I_ACMREPOSITORYGRADE

CDS View

Base for Q Repository Grade

I_ACMREPOSITORYGRADE is a CDS View in S/4HANA. Base for Q Repository Grade. It contains 15 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 15 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ACMApplDocAnalysis view_entity inner COMPOSITE Interface for Q Repository Grades
I_ACMRepositoryGradeData view_entity inner COMPOSITE Interface for Q Repository Grade Data

Fields (15)

KeyField CDS FieldsUsed in Views
KEY Characteristic Characteristic 2
KEY QuantityRepositoryUUID QuantityRepositoryUUID 2
KEY QuantityRepositoryVersion QuantityRepositoryVersion 2
ACMAnalysisType ACMAnalysisType 2
ACMAnalysisTypeText ACMAnalysisTypeText 2
AppDocQualityAttributeUnit AppDocQualityAttributeUnit 2
CharcDecimals CharcDecimals 1
CharcValueDescription CharcValueDescription 2
DiscPremQtyGovAnalysisCode DiscPremQtyGovAnalysisCode 2
DiscPremQtyOvrdGovAnalysisDesc DiscPremQtyOvrdGovAnalysisDesc 2
GovAnalysisSourceLoc GovAnalysisSourceLoc 2
GovAnalysisSourceLocText GovAnalysisSourceLocText 2
LDCEventKey LDCEventKey 1
NonNumericAttrib1Value NonNumericAttrib1Value 1
QtyRepositoryAttributeValue QtyRepositoryAttributeValue 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Base for Q Repository Grade'
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType: #BASIC
define view entity I_ACMRepositoryGrade
  as select from           /accgo/t_qr_ap_q                                      as Grade
    inner join             I_Relstartchar                                        as Description on  Description.CharacteristicInternalID = Grade.attribute
                                                                                                and Description.ArchivingObject          = '0000'
    inner join            I_ACMCharcsData                                        as Grade_char  on Grade_char.CharcInternalID           = Grade.attribute
    left outer to one join P_GenericDomainVH( p_domain_name: '/ACCGO/D_SOURCE' ) as Source      on Grade.source_grade = Source.DomainValue
    left outer to one join I_ACMApplAnalysisTypeVH                               as Type        on Grade.analysis_type = Type.ACMAnalysisType
    left outer to one join P_ACMDPQSGOVANL                                       as Code        on Grade.analysis_code = Code.DiscPremQtyOvrdGovAnalysisCode
{
  key    Grade.qrep_guid                            as QuantityRepositoryUUID,
  key    Grade.qrep_version                         as QuantityRepositoryVersion,
  key    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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACMAPPLANALYSISTYPEVH",
"I_ACMCHARCSDATA",
"I_RELSTARTCHAR",
"P_ACMDPQSGOVANL",
"P_GENERICDOMAINVH",
"/ACCGO/T_QR_AP_Q"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More