I_LOGISTICSORDER

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.

-- Logistics Order
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_LOGISTICSORDER (
    ORDERID,
    _BASEUNIT,
    _BASICSCHEDULINGTYPE,
    _BILLOFOPERATIONS,
    _BILLOFOPERATIONSAPPLICATION,
    _BILLOFOPERATIONSCHANGESTATE,
    _BILLOFOPERATIONSGROUP,
    _BILLOFOPERATIONSGROUP2,
    _BILLOFOPERATIONSTYPE,
    _BILLOFOPERATIONSUSAGE,
    _BUSINESSAREA,
    _CAPACITYREQUIREMENT,
    _CHANGENUMBER,
    _COMPANYCODE,
    _CONFIRMATIONGROUP,
    _CONTROLLINGAREA,
    _CONTROLLINGOBJECTCLASS,
    _COSTCENTER,
    _CREATEDBYUSER,
    _CREATEDBYUSERCONTACTCARD,
    _CURRENCY,
    _FORECASTSCHEDULINGTYPE,
    _FUNCTIONALAREA,
    _GLACCOUNT,
    _INSPECTIONLOT,
    _LASTCHANGEDBYUSER,
    _LASTCHGDBYUSERCONTACTCARD,
    _LEADINGORDER,
    _LOCATIONPLANT,
    _LONGTEXT,
    _MAINTENANCEOBJECTLOCATION,
    _MAINWORKCENTERPLANT,
    _MRPCONTROLLER,
    _ORDERCATEGORY,
    _ORDERCOMPONENT,
    _ORDERINTERNALID,
    _ORDERITEM,
    _ORDERMAINITEM,
    _ORDEROPERATION,
    _ORDERPROCESSINGGROUP,
    _ORDERSEQUENCE,
    _ORDERTYPE,
    _ORDERTYPEDETAILS,
    _ORDINTERNALBILLOFOPERATIONS,
    _PLANT,
    _PRODUCTCOSTCOLLECTOR,
    _PRODUCTIONSCHEDULINGPROFILE,
    _PRODUCTIONSUPERVISOR,
    _PROFITCENTER,
    _PROJECT,
    _PROJECTBASICDATA,
    _PROJECTBASICDATA2,
    _REFERENCEORDER,
    _RESERVATION,
    _RESPONSIBLECOSTCENTER,
    _RESPONSIBLEPLANNERGROUP,
    _RFM_MASTERPRODUCTORDER,
    _SALESORDER,
    _SALESORDERITEM,
    _SCHEDULINGFLOATPROFILE,
    _SETTLEMENTRESERVATION,
    _STATUSOBJECT,
    _STATUSOBJECTSTATUS,
    _SUPERIORPROJECTNETWORK,
    _WBSELEMENT,
    _WBSELEMENTBASICDATA,
    _WBSELEMENTBASICDATA2,
    _WORKCENTER,
    ACTUALCOSTSCOSTINGVARIANT,
    ACTUALDELIVERYDATE,
    ACTUALENDDATE,
    ACTUALRELEASEDDATE,
    ACTUALSTARTDATE,
    ACTUALSTARTTIME,
    BASEUNIT,
    BASICSCHEDULINGTYPE,
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALINTERNALID,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFMATERIALVERSION,
    BILLOFOPERATIONS,
    BILLOFOPERATIONSAPPLICATION,
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSUSAGE,
    BILLOFOPERATIONSVARIANT,
    BILLOFOPERATIONSVERSION,
    BOMEXPLOSIONDATE,
    BOMVALIDITYSTARTDATE,
    BOOEXPLOSIONDATE,
    BOOINTERNALVERSIONCOUNTER,
    BOOVALIDITYSTARTDATE,
    BUSINESSAREA,
    CAPACITYACTIVEVERSION,
    CAPACITYREQUIREMENT,
    CAPACITYRQMTHASNOTTOBECREATED,
    CHANGENUMBER,
    CHANGETOSCHEDULEDDATESISMADE,
    COMPANYCODE,
    CONDITIONAPPLICATION,
    CONFIRMEDENDDATE,
    CONFIRMEDENDTIME,
    CONTROLLINGAREA,
    CONTROLLINGOBJECTCLASS,
    COSTCENTER,
    COSTELEMENT,
    COSTINGSHEET,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CURRENCY,
    ENGINEERINGCHANGEORDER,
    ENVIRONMENTALINVESTMENTREASON,
    ESTIMATEDTOTALORDERCOST,
    EVENTBASEDPOSTINGMETHOD,
    EVENTBASEDPROCESSINGKEY,
    EXTDQUALITYCHECKISREQUIRED,
    EXTERNALORDER,
    FLOATAFTERPRODUCTIONINWORKDAYS,
    FLOATBEFOREPRODUCTIONINWRKDAYS,
    FORECASTEDENDDATE,
    FORECASTEDENDTIME,
    FORECASTEDSTARTDATE,
    FORECASTEDSTARTTIME,
    FORECASTSCHEDULINGTYPE,
    FUNCTIONALAREA,
    GLACCOUNT,
    INSPECTIONLOT,
    INVESTMENTREASON,
    ISMARKEDFORDELETION,
    ISSTATISTICALORDER,
    JOINTVENTURE,
    JOINTVENTURECLASS,
    JOINTVENTUREOBJECTTYPE,
    JOINTVENTUREORIGINALCOSTOBJECT,
    JOINTVENTURESUBCLASS,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    LASTSCHEDULEDDATE,
    LEADINGORDER,
    LOCATIONPLANT,
    LONGTEXTLANGUAGE,
    MAINTENANCEOBJECTLOCATION,
    MAINWORKCENTER,
    MAINWORKCENTERPLANT,
    MASTERPRODUCTIONORDER,
    MATERIAL,
    MATERIALBASEUNIT,
    MATERIALFROMLOTSIZEQUANTITY,
    MATERIALREVISIONLEVEL,
    MATERIALREVISIONLEVEL_2,
    MATERIALTOLOTSIZEQUANTITY,
    MFGORDERCONFIRMATION,
    MFGORDERCONFIRMATIONCOUNT,
    MFGORDERCONFIRMEDREWORKQTY,
    MFGORDERHASMULTIPLEITEMS,
    MFGORDERHIERARCHYLEVEL,
    MFGORDERISPARTOFCOLLVORDER,
    MFGORDERISPRODUCTREWORKORDER,
    MFGORDERSPLITSTATUS,
    MFGORDERSUPERIORMFGORDER,
    MRPCONTROLLER,
    NETWORKPROFILE,
    NTWKACCOUNTASSIGNMENTCODE,
    OBJBASEDAUTHORIZATIONISACTIVE,
    OBJECTINTERNALID,
    ORDERCATEGORY,
    ORDERCONFIRMEDSCRAPQTY,
    ORDERCONFIRMEDYIELDQTY,
    ORDERDESCRIPTION,
    ORDERHASLONGTEXT,
    ORDERHIERARCHYLEVELVALUE,
    ORDERHIERARCHYPATHVALUE,
    ORDERINTERNALBILLOFOPERATIONS,
    ORDERISEVENTBASEDPOSTING,
    ORDERISNOTCOSTEDAUTOMATICALLY,
    ORDERISREFURBISHMENTORDER,
    ORDERPLANNEDSCRAPQTY,
    ORDERPLANNEDTOTALQTY,
    ORDERPROCESSINGGROUP,
    ORDERSEQUENCENUMBER,
    ORDERTYPE,
    ORDISNOTSCHEDLDAUTOMATICALLY,
    OVERHEADCODE,
    PLANNEDCOMPLETIONDATE,
    PLANNEDCOSTSCOSTINGVARIANT,
    PLANNEDENDDATE,
    PLANNEDENDTIME,
    PLANNEDRELEASEDATE,
    PLANNEDSTARTDATE,
    PLANNEDSTARTTIME,
    PLANNEDTOTALQTYINBASEUNIT,
    PLANT,
    PRIORITYCODE,
    PRODAVAILYCHECKPLANNINGTYPE,
    PRODNPROCGISFLEXIBLE,
    PRODUCTCONFIGURATION,
    PRODUCTCOSTCOLLECTOR,
    PRODUCTIONSCHEDULINGPROFILE,
    PRODUCTIONSUPERVISOR,
    PROFITCENTER,
    PROJECTINTERNALID,
    PROJECTINTERNALID_2,
    PROJINTERESTCALCPROFILE,
    REFERENCEORDER,
    RELEASEPERIODINWORKDAYS,
    REQUESTINGCOMPANYCODE,
    REQUESTINGCOSTCENTER,
    RESERVATION,
    RESPONSIBLECOSTCENTER,
    RESPONSIBLEPLANNERGROUP,
    RESULTANALYSISINTERNALID,
    SALESORDER,
    SALESORDERITEM,
    SCHEDULEDBASICENDDATE,
    SCHEDULEDBASICENDTIME,
    SCHEDULEDBASICSTARTDATE,
    SCHEDULEDBASICSTARTTIME,
    SCHEDULEDFCSTDRELEASEDATE,
    SCHEDULEDFORECASTEDENDDATE,
    SCHEDULEDFORECASTEDENDTIME,
    SCHEDULEDFORECASTEDSTARTDATE,
    SCHEDULEDFORECASTEDSTARTTIME,
    SCHEDULEDRELEASEDATE,
    SCHEDULINGFLOATPROFILE,
    SCHEDULINGISALLOWINGFORBREAKS,
    SETTLEMENTRESERVATION,
    SUPERIORPROJECTNETWORK,
    TAXJURISDICTION,
    TECHNICALCOMPLETIONDATE,
    TOTALCOMMITMENTDATE,
    VARIANCEKEY,
    WBSELEMENTINTERNALID,
    WBSELEMENTINTERNALID_2,
    PRIMARY KEY (ORDERID)
);