I_PROCORDMGMTOPCOMPBASIC

CDS View

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)

ViewTypeJoinVDMDescription
P_ProcOrdMgmtAllProductsAggr view from COMPOSITE
P_ProcOrdMgmtOpCompWithSts view from COMPOSITE
P_ProcOrdMgmtOpCompWithSts2 view from COMPOSITE

Fields (94)

KeyField CDS FieldsUsed 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)
);