Creating a View in SAP ERP - SAP Documentation

In the ERP system, in the client that contains equipment data, call up transaction SE11 to create a view. To do so, select the View radio button and enter a name for the view. As the view type, choose Database view:

Example Example

You create view ZEQ_BOM .

End of the example.

On the Table/Join conditions tab page, you link tables EQST and STPO , by entering the two tables in the Tables area and defining join conditions in the Join Conditions area.

Example Example

You define the following join conditions:

End of the example.

Table	Field Name	=	Table	Field Name
STPO	STLNR	=	EQST	STLNR
STPO	MANDT	=	EQST	MANDT

You define the selection conditions on the Selection Criteria tab page.

Example Example

You define the following selection criteria:

End of the example.

Table	Field Name	Operator	Comp. Value
STPO	STLTY	EQ	’E’

You enter the required view fields on the View Flds tab page.

Example Example

Enter the following view fields:

End of the example.

View Field	DTyp	Length	Short Description
MANDT	CLNT	3	Client
EQUNR	CHAR	18	Equipment number
STLNR	CHAR	8	Bill of material
STLTY	CHAR	1	BOM type
STLKN	NUMC	8	BOM item node number
MEINS	UNIT	3	Component unit of measure
MENGE	QUAN	13	Component quantity
IDNRK	CHAR	18	BOM component

Save your entries.