SAP ABAP Table S498 (DRM: Sellin 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	S498	Table Relationship Diagram
Short Description	DRM: Sellin 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	PURCH_ORG	☑	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
4	PLANT	☑	EWERK	WERKS	CHAR	4	0	Plant	T001W
5	PARTNER	☑	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
6	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
7	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
8	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
9	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
10	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
11	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
12	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
13	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
14	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
15	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
16	SIQYNLGI	☐	SIQYNLGI	MENGV15_3	QUAN	15	3	Goods Issue quantity for normal lot sale to distributor
17	SIQYNLIV	☐	SIQYNLIV	MENGV15_3	QUAN	15	3	Invoiced quantity for normal lot sale to distributor
18	SIAMNL	☐	SIAMNL	WERTV8	CURR	15	2	Normal lot invoice amount
19	SIAMBP	☐	SIAMBP	WERTV8	CURR	15	2	Special buy invoice amount
20	SIQYBPIV	☐	SIQYBPIV	MENGV15_3	QUAN	15	3	Special buy invoiced quantity
21	SIQYBPGI	☐	SIQYBPGI	MENGV15_3	QUAN	15	3	Special buy lot quantity sold to distributor/ reseller
22	DSAMNL	☐	DSAMNL	WERTV8	CURR	15	2	Drop ship amount for normal lot
23	DSAMBP	☐	DSAMBP	WERTV8	CURR	15	2	Drop ship amount for special buy lot
24	DSQYNL	☐	DSQYNL	MENGV15_3	QUAN	15	3	Drop ship quantity from normal lot
25	DSQYBP	☐	DSQYBP	MENGV15_3	QUAN	15	3	Drop ship quantity from special buy lot

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S498	BASME	T006	MSEHI
2	S498	MANDT	T000	MANDT	KEY
3	S498	MATNR	MARA	MATNR	KEY
4	S498	PARTNER	BUT000	PARTNER	KEY
5	S498	PLANT	T001W	WERKS	KEY
6	S498	PURCH_ORG	T024E	EKORG	KEY
7	S498	STWAE	TCURC	WAERS

History

Last changed by/on	SAP	20110901
SAP Release Created in