I_FLDLOGSEWMREFDOC

CDS View

Field Logistics EWM Reference Documents

I_FLDLOGSEWMREFDOC is a CDS View in S/4HANA. Field Logistics EWM Reference Documents. It contains 3 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 3 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_FldLogsHandlingUnits view inner COMPOSITE Handling Units
I_FldLogsInbDelivWhseTsk view inner COMPOSITE Field Logistics : Inbound del. Whr. Task
I_FldLogsOpenPackQty view inner COMPOSITE Open Quantity Hu Packing
I_FldLogsWhseTaskInfo view inner COMPOSITE Field Logistics Warehouse Tasks

Fields (3)

KeyField CDS FieldsUsed in Views
KEY DeliveryDocument DeliveryDocument 4
KEY DeliveryDocumentItem DeliveryDocumentItem 4
EWMReferenceDocumentCategory EWMReferenceDocumentCategory 1 
@AbapCatalog.sqlViewName: 'IFLEWMREFDOC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #TRANSACTIONAL,
                         sizeCategory: #XL}
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Field Logistics EWM Reference Documents'
define view I_FldLogsEWMRefDoc
  as select from I_EWM_WarehouseRequestRefDoc as _EWMRefdoc
  association [0..1] to I_FldLogsEWMOutbDelivOrdItm as _EWMOutboundDelivOrder on  _EWMRefdoc.EWMWarehouseRequestUUID     = _EWMOutboundDelivOrder.OutboundDeliveryOrderUUID
                                                                              and _EWMRefdoc.EWMWarehouseRequestItemUUID = _EWMOutboundDelivOrder.OutboundDeliveryOrderItemUUID
 association[0..1] to I_EWM_OutboundDeliveryItem as _EWMOutbDelivery on           _EWMRefdoc.EWMWarehouseRequestUUID = _EWMOutbDelivery.OutboundDeliveryOrderUUID
                                                                              and _EWMRefdoc.EWMWarehouseRequestItemUUID = _EWMOutbDelivery.OutboundDeliveryOrderItemUUID
 
{
  key EWMWarehouseRequestUUID                                          as DeliveryUUID,
  key EWMWarehouseRequestItemUUID                                      as DeliveryItemUUID,
  key EWMReferenceDocumentCategory                                     as EWMReferenceDocumentCategory,
  key ReferenceDocumentUUID                                            as ReferenceDocumentUUID,
  key ReferenceDocumentItemUUID                                        as ReferenceDocumentItemUUID,
      EWMWhseRequestDocumentCategory                                   as EWMDeliveryDocumentCategory,
      EWMWhseReqRefDocumentNumber                                      as EWMRefDeliveryDocumentNumber,
      EWMWhseRequestRefDocumentItem                                    as EWMRefDeliveryDocumentItem,
      BusinessSystemName                                               as BusinessSystemName,
      cast(EWMWhseReqRefDocumentNumber as vbeln_vl)                    as DeliveryDocument,
      cast(substring(EWMWhseRequestRefDocumentItem, 5, 6) as posnr_vl) as DeliveryDocumentItem,
      _EWMOutboundDelivOrder,
      _EWMOutbDelivery
}
where
  (
       EWMWhseRequestDocumentCategory = 'PDO'
    or EWMWhseRequestDocumentCategory = 'PDI'
  )
  and  EWMReferenceDocumentCategory   = 'ERP'
  and  EWMWarehouseRequestItemUUID != hextobin( '00000000000000000000000000000000' )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EWM_WAREHOUSEREQUESTREFDOC"
],
"ASSOCIATED":
[
"I_EWM_OUTBOUNDDELIVERYITEM",
"I_FLDLOGSEWMOUTBDELIVORDITM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More