S119 - Transaction Number (Till Receipt)
Transaction Number (Till Receipt) information is stored in SAP table S119.
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
Fields for table S119
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 3 | T000 |
SPTAG | Period to analyze - current date | X | SPTAG | DATS | 8 | |
BONNR | Transaction number (till receipt) | X | W_BONNR | NUMC | 15 | |
WERKS | Plant | X | WERKS_D | CHAR | 4 | T001W |
AFLAG | Promotion indicator | X | MCW_AFLAG | NUMC | 1 | |
KALWOC | Calendar week | X | MCW_KALWOC | NUMC | 2 | |
WOCHTG | Weekday | X | MCW_WOCHTG | NUMC | 1 | |
TGZTKL | Time of day class | X | MCW_TGZTKL | CHAR | 4 | TMCWW |
VKSTD | Hour of sale | X | W_VKSTD | NUMC | 2 | |
VRSIO | Version number in the information structure | X | VRSIO | CHAR | 3 | * |
SPMON | Period to analyze - month | X | SPMON | NUMC | 6 | |
SPWOC | Period to analyze - week | X | SPWOC | NUMC | 6 | |
SPBUP | Period to analyze - posting period | X | SPBUP | NUMC | 6 | |
SSOUR | Statistic(s) origin | X | SSOUR | CHAR | 4 | |
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | * | |
VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | ||
BASME | Base Unit of Measure | MEINS | UNIT | 3 | T006 | |
VRKME | Sales unit | VRKME | UNIT | 3 | T006 | |
WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | |
KUNDK | Customer ID | W_KUNDK | CHAR | 1 | ||
KUNNR | Customer number | KUND1 | CHAR | 10 | KNA1 | |
CCNUM | Payment cards: Card number | CCNUM | CHAR | 25 | * | |
UMSMNG | Transaction sales - quantity in base unit of measure | W_UMSMNG | QUAN | 8 | ||
VKMNG | Transaction sales - quantity in sales unit | W_VKMNG | QUAN | 8 | ||
UMSATZ | Sales POS | MCW_UMSATZ | CURR | 10 | ||
WERTUM | Sales value POS (exact value) | MCW_WERTUM | CURR | 10 | ||
ANZBON | Number of transactions (till receipts) | MCW_ANZBON | INT4 | 4 | ||
ANZPOS | Number of transaction items (till receipts) | MCW_ANZPOS | INT4 | 4 | ||
ANZWGR | Number of material groups in transaction (till receipt) | MCW_ANZWGR | INT4 | 4 | ||
PRSNLS | Price reduction from sales as per receipts/aggregated sales | W_PRSNLS | CURR | 10 | ||
ANZAAR | Number of promotion items | MCW_ANZAAR | INT4 | 4 | ||
ANZBKK | Number of known customers | MCW_ANZBKK | INT4 | 4 | ||
ANZAKM | Number of anonymous customers (with payment card) | MCW_ANZAKM | INT4 | 4 | ||
ANZAKO | Number of anonymous customers | MCW_ANZAKO | INT4 | 4 | ||
UHZEIT | Time sale was entered | MCW_UHZEIT | TIMS | 6 | ||
KMONAT | Calendar month | MCW_MONAT | NUMC | 2 | ||
QUARTAL | Quarter | MCW_QUARTL | NUMC | 1 | ||
JAHR | Year | MCJAHR | NUMC | 4 |