SAP ABAP Table ROIO_SP_TREE_DELIV (Delivery fields for packing tree)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-OLM (Application Component) Remote Logistics Management
     ⤷ OIO (Package) RLM Remote Logistic Management

Basic Data

Table Category	INTTAB	Structure
Structure	ROIO_SP_TREE_DELIV	Table Relationship Diagram
Short Description	Delivery fields for packing tree

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	VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
2	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
3	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
4	LFART	☐	LFART	LFART	CHAR	4	0	Delivery Type	TVLK
5	WADAT	☐	WADAK	DATUM	DATS	8	0	Planned goods movement date
6	LDDAT	☐	LDDAT	DATUM	DATS	8	0	Loading Date
7	TDDAT	☐	TDDAT_D	DATUM	DATS	8	0	Transportation Planning Date
8	LFDAT	☐	LFDAT_V	DATUM	DATS	8	0	Delivery Date
9	KODAT	☐	KODAT	DATUM	DATS	8	0	Picking Date
10	LIFSK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	TVLS
11	KUNNR_DLV	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
12	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
13	LSTEL	☐	LSTEL	LSTEL	CHAR	2	0	Loading Point	TVLA
14	TRAGR	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group	TTGR
15	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
16	TRSPG	☐	TRSPG	TRSPG	CHAR	2	0	Shipment Blocking Reason	TTSG
17	XBLNR	☐	XBLNR_LIKP	XBLNR_LIKP	CHAR	25	0	Reference Document Number
18	VBUND	☐	VBUND	RCOMP	CHAR	6	0	Company ID	*
19	OIO_HOLD	☐	OIO_HOLD	XFELD	CHAR	1	0	Indicator: Hold Delivery Onshore
20	ICON_HOLD	☐	OIO_ICON_ID	ICON	CHAR	4	0	Icon identifier	*
21	OIO_HOLD_ORIG	☐	OIO_HOLD_ORIG	XFELD	CHAR	1	0	Flag: delivery was originally held onshore
22	POSNR	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
23	PSTYV	☐	PSTYV_VL	PSTYV	CHAR	4	0	Delivery item category	TVPT
24	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
25	LGTYP	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	T301
26	LGPLA	☐	LGPLA	LGPLA	CHAR	10	0	Storage Bin	LAGP
27	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
28	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
29	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
30	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
31	GRKOR	☐	GRKOR	GRKOR	NUMC	3	0	Delivery group (items are delivered together)
32	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
33	UMMAT	☐	UMMAT	MATNR	CHAR	18	0	Receiving/issuing material	*
34	UMBAR	☐	UMBAR	BWTAR	CHAR	10	0	Valuation type of transfer batch	*
35	UMSOK	☐	UMSOK	SOBKZ	CHAR	1	0	Special stock indicator for physical stock transfer	*
36	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
37	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
38	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
39	RTDOC	☐	OIO_RT_DOCNR	OIO_RT_DOCNR	CHAR	10	0	Returns document number	*
40	RTDLN	☐	OIO_RT_DOCLN	OIO_RT_DOCLN	NUMC	4	0	Returns document item number
41	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIO_SP_TREE_DELIV	KUNAG	KNA1	KUNNR	REF	C	CN
2	ROIO_SP_TREE_DELIV	LFART	TVLK	LFART	REF	C	CN
3	ROIO_SP_TREE_DELIV	LGNUM	T300	LGNUM	REF	C	CN
4	ROIO_SP_TREE_DELIV	LGPLA	LAGP	LGPLA	REF	C	CN
5	ROIO_SP_TREE_DELIV	LGTYP	T301	LGTYP	REF	C	CN
6	ROIO_SP_TREE_DELIV	LIFSK	TVLS	LIFSP	REF	C	CN
7	ROIO_SP_TREE_DELIV	LSTEL	TVLA	LSTEL	REF	C	CN
8	ROIO_SP_TREE_DELIV	POSNR	VBUP	POSNR	KEY	1	C
9	ROIO_SP_TREE_DELIV	PSTYV	TVPT	PSTYV	REF	1	CN
10	ROIO_SP_TREE_DELIV	SOBKZ	T148	SOBKZ	REF	C	CN
11	ROIO_SP_TREE_DELIV	SPART	TSPA	SPART	REF	C	CN
12	ROIO_SP_TREE_DELIV	TRAGR	TTGR	TRAGR	REF	C	CN
13	ROIO_SP_TREE_DELIV	TRSPG	TTSG	TRSPG	REF	C	CN
14	ROIO_SP_TREE_DELIV	VKBUR	TVBUR	VKBUR	REF	C	CN
15	ROIO_SP_TREE_DELIV	VKGRP	TVKGR	VKGRP	REF	C	CN
16	ROIO_SP_TREE_DELIV	VKORG	TVKO	VKORG	REF	C	CN
17	ROIO_SP_TREE_DELIV	VSTEL	TVST	VSTEL	REF	1	CN
18	ROIO_SP_TREE_DELIV	VTWEG	TVTW	VTWEG	REF	C	CN

History

Last changed by/on	SAP	20070914
SAP Release Created in