SAP ABAP Table MC43RK1CAS (Extraction Retail BW: POS Cashier Data)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ LO-LIS (Application Component) Logistics Information System (LIS)
⤷ MCEX (Package) Extraction Interface LIS-BW
⤷ LO-LIS (Application Component) Logistics Information System (LIS)
⤷ MCEX (Package) Extraction Interface LIS-BW
Basic Data
Table Category | INTTAB | Structure |
Structure | MC43RK1CAS | Table Relationship Diagram |
Short Description | Extraction Retail BW: POS Cashier Data |
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 | ASCAR | FILIALE | KUNNR | CHAR | 10 | 0 | Assortment owner | * | |
2 | BNKBVOL | W_BNKUMS | WERTV10 | CURR | 19 | 2 | Bank business volume | ||
3 | CMPCODE | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
4 | CONDTYI | W_KKENN | W_KKENN | CHAR | 1 | 0 | Condition type identification | ||
5 | CONDTYS | V_KSCHA | KSCHL | CHAR | 4 | 0 | Condition type, sales | * | |
6 | CONTTAX | C_CONTTAX | W_CONTTAX | CHAR | 1 | 0 | Flag: Tax Included in Sale (Cashier) | ||
7 | CSHRNM | W_KASNAM | CHAR35 | CHAR | 35 | 0 | Cashier name | ||
8 | CSHRNO | W_KBDNR | PERNR | NUMC | 8 | 0 | Cashier number | ||
9 | EXCHANG | KURSK | KURRF | DEC | 9 | 5 | Exchange Rate for Pricing and Statistics | ||
10 | LOCCUR | HWAER | WAERS | CUKY | 5 | 0 | Local Currency | * | |
11 | LOGTIM | W_AMDZT | DEC17_5 | DEC | 17 | 5 | Logon time | ||
12 | MOPAAM | W_KBIST | WERTV10 | CURR | 19 | 2 | Means of payment actual amount | ||
13 | MOPTAM | W_KBSOL | WERTV10 | CURR | 19 | 2 | Means of payment target amount | ||
14 | NOCHOL | W_AZSUL | BCSP4 | DEC | 7 | 0 | Number of checks over limit | ||
15 | NOCON | C_ANZCOND | BCSP6 | DEC | 11 | 0 | Number of conditions based on cashier statistics | ||
16 | NOCSHREM | W_AZABS | BCSP4 | DEC | 7 | 0 | Number of times till has been emptied (cash removals) | ||
17 | NOCTRA | W_AZBST | BCSP4 | DEC | 7 | 0 | Number of canceled transactions (till receipts) | ||
18 | NOFLOGAT | W_AZFAV | BCSP4 | DEC | 7 | 0 | Number of failed logon attempts | ||
19 | NOICANC | W_AZSST | BCSP4 | DEC | 7 | 0 | Number of immediate cancellations | ||
20 | NOLCANC | W_AZZST | BCSP4 | DEC | 7 | 0 | Number of line cancelations | ||
21 | NOMGRSAL | W_AZWGV | BCSP4 | DEC | 7 | 0 | Number of material group sales | ||
22 | NOPOS | C_ANZPOS | BCSP6 | DEC | 11 | 0 | Number of items based on cashier statistics | ||
23 | NOREC | C_ANZBON | BCSP6 | DEC | 11 | 0 | Number of transactions based on cashier statistics | ||
24 | NOREP | W_AZBRT | BCSP4 | DEC | 7 | 0 | Number of reports | ||
25 | NOSCANA | W_AZSCA | BCSP4 | DEC | 7 | 0 | Number of materials scanned | ||
26 | NOTDRWOP | W_AZKSB | BCSP4 | DEC | 7 | 0 | Number of times till drawer was opened | ||
27 | NOTERM | W_AZABB | BCSP4 | DEC | 7 | 0 | Number of terminations | ||
28 | POSCTR | W_KSKRS | W_KSKRS | NUMC | 5 | 0 | POS controller | ||
29 | POSCUR | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | * | |
30 | POSDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
31 | POSNO | W_KASNR | KASNR | NUMC | 10 | 0 | POS number | ||
32 | POSPAYM | POSZAHLART | CHAR4 | CHAR | 4 | 0 | Payment method at POS system | ||
33 | POSTIM | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
34 | REGTIM | W_REGZT | DEC17_5 | DEC | 17 | 5 | Register time | ||
35 | SALCPR | C_PDIFF | WERTV10 | CURR | 19 | 2 | Cashier: price difference between R/3 -> and POS rtl price | ||
36 | SALES | C_UMSATZ | WERTV10 | CURR | 19 | 2 | Sales (Cashier) | ||
37 | SALGRP | VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | * | |
38 | SALPRR | C_PRSNLS | WERTV10 | CURR | 19 | 2 | Price reduction based on cashier statistics | ||
39 | SALTAX | C_UMSTAX | WERTV10 | CURR | 19 | 2 | Amount of Sales Tax (Cashier) | ||
40 | STORE | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
41 | TATYPE | POSUVORG | POSUVORG | CHAR | 4 | 0 | Transact. type | * | |
42 | TAXCODE | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
43 | TDIFFM | W_KDNEG | WERTV10 | CURR | 19 | 2 | Negative till difference | ||
44 | TDIFFP | W_KDPOS | WERTV10 | CURR | 19 | 2 | Positive till difference | ||
45 | VALCHOL | W_WRSUL | WERTV10 | CURR | 19 | 2 | Value of checks over the limit | ||
46 | VALCSHREM | W_UMABS | WERTV10 | CURR | 19 | 2 | Cash removed | ||
47 | VALCTRA | W_WRBST | WERTV10 | CURR | 19 | 2 | Value of canceled transactions (till receipts) | ||
48 | VALICANC | W_WRSST | WERTV10 | CURR | 19 | 2 | Value of immediate cancellations | ||
49 | VALLCANC | W_WRZST | WERTV10 | CURR | 19 | 2 | Value of cancelled lines | ||
50 | VALMGRSAL | W_WRWGV | WERTV10 | CURR | 19 | 2 | Value of material group sales | ||
51 | VALSCANA | W_WRSCA | WERTV10 | CURR | 19 | 2 | Value of scanned material | ||
52 | VALTERM | W_WRABB | WERTV10 | CURR | 19 | 2 | Value of terminations | ||
53 | WEEKDAY | MCW_WOCHTG | DAYS17 | NUMC | 1 | 0 | Weekday |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |