I_ACMLOADDATACAPTUREDET

CDS View

Interface Load Data Capture details

I_ACMLOADDATACAPTUREDET is a CDS View in S/4HANA. Interface Load Data Capture details. It contains 7 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 7 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ACMApplicationOverview1 view inner COMPOSITE Interface ACM Application Overview1

Fields (7)

KeyField CDS FieldsUsed in Views
ACMLoadDataCaptureEventKeyUUID ACMLoadDataCaptureEventKeyUUID 1
ACMScaleTicketNumber ACMScaleTicketNumber 1
BillOfLading BillOfLading 1
BillOfLadingDate BillOfLadingDate 1
Commodity Commodity 1
EventDate EventDate 1
Material Material 1 
@AbapCatalog.sqlViewName: 'IACMLDCHDR2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@ObjectModel:{
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #C,
sizeCategory: #L
}
}
@EndUserText.label: 'Interface Load Data Capture details'
define view I_ACMLoadDataCaptureDet 
  as select distinct from I_ACMLoadDataCaptureHdr1 as LDCHdr 
  
  inner join I_ACMFinalLoadDataEvent as LDCEventData on LDCHdr.LDCKey = LDCEventData.LDCKey
  
//  left outer to one join I_ACMLoadDataCaptureWeightsDet      as LDCWeights on LDCEventData.ACMEventKeyUUID = LDCWeights.ACMEventKeyUUID

    {
      key LDCHdr.LDCKey,
      key LDCHdr.LDCId,
          LDCHdr.ReferenceVendor,
          LDCHdr.TransactingCtpty,
          LDCEventData.ACMLoadDataCaptureEventKeyUUID,
          LDCEventData.LoadDataCaptureEventType,
          LDCEventData.EventDate,
          LDCEventData.ACMScaleTicketNumber,
          LDCEventData.BillOfLadingDate, 
          LDCEventData.BillOfLading,  
          LDCEventData.Material,
          LDCEventData.Commodity                       
    }
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACMFINALLOADDATAEVENT",
"I_ACMLOADDATACAPTUREHDR1"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More