I_SURcp2BOMSourceRcpForKeyDate

DDL: I_SURCP2BOMSOURCERCPFORKEYDATE SQL: ISUR2BSRCRCPKD Type: view COMPOSITE Package: VDM_PLMB_GSS_R2B
20 Fields 2 Data Sources 1 Associations

Sync Unit Rcp2BOM Source Recipe Assignment

I_SURcp2BOMSourceRcpForKeyDate is a Composite CDS View that provides data about "Sync Unit Rcp2BOM Source Recipe Assignment" in SAP S/4HANA. It reads from 2 data sources (P_SURcp2BOMSourceRcpMaxVersNo, P_SuRcp2BOMRcpAssgmtScore) and exposes 20 fields with key field SyncUnitRecipeAssignmentUUID. It has 1 association to related views. Part of development package VDM_PLMB_GSS_R2B.

Data Sources (2)

SourceAliasJoin Type
P_SURcp2BOMSourceRcpMaxVersNo P_SURcp2BOMSourceRcpMaxVersNo inner
P_SuRcp2BOMRcpAssgmtScore RcpAssgmtScore from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_RecipeForKeyDate _RecipeForKeyDate $projection.RecipeUUID = _RecipeForKeyDate.RecipeUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISUR2BSRCRCPKD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Sync Unit Rcp2BOM Source Recipe Assignment view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY SyncUnitRecipeAssignmentUUID SyncUnitRecipeAssignmentUUID
SyncUnitUUID P_SuRcp2BOMRcpAssgmtScore SyncUnitUUID
RecipeUUID RecipeUUID Recipe GUID
TargetChangeNumber TargetChangeNumber
SyncUnitRecipeAssignmentStatus SyncUnitRecipeAssignmentStatus
SyncVersionIsCurrent SyncVersionIsCurrent
SyncUnitAssgmtCrtnUTCDateTime SyncUnitAssgmtCrtnUTCDateTime
SyncUnitAssgmtCreatedByUser SyncUnitAssgmtCreatedByUser
SyncUnitAssgmtChgUTCDateTime SyncUnitAssgmtChgUTCDateTime
SyncUnitAssgmtChangedByUser SyncUnitAssgmtChangedByUser
RecipeType
RecipePurpose
RecipeStatus
RecipeAuthorizationGroup
_RecipeForKeyDate _RecipeForKeyDate
_TargetChangeNumber _TargetChangeNumber
_SyncUnitRcpAssgmtStatus _SyncUnitRcpAssgmtStatus
_SyncUnitRcp2BOM _SyncUnitRcp2BOM
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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_SURcp2BOMSourceRcpForKeyDate.
-- 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: ISUR2BSRCRCPKD
-- Parameters: P_KeyDate : sydate

CREATE VIEW I_SURcp2BOMSourceRcpForKeyDate AS
SELECT
  SyncUnitRecipeAssignmentUUID,
  RcpAssgmtScore.SyncUnitUUID AS SyncUnitUUID,
  RecipeUUID,
  TargetChangeNumber,
  SyncUnitRecipeAssignmentStatus,
  SyncVersionIsCurrent,
  SyncUnitAssgmtCrtnUTCDateTime,
  SyncUnitAssgmtCreatedByUser,
  SyncUnitAssgmtChgUTCDateTime,
  SyncUnitAssgmtChangedByUser,
  _RecipeForKeyDate( P_KeyDate : $parameters.P_KeyDate ).RecipeType AS RecipeType,
  _RecipeForKeyDate( P_KeyDate : $parameters.P_KeyDate ).RecipePurpose AS RecipePurpose,
  _RecipeForKeyDate( P_KeyDate : $parameters.P_KeyDate ).RecipeStatus AS RecipeStatus,
  _RecipeForKeyDate( P_KeyDate : $parameters.P_KeyDate ).RecipeAuthorizationGroup AS RecipeAuthorizationGroup
FROM P_SuRcp2BOMRcpAssgmtScore AS RcpAssgmtScore
INNER JOIN P_SURcp2BOMSourceRcpMaxVersNo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RecipeForKeyDate AS _RecipeForKeyDate ON RecipeUUID = _RecipeForKeyDate.RecipeUUID  -- association [1..1]
;

Learn More