SAP ABAP Table LIPS (SD document: Delivery: Item data)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       VL (Package) WS-SHP: General Processing for Shipping
Basic Data
Table Category TRANSP    Transparent table 
Transparent table LIPS   Table Relationship Diagram
Short Description SD document: Delivery: Item data    
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 T000
2 VBELN VBELN_VL VBELN CHAR 10   0   Delivery VBUK
3 POSNR POSNR_VL POSNR NUMC 6   0   Delivery Item VBUP
4 PSTYV PSTYV_VL PSTYV CHAR 4   0   Delivery item category TVPT
5 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
6 ERZET ERZET UZEIT TIMS 6   0   Entry time  
7 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
8 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
9 MATWA MATWA MATNR CHAR 18   0   Material entered MARA
10 MATKL MATKL MATKL CHAR 9   0   Material Group T023
11 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
12 LGORT LGORT_D LGORT CHAR 4   0   Storage location T001L
13 CHARG CHARG_D CHARG CHAR 10   0   Batch Number MCHA
14 LICHN LICHN LICHN CHAR 15   0   Vendor Batch Number  
15 KDMAT KDMAT IDNEX CHAR 35   0   Material belonging to the customer  
16 PRODH PRODH_D PRODH CHAR 18   0   Product Hierarchy T179
17 LFIMG LFIMG MENG13 QUAN 13   3   Actual quantity delivered (in sales units)  
18 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure T006
19 VRKME VRKME MEINS UNIT 3   0   Sales unit T006
20 UMVKZ UMVKZ UMBSZ DEC 5   0   Numerator (factor) for conversion of sales quantity into SKU  
21 UMVKN UMVKN UMBSN DEC 5   0   Denominator (divisor) for conversion of sales qty. into SKU  
22 NTGEW NTGEW_15 MENG15 QUAN 15   3   Net weight  
23 BRGEW BRGEW_15 MENG15 QUAN 15   3   Gross weight  
24 GEWEI GEWEI MEINS UNIT 3   0   Weight Unit T006
25 VOLUM VOLUM_15 MENG15 QUAN 15   3   Volume  
26 VOLEH VOLEH MEINS UNIT 3   0   Volume unit T006
27 KZTLF KZTLF KZTLF CHAR 1   0   Partial delivery at item level  
28 UEBTK UEBTK XFELD CHAR 1   0   Indicator: Unlimited Overdelivery Allowed  
29 UEBTO UEBTO PRZ21 DEC 3   1   Overdelivery Tolerance Limit  
30 UNTTO UNTTO PRZ21 DEC 3   1   Underdelivery Tolerance Limit  
31 CHSPL CHSPL XFELD CHAR 1   0   Batch split allowed  
32 FAKSP FAKSP FAKSP CHAR 2   0   Lock TVFS
33 MBDAT MBDAT DATUM DATS 8   0   Material Staging/Availability Date  
34 LGMNG LGMNG MENG13 QUAN 13   3   Actual quantity delivered in stockkeeping units  
35 ARKTX ARKTX TEXT40 CHAR 40   0   Short text for sales order item  
36 LGPBE LGPBE CHAR10 CHAR 10   0   Storage Bin  
37 VBELV VBELV VBELN CHAR 10   0   Originating document VBUK
38 POSNV POSNV POSNR NUMC 6   0   Originating item VBUP
39 VBTYV VBTYP VBTYP CHAR 1   0   SD document category  
40 VGSYS VGLOGSYS LOGSYS CHAR 10   0   Logical System in the Preceding Document TBDLS
41 VGBEL VGBEL VBELN CHAR 10   0   Document number of the reference document VBUK
42 VGPOS VGPOS POSNR NUMC 6   0   Item number of the reference item VBUP
43 UPFLU UPFLL UPFLL CHAR 1   0   Update indicator for delivery document flow  
44 UEPOS UEPOS POSNR NUMC 6   0   Higher-level item in bill of material structures VBUP
45 FKREL FKREL FKREL CHAR 1   0   Relevant for Billing  
46 LADGR LADGR LADGR CHAR 4   0   Loading Group TLGR
47 TRAGR TRAGR TRAGR CHAR 4   0   Transportation Group TTGR
48 KOMKZ KOMKZ KOMKZ CHAR 1   0   Indicator for picking control  
49 LGNUM LGNUM LGNUM CHAR 3   0   Warehouse Number / Warehouse Complex T300
50 LISPL LNSPL_LIPS LNSPL_LIPS CHAR 1   0   Split to warehouse number required  
51 LGTYP LGTYP LGTYP CHAR 3   0   Storage Type T301
52 LGPLA LGPLA LGPLA CHAR 10   0   Storage Bin LAGP
53 BWTEX BWTEX XFELD CHAR 1   0   Indicator: Separate valuation  
54 BWART BWART BWART CHAR 3   0   Movement type (inventory management) T156
55 BWLVS BWLVS BWLVS NUMC 3   0   Movement Type for Warehouse Management T333
56 KZDLG LVS_KZDLG XFELD CHAR 1   0   Indicator: dynamic storage bin in warehouse management  
57 BDART BDART BDART CHAR 2   0   Requirement type  
58 PLART PLART PLART CHAR 1   0   Planning type *
59 MTART MTART MTART CHAR 4   0   Material type T134
60 XCHPF XCHPF XFELD CHAR 1   0   Batch management requirement indicator  
61 XCHAR XCHAR XFELD CHAR 1   0   Batch management indicator (internal)  
62 VGREF VGREF XFELD CHAR 1   0   Preceding document has resulted from reference  
63 POSAR POSAR POSAR CHAR 1   0   Item type  
64 BWTAR BWTAR_D BWTAR CHAR 10   0   Valuation type T149D
65 SUMBD SUMBD SUMBD CHAR 1   0   Summing up of requirements  
66 MTVFP MTVFP MTVFP CHAR 2   0   Checking Group for Availability Check TMVF
67 EANNR EANNR CHAR13 CHAR 13   0   European Article Number (EAN) - obsolete!!!!!  
68 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
69 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVBUR
70 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVKGR
71 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
72 SPART SPART SPART CHAR 2   0   Division TSPA
73 GRKOR GRKOR GRKOR NUMC 3   0   Delivery group (items are delivered together)  
74 FMENG FMENG XFELD CHAR 1   0   Quantity is fixed  
75 ANTLF ANTLF ANTLF DEC 1   0   Maximum number of partial deliveries allowed per item  
76 VBEAF VBEAF DEC3_2 DEC 5   2   Fixed shipping processing time in days (= setup time)  
77 VBEAV VBEAV DEC3_2 DEC 5   2   Variable shipping processing time in days  
78 STAFO STAFO STAFO CHAR 6   0   Update group for statistics update *
79 WAVWR WAVWR WERTV7 CURR 13   2   Cost in document currency  
80 KZWI1 KZWI1 WERTV7 CURR 13   2   Subtotal 1 from pricing procedure for condition  
81 KZWI2 KZWI2 WERTV7 CURR 13   2   Subtotal 2 from pricing procedure for condition  
82 KZWI3 KZWI3 WERTV7 CURR 13   2   Subtotal 3 from pricing procedure for condition  
83 KZWI4 KZWI4 WERTV7 CURR 13   2   Subtotal 4 from pricing procedure for condition  
84 KZWI5 KZWI5 WERTV7 CURR 13   2   Subtotal 5 from pricing procedure for condition  
85 KZWI6 KZWI6 WERTV7 CURR 13   2   Subtotal 6 from pricing procedure for condition  
86 SOBKZ SOBKZ SOBKZ CHAR 1   0   Special Stock Indicator T148
87 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
88 EAN11 EAN11 EAN11 CHAR 18   0   International Article Number (EAN/UPC)  
89 KVGR1 KVGR1 KVGR1 CHAR 3   0   Customer group 1 TVV1
90 KVGR2 KVGR2 KVGR2 CHAR 3   0   Customer group 2 TVV2
91 KVGR3 KVGR3 KVGR3 CHAR 3   0   Customer group 3 TVV3
92 KVGR4 KVGR4 KVGR4 CHAR 3   0   Customer group 4 TVV4
93 KVGR5 KVGR5 KVGR5 CHAR 3   0   Customer group 5 TVV5
94 MVGR1 MVGR1 MVGR1 CHAR 3   0   Material group 1 TVM1
95 MVGR2 MVGR2 MVGR2 CHAR 3   0   Material group 2 TVM2
96 MVGR3 MVGR3 MVGR3 CHAR 3   0   Material group 3 TVM3
97 MVGR4 MVGR4 MVGR4 CHAR 3   0   Material group 4 TVM4
98 MVGR5 MVGR5 MVGR5 CHAR 3   0   Material group 5 TVM5
99 VPZUO VPZUO ZUVKZ CHAR 1   0   Allocation Indicator  
100 VGTYP VBTYP VBTYP CHAR 1   0   SD document category  
101 RFVGTYP RFVGTYP VBTYP CHAR 1   0   Type of preceding document in central system  
102 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center CSKS
103 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
104 PAOBJNR RKEOBJNR RKEOBJNR NUMC 10   0   Profitability Segment Number (CO-PA)  
105 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
106 PS_PSP_PNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) *
107 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
108 POSNR_PP CO_POSNR CO_POSNR NUMC 4   0   Order item number  
109 KDAUF KDAUF VBELN CHAR 10   0   Sales Order Number *
110 KDPOS KDPOS NUM06 NUMC 6   0   Item number in Sales Order  
111 VPMAT VPMAT MATNR CHAR 18   0   Planning material MARA
112 VPWRK VPWRK WERKS CHAR 4   0   Planning plant T001W
113 PRBME PRBME MEINS UNIT 3   0   Base unit of measure for product group T006
114 UMREF UMREFF FLTP FLTP 16   16   Conversion factor: quantities  
115 KNTTP KNTTP KNTTP CHAR 1   0   Account assignment category T163K
116 KZVBR KZVBR KZVBR CHAR 1   0   Consumption posting  
117 FIPOS FIPOS FIPOS CHAR 14   0   Commitment Item *
118 FISTL FISTL FISTL CHAR 16   0   Funds Center *
119 GEBER BP_GEBER BP_GEBER CHAR 10   0   Fund *
120 PCKPF PCKPF PCKPF CHAR 1   0   Packing control  
121 BEDAR_LF BEDAR BEDAR CHAR 3   0   Requirements class T459K
122 CMPNT CMPNT XFELD CHAR 1   0   ID: Item with active credit function / relevant for credit  
123 KCMENG KCMENG MENG15 QUAN 15   3   Cumulative batch quantity of all split items (in StckUnit)  
124 KCBRGEW KCBRGEW MENG15 QUAN 15   3   Cumulative gross weight of all batch split items  
125 KCNTGEW KCNTGEW MENG15 QUAN 15   3   Cumulative net weight of all batch split items  
126 KCVOLUM KCVOLUM MENG15 QUAN 15   3   Cumulative volume of all batch split items  
127 UECHA UECHA POSNR NUMC 6   0   Higher-Level Item of Batch Split Item LIPS
128 CUOBJ CUOBJ_VA CUOBJ NUMC 18   0   Configuration  
129 CUOBJ_CH CUOBJ_CH CUOBJ NUMC 18   0   Internal object number of the batch classification  
130 ANZSN ANZSN INT4 INT4 10   0   Number of serial numbers  
131 SERAIL SERAIL SERAIL CHAR 4   0   Serial Number Profile T377P
132 KCGEWEI GEWEI MEINS UNIT 3   0   Weight Unit T006
133 KCVOLEH VOLEH MEINS UNIT 3   0   Volume unit T006
134 SERNR SERNR SERNR CHAR 8   0   BOM explosion number SNUM
135 ABRLI ABRLI ABRLI NUMC 4   0   Internal delivery schedule number VBLB
136 ABART ABART ABART CHAR 1   0   Release type  
137 ABRVW ABRVW ABRVW CHAR 3   0   Usage Indicator TVLV
138 QPLOS QPLOS QPLOS NUMC 12   0   Inspection Lot Number QALS
139 QTLOS QTLOS QTLOS NUMC 6   0   Partial lot number *
140 NACHL NACHL XFELD CHAR 1   0   Customer has not posted goods receipt  
141 MAGRV MAGRV MAGRV CHAR 4   0   Material Group: Packaging Materials TVEGR
142 OBJKO OBJKO J_OBJNR CHAR 22   0   Object number at header level *
143 OBJPO OBJPO J_OBJNR CHAR 22   0   Object number at item level *
144 AESKD AESKD AESKD CHAR 17   0   Customer Engineering Change Status  
145 SHKZG SHKZG_VA XFELD CHAR 1   0   Returns Item  
146 PROSA PROSA PROSA CHAR 1   0   ID for material selection - active  
147 UEPVW UEPVW UEPVW CHAR 1   0   ID for higher-level item usage  
148 EMPST EMPST TEXT25 CHAR 25   0   Receiving point  
149 ABTNR ABTNR ABTNR CHAR 4   0   Department number TSAB
150 KOQUI KOQUI XFELD CHAR 1   0   Picking is subject to confirmation  
151 STADAT STADAT DATUM DATS 8   0   Statistics date  
152 AKTNR WAKTION WAKTION CHAR 10   0   Promotion WAKH
153 KNUMH_CH KNUMH_CH KNUMB CHAR 10   0   Number of condition record from batch determination  
154 PREFE PREFE PREFE CHAR 1   0   Preference indicator in export/import  
155 EXART EXART EXART CHAR 2   0   Business Transaction Type for Foreign Trade *
156 CLINT CLINT CLINT NUMC 10   0   Internal Class Number KLAH
157 CHMVS CHMVS NUM3 NUMC 3   0   Batches: Exit to quantity proposal  
158 ABELN ABELN ABELN CHAR 10   0   Allocation Table Number AUKO
159 ABELP ABELP ABELP NUMC 5   0   Item number of allocation table AUPO
160 LFIMG_FLO LFIMG_FLO FLTP FLTP 16   16   Internal field/ Do not use / LFIMG in float / MUM  
161 LGMNG_FLO LGMNG_FLO FLTP FLTP 16   16   Internal field/ Do not use / LGMNG in float / MUM  
162 KCMENG_FLO KCMENG_FLO FLTP FLTP 16   16   Internal field/ Do not use / KCMENG in float / MUM  
163 KZUMW KZUMW XFELD CHAR 1   0   Indicator: Environmentally relevant  
164 KMPMG KMPMG MENGV13 QUAN 13   3   Component Quantity  
165 AUREL AUREL AUREL CHAR 1   0   Relevant to Allocation Table  
166 KPEIN KPEIN KPEIN DEC 5   0   Condition pricing unit  
167 KMEIN KMEIN MEINS UNIT 3   0   Condition Unit T006
168 NETPR NETPR WERTV6 CURR 11   2   Net price  
169 NETWR NETWR WERTV8 CURR 15   2   Net Value in Document Currency  
170 KOWRR KOWRR KOWRR CHAR 1   0   Statistical values  
171 KZBEW KZBEW KZBEW CHAR 1   0   Movement Indicator  
172 MFRGR MFRGR MFRGR CHAR 8   0   Material freight group TMFG
173 CHHPV CHHPV XFELD CHAR 1   0   Pack accumulated batches / movement type item  
174 ABFOR ABSFORM_CM ABSFORM_CM CHAR 2   0   Form of payment guarantee T691K
175 ABGES ABGES_CM FLTP FLTP 16   16   Guaranteed (factor between 0 and 1)  
176 MBUHR MBUHR TIME_PLANT TIMS 6   0   Material Staging Time (Local, Relating to a Plant)  
177 WKTNR WKTNR VBELN CHAR 10   0   Value contract no. VBUK
178 WKTPS WKTPS POSNR NUMC 6   0   Value contract item VBUP
179 J_1BCFOP J_1BCFOP J_1BCFOP CHAR 10   0   CFOP code and extension J_1BAG
180 J_1BTAXLW1 J_1BTAXLW1 J_1BTAXLW1 CHAR 3   0   Tax law: ICMS J_1BATL1
181 J_1BTAXLW2 J_1BTAXLW2 J_1BTAXLW2 CHAR 3   0   Tax law: IPI J_1BATL2
182 J_1BTXSDC J_1BTXSDC_ J_1BTXSDC CHAR 2   0   SD tax code J_1BTXSDC
183 SITUA SITUA SITUA CHAR 2   0   Indicator for situation *
184 RSNUM RSNUM RSNUM NUMC 10   0   Number of reservation/dependent requirements *
185 RSPOS RSPOS RSPOS NUMC 4   0   Item Number of Reservation / Dependent Requirements  
186 RSART RSART RSART CHAR 1   0   Record type  
187 KANNR KANNR CHAR35 CHAR 35   0   KANBAN/sequence number  
188 KZFME KZFME KZFME CHAR 1   0   ID: Leading unit of measure for completing a transaction  
189 PROFL ADGE_PROFL ADGD_PROFL CHAR 3   0   Dangerous goods indicator profile TDG41
190 KCMENGVME KCMENG_VME MENGV15_3 QUAN 15   3   Cumulative batch quantity of all split items in sales units  
191 KCMENGVMEF KCMENGVMEF FLTP FLTP 16   16   Cumulated batch split quantity in VRKME and float  
192 KZBWS KZBWS KZBWS CHAR 1   0   Valuation of Special Stock  
193 PSPNR PS_INTNR PS_PSPNR NUMC 8   0   Current number for project or project item *
194 EPRIO EPRIO EPRIO CHAR 4   0   Withdrawal sequence group for stocks *
195 RULES BF_RULES BF_RULES CHAR 4   0   Stock determination rule T434R
196 KZBEF LVS_KZBEF XFELD CHAR 1   0   Indicator Inventory Management active  
197 MPROF MPROF MPROF CHAR 4   0   Mfr part profile *
198 EMATN EMATN MATNR CHAR 18   0   Material number corresponding to manufacturer part number MARA
199 LGBZO LGBZO LGBZO CHAR 10   0   Staging Area for Warehouse Complex T30C
200 HANDLE TSEGGUID_LIPS SYSUUID_22 CHAR 22   0   Worldwide unique key for LIPS-VBELN & LIPS_POSNR  
201 VERURPOS VERURPOS POSNR NUMC 6   0   Distribution delivery: Original item *
202 LIFEXPOS LIFEXPOS POSNR NUMC 6   0   External item number *
203 NOATP NO_ATP_CHECK NO_ATP_CHECK CHAR 1   0   Indicator: deactivate availability check  
204 NOPCK NO_PICKING XFELD CHAR 1   0   Indicator: not relevant for picking  
205 RBLVS RBLVS LVS_BWREF NUMC 3   0   Reference movement type for WM from material movements  
206 BERID BERID BERID CHAR 10   0   MRP Area MDLV
207 BESTQ BESTQ BESTQ CHAR 1   0   Stock Category in the Warehouse Management System  
208 UMBSQ BESTQ BESTQ CHAR 1   0   Stock Category in the Warehouse Management System  
209 UMMAT UMMAT MATNR CHAR 18   0   Receiving/issuing material *
210 UMWRK UMWRK WERKS CHAR 4   0   Receiving plant/issuing plant *
211 UMLGO UMLGO LGORT CHAR 4   0   Receiving/issuing storage location *
212 UMCHA UMCHA CHARG CHAR 10   0   Receiving/issuing batch *
213 UMBAR UMBAR BWTAR CHAR 10   0   Valuation type of transfer batch *
214 UMSOK UMSOK SOBKZ CHAR 1   0   Special stock indicator for physical stock transfer *
215 SONUM LVS_SONUM LVS_SONUM CHAR 16   0   Special Stock Number  
216 USONU LVS_SONUM LVS_SONUM CHAR 16   0   Special Stock Number  
217 AKKUR AKKUR KURRF DEC 9   5   Exchange rate for letter-of-credit procg in foreign trade  
218 AKMNG AKMNG AKMNG CHAR 1   0   Current Qty Field for Arithmetic Operations in Doc.Process.  
219 VKGRU VKGRU RMA_VORGA CHAR 3   0   Repair processing: Classify items *
220 SHKZG_UM SHKZG_UM SHKZG_UM CHAR 1   0   Indicator: UNMAT in main posting  
221 INSMK MB_INSMK MB_INSMK CHAR 1   0   Stock Type  
222 KZECH KZECH KZECH CHAR 1   0   Determination of batch entry in the production/process order  
223 FLGWM FLGWM FLGWM CHAR 1   0   Indicator: Copy dest. storage data from preceding document  
224 BERKZ BERKZ LVS_BERKZ CHAR 1   0   Material Staging Indicator for Production Supply  
225 HUPOS HUPOS HUPOS CHAR 1   0   Indicator: Delivery item is a HU item  
226 NOWAB NOWAB NOWAB CHAR 1   0   Indicator: Item Not Relevant for Goods Movements  
227 KONTO SAKNR SAKNR CHAR 10   0   G/L Account Number *
228 KZEAR KZEAR XFELD CHAR 1   0   Final issue for this reservation  
229 HSDAT HSDAT DATUM DATS 8   0   Date of Manufacture  
230 VFDAT VFDAT DATUM DATS 8   0   Shelf Life Expiration or Best-Before Date  
231 LFGJA LFGJA GJAHR NUMC 4   0   Fiscal Year of Current Period  
232 LFBNR LFBNR BELNR CHAR 10   0   Document number of a reference document  
233 LFPOS LFPOS MBLPO NUMC 4   0   Item of a reference document  
234 GRUND MB_GRUND NUMC4 NUMC 4   0   Reason for goods movment  
235 FOBWA FOBWA BWART CHAR 3   0   Subsequent movement type *
236 DLVTP DLVTP DLVTP CHAR 2   0   Delivery Category  
237 EXBWR EXBWR WERT7 CURR 13   2   Externally Entered Posting Amount in Local Currency  
238 BPMNG BPMNG MENG13 QUAN 13   3   Quantity in order price quantity unit  
239 EXVKW EXVKW WERT7 CURR 13   2   Externally Entered Sales Value in Local Currency  
240 CMPRE_FLT CMPRE_FLT FLTP FLTP 16   16   Item credit price  
241 KZPOD KZPOD KZPOD CHAR 1   0   POD indicator (relevance, verification, confirmation)  
242 LFDEZ LFDEZ LFDEZ CHAR 1   0   Not relevant for distribution for WMS  
243 UMREV LE_UMREV FLTP FLTP 16   16   Conversion Factor of Delivery Quantity VRKME for MEINS  
244 PODREL PODREL PODREL CHAR 1   0   POD Control (Proof of Delivery)  
245 KZUML KZUML XFELD CHAR 1   0   Stock Transfer/Transfer Posting  
246 FKBER FKBER FKBER CHAR 16   0   Functional Area *
247 GRANT_NBR GM_GRANT_NBR GM_GRANT_NBR CHAR 20   0   Grant  
248 KZWSO KZWSO KZWSO CHAR 1   0   Units of measure usage  
249 GMCONTROL GMCONTROL GMCONTROL CHAR 1   0   Goods Movement Control  
250 POSTING_CHANGE POSTING_CHANGE POSTING_CHANGE CHAR 1   0   Goods Movement Control: HU  
251 UM_PS_PSP_PNR UM_PS_PSP_PNR PS_POSNR NUMC 8   0   Receiving/Issuing (WBS Element) *
252 PRE_VL_ETENS ETENS NUM04 NUMC 4   0   Sequential Number of Vendor Confirmation  
253 SPE_GEN_ELIKZ ELIKZ XFELD CHAR 1   0   "Delivery Completed" Indicator  
254 SPE_SCRAP_IND /SPE/DELIVERY_SCRAP_IND /SPE/DELIVERY_SCRAP_IND CHAR 1   0   Scrap Indicator for EWM Processing  
255 SPE_AUTH_NUMBER /SPE/RET_RMA /SPE/RET_RMA CHAR 20   0   Return Material Authorization Number  
256 SPE_INSPOUT_GUID /SPE/INSP_OUT_GUID_16 /SPE/RET_GUID16 RAW 16   0   Inspections: Inspection outcome GUID set by EWM  
257 SPE_FOLLOW_UP /SPE/RET_FOLLOW_UP /SPE/RET_FOLLOW_UP CHAR 4   0   Default Follow-Up Activity Code  
258 SPE_EXP_DATE_EXT /SPE/RET_EXPIRY_DATE_EXT TZNTSTMPS DEC 15   0   End date of validity period of returns delivery  
259 SPE_EXP_DATE_INT /SPE/RET_EXPIRY_DATE_INT TZNTSTMPS DEC 15   0   End date of internal validity period of returns delivery  
260 SPE_AUTH_COMPLET /SPE/RET_RMA_COMPLETED /SPE/RET_RMA_COMPLETED CHAR 1   0   RMA completion indicator  
261 ORMNG ORMNG_VL MENG13 QUAN 13   3   Original Quantity of Delivery Item  
262 SPE_ATP_TMSTMP /SPE/DE_ATP_TIMESTAMP TZNTSTMPS DEC 15   0   ATP Time Stamp  
263 SPE_ORIG_SYS /SPE/INB_ORIGIN_SYS /SPE/SYSTYPE_SHORT CHAR 1   0   Original System Type  
264 SPE_LIEFFZ /SPE/LIEFFZ MENG15 QUAN 15   3   Cumulative Qty for SchedAgr - Vendor's Point of View  
265 SPE_IMWRK /SPE/IMWRK_ITEM XFELD CHAR 1   0   Inbound Delivery item has Status 'In Plant'  
266 SPE_LIFEXPOS2 /SPE/DE_EXT_IDENT CHAR35 CHAR 35   0   External item identifier  
267 SPE_EXCEPT_CODE /SPE/INB_EXCEPT_CODE_WM /SPE/EXCEPT_CODE_WM CHAR 4   0   Exception Code Warehouse for Quantity Difference  
268 SPE_KEEP_QTY /SPE/KEEP_QUANTITY MENG13 QUAN 13   3   Retention Quantity for Scrap. Process in EWM  
269 SPE_ALTERNATE /SPE/DE_ALTERNATE_PART_NR /SPE/DE_ALTERNATE_PART_NR CHAR 40   0   Alternate Product Number  
270 SPE_MAT_SUBST /SPE/MAT_SUBST /SPE/MAT_SUBST CHAR 1   0   Reason for material substitution  
271 SPE_STRUC /SPE/STRUC   NUMC 3   0   Structure of Items That Are Delivered Together  
272 SPE_APO_QNTYFAC APOQUANFACTOR APOQUANFACTOR DEC 5   0   Numerator of Quotient for Unit of Measure Conversion  
273 SPE_APO_QNTYDIV APOQUANDIVISOR APOQUANDIVISOR DEC 5   0   Denominator of Quotient for Unit of Measure Conversion  
274 SPE_HERKL HERKL LAND1 CHAR 3   0   Country of origin of the material *
275 SPE_BXP_DATE_EXT /SPE/RET_EXPIRY_DATE_EXT_B TZNTSTMPS DEC 15   0   Begin date of validity period of returns delivery  
276 SPE_VERSION /SPE/DE_DLV_VERSION NUMC04 NUMC 4   0   Delivery Version at Confirmation  
277 SPE_COMPL_MVT /SPE/COMPL_MVT XFELD CHAR 1   0   Completion of Goods Movements after Difference Postings  
278 J_1BTAXLW4 J_1BTAXLW4 J_1BTAXLW4 CHAR 3   0   COFINS Tax Law J_1BATL4A
279 J_1BTAXLW5 J_1BTAXLW5 J_1BTAXLW5 CHAR 3   0   PIS Tax Law J_1BATL5
280 J_1BTAXLW3 J_1BTAXLW3 J_1BTAXLW3 CHAR 3   0   Tax law: ISS J_1BATL3
281 BUDGET_PD FM_BUDGET_PERIOD FM_BUDGET_PERIOD CHAR 10   0   FM: Budget Period *
282 KBNKZ KBNKZ KBNKZ CHAR 1   0   Kanban Indicator  
283 SITKZ SITKZ SITKZ CHAR 1   0   Specification for Issuing Valuated Stock in Transit  
284 .INCLU--AP       0   0   Seasonal Procurement: Append for LIPS  
285 CONS_ORDER WRF_CONS_ORDER WRF_CONS_ORDER CHAR 1   0   Purchase Order for Consignment  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 LIPS ABELN AUKO ABELN REF 1 CN
2 LIPS ABELP AUPO ABELP REF 1 CN
3 LIPS ABFOR T691K ABSFO REF C CN
4 LIPS ABRLI VBLB ABRLI REF C CN
5 LIPS ABRVW TVLV ABRVW REF C CN
6 LIPS ABTNR TSAB ABTNR REF 1 CN
7 LIPS AKTNR WAKH AKTNR REF C CN
8 LIPS AUFNR AUFK AUFNR REF C CN
9 LIPS BEDAR_LF T459K BEDAR REF C CN
10 LIPS BERID MDLV BERID REF 1 CN
11 LIPS BWART T156 BWART REF C CN
12 LIPS BWLVS T333 BWLVS REF C CN
13 LIPS BWTAR T149D BWTAR REF C CN
14 LIPS CHARG MCHA CHARG REF C CN
15 LIPS CLINT KLAH CLINT KEY 1 CN
16 LIPS EMATN MARA MATNR    
17 LIPS FAKSP TVFS FAKSP REF C CN
18 LIPS GEWEI T006 MSEHI REF C CN
19 LIPS GSBER TGSB GSBER REF C CN
20 LIPS J_1BCFOP J_1BAG CFOP C CN
21 LIPS J_1BTAXLW1 J_1BATL1 TAXLAW C CN
22 LIPS J_1BTAXLW2 J_1BATL2 TAXLAW C CN
23 LIPS J_1BTAXLW3 J_1BATL3 TAXLAW REF 1 CN
24 LIPS J_1BTAXLW4 J_1BATL4A TAXLAW REF 1 CN
25 LIPS J_1BTAXLW5 J_1BATL5 TAXLAW REF 1 CN
26 LIPS J_1BTXSDC J_1BTXSDC TAXCODE C CN
27 LIPS KCGEWEI T006 MSEHI REF C CN
28 LIPS KCVOLEH T006 MSEHI REF C CN
29 LIPS KMEIN T006 MSEHI    
30 LIPS KNTTP T163K KNTTP REF 1 CN
31 LIPS KOKRS TKA01 KOKRS REF C CN
32 LIPS KOSTL CSKS KOSTL REF C CN
33 LIPS KVGR1 TVV1 KVGR1 REF C CN
34 LIPS KVGR2 TVV2 KVGR2 REF C CN
35 LIPS KVGR3 TVV3 KVGR3 REF C CN
36 LIPS KVGR4 TVV4 KVGR4 REF C CN
37 LIPS KVGR5 TVV5 KVGR5 REF C CN
38 LIPS LADGR TLGR LADGR REF C CN
39 LIPS LGBZO T30C LGBZO REF 1 CN
40 LIPS LGNUM T300 LGNUM REF C CN
41 LIPS LGORT T001L LGORT REF C CN
42 LIPS LGPLA LAGP LGPLA REF C CN
43 LIPS LGTYP T301 LGTYP REF C CN
44 LIPS MAGRV TVEGR MAGRV REF C CN
45 LIPS MANDT T000 MANDT KEY 1 CN
46 LIPS MATKL T023 MATKL REF C CN
47 LIPS MATNR MARA MATNR REF C CN
48 LIPS MATWA MARA MATNR REF C CN
49 LIPS MEINS T006 MSEHI REF C CN
50 LIPS MFRGR TMFG MFRGR REF 1 CN
51 LIPS MTART T134 MTART REF C CN
52 LIPS MTVFP TMVF MTVFP REF C CN
53 LIPS MVGR1 TVM1 MVGR1 REF C CN
54 LIPS MVGR2 TVM2 MVGR2 REF C CN
55 LIPS MVGR3 TVM3 MVGR3 REF C CN
56 LIPS MVGR4 TVM4 MVGR4 REF C CN
57 LIPS MVGR5 TVM5 MVGR5 REF C CN
58 LIPS POSNR VBUP POSNR KEY 1 C
59 LIPS POSNV VBUP POSNR REF C CN
60 LIPS PRBME T006 MSEHI REF 1 CN
61 LIPS PRODH T179 PRODH REF C CN
62 LIPS PROFL TDG41 PROFL    
63 LIPS PSTYV TVPT PSTYV REF 1 CN
64 LIPS QPLOS QALS PRUEFLOS    
65 LIPS RULES T434R RULES    
66 LIPS SERAIL T377P SERAIL    
67 LIPS SERNR SNUM SERNR REF C CN
68 LIPS SOBKZ T148 SOBKZ REF C CN
69 LIPS SPART TSPA SPART REF C CN
70 LIPS TRAGR TTGR TRAGR REF C CN
71 LIPS UECHA LIPS POSNR REF C CN
72 LIPS UEPOS VBUP POSNR REF C CN
73 LIPS VBELN VBUK VBELN KEY 1 CN
74 LIPS VBELV VBUK VBELN REF C CN
75 LIPS VGBEL VBUK VBELN REF C CN
76 LIPS VGPOS VBUP POSNR REF C CN
77 LIPS VGSYS TBDLS LOGSYS REF C CN
78 LIPS VKBUR TVBUR VKBUR REF C CN
79 LIPS VKGRP TVKGR VKGRP REF C CN
80 LIPS VOLEH T006 MSEHI REF C CN
81 LIPS VPMAT MARA MATNR REF 1 CN
82 LIPS VPWRK T001W WERKS REF 1 CN
83 LIPS VRKME T006 MSEHI REF C CN
84 LIPS VTWEG TVTW VTWEG REF C CN
85 LIPS WERKS T001W WERKS REF C CN
86 LIPS WKTNR VBUK VBELN REF C CN
87 LIPS WKTPS VBUP POSNR REF C CN
History
Last changed by/on SAP  20140121 
SAP Release Created in