SAP ABAP Table V56I_DLNT_VIEW (Transportation Planning: Shipment + Delivery Header)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	V56I_DLNT_VIEW	Table Relationship Diagram
Short Description	Transportation Planning: Shipment + Delivery Header

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	.INCLUDE	☐				0	0	Tranportation Planning: Data from the Shipment
2	TPLST	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	TTDS
3	TXDIL	☐	NAME1_TDL	CHAR28	CHAR	28	0	Service agent name 1
4	TDLNR	☐	TDLNR	LIFNR	CHAR	10	0	Number of forwarding agent	LFA1
5	ROUTE	☐	ROUTR	ROUTE	CHAR	6	0	Shipment route	TVRO
6	SHTYP	☐	SHTYP	SHTYP	CHAR	4	0	Shipment type	TVTK
7	VSART	☐	VERSART	VERSART	CHAR	2	0	Shipping type	T173
8	VSAVL	☐	VSAVL	VERSART	CHAR	2	0	Shipping type of preliminary leg	T173
9	VSANL	☐	VSANL	VERSART	CHAR	2	0	Shipping type of subsequent leg	T173
10	SDABW	☐	SDABW	SDABW	CHAR	4	0	Special Processing Indicator	TVSAK
11	LAUFK	☐	LAUFK	LAUFK	CHAR	1	0	Leg Indicator
12	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
13	SIGNI	☐	SIGNI	TEXT20	CHAR	20	0	Container ID
14	EXTI1	☐	EXTI1	TEXT20	CHAR	20	0	External identification 1
15	EXTI2	☐	EXTI2	TEXT20	CHAR	20	0	External identification 2
16	TPBEZ	☐	TPBEZ	TEXT20	CHAR	20	0	Description of Shipment
17	STDIS	☐	STDIS	STTRA	CHAR	1	0	Status of transportation planning
18	DTDIS	☐	DTDIS	DATUM	DATS	8	0	Date of end of planning
19	UZDIS	☐	UZDIS	UZEIT	TIMS	6	0	Scheduling end time
20	STLBG	☐	STLBG	STTRA	CHAR	1	0	Status for start of loading
21	DPLBG	☐	DPLBG	DATUM	DATS	8	0	Planned date for start of loading
22	UPLBG	☐	UPLBG	UZEIT	TIMS	6	0	Planned loading start time
23	DALBG	☐	DALBG	DATUM	DATS	8	0	Current date for start of loading
24	UALBG	☐	UALBG	UZEIT	TIMS	6	0	Actual loading start time
25	STLAD	☐	STLAD	STTRA	CHAR	1	0	Status for end of loading
26	DPLEN	☐	DPLEND	DATUM	DATS	8	0	Planned date for end of loading
27	UPLEN	☐	UPLEND	UZEIT	TIMS	6	0	Planned loading end time
28	DALEN	☐	DALEND	DATUM	DATS	8	0	Actual date for end of loading
29	UALEN	☐	UALEND	UZEIT	TIMS	6	0	Actual loading end time
30	DPREG	☐	DPREG	DATUM	DATS	8	0	Planned date of check-in
31	UPREG	☐	UPREG	UZEIT	TIMS	6	0	Planned check-in time
32	DAREG	☐	DAREG	DATUM	DATS	8	0	Actual date of check-in
33	UAREG	☐	UAREG	UZEIT	TIMS	6	0	Current time of check-in
34	STTRG	☐	STTRG	STTRG	CHAR	1	0	Overall transportation status
35	STTRG_ICON	☐	STTRG	STTRG	CHAR	1	0	Overall transportation status
36	STABF	☐	STABF	STTRA	CHAR	1	0	Status of shipment completion
37	DTABF	☐	DTABF	DATUM	DATS	8	0	Current date of shipment completion
38	UZABF	☐	UZABF	UZEIT	TIMS	6	0	Time of transportation processing
39	STTBG	☐	STTBG	STTRA	CHAR	1	0	Status for start of shipment
40	DPTBG	☐	DPTBG	DATUM	DATS	8	0	Planned date for start of shipment
41	UPTBG	☐	UPTBG	UZEIT	TIMS	6	0	Planned transport start time
42	DATBG	☐	DATBG	DATUM	DATS	8	0	Current date for start of shipment
43	UATBG	☐	UATBG	UZEIT	TIMS	6	0	Actual transport start time
44	STTEN	☐	STTEN	STTRA	CHAR	1	0	Status for end of shipment
45	DPTEN	☐	DPTEN	DATUM	DATS	8	0	Planned date for end of shipment
46	UPTEN	☐	UPTEN	UZEIT	TIMS	6	0	Planned transport end time
47	DATEN	☐	DATEND	DATUM	DATS	8	0	Actual Date for End of Shipment
48	UATEN	☐	UATEND	UZEIT	TIMS	6	0	Actual shipment end time
49	STREG	☐	STREG	STTRA	CHAR	1	0	Status of check-in
50	TNDRST	☐	TNDRST	TNDRST	CHAR	2	0	Tender Status
51	TNDRRC	☐	TNDRRC	TNDRRC	CHAR	2	0	Acceptance Condition/Rejection Reason
52	ALLOWED_TWGT	☐	ALLOWED_TWGT	MENG12_0	QUAN	8	0	Allowed total weight of shipment
53	DTMEG	☐	DTMEG	MEINS	UNIT	3	0	Unit of Weight for Transportation Planning	*
54	.INCLU--AP	☐				0	0	Append for V56I_ship_part
55	.INCLUDE	☐				0	0	Include Transportation Planning Staff and Vehicles
56	/BEV1/RPFAR1	☐	/DSD/RP_DRIVER1	KUNNR	CHAR	10	0	Driver 1	KNA1
57	/BEV1/RPFAR2	☐	/DSD/RP_DRIVER2	KUNNR	CHAR	10	0	Driver 2	KNA1
58	/BEV1/RPMOWA	☐	/DSD/RP_TRUCK	EQUNR	CHAR	18	0	Vehicle	*
59	/BEV1/RPANHAE	☐	/DSD/RP_TRAIL	EQUNR	CHAR	18	0	Trailer	*
60	/BEV1/RPFLGNR	☐	/DSD/RP_SEQUENCENR	/DSD/RP_SEQUENCENR	NUMC	5	0	Loading Sequence Number in the Tour
61	.INCLUDE	☐				0	0	Dynamic Values Staff and Vehicles for Transport Planning
62	/BEV1/RPF1NA1	☐	/DSD/RP_DRIVER1_NAME	NAME	CHAR	35	0	Name of Driver 1
63	/BEV1/RPF2NA1	☐	/DSD/RP_DRIVER2_NAME	NAME	CHAR	35	0	Name of Driver 2
64	/BEV1/RPMOBEZ	☐	/DSD/RP_TRUCK_NAME	TEXT40	CHAR	40	0	Description of Tractor
65	/BEV1/RPAHBEZ	☐	/DSD/RP_TRAIL_NAME	TEXT40	CHAR	40	0	Description of Trailer
66	.INCLUDE	☐				0	0	Include Route Planning Quantities (from Deliveries)
67	/BEV1/RPKUNDEN	☐	/BEV1/RPKUNDEN	NUMC03	NUMC	3	0	Number of Customers
68	/BEV1/RPMENGE	☐	/BEV1/RPMENGE	MENG13	QUAN	13	3	Order Volume
69	/BEV1/RPVOL_U	☐	/BEV1/RPVOL_U	MEINS	UNIT	3	0	Volume Unit	*
70	/BEV1/RPAGEW	☐	/BEV1/RPAGEW	MENG13	QUAN	13	3	Order Weight
71	/BEV1/RPMASS_U	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
72	.INCLUDE	☐				0	0	Dyn. Part Shipment Header Capacity Usage (Transp. Planning)
73	/BEV1/RPNUTZLAST	☐	/BEV1/RPNUTZLAST	MENG13	QUAN	13	3	Usable Load
74	/BEV1/RP_WEIGTH_U	☐	WEIGHT_UNIT	MEINS	UNIT	3	0	Unit of weight	*
75	/BEV1/RPFRKAPA	☐	/BEV1/RPFRKAPA	MENG13	QUAN	13	3	Free Capacity for Shipment (Transportation Planning)
76	/BEV1/RPMNGTR	☐	/BEV1/RPMNGTR	/BEV1/RPVARKAP	QUAN	7	2	Shipment Quantity Calculated in Var. Capacity Unit of Truck
77	/BEV1/RPKAPTR	☐	/BEV1/RPVARKAP	/BEV1/RPVARKAP	QUAN	7	2	Free Capacity Field with Variable Unit of Measure
78	/BEV1/RPKAPUNIT	☐	/BEV1/RPKAPUNIT	MEINS	UNIT	3	0	Unit of Measure for Var. Capacity Field	*
79	/BEV1/RPAUSLA	☐	/BEV1/RPAUSLA	DEC3_2	DEC	5	2	Capacity Utilization of Vehicle as a Percentage
80	/BEV1/RPGEWNL	☐	/BEV1/RPGEWNL	DEC03_2	DEC	5	2	Ratio of Shipment Weight to Usable Load of Truck as Percent.
81	.INCLUDE	☐				0	0	Dyn. Part Shipment Header Overall Status (Transp. Planning)
82	/BEV1/RPGSTATUS	☐	/BEV1/RPGSTATUS	CHAR1	CHAR	1	0	Overall Status of Shipment in Transportation Planning
83	.INCLUDE	☐				0	0	Transportation Planning: Data from the Delivery
84	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
85	NAME1	☐	NAME1_TWE	CHAR28	CHAR	28	0	Ship-to party name 1
86	CONADDR	☐	TP_ADDR	CHAR40	CHAR	40	0	Address of ship-to party
87	CONADDR_ORIG	☐	TP_ADDR_ORIG	CHAR40	CHAR	40	0	Address of vendor
88	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
89	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
90	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
91	TDDAT	☐	TDDAT_D	DATUM	DATS	8	0	Transportation Planning Date
92	KODAT	☐	KODAT	DATUM	DATS	8	0	Picking Date
93	LDDAT	☐	LDDAT	DATUM	DATS	8	0	Loading Date
94	WADAT	☐	WADAK	DATUM	DATS	8	0	Planned goods movement date
95	WADAT_IST	☐	WADAT_IST	DATUM	DATS	8	0	Actual Goods Movement Date
96	LFDAT	☐	LFDAT_V	DATUM	DATS	8	0	Delivery Date
97	LFUHR	☐	LFUHR	LFUHR	TIMS	6	0	Time of delivery
98	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
99	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
100	KUNNR	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
101	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
102	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
103	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
104	BEROT	☐	BEROT	BEROT	CHAR	20	0	Picked items location
105	GRULG	☐	GRULG	GRULG	CHAR	4	0	Weight group for delivery (To group)	TVLG
106	LSTEL	☐	LSTEL	LSTEL	CHAR	2	0	Loading Point	TVLA
107	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
108	LGTOR	☐	LGTOR	LGTOR	CHAR	3	0	Door for Warehouse Number	T30B
109	LGBZO	☐	LGBZO	LGBZO	CHAR	10	0	Staging Area for Warehouse Complex	T30C
110	ANZPK	☐	ANZPK_CALC	INT4	INT4	10	0	Total number of packages in delivery
111	TRAGR	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group	TTGR
112	TRMTYP	☐	TRMTYP	MATNR	CHAR	18	0	Means of Transportation	MARA
113	TRATY	☐	TRATY	TRATY	CHAR	4	0	Means-of-Transport Type	TVTY
114	TRAID	☐	TRAID	TRAID	CHAR	20	0	Means-of-transport ID
115	CONT_DG	☐	ADGE_NCDG	X	CHAR	1	0	Indicator: Document contains dangerous goods
116	NAME1_SP	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
117	SPDNR	☐	SPDNR	LIFNR	CHAR	10	0	Carrier	LFA1
118	XABLN	☐	XABLN	BELNR	CHAR	10	0	Goods receipt/issue slip number
119	LIFEX	☐	LIFEX	TEXT35	CHAR	35	0	External Identification of Delivery Note
120	LFART	☐	LFART	LFART	CHAR	4	0	Delivery Type	TVLK
121	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
122	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
123	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
124	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
125	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
126	VBELN_VAUF	☐	VBELN_VAUF	VBELN	CHAR	10	0	Order	VBUK
127	BTGEW	☐	LFGEW_NEW	MENG15	QUAN	15	3	Gross Weight of Delivery
128	GSGWD	☐	GSGWD_NEW	MENG15	QUAN	15	3	Total Weight of Delivery
129	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
130	VOLUM	☐	LFVOL_NEW	MENG15	QUAN	15	3	Delivery Volume
131	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
132	WBSTK_TR	☐	WBSTK	STATV	CHAR	1	0	Total goods movement status
133	KOSTK_TR	☐	KOSTK	STATV	CHAR	1	0	Overall picking / putaway status
134	LVSTK_TR	☐	LVSTK	STATV	CHAR	1	0	Overall status of warehouse management activities
135	UVVLS_TR	☐	UVVLS_SU	STATV	CHAR	1	0	Total incompletion status of all items: Delivery
136	KOQUK_TR	☐	KOQUK	STATV	CHAR	1	0	Status of pick confirmation
137	UVPAK_TR	☐	UVPAK_UK	STATV	CHAR	1	0	Header incomplete status for packaging
138	UVPIK_TR	☐	UVPIK_UK	STATV	CHAR	1	0	Header incomplete status for picking/putaway
139	UVWAK_TR	☐	UVWAK_UK	STATV	CHAR	1	0	Post header incomplete status for goods movement
140	VLSTK_TR	☐	VLSTK	VLSTK	CHAR	1	0	Distribution Status (Decentralized Warehouse Processing)
141	LSSTK_TR	☐	LSSTK_G	STATV	CHAR	1	0	Overall delivery block status
142	PDSTK_TR	☐	PDSTK	STATV	CHAR	1	0	POD status on header level
143	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
144	.INCLU--AP	☐				0	0	Append Structure for V56I_DLNT_VIEW
145	.INCLUDE	☐				0	0	Include Basic Structure (2Field) for Appends
146	/BEV1/LULEINH	☐	/BEV1/LULEINH	/BEV1/LULEINH	NUMC	8	0	Loading Units
147	/BEV1/LULDEGRP	☐	/BEV1/LULDEGRP	/BEV1/LULDEGRP	CHAR	3	0	Loading Unit Group: IS Beverage	/BEV1/LUT906

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V56I_DLNT_VIEW	/BEV1/LULDEGRP	/BEV1/LUT906	/BEV1/LULDEGRP
2	V56I_DLNT_VIEW	/BEV1/RPFAR1	KNA1	KUNNR
3	V56I_DLNT_VIEW	/BEV1/RPFAR2	KNA1	KUNNR
4	V56I_DLNT_VIEW	GEWEI	T006	MSEHI
5	V56I_DLNT_VIEW	GRULG	TVLG	GRULG
6	V56I_DLNT_VIEW	INCO1	TINC	INCO1
7	V56I_DLNT_VIEW	KDGRP	T151	KDGRP
8	V56I_DLNT_VIEW	KUNAG	KNA1	KUNNR
9	V56I_DLNT_VIEW	KUNNR	KNA1	KUNNR
10	V56I_DLNT_VIEW	LFART	TVLK	LFART
11	V56I_DLNT_VIEW	LGBZO	T30C	LGBZO
12	V56I_DLNT_VIEW	LGNUM	T300	LGNUM
13	V56I_DLNT_VIEW	LGTOR	T30B	LGTOR
14	V56I_DLNT_VIEW	LIFNR	LFA1	LIFNR
15	V56I_DLNT_VIEW	LPRIO	TPRIO	LPRIO
16	V56I_DLNT_VIEW	LSTEL	TVLA	LSTEL
17	V56I_DLNT_VIEW	LZONE	TZONE	ZONE1
18	V56I_DLNT_VIEW	REGIO	T005S	BLAND
19	V56I_DLNT_VIEW	ROUTE	TVRO	ROUTE
20	V56I_DLNT_VIEW	SDABW	TVSAK	SDABW
21	V56I_DLNT_VIEW	SHTYP	TVTK	SHTYP
22	V56I_DLNT_VIEW	SPDNR	LFA1	LIFNR
23	V56I_DLNT_VIEW	TDLNR	LFA1	LIFNR
24	V56I_DLNT_VIEW	TPLST	TTDS	TPLST
25	V56I_DLNT_VIEW	TRAGR	TTGR	TRAGR
26	V56I_DLNT_VIEW	TRATY	TVTY	TRATY
27	V56I_DLNT_VIEW	TRMTYP	MARA	MATNR
28	V56I_DLNT_VIEW	VBELN_VAUF	VBUK	VBELN
29	V56I_DLNT_VIEW	VKORG	TVKO	VKORG
30	V56I_DLNT_VIEW	VOLEH	T006	MSEHI
31	V56I_DLNT_VIEW	VSANL	T173	VSART
32	V56I_DLNT_VIEW	VSART	T173	VSART
33	V56I_DLNT_VIEW	VSAVL	T173	VSART
34	V56I_DLNT_VIEW	VSBED	TVSB	VSBED
35	V56I_DLNT_VIEW	VSTEL	TVST	VSTEL
36	V56I_DLNT_VIEW	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in