I_PRODUCTIONROUTINGSUBOP

CDS View
71 Fields 3 CDS Views

Prodn Routing - SubOperation Details

I_PRODUCTIONROUTINGSUBOP is a CDS View in S/4HANA. Prodn Routing - SubOperation Details. It contains 71 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ProdnRtgSubordOpToOperation view_entity from COMPOSITE Prodn Rtg Subperation to Operation
I_ProductionRoutingSubOpTP view_entity from TRANSACTIONAL Transaction View for Production Routing Sub Operation
R_ProductionRoutingSubopTP_2 view_entity from TRANSACTIONAL Production Routing Sub Operation

Fields (71)

KeyField CDS FieldsUsed in Views
KEY BillOfOperationsGroup ProductionRoutingGroup 2
KEY BillOfOperationsSequence ProductionRoutingSequence 2
KEY BillOfOperationsVariant ProductionRouting 2
KEY BOOOperationInternalID ProductionRoutingOpIntID 2
KEY BOOOpInternalVersionCounter ProdnRtgSubOpIntVersion 2
_Supplier _Supplier 1
_SupplierCompanyByPlant _SupplierCompanyByPlant 1
BusinessProcess BusinessProcess 1
CapacityCategoryCode CapacityCategoryCode 1
ChangeNumber ChangeNumber 1
CostCtrActivityType1 CostCtrActivityType1 1
CostCtrActivityType2 CostCtrActivityType2 1
CostCtrActivityType3 CostCtrActivityType3 1
CostCtrActivityType4 CostCtrActivityType4 1
CostCtrActivityType5 CostCtrActivityType5 1
CostCtrActivityType6 CostCtrActivityType6 1
CostElement CostElement 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
EmployeeWageGroup EmployeeWageGroup 1
EmployeeWageType EmployeeWageType 1
InspectionLotType InspectionLotType 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
LongTextLanguageCode LongTextLanguageCode 1
MaterialGroup MaterialGroup 1
NumberOfConfirmationSlips NumberOfConfirmationSlips 1
NumberOfEmployees NumberOfEmployees 1
NumberOfOperationPriceUnits NumberOfOperationPriceUnits 1
NumberOfTimeTickets NumberOfTimeTickets 1
Operation Operation 1
OperationControlProfile OperationControlProfile 1
OperationCostingRelevancyType OperationCostingRelevancyType 1
OperationReferenceQuantity OperationReferenceQuantity 1
OperationScrapPercent OperationScrapPercent 1
OperationSetupGroup OperationSetupGroup 1
OperationSetupGroupCategory OperationSetupGroupCategory 1
OperationSetupType OperationSetupType 1
OperationStandardTextCode OperationStandardTextCode 1
OperationText OperationText 1
OperationUnit OperationUnit 1
OpExternalProcessingCurrency OpExternalProcessingCurrency 1
OpExternalProcessingPrice OpExternalProcessingPrice 1
OpQtyToBaseQtyDnmntr OpQtyToBaseQtyDnmntr 1
OpQtyToBaseQtyNmrtr OpQtyToBaseQtyNmrtr 1
PlannedDeliveryDuration PlannedDeliveryDuration 1
Plant Plant 1
PurchaseContract PurchaseContract 1
PurchaseContractItem PurchaseContractItem 1
PurchasingGroup PurchasingGroup 1
PurchasingInfoRecdAddlGrpgName PurchasingInfoRecdAddlGrpgName 1
PurchasingInfoRecord PurchasingInfoRecord 1
PurchasingOrganization PurchasingOrganization 1
StandardWorkQuantity1 StandardWorkQuantity1 1
StandardWorkQuantity2 StandardWorkQuantity2 1
StandardWorkQuantity3 StandardWorkQuantity3 1
StandardWorkQuantity4 StandardWorkQuantity4 1
StandardWorkQuantity5 StandardWorkQuantity5 1
StandardWorkQuantity6 StandardWorkQuantity6 1
StandardWorkQuantityUnit1 StandardWorkQuantityUnit1 1
StandardWorkQuantityUnit2 StandardWorkQuantityUnit2 1
StandardWorkQuantityUnit3 StandardWorkQuantityUnit3 1
StandardWorkQuantityUnit4 StandardWorkQuantityUnit4 1
StandardWorkQuantityUnit5 StandardWorkQuantityUnit5 1
StandardWorkQuantityUnit6 StandardWorkQuantityUnit6 1
SuperiorOperationInternalID SuperiorOperationInternalID 1
Supplier Supplier 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 1
WorkCenterInternalID WorkCenterInternalID 1
WorkCenterTypeCode WorkCenterTypeCode 1

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.

