I_ACMApplDocAnalysis

DDL: I_ACMAPPLDOCANALYSIS Type: view_entity COMPOSITE
22 Fields 2 Data Sources 1 Associations

Interface for Q Repository Grades

I_ACMApplDocAnalysis is a Composite CDS View that provides data about "Interface for Q Repository Grades" in SAP S/4HANA. It reads from 2 data sources (I_ACMRepositoryGrade, I_ACMRepAppMainDet) and exposes 22 fields with key fields ApplicationDocument, ApplicationDocumentItem, ACMDocumentSide, ApplicationDocumentSubItem, QuantityRepositoryUUID. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_ACMRepositoryGrade GradeData inner
I_ACMRepAppMainDet Main inner

Associations (1)

CardinalityTargetAliasCondition
[0..*] P_ACMApplDocDPQSVolApplied Version Version.ACMLoadDataRepositoryUUID = Main.ACMRepositoryWeightAppUUID and Version.ACMLoadDataRepositoryVersion = Main.QuantityRepositoryVersion

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Interface for Q Repository Grades view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY ApplicationDocument Item ApplicationDocument
KEY ApplicationDocumentItem Item ApplicationDocumentItem
KEY ACMDocumentSide Item ACMDocumentSide
KEY ApplicationDocumentSubItem Item ApplicationDocumentSubItem
KEY QuantityRepositoryUUID I_ACMRepositoryGrade QuantityRepositoryUUID QRep GUID
KEY QuantityRepositoryVersion I_ACMRepositoryGrade QuantityRepositoryVersion QRep Version
KEY Characteristic I_ACMRepositoryGrade Characteristic Field Name
ReturnApplicationDocType Item ReturnApplicationDocType
LoadDataCaptureObjectID Item LoadDataCaptureObjectID
LoadDataObjectUUID Item LoadDataObjectUUID
AppDocQualityAttributeUnit I_ACMRepositoryGrade AppDocQualityAttributeUnit Base unit
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
ACMLoadDataRepositoryUUID Version ACMLoadDataRepositoryUUID
ACMLoadDataRepositoryVersion Version ACMLoadDataRepositoryVersion
CharcDecimals I_ACMRepositoryGrade CharcDecimals Decimal Places
_AppDocItem _AppDocItem

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_ACMApplDocAnalysis.
-- 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_ACMApplDocAnalysis AS
SELECT
  Item.ApplicationDocument AS ApplicationDocument,
  Item.ApplicationDocumentItem AS ApplicationDocumentItem,
  Item.ACMDocumentSide AS ACMDocumentSide,
  Item.ApplicationDocumentSubItem AS ApplicationDocumentSubItem,
  GradeData.QuantityRepositoryUUID AS QuantityRepositoryUUID,
  GradeData.QuantityRepositoryVersion AS QuantityRepositoryVersion,
  GradeData.Characteristic AS Characteristic,
  Item.ReturnApplicationDocType AS ReturnApplicationDocType,
  Item.LoadDataCaptureObjectID AS LoadDataCaptureObjectID,
  Item.LoadDataObjectUUID AS LoadDataObjectUUID,
  GradeData.AppDocQualityAttributeUnit AS AppDocQualityAttributeUnit,
  GradeData.DiscPremQtyGovAnalysisCode AS DiscPremQtyGovAnalysisCode,
  GradeData.DiscPremQtyOvrdGovAnalysisDesc AS DiscPremQtyOvrdGovAnalysisDesc,
  GradeData.GovAnalysisSourceLoc AS GovAnalysisSourceLoc,
  GradeData.GovAnalysisSourceLocText AS GovAnalysisSourceLocText,
  GradeData.ACMAnalysisType AS ACMAnalysisType,
  GradeData.ACMAnalysisTypeText AS ACMAnalysisTypeText,
  GradeData.CharcValueDescription AS CharcValueDescription,
  Version.ACMLoadDataRepositoryUUID AS ACMLoadDataRepositoryUUID,
  Version.ACMLoadDataRepositoryVersion AS ACMLoadDataRepositoryVersion,
  GradeData.CharcDecimals AS CharcDecimals
INNER JOIN I_ACMRepAppMainDet AS Main ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMRepositoryGrade AS GradeData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ACMApplDocDPQSVolApplied AS Version ON Version.ACMLoadDataRepositoryUUID = Main.ACMRepositoryWeightAppUUID AND Version.ACMLoadDataRepositoryVersion = Main.QuantityRepositoryVersion  -- association [0..*]
;

Learn More