SAP ABAP Table /POSDW/RETAILTOTALS (Sales Totals)
Hierarchy
☛
BI_CONT (Software Component) Business Intelligence Content
⤷
BW-BCT-ISR-PIP (Application Component) Point of Sales Inbound Processing Engine
⤷
/POSDW/CORE (Package) PIPE Processing Control
BI_CONT (Software Component) Business Intelligence Content⤷
BW-BCT-ISR-PIP (Application Component) Point of Sales Inbound Processing Engine⤷
/POSDW/CORE (Package) PIPE Processing Control
Basic Data
| Table Category | INTTAB | Structure |
| Structure | /POSDW/RETAILTOTALS |
Table Relationship Diagram 
|
| Short Description | Sales Totals |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  .INCLUDE |
0 | 0 | Sales Totals | |||||
| 2 | .INCLUDE |
0 | 0 | Total Sales - Database Fields | |||||
| 3 | .INCLUDE |
0 | 0 | Sales Totals - Database Fields (Key Fields) | |||||
| 4 | RETAILTYPECODE |
/POSDW/RETAILTYPECODE | /POSDW/RETAILTYPECODE | CHAR | 4 | 0 | Sales Item Type | /POSDW/RETTY | |
| 5 | SALESAMOUNT |
/POSDW/SALESTOTAL | /POSDW/CURRENCY | CURR | 15 | 2 | Actual Retail Value Total | ||
| 6 | LINEITEMCOUNT |
/POSDW/LINEITEMCOUNT | /POSDW/COUNT | INT4 | 10 | 0 | Number of Sales Items | ||
| 7 | .INCLUDE |
0 | 0 | Sales Totals - Enhanced Fields | |||||
| 8 | RETAILTYPEGROUP |
/POSDW/RETAILTYPEGROUP | /POSDW/RETAILTYPEGROUP | CHAR | 4 | 0 | Sales Item Type Group | /POSDW/RETTG | |
| 9 | RETAILDEBITFLAG |
/POSDW/DEBITFLAG | /POSDW/DEBITFLAG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
| 10 | RETL_ITEM_CAT |
/POSDW/RETAIL_ITEM_CATEGORY | /POSDW/ITEM_CATEGORY | CHAR | 1 | 0 | Classification of Sales Item: Category | * | |
| 11 | RETL_ITEM_SCAT |
/POSDW/RETAIL_ITEM_SUBCATEGORY | /POSDW/ITEM_SUBCATEGORY | CHAR | 1 | 0 | Classification of Sales Item: Subcategory | * | |
| 12 | .INCLUDE |
0 | 0 | User Interface Data | |||||
| 13 | .INCLUDE |
0 | 0 | Additional Information at Segment Level | |||||
| 14 | NAV_ITEM_QUAL |
/POSDW/NAV_ITEM_QUAL | INT4 | INT4 | 10 | 0 | Item Qualifier for Navigation in Raw Editor | ||
| 15 | MESSAGE |
/POSDW/TT_NAVI_MESSAGE | TTYP | 0 | 0 |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | /POSDW/RETAILTOTALS | RETAILTYPECODE |  /POSDW/RETTY |
RETAILTYPECODE |
KEY | 1 | CN |
| 2 | /POSDW/RETAILTOTALS | RETAILTYPEGROUP | /POSDW/RETTG |
RETAILTYPEGROUP |
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20100326 |
| SAP Release Created in | 30B |
