I_ACMAppDocQuality

DDL: I_ACMAPPDOCQUALITY SQL: IAPPDOCQUALITY Type: view COMPOSITE

Q Repository Grades Application Doc

I_ACMAppDocQuality is a Composite CDS View that provides data about "Q Repository Grades Application Doc" in SAP S/4HANA. It reads from 3 data sources (I_ACMApplicationDocItem1, I_ACMFinalLoadDataEvent, I_ACMRepAppItemDet) and exposes 8 fields with key fields ApplicationDocument, ReferenceApplicationItem, ACMReferenceDocumentType, QuantityRepositoryVersion, MsrgPtInternalCharacteristic.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
I_ACMApplicationDocItem1 C from
I_ACMFinalLoadDataEvent L inner
I_ACMRepAppItemDet Q inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IAPPDOCQUALITY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Q Repository Grades Application Doc view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ApplicationDocument I_ACMApplicationDocItem1 ApplicationDocument
KEY ReferenceApplicationItem I_ACMApplicationDocItem1 ReferenceApplicationItem
KEY ACMReferenceDocumentType I_ACMFinalLoadDataEvent ACMReferenceDocumentType
KEY QuantityRepositoryVersion I_ACMRepAppItemDet QuantityRepositoryVersion
KEY MsrgPtInternalCharacteristic I_ACMRepAppItemDet MsrgPtInternalCharacteristic
LDCEventKey I_ACMRepAppItemDet LDCEventKey
QtyRepositoryAttributeValue I_ACMRepAppItemDet QtyRepositoryAttributeValue
AppDocQualityAttributeUnit I_ACMRepAppItemDet AppDocQualityAttributeUnit 
@AbapCatalog.sqlViewName: 'IAPPDOCQUALITY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@EndUserText.label: 'Q Repository Grades Application Doc'
define view I_ACMAppDocQuality
  as select from I_ACMApplicationDocItem1 as C
    inner join   I_ACMFinalLoadDataEvent  as L on C.LoadDataCaptureObjId = L.LDCId
    inner join   I_ACMRepAppItemDet       as Q on  L.ACMRepositoryWeightAppUUID = Q.ACMRepositoryWeightAppUUID
                                               and L.QuantityRepositoryVersion  = Q.QuantityRepositoryVersion

{
  key    C.ApplicationDocument      as ApplicationDocument,
  key    C.ReferenceApplicationItem as ReferenceApplicationItem,
  key    L.ACMReferenceDocumentType as ACMReferenceDocumentType,
  key    Q.QuantityRepositoryVersion,
  key    Q.MsrgPtInternalCharacteristic,
         Q.LDCEventKey,
         Q.QtyRepositoryAttributeValue,
         Q.AppDocQualityAttributeUnit
}

Learn More