LIPS is a standard Shipping Transparent Table in SAP Logistics Execution application, which stores SD document: Delivery: Item data data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for LIPS. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.
LIPS — Meta Data
Description: | SD document: Delivery: Item data |
Main Category: | Logistics Execution |
Sub Category: | Shipping |
Table type: | Transparent Table (TRANSP) |
LIPS — Table Structure, Fields(Columns) and Definitions
Position | Column Name | Description | Primary Key | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
1 | MANDT | Client | X | CLNT | 3 | T000 |
2 | VBELN | Sales Document | X | CHAR | 10 | LIKP |
3 | POSNR | Item | X | NUMC | 6 | |
4 | PSTYV | Item category | CHAR | 4 | TVPT | |
5 | ERNAM | Created by | CHAR | 12 | ||
6 | ERZET | Time | TIMS | 6 | ||
7 | ERDAT | Created on | DATS | 8 | ||
8 | MATNR | Material | CHAR | 40 | MARA | |
9 | MATWA | MaterialEntered | CHAR | 40 | MARA | |
10 | MATKL | Material Group | CHAR | 9 | T023 | |
11 | WERKS | Plant | CHAR | 4 | T001W | |
12 | LGORT | Stor. Location | CHAR | 4 | T001L | |
13 | CHARG | Batch | CHAR | 10 | MCHA | |
14 | LICHN | Vendor Batch Number | CHAR | 15 | ||
15 | KDMAT | Material belonging to the customer | CHAR | 35 | ||
16 | PRODH | Prod.hierarchy | CHAR | 18 | T179 | |
17 | LFIMG | Delivery qty | QUAN | 13 | ||
18 | MEINS | Base Unit | UNIT | 3 | T006 | |
19 | VRKME | Sales unit | UNIT | 3 | T006 | |
20 | UMVKZ | Numerator | DEC | 5 | ||
21 | UMVKN | Denominat. | DEC | 5 | ||
22 | NTGEW | Net Weight | QUAN | 15 | ||
23 | BRGEW | Gross Weight | QUAN | 15 | ||
24 | GEWEI | Weight unit | UNIT | 3 | T006 | |
25 | VOLUM | Volume | QUAN | 15 | ||
26 | VOLEH | Volume unit | UNIT | 3 | T006 | |
27 | KZTLF | Partial delivery at item level | CHAR | 1 | ||
28 | UEBTK | Unlimited tol. | CHAR | 1 | ||
29 | UEBTO | Overdeliv. Tol. | DEC | 3 | ||
30 | UNTTO | Underdel. Tol. | DEC | 3 | ||
31 | CHSPL | Batch split allowed | CHAR | 1 | ||
32 | FAKSP | Billing block | CHAR | 2 | TVFS | |
33 | MBDAT | Mat.Avail.Date | DATS | 8 | ||
34 | LGMNG | Qty (stckp.unt) | QUAN | 13 | ||
35 | ARKTX | Description | CHAR | 40 | ||
36 | LGPBE | Storage Bin | CHAR | 10 | ||
37 | VBELV | Originating document | CHAR | 10 | ||
38 | POSNV | Originating item | NUMC | 6 | ||
39 | VBTYV | SD document category | CHAR | 4 | ||
40 | VGSYS | Logical System in the Preceding Document | CHAR | 10 | TBDLS | |
41 | VGBEL | Reference doc. | CHAR | 10 | ||
42 | VGPOS | Reference item | NUMC | 6 | ||
43 | UPFLU | Update indicator for delivery document flow | CHAR | 1 | ||
44 | UEPOS | Higher-level item in bill of material structures | NUMC | 6 | LIPS | |
45 | FKREL | Relevant for Billing | CHAR | 1 | ||
46 | LADGR | Loading Group | CHAR | 4 | TLGR | |
47 | TRAGR | Transportation Group | CHAR | 4 | TTGR | |
48 | KOMKZ | Indicator for picking control | CHAR | 1 | ||
49 | LGNUM | Warehouse No. | CHAR | 3 | T300 | |
50 | LISPL | Split to warehouse number required | CHAR | 1 | ||
51 | LGTYP | Storage Type | CHAR | 3 | T301 | |
52 | LGPLA | Storage Bin | CHAR | 10 | LAGP | |
53 | BWTEX | Indicator: Separate valuation | CHAR | 1 | ||
54 | BWART | Movement Type (Inventory Management) | CHAR | 3 | T156 | |
55 | BWLVS | Movement Type for Warehouse Management | NUMC | 3 | T333 | |
56 | KZDLG | Indicator: dynamic storage bin in warehouse management | CHAR | 1 | ||
57 | BDART | Requirement type | CHAR | 2 | ||
58 | PLART | Planning type | CHAR | 1 | ||
59 | MTART | Material Type | CHAR | 4 | T134 | |
60 | XCHPF | Batch management requirement indicator | CHAR | 1 | ||
61 | XCHAR | Batch management indicator (internal) | CHAR | 1 | ||
62 | VGREF | Preceding document has resulted from reference | CHAR | 1 | ||
63 | POSAR | Item type | CHAR | 1 | ||
64 | BWTAR | Valuation Type | CHAR | 10 | T149D | |
65 | SUMBD | Summing up of requirements | CHAR | 1 | ||
66 | MTVFP | Checking Group for Availability Check | CHAR | 2 | TMVF | |
67 | EANNR | European Article Number (EAN) - obsolete!!!!! | CHAR | 13 | ||
68 | GSBER | Business Area | CHAR | 4 | TGSB | |
69 | VKBUR | Sales Office | CHAR | 4 | TVBUR | |
70 | VKGRP | Sales Group | CHAR | 3 | TVKGR | |
71 | VTWEG | Distr. Channel | CHAR | 2 | TVTW | |
72 | SPART | Division | CHAR | 2 | TSPA | |
73 | GRKOR | Delivery group (items are delivered together) | NUMC | 3 | ||
74 | FMENG | Quantity is Fixed | CHAR | 1 | ||
75 | ANTLF | Maximum Number of Partial Deliveries Allowed Per Item | DEC | 1 | ||
76 | VBEAF | Fixed proc.time | DEC | 5 | ||
77 | VBEAV | Var. proc. time | DEC | 5 | ||
78 | STAFO | Update group for statistics update | CHAR | 6 | ||
79 | WAVWR | Cost | CURR | 13 | ||
80 | KZWI1 | Subtotal 1 | CURR | 13 | ||
81 | KZWI2 | Subtotal 2 | CURR | 13 | ||
82 | KZWI3 | Subtotal 3 | CURR | 13 | ||
83 | KZWI4 | Subtotal 4 | CURR | 13 | ||
84 | KZWI5 | Subtotal 5 | CURR | 13 | ||
85 | KZWI6 | Subtotal 6 | CURR | 13 | ||
86 | SOBKZ | Special Stock | CHAR | 1 | T148 | |
87 | AEDAT | Changed on | DATS | 8 | ||
88 | EAN11 | EAN/UPC | CHAR | 18 | ||
89 | KVGR1 | Customer grp 1 | CHAR | 3 | TVV1 | |
90 | KVGR2 | Customer grp 2 | CHAR | 3 | TVV2 | |
91 | KVGR3 | Customer grp 3 | CHAR | 3 | TVV3 | |
92 | KVGR4 | Customer grp 4 | CHAR | 3 | TVV4 | |
93 | KVGR5 | Customer grp 5 | CHAR | 3 | TVV5 | |
94 | MVGR1 | MaterialGroup 1 | CHAR | 3 | TVM1 | |
95 | MVGR2 | MaterialGroup 2 | CHAR | 3 | TVM2 | |
96 | MVGR3 | MaterialGroup 3 | CHAR | 3 | TVM3 | |
97 | MVGR4 | MaterialGroup 4 | CHAR | 3 | TVM4 | |
98 | MVGR5 | MaterialGroup 5 | CHAR | 3 | TVM5 | |
99 | VPZUO | Allocation Indicator | CHAR | 1 | ||
100 | VGTYP | Prec.doc.categ. | CHAR | 4 | ||
101 | RFVGTYP | Type of preceding document in central system | CHAR | 4 | ||
102 | KOSTL | Cost Center | CHAR | 10 | CSKS | |
103 | KOKRS | CO Area | CHAR | 4 | TKA01 | |
104 | PAOBJNR | Profitability Segment Number (CO-PA) | NUMC | 10 | ||
105 | PRCTR | Profit Center | CHAR | 10 | ||
106 | PS_PSP_PNR | WBS Element | NUMC | 8 | ||
107 | AUFNR | Order | CHAR | 12 | AUFK | |
108 | POSNR_PP | Number of Order Item | NUMC | 4 | ||
109 | KDAUF | Sales Order Number | CHAR | 10 | ||
110 | KDPOS | Item Number in Sales Order | NUMC | 6 | ||
111 | VPMAT | Planning material | CHAR | 40 | MARA | |
112 | VPWRK | Planning plant | CHAR | 4 | T001W | |
113 | PRBME | Base unit of measure for product group | UNIT | 3 | T006 | |
114 | UMREF | Conversion factor: quantities | FLTP | 16 | ||
115 | KNTTP | Account Assignment Category | CHAR | 1 | T163K | |
116 | KZVBR | Consumption posting | CHAR | 1 | ||
117 | FIPOS | Commitment Item | CHAR | 14 | ||
118 | FISTL | Funds Center | CHAR | 16 | ||
119 | GEBER | Fund | CHAR | 10 | ||
120 | PCKPF | Packing control | CHAR | 1 | ||
121 | BEDAR_LF | Requirements class | CHAR | 3 | T459K | |
122 | CMPNT | ID: Item with active credit function / relevant for credit | CHAR | 1 | ||
123 | KCMENG | Cumulative batch quantity of all split items (in StckUnit) | QUAN | 15 | ||
124 | KCBRGEW | Cumulative gross weight of all batch split items | QUAN | 15 | ||
125 | KCNTGEW | Cumulative net weight of all batch split items | QUAN | 15 | ||
126 | KCVOLUM | Cumulative volume of all batch split items | QUAN | 15 | ||
127 | UECHA | Higher-Level Item of Batch Split Item | NUMC | 6 | LIPS | |
128 | CUOBJ | Configuration (internal object number) | NUMC | 18 | ||
129 | CUOBJ_CH | Internal object number of the batch classification | NUMC | 18 | ||
130 | ANZSN | Number of Serial Numbers | INT4 | 10 | ||
131 | SERAIL | Serial Number Profile | CHAR | 4 | T377P | |
132 | KCGEWEI | Weight Unit | UNIT | 3 | T006 | |
133 | KCVOLEH | Volume unit | UNIT | 3 | T006 | |
134 | SERNR | BOM explosion number | CHAR | 8 | SNUM | |
135 | ABRLI | Internal delivery schedule number | NUMC | 4 | VBLB | |
136 | ABART | Release type | CHAR | 1 | ||
137 | ABRVW | Usage Indicator | CHAR | 3 | TVLV | |
138 | QPLOS | Inspection Lot Number | NUMC | 12 | QALS | |
139 | QTLOS | Partial lot number | NUMC | 6 | ||
140 | NACHL | Customer has not posted goods receipt | CHAR | 1 | ||
141 | MAGRV | Material Group: Packaging Materials | CHAR | 4 | TVEGR | |
142 | OBJKO | Object number at header level | CHAR | 22 | ||
143 | OBJPO | Object number at item level | CHAR | 22 | ||
144 | AESKD | Customer Engineering Change Status | CHAR | 17 | ||
145 | SHKZG | Debit/Credit | CHAR | 1 | ||
146 | PROSA | ID for material determination | CHAR | 1 | ||
147 | UEPVW | ID for higher-level item usage | CHAR | 1 | ||
148 | EMPST | Receiving point | CHAR | 25 | ||
149 | ABTNR | Department number | CHAR | 4 | TSAB | |
150 | KOQUI | Picking is subject to confirmation | CHAR | 1 | ||
151 | STADAT | Statistics date | DATS | 8 | ||
152 | AKTNR | Promotion | CHAR | 10 | WAKH | |
153 | KNUMH_CH | Number of condition record from batch determination | CHAR | 10 | ||
154 | PREFE | Preference indicator in export/import | CHAR | 1 | ||
155 | EXART | Business Transaction Type for Foreign Trade | CHAR | 2 | ||
156 | CLINT | Internal Class Number | NUMC | 10 | KLAH | |
157 | CHMVS | Batches: Exit to quantity proposal | NUMC | 3 | ||
158 | ABELN | Allocation Table Number | CHAR | 10 | AUKO | |
159 | ABELP | Item number of allocation table | NUMC | 5 | AUPO | |
160 | LFIMG_FLO | Internal field/ Do not use / LFIMG in float / MUM | FLTP | 16 | ||
161 | LGMNG_FLO | Internal field/ Do not use / LGMNG in float / MUM | FLTP | 16 | ||
162 | KCMENG_FLO | Internal field/ Do not use / KCMENG in float / MUM | FLTP | 16 | ||
163 | KZUMW | Environmentally Relevant | CHAR | 1 | ||
164 | KMPMG | Component quantity | QUAN | 13 | ||
165 | AUREL | Relevant to Allocation Table | CHAR | 1 | ||
166 | KPEIN | Pricing unit | DEC | 5 | ||
167 | KMEIN | Unit of measure | UNIT | 3 | T006 | |
168 | NETPR | Net price | CURR | 11 | ||
169 | NETWR | Net value | CURR | 15 | ||
170 | KOWRR | Statistical values | CHAR | 1 | ||
171 | KZBEW | Movement Indicator | CHAR | 1 | ||
172 | MFRGR | Material freight group | CHAR | 8 | TMFG | |
173 | CHHPV | Pack accumulated batches / movement type item | CHAR | 1 | ||
174 | ABFOR | Form of payment guarantee | CHAR | 2 | T691K | |
175 | ABGES | Guaranteed (factor between 0 and 1) | FLTP | 16 | ||
176 | MBUHR | Material Staging Time (Local, Relating to a Plant) | TIMS | 6 | ||
177 | WKTNR | Value contract no. | CHAR | 10 | VBAK | |
178 | WKTPS | Value contract item | NUMC | 6 | VBAP | |
179 | J_1BCFOP | CFOP Code and Extension | CHAR | 10 | J_1BAG | |
180 | J_1BTAXLW1 | Tax law: ICMS | CHAR | 3 | J_1BATL1 | |
181 | J_1BTAXLW2 | Tax law: IPI | CHAR | 3 | J_1BATL2 | |
182 | J_1BTXSDC | SD tax code | CHAR | 2 | J_1BTXSDC | |
183 | SITUA | Indicator for situation | CHAR | 2 | ||
184 | RSNUM | Number of Reservation/Dependent Requirement | NUMC | 10 | ||
185 | RSPOS | Item Number of Reservation/Dependent Requirement | NUMC | 4 | ||
186 | RSART | Record type | CHAR | 1 | ||
187 | KANNR | KANBAN/sequence number | CHAR | 35 | ||
188 | KZFME | ID: Leading unit of measure for completing a transaction | CHAR | 1 | ||
189 | PROFL | Dangerous Goods Indicator Profile | CHAR | 3 | TDG41 | |
190 | KCMENGVME | Cumulative batch quantity of all split items in sales units | QUAN | 15 | ||
191 | KCMENGVMEF | Cumulated batch split quantity in VRKME and float | FLTP | 16 | ||
192 | KZBWS | Valuation of Special Stock | CHAR | 1 | ||
193 | PSPNR | Project definition (internal) | NUMC | 8 | ||
194 | EPRIO | Withdrawal sequence group for stocks | CHAR | 4 | ||
195 | RULES | Stock Determination Rule | CHAR | 4 | T434R | |
196 | KZBEF | Indicator Inventory Management active | CHAR | 1 | ||
197 | MPROF | Manufacturer Part Profile | CHAR | 4 | ||
198 | EMATN | Material | CHAR | 40 | MARA | |
199 | LGBZO | Staging Area for Warehouse Complex | CHAR | 10 | T30C | |
200 | HANDLE | Worldwide unique key for LIKP-VBELN | CHAR | 22 | ||
201 | VERURPOS | Distribution delivery: Original item | NUMC | 6 | ||
202 | LIFEXPOS | External item number | NUMC | 6 | ||
203 | NOATP | Indicator: deactivate availability check | CHAR | 1 | ||
204 | NOPCK | Indicator: not relevant for picking | CHAR | 1 | ||
205 | RBLVS | Reference movement type for WM from material movements | NUMC | 3 | ||
206 | BERID | MRP Area | CHAR | 10 | MDLV | |
207 | BESTQ | Stock Category in the Warehouse Management System | CHAR | 1 | ||
208 | UMBSQ | Stock Category in the Warehouse Management System | CHAR | 1 | ||
209 | UMMAT | Receiving/Issuing Material | CHAR | 40 | ||
210 | UMWRK | Receiving/Issuing Plant | CHAR | 4 | ||
211 | UMLGO | Receiving/Issuing Storage Location | CHAR | 4 | ||
212 | UMCHA | Receiving/Issuing Batch | CHAR | 10 | ||
213 | UMBAR | Valuation Type of Transfer Batch | CHAR | 10 | ||
214 | UMSOK | Special stock indicator for physical stock transfer | CHAR | 1 | ||
215 | SONUM | Special Stock Number | CHAR | 16 | ||
216 | USONU | Special Stock Number | CHAR | 16 | ||
217 | AKKUR | Exchange rate for letter-of-credit procg in foreign trade | DEC | 9 | ||
218 | AKMNG | Current Qty Field for Arithmetic Operations in Doc.Process. | CHAR | 1 | ||
219 | VKGRU | Repair Processing: Classification of Items | CHAR | 3 | ||
220 | SHKZG_UM | Indicator: UNMAT in main posting | CHAR | 1 | ||
221 | INSMK | Stock Type | CHAR | 1 | ||
222 | KZECH | Determination of batch entry in the production/process order | CHAR | 1 | ||
223 | FLGWM | Indicator: Copy dest. storage data from preceding document | CHAR | 1 | ||
224 | BERKZ | Material Staging Indicator for Production Supply | CHAR | 1 | ||
225 | HUPOS | Indicator: Delivery item is a HU item | CHAR | 1 | ||
226 | NOWAB | Indicator: Item Not Relevant for Goods Movements | CHAR | 1 | ||
227 | KONTO | G/L Account Number | CHAR | 10 | ||
228 | KZEAR | Final Issue for Reservation | CHAR | 1 | ||
229 | HSDAT | Date of Manufacture | DATS | 8 | ||
230 | VFDAT | Shelf Life Expiration or Best-Before Date | DATS | 8 | ||
231 | LFGJA | Fiscal Year of Current Period | NUMC | 4 | ||
232 | LFBNR | Document No. of a Reference Document | CHAR | 10 | ||
233 | LFPOS | Item of a Reference Document | NUMC | 4 | ||
234 | GRUND | Reason for goods movment | NUMC | 4 | ||
235 | FOBWA | Subsequent movement type | CHAR | 3 | ||
236 | DLVTP | Delivery Category | CHAR | 2 | ||
237 | EXBWR | Externally Entered Posting Amount in Local Currency | CURR | 13 | ||
238 | BPMNG | Quantity in Purchase Order Price Unit | QUAN | 13 | ||
239 | EXVKW | Externally Entered Sales Value in Local Currency | CURR | 13 | ||
240 | CMPRE_FLT | Item credit price | FLTP | 16 | ||
241 | KZPOD | POD indicator (relevance, verification, confirmation) | CHAR | 1 | ||
242 | LFDEZ | Not relevant for distribution for WMS | CHAR | 1 | ||
243 | UMREV | Conversion Factor of Delivery Quantity VRKME for MEINS | FLTP | 16 | ||
244 | PODREL | POD Control (Proof of Delivery) | CHAR | 1 | ||
245 | KZUML | Stock transfer/transfer posting | CHAR | 1 | ||
246 | FKBER | Functional Area | CHAR | 16 | ||
247 | GRANT_NBR | Grant | CHAR | 20 | ||
248 | KZWSO | Units of measure usage | CHAR | 1 | ||
249 | GMCONTROL | Goods Movement Control | CHAR | 1 | ||
250 | POSTING_CHANGE | Goods Movement Control: HU | CHAR | 1 | ||
251 | UM_PS_PSP_PNR | Receiving/Issuing (WBS Element) | NUMC | 8 | ||
252 | PRE_VL_ETENS | Sequential Number of Vendor Confirmation | NUMC | 4 | ||
253 | SPE_GEN_ELIKZ | \Delivery Completed\" Indicator" | CHAR | 1 | ||
254 | SPE_SCRAP_IND | Scrap Indicator for EWM Processing | CHAR | 1 | ||
255 | SPE_AUTH_NUMBER | Return Material Authorization Number | CHAR | 20 | ||
256 | SPE_INSPOUT_GUID | Inspections: Inspection outcome GUID set by EWM | RAW | 16 | ||
257 | SPE_FOLLOW_UP | Default Follow-Up Activity Code | CHAR | 4 | ||
258 | SPE_EXP_DATE_EXT | End date of validity period of returns delivery | DEC | 15 | ||
259 | SPE_EXP_DATE_INT | End date of internal validity period of returns delivery | DEC | 15 | ||
260 | SPE_AUTH_COMPLET | RMA completion indicator | CHAR | 1 | ||
261 | ORMNG | Original Quantity of Delivery Item | QUAN | 13 | ||
262 | SPE_ATP_TMSTMP | ATP Time Stamp | DEC | 15 | ||
263 | SPE_ORIG_SYS | Original System Type | CHAR | 1 | ||
264 | SPE_LIEFFZ | Cumulative Qty for SchedAgr - Vendor's Point of View | QUAN | 15 | ||
265 | SPE_IMWRK | Inbound Delivery item has Status 'In Plant' | CHAR | 1 | ||
266 | SPE_LIFEXPOS2 | External item identifier | CHAR | 35 | ||
267 | SPE_EXCEPT_CODE | Exception Code Warehouse for Quantity Difference | CHAR | 4 | ||
268 | SPE_KEEP_QTY | Retention Quantity for Scrap. Process in EWM | QUAN | 13 | ||
269 | SPE_ALTERNATE | Alternate Product Number | CHAR | 40 | ||
270 | SPE_MAT_SUBST | Reason for material substitution | CHAR | 1 | ||
271 | SPE_STRUC | Structure of Items That Are Delivered Together | NUMC | 3 | ||
272 | SPE_APO_QNTYFAC | Numerator of Quotient for Unit of Measure Conversion | DEC | 5 | ||
273 | SPE_APO_QNTYDIV | Denominator of Quotient for Unit of Measure Conversion | DEC | 5 | ||
274 | SPE_HERKL | Country of origin of the material | CHAR | 3 | ||
275 | SPE_BXP_DATE_EXT | Begin date of validity period of returns delivery | DEC | 15 | ||
276 | SPE_VERSION | Delivery Version at Confirmation | NUMC | 4 | ||
277 | SPE_COMPL_MVT | Completion of Goods Movements after Difference Postings | CHAR | 1 | ||
278 | J_1BTAXLW4 | Single-Character Flag | CHAR | 3 | J_1BATL4A | |
279 | J_1BTAXLW5 | Single-Character Flag | CHAR | 3 | J_1BATL5 | |
280 | J_1BTAXLW3 | ISS Tax Law | CHAR | 3 | J_1BATL3 | |
281 | BUDGET_PD | Budget Period | CHAR | 10 | ||
282 | KBNKZ | Updated information in related user data field | CHAR | 1 | ||
283 | FARR_RELTYPE | Relevance Type for Revenue Accounting | CHAR | 10 | ||
284 | SITKZ | Specification for Issuing Valuated Stock in Transit | CHAR | 1 | ||
285 | SGT_RCAT | Requirement Segment | CHAR | 40 | ||
286 | SGT_SCAT | Stock Segment | CHAR | 40 | ||
287 | .INCLUDE | 0 | ||||
288 | BESTA | Confirmation Status of Document Item | CHAR | 1 | ||
289 | CMPPI | Status of credit check against financial document | CHAR | 1 | ||
290 | CMPPJ | Status of credit check against export credit insurance | CHAR | 1 | ||
291 | FKIVP | Intercompany Billing Status | CHAR | 1 | ||
292 | FKSTA | Billing status of delivery-related billing documents | CHAR | 1 | ||
293 | GBSTA | Overall processing status of the SD document item | CHAR | 1 | ||
294 | HDALL | Inbound delivery header not yet complete (on Hold) | CHAR | 1 | ||
295 | KOQUA | Confirmation | CHAR | 1 | ||
296 | KOSTA | Picking status | CHAR | 1 | ||
297 | LVSTA | Status of warehouse management activities | CHAR | 1 | ||
298 | PDSTA | POD status on item level | CHAR | 1 | ||
299 | PKSTA | There are Packed Deliveries Dependent on Shipping | CHAR | 1 | ||
300 | UVALL | Item | CHAR | 1 | ||
301 | UVFAK | Item bill.data | CHAR | 1 | ||
302 | UVPAK | Header incomplete status for packaging | CHAR | 1 | ||
303 | UVPIK | Header incomplete status for picking/putaway | CHAR | 1 | ||
304 | UVVLK | Item deliv.data | CHAR | 1 | ||
305 | UVWAK | Post header incomplete status for goods movement | CHAR | 1 | ||
306 | VLSTP | Decentralized whse processing | CHAR | 1 | ||
307 | WBSTA | GoodsMovementSt | CHAR | 1 | ||
308 | UVP01 | Customer reserves 1: Item status | CHAR | 1 | ||
309 | UVP02 | Customer reserves 2: Item status | CHAR | 1 | ||
310 | UVP03 | Item reserves 3: Item status | CHAR | 1 | ||
311 | UVP04 | Item reserves 4: Item status | CHAR | 1 | ||
312 | UVP05 | Customer reserves 5: Item status | CHAR | 1 | ||
313 | EMCST | CHAR | 1 | |||
314 | SLCST | Scope of check: Street for sanctioned party list | CHAR | 1 | ||
315 | LCCST | CHAR | 1 | |||
316 | .INCLU--AP | 0 | ||||
317 | /SAPMP/LBASP | DTUC Status | CHAR | 1 | ||
318 | .INCLU--AP | 0 | ||||
319 | .INCLUDE | 0 | ||||
320 | OIINVCST1 | Status of invoice cycle 1 | CHAR | 1 | ||
321 | OIINVCST2 | Status of invoice cycle 2 | CHAR | 1 | ||
322 | OIINVCST3 | Status of invoice cycle 3 | CHAR | 1 | ||
323 | OIINVCST4 | Status of invoice cycle 4 | CHAR | 1 | ||
324 | OIINVCST5 | Status of invoice cycle 5 | CHAR | 1 | ||
325 | OIINVCST6 | Status of invoice cycle 6 | CHAR | 1 | ||
326 | OIINVCST7 | Status of invoice cycle 7 | CHAR | 1 | ||
327 | OIINVCST8 | Status of invoice cycle 8 | CHAR | 1 | ||
328 | OIINVCST9 | Status of invoice cycle 9 | CHAR | 1 | ||
329 | _DATAAGING | Data Filter Value for Data Aging | DATS | 8 | ||
330 | .INCLUDE | 0 | ||||
331 | /CWM/LFIMG | Actual Delivered Quantity in Parallel Unit of Measure | QUAN | 13 | ||
332 | /CWM/LFIME | CWM Delivery Unit of Measure | UNIT | 3 | * | |
333 | /CWM/PIKMG | Quantity Picked/Placed in Storage in Parallel UoM | QUAN | 13 | ||
334 | /CWM/PIKME | Picked/Stored Parallel Unit of Measure | UNIT | 3 | * | |
335 | /CWM/XENTER | Indicator Stating Whether Quantity Clearly Entered in PUoM | CHAR | 1 | ||
336 | /CWM/XTAENTER | Indicator Stating Whether Qty to Be Entered in PUoM in TO | CHAR | 1 | ||
337 | /CWM/KCMENG | Cumulatd CWM Batch Quantity of all Split Items (in StckUnit) | QUAN | 15 | ||
338 | /CWM/EBUMG | Quantity to Be Posted in PUoM | QUAN | 15 | ||
339 | .INCLUDE | 0 | ||||
340 | DUMMY_DELITM_INCL_EEW_PS | Dummy function in length 1 | CHAR | 1 | ||
341 | .INCLU--AP | 0 | ||||
342 | .INCLUDE | 0 | ||||
343 | /KJEDM/INVERTED | CHAR | 1 | |||
344 | .INCLU--AP | 0 | ||||
345 | /SAPMP/LBA_NO | DTUC Complete | CHAR | 1 | ||
346 | .INCLU--AP | 0 | ||||
347 | .INCLUDE | 0 | ||||
348 | /SAPMP/ALT_CONV | CHAR | 1 | |||
349 | .INCLU--AP | 0 | ||||
350 | LGTOR | Door for Warehouse Number | CHAR | 3 | * | |
351 | .INCLU--AP | 0 | ||||
352 | FSH_SEASON_YEAR | Season Year | CHAR | 4 | ||
353 | FSH_SEASON | Season | CHAR | 10 | ||
354 | FSH_COLLECTION | Fashion Collection | CHAR | 10 | * | |
355 | FSH_THEME | Fashion Theme | CHAR | 10 | ||
356 | FSH_KVGR6 | Updated information in related user data field | CHAR | 3 | * | |
357 | FSH_KVGR7 | Updated information in related user data field | CHAR | 3 | * | |
358 | FSH_KVGR8 | Updated information in related user data field | CHAR | 3 | * | |
359 | FSH_KVGR9 | Updated information in related user data field | CHAR | 3 | * | |
360 | FSH_KVGR10 | Updated information in related user data field | CHAR | 3 | * | |
361 | .INCLUDE | 0 | ||||
362 | FSH_VAS_REL | Character Field of Length 1 | CHAR | 1 | ||
363 | FSH_VAS_PRNT_ID | Item Number of Purchasing Document | NUMC | 6 | ||
364 | FSH_TRANSACTION | Transaction Number | CHAR | 10 | ||
365 | FSH_ITEM_GROUP | Item Group | NUMC | 5 | ||
366 | FSH_ITEM | Character Field of Length 1 | NUMC | 5 | ||
367 | FSH_RSNUM | Number of reservation/dependent requirements | NUMC | 10 | * | |
368 | FSH_RSPOS | Item Number of Reservation / Dependent Requirements | NUMC | 4 | ||
369 | .INCLU--AP | 0 | ||||
370 | MILL_UCDET | Batch Determination for Original Batches | CHAR | 1 | ||
371 | .INCLU--AP | 0 | ||||
372 | .INCLUDE | 0 | ||||
373 | OID_EXTBOL | External bill of lading | CHAR | 16 | ||
374 | OID_MISCDL | Miscellaneous delivery number | CHAR | 16 | ||
375 | .INCLUDE | 0 | ||||
376 | OIPIPEVAL | Validation indicator for pipeline fields (X=ON | CHAR | 1 | ||
377 | OIC_LIFNR | Account Number of Vendor or Creditor | CHAR | 10 | LFA1 | |
378 | .INCLUDE | 0 | ||||
379 | OIC_DCITYC | Destination city code | CHAR | 4 | T005G | |
380 | OIC_DCOUNC | Destination county code | CHAR | 3 | T005E | |
381 | OIC_DREGIO | Destination region | CHAR | 3 | T005S | |
382 | OIC_DLAND1 | Destination country | CHAR | 3 | T005 | |
383 | OIC_OCITYC | Origin city code | CHAR | 4 | T005G | |
384 | OIC_OCOUNC | Origin county code | CHAR | 3 | T005E | |
385 | OIC_OREGIO | Origin region | CHAR | 3 | T005S | |
386 | OIC_OLAND1 | Origin country | CHAR | 3 | T005 | |
387 | OIC_PORGIN | Tax origin | CHAR | 15 | ||
388 | OIC_PDESTN | Tax destination | CHAR | 15 | ||
389 | OIC_PTRIP | Pipeline trip number (external) | CHAR | 16 | ||
390 | OIC_PBATCH | Pipeline operators external batch number | CHAR | 16 | ||
391 | OIC_MOT | IS-OIL MAP external details mode of transport | CHAR | 2 | TVTR | |
392 | OIC_AORGIN | Alternate origin | CHAR | 15 | ||
393 | OIC_ADESTN | Alternate destination | CHAR | 15 | ||
394 | OIC_TRUCKN | Truck number | CHAR | 10 | ||
395 | OIA_BASELO | Base location | CHAR | 15 | ||
396 | CMETH | Checkbox | CHAR | 1 | ||
397 | OITAXFROM | Excise duty tax key for 'from' location | CHAR | 2 | OIH4 | |
398 | OIHANTYP | Excise Duty Handling Type | CHAR | 2 | OIH5 | |
399 | OITAXGRP | Excise Duty Group | CHAR | 2 | OIH2 | |
400 | OITAXTO | Excise duty tax key for 'to' location | CHAR | 2 | OIH4 | |
401 | OICERTF1 | Excise tax external license number | CHAR | 15 | ||
402 | OIOILCON | Oil content in a material as a percentage | DEC | 5 | ||
403 | OIDATFM1 | Excise Duty License Valid from Date | DATS | 8 | ||
404 | OIDATTO1 | Valid to date for excise duty tax certificate | DATS | 8 | ||
405 | OIEDBAL | Updated information in related user data field | CHAR | 1 | ||
406 | OIPRICIE | ED pricing: external (indicator) | CHAR | 1 | ||
407 | OIINEX | Updated information in related user data field | CHAR | 2 | OIH16 | |
408 | OIEDBALM | Updated information in related user data field | CHAR | 1 | ||
409 | OITAXLOD | Excise duty tax value for goods loading | CURR | 13 | ||
410 | OITAXISS | Excise duty value for goods issue | CURR | 13 | ||
411 | OITAXINV | Excise duty tax value for an invoice | CURR | 13 | ||
412 | OICONTNR | Single-Character Flag | CHAR | 10 | ||
413 | OIC_KMPOS | Single-Character Flag | NUMC | 6 | ||
414 | OIC_TIME | Single-Character Flag | TIMS | 6 | ||
415 | OIC_DATE | Date for time pricing | DATS | 8 | ||
416 | .INCLUDE | 0 | ||||
417 | OIEXGNUM | Exchange agreement number | CHAR | 10 | ||
418 | OIEXGTYP | Exchange type | CHAR | 4 | TOIA2 | |
419 | OIFEETOT | Fee total | CURR | 13 | ||
420 | OIFEEDT | Fee pricing condition date | DATS | 8 | ||
421 | OINETCYC | Netting cycle (FI blocking indicator) | CHAR | 1 | T008 | |
422 | OIMATREF | Material group reference for exchange balance reporting | CHAR | 20 | ||
423 | OIFINAL | Final Delivery Indicator | CHAR | 1 | ||
424 | OIC_WATIM | Actual goods issue time (for time pricing) | TIMS | 6 | ||
425 | OIC_WADAT | Goods issue date (for time pricing) | DATS | 8 | ||
426 | OIH_LICTP | License type | CHAR | 4 | * | |
427 | OIH_LICIN | Excise tax internal license number | CHAR | 10 | ||
428 | OIH_LCFOL | Follow-on license for quantity license | CHAR | 10 | * | |
429 | OIH_FOLQTY | Excise Tax Follow-On License Quantity | QUAN | 13 | ||
430 | .INCLUDE | 0 | ||||
431 | OITRKNR | Tracking number | CHAR | 10 | ||
432 | OITRKJR | Tracking number year | NUMC | 4 | ||
433 | OIEXTNR | External tracking number | CHAR | 18 | ||
434 | OIITMNR | Tracking number item line | NUMC | 5 | ||
435 | OIFTIND | Final transfer indicator | CHAR | 1 | ||
436 | OIPRIOP | Price options for gain calculation | CHAR | 1 | ||
437 | OITRIND | Transfer sign for plant-to-plant transfers | CHAR | 1 | ||
438 | OIGHNDL | Gain handling | CHAR | 1 | ||
439 | OIUMBAR | Valuation type of issuing location for two-step transfer | CHAR | 10 | T149D | |
440 | OISBREL | Sub product/ base product relevence indicator | NUMC | 3 | ||
441 | OIBASPROD | Base product number | CHAR | 40 | * | |
442 | OIGNRULE | Single-Character Flag | NUMC | 3 | * | |
443 | OITITLE | Location of title transfer for Incoterms purposes | CHAR | 1 | ||
444 | OIA_IPMVAT | Updated information in related user data field | CHAR | 1 | ||
445 | OIA_FFTYP | Fulfillment indicator for exchange assignments | CHAR | 1 | ||
446 | OII_CONWK | OIL-BDRP: Consignment stock receiving plant in delivery | CHAR | 4 | * | |
447 | OII_CONLG | OIL-BDRP: Consignment stock receiving s/loc in delivery | CHAR | 4 | * | |
448 | OIEDBAL_GI | Excise Duty Balancing is Required for Mat. (STO) | CHAR | 1 | ||
449 | OIEDBALM_GI | Excise Duty Balancing Method Indicator for Mat. (STO) | CHAR | 1 | ||
450 | .INCLUDE | 0 | ||||
451 | OICERTF1_GI | Excise Tax External License Number Used During GI (STO) | CHAR | 15 | ||
452 | OIDATFM1_GI | Excise Duty License Valid from Date for Mat. (STO) | DATS | 8 | ||
453 | OIDATTO1_GI | Valid To Date for Excise Duty Tax Certificate for Mat. (STO) | DATS | 8 | ||
454 | OIH_LICTP_GI | License Type to Material (STO) | CHAR | 4 | OIH20 | |
455 | OIH_LICIN_GI | Excise Tax Internal License Number to Mat. (STO) | CHAR | 10 | OIHL | |
456 | OIH_LCFOL_GI | Follow-On License for Quantity License to Mat. (STO) | CHAR | 10 | OIHL | |
457 | OIH_FOLQTY_GI | Excise Tax Follow-On License Quantity to Mat. (STO) | QUAN | 13 | ||
458 | OIHANTYP_GI | Excise Duty Handling Type - Denotes Use of Material | CHAR | 2 | * | |
459 | OITAXGRP_GI | Updated information in related user data field | CHAR | 2 | * | |
460 | OITAXISS_CC | Excise duty value for goods issue | CURR | 13 | ||
461 | OITAXINV_CC | Excise duty tax value for an invoice | CURR | 13 | ||
462 | .INCLU--AP | 0 | ||||
463 | OIO_SPROC | Supply Process | CHAR | 4 | * | |
464 | .INCLU--AP | 0 | ||||
465 | CONS_ORDER | Purchase Order for Consignment | CHAR | 1 | ||
466 | .INCLU--AP | 0 | ||||
467 | WRF_CHARSTC1 | Characteristic Value 1 | CHAR | 18 | ||
468 | WRF_CHARSTC2 | Characteristic Value 2 | CHAR | 18 | ||
469 | WRF_CHARSTC3 | Characteristic Value 3 | CHAR | 18 |
SAP Help, Wiki Resources, and Forum Discussions on LIPS
Click the above link for the full list of resources and help pages, only the first few are posted below
-
Link VBAK AND LIPS | SCN
IS there any link between VBAK and LIPS (VBELN AND VGBEL). Data is flow from header level VBAK to Item level LIPS is correct or Item level to item level.
http://scn.sap.com/message/10844645
-
Joining VBRK, VBRP, VBAK, VBAP, LIKP, LIPS | SCN
I just wanted to ask how to join the above subject in one table? Or it isnt possible?
http://scn.sap.com/thread/493171
-
How to update batch (LIPS-CHARG) using FM WS_DELIVERY_UPDATE
But for some deliveries with missing batch, I'm unable to update the batch of items. I don't know what parameter I'm missing because when I tested the function module, it didn't produce any error. But it also didn't update the batch (LIPS-CHARG) of the delivery items. Anybody here with experience in successful update of the batch field using this function module, or any other function module, pleas...
http://scn.sap.com/thread/731927
-
Select statement -EKKO,EKPO,LIPS | SCN
SELECT EKKOEBELN EKPOWERKS EKPOLGORT EKPOMENGE EKPOMEINS EKPOMATNR EKPOTXZ01 EKKOAEDAT EKKO~KNUMV
http://scn.sap.com/message/3439045
-
Likp and LIPS table datasources | SCN
So it's enough to activate and use only the above-mentioned new logistick cockpit datasources...(but only the datasource related to the level for which you are interested ! it's not necessary to have all !)
http://scn.sap.com/message/731155
-
Where in se11 to make changes to mcLIPS | SCN
Skip to Content We're sorry, but you're attempting to access SCN content that was not migrated to the new SAP Community experience. ...
http://scn.sap.com/message/168567
-
Activate an index on LIPS table | SCN
Hello,
SAP recommending to activating an index on LIPS table.
I want to Activate the SAP delivered index LIPS~VBG on table LIPS
What are the steps to activating this index?
Are there any precautions that needs to take before activating this index.
Is index activate using SE11?
regards,
zerandib
http://scn.sap.com/message/13589945
-
VBAP - VBEP - LIPS | SCN
Hi,
I have an order with one item ( VBAP)
2 schedule lines in VBEP for the same item.
3 deliveries in LIPS for that item.
i want to display order with items, item schedule lines, deliveries if any.
How do i ralate these 3 tables ? or is there other solution?
Thanks,
M B
http://scn.sap.com/thread/340146
-
Field from LIPSd | SCN
I want to take the field pikmg from LIPSd into my program.But while executing it is showing the message that "LIPSD" is not defined in the ABAP Dictionary as a table, projection view or database view.
http://scn.sap.com/message/4004948
-
Relation between VBEP and LIPS/LIKP??? | SCN
I'm making a report where you can see each Scheduling Agreement of each position of an order.
http://scn.sap.com/message/4837209
-
User exit for LIPS table update | SCN
Hi all,
I am added one custome field to LIPS table,
And i want to enter data into that field before the LIPS table updating.
If there is any userexit for this,please suggest me....
Thanks and regard,
shiek
http://scn.sap.com/message/1897308
Related Tables
TABLE | Description | Functional Area |
---|---|---|
LIKP | SD Document: Delivery Header Data | Logistics Execution - Shipping |
VBAK | Sales Document: Header Data | SD - Sales |
VBRP | Billing Document: Item Data | SD - Billing |
VBFA | Sales Document Flow | SD - Basic Functions |
VBRK | Billing Document: Header Data | SD - Billing |
MARA | General Material Data | Logistics - Material Master |
EKPO | Purchasing Document Item | MM - Purchasing |
Transaction Codes for SAP Table LIPS
TCODE | Description | Functional Area |
---|---|---|
SPRO | Customizing - Edit Project | Basis - Customizing Project Management (IMG) |
SLIS | FI-SL Spec.Purpose Ledg. Info.System | FI - Information System |
VL02N | Change Outbound Delivery | Logistics Execution - Shipping |
VA01 | Create Sales Order | SD - Sales |
SE11 | ABAP Dictionary Maintenance | Basis - Dictionary Maintenance |
MIGO | Goods Movement | MM - Inventory Management |
VBKD | Bonus Buy: Condition Types | SD - Free Goods |
SE16 | Data Browser | Basis - Workbench Utilities |
FMs for SAP Table LIPS
FM | Description | Functional Area |
---|---|---|
REUSE_ALV_GRID_DISPLAY | Output of a simple list (single-line) | Basis - SAP List Viewer |
REUSE_ALV_COMMENTARY_WRITE | List body comment block output | BC - SAP List Viewer |
REUSE_ALV_EVENTS_GET | Returns table of possible events for a list type | BC - SAP List Viewer |
REUSE_ALV_LIST_DISPLAY | Output a simple list (single line or several lines) | BC - SAP List Viewer |
REUSE_ALV_FIELDCATALOG_MERGE | Create field catalog from dictionary structure or internal table | BC - SAP List Viewer |
SET_FOCUS | Set focus to active editor | Basis - ABAP Editor |
UI_FUNCTIONS | Anwendungsspezifische Funktionen des Varianten-Editors | Cross Application - Object Dependencies |
F4_FILENAME | F4 for filename / Filemanager support to locate file in a directory | PM - Plant Maintenance |
ABAP Reports for SAP Table LIPS
ABAP REPORT | Description | Functional Area |
---|---|---|
MV50AFZ1 | User Exit as of 21D for Delivery Processing | SD - Material Maintenance |
SAPMV50A | General Delivery Module Pool | Logistics Execution - Shipping |
MV50AFZZ | User Exit for Batch Determination | SD - Material Maintenance |
SPRSL | TEXT | 630 - Workbench Tools: Editors |
SDRQCR21 | Recovery of Sales and Delivery Requirements | SD - Basic Functions |
SAPMV45A | Sales Order Processing | SD - Sales |
SAPLIPW1 | Include SAPLIPW1 | |
RV60AFZC | User Exit for Billing | SD - Material Maintenance |
BW Datasources for SAP Table LIPS
BW DATASOURCE | Description | Functional Area |
---|---|---|
2LIS_12_VCITM | Delivery Item Data | SD - Sales and Distribution |
2LIS_11_VAITM | Sales Document Item Data | SD - Sales and Distribution |
2LIS_12_VCHDR | Delivery Header Data | SD - Sales and Distribution |
2LIS_13_VDITM | Billing Document Item Data | SD - Sales and Distribution |
2LIS_11_VAHDR | Sales Document Header Data | SD - Sales and Distribution |
2LIS_12_VCSCL | Sales-Shipping Schedule Line Delivery | SD - Sales and Distribution |
2LIS_11_V_SSL | Sales Document Order Delivery | SD - Sales and Distribution |
2LIS_08TRTLP | Shipment: Delivery Item Data by Section | SD - Sales and Distribution |
Authorization Objects for SAP Table LIPS
AUTHORIZATION OBJECT | Description | Functional Area |
---|---|---|
P_PERNR | HR: Master Data - Personnel Number Check | |
E_GRID | Authorization Object for Grid | |
V_VBAK_VKO | Sales Document: Authorization for Sales Areas | |
M_MATE_WRK | Material Master: Plants | |
E_VARIANT | Authorization Object for Variants | |
I_TCODE | PM: Transaction Code | |
I_FCODE | WCM: Function Codes (e.g. Operational Cycle) |
Most searched SAP Logistics Execution Tables
- Shipping Point Tables
- Shipment Tables
- Inbound Delivery Tables
- Storage Type Tables
- Storage Bin Tables
- Warehouse Number Tables
- Shipment Cost Tables
- Transfer Order Tables
- Route Tables
- Route Determination Tables
- Routes Tables
- Deliver Tables
- Warehouse Tables
- Freight Tables
- Material Wm Tables
- Storage Unit Tables
- Shipment Type Tables
- Transfer Requirement Tables
- Storage Section Tables
- Shipping Point Determination Tables
- Picking Tables
- Storage Unit Type Tables