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

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