I_ACMAPPDOCLATESTVERSION1

CDS View

Interface App Doc Latest Version Data

I_ACMAPPDOCLATESTVERSION1 is a CDS View in S/4HANA. Interface App Doc Latest Version Data. It contains 14 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ACMAppDocDPQSEvaluation view inner COMPOSITE Interface DPQS Evaluation
I_ACMAppDocToleranceDet view inner COMPOSITE Interface Tolerance Eval Details
I_ACMApplicationOverview1 view from COMPOSITE Interface ACM Application Overview1

Fields (14)

KeyField CDS FieldsUsed in Views
KEY ReferenceApplicationDocument ReferenceApplicationDocument 2
KEY ReferenceApplicationItem ReferenceApplicationItem 3
ACMOverfillQuantity ACMOverfillQuantity 1
ACMUnderFillQuantity ACMUnderFillQuantity 1
ApplDocumentCreatedBy ApplDocumentChangedBy,ApplDocumentCreatedBy 1
ApplicationItemChangedOnDate ApplicationItemChangedOnDate 1
ApplicationItemCreatedOnDate ApplicationItemCreatedOnDate 1
ContractApplicationUUID ContractApplicationUUID 1
ContractApplicationVersion ContractApplicationVersion 1
DeliveryDate DeliveryDate 1
ReferenceApplicationSide ReferenceApplicationSide 1
ReferenceApplicationSubItem ReferenceApplicationSubItem 1
TradingContractItem TradingContractItem 1
TradingContractNumber TradingContractNumber 1
@AbapCatalog.sqlViewName: 'IACMAPPLATESTVER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@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 App Doc Latest Version Data'
define view I_ACMAppDocLatestVersion1
  as select from P_ACMApplicationLatestVersion
{

  key ContractApplicationUUID,
  key ContractApplicationVersion,
      ReferenceApplicationDocument,
      ReferenceApplicationItem,
      ReferenceApplicationSide,
      ReferenceApplicationSubItem,
      ContractNum                                 as TradingContractNumber,
      ContractItem                                as TradingContractItem,
      DeliveryDate,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      ACMOverfillQuantity,
      @Semantics.quantity.unitOfMeasure: 'TrdgContractApplUnitOfMeasure'
      ACMUnderFillQuantity,
      @Semantics.unitOfMeasure: true
      TrdgContractApplUnitOfMeasure,
      CreatedBy                                   as ApplDocumentCreatedBy,
      ChangedBy                                   as ApplDocumentChangedBy,
      tstmp_to_dats( CreatedOn,                                       //Convert To Date

                     abap_system_timezone( $session.client,'NULL' ),
                     $session.client,
                     'NULL' )                     as ApplicationItemCreatedOnDate,

      tstmp_to_dats( ChangedOn,                                       //Convert To Date

                     abap_system_timezone( $session.client,'NULL' ),
                     $session.client,
                     'NULL' )                     as ApplicationItemChangedOnDate,

      cast( ContractApplicationStatus as char1  ) as ContractApplicationStatus,
      ConversionFactorNmrtrValue,
      ConversionFactorDnmntrValue,
      UnitOfMeasure,
      ACMRepositoryWeightAppUUID,
      LatestGroupVersion

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