SAP ABAP Table S120 (Sales as per receipts)

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	S120	Table Relationship Diagram
Short Description	Sales as per receipts

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	KSKRS	☑	W_KSKRS	W_KSKRS	NUMC	5	0	POS controller
5	KASNR	☑	W_KASNR	KASNR	NUMC	10	0	POS number
6	BONNR	☑	W_BONNR	W_BONNR	NUMC	15	0	Transaction number (till receipt)
7	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
8	EANNR	☑	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
9	KSCHL	☑	V_KSCHA	KSCHL	CHAR	4	0	Condition type, sales	T685
10	KVORG	☑	POSUVORG	POSUVORG	CHAR	4	0	Transact. type	TWPPB
11	CONDNR	☑	MCW_CONDNR	NUMC6	NUMC	6	0	Consecutive condition number
12	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
13	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
14	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
15	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
16	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
17	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
18	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
19	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
20	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
21	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
22	VKMNG	☐	W_VKMNG	MENGV15_3	QUAN	15	3	Transaction sales - quantity in sales unit
23	UMSMNG	☐	W_UMSMNG	MENGV15_3	QUAN	15	3	Transaction sales - quantity in base unit of measure
24	UMSGVP	☐	W_UMSVPM	WERTV10	CURR	19	2	Retail price w/tax from sales as per receipts/aggreg.sales
25	UMSGVO	☐	W_UMSVPO	WERTV10	CURR	19	2	Rtl price from sales as per receipts/aggreg.sales
26	UMSGEO_01	☐	W_UMSEP	WERTV10	CURR	19	2	Sales transactions (till receipts) at cost
27	PRSNLS	☐	W_PRSNLS	WERTV10	CURR	19	2	Price reduction from sales as per receipts/aggregated sales
28	PDIFF	☐	W_PDIFF	WERTV10	CURR	19	2	Trnsctn price diff. between R/3 -> and sales price at POS
29	AZBON	☐	W_AZBON	BCSP6	DEC	11	0	Number of transactions from sales as per till receipts
30	BONPOS	☐	W_BONPOS	DEC9_3	DEC	12	3	No. of material items per transaction (till receipt)
31	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
32	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
33	VKSTD	☐	W_VKSTD	W_VKSTD	NUMC	2	0	Hour of sale
34	ZMTTL	☐	W_ZAHLART	KSCHL	CHAR	4	0	Payment method as condition	T685
35	KUNNR	☐	KUND1	KUNNR	CHAR	10	0	Customer No.	KNA1
36	KTONR	☐	BANKN	BANKN	CHAR	18	0	Bank account number
37	BNKLZ	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
38	CCINS	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	TVCIN
39	CCNUM	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	VCNUM
40	KRFNR	☐	POSKARFNR	CHAR15	CHAR	15	0	Card Sequence Number
41	BZIRK	☐	W_BEZIRK	BZIRK	CHAR	6	0	Sales district	T171
42	EZEIT	☐	ERZET	UZEIT	TIMS	6	0	Entry time
43	KASNAM	☐	W_KASNAM	CHAR35	CHAR	35	0	Cashier name
44	KKENN	☐	W_KKENN	W_KKENN	CHAR	1	0	Condition type identification
45	ZMUMS	☐	W_ZMUMS	WERTV10	CURR	19	2	Means of payment sales from sales as per receipts/aggr.sales
46	SERNR	☐	W_SERNR	CHAR25	CHAR	25	0	BOM Explosion Number
47	KUNDK	☐	W_KUNDK	W_KUNDK	CHAR	1	0	Customer ID
48	ANZCOND	☐	W_ANZCOND	BCSP6	DEC	11	0	Number of conditions from sales as per receipt/aggregated
49	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
50	VKFNR	☐	W_VKFNR	PERNR	NUMC	8	0	Salesperson number
51	PRVBT	☐	W_PRVBT	WERTV10	CURR	19	2	Commission amount, sales
52	UMART	☐	W_UMART	CHAR1	CHAR	1	0	Sales type (sales/returns/empties)
53	DUMMY1	☐	W_DUMMY1	CHAR6	CHAR	6	0	Dummy element 1 POS (10 characters)
54	DUMMY2	☐	W_DUMMY2	CHAR4	CHAR	4	0	Dummy element 2 POS (10 characters)
55	DUMMY3	☐	W_DUMMY3	CHAR4	CHAR	4	0	Dummy element 3 POS (10 characters)
56	DUMMY4	☐	W_DUMMY4	CHAR10	CHAR	10	0	Dummy element 4 POS (10 characters)
57	DUMMY5	☐	W_DUMMY5	CHAR10	CHAR	10	0	Dummy element 5 POS (10 characters)
58	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
59	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
60	KBDNR	☐	W_KBDNR	PERNR	NUMC	8	0	Cashier number
61	CONDID	☐	W_CONDID	CHAR20	CHAR	20	0	Condition Type Identification
62	PAYDIR	☐	W_PAYDIR	W_PAYDIR	CHAR	1	0	Direction of payment type (outbound/inbound)
63	UMSGVC	☐	W_UMSVPC	WERTV10	CURR	19	2	Retail price from sales without manufacturer's coupons
64	BBYNR	☐	BBYNR	BBYNR	CHAR	12	0	Bonus buy	KONBBYH

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S120	AKTNR	WAKH	AKTNR
2	S120	BASME	T006	MSEHI
3	S120	BBYNR	KONBBYH	BBYNR
4	S120	BZIRK	T171	BZIRK		1	CN
5	S120	CCINS	TVCIN	CCINS
6	S120	CCNUM	VCNUM	CCNUM
7	S120	KSCHL	T685	KSCHL	KEY	C	1
8	S120	KUNNR	KNA1	KUNNR
9	S120	KVORG	TWPPB	UVORG	KEY
10	S120	MANDT	T000	MANDT	KEY
11	S120	MATKL	T023	MATKL
12	S120	MATNR	MARA	MATNR	KEY
13	S120	VKGRP	TVKGR	VKGRP		C	1
14	S120	VKORG	TVKO	VKORG
15	S120	VRKME	T006	MSEHI
16	S120	VTWEG	TVTW	VTWEG
17	S120	WAERK	TCURC	WAERS
18	S120	WERKS	T001W	WERKS	KEY
19	S120	ZMTTL	T685	KSCHL

History

Last changed by/on	SAP	20130529
SAP Release Created in