I_ACMLoadDataCaptureEvt

DDL: I_ACMLOADDATACAPTUREEVT SQL: IACMLDCEVT Type: view COMPOSITE

Interface LDC Event Details

I_ACMLoadDataCaptureEvt is a Composite CDS View that provides data about "Interface LDC Event Details" in SAP S/4HANA. It reads from 2 data sources (I_ACMLoadDataCaptureEvtData1, I_ACMSystemStatus) and exposes 16 fields with key fields LDCKey, ACMLoadDataCaptureEventKeyUUID, ACMRepositoryWeightAppUUID, QuantityRepositoryVersion.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
I_ACMLoadDataCaptureEvtData1 LDCEvent from
I_ACMSystemStatus Status inner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IACMLDCEVT view
AbapCatalog.compiler.compareFilter true 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
AccessControl.authorizationCheck #CHECK view
EndUserText.label Interface LDC Event Details view
ObjectModel.supportedCapabilities #CDS_MODELING_DATA_SOURCE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY LDCKey I_ACMLoadDataCaptureEvtData1 LDCKey
KEY ACMLoadDataCaptureEventKeyUUID I_ACMLoadDataCaptureEvtData1 ACMLoadDataCaptureEventKeyUUID
KEY ACMRepositoryWeightAppUUID I_ACMLoadDataCaptureEvtData1 ACMRepositoryWeightAppUUID
KEY QuantityRepositoryVersion I_ACMLoadDataCaptureEvtData1 QuantityRepositoryVersion
LDCId I_ACMLoadDataCaptureEvtData1 LDCId
ACMReferenceDocumentType I_ACMLoadDataCaptureEvtData1 ACMReferenceDocumentType
LoadDataCaptureEventType I_ACMLoadDataCaptureEvtData1 LoadDataCaptureEventType
LoadDataCaptureItem I_ACMLoadDataCaptureEvtData1 LoadDataCaptureItem
EventDate I_ACMLoadDataCaptureEvtData1 EventDate
ACMScaleTicketNumber I_ACMLoadDataCaptureEvtData1 ACMScaleTicketNumber
BillOfLadingDate I_ACMLoadDataCaptureEvtData1 BillOfLadingDate
BillOfLading I_ACMLoadDataCaptureEvtData1 BillOfLading
Material I_ACMLoadDataCaptureEvtData1 Material
Commodity I_ACMLoadDataCaptureEvtData1 Commodity
ReferenceApplicationItem I_ACMLoadDataCaptureEvtData1 ReferenceApplicationItem
ACMAppDocStatus I_ACMSystemStatus StatusProfileName 
@AbapCatalog.sqlViewName: 'IACMLDCEVT'
@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 LDC Event Details'
@ObjectModel.supportedCapabilities: #CDS_MODELING_DATA_SOURCE
define view I_ACMLoadDataCaptureEvt
  as select from I_ACMLoadDataCaptureEvtData1 as LDCEvent

    inner join   I_ACMSystemStatus            as Status on  Status.ApplicationStatusObject        = LDCEvent.ACMLoadDataCaptureStatusObj
                                                        and Status.ChangeDocumentStatusIsInactive = ''


{
  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,
      Status.StatusProfileName as ACMAppDocStatus
}
where
     Status.StatusProfileName = 'I7U07' //OF Execution Successful

  or Status.StatusProfileName = 'I7U02' //Obsolete

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

Learn More