R_FldLogsKitReceivedItem

DDL: R_FLDLOGSKITRECEIVEDITEM Type: view_entity TRANSACTIONAL
30 Fields 1 Data Sources 4 Associations

Kit Received Item

R_FldLogsKitReceivedItem is a Transactional CDS View that provides data about "Kit Received Item" in SAP S/4HANA. It reads from 1 data source (I_FldLogsKitReceivedItem) and exposes 30 fields with key fields FieldLogisticsKitItemUUID, FieldLogisticsKitHeaderUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsKitReceivedItem I_FldLogsKitReceivedItem from

Associations (4)

CardinalityTargetAliasCondition
[1] I_FldLogsShptCtnPackggUntRecd _ShipmentContainer $projection.FldLogsContainerUnitUUID = _ShipmentContainer.FldLogsContainerUnitUUID
[1] I_FldLogsSuplrItmAuxTypeText _WarehouseTasks _WarehouseTasks.FldLogsAuxSubTypeCode = 'WAREHSTASK'
[1] I_FldLogsSuplrItmAuxTypeText _HandlingUnits _HandlingUnits.FldLogsAuxSubTypeCode = 'HNDLNGUT'
[0..*] I_OrderCategoryText _OrderCategoryText $projection.ordercategory = _OrderCategoryText.OrderCategory

Annotations (10)

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 #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AbapCatalog.extensibility.extensible true view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY FieldLogisticsKitItemUUID FieldLogisticsKitItemUUID Kit Item ID
KEY FieldLogisticsKitHeaderUUID FieldLogisticsKitHeaderUUID kit header id
FldLogsKitItmRefDocument1 FldLogsKitItmRefDocument1 Reference Doc Number
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 FldLogsKitPlannedDeliveryDate Delivery Date
EWMOutboundDeliveryOrder EWMOutboundDeliveryOrder Document Number
DeliveryDocument DeliveryDocument Outbound Delivery
OutboundDelivery DeliveryDocument Outbound Delivery
PurchaseOrder PurchaseOrder Purchasing Document
FldLogsContainerUnitUUID FldLogsContainerUnitUUID Container Unit ID
EWMWarehouse EWMWarehouse Warehouse No.
Material Material Vehicle Model
LastChangeDateTime LastChangeDateTime Timestamp
FldLogsSrcePlnt FldLogsSrcePlnt Plant
MaintenanceOrder
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
StockTransportOrder StockTransportOrder STO Number
StockTransportOrderItem StockTransportOrderItem STO Item
OrderCategory _KitHeader OrderCategory Order Category
FldLogsKitDispatchOnHold FldLogsKitDispatchOnHold Dispatch On hold
HandlingUnitId HandlingUnitId
_KitHeader _KitHeader
_ShipmentContainer _ShipmentContainer
_OrderCategoryText _OrderCategoryText

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 R_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 R_FldLogsKitReceivedItem AS
SELECT
  FieldLogisticsKitItemUUID,
  FieldLogisticsKitHeaderUUID,
  FldLogsKitItmRefDocument1,
  Quantity,
  BaseUnit,
  FldLogsReferenceDocumentNumber,
  ItemDescription,
  FldLogsDelivIsHeldOnShore,
  StorageBin,
  DeliveryDate,
  FldLogsKitPlannedDeliveryDate,
  EWMOutboundDeliveryOrder,
  DeliveryDocument,
  DeliveryDocument AS OutboundDelivery,
  PurchaseOrder,
  FldLogsContainerUnitUUID,
  EWMWarehouse,
  Material,
  LastChangeDateTime,
  FldLogsSrcePlnt,
  ltrim( MaintenanceOrder, '0' ) AS MaintenanceOrder,
  IsEndOfPurposeBlocked,
  StockTransportOrder,
  StockTransportOrderItem,
  _KitHeader.OrderCategory AS OrderCategory,
  FldLogsKitDispatchOnHold,
  HandlingUnitId
FROM I_FldLogsKitReceivedItem
LEFT OUTER JOIN I_FldLogsShptCtnPackggUntRecd AS _ShipmentContainer ON FldLogsContainerUnitUUID = _ShipmentContainer.FldLogsContainerUnitUUID  -- association [1]
LEFT OUTER JOIN I_FldLogsSuplrItmAuxTypeText AS _WarehouseTasks ON _WarehouseTasks.FldLogsAuxSubTypeCode = 'WAREHSTASK'  -- association [1]
LEFT OUTER JOIN I_FldLogsSuplrItmAuxTypeText AS _HandlingUnits ON _HandlingUnits.FldLogsAuxSubTypeCode = 'HNDLNGUT'  -- association [1]
LEFT OUTER JOIN I_OrderCategoryText AS _OrderCategoryText ON ordercategory = _OrderCategoryText.OrderCategory  -- association [0..*]
;

Learn More