P_EngBOMAssgdToChgRecd

DDL: P_ENGBOMASSGDTOCHGRECD SQL: PENGBOMASSTOCR Type: view COMPOSITE Package: MPE_PLAN_MEC
12 Fields 2 Data Sources 1 Associations

Engineering BOM Details Assigned To Change Record

P_EngBOMAssgdToChgRecd is a Composite CDS View that provides data about "Engineering BOM Details Assigned To Change Record" in SAP S/4HANA. It reads from 2 data sources (I_ChgRecdRefEBOM, I_MaterialBOM) and exposes 12 fields with key field ChangeRecordReferenceUUID. It has 1 association to related views. Part of development package MPE_PLAN_MEC.

Data Sources (2)

SourceAliasJoin Type
I_ChgRecdRefEBOM EngBOMAssigned from
I_MaterialBOM MaterialBOM inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_PlngScpAssgdToChgRecd _PlngScpAssgd $projection.ChangeRecordUUID = _PlngScpAssgd.ChangeRecordUUID

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PENGBOMASSTOCR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID I_ChgRecdRefEBOM ChangeRecordReferenceUUID UUID
ChangeRecord I_ChgRecdRefEBOM ChangeRecord Char20
ChangeRecordUUID I_ChgRecdRefEBOM ChangeRecordUUID NodeID
Material I_MaterialBOM Material Vehicle Model
Plant I_MaterialBOM Plant Valuation Area
BillOfMaterialHeaderUUID I_MaterialBOM BillOfMaterialHeaderUUID Guid
BillOfMaterialVariantUsage I_MaterialBOM BillOfMaterialVariantUsage Usage
BillOfMaterialCategory I_MaterialBOM BillOfMaterialCategory BOM category
BillOfMaterial I_MaterialBOM BillOfMaterial BOM
BillOfMaterialVariant I_MaterialBOM BillOfMaterialVariant AlternativeBOM
BillOfMaterialVersion I_MaterialBOM BillOfMaterialVersion BOM Version
_PlngScpAssgd _PlngScpAssgd

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_EngBOMAssgdToChgRecd.
-- 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: PENGBOMASSTOCR

CREATE VIEW P_EngBOMAssgdToChgRecd AS
SELECT
  EngBOMAssigned.ChangeRecordReferenceUUID AS ChangeRecordReferenceUUID,
  EngBOMAssigned.ChangeRecord AS ChangeRecord,
  EngBOMAssigned.ChangeRecordUUID AS ChangeRecordUUID,
  MaterialBOM.Material AS Material,
  MaterialBOM.Plant AS Plant,
  MaterialBOM.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  MaterialBOM.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  MaterialBOM.BillOfMaterialCategory AS BillOfMaterialCategory,
  MaterialBOM.BillOfMaterial AS BillOfMaterial,
  MaterialBOM.BillOfMaterialVariant AS BillOfMaterialVariant,
  MaterialBOM.BillOfMaterialVersion AS BillOfMaterialVersion
FROM I_ChgRecdRefEBOM AS EngBOMAssigned
INNER JOIN I_MaterialBOM AS MaterialBOM ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PlngScpAssgdToChgRecd AS _PlngScpAssgd ON ChangeRecordUUID = _PlngScpAssgd.ChangeRecordUUID  -- association [0..1]
;

Learn More