I_ACMRepositoryGrade

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_ACMRepositoryGrade.
-- 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_ACMRepositoryGrade AS
SELECT
  Grade.qrep_guid AS QuantityRepositoryUUID,
  Grade.qrep_version AS QuantityRepositoryVersion,
  Description.CharacteristicDescription AS Characteristic,
  Description.CharacteristicValueDescription AS CharcValueDescription,
  Grade.attribute_value AS QtyRepositoryAttributeValue,
  Grade.attr_uom AS AppDocQualityAttributeUnit,
  Grade.attr_val AS NonNumericAttrib1Value,
  Grade.analysis_code AS DiscPremQtyGovAnalysisCode,
  Code.DiscPremQtyOvrdGovAnalysisDesc AS DiscPremQtyOvrdGovAnalysisDesc,
  Grade.source_grade AS GovAnalysisSourceLoc,
  Source.DomainText AS GovAnalysisSourceLocText,
  Grade.analysis_type AS ACMAnalysisType,
  Type.ACMAnalysisTypeText AS ACMAnalysisTypeText,
  Grade.uis_evnt_key AS LDCEventKey,
  Grade_char.CharcDecimals AS CharcDecimals
FROM /accgo/t_qr_ap_q AS Grade
INNER JOIN I_Relstartchar AS Description ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMCharcsData AS Grade_char ON /* join condition not captured in parsed metadata */
;