SAP ABAP Table /POSDW/V_RETTY (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure /POSDW/V_RETTY   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 DESCRIPTION /POSDW/DESCRIPTION /POSDW/DESCRIPTION CHAR 50   0   Description  
5 RETAILTYPEGROUP /POSDW/RETAILTYPEGROUP /POSDW/RETAILTYPEGROUP CHAR 4   0   Sales Item Type Group /POSDW/RETTG
6 DEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
7 INCLEXCLTASK /POSDW/INCLEXCLTASK /POSDW/INCLEXCLTASK CHAR 1   0   Flag if Procedure Is Relevant for Task Group  
8 TASKGROUP /POSDW/INCLEXCLTASKGROUP /POSDW/TASKGROUP CHAR 4   0   Include/Exclude Task Group /POSDW/TASKG
9 EXCLHEADERDISC /POSDW/EXCLUDEHEADERDISCOUNT XFELD CHAR 1   0   Remove Item from the Distribution of Header Discounts  
10 EXCLHEADERTAX /POSDW/EXCLUDEHEADERTAX XFELD CHAR 1   0   Remove Item from Distribution of Header Taxes  
11 EXCLTENDER /POSDW/EXCLUDEHEADERTENDER XFELD CHAR 1   0   Remove Item from Distribution of Tender  
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 AGGR_K1 /POSDW/AGGR_GROUPING_KEY1 /POSDW/AGGR_GROUPING_KEY CHAR 2   0   Grouping Key 1 for Summarization  
15 AGGR_K2 /POSDW/AGGR_GROUPING_KEY2 /POSDW/AGGR_GROUPING_KEY CHAR 2   0   Grouping Key 2 for Summarization  
16 AGGR_K3 /POSDW/AGGR_GROUPING_KEY3 /POSDW/AGGR_GROUPING_KEY CHAR 2   0   Grouping Key 3 for Summarization  
17 INCLEXCLTASK_TOT /POSDW/INCLEXCLTASK_TOT /POSDW/INCLEXCLTASK CHAR 1   0   Controls if Process for Task Group Relev. for Totals Record  
18 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/V_RETTY ITEM_CAT /POSDW/ITMC ITEM_CAT KEY 1 CN
2 /POSDW/V_RETTY ITEM_SCAT /POSDW/ITMS ITEM_SCAT KEY 1 CN
3 /POSDW/V_RETTY PROFILETYPE /POSDW/PROF PROFILETYPE KEY 1 CN
4 /POSDW/V_RETTY RETAILTYPEGROUP /POSDW/RETTG RETAILTYPEGROUP REF 1 CN
5 /POSDW/V_RETTY TASKGROUP /POSDW/TASKG TASKGROUP REF 1 CN
6 /POSDW/V_RETTY TASKGROUP_TOT /POSDW/TASKG TASKGROUP REF 1 CN
History
Last changed by/on SAP  20100326 
SAP Release Created in