I_FldLogsRcvdHndlgUntItmBasic

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_FldLogsRcvdHndlgUntItmBasic.
-- 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_FldLogsRcvdHndlgUntItmBasic AS
SELECT
  FldLogsShptItemUUID,
  FldLogsShptItmHndlgUnitID,
  ref_doc AS FldLogsReferenceDocumentNumber,
  dispatchdat AS DispatchedStartDate,
  dispatch_loc AS FldLogsDispatchPlant,
  ref_doctyp AS FldLogsReferenceDocCategory,
  matnr AS Material,
  load_quantity AS RetblQtyInOrderUnit,
  loadqtyorderunit AS RetblQtyOrderUnit,
  loadqtyinbaseunit AS RetblQtyInBaseUnit,
  unit AS RetblQtyBaseUnit,
  FldLogsSupplyProcess,
  item_type AS FldLogsItemType,
  ret_status AS FldLogsReturnStatus,
  item_status AS FldLogsContainerItemStatus,
  quk_action AS FldLogsCtnQuickAction,
  gr AS MaterialDocument,
  ret_po AS PurchasingDocument,
  ret_po AS StockTransportOrder,
  ret_po AS FldLogsRetServicePurOrd,
  storage_type AS FldLogsStorageType,
  Batch,
  valuation_typ AS ValuationType,
  serialno AS SerialNumber,
  receivingplant AS FieldLogisticsReceivingPlant,
  process_type AS FieldLogisticsProcessType,
  FldLogsSubcontractingPO,
  FldLogsSubcontrgPOIsCreated,
  del_flag AS IsMarkedForDeletion,
  changedat AS FldLogsCtnItmChangeDateTime,
  FldLogsRetPOOutbDelivIsCreated,
  FldLogsContainerUnitUUID,
  FldLogsShptVoyageUUID,
  FldLogsShptVoyageNumber,
  FldLogsVoyageSrceStage,
  FldLogsVoyageDestStage,
  PackagingMaterial,
  HandlingUnitQuantity,
  HandlingUnitQuantityUnit,
  OutboundDelivery,
  OutboundDeliveryItem,
  MaintenanceOrder,
  Reservation,
  ReservationItem,
  FldLogsRefurbishmentOrder,
  reservation AS FldLogsRefrbmtOrderReservation,
  reservationitem AS FldLogsRefrbmtOrderResvnItem,
  InboundDelivery,
  InboundDeliveryItem,
  FldLogsSuplrItemUUID,
  FldLogsSuplrItemVislInspCode,
  FldLogsSrceStorLocID,
  FldLogsDestStorLocID,
  cast ( warehousetask as /scwm/tanum_conv_alpha preserving type ) AS WarehouseTask,
  DeliveryDocument,
  DeliveryDocumentItem,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  PurchasingDocumentItem,
  FldLogsItemActualDispatchPlant,
  FldLogsItmActualReceivingPlant,
  MaterialDocumentYear,
  MaterialDocumentItem,
  OrderCategory,
  FldLogsRcvdItmIsAcctAssgd,
  FldLogsGdsIssMatlDocument
FROM flog_rcvd_huitm
;