I_AsstmtMdlMDGenerationError

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_AsstmtMdlMDGenerationError.
-- 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: IASSTMTMDLGENERR

CREATE VIEW I_AsstmtMdlMDGenerationError AS
SELECT
  rfm_asm_error.AssortmentModuleUser AS AssortmentModuleUser,
  rfm_asm_error.Product AS Product,
  rfm_asm_error.Product AS ProductOfSuprordLstgCondition,
  rfm_asm_error.SystemMessageClass AS SystemMessageClass,
  rfm_asm_error.SystemMessageNumber AS SystemMessageNumber,
  rfm_asm_error.SystemMessageVariable1 AS SystemMessageVariable1,
  rfm_asm_error.SystemMessageVariable2 AS SystemMessageVariable2,
  rfm_asm_error.SystemMessageVariable3 AS SystemMessageVariable3,
  rfm_asm_error.SystemMessageVariable4 AS SystemMessageVariable4,
  rfm_asm_error.LatestMasterDataGenerationDate AS LatestMasterDataGenerationDate,
  rfm_asm_error.Processor AS Processor,
  rfm_asm_error.LastChangeDateTime AS LastChangeDateTime,
  rfm_asm_error.MasterDataGenerationIsRunning AS MasterDataGenerationIsRunning
FROM I_AsstmtMdlMDGenerationError_1 AS rfm_asm_error
INNER JOIN I_Product ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_Product AS _ProductOfSuprordLstgCondition ON ProductOfSuprordLstgCondition = _ProductOfSuprordLstgCondition.Product  -- association [1..1]
LEFT OUTER JOIN I_Site AS _Site ON AssortmentModuleUser = _Site.SiteCustomer  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _Processor ON _Processor.ContactCardID = Processor  -- association [0..1]
;