P_MasterRecipeActyWithLongText

DDL: P_MASTERRECIPEACTYWITHLONGTEXT Type: view_entity COMPOSITE Package: VDM_PP_MD_MRC
62 Fields 1 Data Sources 1 Associations

Master Recipe Activities with Long Text

P_MasterRecipeActyWithLongText is a Composite CDS View that provides data about "Master Recipe Activities with Long Text" in SAP S/4HANA. It reads from 1 data source (P_MasterRecipeActivityChgState) and exposes 62 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BOOOperationInternalID, BOOOpInternalVersionCounter. It has 1 association to related views. Part of development package VDM_PP_MD_MRC.

Data Sources (1)

SourceAliasJoin Type
P_MasterRecipeActivityChgState P_MasterRecipeActivityChgState from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_TaskListOperationLongText _LongText $projection.BillOfOperationsType = _LongText.TaskListType and $projection.BillOfOperationsGroup = _LongText.TaskListGroup and $projection.BOOOperationInternalID = _LongText.BOOOperationInternalID and $projection.BOOOpInternalVersionCounter = _LongText.BOOInternalVersionCounter and $projection.LongTextLanguageCode is not null

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (62)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType BillOfOperationsType Task List Type
KEY BillOfOperationsGroup BillOfOperationsGroup Group
KEY BillOfOperationsVariant BillOfOperationsVariant Group Counter
KEY BOOOperationInternalID BOOOperationInternalID Task list node
KEY BOOOpInternalVersionCounter BOOOpInternalVersionCounter Counter
KEY BillOfOperationsIntID BillOfOperationsIntID Counter
Operation Operation Transaction
OperationText OperationText Description
LongTextLanguageCode LongTextLanguageCode Language
BOOOperationIsPhase BOOOperationIsPhase
BOOPhaseSuperiorOpInternalID BOOPhaseSuperiorOpInternalID
BOOOperationIsSecdryRsce BOOOperationIsSecdryRsce
SuperiorOperationInternalID SuperiorOperationInternalID Sup. Op. Node
BOOSuperiorOperationIsPhase BOOSuperiorOperationIsPhase
OperationControlProfile OperationControlProfile Control Key
WorkCenterInternalID WorkCenterInternalID Work Center
WorkCenter WorkCenter Work Center
Plant Plant Valuation Area
StandardWorkFormulaParamGroup StandardWorkFormulaParamGroup
OperationReferenceQuantity OperationReferenceQuantity Base Quantity
OperationUnit OperationUnit Act/op UoM
OpQtyToBaseQtyNmrtr OpQtyToBaseQtyNmrtr
OpQtyToBaseQtyDnmntr OpQtyToBaseQtyDnmntr
OperationSetupType OperationSetupType Setup Type Key
OperationSetupGroup OperationSetupGroup Setup group key
OperationSetupGroupCategory OperationSetupGroupCategory Setup group cat
OperationStandardTextCode OperationStandardTextCode Std Text Key
StandardWorkFormulaParam1 StandardWorkFormulaParam1
StandardWorkQuantity1 StandardWorkQuantity1 Standard Value
StandardWorkQuantityUnit1 StandardWorkQuantityUnit1 Std value unit
CostCtrActivityType1 CostCtrActivityType1 Activity Type
StandardWorkFormulaParam2 StandardWorkFormulaParam2
StandardWorkQuantity2 StandardWorkQuantity2 Standard Value
StandardWorkQuantityUnit2 StandardWorkQuantityUnit2 Std value unit
CostCtrActivityType2 CostCtrActivityType2 Activity Type
StandardWorkFormulaParam3 StandardWorkFormulaParam3
StandardWorkQuantity3 StandardWorkQuantity3 Standard Value
StandardWorkQuantityUnit3 StandardWorkQuantityUnit3 Std value unit
CostCtrActivityType3 CostCtrActivityType3 Activity Type
StandardWorkFormulaParam4 StandardWorkFormulaParam4
StandardWorkQuantity4 StandardWorkQuantity4 Standard Value
StandardWorkQuantityUnit4 StandardWorkQuantityUnit4 Std value unit
CostCtrActivityType4 CostCtrActivityType4 Activity Type
StandardWorkFormulaParam5 StandardWorkFormulaParam5
StandardWorkQuantity5 StandardWorkQuantity5 Standard Value
StandardWorkQuantityUnit5 StandardWorkQuantityUnit5 Std value unit
CostCtrActivityType5 CostCtrActivityType5 Activity Type
StandardWorkFormulaParam6 StandardWorkFormulaParam6
StandardWorkQuantity6 StandardWorkQuantity6 Standard Value
StandardWorkQuantityUnit6 StandardWorkQuantityUnit6 Std value unit
CostCtrActivityType6 CostCtrActivityType6 Activity Type
FactoryCalendar FactoryCalendar Factory Calendar
StartDateOffsetDuration StartDateOffsetDuration
StartDateOffsetDurationUnit StartDateOffsetDurationUnit
EndDateOffsetDuration EndDateOffsetDuration
EndDateOffsetDurationUnit EndDateOffsetDurationUnit
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
ChangeNumber ChangeNumber Change Number
IsDeleted IsDeleted TRUE
IsImplicitlyDeleted IsImplicitlyDeleted
PlainLongText _LongText 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 P_MasterRecipeActyWithLongText.
-- 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 P_MasterRecipeActyWithLongText AS
SELECT
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BOOOperationInternalID,
  BOOOpInternalVersionCounter,
  BillOfOperationsIntID,
  Operation,
  OperationText,
  LongTextLanguageCode,
  BOOOperationIsPhase,
  BOOPhaseSuperiorOpInternalID,
  BOOOperationIsSecdryRsce,
  SuperiorOperationInternalID,
  BOOSuperiorOperationIsPhase,
  OperationControlProfile,
  WorkCenterInternalID,
  WorkCenter,
  Plant,
  StandardWorkFormulaParamGroup,
  OperationReferenceQuantity,
  OperationUnit,
  OpQtyToBaseQtyNmrtr,
  OpQtyToBaseQtyDnmntr,
  OperationSetupType,
  OperationSetupGroup,
  OperationSetupGroupCategory,
  OperationStandardTextCode,
  StandardWorkFormulaParam1,
  StandardWorkQuantity1,
  StandardWorkQuantityUnit1,
  CostCtrActivityType1,
  StandardWorkFormulaParam2,
  StandardWorkQuantity2,
  StandardWorkQuantityUnit2,
  CostCtrActivityType2,
  StandardWorkFormulaParam3,
  StandardWorkQuantity3,
  StandardWorkQuantityUnit3,
  CostCtrActivityType3,
  StandardWorkFormulaParam4,
  StandardWorkQuantity4,
  StandardWorkQuantityUnit4,
  CostCtrActivityType4,
  StandardWorkFormulaParam5,
  StandardWorkQuantity5,
  StandardWorkQuantityUnit5,
  CostCtrActivityType5,
  StandardWorkFormulaParam6,
  StandardWorkQuantity6,
  StandardWorkQuantityUnit6,
  CostCtrActivityType6,
  FactoryCalendar,
  StartDateOffsetDuration,
  StartDateOffsetDurationUnit,
  EndDateOffsetDuration,
  EndDateOffsetDurationUnit,
  ValidityStartDate,
  ValidityEndDate,
  ChangeNumber,
  IsDeleted,
  IsImplicitlyDeleted,
  _LongText.PlainLongText AS PlainLongText
FROM P_MasterRecipeActivityChgState
LEFT OUTER JOIN I_TaskListOperationLongText AS _LongText ON BillOfOperationsType = _LongText.TaskListType AND BillOfOperationsGroup = _LongText.TaskListGroup AND BOOOperationInternalID = _LongText.BOOOperationInternalID AND BOOOpInternalVersionCounter = _LongText.BOOInternalVersionCounter AND LongTextLanguageCode is not null  -- association [0..1]
;

Learn More