I_ACMFINALLOADDATAEVENT

CDS View

Interface Final LDC Event Details

I_ACMFINALLOADDATAEVENT is a CDS View in S/4HANA. Interface Final LDC Event Details. It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ACMAppDocQuality view inner COMPOSITE Q Repository Grades Application Doc
I_ACMLoadDataCaptureDet view inner COMPOSITE Interface Load Data Capture details

Fields (9)

KeyField CDS FieldsUsed in Views
KEY ACMReferenceDocumentType ACMReferenceDocumentType 1
ACMLoadDataCaptureEventKeyUUID ACMLoadDataCaptureEventKeyUUID 1
ACMScaleTicketNumber ACMScaleTicketNumber 1
BillOfLading BillOfLading 1
BillOfLadingDate BillOfLadingDate 1
Commodity Commodity 1
EventDate EventDate 1
LoadDataCaptureEventType LoadDataCaptureEventType 1
Material Material 1
@AbapCatalog.sqlViewName: 'IACMFINALLDC'
@AbapCatalog.compiler.compareFilter: true
@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
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Interface Final LDC Event Details'
@ObjectModel.supportedCapabilities: #CDS_MODELING_DATA_SOURCE
define view I_ACMFinalLoadDataEvent
  as select from I_ACMLoadDataCaptureEvt  as LDCEvent

    inner join   I_ACMLatestLoadDataEvent as LatestEvent on  LatestEvent.LDCId                    = LDCEvent.LDCId
                                                         and LatestEvent.LoadDataCaptureEventType = LDCEvent.LoadDataCaptureEventType

{
  key LDCEvent.LDCKey,
  key LDCEvent.ACMLoadDataCaptureEventKeyUUID,
  key LDCEvent.ACMRepositoryWeightAppUUID,
  key LDCEvent.QuantityRepositoryVersion,
      LDCEvent.LDCId,
      LDCEvent.ACMReferenceDocumentType,
      LDCEvent.LoadDataCaptureEventType,
      LDCEvent.LoadDataCaptureItem,
      LDCEvent.EventDate,
      LDCEvent.ACMScaleTicketNumber,
      LDCEvent.BillOfLadingDate,
  /*BillOfLadingDate*/
      LDCEvent.BillOfLading,
  /*BillOfLading*/
      LDCEvent.Material,
      LDCEvent.Commodity,
      LDCEvent.ReferenceApplicationItem

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