/POSDW/RETTY SAP table for – Category for Sales Items

Here we would like to draw your attention to /POSDW/RETTY table in SAP. As we know it is being mainly used with the SAP BW-BCT (Business Content and Extractors in BW) component which is coming under BW module (Business Warehouse). /POSDW/RETTY is a SAP standard transp table used for storing Category for Sales Items related data in SAP. It comes under the package /POSDW/DATABASE.

SAP /POSDW/RETTY table

Table /POSDW/RETTY technical data

Table/POSDW/RETTY
Data storingCategory for Sales Items
ModuleBW
Sub ModuleBW-BCT-ISR-PIP
SAP Package/POSDW/DATABASE
Delivery ClassE – System table whose data is transported with its own transport objects
ComponentBI_CONT
Table CategoryTRANSP

SAP /POSDW/RETTY Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in /POSDW/RETTY table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PROFILETYPE : Customizing Profile Type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • RETAILTYPECODE : Sales Item Type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • RETAILTYPEGROUP : Sales Item Type Group
    Its data type is CHAR (Character String) with field length 4
  • DEBITFLAG : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • INCLEXCLTASK : Flag if Procedure Is Relevant for Task Group
    Its data type is CHAR (Character String) with field length 1
  • TASKGROUP : Include/Exclude Task Group
    Its data type is CHAR (Character String) with field length 4
  • EXCLHEADERDISC : Remove Item from the Distribution of Header Discounts
    Its data type is CHAR (Character String) with field length 1
  • EXCLHEADERTAX : Remove Item from Distribution of Header Taxes
    Its data type is CHAR (Character String) with field length 1
  • EXCLTENDER : Remove Item from Distribution of Tender
    Its data type is CHAR (Character String) with field length 1
  • FRETYPECODE : Type Code for Forecasting & Replenishment
    Its data type is CHAR (Character String) with field length 4
  • ITEM_CAT : Classification of Sales Item: Category
    Its data type is CHAR (Character String) with field length 1
  • ITEM_SCAT : Classification of Sales Item: Subcategory
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Grouping Key for Summarization
  • AGGR_K1 : Grouping Key 1 for Summarization
    Its data type is CHAR (Character String) with field length 2
  • AGGR_K2 : Grouping Key 2 for Summarization
    Its data type is CHAR (Character String) with field length 2
  • AGGR_K3 : Grouping Key 3 for Summarization
    Its data type is CHAR (Character String) with field length 2
  • INCLEXCLTASK_TOT : Controls if Process for Task Group Relev. for Totals Record
    Its data type is CHAR (Character String) with field length 1
  • TASKGROUP_TOT : Task Group Incl./Excl. for Totals Records
    Its data type is CHAR (Character String) with field length 4