SAP ABAP Table MCCSHR (Cash external: Cashier data (only LIS))

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-RIS (Application Component) Retail Information System (RIS)
     ⤷ MCW (Package) R/3 application development: Retail Information System

Basic Data

Table Category	INTTAB	Structure
Structure	MCCSHR	Table Relationship Diagram
Short Description	Cash external: Cashier data (only LIS)

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	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
3	KSKRS	☐	W_KSKRS	W_KSKRS	NUMC	5	0	POS controller
4	KASNR	☐	W_KASNR	KASNR	NUMC	10	0	POS number
5	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
6	EZEIT	☐	ERZET	UZEIT	TIMS	6	0	Entry time
7	KBDNR	☐	W_KBDNR	PERNR	NUMC	8	0	Cashier number
8	ZMTTL	☐	POSZAHLART	CHAR4	CHAR	4	0	Payment method at POS system
9	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
10	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
11	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
12	SUPKZ	☐	SUPKZ	SUPKZ	CHAR	1	0	Statistics update indicator (post in/post out)
13	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
14	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
15	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
16	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
17	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
18	BZIRK	☐	W_BEZIRK	BZIRK	CHAR	6	0	Sales district	T171
19	FILNR	☐	FILIALE	KUNNR	CHAR	10	0	Assortment owner	KNA1
20	KKENN	☐	W_KKENN	W_KKENN	CHAR	1	0	Condition type identification
21	KASNAM	☐	W_KASNAM	CHAR35	CHAR	35	0	Cashier name
22	AZABS	☐	W_AZABS	BCSP4	DEC	7	0	Number of times till has been emptied (cash removals)
23	UMABS	☐	W_UMABS	WERTV10	CURR	19	2	Cash removed
24	KBSOL	☐	W_KBSOL	WERTV10	CURR	19	2	Means of payment target amount
25	KBIST	☐	W_KBIST	WERTV10	CURR	19	2	Means of payment actual amount
26	KDPOS	☐	W_KDPOS	WERTV10	CURR	19	2	Positive till difference
27	KDNEG	☐	W_KDNEG	WERTV10	CURR	19	2	Negative till difference
28	AZSUL	☐	W_AZSUL	BCSP4	DEC	7	0	Number of checks over limit
29	WRSUL	☐	W_WRSUL	WERTV10	CURR	19	2	Value of checks over the limit
30	AZSST	☐	W_AZSST	BCSP4	DEC	7	0	Number of immediate cancellations
31	WRSST	☐	W_WRSST	WERTV10	CURR	19	2	Value of immediate cancellations
32	AZZST	☐	W_AZZST	BCSP4	DEC	7	0	Number of line cancelations
33	WRZST	☐	W_WRZST	WERTV10	CURR	19	2	Value of cancelled lines
34	AZBST	☐	W_AZBST	BCSP4	DEC	7	0	Number of canceled transactions (till receipts)
35	WRBST	☐	W_WRBST	WERTV10	CURR	19	2	Value of canceled transactions (till receipts)
36	AZABB	☐	W_AZABB	BCSP4	DEC	7	0	Number of terminations
37	WRABB	☐	W_WRABB	WERTV10	CURR	19	2	Value of terminations
38	AMDZT	☐	W_AMDZT	DEC17_5	DEC	17	5	Logon time
39	REGZT	☐	W_REGZT	DEC17_5	DEC	17	5	Register time
40	AZBRT	☐	W_AZBRT	BCSP4	DEC	7	0	Number of reports
41	WRUMS	☐	C_UMSVPM	WERTV10	CURR	19	2	Retail price with tax from cashier statistics
42	WRSCA	☐	W_WRSCA	WERTV10	CURR	19	2	Value of scanned material
43	AZSCA	☐	W_AZSCA	BCSP4	DEC	7	0	Number of materials scanned
44	WRWGV	☐	W_WRWGV	WERTV10	CURR	19	2	Value of material group sales
45	AZWGV	☐	W_AZWGV	BCSP4	DEC	7	0	Number of material group sales
46	AZKSB	☐	W_AZKSB	BCSP4	DEC	7	0	Number of times till drawer was opened
47	AZFAV	☐	W_AZFAV	BCSP4	DEC	7	0	Number of failed logon attempts
48	AZBON	☐	C_ANZBON	BCSP6	DEC	11	0	Number of transactions based on cashier statistics
49	KSCHL	☐	V_KSCHA	KSCHL	CHAR	4	0	Condition type, sales	*
50	KVORG	☐	POSUVORG	POSUVORG	CHAR	4	0	Transact. type	*
51	AZPOS	☐	C_ANZPOS	BCSP6	DEC	11	0	Number of items based on cashier statistics
52	ANZCOND	☐	C_ANZCOND	BCSP6	DEC	11	0	Number of conditions based on cashier statistics
53	PRSNLS	☐	C_PRSNLS	WERTV10	CURR	19	2	Price reduction based on cashier statistics
54	PDIFF	☐	C_PDIFF	WERTV10	CURR	19	2	Cashier: price difference between R/3 -> and POS rtl price
55	UMSGVO	☐	C_UMSVPO	WERTV10	CURR	19	2	Retail price without tax from cashier statistics
56	BNKUMS	☐	W_BNKUMS	WERTV10	CURR	19	2	Bank business volume
57	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
58	.INCLUDE	☐				0	0	User portion: Cashier data, external cash interface (LIS)
59	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	MCCSHR	BUKRS	T001	BUKRS
2	MCCSHR	BZIRK	T171	BZIRK		1	CN
3	MCCSHR	FILNR	KNA1	KUNNR	KEY	1	1
4	MCCSHR	HWAER	TCURC	WAERS
5	MCCSHR	MANDT	T000	MANDT
6	MCCSHR	MEINS	T006	MSEHI
7	MCCSHR	VKGRP	TVKGR	VKGRP
8	MCCSHR	VKORG	TVKO	VKORG
9	MCCSHR	VTWEG	TVTW	VTWEG
10	MCCSHR	WAERK	TCURC	WAERS
11	MCCSHR	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in