SAP ABAP Table /SAPCEM/VS1 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	/SAPCEM/VS1	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
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	J_3GBELNR	☑	J_3GBELNR	J_3GBELNR	CHAR	10	0	External Document Number
3	J_3GBELNRI	☑	J_3GBELNRI	J_3GBELNR	CHAR	10	0	Document Number
4	J_3GPOSNRI	☑	J_3GBELPOS	J_3GPOSNR	NUMC	5	0	Document Item
5	J_3GUPOSNR	☑	J_3GUPOSNR	NUMC2	NUMC	2	0	Sub-Item Number
6	J_3GABSEND	☐	J_3GABSEND	KUNNR	CHAR	10	0	Sender	KNA1
7	J_3GEMPFAE	☐	J_3GEMPFAE	KUNNR	CHAR	10	0	Recipient	KNA1
8	J_3GBELDAT	☐	J_3GBELDAT	DATUM	DATS	8	0	CEM Document Date
9	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
10	J_3GBEWEG	☐	J_3GBEWEG	J_3GBEWEG	CHAR	1	0	Internal Indicator for Transaction Type
11	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
12	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
13	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
14	J_3GBELSTA	☐	J_3GBELSTA	J_3GBELSTA	CHAR	1	0	Internal Document Status
15	J_3GBLART	☐	J_3GBLART	J_3GBLART	CHAR	4	0	Document Type	J_3GBELART

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/SAPCEM/VS1	EQUNR	EQUI	EQUNR
2	/SAPCEM/VS1	J_3GABSEND	KNA1	KUNNR
3	/SAPCEM/VS1	J_3GBLART	J_3GBELART	J_3GBLART
4	/SAPCEM/VS1	J_3GEMPFAE	KNA1	KUNNR
5	/SAPCEM/VS1	MANDT	T000	MANDT	KEY	1	CN
6	/SAPCEM/VS1	MATNR	MARA	MATNR	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in