SAP ABAP Table V_SOTR (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_SOTR	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	ASORT	☑	ASORT	ASORT	CHAR	10	0	Assortment
3	STATU	☑	W_S_STATUS	W_S_STATUS	CHAR	1	0	Status of assortment
4	KZLIK	☑	KZLIK	XFELD	CHAR	1	0	Listing conditions should be created per assortment
5	NLMATFB	☑	NLMATFB	NLMATFB	CHAR	1	0	ID: Carry out subsequent listing
6	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
7	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
8	LSTFL	☑	LSTVF	LSTFL	CHAR	2	0	Listing procedure	TWLV
9	DATAB	☑	DATAB	DATUM	DATS	8	0	Valid-From Date
10	DATBI	☑	DATBI	DATUM	DATS	8	0	Valid To Date
11	KOPRO	☑	W_S_KOPRO	XFELD	CHAR	1	0	All material groups can be listed - even if there are errors
12	LAYPR	☑	W_S_LAYPR	XFELD	CHAR	1	0	Listing check: only use layout defined for the assortment
13	VLFKZ	☑	W_SOTYP	W_SOTYP	CHAR	1	0	Assortment Category
14	LAYVR	☑	LAYVAR	LAYVAR	CHAR	10	0	Layout	TWGV
15	NAME1	☑	ASORTTEXT40	TEXT40	CHAR	40	0	Description of Assortments
16	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_SOTR	LAYVR	TWGV	LAYVR		1	CN
2	V_SOTR	LSTFL	TWLV	LSTFL		1	CN
3	V_SOTR	MANDT	T000	MANDT		1	CN
4	V_SOTR	SPRAS	T002	SPRAS		1	CN
5	V_SOTR	VKORG	TVKO	VKORG		1	CN
6	V_SOTR	VTWEG	TVTW	VTWEG		1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in