SAP ABAP Table /POSDW/DMF_AGGR_REC_SALES (POS aggregate "Sales for DMF": single record "Sales")
Hierarchy
☛
BI_CONT (Software Component) Business Intelligence Content
⤷
BW-BCT-ISR-PIP (Application Component) Point of Sales Inbound Processing Engine
⤷
/POSDW/OUTPUT_CONVERSION_EN (Package) PIPE tasks and output conversion - language EN
BI_CONT (Software Component) Business Intelligence Content⤷
BW-BCT-ISR-PIP (Application Component) Point of Sales Inbound Processing Engine⤷
/POSDW/OUTPUT_CONVERSION_EN (Package) PIPE tasks and output conversion - language EN
Basic Data
| Table Category | INTTAB | Structure |
| Structure | /POSDW/DMF_AGGR_REC_SALES |
Table Relationship Diagram 
|
| Short Description | POS aggregate "Sales for DMF": single record "Sales" |
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 | POS aggregate "Sales for DMF": Section "Sales" | |||||
| 2 | MANDT |
MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
| 3 | .INCLUDE |
0 | 0 | Key of Aggregate Record in Lower-Level Table | |||||
| 4 | AGGR_NO |
/POSDW/AGGREGATE_NUMBER | /POSDW/AGGREGATE_NUMBER | INT4 | 10 | 0 | POS Aggregate Number | * | |
| 5 | REC_ID |
/POSDW/AGGR_UNIQUE_RECID | INT4 | INT4 | 10 | 0 | Record Number Assigned Uniquely at Aggregate Level | ||
| 6 | .INCLUDE |
0 | 0 | Key for aggregate "Daily sales per store, product, offer" | |||||
| 7 | MATERIALNUMBER |
/POSDW/MATERIALNUMBER | MATNR | CHAR | 18 | 0 | Material Number | ||
| 8 | OFFERID |
/POSDW/OFFERID | /POSDW/OFFERID | CHAR | 36 | 0 | Offer ID | ||
| 9 | .INCLUDE |
0 | 0 | Data fields aggr. "Daily sales per store, product, offer" | |||||
| 10 | BASEUOM |
/POSDW/BASEUNITOFMEASURE | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
| 11 | BASEQUANTITY |
/POSDW/BASEQUANTITY | /POSDW/QUANTITY | QUAN | 13 | 3 | Quantity in Base Unit of Measure | ||
| 12 | GROSSSALESAMOUNT |
/POSDW/GROSSSALESAMOUNT | /POSDW/CURRENCY | CURR | 15 | 2 | Gross Sales (Including All Taxes) | ||
| 13 | NETSALESAMOUNT |
/POSDW/NETSALESAMOUNT | /POSDW/CURRENCY | CURR | 15 | 2 | Net Sales (Without Taxes) | ||
| 14 | TRANSACTIONCOUNT |
/POSDW/TRANSACTIONCOUNT | /POSDW/COUNT | INT4 | 10 | 0 | Number of Transactions | ||
| 15 | SQUAREDBASEQTY |
/POSDW/SQUAREDBASEQUANTITY | FLTP | 16 | 16 | Sales in Base UOM ^2 (per transaction) | |||
| 16 | CUBEDBASEQTY |
/POSDW/CUBICBASEQUANTITY | FLTP | 16 | 16 | Sales in Base UOM ^3 (per transaction) |
History
| Last changed by/on | SAP | 20100820 |
| SAP Release Created in | 704 |