-- Prodn Routing - SubOperation Details
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODUCTIONROUTINGSUBOP (
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSSEQUENCE,
    BILLOFOPERATIONSVARIANT,
    BOOOPERATIONINTERNALID,
    BOOOPINTERNALVERSIONCOUNTER,
    _SUPPLIER,
    _SUPPLIERCOMPANYBYPLANT,
    BUSINESSPROCESS,
    CAPACITYCATEGORYCODE,
    CHANGENUMBER,
    COSTCTRACTIVITYTYPE1,
    COSTCTRACTIVITYTYPE2,
    COSTCTRACTIVITYTYPE3,
    COSTCTRACTIVITYTYPE4,
    COSTCTRACTIVITYTYPE5,
    COSTCTRACTIVITYTYPE6,
    COSTELEMENT,
    CREATEDBYUSER,
    CREATIONDATE,
    EMPLOYEEWAGEGROUP,
    EMPLOYEEWAGETYPE,
    INSPECTIONLOTTYPE,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LONGTEXTLANGUAGECODE,
    MATERIALGROUP,
    NUMBEROFCONFIRMATIONSLIPS,
    NUMBEROFEMPLOYEES,
    NUMBEROFOPERATIONPRICEUNITS,
    NUMBEROFTIMETICKETS,
    OPERATION,
    OPERATIONCONTROLPROFILE,
    OPERATIONCOSTINGRELEVANCYTYPE,
    OPERATIONREFERENCEQUANTITY,
    OPERATIONSCRAPPERCENT,
    OPERATIONSETUPGROUP,
    OPERATIONSETUPGROUPCATEGORY,
    OPERATIONSETUPTYPE,
    OPERATIONSTANDARDTEXTCODE,
    OPERATIONTEXT,
    OPERATIONUNIT,
    OPEXTERNALPROCESSINGCURRENCY,
    OPEXTERNALPROCESSINGPRICE,
    OPQTYTOBASEQTYDNMNTR,
    OPQTYTOBASEQTYNMRTR,
    PLANNEDDELIVERYDURATION,
    PLANT,
    PURCHASECONTRACT,
    PURCHASECONTRACTITEM,
    PURCHASINGGROUP,
    PURCHASINGINFORECDADDLGRPGNAME,
    PURCHASINGINFORECORD,
    PURCHASINGORGANIZATION,
    STANDARDWORKQUANTITY1,
    STANDARDWORKQUANTITY2,
    STANDARDWORKQUANTITY3,
    STANDARDWORKQUANTITY4,
    STANDARDWORKQUANTITY5,
    STANDARDWORKQUANTITY6,
    STANDARDWORKQUANTITYUNIT1,
    STANDARDWORKQUANTITYUNIT2,
    STANDARDWORKQUANTITYUNIT3,
    STANDARDWORKQUANTITYUNIT4,
    STANDARDWORKQUANTITYUNIT5,
    STANDARDWORKQUANTITYUNIT6,
    SUPERIOROPERATIONINTERNALID,
    SUPPLIER,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (BILLOFOPERATIONSGROUP, BILLOFOPERATIONSSEQUENCE, BILLOFOPERATIONSVARIANT, BOOOPERATIONINTERNALID, BOOOPINTERNALVERSIONCOUNTER)
);

Learn More