SAP ABAP View EXPO_BOM_2_MAT (Read BOM for a material number)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ LO-PDM (Application Component) Product Data Management
     ⤷ PLM_FOX_OBJ (Package) Object implementation for PLM_FOX

Basic Data

View Type	D	Database View
Database View	EXPO_BOM_2_MAT
Short Description	Read BOM for a material number
Root table	MAST	Material to BOM Link

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MAST	MAST
2	TC04
3	TCS41
4	STKO
5	T415S

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TC04	MANDT	JL	EQ				0	0
2	TCS41	MANDT	JR	EQ			AND	0	0
3	TC04	CSLID	JL	EQ				0	0
4	TCS41	CSLID	JR	EQ			AND	0	0
5	TCS41	MANDT	JL	EQ				0	0
6	MAST	MANDT	JR	EQ			AND	0	0
7	TCS41	STLAN	JL	EQ				0	0
8	MAST	STLAN	JR	EQ			AND	0	0
9	STKO	MANDT	JL	EQ				0	0
10	MAST	MANDT	JR	EQ			AND	0	0
11	STKO	STLNR	JL	EQ				0	0
12	MAST	STLNR	JR	EQ			AND	0	0
13	T415S	MANDT	JL	EQ				0	0
14	STKO	MANDT	JR	EQ			AND	0	0
15	T415S	STLST	JL	EQ				0	0
16	STKO	STLST	JR	EQ			AND	0	0
17	STKO	STLAL	JL	EQ				0	0
18	MAST	STLAL	JR	EQ			AND	0	0
19	STKO	STLTY		EQ	'M'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TC04	MANDT		☐	MANDT	☐	Client
2	CAPID	TC04	CAPID		☐	CAPID	☐	Application
3	CSLID	TCS41	CSLID		☐	CSLID	☐	CIM selection indicator for alternatives
4	CSLPR	TCS41	CSLPR		☐	CSLPR	☐	CIM priority for selection ID
5	MATNR	MAST	MATNR		☐	MATNR	☐	Material Number
6	WERKS	MAST	WERKS		☐	WERKS_D	☐	Plant
7	STLAN	MAST	STLAN		☐	STLAN	☐	BOM Usage
8	STLNR	MAST	STLNR		☐	STNUM	☐	Bill of Material
9	STLAL	MAST	STLAL		☐	STALT	☐	Alternative BOM
10	STLTY	STKO	STLTY		☐	STLTY	☐	BOM Category
11	STKOZ	STKO	STKOZ		☐	CIM_COUNT	☐	Internal counter
12	STLST	T415S	STLST		☐	STLST	☐	BOM Statuses
13	X415A	TC04	X415A		☐	X415A	☐	Indicator: alternative determination for multiple BOMs
14	XZBDP	TC04	XZBDP		☐	XZBDP	☐	Indicator: explosion in MRP required
15	XZPAF	TC04	XZPAF		☐	XZPAF	☐	Indicator: release for planned orders required
16	XZKLF	TC04	XZKLF		☐	XZKLF	☐	Indicator: release for costing required
17	XZAPF	TC04	XZAPF		☐	XZAPF	☐	Indicator: release for work scheduling required
18	XZAUF	TC04	XZAUF		☐	XZAUF	☐	Indicator: release for orders required
19	XZSME	TC04	XZSME		☐	XZSME	☐	Indicator: collective issue must be allowed
20	XZRVA	TC04	XZRVA		☐	XZRVA	☐	Indicator: explosion in sales order required
21	XFVRS	TC04	XFVRS		☐	XFVRS	☐	Indicator: check production process versions
22	XVWPR	TC04	XVWPR		☐	XVWPR	☐	Indicator: BOM usage has high priority in alt. determination
23	KZBDP	T415S	KZBDP		☐	KZBDP	☐	Indicator: explosion in material requirements planning (MRP)
24	KZPAF	T415S	KZPAF		☐	KZPAF	☐	Indicator: released for planned orders
25	KZKLF	T415S	KZKLF		☐	KZKLF	☐	Indicator: released for costing
26	KZAPF	T415S	KZAPF		☐	KZAPF	☐	Indicator: released for work scheduling
27	KZAUF	T415S	KZAUF		☐	KZAUF	☐	Indicator: released for production orders
28	KZSME	T415S	KZSME		☐	KZSME	☐	Indicator: collective issue allowed
29	KZRVA	T415S	KZRVA		☐	KZRVA	☐	Indicator: sales order explosion
30	KZAMS	T415S	KZAMS		☐	KZAMS	☐	MRP exception message ID (T458A)
31	AENNR	STKO	AENNR		☐	AENNR	☐	Change Number

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20110901
SAP Release Created in	46C1