A_ProductionRoutingSubOp

DDL: A_PRODUCTIONROUTINGSUBOP Type: view_entity CONSUMPTION
75 Fields 1 Data Sources 1 OData Services

Sub Operation

A_ProductionRoutingSubOp is a Consumption CDS View that provides data about "Sub Operation" in SAP S/4HANA. It reads from 1 data source (I_ProductionRoutingSubOpTP) and exposes 75 fields with key fields ProductionRoutingGroup, ProductionRouting, ProductionRoutingOpIntID, ProductionRoutingSequence, ProductionRoutingOpIntVersion. It is exposed through 1 OData service (API_PRODUCTIONROUTING).

Data Sources (1)

SourceAliasJoin Type
I_ProductionRoutingSubOpTP I_ProductionRoutingSubOpTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Sub 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

OData Services (1)

ServiceBindingVersionContractRelease
API_PRODUCTIONROUTING API_PRODUCTION_ROUTING V2 C2 C1

Fields (75)

KeyFieldSource TableSource FieldDescription
KEY ProductionRoutingGroup ProductionRoutingGroup Group
KEY ProductionRouting ProductionRouting Group Counter
KEY ProductionRoutingOpIntID ProductionRoutingOpIntID Task list node
KEY ProductionRoutingSequence ProductionRoutingSequence Sequence
KEY ProductionRoutingOpIntVersion ProdnRtgSubOpIntVersion Counter
SuperiorOperationInternalID SuperiorOperationInternalID Sup. Op. Node
Operation Transaction
OperationText OperationText Description
LongTextLanguageCode LongTextLanguageCode Language
WorkCenterTypeCode WorkCenterTypeCode Object Type
WorkCenterInternalID WorkCenterInternalID Work Center
Plant Plant Valuation Area
OperationControlProfile OperationControlProfile Control Key
OperationStandardTextCode OperationStandardTextCode Std Text 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
NumberOfTimeTickets NumberOfTimeTickets No.TimeTickets
EmployeeWageType EmployeeWageType Wage type
EmployeeWageGroup EmployeeWageGroup Wage Group
NumberOfConfirmationSlips NumberOfConfirmationSlips No. of Conf. Slips
NumberOfEmployees NumberOfEmployees No. employees
OperationCostingRelevancyType OperationCostingRelevancyType Operation Costing Relevancy Type
BusinessProcess BusinessProcess Business Process
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
ChangeNumber ChangeNumber Change Number
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
OperationSetupType OperationSetupType Setup Type Key
OperationSetupGroupCategory OperationSetupGroupCategory Setup group cat
OperationSetupGroup OperationSetupGroup Setup group key
CapacityCategoryCode CapacityCategoryCode
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_ProductionRoutingSubOp.
-- 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_ProductionRoutingSubOp AS
SELECT
  ProductionRoutingGroup,
  ProductionRouting,
  ProductionRoutingOpIntID,
  ProductionRoutingSequence,
  ProdnRtgSubOpIntVersion AS ProductionRoutingOpIntVersion,
  SuperiorOperationInternalID,
  cast(Operation as pph_vornr preserving type) AS Operation,
  OperationText,
  LongTextLanguageCode,
  WorkCenterTypeCode,
  WorkCenterInternalID,
  Plant,
  OperationControlProfile,
  OperationStandardTextCode,
  OperationReferenceQuantity,
  OperationUnit,
  OpQtyToBaseQtyNmrtr,
  OpQtyToBaseQtyDnmntr,
  StandardWorkQuantity1,
  StandardWorkQuantityUnit1,
  CostCtrActivityType1,
  StandardWorkQuantity2,
  StandardWorkQuantityUnit2,
  CostCtrActivityType2,
  StandardWorkQuantity3,
  StandardWorkQuantityUnit3,
  CostCtrActivityType3,
  StandardWorkQuantity4,
  StandardWorkQuantityUnit4,
  CostCtrActivityType4,
  StandardWorkQuantity5,
  StandardWorkQuantityUnit5,
  CostCtrActivityType5,
  StandardWorkQuantity6,
  StandardWorkQuantityUnit6,
  CostCtrActivityType6,
  NumberOfTimeTickets,
  EmployeeWageType,
  EmployeeWageGroup,
  NumberOfConfirmationSlips,
  NumberOfEmployees,
  OperationCostingRelevancyType,
  BusinessProcess,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  ValidityStartDate,
  ValidityEndDate,
  ChangeNumber,
  OpIsExtlyProcdWithSubcontrg,
  InspectionLotType,
  PurchasingInfoRecord,
  PurchasingOrganization,
  PurchaseContract,
  PurchaseContractItem,
  PurchasingInfoRecdAddlGrpgName,
  PlannedDeliveryDuration,
  MaterialGroup,
  PurchasingGroup,
  Supplier,
  NumberOfOperationPriceUnits,
  CostElement,
  OpExternalProcessingPrice,
  OpExternalProcessingCurrency,
  OperationSetupType,
  OperationSetupGroupCategory,
  OperationSetupGroup,
  CapacityCategoryCode,
  OperationScrapPercent,
  ChangedDateTime,
  PlainLongText
FROM I_ProductionRoutingSubOpTP
;

Learn More