I_MANUFACTURINGORDER

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.

-- Manufacturing Order
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MANUFACTURINGORDER (
    MANUFACTURINGORDER,
    MANUFACTURINGORDERCATEGORY,
    SALESORDERITEM,
    _ACTUALCOSTSCOSTINGVARIANT,
    _BASICSCHEDULINGTYPE,
    _BATCH,
    _BATCH_2,
    _BILLOFOPERATIONS,
    _BILLOFOPERATIONS2,
    _BILLOFOPERATIONSAPPLICATION,
    _BILLOFOPERATIONSCHANGESTATE,
    _BILLOFOPERATIONSCHANGESTATE2,
    _BILLOFOPERATIONSGROUP,
    _BILLOFOPERATIONSGROUP2,
    _BILLOFOPERATIONSMATERIAL,
    _BILLOFOPERATIONSTYPE,
    _BILLOFOPERATIONSUSAGE,
    _BUSINESSAREA,
    _CAPACITYREQUIREMENT,
    _CHANGENUMBER,
    _COMPANYCODE,
    _CONFIRMATIONGROUP,
    _CONTROLLINGAREA,
    _CONTROLLINGOBJECTCLASS,
    _COSTCENTER,
    _COSTELEMENT,
    _CREATEDBYUSER,
    _CURRENCY,
    _FORECASTSCHEDULINGTYPE,
    _FUNCTIONALAREA,
    _GLACCOUNT,
    _INSPECTIONLOT,
    _INVENTORYUSABILITYCODE,
    _LASTCHANGEDBYUSER,
    _LEADINGORDER,
    _LONGTEXT,
    _LONGTEXTLANGUAGE,
    _MATERIAL,
    _MATERIALREVISIONLEVEL2,
    _MFGORDERCATEGORY,
    _MFGORDERDOCINFORECORD,
    _MFGORDERIMPORTANCE,
    _MFGORDERITEM,
    _MFGORDERLONGTEXT,
    _MFGORDERMATERIALDOCITEM,
    _MFGORDEROPERATION,
    _MFGORDERSEQUENCE,
    _MFGORDERTYPE,
    _MRPAREA,
    _MRPCONTROLLER,
    _ORDERINTERNALID,
    _ORDERTYPEDETAILS,
    _PLANNEDCOSTSCOSTINGVARIANT,
    _PLANNEDORDER,
    _PLANNINGPLANT,
    _PRODUCT,
    _PRODUCTCOSTCOLLECTOR,
    _PRODUCTIONPLANT,
    _PRODUCTIONSCHEDULINGPROFILE,
    _PRODUCTIONSUPERVISOR,
    _PRODUCTIONUNIT,
    _PRODUCTPLANT,
    _PRODUCTPLANT2,
    _PRODUCTSTORAGELOCATION,
    _PRODUCTSTORAGELOCATION2,
    _PROFITCENTER,
    _REFERENCEORDER,
    _RESERVATION,
    _RESPONSIBLECOSTCENTER,
    _RESPONSIBLEPLANNERGROUP,
    _RFM_MASTERPRODUCTORDER,
    _SALESDOCUMENT,
    _SALESDOCUMENTITEM,
    _SALESORDER,
    _SALESORDERITEM,
    _SCHEDULINGFLOATPROFILE,
    _SETTLEMENTRESERVATION,
    _STORAGELOCATION,
    _SUPERIORORDER,
    _WBSELEMENT,
    _WBSELEMENTBASICDATA,
    _WBSELEMENTBASICDATA2,
    ACTUALCOSTSCOSTINGVARIANT,
    ACTUALDELIVEREDQUANTITY,
    BASICSCHEDULINGTYPE,
    BATCH,
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALINTERNALID,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFMATERIALVERSION,
    BILLOFOPERATIONS,
    BILLOFOPERATIONSAPPLICATION,
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSMATERIAL,
    BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSUSAGE,
    BILLOFOPERATIONSVARIANT,
    BILLOFOPERATIONSVERSION,
    BOMEXPLOSIONDATE,
    BOMVALIDITYSTARTDATE,
    BOOEXPLOSIONDATE,
    BOOINTERNALVERSIONCOUNTER,
    BOOVALIDITYSTARTDATE,
    BUSINESSAREA,
    CAPACITYACTIVEVERSION,
    CAPACITYREQUIREMENT,
    CAPACITYRQMTHASNOTTOBECREATED,
    CHANGENUMBER,
    CHANGETOSCHEDULEDDATESISMADE,
    COMPANYCODE,
    CONDITIONAPPLICATION,
    CONTROLLINGAREA,
    CONTROLLINGOBJECTCLASS,
    COSTCENTER,
    COSTELEMENT,
    COSTINGSHEET,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CURRENCY,
    EFFECTIVITYPARAMETERVARIANT,
    EVENTBASEDPOSTINGMETHOD,
    EXPECTEDDEVIATIONQUANTITY,
    EXTDQUALITYCHECKISREQUIRED,
    FLOATAFTERPRODUCTIONINWORKDAYS,
    FLOATBEFOREPRODUCTIONINWRKDAYS,
    FORECASTSCHEDULINGTYPE,
    FUNCTIONALAREA,
    GLACCOUNT,
    GOODSRECIPIENTNAME,
    INSPECTIONLOT,
    INVENTORYUSABILITYCODE,
    ISCOMPLETELYDELIVERED,
    ISMARKEDFORDELETION,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    LEADINGORDER,
    LONGTEXTLANGUAGECODE,
    MANUFACTURINGORDERHASLONGTEXT,
    MANUFACTURINGORDERIMPORTANCE,
    MANUFACTURINGORDERTEXT,
    MANUFACTURINGORDERTYPE,
    MASTERPRODUCTIONORDER,
    MATERIAL,
    MATERIALGOODSRECEIPTDURATION,
    MATERIALREVISIONLEVEL,
    MATERIALREVISIONLEVEL_2,
    MFGORDERACTUALCOMPLETIONDATE,
    MFGORDERACTUALENDDATE,
    MFGORDERACTUALRELEASEDATE,
    MFGORDERACTUALSTARTDATE,
    MFGORDERACTUALSTARTTIME,
    MFGORDERCONFIRMATION,
    MFGORDERCONFIRMEDENDDATE,
    MFGORDERCONFIRMEDENDTIME,
    MFGORDERCONFIRMEDREWORKQTY,
    MFGORDERCONFIRMEDSCRAPQTY,
    MFGORDERCONFIRMEDYIELDQTY,
    MFGORDERHASMULTIPLEITEMS,
    MFGORDERHIERARCHYLEVEL,
    MFGORDERINTERNALID,
    MFGORDERISPARTOFCOLLVORDER,
    MFGORDERITEMACTUALDELIVERYDATE,
    MFGORDERPLANNEDENDDATE,
    MFGORDERPLANNEDENDTIME,
    MFGORDERPLANNEDRELEASEDATE,
    MFGORDERPLANNEDSCRAPQTY,
    MFGORDERPLANNEDSTARTDATE,
    MFGORDERPLANNEDSTARTTIME,
    MFGORDERPLANNEDTOTALQTY,
    MFGORDERSCHEDULEDENDDATE,
    MFGORDERSCHEDULEDENDTIME,
    MFGORDERSCHEDULEDRELEASEDATE,
    MFGORDERSCHEDULEDSTARTDATE,
    MFGORDERSCHEDULEDSTARTTIME,
    MFGORDERSPLITSTATUS,
    MFGORDERTOTALCOMMITMENTDATE,
    MRPAREA,
    MRPCONTROLLER,
    NUMBEROFMFGORDERCONFIRMATIONS,
    NUMBEROFSERIALNUMBERS,
    OBJECTINTERNALID,
    ORDERISEVENTBASEDPOSTING,
    ORDERSEQUENCENUMBER,
    PLANNEDCOSTSCOSTINGVARIANT,
    PLANNEDORDER,
    PLANNINGPLANT,
    PRODNPROCGISFLEXIBLE,
    PRODUCT,
    PRODUCTCOLLECTION,
    PRODUCTCONFIGURATION,
    PRODUCTCOSTCOLLECTOR,
    PRODUCTIONPLANT,
    PRODUCTIONSCHEDULINGPROFILE,
    PRODUCTIONSUPERVISOR,
    PRODUCTIONUNIT,
    PRODUCTIONVERSION,
    PRODUCTSEASON,
    PRODUCTSEASONYEAR,
    PRODUCTTHEME,
    PROFITCENTER,
    QUANTITYDISTRIBUTIONKEY,
    REFERENCEORDER,
    RELEASEPERIODINWORKDAYS,
    RESERVATION,
    RESPONSIBLECOSTCENTER,
    RESPONSIBLEPLANNERGROUP,
    SALESORDER,
    SCHEDULINGFLOATPROFILE,
    SETTLEMENTRESERVATION,
    STOCKSEGMENT,
    STORAGELOCATION,
    SUPERIORORDER,
    UNLOADINGPOINTNAME,
    WBSELEMENTINTERNALID,
    WBSELEMENTINTERNALID_2,
    PRIMARY KEY (MANUFACTURINGORDER, MANUFACTURINGORDERCATEGORY, SALESORDERITEM)
);