SAP ABAP Table S219BIW2 (S219BIW2 * CatMan: Detailed Level)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-MAP (Application Component) Merchandise and Assortment Planning
     ⤷ CM_MAP (Package) Category Management - MAP

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S219BIW2	Table Relationship Diagram
Short Description	S219BIW2 * CatMan: Detailed Level

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	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
3	HIER_ID	☑	HIER_CNT	HIERCNT	CHAR	2	0	Hierarchy ID
4	CDT1	☑	CM_CDT1	CM_CDT	CHAR	18	0	Category	CMMD_CDT1
5	CDT2	☑	CM_CDT2	CM_CDT	CHAR	18	0	Subcategory	CMMD_CDT2
6	CDT3	☑	CM_CDT3	CM_CDT	CHAR	18	0	Segment	CMMD_CDT3
7	CDT4	☑	CM_CDT4	CM_CDT	CHAR	18	0	Subsegment	CMMD_CDT4
8	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
9	CM_LAND1	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
10	REGIO	☑	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
11	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
12	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
13	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
14	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
15	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
16	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
17	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
18	PSWAE	☐	WISP_PSWAE	WAERS	CUKY	5	0	Database Currency for Planning Data in a Planning Scenario	TCURC
19	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
20	CDT5	☐	CM_CDT5	CM_CDT	CHAR	18	0	Sub-Subsegment	CMMD_CDT5
21	CDT6	☐	CM_CDT6	CM_CDT	CHAR	18	0	Product Group	CMMD_CDT6
22	CDT7	☐	CM_CDT7	CM_CDT	CHAR	18	0	Brand	CMMD_CDT7
23	UMSGVO	☐	MCW_UMSGVO	WERTV10	CURR	19	2	Sales at retail
24	UMSGEO	☐	MCW_UMSGEO	WERTV10	CURR	19	2	Sales at cost
25	UMSMNG	☐	MCW_UMSMNG	MENGV15_3	QUAN	15	3	Sales quantity in base unit of measure
26	CM_AZART	☐	CM_AZART	DEC8_3	DEC	11	3	Number of Articles
27	CM_LISTED	☐	CM_LISTED	LISTED	NUMC	1	0	Listing Indicator
28	CM_UMMKT_E	☐	CM_UMMKT_E	WERTV10	CURR	19	2	Market Turnover (External)
29	CM_ABDSG_E	☐	CM_ABDSG_E	DEC3_3	DEC	6	3	Market Coverage for Segment Level (External)
30	CM_ABDSS_E	☐	CM_ABDSS_E	DEC3_3	DEC	6	3	Market Coverage for Subsegment Level (External)
31	CM_AVGPR_E	☐	CM_AVGPR_E	WERT4	CURR	7	2	Average Price per Article (External)
32	CM_SHLFPRC	☐	CM_SHLFPRC	WERT4	CURR	7	2	Recommended Shelf Price

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S219BIW2	BASME	T006	MSEHI
2	S219BIW2	CDT1	CMMD_CDT1	CDT1	KEY
3	S219BIW2	CDT2	CMMD_CDT2	CDT2	KEY
4	S219BIW2	CDT3	CMMD_CDT3	CDT3	KEY
5	S219BIW2	CDT4	CMMD_CDT4	CDT4	KEY
6	S219BIW2	CDT5	CMMD_CDT5	CDT5
7	S219BIW2	CDT6	CMMD_CDT6	CDT6
8	S219BIW2	CDT7	CMMD_CDT7	CDT7
9	S219BIW2	CM_LAND1	T005	LAND1	KEY
10	S219BIW2	MANDT	T000	MANDT	KEY
11	S219BIW2	MATNR	MARA	MATNR	KEY
12	S219BIW2	PSWAE	TCURC	WAERS		1	CN
13	S219BIW2	REGIO	T005S	BLAND	KEY

History

Last changed by/on	SAP	20130529
SAP Release Created in	600