I_MasterRcpNonHistoricActyTP

DDL: I_MASTERRCPNONHISTORICACTYTP SQL: IMRCNHACTYTP Type: view_entity TRANSACTIONAL
14 Fields 1 Data Sources 9 Associations

Master Recipe Non Historical Activity

I_MasterRcpNonHistoricActyTP is a Transactional CDS View that provides data about "Master Recipe Non Historical Activity" in SAP S/4HANA. It reads from 1 data source (I_BOOSqncOperationAssgmtChgSt) and exposes 14 fields with key fields MasterRecipeGroup, MasterRecipe, MasterRecipeOperationIntID. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BOOSqncOperationAssgmtChgSt plas inner

Associations (9)

CardinalityTargetAliasCondition
[1..*] I_MasterRecipeHeaderTP _Header $projection.MasterRecipeGroup = _Header.MasterRecipeGroup and $projection.MasterRecipe = _Header.MasterRecipe -- to root node
[0..*] I_MasterRecipeOperationTP _Operation
[0..*] I_MasterRecipePhaseTP _Phase
[0..*] I_MasterRecipeOpCompAllocTP _OpCompAlloc
[0..*] I_MasterRecipeOpSecdryRsceTP _OpSecdryRsce
[0..*] I_MasterRecipePhseCompAllocTP _PhseCompAlloc
[0..*] I_MasterRecipePhseSecdryRsceTP _PhseSecdryRsce
[0..*] I_MasterRecipeRelationshipTP _PhseRelshp
[0..*] R_MasterRcpInspCharcsAssgmtTP _InspCharcsAssgmt

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Master Recipe Non Historical Activity view
ObjectModel.representativeKey MasterRecipeOperationIntID view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY MasterRecipeGroup plpo BillOfOperationsGroup Group
KEY MasterRecipe I_BOOSqncOperationAssgmtChgSt BillOfOperationsVariant Group Counter
KEY MasterRecipeOperationIntID plpo BOOOperationInternalID Task list node
ChangedDateTime _RcpTP ChangedDateTime Time Stamp
_RcpTP _RcpTP
_Operation _Operation
_Phase _Phase
_OpCompAlloc _OpCompAlloc
_OpSecdryRsce _OpSecdryRsce
_PhseCompAlloc _PhseCompAlloc
_PhseSecdryRsce _PhseSecdryRsce
_PhseRelshp _PhseRelshp
_InspCharcsAssgmt _InspCharcsAssgmt
_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 I_MasterRcpNonHistoricActyTP.
-- 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: IMRCNHACTYTP

CREATE VIEW I_MasterRcpNonHistoricActyTP AS
SELECT
  plpo.BillOfOperationsGroup AS MasterRecipeGroup,
  plas.BillOfOperationsVariant AS MasterRecipe,
  plpo.BOOOperationInternalID AS MasterRecipeOperationIntID,
  _RcpTP.ChangedDateTime AS ChangedDateTime
INNER JOIN I_BOOSqncOperationAssgmtChgSt AS plas ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MasterRecipeHeaderTP AS _Header ON MasterRecipeGroup = _Header.MasterRecipeGroup AND MasterRecipe = _Header.MasterRecipe  -- association [1..*]
LEFT OUTER JOIN I_MasterRecipeOperationTP AS _Operation ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_MasterRecipePhaseTP AS _Phase ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_MasterRecipeOpCompAllocTP AS _OpCompAlloc ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_MasterRecipeOpSecdryRsceTP AS _OpSecdryRsce ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_MasterRecipePhseCompAllocTP AS _PhseCompAlloc ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_MasterRecipePhseSecdryRsceTP AS _PhseSecdryRsce ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_MasterRecipeRelationshipTP AS _PhseRelshp ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_MasterRcpInspCharcsAssgmtTP AS _InspCharcsAssgmt ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More