I_PROCORDMGMTOPCOMPBASIC
Process Order Operation Comp Basic
I_PROCORDMGMTOPCOMPBASIC is a CDS View in S/4HANA. Process Order Operation Comp Basic. It contains 94 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_ProcOrdMgmtAllProductsAggr | view | from | COMPOSITE | |
| P_ProcOrdMgmtOpCompWithSts | view | from | COMPOSITE | |
| P_ProcOrdMgmtOpCompWithSts2 | view | from | COMPOSITE |
Fields (94)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | RecordType | RecordType | 2 |
| KEY | Reservation | Reservation | 2 |
| KEY | ReservationItem | ReservationItem | 2 |
| AccountAssignmentCategory | AccountAssignmentCategory | 2 | |
| BaseUnit | BaseUnit | 2 | |
| Batch | Batch | 2 | |
| BatchSplitType | BatchSplitType | 2 | |
| BillOfMaterialCategory | BillOfMaterialCategory | 2 | |
| BillOfMaterialInternalID | BillOfMaterialInternalID | 2 | |
| BillOfMaterialItemNumber | BillOfMaterialItemNumber | 2 | |
| BillOfMaterialVariant | BillOfMaterialVariant | 2 | |
| BOMExplosionDateID | BOMExplosionDateID | 2 | |
| BOMItem | BillOfMaterialItemNodeNumber | 2 | |
| BOMItemCategory | BillOfMaterialItemCategory | 2 | |
| BOMItemDescription | BOMItemDescription | 2 | |
| BusinessArea | BusinessArea | 2 | |
| ChangeNumber | ChangeNumber | 2 | |
| CompanyCode | CompanyCode | 2 | |
| ComponentScrapInPercent | ComponentScrapInPercent | 2 | |
| ConfirmedAvailableQuantity | ConfirmedAvailableQuantity | 2 | |
| ConsumptionPosting | ConsumptionPosting | 2 | |
| DebitCreditCode | DebitCreditCode | 2 | |
| DeliveryDurationInDays | DeliveryDurationInDays | 2 | |
| EffectivityParameterVariant | EffectivityParameterVariant | 2 | |
| EntryUnit | EntryUnit | 2 | |
| FormulaKey | FormulaKey | 2 | |
| FunctionalArea | FunctionalArea | 2 | |
| GLAccount | GLAccount | 2 | |
| GoodsMovementEntryQty | GoodsMovementEntryQty | 2 | |
| GoodsMovementIsAllowed | GoodsMovementIsAllowed | 2 | |
| GoodsMovementType | GoodsMovementType | 2 | |
| GoodsRecipientName | GoodsRecipientName | 2 | |
| InventorySpecialStockType | InventorySpecialStockType | 2 | |
| InventorySpecialStockValnType | InventorySpecialStockValnType | 2 | |
| IsBulkMaterialComponent | IsBulkMaterialComponent | 2 | |
| IsNetScrap | IsNetScrap | 2 | |
| LeadingReservationItem | LeadingReservationItem | 2 | |
| LeadTimeOffset | LeadTimeOffset | 2 | |
| LongTextExists | LongTextExists | 2 | |
| LongTextLanguageCode | LongTextLanguageCode | 2 | |
| ManufacturingOrder | ManufacturingOrder | 2 | |
| ManufacturingOrderCategory | ManufacturingOrderCategory | 2 | |
| ManufacturingOrderOperation | ManufacturingOrderOperation | 1 | |
| ManufacturingOrderSequence | ManufacturingOrderSequence | 2 | |
| ManufacturingOrderType | ManufacturingOrderType | 2 | |
| Material | Material | 2 | |
| MaterialCompIsAlternativeItem | MaterialCompIsAlternativeItem | 2 | |
| MaterialCompIsCostRelevant | MaterialCompIsCostRelevant | 2 | |
| MaterialCompIsIntraMaterial | MaterialCompIsIntraMaterial | 2 | |
| MaterialCompIsVariableSized | MaterialCompIsVariableSized | 2 | |
| MaterialComponentIsClassified | MaterialComponentIsClassified | 2 | |
| MaterialComponentIsMissing | MaterialComponentIsMissing | 2 | |
| MaterialComponentIsPhantomItem | MaterialComponentIsPhantomItem | 2 | |
| MaterialCompOriginalQuantity | MaterialCompOriginalQuantity | 2 | |
| MaterialGroup | MaterialGroup | 2 | |
| MatlCompDiscontinuationType | MatlCompDiscontinuationType | 2 | |
| MatlCompIsConfigurable | MatlCompIsConfigurable | 2 | |
| MatlCompIsMarkedForBackflush | MatlCompIsMarkedForBackflush | 2 | |
| MatlCompIsMarkedForDeletion | MatlCompIsMarkedForDeletion | 2 | |
| MatlCompIsTextItem | MatlCompIsTextItem | 2 | |
| MatlCompRequirementDate | MatlCompRequirementDate | 2 | |
| MatlCompRequirementTime | MatlCompRequirementTime | 2 | |
| OperationLeadTimeOffset | OperationLeadTimeOffset | 2 | |
| OperationLeadTimeOffsetUnit | OperationLeadTimeOffsetUnit | 2 | |
| OperationScrapInPercent | OperationScrapInPercent | 2 | |
| OrderIntBillOfOperationsItem | OrderIntBillOfOperationsItem | 1 | |
| OrderInternalBillOfOperations | OrderInternalBillOfOperations | 1 | |
| OrderLevelValue | OrderLevelValue | 2 | |
| OrderPathValue | OrderPathValue | 2 | |
| Plant | Plant | 2 | |
| ProductConfiguration | ProductConfiguration | 2 | |
| ProductionPlant | ProductionPlant | 2 | |
| ProductionSupervisor | ProductionSupervisor | 2 | |
| PurchasingGroup | PurchasingGroup | 2 | |
| PurchasingInfoRecord | PurchasingInfoRecord | 2 | |
| QuantityIsFixed | QuantityIsFixed | 2 | |
| RequirementSegment | RequirementSegment | 2 | |
| RequirementType | RequirementType | 2 | |
| ReservationIsFinallyIssued | ReservationIsFinallyIssued | 2 | |
| ReservationItemCreationCode | ReservationItemCreationCode | 2 | |
| SalesOrder | SalesOrder | 2 | |
| SalesOrderItem | SalesOrderItem | 2 | |
| StockSegment | StockSegment | 2 | |
| StorageBin | StorageBin | 2 | |
| StorageLocation | StorageLocation | 2 | |
| StorageType | StorageType | 2 | |
| SupplyArea | SupplyArea | 2 | |
| UnloadingPointName | UnloadingPointName | 2 | |
| UsageProbabilityPercent | UsageProbabilityPercent | 2 | |
| VariableSizeComponentQuantity | VariableSizeComponentQuantity | 2 | |
| VariableSizeComponentUnit | VariableSizeComponentUnit | 2 | |
| Warehouse | Warehouse | 2 | |
| WBSElementInternalID | WBSElementInternalID | 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.
-- Process Order Operation Comp Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PROCORDMGMTOPCOMPBASIC (
RECORDTYPE,
RESERVATION,
RESERVATIONITEM,
ACCOUNTASSIGNMENTCATEGORY,
BASEUNIT,
BATCH,
BATCHSPLITTYPE,
BILLOFMATERIALCATEGORY,
BILLOFMATERIALINTERNALID,
BILLOFMATERIALITEMNUMBER,
BILLOFMATERIALVARIANT,
BOMEXPLOSIONDATEID,
BOMITEM,
BOMITEMCATEGORY,
BOMITEMDESCRIPTION,
BUSINESSAREA,
CHANGENUMBER,
COMPANYCODE,
COMPONENTSCRAPINPERCENT,
CONFIRMEDAVAILABLEQUANTITY,
CONSUMPTIONPOSTING,
DEBITCREDITCODE,
DELIVERYDURATIONINDAYS,
EFFECTIVITYPARAMETERVARIANT,
ENTRYUNIT,
FORMULAKEY,
FUNCTIONALAREA,
GLACCOUNT,
GOODSMOVEMENTENTRYQTY,
GOODSMOVEMENTISALLOWED,
GOODSMOVEMENTTYPE,
GOODSRECIPIENTNAME,
INVENTORYSPECIALSTOCKTYPE,
INVENTORYSPECIALSTOCKVALNTYPE,
ISBULKMATERIALCOMPONENT,
ISNETSCRAP,
LEADINGRESERVATIONITEM,
LEADTIMEOFFSET,
LONGTEXTEXISTS,
LONGTEXTLANGUAGECODE,
MANUFACTURINGORDER,
MANUFACTURINGORDERCATEGORY,
MANUFACTURINGORDEROPERATION,
MANUFACTURINGORDERSEQUENCE,
MANUFACTURINGORDERTYPE,
MATERIAL,
MATERIALCOMPISALTERNATIVEITEM,
MATERIALCOMPISCOSTRELEVANT,
MATERIALCOMPISINTRAMATERIAL,
MATERIALCOMPISVARIABLESIZED,
MATERIALCOMPONENTISCLASSIFIED,
MATERIALCOMPONENTISMISSING,
MATERIALCOMPONENTISPHANTOMITEM,
MATERIALCOMPORIGINALQUANTITY,
MATERIALGROUP,
MATLCOMPDISCONTINUATIONTYPE,
MATLCOMPISCONFIGURABLE,
MATLCOMPISMARKEDFORBACKFLUSH,
MATLCOMPISMARKEDFORDELETION,
MATLCOMPISTEXTITEM,
MATLCOMPREQUIREMENTDATE,
MATLCOMPREQUIREMENTTIME,
OPERATIONLEADTIMEOFFSET,
OPERATIONLEADTIMEOFFSETUNIT,
OPERATIONSCRAPINPERCENT,
ORDERINTBILLOFOPERATIONSITEM,
ORDERINTERNALBILLOFOPERATIONS,
ORDERLEVELVALUE,
ORDERPATHVALUE,
PLANT,
PRODUCTCONFIGURATION,
PRODUCTIONPLANT,
PRODUCTIONSUPERVISOR,
PURCHASINGGROUP,
PURCHASINGINFORECORD,
QUANTITYISFIXED,
REQUIREMENTSEGMENT,
REQUIREMENTTYPE,
RESERVATIONISFINALLYISSUED,
RESERVATIONITEMCREATIONCODE,
SALESORDER,
SALESORDERITEM,
STOCKSEGMENT,
STORAGEBIN,
STORAGELOCATION,
STORAGETYPE,
SUPPLYAREA,
UNLOADINGPOINTNAME,
USAGEPROBABILITYPERCENT,
VARIABLESIZECOMPONENTQUANTITY,
VARIABLESIZECOMPONENTUNIT,
WAREHOUSE,
WBSELEMENTINTERNALID,
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