I_EndItmMjrAssyProjSystRelshp

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_EndItmMjrAssyProjSystRelshp.
-- 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: IENDITMMAPSREL

CREATE VIEW I_EndItmMjrAssyProjSystRelshp AS
SELECT
  sfi_id AS ShopFloorItem,
  matnr AS Material,
  werks AS Plant,
  stlnr AS BillOfMaterial,
  stlal AS BillOfMaterialVariant,
  stlan AS BillOfMaterialVariantUsage,
  bom_versn AS BillOfMaterialVersion,
  crtn_time AS CreationDateTime,
  techs AS ParameterEffectivityValue,
  aufnr AS ManufacturingOrder,
  parent_ma AS ParentMajorAssembly,
  version_selection AS VersionSelection,
  project_id AS Project,
  parent_sfi_id AS ParentShopFloorItem,
  explosion_date AS BOMExplosionDate,
  parent_matnr AS ParentMaterial,
  cast( parent_stlnr as cs_stlnr preserving type ) AS ParentBillOfMaterial,
  parent_stlal AS ParentBillOfMaterialVariant,
  parent_stlan AS ParentBillOfMaterialUsage,
  parent_bom_versn AS ParentBillOfMaterialVersion,
  parent_stlkn AS ParentBOMItemNodeNumber,
  parent_stvkn AS ParentBOMItmInhtdNodeNmbr,
  parent_aufpl AS ParentRtgOrderOperationNumber,
  parent_aplzl AS ParentOrderOperationInternalID,
  parent_stpoz AS ParentBOMItemInternalCounter,
  ismanetwork AS MajorAssemblyIsNetwork,
  projassign AS MjrAssyProjectIsAssigned,
  cast( wbselement as ps_posid_edit preserving type ) AS WBSElement,
  isnonwreq AS MjrAssyNoNetworkIsRequired,
  bgprocstatus AS MjrAssyBckgndProcgStatus
FROM mpe_bom_ps_rel
;