SAP ABAP Table S122 (Cashier)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S122	Table Relationship Diagram
Short Description	Cashier

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
3	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
4	KBDNR	☑	W_KBDNR	PERNR	NUMC	8	0	Cashier number
5	KASNR	☑	W_KASNR	KASNR	NUMC	10	0	POS number
6	KSKRS	☑	W_KSKRS	W_KSKRS	NUMC	5	0	POS controller
7	KSCHL	☑	V_KSCHA	KSCHL	CHAR	4	0	Condition type, sales	T685
8	KVORG	☑	POSUVORG	POSUVORG	CHAR	4	0	Transact. type	TWPPB
9	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
10	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
11	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
12	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
13	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
14	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
15	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
16	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
17	WRUMS	☐	C_UMSVPM	WERTV10	CURR	19	2	Retail price with tax from cashier statistics
18	UMSGVO	☐	C_UMSVPO	WERTV10	CURR	19	2	Retail price without tax from cashier statistics
19	PRSNLS	☐	C_PRSNLS	WERTV10	CURR	19	2	Price reduction based on cashier statistics
20	PDIFF	☐	C_PDIFF	WERTV10	CURR	19	2	Cashier: price difference between R/3 -> and POS rtl price
21	KBSOL	☐	W_KBSOL	WERTV10	CURR	19	2	Means of payment target amount
22	KBIST	☐	W_KBIST	WERTV10	CURR	19	2	Means of payment actual amount
23	KDNEG	☐	W_KDNEG	WERTV10	CURR	19	2	Negative till difference
24	KDPOS	☐	W_KDPOS	WERTV10	CURR	19	2	Positive till difference
25	AZBON	☐	C_ANZBON	BCSP6	DEC	11	0	Number of transactions based on cashier statistics
26	AZPOS	☐	C_ANZPOS	BCSP6	DEC	11	0	Number of items based on cashier statistics
27	AZBST	☐	W_AZBST	BCSP4	DEC	7	0	Number of canceled transactions (till receipts)
28	ANZCOND	☐	C_ANZCOND	BCSP6	DEC	11	0	Number of conditions based on cashier statistics
29	WRBST	☐	W_WRBST	WERTV10	CURR	19	2	Value of canceled transactions (till receipts)
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	AZSCA	☐	W_AZSCA	BCSP4	DEC	7	0	Number of materials scanned
35	AZWGV	☐	W_AZWGV	BCSP4	DEC	7	0	Number of material group sales
36	AZABB	☐	W_AZABB	BCSP4	DEC	7	0	Number of terminations
37	WRABB	☐	W_WRABB	WERTV10	CURR	19	2	Value of terminations
38	AZABS	☐	W_AZABS	BCSP4	DEC	7	0	Number of times till has been emptied (cash removals)
39	UMABS	☐	W_UMABS	WERTV10	CURR	19	2	Cash removed
40	AZSUL	☐	W_AZSUL	BCSP4	DEC	7	0	Number of checks over limit
41	WRSUL	☐	W_WRSUL	WERTV10	CURR	19	2	Value of checks over the limit
42	AMDZT	☐	W_AMDZT	DEC17_5	DEC	17	5	Logon time
43	REGZT	☐	W_REGZT	DEC17_5	DEC	17	5	Register time
44	AZBRT	☐	W_AZBRT	BCSP4	DEC	7	0	Number of reports
45	WRSCA	☐	W_WRSCA	WERTV10	CURR	19	2	Value of scanned material
46	WRWGV	☐	W_WRWGV	WERTV10	CURR	19	2	Value of material group sales
47	AZKSB	☐	W_AZKSB	BCSP4	DEC	7	0	Number of times till drawer was opened
48	AZFAV	☐	W_AZFAV	BCSP4	DEC	7	0	Number of failed logon attempts
49	BNKUMS	☐	W_BNKUMS	WERTV10	CURR	19	2	Bank business volume
50	KASNAM	☐	W_KASNAM	CHAR35	CHAR	35	0	Cashier name
51	KKENN	☐	W_KKENN	W_KKENN	CHAR	1	0	Condition type identification
52	BZIRK	☐	W_BEZIRK	BZIRK	CHAR	6	0	Sales district	T171
53	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
54	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
55	UMSGVP	☐	W_UMSVPM	WERTV10	CURR	19	2	Retail price w/tax from sales as per receipts/aggreg.sales
56	UMSGVO_01	☐	W_UMSVPO	WERTV10	CURR	19	2	Rtl price from sales as per receipts/aggreg.sales
57	PRSNLS_02	☐	W_PRSNLS	WERTV10	CURR	19	2	Price reduction from sales as per receipts/aggregated sales
58	PDIFF_03	☐	W_PDIFF	WERTV10	CURR	19	2	Trnsctn price diff. between R/3 -> and sales price at POS
59	ZMUMS	☐	W_ZMUMS	WERTV10	CURR	19	2	Means of payment sales from sales as per receipts/aggr.sales
60	ANZPOS	☐	W_ANZPOS	BCSP6	DEC	11	0	Number of items from sales as per receipts/aggregated sales
61	AZBON_04	☐	W_AZBON	BCSP6	DEC	11	0	Number of transactions from sales as per till receipts
62	ANZCOND_05	☐	W_ANZCOND	BCSP6	DEC	11	0	Number of conditions from sales as per receipt/aggregated

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S122	BZIRK	T171	BZIRK		1	CN
2	S122	KSCHL	T685	KSCHL	KEY	C	1
3	S122	KVORG	TWPPB	UVORG	KEY
4	S122	MANDT	T000	MANDT	KEY
5	S122	VKORG	TVKO	VKORG
6	S122	VTWEG	TVTW	VTWEG
7	S122	WAERK	TCURC	WAERS
8	S122	WERKS	T001W	WERKS	KEY

History

Last changed by/on	SAP	20050411
SAP Release Created in