I_BOMMfgRefStrucAssgmt

DDL: I_BOMMFGREFSTRUCASSGMT Type: view_entity BASIC
17 Fields 1 Data Sources

MRS BOM to MRS Assignment Root

I_BOMMfgRefStrucAssgmt is a Basic CDS View that provides data about "MRS BOM to MRS Assignment Root" in SAP S/4HANA. It reads from 1 data source (mpe_mrs_bom2refr) and exposes 17 fields with key field MfgRefStrucBOMRootAssgmtUUID.

Data Sources (1)

SourceAliasJoin Type
mpe_mrs_bom2refr mpe_mrs_bom2refr from

Annotations (7)

NameValueLevelField
EndUserText.label MRS BOM to MRS Assignment Root view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY MfgRefStrucBOMRootAssgmtUUID root_assignment_uuid Root Assignment UUID
Material bom_header_material Material
Plant werks Receiving Plant
BillOfMaterialCategory stlty Single-Character Flag
BillOfMaterialUsage stlan Usage
BillOfMaterial BOM
AlternativeBillOfMaterial stlal AlternativeBOM
BOMVersionStart bom_versn_start BOM Version
BOMVersionEnd bom_versn_end BOM Version
MfgRefStructureUsage ref_structure_usage Usage
MfgRefStrucHeaderObject header_ref_object Reference Object
SalesOrder vbeln SD Sched. Agmt
SalesOrderItem vbpos Item
CreatedByUser createdbyuser User Name
CreationDateTime creationdatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
LastChangeDateTime lastchangedatetime Timestamp

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_BOMMfgRefStrucAssgmt.
-- 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 I_BOMMfgRefStrucAssgmt AS
SELECT
  root_assignment_uuid AS MfgRefStrucBOMRootAssgmtUUID,
  bom_header_material AS Material,
  werks AS Plant,
  stlty AS BillOfMaterialCategory,
  stlan AS BillOfMaterialUsage,
  cast(stlnr as abap.char(8) ) AS BillOfMaterial,
  stlal AS AlternativeBillOfMaterial,
  bom_versn_start AS BOMVersionStart,
  bom_versn_end AS BOMVersionEnd,
  ref_structure_usage AS MfgRefStructureUsage,
  header_ref_object AS MfgRefStrucHeaderObject,
  vbeln AS SalesOrder,
  vbpos AS SalesOrderItem,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM mpe_mrs_bom2refr
;

Learn More