SAP ABAP Table S496 (DRM: MS Side Business Metrics)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-HT-DRM (Application Component) Distributor-Reseller-Management
     ⤷ DRM4 (Package) Development class for LIS structures

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S496	Table Relationship Diagram
Short Description	DRM: MS Side Business Metrics

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	TRK_PRNR	☑	TRK_PRNR	BU_PARTNER	CHAR	10	0	Tracking partner	BUT000
4	ENDCUST	☑	END_CUST	BU_PARTNER	CHAR	10	0	Customer to whom distributor/ reseller made resale	BUT000
5	SALES_ORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
6	DIST_CHNL	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
7	DIVN	☑	SPART	SPART	CHAR	2	0	Division	TSPA
8	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
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	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
17	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
18	SDQTAPP	☐	SDQTAPP	MENGV15_3	QUAN	15	3	Ship-and-debit claim quantity approved
19	SDAMAPP	☐	SDAMAPP	WERTV8	CURR	15	2	Ship-and-debit claim amount approved
20	SDQTCLM	☐	SDQTCLM	MENGV15_3	QUAN	15	3	Ship-and-debit claim quantity sent by distributor/ reseller
21	SDAMCLM	☐	SDAMCLM	WERTV8	CURR	15	2	Ship-and-debit claimed amount
22	PPQTCR	☐	PPQTCR	MENGV15_3	QUAN	15	3	Price protection claim approved quantity
23	PPAMCR	☐	PPAMCR	WERTV8	CURR	15	2	Price protection approved amount
24	PPQTDB	☐	PPQTDB	MENGV15_3	QUAN	15	3	Price protection claimed quantity
25	PPAMDB	☐	PPAMDB	WERTV8	CURR	15	2	Price protection claimed amount
26	BLQTCLM	☐	BLQTCLM	MENGV15_3	QUAN	15	3	Bill-up claim quantity
27	BLAMCLM	☐	BLAMCLM	WERTV8	CURR	15	2	Bill-up claim amount
28	STQTNL	☐	STQTNL	MENGV15_3	QUAN	15	3	Quantity of material resold from normal lot
29	STQTBP	☐	STQTBP	MENGV15_3	QUAN	15	3	Quantity of material resold from special buy lot
30	STAMNL	☐	STAMNL	WERTV8	CURR	15	2	Value of resale from normal lot
31	STAMBP	☐	STAMBP	WERTV8	CURR	15	2	Value of resale of material from special buy lot
32	ERTQTNL	☐	ERTQTNL	MENGV15_3	QUAN	15	3	Quantity of material returned by resale customer
33	ERTQTBP	☐	ERTQTBP	MENGV15_3	QUAN	15	3	Resale return quantity from special buy lot
34	ERTAMNL	☐	ERTAMNL	WERTV8	CURR	15	2	Refund amount against resale return from normal lot
35	RTQTBKP	☐	RTQTBKP	WERTV8	CURR	15	2	Refund amount against resale return from special buy lot
36	RTNMQYGR	☐	RTNMQYGR	MENGV15_3	QUAN	15	3	Return quantity issued/ received from normal lot
37	RTBPQYCM	☐	RTBPQYCM	MENGV15_3	QUAN	15	3	Return quantity from special buy lot approved for refund
38	DRTAMNL	☐	DRTAMNL	WERTV8	CURR	15	2	Refund amount for sales return from normal lot
39	DRTAMBP	☐	DRTAMBP	MENGV15_3	QUAN	15	3	Sales return quantity from special buy lot
40	DRTQYNAP	☐	DRTQYNAP	MENGV15_3	QUAN	15	3	Normal price lot return quantity approved for refund
41	DRTAMBAP	☐	DRTAMBAP	WERTV8	CURR	15	2	Refund amount approved against return from special buy lot
42	SIQYNLGI	☐	SIQYNLGI	MENGV15_3	QUAN	15	3	Goods Issue quantity for normal lot sale to distributor
43	SIQYNLIV	☐	SIQYNLIV	MENGV15_3	QUAN	15	3	Invoiced quantity for normal lot sale to distributor
44	SIAMNL	☐	SIAMNL	WERTV8	CURR	15	2	Normal lot invoice amount
45	SIQYBPGI	☐	SIQYBPGI	MENGV15_3	QUAN	15	3	Special buy lot quantity sold to distributor/ reseller
46	SIQYBPIV	☐	SIQYBPIV	MENGV15_3	QUAN	15	3	Special buy invoiced quantity
47	SIAMBP	☐	SIAMBP	WERTV8	CURR	15	2	Special buy invoice amount
48	PCRQYNL	☐	PCRQYNL	MENGV15_3	QUAN	15	3	Increment applied on normal lot quantity for reconciliation
49	PCRQYBP	☐	PCRQYBP	MENGV15_3	QUAN	15	3	Increment applied to special buy quantity for reconciliation
50	NCRQYNL	☐	NCRQYNL	MENGV15_3	QUAN	15	3	Reduction applied for reconciliation of normal lot quantity
51	NCRQYBP	☐	NCRQYBP	MENGV15_3	QUAN	15	3	Reduction applied to special buy quantity for reconciliation
52	DSAMNL	☐	DSAMNL	WERTV8	CURR	15	2	Drop ship amount for normal lot
53	DSQYNL	☐	DSQYNL	MENGV15_3	QUAN	15	3	Drop ship quantity from normal lot
54	DSQYBP	☐	DSQYBP	MENGV15_3	QUAN	15	3	Drop ship quantity from special buy lot
55	DSAMBP	☐	DSAMBP	WERTV8	CURR	15	2	Drop ship amount for special buy lot
56	STDSQYNL	☐	STDSQYNL	MENGV15_3	QUAN	15	3	Drop-ship quantity from normal lot
57	STDSAMNL	☐	STDSAMNL	WERTV8	CURR	15	2	Amount for drop-ship resale from normal lot
58	STDSQYBP	☐	STDSQYBP	MENGV15_3	QUAN	15	3	Drop-ship quantity from special buy lot
59	STDSAMBP	☐	STDSAMBP	WERTV8	CURR	15	2	DRM Drop Ship (Special Price) Amount Sell Through

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S496	BASME	T006	MSEHI
2	S496	DIST_CHNL	TVTW	VTWEG	KEY
3	S496	DIVN	TSPA	SPART	KEY
4	S496	ENDCUST	BUT000	PARTNER	KEY
5	S496	MANDT	T000	MANDT	KEY
6	S496	MATNR	MARA	MATNR	KEY
7	S496	SALES_ORG	TVKO	VKORG	KEY
8	S496	STWAE	TCURC	WAERS
9	S496	TRK_PRNR	BUT000	PARTNER	KEY

History

Last changed by/on	SAP	20110901
SAP Release Created in