SAP ABAP Table ROIO_SP_TREE (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   Table Relationship Diagram
Short Description 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 ICON_DRAG OIO_SP_ICON_DRAG ICON CHAR 4   0   Icon for items that can be dragged *
2 .INCLUDE       0   0   Key for document flow object  
3 OBJTY OIO_OBJTY OIO_OBJTY CHAR 4   0   Object type for document flow *
4 OBJID OIO_OBJID OIO_OBJID CHAR 22   0   Identifier for document flow object  
5 .INCLUDE       0   0   Common data for document flow objects  
6 ONAME OIO_OBJ_NAME TEXT40 CHAR 40   0   Name of document flow object  
7 OBJ_EXTID OIO_OBJ_EXTID TEXT20 CHAR 20   0   External ID for document flow object  
8 DESCR OIO_OBJ_DESCR TEXT40 CHAR 40   0   Description of document flow object  
9 STATUS_CD OIO_OBJ_STATUS_CD OIO_OBJ_STATUS_CD NUMC 2   0   Status of document flow object  
10 MATNR OIO_OBJ_MATNR MATNR CHAR 18   0   Material of document flow object *
11 MATKL MATKL MATKL CHAR 9   0   Material Group *
12 WERKS OIO_OBJ_WERKS WERKS CHAR 4   0   Plant of document flow object *
13 LGORT OIO_OBJ_LGORT LGORT CHAR 4   0   Store location of document flow object *
14 CHARG OIO_OBJ_CHARG CHARG CHAR 10   0   Batch number of a document flow object *
15 UMWRK OIO_OBJ_UMWRK WERKS CHAR 4   0   Receiving / supplying plant for document flow object *
16 UMLGO OIO_OBJ_UMLGO LGORT CHAR 4   0   Supplying store location of document flow object *
17 UMCHA OIO_OBJ_UMCHA CHARG CHAR 10   0   Supplying batch of a document flow object *
18 XPART OIO_OBJ_XPART XFELD CHAR 1   0   Flag for partial quantity  
19 BWART BWART BWART CHAR 3   0   Movement type (inventory management) *
20 BWTXT BWTXT BTEXT CHAR 20   0   Movement type text (inventory management)  
21 MENGE OIO_OBJ_MENGE MENGE QUAN 13   3   Quantity for document flow object  
22 MEINS OIO_OBJ_MEINS MEINS UNIT 3   0   Units for document flow quantity *
23 LGMNG OIO_OBJ_LGMNG MENGE QUAN 13   3   Quantity in stockkeeping units  
24 LMEIN OIO_OBJ_LMEIN MEINS UNIT 3   0   Stockkeeping units for document flow object *
25 WRKMG OIO_OBJ_WRKMG MENGE QUAN 13   3   Quantity at plant  
26 WRKME OIO_OBJ_WRKME MEINS UNIT 3   0   Base units at plant *
27 UMLMG OIO_OBJ_UMLMG MENGE QUAN 13   3   Quantity at supplying plant  
28 UMLME OIO_OBJ_UMLME MEINS UNIT 3   0   Base units at supplying plant *
29 KUNWE OIO_OBJ_KUNWE KUNNR CHAR 10   0   Ship-to party for document flow object *
30 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
31 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area *
32 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
33 AUFNR AUFNR AUFNR CHAR 12   0   Order Number *
34 PROJK PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) *
35 GSBER GSBER GSBER CHAR 4   0   Business Area *
36 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
37 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number *
38 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor *
39 EKORG EKORG EKORG CHAR 4   0   Purchasing organization *
40 EKGRP EKGRP EKGRP CHAR 3   0   Purchasing group *
41 WEMPF WEMPF WEMPF CHAR 12   0   Goods recipient  
42 ABLAD ABLAD TEXT25 CHAR 25   0   Unloading Point  
43 TPLNR TPLNR TPLNR CHAR 30   0   Functional Location *
44 EQUNR EQUNR EQUNR CHAR 18   0   Equipment Number *
45 BAUTL BAUTL MATNR CHAR 18   0   Assembly *
46 NTGEW NTGEW_15 MENG15 QUAN 15   3   Net weight  
47 BRGEW BRGEW_15 MENG15 QUAN 15   3   Gross weight  
48 GEWEI GEWEI MEINS UNIT 3   0   Weight Unit *
49 VOLUM VOLUM_15 MENG15 QUAN 15   3   Volume  
50 VOLEH VOLEH MEINS UNIT 3   0   Volume unit *
51 LAENG LAENG MENG13 QUAN 13   3   Length  
52 BREIT BREIT MENG13 QUAN 13   3   Width  
53 HOEHE HOEHE MENG13 QUAN 13   3   Height  
54 MEABM MEABM MEINS UNIT 3   0   Unit of Dimension for Length/Width/Height *
55 BEROT BEROT BEROT CHAR 20   0   Picked items location  
56 XHOLD OIO_HOLD XFELD CHAR 1   0   Indicator: Hold Delivery Onshore  
57 XDELT_OBJ OIO_MT_XDELT FLAG CHAR 1   0   Flag: tracking object is deleted  
58 X_COMPLETE OIO_MT_COMPLETE FLAG CHAR 1   0   Flag: object is complete  
59 SPROC OIO_SPROC OIO_SPROC CHAR 4   0   Supply Process *
60 DATUM OIO_OBJ_DATUM DATUM DATS 8   0   Key date for document flow object  
61 ERDAT OIO_OBJ_ERDAT DATUM DATS 8   0   Create date for document flow  
62 DMDAT OIO_OBJ_DMDAT DATUM DATS 8   0   Demand date for document flow object  
63 SPDAT OIO_OBJ_SPDAT DATE DATS 8   0   Supply date  
64 BLDAT OIO_OBJ_BLDAT DATUM DATS 8   0   Document date for document flow object  
65 BUDAT OIO_OBJ_BUDAT DATUM DATS 8   0   Posting date  
66 US_DETAIL OIO_US_DETAIL   CHAR 50   0   User defined details  
67 US_DATE OIO_US_DATE   DATS 8   0   User defined date  
68 US_QUANT OIO_US_QUANT   QUAN 17   3   User defined quantity  
69 US_UNIT OIO_US_UNIT   UNIT 3   0   Units for user defined quantity  
70 US_DESCR OIO_US_DESCR   CHAR 25   0   User defined description  
71 .INCLUDE       0   0   Texts for document flow object data  
72 OBJTY_TXT OIO_OBJTY_TXT TEXT30 CHAR 30   0   Object type description  
73 MATNR_TXT OIO_MATNR_TXT TEXT40 CHAR 40   0   Material description  
74 BWART_TXT BWTXT BTEXT CHAR 20   0   Movement type text (inventory management)  
75 WERKS_TXT OIO_WERKS_TXT TEXT30 CHAR 30   0   Plant name  
76 LGORT_TXT OIO_LGORT_TXT_16 TEXT16 CHAR 16   0   Store name  
77 UMWRK_TXT OIO_UMWRK_TXT TEXT30 CHAR 30   0   Supplying plant name  
78 UMLGO_TXT OIO_UMLGO_TXT_16 TEXT16 CHAR 16   0   Supplying store name  
79 KUNWE_TXT OIO_KUNWE_TXT TEXT30 CHAR 30   0   Ship-to party name  
80 BUKRS_TXT BUTXT TEXT25 CHAR 25   0   Name of Company Code or Company  
81 KOKRS_TXT BEZEI TEXT25 CHAR 25   0   Name of the controlling area  
82 KOSTL_TXT OIO_KOSTL_TXT TEXT20 CHAR 20   0   Cost centre name  
83 AUFNR_TXT OIO_AUFNR_TXT TEXT20 CHAR 20   0   Order text  
84 PROJK_TXT PS_POST1 TEXT40 CHAR 40   0   PS: Short description (first text line)  
85 GSBER_TXT GTEXT TEXT30 CHAR 30   0   Business area description  
86 PRCTR_TXT OIO_PRCTR_TXT TEXT30 CHAR 30   0   Profit centre name  
87 SPROC_TXT OIO_SPROC_TX OIO_SPROC_TX CHAR 40   0   Supply process text  
88 .INCLUDE       0   0   Container fields for packing tree  
89 CNTNR_TYP_CD OIO_CNTNR_TYP_CD OIO_CNTNR_TYP_CD CHAR 2   0   Container type OIO_CNTNR_TYP
90 CNTNR_ID OIO_CNTNR_ID OIO_CNTNR_ID CHAR 20   0   Container identifier  
91 EXTID OIO_CT_EXTID CHAR25 CHAR 25   0   Container external identifier  
92 XRENT OIO_CT_XRENT   CHAR 1   0   Flag: Container is rented  
93 OWNER OIO_CT_OWNER LIFNR CHAR 10   0   Container owner LFA1
94 CERT_NR OIO_CT_CERT_NR OIO_CT_CERT_NR CHAR 20   0   Container certificate number  
95 CERT_DT OIO_CT_CERT_DT DATE DATS 8   0   Container last certification date  
96 CERT_DT_NEXT OIO_CT_CERT_DT_NEXT DATE DATS 8   0   Container next certification date  
97 RENT_DT OIO_CT_RENT_DT DATE DATS 8   0   Container rental date  
98 EXP_DT OIO_CT_EXP_DT DATE DATS 8   0   Container rental expiry date  
99 XTPTY OIO_CT_XTPTY   CHAR 1   0   Flag: Container is owned by third party  
100 TP_OWNER OIO_CT_TP_OWNER LIFNR CHAR 10   0   Container third party owner LFA1
101 LENGTH OIO_CT_LENGTH   QUAN 13   3   Container length  
102 WIDTH OIO_CT_WIDTH   QUAN 13   3   Container width  
103 HEIGHT OIO_CT_HEIGHT   QUAN 13   3   Container height  
104 DIM_UN OIO_CT_DIM_UNIT MEINS UNIT 3   0   Container dimensions unit *
105 FOOTPRINT OIO_CT_FOOTPRINT   QUAN 13   3   Container footprint  
106 FOOTPRINT_UN OIO_CT_FOOTPRINT_UN MEINS UNIT 3   0   Container footprint unit T006
107 WEIGHT OIO_CT_WEIGHT   QUAN 13   3   Container tare weight  
108 WEIGHT_UN OIO_CT_WEIGHT_UN MEINS UNIT 3   0   Container tare weight unit T006
109 SAFE_LOAD OIO_CT_SAFE_LOAD   QUAN 13   3   Container safe load  
110 SAFE_LOAD_UN OIO_CT_SAFE_LOAD_UN MEINS UNIT 3   0   Container safe load unit T006
111 MAX_WEIGHT OIO_CT_MAX_WEIGHT   QUAN 13   3   Container maximum gross weight  
112 MAX_WEIGHT_UN OIO_CT_MAX_WEIGHT_UN MEINS UNIT 3   0   Container maximum gross weight unit T006
113 XDELT OIO_CT_XDELT XFELD CHAR 1   0   Flag: Container is deleted  
114 XBLCK OIO_CT_XBLCK XFELD CHAR 1   0   Flag: Container is blocked  
115 XACTV OIO_CT_XACTV   CHAR 1   0   Flag: Container is active  
116 CNTNR_LABEL OIO_CNTNR_LABEL TEXT20 CHAR 20   0   Container label  
117 CNTNR_NAME OIO_CNTNR_NAME TEXT50 CHAR 50   0   Container name  
118 .INCLUDE       0   0   Delivery fields for packing tree  
119 VBELN VBELN_VL VBELN CHAR 10   0   Delivery *
120 VSTEL VSTEL VSTEL CHAR 4   0   Shipping Point/Receiving Point TVST
121 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
122 LFART LFART LFART CHAR 4   0   Delivery Type TVLK
123 WADAT WADAK DATUM DATS 8   0   Planned goods movement date  
124 LDDAT LDDAT DATUM DATS 8   0   Loading Date  
125 TDDAT TDDAT_D DATUM DATS 8   0   Transportation Planning Date  
126 LFDAT LFDAT_V DATUM DATS 8   0   Delivery Date  
127 KODAT KODAT DATUM DATS 8   0   Picking Date  
128 LIFSK LIFSK LIFSP CHAR 2   0   Delivery block (document header) TVLS
129 KUNNR_DLV KUNWE KUNNR CHAR 10   0   Ship-to party *
130 KUNAG KUNAG KUNNR CHAR 10   0   Sold-to party KNA1
131 LSTEL LSTEL LSTEL CHAR 2   0   Loading Point TVLA
132 TRAGR TRAGR TRAGR CHAR 4   0   Transportation Group TTGR
133 LGNUM LGNUM LGNUM CHAR 3   0   Warehouse Number / Warehouse Complex T300
134 TRSPG TRSPG TRSPG CHAR 2   0   Shipment Blocking Reason TTSG
135 XBLNR XBLNR_LIKP XBLNR_LIKP CHAR 25   0   Reference Document Number  
136 VBUND VBUND RCOMP CHAR 6   0   Company ID *
137 OIO_HOLD OIO_HOLD XFELD CHAR 1   0   Indicator: Hold Delivery Onshore  
138 ICON_HOLD OIO_ICON_ID ICON CHAR 4   0   Icon identifier *
139 OIO_HOLD_ORIG OIO_HOLD_ORIG XFELD CHAR 1   0   Flag: delivery was originally held onshore  
140 POSNR POSNR_VL POSNR NUMC 6   0   Delivery Item VBUP
141 PSTYV PSTYV_VL PSTYV CHAR 4   0   Delivery item category TVPT
142 ARKTX ARKTX TEXT40 CHAR 40   0   Short text for sales order item  
143 LGTYP LGTYP LGTYP CHAR 3   0   Storage Type T301
144 LGPLA LGPLA LGPLA CHAR 10   0   Storage Bin LAGP
145 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVBUR
146 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVKGR
147 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
148 SPART SPART SPART CHAR 2   0   Division TSPA
149 GRKOR GRKOR GRKOR NUMC 3   0   Delivery group (items are delivered together)  
150 SOBKZ SOBKZ SOBKZ CHAR 1   0   Special Stock Indicator T148
151 UMMAT UMMAT MATNR CHAR 18   0   Receiving/issuing material *
152 UMBAR UMBAR BWTAR CHAR 10   0   Valuation type of transfer batch *
153 UMSOK UMSOK SOBKZ CHAR 1   0   Special stock indicator for physical stock transfer *
154 MBLNR MBLNR BELNR CHAR 10   0   Number of Material Document  
155 MJAHR MJAHR GJAHR NUMC 4   0   Year of material document  
156 ZEILE MBLPO MBLPO NUMC 4   0   Item in material document  
157 RTDOC OIO_RT_DOCNR OIO_RT_DOCNR CHAR 10   0   Returns document number *
158 RTDLN OIO_RT_DOCLN OIO_RT_DOCLN NUMC 4   0   Returns document item number  
159 PS_PSP_PNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) *
160 .INCLUDE       0   0   Shipping units fields for packing tree  
161 EXIDV EXIDV EXIDV CHAR 20   0   External Handling Unit Identification  
162 EXIDA EXIDA EXIDA CHAR 1   0   Type of External Handling Unit Identifier  
163 ANZGL ANZGL ANZGL INT4 10   0   Number of Similar Packaging Materials  
164 SORTL SORTL CHAR10 CHAR 10   0   Sort field  
165 VEGR1 VEGR1 VEGR1 CHAR 5   0   Handling Unit Group 1 (Freely Definable) *
166 VEGR2 VEGR2 VEGR2 CHAR 5   0   Handling Unit Group 2 (Freely Definable) *
167 VEGR3 VEGR3 VEGR3 CHAR 5   0   Handling Unit Group 3 (Freely Definable) *
168 VEGR4 VEGR4 VEGR4 CHAR 5   0   Handling Unit Group 4 (Freely Definable) *
169 VEGR5 VEGR5 VEGR5 CHAR 5   0   Handling Unit Group 5 (Freely Definable) *
170 VHILM VHILM MATNR CHAR 18   0   Packaging Materials *
171 GEWTO GEWTO PRZ21 DEC 3   1   Excess weight tolerance for shipping unit  
172 VOLTO VOLTO PRZ21 DEC 3   1   Excess volume tolerance limit during packing  
173 VOLEH_MAX VOLEH MEINS UNIT 3   0   Volume unit *
174 GEWEI_MAX GEWEI MEINS UNIT 3   0   Weight Unit *
175 INHALT INHALT TEXT40 CHAR 40   0   Description of Handling Unit Content  
176 VHART VHIART TRATY CHAR 4   0   Shipping material type *
177 MAGRV MAGRV MAGRV CHAR 4   0   Material Group: Packaging Materials *
178 OIO_CNTNR_TYP_CD OIO_CNTNR_TYP_CD OIO_CNTNR_TYP_CD CHAR 2   0   Container type *
179 OIO_CNTNR_STATUS OIO_CNTNR_STATUS OIO_CNTNR_STATUS CHAR 1   0   Status of container in shipping unit  
180 .INCLUDE       0   0   Shipment fields for packing tree  
181 TKNUM TKNUM TKNUM CHAR 10   0   Shipment Number *
182 SHTYP SHTYP SHTYP CHAR 4   0   Shipment type TVTK
183 TPLST TPLST TPLST CHAR 4   0   Transportation planning point TTDS
184 VSART VSARTTR VERSART CHAR 2   0   Shipping type T173
185 VSBED VSBED VSBED CHAR 2   0   Shipping conditions TVSB
186 ROUTE ROUTR ROUTE CHAR 6   0   Shipment route TVRO
187 SIGNI SIGNI TEXT20 CHAR 20   0   Container ID  
188 EXTI1 EXTI1 TEXT20 CHAR 20   0   External identification 1  
189 EXTI2 EXTI2 TEXT20 CHAR 20   0   External identification 2  
190 TPBEZ TPBEZ TEXT20 CHAR 20   0   Description of Shipment  
191 STDIS STDIS STTRA CHAR 1   0   Status of transportation planning  
192 STREG STREG STTRA CHAR 1   0   Status of check-in  
193 STLBG STLBG STTRA CHAR 1   0   Status for start of loading  
194 STLAD STLAD STTRA CHAR 1   0   Status for end of loading  
195 STABF STABF STTRA CHAR 1   0   Status of shipment completion  
196 STTBG STTBG STTRA CHAR 1   0   Status for start of shipment  
197 STTEN STTEN STTRA CHAR 1   0   Status for end of shipment  
198 STTRG STTRG STTRG CHAR 1   0   Overall transportation status  
199 TDLNR TDLNR LIFNR CHAR 10   0   Number of forwarding agent LFA1
200 TERNR AUFNR AUFNR CHAR 12   0   Order Number *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ROIO_SP_TREE CNTNR_TYP_CD OIO_CNTNR_TYP CNTNR_TYP_CD KEY C CN
2 ROIO_SP_TREE FOOTPRINT_UN T006 MSEHI    
3 ROIO_SP_TREE KUNAG KNA1 KUNNR REF C CN
4 ROIO_SP_TREE LFART TVLK LFART REF C CN
5 ROIO_SP_TREE LGNUM T300 LGNUM REF C CN
6 ROIO_SP_TREE LGPLA LAGP LGPLA REF C CN
7 ROIO_SP_TREE LGTYP T301 LGTYP REF C CN
8 ROIO_SP_TREE LIFSK TVLS LIFSP REF C CN
9 ROIO_SP_TREE LSTEL TVLA LSTEL REF C CN
10 ROIO_SP_TREE MAX_WEIGHT_UN T006 MSEHI REF C CN
11 ROIO_SP_TREE OWNER LFA1 LIFNR    
12 ROIO_SP_TREE POSNR VBUP POSNR KEY 1 C
13 ROIO_SP_TREE PSTYV TVPT PSTYV REF 1 CN
14 ROIO_SP_TREE ROUTE TVRO ROUTE REF C CN
15 ROIO_SP_TREE SAFE_LOAD_UN T006 MSEHI    
16 ROIO_SP_TREE SHTYP TVTK SHTYP REF 1 CN
17 ROIO_SP_TREE SOBKZ T148 SOBKZ REF C CN
18 ROIO_SP_TREE SPART TSPA SPART REF C CN
19 ROIO_SP_TREE TDLNR LFA1 LIFNR REF 1 CN
20 ROIO_SP_TREE TPLST TTDS TPLST REF 1 CN
21 ROIO_SP_TREE TP_OWNER LFA1 LIFNR    
22 ROIO_SP_TREE TRAGR TTGR TRAGR REF C CN
23 ROIO_SP_TREE TRSPG TTSG TRSPG REF C CN
24 ROIO_SP_TREE VKBUR TVBUR VKBUR REF C CN
25 ROIO_SP_TREE VKGRP TVKGR VKGRP REF C CN
26 ROIO_SP_TREE VKORG TVKO VKORG REF C CN
27 ROIO_SP_TREE VSART T173 VSART REF C CN
28 ROIO_SP_TREE VSBED TVSB VSBED REF C CN
29 ROIO_SP_TREE VSTEL TVST VSTEL REF 1 CN
30 ROIO_SP_TREE VTWEG TVTW VTWEG REF C CN
31 ROIO_SP_TREE WEIGHT_UN T006 MSEHI    
History
Last changed by/on SAP  20130529 
SAP Release Created in