C_ChgRecdRefVarBOMTP

DDL: C_CHGRECDREFVARBOMTP Type: view_entity CONSUMPTION Package: VDM_PLMB_CR_O
36 Fields 1 Data Sources 3 Associations

Variant Bill of material Projection

C_ChgRecdRefVarBOMTP is a Consumption CDS View that provides data about "Variant Bill of material Projection" in SAP S/4HANA. It reads from 1 data source (R_ChgRecdRefVarBOMTP) and exposes 36 fields with key field ChangeRecordReferenceUUID. It has 3 associations to related views. Part of development package VDM_PLMB_CR_O.

Data Sources (1)

SourceAliasJoin Type
R_ChgRecdRefVarBOMTP R_ChgRecdRefVarBOMTP projection

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Material _Material $projection.Material = _Material.Material
[1..1] C_ChangeRecordItemRelBOMVH _ChangeRecordItemRelBOMVH $projection.ChangeRecordItemRelevance = _ChangeRecordItemRelBOMVH.ChangeRecordItemRelevance and $projection.ChangeRecordType = _ChangeRecordItemRelBOMVH.ChangeRecordType
[1..1] C_ChgRecordItemProcgStatusVH _ProcessingStatusVH $projection.ChangeRecordItemProcgStatus = _ProcessingStatusVH.ChgRecdNextItemProcgStatus and $projection.ChgRecdCurrentItemProcgStatus = _ProcessingStatusVH.ChgRecdCurrentItemProcgStatus and $projection.ChangeRecordLifecycleStatus = _ProcessingStatusVH.ChangeRecordLifecycleStatus

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Variant Bill of material Projection view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID UUID
virtualProductImageURLproductimageurl
Material Material Vehicle Model
Plant Plant Valuation Area
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus Processing Status
ChgRecdCurrentItemProcgStatus ChgRecdCurrentItemProcgStatus
ChangeRecordLifecycleStatus _ChangeRecord ChangeRecordLifecycleStatus Issue Lifecycle
ChangeRecordType _ChangeRecord ChangeRecordType Record Type
ChangeRecordUUID ChangeRecordUUID NodeID
ChangeRecordReferenceType ChangeRecordReferenceType Object Type
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype Subtype
ParentChangeRecordRefUUID ParentChangeRecordRefUUID Node ID
ChangeRecordItemRelevance ChangeRecordItemRelevance Relevance
ChangeNumber ChangeNumber Change Number
ChangeRecordReference ChangeRecordReference Ref. Object ID
BillOfMaterial BillOfMaterial BOM
ChangeRecordStatus _ChangeRecord ChangeRecordStatus
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
virtualCreationDateplmbcreated_on
LastChangedByUser LastChangedByUser User Name
BillOfMaterialCategory BillOfMaterialCategory BOM category
LastChangeDateTime LastChangeDateTime Timestamp
virtualLastChangeDateplmbchanged_on
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd Virtual Reference
ChgRecdItmTgtSts ChgRecdItmTgtSts Tgt Proc. Sts
ChgRecdReasonForChange ChgRecdReasonForChange Reason for Chge
ExpdCompltnDte ExpdCompltnDte Exp Completion Date
ChgRecdAuthznGrpText ChgRecdAuthznGrpText Authoriz. Group
ChgRecdNmbrChgSts ChgRecdNmbrChgSts Status
virtualChgRecdObjDgtlSgntrEnableboolean
_Material _Material
_Plant _Plant
_ChangeRecordProduct _ChangeRecordProduct

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 C_ChgRecdRefVarBOMTP.
-- 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 C_ChgRecdRefVarBOMTP AS
SELECT
  ChangeRecordReferenceUUID,
  virtual ProductImageURL : productimageurl AS virtualProductImageURLproductimageurl,
  Material,
  Plant,
  BillOfMaterialVariantUsage,
  BillOfMaterialVariant,
  ChangeRecordItemProcgStatus,
  ChgRecdCurrentItemProcgStatus,
  _ChangeRecord.ChangeRecordLifecycleStatus AS ChangeRecordLifecycleStatus,
  _ChangeRecord.ChangeRecordType AS ChangeRecordType,
  ChangeRecordUUID,
  ChangeRecordReferenceType,
  ChangeRecordReferenceSubtype,
  ParentChangeRecordRefUUID,
  ChangeRecordItemRelevance,
  ChangeNumber,
  ChangeRecordReference,
  BillOfMaterial,
  _ChangeRecord.ChangeRecordStatus AS ChangeRecordStatus,
  CreatedByUser,
  CreationDateTime,
  virtual CreationDate : /plmb/created_on AS virtualCreationDateplmbcreated_on,
  LastChangedByUser,
  BillOfMaterialCategory,
  LastChangeDateTime,
  virtual LastChangeDate : /plmb/changed_on AS virtualLastChangeDateplmbchanged_on,
  ChangeRecordVirtualRefInd,
  ChgRecdItmTgtSts,
  ChgRecdReasonForChange,
  ExpdCompltnDte,
  ChgRecdAuthznGrpText,
  ChgRecdNmbrChgSts,
  virtual ChgRecdObjDgtlSgntrEnable : boolean AS virtualChgRecdObjDgtlSgntrEnableboolean
FROM R_ChgRecdRefVarBOMTP
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN C_ChangeRecordItemRelBOMVH AS _ChangeRecordItemRelBOMVH ON ChangeRecordItemRelevance = _ChangeRecordItemRelBOMVH.ChangeRecordItemRelevance AND ChangeRecordType = _ChangeRecordItemRelBOMVH.ChangeRecordType  -- association [1..1]
LEFT OUTER JOIN C_ChgRecordItemProcgStatusVH AS _ProcessingStatusVH ON ChangeRecordItemProcgStatus = _ProcessingStatusVH.ChgRecdNextItemProcgStatus AND ChgRecdCurrentItemProcgStatus = _ProcessingStatusVH.ChgRecdCurrentItemProcgStatus AND ChangeRecordLifecycleStatus = _ProcessingStatusVH.ChangeRecordLifecycleStatus  -- association [1..1]
;

Learn More