I_ACMRepositoryGradeData

DDL: I_ACMREPOSITORYGRADEDATA Type: view_entity COMPOSITE

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.

2 data source(s) 15 fields

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
KEY QuantityRepositoryVersion I_ACMRepositoryGrade QuantityRepositoryVersion
KEY Characteristic I_ACMRepositoryGrade Characteristic
QtyRepositoryAttributeValue I_ACMRepositoryGrade QtyRepositoryAttributeValue
AppDocQualityAttributeUnit I_ACMRepositoryGrade AppDocQualityAttributeUnit
NonNumericAttrib1Value I_ACMRepositoryGrade NonNumericAttrib1Value
DiscPremQtyGovAnalysisCode I_ACMRepositoryGrade DiscPremQtyGovAnalysisCode
DiscPremQtyOvrdGovAnalysisDesc I_ACMRepositoryGrade DiscPremQtyOvrdGovAnalysisDesc
GovAnalysisSourceLoc I_ACMRepositoryGrade GovAnalysisSourceLoc
GovAnalysisSourceLocText I_ACMRepositoryGrade GovAnalysisSourceLocText
ACMAnalysisType I_ACMRepositoryGrade ACMAnalysisType
ACMAnalysisTypeText I_ACMRepositoryGrade ACMAnalysisTypeText
CharcValueDescription I_ACMRepositoryGrade CharcValueDescription
LDCEventKey I_ACMRepositoryGrade LDCEventKey
LDCKey LDC LDCKey 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Interface for Q Repository Grade Data'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}
define view entity I_ACMRepositoryGradeData
  as select distinct from I_LoadDataCaptureEvent as LDC
    inner join            P_ACMRepAppMain        as Main  on Main.ACMLoadDataCaptureEventKeyUUID = LDC.LDCEventKey
  //inner join            I_ACMRepositoryLatestVersion as Latest on Latest.QuantityRepositoryUUID = Main.ACMRepositoryWeightAppUUID

    inner join            I_ACMRepositoryGrade   as Grade on  Grade.QuantityRepositoryUUID    = Main.ACMRepositoryWeightAppUUID
                                                          and Grade.QuantityRepositoryVersion = Main.QuantityRepositoryVersion

{
  key   Grade.QuantityRepositoryUUID         as QuantityRepositoryUUID,
  key   Grade.QuantityRepositoryVersion      as QuantityRepositoryVersion,
  key   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
}

Learn More