R_FldLogsKitReceivedItem

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,
  DeliveryDocumentItem,
  DeliveryDocument AS OutboundDelivery,
  PurchaseOrder,
  EWMWarehouse,
  Material,
  LastChangeDateTime,
  FldLogsSrcePlnt,
  cast ( ltrim( MaintenanceOrder, '0' ) as aufnr ) AS MaintenanceOrder,
  IsEndOfPurposeBlocked,
  StockTransportOrder,
  StockTransportOrderItem,
  _KitHeader.OrderCategory AS OrderCategory,
  FldLogsKitDispatchOnHold,
  HandlingUnitId,
  cast( MaintenanceOrderOperation as flog_doc ) AS FldLogsKitItmRefDocument2,
  cast( MaintenanceOrderComponent as flog_doc ) AS FldLogsKitItmRefDocument3,
  coalesce(_RstrcdItmIntegration.FldLogsItemIsRestricted, '') AS FldLogsItemIsRestricted
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..*]
LEFT OUTER JOIN E_FieldLogisticsKitItem AS _KitReceivedItemExt ON FieldLogisticsKitItemUUID = _KitReceivedItemExt.FieldLogisticsKitItemUUID  -- association [1..1]
LEFT OUTER JOIN I_FldLogsShipmentItem AS _ShipmentItemTagged ON DeliveryDocument = _ShipmentItemTagged.DeliveryDocument AND DeliveryDocumentItem = _ShipmentItemTagged.DeliveryDocumentItem  -- association [1]
LEFT OUTER JOIN I_FldLogsRstrcdItmIntegration AS _RstrcdItmIntegration ON FldLogsReferenceDocumentNumber = _RstrcdItmIntegration.FldLogsRstrcdItmRefDocNmbr  -- association [0..1]
;