I_ActyTypeProductionRouting

DDL: I_ACTYTYPEPRODUCTIONROUTING SQL: IACTYTYPEPRDRTG Type: view COMPOSITE
32 Fields 1 Data Sources 2 Associations

Production Routing

I_ActyTypeProductionRouting is a Composite CDS View that provides data about "Production Routing" in SAP S/4HANA. It reads from 1 data source (P_ActyTypeProdnRTGActyTypeList) and exposes 32 fields with key fields StandardWorkFormulaParameter, BillOfOperationsVariant, BillOfOperationsSequence, BOOSqncOpAssgmtIntVersionCntr, BillOfOperationsType. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_ActyTypeProdnRTGActyTypeList P_ActyTypeProdnRTGActyTypeList from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_CostCenterActivityType _CostCtrActivityType $projection.CostCtrActivityType = _CostCtrActivityType.CostCtrActivityType and not ( $projection.ValidityStartDate > _CostCtrActivityType.ValidityEndDate or $projection.ValidityEndDate < _CostCtrActivityType.ValidityStartDate )
[0..1] I_StandardWorkFormulaParameter _StandardWorkFormulaParameter $projection.StandardWorkFormulaParameter = _StandardWorkFormulaParameter.StandardWorkFormulaParameter

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IACTYTYPEPRDRTG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Production Routing view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MASTER view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY StandardWorkFormulaParameter StandardWorkFormulaParameter
KEY BillOfOperationsVariant BillOfOperationsVariant Group Counter
KEY BillOfOperationsSequence BillOfOperationsSequence Sequence
KEY BOOSqncOpAssgmtIntVersionCntr BOOSqncOpAssgmtIntVersionCntr
KEY BillOfOperationsType BillOfOperationsType Task List Type
KEY BillOfOperationsGroup BillOfOperationsGroup Group
KEY BOOOperationInternalID BOOOperationInternalID Task list node
KEY BOOOpInternalVersionCounter BOOOpInternalVersionCounter Counter
KEY ControllingArea _CostCtrActivityType ControllingArea Controlling Area
KEY CostCtrActivityType CostCtrActivityType Activity Type
KEY CostCtrActyTypeValdtyEndDate _CostCtrActivityType ValidityEndDate ValidTo
KEY CostCtrActyTypeValdtyStartDate _CostCtrActivityType ValidityStartDate Validity Start Date
StandardWorkFormulaParamName
BillOfOperationsDesc BillOfOperationsDesc
CostCtrActivityTypeName
WorkCenter _WorkCenter WorkCenter Work Center
CostCenter
CostCenterValidityStartDate
CostCenterValidityEndDate
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
Operation Operation Transaction
WorkCenterInternalID WorkCenterInternalID Work Center
WorkCenterTypeCode WorkCenterTypeCode Object Type
Plant Plant Valuation Area
PlantName PlantName Plant Name
WorkCenterStandardWorkQty WorkCenterStandardWorkQty Standard Value
WorkCenterStandardWorkQtyUnit WorkCenterStandardWorkQtyUnit Std value unit
OperationText OperationText Description
OperationControlProfile OperationControlProfile Control Key
OperationStandardTextCode OperationStandardTextCode Std Text Key
_WorkCenter _WorkCenter

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_ActyTypeProductionRouting.
-- 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.
-- SQL view name: IACTYTYPEPRDRTG

CREATE VIEW I_ActyTypeProductionRouting AS
SELECT
  StandardWorkFormulaParameter,
  BillOfOperationsVariant,
  BillOfOperationsSequence,
  BOOSqncOpAssgmtIntVersionCntr,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BOOOperationInternalID,
  BOOOpInternalVersionCounter,
  _CostCtrActivityType.ControllingArea AS ControllingArea,
  CostCtrActivityType,
  _CostCtrActivityType.ValidityEndDate AS CostCtrActyTypeValdtyEndDate,
  _CostCtrActivityType.ValidityStartDate AS CostCtrActyTypeValdtyStartDate,
  _StandardWorkFormulaParameter._Text[ Language = $session.system_language ].StandardWorkFormulaParamName AS StandardWorkFormulaParamName,
  BillOfOperationsDesc,
  cast(_CostCtrActivityType._Text[ Language = $session.system_language ].CostCtrActivityTypeName as actytypename preserving type ) AS CostCtrActivityTypeName,
  _WorkCenter.WorkCenter AS WorkCenter,
  _WorkCenter._WorkCenterCostCenter.CostCenter AS CostCenter,
  _WorkCenter._WorkCenterCostCenter.ValidityStartDate AS CostCenterValidityStartDate,
  _WorkCenter._WorkCenterCostCenter.ValidityEndDate AS CostCenterValidityEndDate,
  ValidityStartDate,
  ValidityEndDate,
  Operation,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  Plant,
  PlantName,
  WorkCenterStandardWorkQty,
  WorkCenterStandardWorkQtyUnit,
  OperationText,
  OperationControlProfile,
  OperationStandardTextCode
FROM P_ActyTypeProdnRTGActyTypeList
LEFT OUTER JOIN I_CostCenterActivityType AS _CostCtrActivityType ON CostCtrActivityType = _CostCtrActivityType.CostCtrActivityType AND not ( ValidityStartDate > _CostCtrActivityType.ValidityEndDate OR ValidityEndDate < _CostCtrActivityType.ValidityStartDate )  -- association [0..*]
LEFT OUTER JOIN I_StandardWorkFormulaParameter AS _StandardWorkFormulaParameter ON StandardWorkFormulaParameter = _StandardWorkFormulaParameter.StandardWorkFormulaParameter  -- association [0..1]
;

Learn More