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