I_ACMRepositoryGradeData

DDL: I_ACMREPOSITORYGRADEDATA Type: view_entity COMPOSITE
15 Fields 2 Data Sources

Interface for Q Repository Grade Data

I_ACMRepositoryGradeData is a Composite CDS View that provides data about "Interface for Q Repository Grade Data" in SAP S/4HANA. It reads from 2 data sources (I_ACMRepositoryGrade, P_ACMRepAppMain) and exposes 15 fields with key fields QuantityRepositoryUUID, QuantityRepositoryVersion, Characteristic.

Data Sources (2)

SourceAliasJoin Type
I_ACMRepositoryGrade Grade inner
P_ACMRepAppMain Main inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Interface for Q Repository Grade Data view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY QuantityRepositoryUUID I_ACMRepositoryGrade QuantityRepositoryUUID QRep GUID
KEY QuantityRepositoryVersion I_ACMRepositoryGrade QuantityRepositoryVersion QRep Version
KEY Characteristic I_ACMRepositoryGrade Characteristic Field Name
QtyRepositoryAttributeValue I_ACMRepositoryGrade QtyRepositoryAttributeValue Rnd.Attr. Value
AppDocQualityAttributeUnit I_ACMRepositoryGrade AppDocQualityAttributeUnit Base unit
NonNumericAttrib1Value I_ACMRepositoryGrade NonNumericAttrib1Value Grade Value
DiscPremQtyGovAnalysisCode I_ACMRepositoryGrade DiscPremQtyGovAnalysisCode Governing Analysis
DiscPremQtyOvrdGovAnalysisDesc I_ACMRepositoryGrade DiscPremQtyOvrdGovAnalysisDesc
GovAnalysisSourceLoc I_ACMRepositoryGrade GovAnalysisSourceLoc Origin/Destination
GovAnalysisSourceLocText I_ACMRepositoryGrade GovAnalysisSourceLocText Short Description
ACMAnalysisType I_ACMRepositoryGrade ACMAnalysisType Risk Type
ACMAnalysisTypeText I_ACMRepositoryGrade ACMAnalysisTypeText
CharcValueDescription I_ACMRepositoryGrade CharcValueDescription
LDCEventKey I_ACMRepositoryGrade LDCEventKey LDC Key
LDCKey LDC LDCKey

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_ACMRepositoryGradeData.
-- 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_ACMRepositoryGradeData AS
SELECT
  Grade.QuantityRepositoryUUID AS QuantityRepositoryUUID,
  Grade.QuantityRepositoryVersion AS QuantityRepositoryVersion,
  Grade.Characteristic AS Characteristic,
  Grade.QtyRepositoryAttributeValue AS QtyRepositoryAttributeValue,
  Grade.AppDocQualityAttributeUnit AS AppDocQualityAttributeUnit,
  Grade.NonNumericAttrib1Value AS NonNumericAttrib1Value,
  Grade.DiscPremQtyGovAnalysisCode AS DiscPremQtyGovAnalysisCode,
  Grade.DiscPremQtyOvrdGovAnalysisDesc AS DiscPremQtyOvrdGovAnalysisDesc,
  Grade.GovAnalysisSourceLoc AS GovAnalysisSourceLoc,
  Grade.GovAnalysisSourceLocText AS GovAnalysisSourceLocText,
  Grade.ACMAnalysisType AS ACMAnalysisType,
  Grade.ACMAnalysisTypeText AS ACMAnalysisTypeText,
  Grade.CharcValueDescription AS CharcValueDescription,
  Grade.LDCEventKey AS LDCEventKey,
  LDC.LDCKey AS LDCKey
INNER JOIN P_ACMRepAppMain AS Main ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMRepositoryGrade AS Grade ON /* join condition not captured in parsed metadata */
;

Learn More