SAP ABAP Table /POSDW/RETAILTOTALS_FI (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
⤷ 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_FI | 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 | Total Sales - Database Fields | |||||
2 | .INCLUDE | 0 | 0 | Sales Totals - Database Fields (Key Fields) | |||||
3 | RETAILTYPECODE | /POSDW/RETAILTYPECODE | /POSDW/RETAILTYPECODE | CHAR | 4 | 0 | Sales Item Type | * | |
4 | SALESAMOUNT | /POSDW/SALESTOTAL | /POSDW/CURRENCY | CURR | 15 | 2 | Actual Retail Value Total | ||
5 | LINEITEMCOUNT | /POSDW/LINEITEMCOUNT | /POSDW/COUNT | INT4 | 10 | 0 | Number of Sales Items | ||
6 | .INCLUDE | 0 | 0 | Sales Totals - Enhanced Fields | |||||
7 | RETAILTYPEGROUP | /POSDW/RETAILTYPEGROUP | /POSDW/RETAILTYPEGROUP | CHAR | 4 | 0 | Sales Item Type Group | /POSDW/RETTG | |
8 | RETAILDEBITFLAG | /POSDW/DEBITFLAG | /POSDW/DEBITFLAG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
9 | RETL_ITEM_CAT | /POSDW/RETAIL_ITEM_CATEGORY | /POSDW/ITEM_CATEGORY | CHAR | 1 | 0 | Classification of Sales Item: Category | * | |
10 | RETL_ITEM_SCAT | /POSDW/RETAIL_ITEM_SUBCATEGORY | /POSDW/ITEM_SUBCATEGORY | CHAR | 1 | 0 | Classification of Sales Item: Subcategory | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | /POSDW/RETAILTOTALS_FI | RETAILTYPEGROUP | /POSDW/RETTG | RETAILTYPEGROUP | KEY | 1 | CN |
History
Last changed by/on | SAP | 20100326 |
SAP Release Created in | 30B |