I_ACMLoadDataCaptureEvtDet

DDL: I_ACMLOADDATACAPTUREEVTDET SQL: IACMLDCEVTDET Type: view BASIC

Basic LDC Event Details

I_ACMLoadDataCaptureEvtDet is a Basic CDS View that provides data about "Basic LDC Event Details" in SAP S/4HANA. It reads from 2 data sources (I_ACMMaterialMstrData, /accgo/t_uisevnt) and exposes 10 fields with key fields LDCKey, ACMLoadDataCaptureEventKeyUUID.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_ACMMaterialMstrData _Material inner
/accgo/t_uisevnt LDCEvent from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IACMLDCEVTDET view
AbapCatalog.compiler.compareFilter true view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC 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 Basic LDC Event Details view
ObjectModel.supportedCapabilities #CDS_MODELING_DATA_SOURCE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY LDCKey /accgo/t_uisevnt parent_key
KEY ACMLoadDataCaptureEventKeyUUID /accgo/t_uisevnt uis_evnt_key
LoadDataCaptureEventType /accgo/t_uisevnt event_type
LoadDataCaptureItem /accgo/t_uisevnt item
EventDate /accgo/t_uisevnt evnt_actual_date
ACMScaleTicketNumber /accgo/t_uisevnt scale_tkt_no
BillOfLadingDate /accgo/t_uisevnt bol_date
BillOfLading /accgo/t_uisevnt bol
Material /accgo/t_uisevnt material
Commodity I_ACMMaterialMstrData Commodity 
@AbapCatalog.sqlViewName: 'IACMLDCEVTDET'
@AbapCatalog.compiler.compareFilter: true
@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
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Basic LDC Event Details'
@ObjectModel.supportedCapabilities: #CDS_MODELING_DATA_SOURCE
define view I_ACMLoadDataCaptureEvtDet 
  as select from /accgo/t_uisevnt as LDCEvent
    
  inner join I_ACMMaterialMstrData as _Material on LDCEvent.material = _Material.Material
  

  {
    key LDCEvent.parent_key          as LDCKey,
    key LDCEvent.uis_evnt_key        as ACMLoadDataCaptureEventKeyUUID,
        LDCEvent.event_type          as LoadDataCaptureEventType,
        LDCEvent.item                as LoadDataCaptureItem,
        LDCEvent.evnt_actual_date    as EventDate,
        LDCEvent.scale_tkt_no        as ACMScaleTicketNumber,
        LDCEvent.bol_date            as BillOfLadingDate, /*BillOfLadingDate*/
        LDCEvent.bol                 as BillOfLading,     /*BillOfLading*/
        LDCEvent.material            as Material,
        _Material.Commodity          as Commodity

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

Learn More