I_FIELDLOGISTICSKITITEM

CDS View

Kit Item

I_FIELDLOGISTICSKITITEM is a CDS View in S/4HANA. Kit Item. It contains 2 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 2 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_FldLogsKitMaintOrderItem view_entity from COMPOSITE Kit Maintenance Order Item
I_FldLogsKitMatlDocumentItem view_entity from COMPOSITE Kit Material Document Item
I_FldLogsKitOutbDelivItmRef view_entity from COMPOSITE Kit Outbound Delivery Item Reference Document
I_FldLogsKitOutbDelivItmRef view_entity union COMPOSITE Kit Outbound Delivery Item Reference Document
I_FldLogsKitShipmentItem view_entity from COMPOSITE Kit Shipment Item
I_FldLogsKitTotNrOfOutbDlvItm view_entity from COMPOSITE Kit Total Number of Outbound Delivery Item
R_FieldLogisticsKitItemTP view_entity from TRANSACTIONAL Kit Item TP
R_FieldLogisticsKitItemTP_2 view_entity from TRANSACTIONAL Kit Item as a root entity

Fields (2)

KeyField CDS FieldsUsed in Views
KEY FieldLogisticsKitHeaderUUID FieldLogisticsKitHeaderUUID 1
KEY FieldLogisticsKitItemUUID FieldLogisticsKitItemUUID 1 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Kit Item'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #COMPOSITE
define view entity I_FieldLogisticsKitItem
  as select from I_FieldLogisticsKit

  association [1]    to I_DeliveryDocumentItem        as _DeliveryItem              on  $projection.FldLogsKitItmRefDocument1 = _DeliveryItem.DeliveryDocument
                                                                                    and $projection.FldLogsKitItmRefDocument2 = _DeliveryItem.DeliveryDocumentItem

  association [0..1] to I_FldLogsEWMRefDoc            as _FldLogsEWMRefDoc          on  $projection.FldLogsKitItmRefDocument1 = _FldLogsEWMRefDoc.DeliveryDocument
                                                                                    and $projection.FldLogsKitItmRefDocument2 = _FldLogsEWMRefDoc.DeliveryDocumentItem

  association [0..1] to I_FldLogsEWMWhseTaskDelivItm  as _HandlingUnitWarehouseTask on  $projection.deliveryuuid                            = _HandlingUnitWarehouseTask.EWMWarehouseRequestUUID
                                                                                    and _HandlingUnitWarehouseTask.EWMDocumentCategory      = 'PDO'
                                                                                    and _HandlingUnitWarehouseTask.WarehouseProcessCategory is not initial

  association [0..1] to I_EWM_WarehouseRequestOutItem as _OpenWarehouseTask         on  $projection.deliveryuuid                =  _OpenWarehouseTask.EWMWarehouseRequestUUID
                                                                                    and _OpenWarehouseTask.PlannedPickingStatus <> '9'

  association [0..1] to I_EWM_OpenWarehouseTasks      as _PartialOpenWarehouseTask  on  $projection.deliveryuuid = _PartialOpenWarehouseTask.ReferenceDocumentUUID


  association [0..1] to I_EWM_OutbDelivOrdSts         as _PickingStatus             on  $projection.deliveryuuid          = _PickingStatus.OutboundDeliveryOrderUUID
                                                                                    and $projection.deliveryitemuuid      = _PickingStatus.OutboundDeliveryOrderItemUUID
                                                                                    and _PickingStatus.DeliveryStatusType = 'DPI'
{
  key FieldLogisticsKitItemUUID     as FieldLogisticsKitItemUUID,
  key FieldLogisticsKitHeaderUUID   as FieldLogisticsKitHeaderUUID,
      FldLogsKitItmRefDocument1     as FldLogsKitItmRefDocument1,
      FldLogsKitItmRefDocument2     as FldLogsKitItmRefDocument2,
      FldLogsKitItmRefDocument3     as FldLogsKitItmRefDocument3,
      FldLogsKitItmRefDocument4     as FldLogsKitItmRefDocument4,
      FldLogsKitItmRefDocument1UUID as FldLogsKitItmRefDocument1UUID,
      FldLogsKitItmRefDocument2UUID as FldLogsKitItmRefDocument2UUID,
      FldLogsReferenceDocCategory   as FldLogsReferenceDocCategory,
      ParentObjectUUID              as ParentObjectUUID,
      LastChangeDateTime            as LastChangeDateTime,
      FldLogsKitIsTwoStpGRCmpltd    as FldLogsKitIsTwoStpGRCmpltd,
      FldLogsKitDispatchOnHold      as FldLogsKitDispatchOnHold,
      _FldLogsEWMRefDoc.DeliveryUUID,
      _FldLogsEWMRefDoc.DeliveryItemUUID,


      /*Associations*/
      _DeliveryItem,
      _FldLogsEWMRefDoc,
      _PickingStatus,
      _OpenWarehouseTask,
      _PartialOpenWarehouseTask,
      _HandlingUnitWarehouseTask

}

Learn More