I_MFGORDEROPERATIONCOMPWITHSTS
Manufacturing Order Component with Header Status
I_MFGORDEROPERATIONCOMPWITHSTS is a CDS View in S/4HANA. Manufacturing Order Component with Header Status. It contains 57 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_Operationcomponents | view | from | CONSUMPTION | Components |
| I_RFM_MfgOrderOpCompWithSts | view | from | COMPOSITE | Manufacturing Order Operation Component |
Fields (57)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | RecordType | RecordType | 2 |
| KEY | Reservation | Reservation | 2 |
| KEY | ReservationItem | ReservationItem | 2 |
| AlternativeItemGroup | AlternativeItemGroup | 1 | |
| Assembly | Assembly | 1 | |
| BaseUnit | BaseUnit | 2 | |
| Batch | Batch | 2 | |
| BatchMasterReservationItem | BatchMasterReservationItem | 1 | |
| BatchSplitType | BatchSplitType | 1 | |
| BillOfMaterial | BillOfMaterial | 1 | |
| BillOfMaterialCategory | BillOfMaterialCategory | 1 | |
| BillOfMaterialItemCategory | BillOfMaterialItemCategory | 1 | |
| BillOfMaterialItemNodeNumber | BillOfMaterialItemNodeNumber | 1 | |
| BillOfMaterialVariant | BillOfMaterialVariant | 1 | |
| BillOfMaterialVersion | BillOfMaterialVersion | 1 | |
| BOMItemDescription | BOMItemDescription | 2 | |
| BOMItemInternalChangeCount | BOMItemInternalChangeCount | 1 | |
| ComponentScrapInPercent | ComponentScrapInPercent | 1 | |
| DebitCreditCode | DebitCreditCode | 2 | |
| EffectivityParameterVariant | EffectivityParameterVariant | 1 | |
| EntryUnit | EntryUnit | 2 | |
| GoodsMovementEntryQty | GoodsMovementEntryQty | 2 | |
| InheritedBOMItemNode | InheritedBOMItemNode | 1 | |
| InventorySpecialStockType | InventorySpecialStockType | 2 | |
| IsBulkMaterialComponent | IsBulkMaterialComponent | 1 | |
| IsNetScrap | IsNetScrap | 2 | |
| ManufacturingOrder | ManufacturingOrder | 2 | |
| ManufacturingOrderCategory | ManufacturingOrderCategory | 2 | |
| ManufacturingOrderSequence | ManufacturingOrderSequence | 2 | |
| ManufacturingOrderType | ManufacturingOrderType | 2 | |
| Material | Material | 2 | |
| MaterialCompIsAlternativeItem | MaterialCompIsAlternativeItem | 1 | |
| MaterialCompIsIntraMaterial | MaterialCompIsIntraMaterial | 1 | |
| MaterialComponentIsMissing | MaterialComponentIsMissing | 1 | |
| MaterialComponentIsPhantomItem | MaterialComponentIsPhantomItem | 1 | |
| MatlCompIsMarkedForBackflush | MatlCompIsMarkedForBackflush | 2 | |
| MatlCompIsMarkedForDeletion | MatlCompIsMarkedForDeletion | 2 | |
| MatlCompIsTextItem | MatlCompIsTextItem | 1 | |
| MatlCompRequirementDate | MatlCompRequirementDate | 2 | |
| MatlCompRequirementTime | MatlCompRequirementTime | 2 | |
| MRPController | MRPController | 1 | |
| OperationScrapInPercent | OperationScrapInPercent | 1 | |
| OperationText | OperationText | 1 | |
| OrderIntBillOfOperationsItem | OrderIntBillOfOperationsItem | 1 | |
| OrderInternalBillOfOperations | OrderInternalBillOfOperations | 1 | |
| OriginalReservation | OriginalReservation | 1 | |
| OriginalReservationItem | OriginalReservationItem | 1 | |
| Plant | Plant | 2 | |
| ProductionPlant | ProductionPlant | 2 | |
| QuantityIsFixed | QuantityIsFixed | 2 | |
| RequiredQuantity | RequiredQuantity | 2 | |
| RequirementSegment | RequirementSegment | 1 | |
| ReservationIsFinallyIssued | ReservationIsFinallyIssued | 2 | |
| StockSegment | StockSegment | 1 | |
| StorageLocation | StorageLocation | 2 | |
| SupplyArea | SupplyArea | 2 | |
| WithdrawnQuantity | WithdrawnQuantity | 2 |
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 Component with Header Status
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MFGORDEROPERATIONCOMPWITHSTS (
RECORDTYPE,
RESERVATION,
RESERVATIONITEM,
ALTERNATIVEITEMGROUP,
ASSEMBLY,
BASEUNIT,
BATCH,
BATCHMASTERRESERVATIONITEM,
BATCHSPLITTYPE,
BILLOFMATERIAL,
BILLOFMATERIALCATEGORY,
BILLOFMATERIALITEMCATEGORY,
BILLOFMATERIALITEMNODENUMBER,
BILLOFMATERIALVARIANT,
BILLOFMATERIALVERSION,
BOMITEMDESCRIPTION,
BOMITEMINTERNALCHANGECOUNT,
COMPONENTSCRAPINPERCENT,
DEBITCREDITCODE,
EFFECTIVITYPARAMETERVARIANT,
ENTRYUNIT,
GOODSMOVEMENTENTRYQTY,
INHERITEDBOMITEMNODE,
INVENTORYSPECIALSTOCKTYPE,
ISBULKMATERIALCOMPONENT,
ISNETSCRAP,
MANUFACTURINGORDER,
MANUFACTURINGORDERCATEGORY,
MANUFACTURINGORDERSEQUENCE,
MANUFACTURINGORDERTYPE,
MATERIAL,
MATERIALCOMPISALTERNATIVEITEM,
MATERIALCOMPISINTRAMATERIAL,
MATERIALCOMPONENTISMISSING,
MATERIALCOMPONENTISPHANTOMITEM,
MATLCOMPISMARKEDFORBACKFLUSH,
MATLCOMPISMARKEDFORDELETION,
MATLCOMPISTEXTITEM,
MATLCOMPREQUIREMENTDATE,
MATLCOMPREQUIREMENTTIME,
MRPCONTROLLER,
OPERATIONSCRAPINPERCENT,
OPERATIONTEXT,
ORDERINTBILLOFOPERATIONSITEM,
ORDERINTERNALBILLOFOPERATIONS,
ORIGINALRESERVATION,
ORIGINALRESERVATIONITEM,
PLANT,
PRODUCTIONPLANT,
QUANTITYISFIXED,
REQUIREDQUANTITY,
REQUIREMENTSEGMENT,
RESERVATIONISFINALLYISSUED,
STOCKSEGMENT,
STORAGELOCATION,
SUPPLYAREA,
WITHDRAWNQUANTITY,
PRIMARY KEY (RECORDTYPE, RESERVATION, RESERVATIONITEM)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA