I_RESERVATIONITEM

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.

-- Reservation Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RESERVATIONITEM (
    MATERIAL,
    PLANT,
    RECORDTYPE,
    RESERVATION,
    RESERVATIONITEM,
    RSNUM,
    SCHEDULELINE,
    SUPPLIER,
    _BASEUNIT,
    _BATCH,
    _CURRENCY,
    _DEBITCREDITCODE,
    _ENTRYUNIT,
    _GOODSMOVEMENTTYPE,
    _INVENTORYSPECIALSTOCKTYPE,
    _ISSUINGORRECEIVINGPLANT,
    _ISSUINGORRECEIVINGSTORAGELOC,
    _MATERIAL,
    _PLANT,
    _PURCHASINGDOCUMENT,
    _PURCHASINGDOCUMENTITEM,
    _RECIPIENTLOCATIONCODE,
    _SERVICEDOCUMENTITEM,
    _STORAGELOCATION,
    _SUPPLIER,
    _SUPPLIERCOMPANYBYPLANT,
    _WBSELEMENTBASICDATA,
    ABLAD,
    ACCOUNTASSIGNMENTCATEGORY,
    AENNR,
    AFPOS,
    ALPOS,
    AUFNR,
    AUFST,
    AUFWG,
    AUSCH,
    AVOAU,
    BASEUNIT,
    BATCH,
    BAUGR,
    BAUST,
    BAUWG,
    BDMNG,
    BERKZ,
    BOM_VERSN,
    BWART,
    CHARG,
    CHOBJ,
    CLAKZ,
    COMPANYCODECURRENCY,
    CONFDQTYFORATPINBASEUOM,
    CONSUMPTIONPOSTING,
    CUOBJ,
    DEBITCREDITCODE,
    ENTRYUNIT,
    ENWRT,
    ESMNG,
    EWAHR,
    FIPEX,
    FKBER,
    FMENG,
    FSH_CRITICAL_COMP,
    FSH_CRITICAL_LEVEL,
    GLACCOUNT,
    GOODSMOVEMENTISALLOWED,
    GOODSMOVEMENTTYPE,
    GOODSRECIPIENTNAME,
    GSBER,
    INPOS,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYSPECIALSTOCKVALNTYPE,
    ISSUINGORRECEIVINGPLANT,
    ISSUINGORRECEIVINGSTORAGELOC,
    KBLNR,
    KFPOS,
    KZAUS,
    KZEAR,
    KZKUP,
    LGNUM,
    LGPLA,
    LGTYP,
    LIFNR,
    MANUFACTURINGORDEROPERATION,
    MATERIALCOMPISPROCUREDDIRECTLY,
    MATERIALGROUP,
    MATKL,
    MATLCOMPISMARKEDFORBACKFLUSH,
    MATLCOMPREQUIREMENTDATE,
    MATNR,
    NETAU,
    OBJNR,
    PLANNEDORDER,
    POTX1,
    POTX2,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    QUANTITYISFIXED,
    RECIPIENTLOCATIONCODE,
    REFERENCEORDER,
    REQUIREMENTTYPE,
    RESERVATIONITEMCREATIONCODE,
    RESERVATIONITEMISFINALLYISSUED,
    RESERVATIONITEMTEXT,
    RESERVATIONITMISMARKEDFORDELTN,
    RESVNACCOUNTISENTEREDMANUALLY,
    RESVNITMREQUIREDQTYINBASEUNIT,
    RESVNITMREQUIREDQTYINENTRYUNIT,
    RESVNITMSRVCDOCASACCTASGT,
    RESVNITMSRVCDOCITMASACCTASGT,
    RESVNITMSRVCDOCTYPEASACCTASGT,
    RESVNITMWITHDRAWNAMTINCCCRCY,
    RESVNITMWITHDRAWNQTYINBASEUNIT,
    RFORM,
    RGEKZ,
    ROHPS,
    ROMS1,
    ROMS2,
    ROMS3,
    SAKNR,
    SALESORDER,
    SALESORDERITEM,
    SANKA,
    SCHGT,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEOBJECTTYPE,
    SGT_RCAT,
    SGT_SCAT,
    SORTF,
    SPECIALSTOCKIDFGWBSELEMENT,
    SPLKZ,
    STLAL,
    STORAGELOCATION,
    STPOZ,
    STVKN,
    TECHS,
    TXTPS,
    UMREN,
    UMREZ,
    UNLOADINGPOINTNAME,
    WAERS,
    WERKS,
    XFEHL,
    XWAOK,
    PRIMARY KEY (MATERIAL, PLANT, RECORDTYPE, RESERVATION, RESERVATIONITEM, RSNUM, SCHEDULELINE, SUPPLIER)
);