I_ProdnRoutingOperationTP_2

DDL: I_PRODNROUTINGOPERATIONTP_2 Type: view_entity TRANSACTIONAL
121 Fields 1 Data Sources

Production Routing Operation - TP

I_ProdnRoutingOperationTP_2 is a Transactional CDS View that provides data about "Production Routing Operation - TP" in SAP S/4HANA. It reads from 1 data source (R_ProdnRoutingOperationTP_2) and exposes 121 fields with key fields ProductionRoutingGroup, ProductionRouting, ProductionRoutingSequence, ProductionRoutingOpIntID, ProductionRoutingOpIntVersion.

Data Sources (1)

SourceAliasJoin Type
R_ProdnRoutingOperationTP_2 R_ProdnRoutingOperationTP_2 projection

Annotations (11)

NameValueLevelField
EndUserText.label Production Routing Operation - TP view
ObjectModel.sapObjectNodeType.name ProductionRouting view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (121)

KeyFieldSource TableSource FieldDescription
KEY ProductionRoutingGroup ProductionRoutingGroup Group
KEY ProductionRouting ProductionRouting Group Counter
KEY ProductionRoutingSequence ProductionRoutingSequence Sequence
KEY ProductionRoutingOpIntID ProductionRoutingOpIntID Task list node
KEY ProductionRoutingOpIntVersion ProductionRoutingOpIntVersion Counter
Operation Transaction
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
ChangeNumber ChangeNumber Change Number
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
IsDeleted IsDeleted TRUE
IsImplicitlyDeleted IsImplicitlyDeleted
OperationText OperationText Description
LongTextLanguageCode LongTextLanguageCode Language
Plant Plant Valuation Area
OperationControlProfile OperationControlProfile Control Key
OperationStandardTextCode OperationStandardTextCode Std Text Key
WorkCenterTypeCode WorkCenterTypeCode Object Type
WorkCenterInternalID WorkCenterInternalID Work Center
CapacityCategoryCode CapacityCategoryCode
CostElement CostElement G/L Account
OperationCostingRelevancyType OperationCostingRelevancyType Operation Costing Relevancy Type
NumberOfTimeTickets NumberOfTimeTickets No.TimeTickets
NumberOfConfirmationSlips NumberOfConfirmationSlips No. of Conf. Slips
EmployeeWageGroup EmployeeWageGroup Wage Group
EmployeeWageType EmployeeWageType Wage type
EmployeeSuitability EmployeeSuitability
NumberOfEmployees NumberOfEmployees No. employees
BillOfOperationsRefType BillOfOperationsRefType
BillOfOperationsRefGroup BillOfOperationsRefGroup
BillOfOperationsRefVariant BillOfOperationsRefVariant
LineSegmentTakt LineSegmentTakt
OperationStdWorkQtyGrpgCat OperationStdWorkQtyGrpgCat
OrderHasNoSubOperations OrderHasNoSubOperations
OperationSetupType OperationSetupType Setup Type Key
OperationSetupGroupCategory OperationSetupGroupCategory Setup group cat
OperationSetupGroup OperationSetupGroup Setup group key
BOOOperationIsPhase BOOOperationIsPhase
BOOPhaseSuperiorOpInternalID BOOPhaseSuperiorOpInternalID
ControlRecipeDestination ControlRecipeDestination
OpIsExtlyProcdWithSubcontrg OpIsExtlyProcdWithSubcontrg
PurchasingInfoRecord PurchasingInfoRecord Info Record
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchaseContract PurchaseContract Purchasing Doc.
PurchaseContractItem PurchaseContractItem Item
PurchasingInfoRecdAddlGrpgName PurchasingInfoRecdAddlGrpgName Sort Term
MaterialGroup MaterialGroup Product Group
PurchasingGroup PurchasingGroup Purchasing Group
Supplier Supplier Supplier
PlannedDeliveryDuration PlannedDeliveryDuration Pl. Deliv. Time
NumberOfOperationPriceUnits NumberOfOperationPriceUnits Price Unit
OpExternalProcessingCurrency OpExternalProcessingCurrency Currency
OpExternalProcessingPrice OpExternalProcessingPrice Price
InspectionLotType InspectionLotType Inspection Type
InspResultRecordingView InspResultRecordingView
InspSbstCompletionConfirmation InspSbstCompletionConfirmation
InspSbstHasNoTimeOrQuantity InspSbstHasNoTimeOrQuantity Price determin.
OperationReferenceQuantity OperationReferenceQuantity Base Quantity
OperationUnit OperationUnit Act/op UoM
OperationScrapPercent OperationScrapPercent Scrap
OpQtyToBaseQtyNmrtr OpQtyToBaseQtyNmrtr
OpQtyToBaseQtyDnmntr OpQtyToBaseQtyDnmntr
StandardWorkQuantity1 StandardWorkQuantity1 Standard Value
StandardWorkQuantityUnit1 StandardWorkQuantityUnit1 Std value unit
CostCtrActivityType1 CostCtrActivityType1 Activity Type
PerfEfficiencyRatioCode1 PerfEfficiencyRatioCode1
StandardWorkQuantity2 StandardWorkQuantity2 Standard Value
StandardWorkQuantityUnit2 StandardWorkQuantityUnit2 Std value unit
CostCtrActivityType2 CostCtrActivityType2 Activity Type
PerfEfficiencyRatioCode2 PerfEfficiencyRatioCode2
StandardWorkQuantity3 StandardWorkQuantity3 Standard Value
StandardWorkQuantityUnit3 StandardWorkQuantityUnit3 Std value unit
CostCtrActivityType3 CostCtrActivityType3 Activity Type
PerfEfficiencyRatioCode3 PerfEfficiencyRatioCode3
StandardWorkQuantity4 StandardWorkQuantity4 Standard Value
StandardWorkQuantityUnit4 StandardWorkQuantityUnit4 Std value unit
CostCtrActivityType4 CostCtrActivityType4 Activity Type
PerfEfficiencyRatioCode4 PerfEfficiencyRatioCode4
StandardWorkQuantity5 StandardWorkQuantity5 Standard Value
StandardWorkQuantityUnit5 StandardWorkQuantityUnit5 Std value unit
CostCtrActivityType5 CostCtrActivityType5 Activity Type
PerfEfficiencyRatioCode5 PerfEfficiencyRatioCode5
StandardWorkQuantity6 StandardWorkQuantity6 Standard Value
StandardWorkQuantityUnit6 StandardWorkQuantityUnit6 Std value unit
CostCtrActivityType6 CostCtrActivityType6 Activity Type
PerfEfficiencyRatioCode6 PerfEfficiencyRatioCode6
BusinessProcess BusinessProcess Business Process
LeadTimeReductionStrategy LeadTimeReductionStrategy Red. Strategy
TeardownAndWaitIsParallel TeardownAndWaitIsParallel Teardown/Wait Par.
BillOfOperationsBreakDuration BillOfOperationsBreakDuration Break Time
BreakDurationUnit BreakDurationUnit
MaximumWaitDuration MaximumWaitDuration Max. Wait Time
MaximumWaitDurationUnit MaximumWaitDurationUnit Max. Wait Unit
MinimumWaitDuration MinimumWaitDuration Min. Wait Time
MinimumWaitDurationUnit MinimumWaitDurationUnit Req. Wait Unit
StandardQueueDuration StandardQueueDuration Std Queue Time
StandardQueueDurationUnit StandardQueueDurationUnit Std Queue Unit
MinimumQueueDuration MinimumQueueDuration Min. Queue Time
MinimumQueueDurationUnit MinimumQueueDurationUnit Min. Queue Unit
StandardMoveDuration StandardMoveDuration Std Move Time
StandardMoveDurationUnit StandardMoveDurationUnit StdMoveTime Un
MinimumMoveDuration MinimumMoveDuration Min. Move Time
MinimumMoveDurationUnit MinimumMoveDurationUnit MinMoveTime Un
OperationSplitIsRequired OperationSplitIsRequired Splitting Reqd
MaximumNumberOfSplits MaximumNumberOfSplits Maximum Splits
MinProcessingDurationPerSplit MinProcessingDurationPerSplit Min. Proc. Time
MinProcessingDurnPerSplitUnit MinProcessingDurnPerSplitUnit Min. Proc. Time
OperationOverlappingIsRequired OperationOverlappingIsRequired
OperationOverlappingIsPossible OperationOverlappingIsPossible
OperationsIsAlwaysOverlapping OperationsIsAlwaysOverlapping
OperationHasNoOverlapping OperationHasNoOverlapping
OverlapMinimumDuration OverlapMinimumDuration Minimum Overlap
OverlapMinimumDurationUnit OverlapMinimumDurationUnit Min.Overlap Tme
OverlapMinimumTransferQty OverlapMinimumTransferQty Min. Send-Ahead
OverlapMinimumTransferQtyUnit OverlapMinimumTransferQtyUnit Act/op UoM
FactoryCalendar FactoryCalendar Factory Calendar
ChangedDateTime ChangedDateTime Time Stamp
PlainLongText PlainLongText Long Text

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ProdnRoutingOperationTP_2.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_ProdnRoutingOperationTP_2 AS
SELECT
  ProductionRoutingGroup,
  ProductionRouting,
  ProductionRoutingSequence,
  ProductionRoutingOpIntID,
  ProductionRoutingOpIntVersion,
  cast(Operation as pph_vornr preserving type) AS Operation,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  ChangeNumber,
  ValidityStartDate,
  ValidityEndDate,
  IsDeleted,
  IsImplicitlyDeleted,
  OperationText,
  LongTextLanguageCode,
  Plant,
  OperationControlProfile,
  OperationStandardTextCode,
  WorkCenterTypeCode,
  WorkCenterInternalID,
  CapacityCategoryCode,
  CostElement,
  OperationCostingRelevancyType,
  NumberOfTimeTickets,
  NumberOfConfirmationSlips,
  EmployeeWageGroup,
  EmployeeWageType,
  EmployeeSuitability,
  NumberOfEmployees,
  BillOfOperationsRefType,
  BillOfOperationsRefGroup,
  BillOfOperationsRefVariant,
  LineSegmentTakt,
  OperationStdWorkQtyGrpgCat,
  OrderHasNoSubOperations,
  OperationSetupType,
  OperationSetupGroupCategory,
  OperationSetupGroup,
  BOOOperationIsPhase,
  BOOPhaseSuperiorOpInternalID,
  ControlRecipeDestination,
  OpIsExtlyProcdWithSubcontrg,
  PurchasingInfoRecord,
  PurchasingOrganization,
  PurchaseContract,
  PurchaseContractItem,
  PurchasingInfoRecdAddlGrpgName,
  MaterialGroup,
  PurchasingGroup,
  Supplier,
  PlannedDeliveryDuration,
  NumberOfOperationPriceUnits,
  OpExternalProcessingCurrency,
  OpExternalProcessingPrice,
  InspectionLotType,
  InspResultRecordingView,
  InspSbstCompletionConfirmation,
  InspSbstHasNoTimeOrQuantity,
  OperationReferenceQuantity,
  OperationUnit,
  OperationScrapPercent,
  OpQtyToBaseQtyNmrtr,
  OpQtyToBaseQtyDnmntr,
  StandardWorkQuantity1,
  StandardWorkQuantityUnit1,
  CostCtrActivityType1,
  PerfEfficiencyRatioCode1,
  StandardWorkQuantity2,
  StandardWorkQuantityUnit2,
  CostCtrActivityType2,
  PerfEfficiencyRatioCode2,
  StandardWorkQuantity3,
  StandardWorkQuantityUnit3,
  CostCtrActivityType3,
  PerfEfficiencyRatioCode3,
  StandardWorkQuantity4,
  StandardWorkQuantityUnit4,
  CostCtrActivityType4,
  PerfEfficiencyRatioCode4,
  StandardWorkQuantity5,
  StandardWorkQuantityUnit5,
  CostCtrActivityType5,
  PerfEfficiencyRatioCode5,
  StandardWorkQuantity6,
  StandardWorkQuantityUnit6,
  CostCtrActivityType6,
  PerfEfficiencyRatioCode6,
  BusinessProcess,
  LeadTimeReductionStrategy,
  TeardownAndWaitIsParallel,
  BillOfOperationsBreakDuration,
  BreakDurationUnit,
  MaximumWaitDuration,
  MaximumWaitDurationUnit,
  MinimumWaitDuration,
  MinimumWaitDurationUnit,
  StandardQueueDuration,
  StandardQueueDurationUnit,
  MinimumQueueDuration,
  MinimumQueueDurationUnit,
  StandardMoveDuration,
  StandardMoveDurationUnit,
  MinimumMoveDuration,
  MinimumMoveDurationUnit,
  OperationSplitIsRequired,
  MaximumNumberOfSplits,
  MinProcessingDurationPerSplit,
  MinProcessingDurnPerSplitUnit,
  OperationOverlappingIsRequired,
  OperationOverlappingIsPossible,
  OperationsIsAlwaysOverlapping,
  OperationHasNoOverlapping,
  OverlapMinimumDuration,
  OverlapMinimumDurationUnit,
  OverlapMinimumTransferQty,
  OverlapMinimumTransferQtyUnit,
  FactoryCalendar,
  ChangedDateTime,
  PlainLongText
FROM R_ProdnRoutingOperationTP_2
;

Learn More