I_ACMAppDocDPQSEvaluation

DDL: I_ACMAPPDOCDPQSEVALUATION SQL: IACMAPPDPQSDET Type: view COMPOSITE

Interface DPQS Evaluation

I_ACMAppDocDPQSEvaluation is a Composite CDS View that provides data about "Interface DPQS Evaluation" in SAP S/4HANA. It reads from 2 data sources (I_ACMAppDocLatestVersion1, I_ApplDocDiscPremQltySchedEval) and exposes 14 fields with key fields ContractApplicationUUID, ContractApplicationVersion, ReferenceApplicationDocument, ReferenceApplicationItem, SequenceNumber.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
I_ACMAppDocLatestVersion1 AppDocLatestVersion inner
I_ApplDocDiscPremQltySchedEval DPQSEvaluation from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IACMAPPDPQSDET view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.preserveKey true view
ObjectModel.supportedCapabilities #CDS_MODELING_DATA_SOURCE view
EndUserText.label Interface DPQS Evaluation view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ContractApplicationUUID I_ApplDocDiscPremQltySchedEval ContractApplicationUUID
KEY ContractApplicationVersion I_ApplDocDiscPremQltySchedEval ContractApplicationVersion
KEY ReferenceApplicationDocument I_ACMAppDocLatestVersion1 ReferenceApplicationDocument
KEY ReferenceApplicationItem I_ACMAppDocLatestVersion1 ReferenceApplicationItem
KEY SequenceNumber I_ApplDocDiscPremQltySchedEval SequenceNumber
DiscPremQtyIntChar
DiscPremQtyCharcsName I_ApplDocDiscPremQltySchedEval DiscPremQtyCharcsName
ACMMinimumDPQSValue I_ApplDocDiscPremQltySchedEval ACMMinimumDPQSValue
ACMMaximumDPQSValue I_ApplDocDiscPremQltySchedEval ACMMaximumDPQSValue
UnitOfMeasure I_ApplDocDiscPremQltySchedEval UnitOfMeasure
EvaluatedQuantity I_ApplDocDiscPremQltySchedEval EvaluatedQuantity
AdjustedQuantity I_ApplDocDiscPremQltySchedEval AdjustedQuantity
ACMSettlementEvalDPQSQuantity I_ApplDocDiscPremQltySchedEval ACMSettlementEvalDPQSQuantity
SettlementAdjustedQuantity I_ApplDocDiscPremQltySchedEval SettlementAdjustedQuantity 
@AbapCatalog.sqlViewName: 'IACMAPPDPQSDET'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.preserveKey:true
@ObjectModel.supportedCapabilities: #CDS_MODELING_DATA_SOURCE
@EndUserText.label: 'Interface DPQS Evaluation'
define view I_ACMAppDocDPQSEvaluation
  as select from I_ApplDocDiscPremQltySchedEval as DPQSEvaluation

    inner join   I_ACMAppDocLatestVersion1      as AppDocLatestVersion on  AppDocLatestVersion.ContractApplicationUUID    =  DPQSEvaluation.ContractApplicationUUID
                                                                       and AppDocLatestVersion.ContractApplicationVersion =  DPQSEvaluation.ContractApplicationVersion
                                                                       and AppDocLatestVersion.ContractApplicationStatus  <> '9' //Reversed

{
  key DPQSEvaluation.ContractApplicationUUID,
  key DPQSEvaluation.ContractApplicationVersion,
  key AppDocLatestVersion.ReferenceApplicationDocument,
  key AppDocLatestVersion.ReferenceApplicationItem,
  key DPQSEvaluation.SequenceNumber,
      cast (DPQSEvaluation.DiscPremQtyIntChar as abap.numc( 10 )) as DiscPremQtyIntChar,
      DPQSEvaluation.DiscPremQtyCharcsName,
      DPQSEvaluation.ACMMinimumDPQSValue,
      DPQSEvaluation.ACMMaximumDPQSValue,
      @Semantics.unitOfMeasure: true
      DPQSEvaluation.UnitOfMeasure,
      //Evaluated Quantity

      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
      DPQSEvaluation.EvaluatedQuantity,
      //Adjusted Quantity

      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
      DPQSEvaluation.AdjustedQuantity,
      //Evaluated Quantity Settlement

      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
      DPQSEvaluation.ACMSettlementEvalDPQSQuantity, //SettlementEvaluatedQuantity,

      //Adjusted Quantity Settlement

      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
      DPQSEvaluation.SettlementAdjustedQuantity

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACMAPPDOCLATESTVERSION1",
"I_APPLDOCDISCPREMQLTYSCHEDEVAL"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More