I_ACMAppDocToleranceDet

DDL: I_ACMAPPDOCTOLERANCEDET SQL: IACMAPPTOLDET Type: view COMPOSITE

Interface Tolerance Eval Details

I_ACMAppDocToleranceDet is a Composite CDS View that provides data about "Interface Tolerance Eval Details" in SAP S/4HANA. It reads from 2 data sources (I_ACMAppDocLatestVersion1, I_ApplicationDocTolEval) and exposes 18 fields with key fields ContractApplicationUUID, ContractApplicationVersion, ReferenceApplicationDocument, ReferenceApplicationItem, TradingContractNumber.

2 data source(s) 18 fields

Data Sources (2)

SourceAliasJoin Type
I_ACMAppDocLatestVersion1 AppDocLatestVersion inner
I_ApplicationDocTolEval ToleranceEval from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IACMAPPTOLDET view
EndUserText.label Interface Tolerance Eval Details view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.supportedCapabilities #CDS_MODELING_DATA_SOURCE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ContractApplicationUUID I_ApplicationDocTolEval ContractApplicationUUID
KEY ContractApplicationVersion I_ApplicationDocTolEval ContractApplicationVersion
KEY ReferenceApplicationDocument I_ACMAppDocLatestVersion1 ReferenceApplicationDocument
KEY ReferenceApplicationItem I_ACMAppDocLatestVersion1 ReferenceApplicationItem
KEY TradingContractNumber I_ApplicationDocTolEval TradingContractNumber
KEY TradingContractItem I_ApplicationDocTolEval TradingContractItem
KEY ACMToleranceHeaderUUID I_ApplicationDocTolEval ACMToleranceHeaderUUID
KEY ACMTolEvalTabSequenceNumber I_ApplicationDocTolEval ACMTolEvalTabSequenceNumber
ACMTrdgContrToleranceSchedule I_ApplicationDocTolEval ACMTrdgContrToleranceSchedule
ACMToleranceScheduleIdText I_ApplicationDocTolEval ACMToleranceScheduleIdText
ACMToleranceTypeID I_ApplicationDocTolEval ACMToleranceTypeID
ToleranceTypeIdText I_ApplicationDocTolEval ToleranceTypeIdText
ACMUnderFillOverFillDirection I_ApplicationDocTolEval ACMUnderFillOverFillDirection
ACMUnderFillOverFillDrctnText I_ApplicationDocTolEval ACMUnderFillOverFillDrctnText
ACMToleranceDeliveryQuantity I_ApplicationDocTolEval ACMToleranceDeliveryQuantity
UnitOfMeasure I_ApplicationDocTolEval UnitOfMeasure
ACMTolItemFromPercentageVal I_ApplicationDocTolEval ACMTolItemFromPercentageVal
ACMTolItemToPercentageVal I_ApplicationDocTolEval ACMTolItemToPercentageVal 
@AbapCatalog.sqlViewName: 'IACMAPPTOLDET'
@EndUserText.label: 'Interface Tolerance Eval Details'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.supportedCapabilities: #CDS_MODELING_DATA_SOURCE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view I_ACMAppDocToleranceDet
  as select from I_ApplicationDocTolEval   as ToleranceEval

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

{
  key ToleranceEval.ContractApplicationUUID,
  key ToleranceEval.ContractApplicationVersion,
  key AppDocLatestVersion.ReferenceApplicationDocument,
  key AppDocLatestVersion.ReferenceApplicationItem,
  key ToleranceEval.TradingContractNumber,
  key ToleranceEval.TradingContractItem,
  key ToleranceEval.ACMToleranceHeaderUUID,
  key ToleranceEval.ACMTolEvalTabSequenceNumber,
      ToleranceEval.ACMTrdgContrToleranceSchedule,
      ToleranceEval.ACMToleranceScheduleIdText,
      ToleranceEval.ACMToleranceTypeID,
      ToleranceEval.ToleranceTypeIdText,
      ToleranceEval.ACMUnderFillOverFillDirection,
      ToleranceEval.ACMUnderFillOverFillDrctnText,
      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
      ToleranceEval.ACMToleranceDeliveryQuantity,
      @Semantics.unitOfMeasure: true
      ToleranceEval.UnitOfMeasure,
      ToleranceEval.ACMTolItemFromPercentageVal,
      ToleranceEval.ACMTolItemToPercentageVal

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

Learn More