A_ProductionRoutingOperation

DDL: A_PRODUCTIONROUTINGOPERATION Type: view_entity CONSUMPTION
86 Fields 1 Data Sources

Operation

A_ProductionRoutingOperation is a Consumption CDS View that provides data about "Operation" in SAP S/4HANA. It reads from 1 data source (I_ProdnRtgOperationTP) and exposes 86 fields with key fields ProductionRoutingGroup, ProductionRouting, ProductionRoutingSequence, ProductionRoutingOpIntID, ProductionRoutingOpIntVersion.

Data Sources (1)

SourceAliasJoin Type
I_ProdnRtgOperationTP I_ProdnRtgOperationTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Operation view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (86)

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 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
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
OperationCostingRelevancyType OperationCostingRelevancyType Operation Costing Relevancy Type
NumberOfTimeTickets NumberOfTimeTickets No.TimeTickets
NumberOfConfirmationSlips NumberOfConfirmationSlips No. of Conf. Slips
EmployeeWageGroup EmployeeWageGroup Wage Group
EmployeeWageType EmployeeWageType Wage type
NumberOfEmployees NumberOfEmployees No. employees
OperationSetupType OperationSetupType Setup Type Key
OperationSetupGroupCategory OperationSetupGroupCategory Setup group cat
OperationSetupGroup OperationSetupGroup Setup group key
OperationReferenceQuantity OperationReferenceQuantity Base Quantity
OperationUnit OperationUnit Act/op UoM
OpQtyToBaseQtyNmrtr OpQtyToBaseQtyNmrtr
OpQtyToBaseQtyDnmntr OpQtyToBaseQtyDnmntr
StandardWorkQuantity1 StandardWorkQuantity1 Standard Value
StandardWorkQuantityUnit1 StandardWorkQuantityUnit1 Std value unit
CostCtrActivityType1 CostCtrActivityType1 Activity Type
StandardWorkQuantity2 StandardWorkQuantity2 Standard Value
StandardWorkQuantityUnit2 StandardWorkQuantityUnit2 Std value unit
CostCtrActivityType2 CostCtrActivityType2 Activity Type
StandardWorkQuantity3 StandardWorkQuantity3 Standard Value
StandardWorkQuantityUnit3 StandardWorkQuantityUnit3 Std value unit
CostCtrActivityType3 CostCtrActivityType3 Activity Type
StandardWorkQuantity4 StandardWorkQuantity4 Standard Value
StandardWorkQuantityUnit4 StandardWorkQuantityUnit4 Std value unit
CostCtrActivityType4 CostCtrActivityType4 Activity Type
StandardWorkQuantity5 StandardWorkQuantity5 Standard Value
StandardWorkQuantityUnit5 StandardWorkQuantityUnit5 Std value unit
CostCtrActivityType5 CostCtrActivityType5 Activity Type
StandardWorkQuantity6 StandardWorkQuantity6 Standard Value
StandardWorkQuantityUnit6 StandardWorkQuantityUnit6 Std value unit
CostCtrActivityType6 CostCtrActivityType6 Activity Type
BusinessProcess BusinessProcess Business Process
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
OpIsExtlyProcdWithSubcontrg OpIsExtlyProcdWithSubcontrg
InspectionLotType InspectionLotType Inspection Type
PurchasingInfoRecord PurchasingInfoRecord Info Record
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchaseContract PurchaseContract Purchasing Doc.
PurchaseContractItem PurchaseContractItem Item
PurchasingInfoRecdAddlGrpgName PurchasingInfoRecdAddlGrpgName Sort Term
PlannedDeliveryDuration PlannedDeliveryDuration Pl. Deliv. Time
MaterialGroup MaterialGroup Product Group
PurchasingGroup PurchasingGroup Purchasing Group
Supplier Supplier Supplier
NumberOfOperationPriceUnits NumberOfOperationPriceUnits Price Unit
CostElement CostElement G/L Account
OpExternalProcessingPrice OpExternalProcessingPrice Price
OpExternalProcessingCurrency OpExternalProcessingCurrency Currency
OperationScrapPercent OperationScrapPercent Scrap
ChangedDateTime ChangedDateTime Time Stamp
PlainLongText PlainLongText Long Text
_Supplier _Supplier
_SupplierCompanyByPlant _SupplierCompanyByPlant
_Header _Header

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 A_ProductionRoutingOperation.
-- 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 A_ProductionRoutingOperation AS
SELECT
  ProductionRoutingGroup,
  ProductionRouting,
  ProductionRoutingSequence,
  ProductionRoutingOpIntID,
  ProductionRoutingOpIntVersion,
  Operation,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  ChangeNumber,
  ValidityStartDate,
  ValidityEndDate,
  OperationText,
  LongTextLanguageCode,
  Plant,
  OperationControlProfile,
  OperationStandardTextCode,
  WorkCenterTypeCode,
  WorkCenterInternalID,
  CapacityCategoryCode,
  OperationCostingRelevancyType,
  NumberOfTimeTickets,
  NumberOfConfirmationSlips,
  EmployeeWageGroup,
  EmployeeWageType,
  NumberOfEmployees,
  OperationSetupType,
  OperationSetupGroupCategory,
  OperationSetupGroup,
  OperationReferenceQuantity,
  OperationUnit,
  OpQtyToBaseQtyNmrtr,
  OpQtyToBaseQtyDnmntr,
  StandardWorkQuantity1,
  StandardWorkQuantityUnit1,
  CostCtrActivityType1,
  StandardWorkQuantity2,
  StandardWorkQuantityUnit2,
  CostCtrActivityType2,
  StandardWorkQuantity3,
  StandardWorkQuantityUnit3,
  CostCtrActivityType3,
  StandardWorkQuantity4,
  StandardWorkQuantityUnit4,
  CostCtrActivityType4,
  StandardWorkQuantity5,
  StandardWorkQuantityUnit5,
  CostCtrActivityType5,
  StandardWorkQuantity6,
  StandardWorkQuantityUnit6,
  CostCtrActivityType6,
  BusinessProcess,
  MaximumWaitDuration,
  MaximumWaitDurationUnit,
  MinimumWaitDuration,
  MinimumWaitDurationUnit,
  StandardQueueDuration,
  StandardQueueDurationUnit,
  MinimumQueueDuration,
  MinimumQueueDurationUnit,
  StandardMoveDuration,
  StandardMoveDurationUnit,
  MinimumMoveDuration,
  MinimumMoveDurationUnit,
  OpIsExtlyProcdWithSubcontrg,
  InspectionLotType,
  PurchasingInfoRecord,
  PurchasingOrganization,
  PurchaseContract,
  PurchaseContractItem,
  PurchasingInfoRecdAddlGrpgName,
  PlannedDeliveryDuration,
  MaterialGroup,
  PurchasingGroup,
  Supplier,
  NumberOfOperationPriceUnits,
  CostElement,
  OpExternalProcessingPrice,
  OpExternalProcessingCurrency,
  OperationScrapPercent,
  ChangedDateTime,
  PlainLongText
FROM I_ProdnRtgOperationTP
;

Learn More