R_ModelProductSpecification

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 R_ModelProductSpecification.
-- 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: RMODPRODSPEC

CREATE VIEW R_ModelProductSpecification AS
SELECT
  mmpur_mps_header.modelproductspecificationuuid AS ModelProductSpecificationUUID,
  mmpur_mps_header.modelproductspecification AS ModelProductSpecification,
  mmpur_mps_header.modelproductspecificationname AS ModelProductSpecificationName,
  mmpur_mps_header.modprodspecgroupingcode AS ModProdSpecGroupingCode,
  mmpur_mps_header.modprodspecsearchtermtext AS ModProdSpecSearchTermText,
  mmpur_mps_header.modprodspecactvtnstatuscode AS ModProdSpecActvtnStatusCode,
  mmpur_mps_header.isdeleted AS IsDeleted,
  mmpur_mps_header.language AS Language,
  mmpur_mps_header.creationdatetime AS CreationDateTime,
  mmpur_mps_header.createdbyuser AS CreatedByUser,
  mmpur_mps_header.lastchangedatetime AS LastChangeDateTime,
  mmpur_mps_header.lastchangedbyuser AS LastChangedByUser
FROM mmpur_mps_header
INNER JOIN P_ItemHierarchyBFStatus AS ItemHierarchyBFStatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_ModProdSpecItem AS _ModProdSpecItem ON ModelProductSpecificationUUID = _ModProdSpecItem.ModelProductSpecificationUUID  -- association [1..*]
LEFT OUTER JOIN I_ModProdSpecGroupingCode AS _ModProdSpecGroupingCode ON ModProdSpecGroupingCode = _ModProdSpecGroupingCode.ModProdSpecGroupingCode  -- association [0..1]
LEFT OUTER JOIN I_ModProdSpecGroupingCodeText AS _ModProdSpecGroupingCodeText ON ModProdSpecGroupingCode = _ModProdSpecGroupingCodeText.ModProdSpecGroupingCode  -- association [0..*]
LEFT OUTER JOIN I_ModProdSpecActvtnStatusText AS _ModProdSpecStatusText ON ModProdSpecActvtnStatusCode = _ModProdSpecStatusText.ModProdSpecActvtnStatusCode  -- association [0..*]
LEFT OUTER JOIN I_LanguageText AS _ModProdSpecLanguageText ON Language = _ModProdSpecLanguageText.LanguageCode  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangedByUser ON LastChangedByUser = _ChangedByUser.UserID  -- association [0..1]
;