SAP ABAP Table /POSDW/RETTY (Category for Sales Items)
Hierarchy
☛ BI_CONT (Software Component) Business Intelligence Content
   ⤷ BW-BCT-ISR-PIP (Application Component) Point of Sales Inbound Processing Engine
     ⤷ /POSDW/DATABASE (Package) PIPE Database
Basic Data
Table Category TRANSP    Transparent table 
Transparent table /POSDW/RETTY   Table Relationship Diagram
Short Description Category for Sales Items    
Delivery and Maintenance
Pool/cluster      
Delivery Class E   Control table, SAP and customer have separate key areas 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client *
2 PROFILETYPE /POSDW/PROFILETYPE /POSDW/PROFILETYPE CHAR 4   0   Customizing Profile Type /POSDW/PROF
3 RETAILTYPECODE /POSDW/RETAILTYPECODE /POSDW/RETAILTYPECODE CHAR 4   0   Sales Item Type  
4 RETAILTYPEGROUP /POSDW/RETAILTYPEGROUP /POSDW/RETAILTYPEGROUP CHAR 4   0   Sales Item Type Group /POSDW/RETTG
5 DEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
6 INCLEXCLTASK /POSDW/INCLEXCLTASK /POSDW/INCLEXCLTASK CHAR 1   0   Flag if Procedure Is Relevant for Task Group  
7 TASKGROUP /POSDW/INCLEXCLTASKGROUP /POSDW/TASKGROUP CHAR 4   0   Include/Exclude Task Group /POSDW/TASKG
8 EXCLHEADERDISC /POSDW/EXCLUDEHEADERDISCOUNT XFELD CHAR 1   0   Remove Item from the Distribution of Header Discounts  
9 EXCLHEADERTAX /POSDW/EXCLUDEHEADERTAX XFELD CHAR 1   0   Remove Item from Distribution of Header Taxes  
10 EXCLTENDER /POSDW/EXCLUDEHEADERTENDER XFELD CHAR 1   0   Remove Item from Distribution of Tender  
11 FRETYPECODE /POSDW/FRETYPECODE   CHAR 4   0   Type Code for Forecasting & Replenishment  
12 ITEM_CAT /POSDW/RETAIL_ITEM_CATEGORY /POSDW/ITEM_CATEGORY CHAR 1   0   Classification of Sales Item: Category /POSDW/ITMC
13 ITEM_SCAT /POSDW/RETAIL_ITEM_SUBCATEGORY /POSDW/ITEM_SUBCATEGORY CHAR 1   0   Classification of Sales Item: Subcategory /POSDW/ITMS
14 .INCLUDE       0   0   Grouping Key for Summarization  
15 AGGR_K1 /POSDW/AGGR_GROUPING_KEY1 /POSDW/AGGR_GROUPING_KEY CHAR 2   0   Grouping Key 1 for Summarization  
16 AGGR_K2 /POSDW/AGGR_GROUPING_KEY2 /POSDW/AGGR_GROUPING_KEY CHAR 2   0   Grouping Key 2 for Summarization  
17 AGGR_K3 /POSDW/AGGR_GROUPING_KEY3 /POSDW/AGGR_GROUPING_KEY CHAR 2   0   Grouping Key 3 for Summarization  
18 INCLEXCLTASK_TOT /POSDW/INCLEXCLTASK_TOT /POSDW/INCLEXCLTASK CHAR 1   0   Controls if Process for Task Group Relev. for Totals Record  
19 TASKGROUP_TOT /POSDW/INCLEXCLTASKGROUP_TOT /POSDW/TASKGROUP CHAR 4   0   Task Group Incl./Excl. for Totals Records /POSDW/TASKG
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /POSDW/RETTY ITEM_CAT /POSDW/ITMC ITEM_CAT KEY 1 CN
2 /POSDW/RETTY ITEM_SCAT /POSDW/ITMS ITEM_SCAT KEY 1 CN
3 /POSDW/RETTY PROFILETYPE /POSDW/PROF PROFILETYPE KEY 1 CN
4 /POSDW/RETTY RETAILTYPEGROUP /POSDW/RETTG RETAILTYPEGROUP REF 1 CN
5 /POSDW/RETTY TASKGROUP /POSDW/TASKG TASKGROUP REF 1 CN
6 /POSDW/RETTY TASKGROUP_TOT /POSDW/TASKG TASKGROUP REF 1 CN
History
Last changed by/on SAP  20100326 
SAP Release Created in 320