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