SAP ABAP Table MCPOSCAS (External Cash Register: Cashier Data (SAP BW Extractor))

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ BC-BW (Application Component) BW Service API
     ⤷ MCPOSBW (Package) Retail POS Extractors for SAP BW, Non-Release-Specific

Basic Data

Table Category	INTTAB	Structure
Structure	MCPOSCAS	Table Relationship Diagram
Short Description	External Cash Register: Cashier Data (SAP BW Extractor)

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCPOSCAS	MANDT	T000	MANDT
2	MCPOSCAS	STORE	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in