I_PRODUCTIONROUTINGVERSION

CDS View
46 Fields 11 CDS Views

Production Routing Version

I_PRODUCTIONROUTINGVERSION is a CDS View in S/4HANA. Production Routing Version. It contains 46 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_ChgImpactRoutingDets view from CONSUMPTION Routing Details
C_ChgImpctETOShopFloorRtgDets view from CONSUMPTION ETO Shop Floor Routing Details
C_ProdnRtgVersWrkflwInbox view from CONSUMPTION Production Routing Workflow MyInbox
C_ReworkBOOVersionDefectCode view from CONSUMPTION Rework Version BOO Defect Code Assgnmnt
I_ChgRecdRefOrdSpcfcRoutingTP view left_outer TRANSACTIONAL Change Record Ref Object Ord Spcfc Rtg
I_ChgRecdRefRoutingTP view left_outer TRANSACTIONAL Change Record Reference Object Routing TP
I_ChgRecdRefRoutingVersion view left_outer COMPOSITE Change Record Routing with max version
I_MfgOrderSpecificRouting view from COMPOSITE Manufacturing Order Specific Routing
I_ProdnRtgVersWrkflwInboxTP view from TRANSACTIONAL Production Routing Workflow MyInbox
I_ProdnRtgVersWrkflwTP view from TRANSACTIONAL Production Routing Workflow
N_ChangeRecordObjPgRouting view left_outer Change Record Object Page Routing

Fields (46)

KeyField CDS FieldsUsed in Views
KEY BillOfOperationsGroup BillOfOperationsGroup 6
KEY BillOfOperationsType BillOfOperationsType 7
KEY BillOfOperationsVariant BillOfOperationsVariant 7
KEY BillOfOperationsVersion BillOfOperationsVersion 6
_BillOfOperations _BillOfOperations 2
_BillOfOperationsGroup _BillOfOperationsGroup 2
_BillOfOperationsType _BillOfOperationsType 2
BillOfOperationsDesc BillOfOperationsDesc 4
BillOfOperationsRefGroup BillOfOperationsRefGroup 2
BillOfOperationsRefType BillOfOperationsRefType 2
BillOfOperationsRefVariant BillOfOperationsRefVariant 2
BillOfOperationsStatus BillOfOperationsStatus 3
BillOfOperationsSubtype BillOfOperationsSubtype 1
BillOfOperationsUnit BillOfOperationsUnit 3
BillOfOperationsUsage BillOfOperationsUsage 3
BillOfOperationsVersionStatus BillOfOperationsVersionStatus 4
BillOfOperationsVersionType BillOfOperationsVersionType 1
BOOInternalVersionCounter BOOInternalVersionCounter 1
BOOReferenceVersion BOOReferenceVersion 2
CreatedByUser CreatedByUser 3
CreationDateTime CreationDateTime 2
InspectionLotDynamicLevel InspectionLotDynamicLevel 3
InspectionPartialLot InspectionPartialLot 2
InspExternalNumberingOfValues InspExternalNumberingOfValues 2
InspLotDynamicRule InspLotDynamicRule 3
InspSubsetFieldCombination InspSubsetFieldCombination 2
IsDeleted IsDeleted 1
IsLatestBOOVersion IsLatestBOOVersion 2
IsMarkedForDeletion IsMarkedForDeletion 1
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 3
LastUsageDate LastUsageDate 3
MaintenanceStrategy MaintenanceStrategy 1
MaximumLotSizeQuantity MaximumLotSizeQuantity 3
MinimumLotSizeQuantity MinimumLotSizeQuantity 3
NumberOfBOOVersionSuccessors NumberOfBOOVersionSuccessors 2
NumberOfUsages NumberOfUsages 3
OrderID ManufacturingOrder,OrderID 4
Plant Plant,ProductionPlant 6
ReplacedBillOfOperations ReplacedBillOfOperations 1
ResponsiblePlannerGroup ResponsiblePlannerGroup 3
SmplDrawingProcedure SmplDrawingProcedure 3
SmplDrawingProcedureVersion SmplDrawingProcedureVersion 1
WorkCenter WorkCenter 3
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.

-- Production Routing Version
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODUCTIONROUTINGVERSION (
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSVARIANT,
    BILLOFOPERATIONSVERSION,
    _BILLOFOPERATIONS,
    _BILLOFOPERATIONSGROUP,
    _BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSDESC,
    BILLOFOPERATIONSREFGROUP,
    BILLOFOPERATIONSREFTYPE,
    BILLOFOPERATIONSREFVARIANT,
    BILLOFOPERATIONSSTATUS,
    BILLOFOPERATIONSSUBTYPE,
    BILLOFOPERATIONSUNIT,
    BILLOFOPERATIONSUSAGE,
    BILLOFOPERATIONSVERSIONSTATUS,
    BILLOFOPERATIONSVERSIONTYPE,
    BOOINTERNALVERSIONCOUNTER,
    BOOREFERENCEVERSION,
    CREATEDBYUSER,
    CREATIONDATETIME,
    INSPECTIONLOTDYNAMICLEVEL,
    INSPECTIONPARTIALLOT,
    INSPEXTERNALNUMBERINGOFVALUES,
    INSPLOTDYNAMICRULE,
    INSPSUBSETFIELDCOMBINATION,
    ISDELETED,
    ISLATESTBOOVERSION,
    ISMARKEDFORDELETION,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LASTUSAGEDATE,
    MAINTENANCESTRATEGY,
    MAXIMUMLOTSIZEQUANTITY,
    MINIMUMLOTSIZEQUANTITY,
    NUMBEROFBOOVERSIONSUCCESSORS,
    NUMBEROFUSAGES,
    ORDERID,
    PLANT,
    REPLACEDBILLOFOPERATIONS,
    RESPONSIBLEPLANNERGROUP,
    SMPLDRAWINGPROCEDURE,
    SMPLDRAWINGPROCEDUREVERSION,
    WORKCENTER,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    PRIMARY KEY (BILLOFOPERATIONSGROUP, BILLOFOPERATIONSTYPE, BILLOFOPERATIONSVARIANT, BILLOFOPERATIONSVERSION)
);

Learn More