LIPS

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- SD document: Delivery: Item data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LIPS (
    MANDT,                    -- Client [mandt]
    VBELN,                    -- Delivery [vbeln_vl]
    POSNR,                    -- Item [posnr_vl]
    PSTYV,                    -- Item Category [pstyv_vl]
    ERNAM,                    -- Created By [ernam]
    ERZET,                    -- Time [erzet]
    ERDAT,                    -- Created On [erdat]
    MATNR,                    -- Material [matnr]
    MATWA,                    -- MaterialEntered [matwa]
    MATKL,                    -- Material Group [matkl]
    WERKS,                    -- Plant [werks_d]
    LGORT,                    -- Location [lgort_d]
    CHARG,                    -- Batch [charg_d]
    LICHN,                    -- Supplier Batch [lichn]
    KDMAT,                    -- Customer Mat. [kdmat]
    PRODH,                    -- Prod. Hierarchy [prodh_d]
    LFIMG,                    -- Delivery Qty [lfimg]
    MEINS,                    -- Base Unit [meins]
    VRKME,                    -- Sales Unit [vrkme]
    UMVKZ,                    -- Numerator [umvkz]
    UMVKN,                    -- Denominat. [umvkn]
    NTGEW,                    -- Net Weight [ntgew_15]
    BRGEW,                    -- Gross Weight [brgew_15]
    GEWEI,                    -- Unit of Weight [gewei]
    VOLUM,                    -- Volume [volum_15]
    VOLEH,                    -- Volume Unit [voleh]
    KZTLF,                    -- Part.dlv./item [kztlf]
    UEBTK,                    -- Unlimited [uebtk]
    UEBTO,                    -- Overdeliv. Tol. [uebto]
    UNTTO,                    -- Underdel. Tol. [untto]
    CHSPL,                    -- Batch split [chspl]
    FAKSP,                    -- Billing Block [faksp]
    MBDAT,                    -- Mat.Avail.Date [mbdat]
    LGMNG,                    -- Qty (stckp.unt) [lgmng]
    ARKTX,                    -- Item Descr. [arktx]
    LGPBE,                    -- Storage Bin [lgpbe]
    VBELV,                    -- Originating Doc [vbelv]
    POSNV,                    -- Origin. Item [posnv]
    VBTYV,                    -- Document Cat. [vbtypl]
    VGSYS,                    -- PrDocLogSys [vglogsys]
    VGBEL,                    -- Reference Doc. [vgbel]
    VGPOS,                    -- Reference Item [vgpos]
    UPFLU,                    -- Update doc.flow [upfll]
    UEPOS,                    -- Higher-Lev.Item [uepos]
    FKREL,                    -- Relev.for Bill. [fkrel]
    BATCH_BILLING_VARIANT,    -- BatchItmBillVar [sdbil_batch_billing_variant]
    LADGR,                    -- Loading Group [ladgr]
    TRAGR,                    -- Trans. Group [tragr]
    KOMKZ,                    -- Picking ID [komkz]
    LGNUM,                    -- Warehouse No. [lgnum]
    LISPL,                    -- Whse no. split [lnspl_lips]
    LGTYP,                    -- Storage Type [lgtyp]
    LGPLA,                    -- Storage Bin [lgpla]
    BWTEX,                    -- Separate val. [bwtex]
    ETTYP,                    -- Sched.Line Cat. [ettyp]
    BWART,                    -- Movement Type [bwart]
    BWLVS,                    -- Movement Type [bwlvs]
    KZDLG,                    -- Ind.dynamic bin [lvs_kzdlg]
    BDART,                    -- RequirementType [bdart]
    PLART,                    -- Planning type [plart]
    MTART,                    -- Material Type [mtart]
    XCHPF,                    -- Batch Mgmt Rqt [xchpf]
    XCHAR,                    -- Batches [xchar]
    VGREF,                    -- Preced. with ref. [vgref]
    POSAR,                    -- Item Type [posar]
    BWTAR,                    -- Valuation Type [bwtar_d]
    SUMBD,                    -- Req'mt totals. [sumbd]
    MTVFP,                    -- Avail. check [mtvfp]
    EANNR,                    -- EAN Number [eannr]
    GSBER,                    -- Business Area [gsber]
    VKBUR,                    -- Sales Office [vkbur]
    VKGRP,                    -- Sales Group [vkgrp]
    VTWEG,                    -- Distr. Channel [vtweg]
    SPART,                    -- Division [spart]
    GRKOR,                    -- Delivery Group [grkor]
    FMENG,                    -- Qty. is fixed [fmeng]
    ANTLF,                    -- Max.Part.Deliv. [antlf]
    VBEAF,                    -- Fixed proc.time [vbeaf]
    VBEAV,                    -- Var. proc. time [vbeav]
    STAFO,                    -- Update Group [stafo]
    WAVWR,                    -- Cost [wavwr]
    KZWI1,                    -- Subtotal 1 [kzwi1]
    KZWI2,                    -- Subtotal 2 [kzwi2]
    KZWI3,                    -- Subtotal 3 [kzwi3]
    KZWI4,                    -- Subtotal 4 [kzwi4]
    KZWI5,                    -- Subtotal 5 [kzwi5]
    KZWI6,                    -- Subtotal 6 [kzwi6]
    SOBKZ,                    -- Special Stock [sobkz]
    AEDAT,                    -- Changed On [aedat]
    EAN11,                    -- EAN/UPC [ean11]
    KVGR1,                    -- Customer Grp 1 [kvgr1]
    KVGR2,                    -- Customer Grp 2 [kvgr2]
    KVGR3,                    -- Customer Grp 3 [kvgr3]
    KVGR4,                    -- Customer Grp 4 [kvgr4]
    KVGR5,                    -- Customer Grp 5 [kvgr5]
    MVGR1,                    -- MaterialGroup 1 [mvgr1]
    MVGR2,                    -- MaterialGroup 2 [mvgr2]
    MVGR3,                    -- MaterialGroup 3 [mvgr3]
    MVGR4,                    -- MaterialGroup 4 [mvgr4]
    MVGR5,                    -- MaterialGroup 5 [mvgr5]
    VPZUO,                    -- Allocation Ind. [vpzuo]
    VGTYP,                    -- Prec.Doc.Categ. [vbtypl_v]
    RFVGTYP,                  -- PrecedDocCentrl [rfvgtypl]
    KOSTL,                    -- Cost Center [kostl]
    KOKRS,                    -- CO Area [kokrs]
    PAOBJNR,                  -- Profit. segment [rkeobjnr]
    PRCTR,                    -- Profit Center [prctr]
    PS_PSP_PNR,               -- WBS Element [ps_psp_pnr]
    AUFNR,                    -- Order [aufnr]
    POSNR_PP,                 -- Item Number [co_posnr]
    VORNR,                    -- Activity [vornr]
    RECIPIENT_LOCATION_CODE,  -- Recipient Loc. [recipient_location_code]
    AUFPL,                    -- Plan No.f.Oper. [co_aufpl]
    APLZL,                    -- Counter [cim_count]
    KDAUF,                    -- Sales Order [kdauf]
    KDPOS,                    -- Sales Ord. Item [kdpos]
    VPMAT,                    -- Plng material [vpmat]
    VPWRK,                    -- Planning Plant [vpwrk]
    PRBME,                    -- Prod. grp unit [prbme]
    UMREF,                    -- Conversion [umreff]
    KNTTP,                    -- Acct Assgmt Cat [knttp]
    KZVBR,                    -- Consumption [kzvbr]
    FIPOS,                    -- Commitment item [fipos]
    FISTL,                    -- Funds Center [fistl]
    GEBER,                    -- Fund [bp_geber]
    PCKPF,                    -- Packing Control [pckpf]
    BEDAR_LF,                 -- Reqmts Class [bedar]
    CMPNT,                    -- Credit Active [cmpnt]
    KCMENG,                   -- Cumul.batch qty [kcmeng]
    KCBRGEW,                  -- Cum.gross wght [kcbrgew]
    KCNTGEW,                  -- Cumul.net wght [kcntgew]
    KCVOLUM,                  -- Cumul.volume [kcvolum]
    UECHA,                    -- HghLevItmBatch [uecha]
    CUOBJ,                    -- Configuration [cuobj_va]
    CUOBJ_CH,                 -- Int.object no. [cuobj_ch]
    ANZSN,                    -- No.serial no. [anzsn]
    SERAIL,                   -- SerialNoProfile [serail]
    KCGEWEI,                  -- Unit of Weight [gewei]
    KCVOLEH,                  -- Volume Unit [voleh]
    SERNR,                    -- BOM expl.number [sernr]
    ABRLI,                    -- Int.dlv.scd.no. [abrli]
    ABART,                    -- Release type [abart]
    ABRVW,                    -- Usage [abrvw]
    QPLOS,                    -- Inspection Lot [qplos]
    QTLOS,                    -- Partial Lot [qtlos]
    NACHL,                    -- No GR posted [nachl]
    MAGRV,                    -- Matl Grp Pckmat [magrv]
    OBJKO,                    -- Object No. Hdr [objko]
    OBJPO,                    -- ObjNo Item [objpo]
    AESKD,                    -- Engin. Change [aeskd]
    SHKZG,                    -- Returns [shkzg_dlv]
    PROSA,                    -- MatDetermActive [prosa]
    UEPVW,                    -- Usage HL Item [uepvw]
    EMPST,                    -- Recv. Point [empst]
    ABTNR,                    -- Department [abtnr]
    KOQUI,                    -- Confirmation [koqui]
    STADAT,                   -- Statistics Date [stadat]
    AKTNR,                    -- Promotion [waktion]
    KNUMH_CH,                 -- NoCondRec.Batch [knumh_ch]
    PREFE,                    -- Cus. Preference [prefe]
    EXART,                    -- Bus.Trans.Type [exart]
    CLINT,                    -- Int class no. [clint]
    CHMVS,                    -- Qty proposal [chmvs]
    ABELN,                    -- Alloc. Table [abeln]
    ABELP,                    -- Item [abelp]
    LFIMG_FLO,                -- Internal field/ Do not use / LFIMG in float / MUM [lfimg_flo]
    LGMNG_FLO,                -- Internal field/ Do not use / LGMNG in float / MUM [lgmng_flo]
    KCMENG_FLO,               -- Internal field/ Do not use / KCMENG in float / MUM [kcmeng_flo]
    KZUMW,                    -- Envt. relevant [kzumw]
    KMPMG,                    -- Quantity [kmpmg]
    AUREL,                    -- AT-Relevant [aurel]
    KPEIN,                    -- Pricing Unit [kpein]
    KMEIN,                    -- Unit of Measure [kmein]
    NETPR,                    -- Net Price [netpr]
    NETWR,                    -- Net Value [netwr]
    KOWRR,                    -- Stat. Value [kowrr]
    KZBEW,                    -- Movement ind. [kzbew]
    MFRGR,                    -- Mat.Freight Grp [mfrgr]
    CHHPV,                    -- Pack acc.batch [chhpv]
    ABFOR,                    -- PaytGuarantForm [absform_cm]
    ABGES,                    -- Guaranteed [abges_cm]
    MBUHR,                    -- Matl Staging Tme [mbuhr]
    WKTNR,                    -- Value Contract No. [wktnr]
    WKTPS,                    -- Val. Cont.Item [wktps]
    J_1BCFOP,                 -- CFOP [j_1bcfop]
    J_1BTAXLW1,               -- ICMS Law [j_1btaxlw1]
    J_1BTAXLW2,               -- IPI Law [j_1btaxlw2]
    J_1BTXSDC,                -- Tax Code [j_1btxsdc_]
    SITUA,                    -- Situation [situa]
    RSNUM,                    -- Reservation [rsnum]
    RSPOS,                    -- Item no. [rspos]
    RSART,                    -- Record type [rsart]
    KANNR,                    -- Sequence Number [kannr]
    KZFME,                    -- Leading UoM [kzfme]
    PROFL,                    -- DGIndProfile [adge_profl]
    KCMENGVME,                -- Cumul.batch qty [kcmeng_vme]
    KCMENGVMEF,               -- Cumulated batch split quantity in VRKME and float [kcmengvmef]
    KZBWS,                    -- Valuation [kzbws]
    PSPNR,                    -- Project def. [ps_intnr]
    EPRIO,                    -- Withdr.Seq.Grp [eprio]
    RULES,                    -- Stk Determ.Rule [bf_rules]
    KZBEF,                    -- Inv.Mgmt active [lvs_kzbef]
    MPROF,                    -- Mfr Part Profile [mprof]
    EMATN,                    -- MPN: Material [ematn]
    LGBZO,                    -- Staging Area [lgbzo]
    HANDLE,                   -- Key [tsegguid_lips]
    VERURPOS,                 -- Orig. item [verurpos]
    LIFEXPOS,                 -- Ext. item [lifexpos]
    NOATP,                    -- No avail. check [no_atp_check]
    NOPCK,                    -- Not rel.picking [no_picking]
    RBLVS,                    -- RefMvtType WM [rblvs]
    BERID,                    -- MRP Area [berid]
    BESTQ,                    -- Stock Category [bestq]
    UMBSQ,                    -- Stock Category [bestq]
    UMMAT,                    -- Receiving Mat. [ummat]
    UMWRK,                    -- Receiving plant [umwrk]
    UMLGO,                    -- Receiving SLoc. [umlgo]
    UMCHA,                    -- Receiving Batch [umcha]
    UMBAR,                    -- Val. Type Tfr. [umbar]
    UMSOK,                    -- Sp.ind.st.tfr. [umsok]
    SONUM,                    -- Spec.Stock No. [lvs_sonum]
    USONU,                    -- Spec.Stock No. [lvs_sonum]
    AKKUR,                    -- LettofCredRate [akkur]
    AKMNG,                    -- Current qty [akmng]
    VKGRU,                    -- Class. of Items [vkgru]
    SHKZG_UM,                 -- Main posting id [shkzg_um]
    INSMK,                    -- Stock Type [mb_insmk]
    KZECH,                    -- Enter batch [kzech]
    FLGWM,                    -- Indicator: Copy dest. storage data from preceding document [flgwm]
    BERKZ,                    -- Staging Ind. [berkz]
    HUPOS,                    -- Indicator: Delivery item is a HU item [hupos]
    NOWAB,                    -- No gds movement [nowab]
    KONTO,                    -- G/L Account [saknr]
    KZEAR,                    -- Final Issue [kzear]
    HSDAT,                    -- Date of Manuf. [hsdat]
    VFDAT,                    -- SLED/BBD [vfdat]
    LFGJA,                    -- Year Cur.Period [lfgja]
    LFBNR,                    -- Reference Doc. [lfbnr]
    LFPOS,                    -- Ref. Doc. Item [lfpos]
    GRUND,                    -- Reason for mvt. [mb_grund]
    FOBWA,                    -- Sub.movmnt type [fobwa]
    DLVTP,                    -- Delivery Cat. [dlvtp]
    EXBWR,                    -- Ext. Amount LC [exbwr]
    BPMNG,                    -- Qty in OPUn [bpmng]
    EXVKW,                    -- Sales Value [exvkw]
    CMPRE_FLT,                -- Credit Price [cmpre_flt]
    KZPOD,                    -- POD indicator [kzpod]
    LFDEZ,                    -- Not WMS-relevnt [lfdez]
    UMREV,                    -- ConversionFactr [le_umrev]
    PODREL,                   -- POD rel. RC/SC [podrel]
    KZUML,                    -- St.tfr./tfr.pst [kzuml]
    FKBER,                    -- Functional Area [fkber]
    GRANT_NBR,                -- Grant [gm_grant_nbr]
    KZWSO,                    -- Units meas. use [kzwso]
    GMCONTROL,                -- Gds mvmt contrl [gmcontrol]
    POSTING_CHANGE,           -- WBWKZ [posting_change]
    UM_PS_PSP_PNR,            -- Trsfr WBS Elmnt [um_ps_psp_pnr]
    PRE_VL_ETENS,             -- Sequential No. [etens]
    SPE_GEN_ELIKZ,            -- Deliv. Compl. [elikz]
    SPE_SCRAP_IND,            -- Scrap Indicator [/spe/delivery_scrap_ind]
    SPE_AUTH_NUMBER,          -- RMA Number [/spe/ret_rma]
    SPE_INSPOUT_GUID,         -- Inspection GUID [/spe/insp_out_guid_16]
    SPE_FOLLOW_UP,            -- Follow-Up Code [/spe/ret_follow_up]
    SPE_EXP_DATE_EXT,         -- End Validity Period [/spe/ret_expiry_date_ext]
    SPE_EXP_DATE_INT,         -- End internal val. [/spe/ret_expiry_date_int]
    SPE_AUTH_COMPLET,         -- RMA No. Completed [/spe/ret_rma_completed]
    ORMNG,                    -- Delivery Qty [ormng_vl]
    SPE_ATP_TMSTMP,           -- ATP Time Stamp [/spe/de_atp_timestamp]
    SPE_ORIG_SYS,             -- Original System Type [/spe/inb_origin_sys]
    SPE_LIEFFZ,               -- CQ Vendor [/spe/lieffz]
    SPE_IMWRK,                -- In Plant [/spe/imwrk_item]
    SPE_LIFEXPOS2,            -- Ext. ident. [/spe/de_ext_ident]
    SPE_EXCEPT_CODE,          -- Except.Code WH [/spe/inb_except_code_wm]
    SPE_KEEP_QTY,             -- Retention Qty [/spe/keep_quantity]
    SPE_ALTERNATE,            -- Alt.ProdNr. [/spe/de_alternate_part_nr]
    SPE_MAT_SUBST,            -- Reasn [/spe/mat_subst]
    SPE_STRUC,                -- Structure [/spe/struc]
    SPE_APO_QNTYFAC,          -- Numerator [apoquanfactor]
    SPE_APO_QNTYDIV,          -- Denominator [apoquandivisor]
    SPE_HERKL,                -- C/R of Origin [herkl]
    SPE_BXP_DATE_EXT,         -- Begin Valid. Period [/spe/ret_expiry_date_ext_b]
    SPE_VERSION,              -- DeliveryVsn [/spe/de_dlv_version]
    SPE_COMPL_MVT,            -- GM Completion [/spe/compl_mvt]
    J_1BTAXLW4,               -- COFINS Law [j_1btaxlw4]
    J_1BTAXLW5,               -- PIS Law [j_1btaxlw5]
    J_1BTAXLW3,               -- ISS Law [j_1btaxlw3]
    BUDGET_PD,                -- Budget Period [fm_budget_period]
    KBNKZ,                    -- Kanban Indicat. [kbnkz]
    FARR_RELTYPE,             -- Type [farr_reltype]
    SITKZ,                    -- Spec.Iss. Val. SiT [sitkz]
    SGT_RCAT,                 -- Req. Segment [sgt_rcat]
    SGT_SCAT,                 -- Stock Segment [sgt_scat]
    RESOURCE_ID,              -- Resource [le_resourcename_sid]
    UMRESOURCE_ID,            -- Receiv. Resource [le_resourcename_cid]
    FLPKZ,                    -- Fld. Logs. Ind. [flpkz]
    LOADING_POINT,            -- Load./Unload. Pt [/scmtms/loading_point_id]
    SOLUTION_ORDER_ID,        -- Solution Order [crms4_solo_object_id]
    SOLUTION_ORDER_ITM_ID,    -- Item Number in Doc. [crms4_number_int]
    SPE_HERKR,                -- Reg. of Origin [herkr]
    ITM_COMCO,                -- Commodity Code [/sapsll/comco]
    WEMPF,                    -- Recipient [wempf]
    CREATION_TS,              -- Time Stamp [timestampl]
    CHANGED_TS,               -- Time Stamp [timestampl]
    PIKMG_WH,                 -- Pick quantity [pikmg_wh]
    PIKMG_WH_BU,              -- Pick quantity [pikmg_wh_bu]
    SERVICE_DOC_TYPE,         -- Service Doc. Type [fco_srvdoc_type]
    SERVICE_DOC_ID,           -- Service Document [fco_srvdoc_id]
    SERVICE_DOC_ITEM_ID,      -- Service Doc. Item [fco_srvdoc_item_id]
    SERVICE_ORDER_ID,         -- Service Order [crms4_srv_id]
    SERVICE_ORDER_ITEM_ID,    -- Service Order Item [crms4_srv_itm_id]
    _DATAAGING,               -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, VBELN, POSNR)
);