SAP ABAP Table VTRDI (Shipment Planning Index)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF (Application Component) Basic Functions
     ⤷ VTR (Package) SD R/3 transport processing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VTRDI	Table Relationship Diagram
Short Description	Shipment Planning Index

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	*
2	TRSTA	☑	TRSTA	TRSTA	CHAR	1	0	Transportation planning status
3	VSTEL	☑	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
4	TDDAT	☑	TDDAT_D	DATUM	DATS	8	0	Transportation Planning Date
5	VBELN	☑	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
6	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
7	LSTEL	☐	LSTEL	LSTEL	CHAR	2	0	Loading Point	TVLA
8	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
9	TRAGR	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group	TTGR
10	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
11	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
12	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
13	WADAT	☐	WADAT	DATUM	DATS	8	0	Goods Issue Date
14	LDDAT	☐	LDDAT	DATUM	DATS	8	0	Loading Date
15	LFDAT	☐	LFDAT_V	DATUM	DATS	8	0	Delivery Date
16	KODAT	☐	KODAT	DATUM	DATS	8	0	Picking Date
17	BTGEW	☐	GSGEW	MENG15	QUAN	15	3	Total Weight
18	VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
19	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
20	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
21	KUNNR	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
22	SPDNR	☐	SPDNR	LIFNR	CHAR	10	0	Carrier	LFA1
23	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
24	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
25	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
26	TRSPG	☐	TRSPG	TRSPG	CHAR	2	0	Shipment Blocking Reason	TTSG
27	WBSTK	☐	WBSTK	STATV	CHAR	1	0	Total goods movement status
28	TRATY	☐	TRATY	TRATY	CHAR	4	0	Means-of-Transport Type	TVTY
29	TRMTYP	☐	TRMTYP	MATNR	CHAR	18	0	Means of Transportation	MARA
30	VSART	☐	VSARTTR	VERSART	CHAR	2	0	Shipping type	T173
31	SDABW	☐	SDABW	SDABW	CHAR	4	0	Special Processing Indicator	TVSAK
32	.INCLU--AP	☐				0	0	Fields for IS-DFPS for Transport Index
33	.INCLUDE	☐				0	0	Relocation: Structure for Enhancing Logistics Documents
34	FORCE_ID	☐	/ISDFPS/FORCE_ID	SYSUUID_C	CHAR	32	0	Internal Key for Force Element
35	FORCE_CNT	☐	/ISDFPS/FORCE_CNT	NUMC6	NUMC	6	0	Internal (Version) Counter
36	RELOC_ID	☐	/ISDFPS/RELOC_ID	/ISDFPS/RELOC_ID	CHAR	10	0	Relocation ID	/ISDFPS/REL
37	RELOC_SEQ_ID	☐	/ISDFPS/RELOC_SEQ_ID	/ISDFPS/RELOC_SEQ_ID	CHAR	4	0	Relocation Step ID	/ISDFPS/RELSEQ

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VTRDI	GEWEI	T006	MSEHI	REF	1	CN
2	VTRDI	INCO1	TINC	INCO1	REF	1	CN
3	VTRDI	KUNNR	KNA1	KUNNR	REF	1	CN
4	VTRDI	LAND1	T005	LAND1	REF	1	CN
5	VTRDI	LPRIO	TPRIO	LPRIO	REF	1	CN
6	VTRDI	LSTEL	TVLA	LSTEL	REF	1	CN
7	VTRDI	LZONE	TZONE	ZONE1	REF	1	CN
8	VTRDI	RELOC_ID	/ISDFPS/REL	RELOC_ID
9	VTRDI	RELOC_SEQ_ID	/ISDFPS/RELSEQ	RELOC_SEQ_ID
10	VTRDI	ROUTE	TVRO	ROUTE	REF	1	CN
11	VTRDI	SDABW	TVSAK	SDABW
12	VTRDI	SPDNR	LFA1	LIFNR	REF	1	CN
13	VTRDI	TRAGR	TTGR	TRAGR		1	CN
14	VTRDI	TRATY	TVTY	TRATY
15	VTRDI	TRMTYP	MARA	MATNR
16	VTRDI	TRSPG	TTSG	TRSPG	REF	1	CN
17	VTRDI	VBELN	VBUK	VBELN	KEY	1	CN
18	VTRDI	VOLEH	T006	MSEHI	REF	1	CN
19	VTRDI	VSART	T173	VSART	REF	C	CN
20	VTRDI	VSBED	TVSB	VSBED		1	CN
21	VTRDI	VSTEL	TVST	VSTEL	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in