I_FldLogsKitReceivedItem

DDL: I_FLDLOGSKITRECEIVEDITEM Type: view_entity COMPOSITE Package: FLOG_SHIPMENT_PACKCTN
46 Fields 2 Data Sources

Kit Received Item

I_FldLogsKitReceivedItem is a Composite CDS View that provides data about "Kit Received Item" in SAP S/4HANA. It reads from 2 data sources (I_FldLogsKitPkablOutbDelivItm, I_FldLogsKitRcvdPurrOrderItem) and exposes 46 fields with key fields FieldLogisticsKitItemUUID, FieldLogisticsKitHeaderUUID, FieldLogisticsKitHeaderUUID. Part of development package FLOG_SHIPMENT_PACKCTN.

Data Sources (2)

SourceAliasJoin Type
I_FldLogsKitPkablOutbDelivItm I_FldLogsKitPkablOutbDelivItm from
I_FldLogsKitRcvdPurrOrderItem I_FldLogsKitRcvdPurrOrderItem union

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Kit Received Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY FieldLogisticsKitItemUUID FieldLogisticsKitItemUUID Kit Item ID
KEY FieldLogisticsKitHeaderUUID FieldLogisticsKitHeaderUUID kit header id
FldLogsKitItmRefDocument1 FldLogsKitItmRefDocument1 Purchasing Document
Quantity Quantity Value
BaseUnit BaseUnit Unit of Measure
FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
ItemDescription ItemDescription Description
FldLogsDelivIsHeldOnShore FldLogsDelivIsHeldOnShore Hold On-Shore
StorageBin StorageBin Storage Bin
DeliveryDate DeliveryDate Delivery Date
FldLogsKitPlannedDeliveryDate Delivery Date
DeliveryDocument _DeliveryItem DeliveryDocument Outbound Delivery
PurchaseOrder Purchasing Document
StatusendasPackingStatus
FldLogsContainerUnitUUID _PurchaseOrderShipmentItem FldLogsContainerUnitUUID Container Unit ID
EWMOutboundDeliveryOrder EWMOutboundDeliveryOrder Document Number
EWMWarehouse EWMWarehouse Warehouse No.
Material Material Vehicle Model
LastChangeDateTime LastChangeDateTime Timestamp
FldLogsSrcePlnt _DeliveryItem Plant Plant
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
PlannedPickingStatus _WarehouseRequestOutItem PlannedPickingStatus Status Value
StockTransportOrder STO Number
KEY FieldLogisticsKitHeaderUUID FieldLogisticsKitHeaderUUID kit header id
FldLogsKitItmRefDocument1 PurchaseOrder Purchasing Document
Quantity Quantity Value
BaseUnit BaseUnit Unit of Measure
FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
ItemDescription ItemDescription Description
StorageBin Storage Bin
DeliveryDate Delivery Date
FldLogsKitPlannedDeliveryDate FldLogsKitPlannedDeliveryDate Delivery Date
DeliveryDocument Outbound Delivery
PurchaseOrder PurchaseOrder Purchasing Document
PackingStatus
FldLogsContainerUnitUUID _PurchaseOrderShipmentItem FldLogsContainerUnitUUID Container Unit ID
EWMOutboundDeliveryOrder Document Number
EWMWarehouse Warehouse No.
Material Material Vehicle Model
LastChangeDateTime LastChangeDateTime Timestamp
FldLogsSrcePlnt FldLogsSrcePlnt Plant
MaintenanceOrder MaintenanceOrder Order
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
PlannedPickingStatus Status Value
StockTransportOrder StockTransportOrder STO Number
StockTransportOrderItem StockTransportOrderItem STO Item

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_FldLogsKitReceivedItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_FldLogsKitReceivedItem AS
SELECT
  FieldLogisticsKitItemUUID,
  FieldLogisticsKitHeaderUUID,
  FldLogsKitItmRefDocument1,
  Quantity,
  BaseUnit,
  FldLogsReferenceDocumentNumber,
  ItemDescription,
  FldLogsDelivIsHeldOnShore,
  StorageBin,
  DeliveryDate,
  abap.dats'00000000' AS FldLogsKitPlannedDeliveryDate,
  _DeliveryItem.DeliveryDocument AS DeliveryDocument,
  cast('' as ebeln) AS PurchaseOrder,
  case when EWMOutboundDeliveryOrder is null or EWMOutboundDeliveryOrder is initial then _DeliveryItem.PackingStatus else _PickingStatus.Status end as PackingStatus AS StatusendasPackingStatus,
  _PurchaseOrderShipmentItem.FldLogsContainerUnitUUID AS FldLogsContainerUnitUUID,
  EWMOutboundDeliveryOrder,
  EWMWarehouse,
  Material,
  LastChangeDateTime,
  _DeliveryItem.Plant AS FldLogsSrcePlnt,
  IsEndOfPurposeBlocked,
  _WarehouseRequestOutItem.PlannedPickingStatus AS PlannedPickingStatus,
  cast('' as ebeln) AS StockTransportOrder,
  abap.char'' AS PackingStatus,
  MaintenanceOrder,
  StockTransportOrderItem
FROM I_FldLogsKitPkablOutbDelivItm
-- UNION with additional select branch(es): I_FldLogsKitRcvdPurrOrderItem
;

Learn More