SAP ABAP Table S124 (Customer / material)

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	S124	Table Relationship Diagram
Short Description	Customer / material

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	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
9	KUNAG	☑	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
10	WGRU2	☑	MCW_WGRU2	KLASSE	CHAR	18	0	Material group hierarchy 2
11	WGRU1	☑	MCW_WGRU1	KLASSE	CHAR	18	0	Material group hierarchy 1
12	MATKL	☑	MATKL	MATKL	CHAR	9	0	Material Group	T023
13	SAISO	☑	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
14	PLGTP	☑	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
15	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
16	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
17	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
18	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
19	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
20	KAVMNG	☐	MCW_KAVMNG	MENGV15_3	QUAN	15	3	Sales order volume quantity
21	KAVGEO	☐	MCW_KAVGEO	WERTV10	CURR	19	2	Sales order volume at cost
22	KAVGVO	☐	MCW_KAVGVO	WERTV10	CURR	19	2	Sales order volume at retail
23	KAVGVP	☐	MCW_KAVGVP	WERTV10	CURR	19	2	Sales order volume at retail with tax
24	KAVANZ	☐	MCW_KAVANZ	MCZAEHLINT	INT4	10	0	Sales order volume number of transactions
25	RAVMNG	☐	MCW_RAVMNG	MENGV15_3	QUAN	15	3	Return orders quantity
26	RAVGEO	☐	MCW_RAVGEO	WERTV10	CURR	19	2	Return orders at cost
27	RAVGVO	☐	MCW_RAVGVO	WERTV10	CURR	19	2	Return orders at retail
28	RAVGVP	☐	MCW_RAVGVP	WERTV10	CURR	19	2	Return orders at retail with tax
29	RAVANZ	☐	MCW_RAVANZ	MCZAEHLINT	INT4	10	0	Return orders, no. of transactions
30	SAVMNG	☐	MCW_SAVMNG	MENGV15_3	QUAN	15	3	Third-party orders quantity
31	SAVGEO	☐	MCW_SAVGEO	WERTV10	CURR	19	2	Third-party orders at cost
32	SAVGVO	☐	MCW_SAVGVO	WERTV10	CURR	19	2	Third party orders at retail
33	SAVGVP	☐	MCW_SAVGVP	WERTV10	CURR	19	2	Third-party orders at retail with tax
34	SAVANZ	☐	MCW_SAVANZ	MCZAEHLINT	INT4	10	0	Third-party order, no. of transactions
35	LIFMNG	☐	MCW_LIFMNG	MENGV15_3	QUAN	15	3	Deliveries to customers, quantity
36	LIFANZ	☐	MCW_LIFANZ	MCZAEHLINT	INT4	10	0	Deliveries to customers, no. of transactions
37	RLFMNG	☐	MCW_RLFMNG	MENGV15_3	QUAN	15	3	Return deliveries from customer, quantity
38	RLFANZ	☐	MCW_RLFANZ	MCZAEHLINT	INT4	10	0	Return deliveries from customer, no. of transactions
39	OAVMNG	☐	MCW_OAVMNG	MENGV15_3	QUAN	15	3	On-order quantity IS-R
40	OAVWRT	☐	MCW_OAVWRT	WERTV10	CURR	19	2	On-order value IS-R
41	UMAMNG	☐	MCW_UMAMNG	MENGV15_3	QUAN	15	3	Sales (absolute) quantity in BUn
42	UMAGEO	☐	MCW_UMAGEO	WERTV10	CURR	19	2	Sales (absolute) at cost
43	UMAGVO	☐	MCW_UMAGVO	WERTV10	CURR	19	2	Sales (absolute) at retail
44	UMAGVP	☐	MCW_UMAGVP	WERTV10	CURR	19	2	Sales (absolute) at retail with tax
45	PRSNLA	☐	MCW_PRSNLA	WERTV10	CURR	19	2	Sales deviation (absolute) during sales
46	AUMMNG	☐	MCW_AUMMNG	MENGV15_3	QUAN	15	3	Promotion sales quantity in BUn
47	AUMGEO	☐	MCW_AUMGEO	WERTV10	CURR	19	2	Promotion sales at cost
48	AUMGVO	☐	MCW_AUMGVO	WERTV10	CURR	19	2	Promotion sales at retail
49	AUMGVP	☐	MCW_AUMGVP	WERTV10	CURR	19	2	Promotion sales at retail with tax
50	GUTMNG	☐	MCW_GUTMNG	MENGV15_3	QUAN	15	3	Credit memo quantity in BUn
51	GUTGEO	☐	MCW_GUTGEO	WERTV10	CURR	19	2	Credit memo at cost
52	GUTGVO	☐	MCW_GUTGVO	WERTV10	CURR	19	2	Credit memo at retail
53	GUTGVP	☐	MCW_GUTGVP	WERTV10	CURR	19	2	Credit memo at retail with tax
54	GUTNLS	☐	MCW_GUTNLS	WERTV10	CURR	19	2	Credit memo deviation at sale
55	UMSMNG	☐	MCW_SUMMNG	MENGV15_3	QUAN	15	3	Third-party sales quantity in BUn
56	UMSGEO	☐	MCW_SUMGEO	WERTV10	CURR	19	2	Third-party sales at cost
57	UMSGVO	☐	MCW_SUMGVO	WERTV10	CURR	19	2	Third-party sales at retail
58	UMSGVP	☐	MCW_SUMGVP	WERTV10	CURR	19	2	Third-party sales at retail with tax
59	PRSNLS	☐	MCW_SPRSNL	WERTV10	CURR	19	2	Third-party sales deviation
60	KAVMAM	☐	MCW_KAVMAM	PRZ32V	DEC	6	2	Sales order volume margin with tax
61	KAVMAO	☐	MCW_KAVMAO	PRZ32V	DEC	6	2	Sales order volume margin
62	SAVMAM	☐	MCW_SAVMAM	PRZ32V	DEC	6	2	Third-party order margin w/tax
63	SAVMAO	☐	MCW_SAVMAO	PRZ32V	DEC	6	2	Third-party order margin
64	UMSMAO	☐	MCW_UMSMAO	PRZ32V	DEC	6	2	Sales margin
65	UMSMAM	☐	MCW_UMSMAM	PRZ32V	DEC	6	2	Sales margin with tax
66	AUMMAO	☐	MCW_AUMMAO	PRZ32V	DEC	6	2	Promotion sales margin
67	AUMMAM	☐	MCW_AUMMAM	PRZ32V	DEC	6	2	Promotion sales margin with tax
68	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
69	KUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	KNA1
70	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
71	ASCAR	☐	ASORT	ASORT	CHAR	10	0	Assortment	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S124	BASME	T006	MSEHI
2	S124	HWAER	TCURC	WAERS
3	S124	KDGRP	T151	KDGRP
4	S124	KUNAG	KNA1	KUNNR
5	S124	KUNRG	KNA1	KUNNR
6	S124	LIFNR	LFA1	LIFNR
7	S124	MANDT	T000	MANDT
8	S124	MATKL	T023	MATKL
9	S124	MATNR	MARA	MATNR
10	S124	PLGTP	TWPT	PLGTP
11	S124	SAISO	T6WSP	SAISO
12	S124	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20050411
SAP Release Created in