SAP ABAP Table S457 (IS-M/SD: Carrier Route Statistics)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S457	Table Relationship Diagram
Short Description	IS-M/SD: Carrier Route Statistics

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	BEZIRKTAT	☑	BEZIRKTAT	BEZIRK	CHAR	10	0	Actual Carrier Route	JVTBEZIRK
9	DRERZTAT	☑	DRERZTAT	DRERZ	CHAR	8	0	Actual Publication Delivered	JDTDRER
10	PVATAT	☑	PVATAT	PVA	CHAR	8	0	Actual edition delivered	JDTPVA
11	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
12	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
13	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
14	ETMEINS	☐	ETMEINS	MEINS	UNIT	3	0	IS-M: Sales Unit for Sales Order	T006
15	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
16	LFMENGE	☐	LIEFRMENG2	LIEFRMENG2	QUAN	9	0	Delivery quantity of edition
17	WRBMNGPLAN	☐	WRBMNGPLA2	JSTMNGQUAN	QUAN	9	0	Planned quantity for promotional copies in a delivery
18	RESMNGPLAN	☐	RESMNGPLA2	JSTMNGQUAN	QUAN	9	0	Planned reserve quantity per delivery
19	LFMNGAU	☐	JMC_LFMNGZ	JMC_QUAN15	QUAN	15	0	Quantity delivered (for order schedule line)
20	REMMENGE	☐	JMC_REMMNG	JMC_MENGE	QUAN	14	0	Quantity returned
21	ANZREM	☐	JMC_ANZREM	MCZAEHLER	DEC	9	0	Number of returns
22	ANZREMPOS	☐	JMC_ANZREP	MCZAEHLER	DEC	9	0	Number of return items
23	REKMENGE	☐	JMC_REKMNG	JMC_MENGE	QUAN	14	0	Complaint quantity
24	NLMENGE	☐	JMC_NLMENG	JMC_MENGE	QUAN	14	0	Subsequent delivery quantity
25	BEZMENGE	☐	JMC_BEZOGM	JMC_MENGE	QUAN	14	0	Quantity purchased for complaint
26	ANZREK	☐	JMC_ANZREK	MCZAEHLER	DEC	9	0	Number of complaints
27	ANZREKPOS	☐	JMC_ANZRKP	MCZAEHLER	DEC	9	0	Number of complaint items
28	UMNETWR	☐	MC_UMNETWR	WERTV10	CURR	19	2	Net value of invoiced sales
29	UMBRTWR	☐	JMC_UMBR	WERTV10	CURR	19	2	Gross sales volume
30	GUNETWR	☐	MC_GUNETWR	WERTV10	CURR	19	2	Net value of credit memos
31	GUBRTWR	☐	JMC_GUBR	WERTV10	CURR	19	2	Gross credit memo value
32	UMKZWI1	☐	JMC_UMKZW1	WERTV9	CURR	17	2	Sales volume pricing subtotal 1
33	UMKZWI2	☐	JMC_UMKZW2	WERTV9	CURR	17	2	Sales volume pricing subtotal 2
34	UMKZWI3	☐	JMC_UMKZW3	WERTV9	CURR	17	2	Sales volume pricing subtotal
35	UMKZWI4	☐	JMC_UMKZW4	WERTV9	CURR	17	2	Sales volume pricing subtotal 4
36	UMKZWI5	☐	JMC_UMKZW5	WERTV9	CURR	17	2	Sales volume pricing subtotal 5
37	UMKZWI6	☐	JMC_UMKZW6	WERTV9	CURR	17	2	Sales volume pricing subtotal 6
38	GUKZWI1	☐	JMC_GUKZW1	WERTV9	CURR	17	2	Credit memo pricing subtotal 1
39	GUKZWI2	☐	JMC_GUKZW2	WERTV9	CURR	17	2	Credit memo pricing subtotal 2
40	GUKZWI3	☐	JMC_GUKZW3	WERTV9	CURR	17	2	Credit memo pricing subtotal 3
41	GUKZWI4	☐	JMC_GUKZW4	WERTV9	CURR	17	2	Credit memo pricing subtotal 4
42	GUKZWI5	☐	JMC_GUKZW5	WERTV9	CURR	17	2	Credit memo pricing subtotal 5
43	GUKZWI6	☐	JMC_GUKZW6	WERTV9	CURR	17	2	Credit memo pricing subtotal 6

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S457	BEZIRKTAT	JVTBEZIRK	BEZIRK
2	S457	DRERZTAT	JDTDRER	DRERZ
3	S457	ETMEINS	T006	MSEHI
4	S457	MANDT	T000	MANDT
5	S457	PVATAT	JDTPVA	PVA
6	S457	STWAE	TCURC	WAERS
7	S457	VKORG	TVKO	VKORG

History

Last changed by/on	SAP	20050224
SAP Release Created in