I_FldLogsStockTP

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_FldLogsStockTP.
-- 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_FldLogsStockTP AS
SELECT
  Material,
  FldLogsRemotePlant,
  FldLogsReferenceDocumentNumber,
  ReferenceDocumentItem,
  FldLogsMaintenanceOrder,
  RemoteStorageLocation,
  cast( concat ( concat ( Material, FldLogsRemotePlant ) ,concat ( concat ( FldLogsReferenceDocumentNumber, ReferenceDocumentItem ), concat ( FldLogsMaintenanceOrder, RemoteStorageLocation ) ) ) as char90 ) AS ChangeDocObject,
  FldLogsReferenceDocCategory,
  FldLogsReturnStatus,
  RetblQtyInBaseUnit,
  RetblQtyBaseUnit,
  RetblQtyInOrderUnit,
  RetblQtyOrderUnit,
  LoadingQtyInOrderUnit,
  DispatchedStartDate,
  SupplyingStorageLocation,
  RequestedShippingDate,
  RequestedShippingTime,
  ReturnRecordCreationDateTime,
  ReturnRecordChangeDateTime,
  _NetStock.FieldLogisticsTransferPlant AS FieldLogisticsTransferPlant,
  FldLogsSupplyProcess,
  ReferenceOrder,
  ReferencePurchasingDocument,
  FldLogsContainerID,
  FldLogsContainerID AS FldLogsTranspContainerID,
  InventoryUsabilityCode,
  FldLogsItemType,
  _SupplierItem.FldLogsSuplrItmPackggTypeCode AS FldLogsSuplrItmPackggTypeCode,
  Batch,
  ValuationType,
  SerialNumber,
  MaterialMinSftyStockQuantity,
  FldLogsRecommendedAction,
  cast( 0 as int1 preserving type ) AS FldLogsRetTrggrStsCriticality,
  cast( OutboundDelivery as outbound_delivery) AS OutboundDelivery,
  OutboundDeliveryItem,
  cast('' as exidv ) AS EWMMovingHandlingUnitNumber,
  IsInternalBatchManaged,
  FldLogsSuplrItemUUID,
  FldLogsContainerUUID,
  FldLogsShptItemUUID,
  FldLogsContainerUnitUUID,
  FieldLogisticsStorageBin,
  FldLogsTransferType,
  _RetComments.FldLogsReturnComment AS FldLogsReturnComment,
  _RetComments.FldLogsReturnLongComment AS FldLogsReturnLongComment,
  _ReservationQty.QuantityUnit AS QuantityUnit,
  ( _ReservationQty.ResvnItmTotalRequiredQty - _ReservationQty.ResvnItmTotalWithdrawnQty ) AS ResvnItmTotalRequiredQty,
  _ReservationQty.ResvnItmTotalWithdrawnQty AS ResvnItmTotalWithdrawnQty,
  _SupplyingPlant.SupplierPlant AS SupplyingPlant,
  IsMarkedForDeletion,
  FldLogsRefurbishmentOrder,
  PurchaseOrderItem,
  cast(lpad(FldLogsReferenceDocumentNumber,20,'0') as char20) AS ReferenceDocumentLongNumber,
  EWMWarehouse,
  InboundDelivery,
  InboundDeliveryItem,
  MaterialDocument,
  MaterialDocumentItem,
  cast('' as exidv ) AS HandlingUnitExternalID,
  cast('' as ps_s4_posid) AS WBSElementExternalID,
  Reservation,
  ReservationItem,
  _StorageBin.WarehouseStorageBin AS WarehouseStorageBin,
  FldLogsVoyageDestStage,
  OrderOperation,
  BillOfMaterialItemNumber,
  OrderCategory,
  _SupplierItem.FldLogsReferenceObjectType AS FldLogsReferenceObjectType,
  _SupplierItem.FldLogsReferenceObjectNumber AS FldLogsReferenceObjectNumber,
  _ReservationQty._BaseUnitOfMaterial AS _BaseUnitOfMaterial
FROM I_NetReturnStock AS _NetStock
LEFT OUTER JOIN I_FldLogsSupplyProcessText AS _SprocText ON FldLogsSupplyProcess = _SprocText.FldLogsSupplyProcess  -- association [0..*]
LEFT OUTER JOIN I_FldLogsMaterialText AS _MatText ON Material = _MatText.Material AND FldLogsSuplrItemUUID = _MatText.FldLogsSuplrItemUUID  -- association [0..1]
LEFT OUTER JOIN I_FldLogsReturnStatusT AS _RetStatText ON FldLogsReturnStatus = _RetStatText.FldLogsReturnStatus  -- association [0..*]
LEFT OUTER JOIN I_RecommendedActionText AS _ActionText ON FldLogsRecommendedAction = _ActionText.FldLogsRecommendedAction  -- association [0..*]
LEFT OUTER JOIN I_FldLogsReturnComment AS _RetComments ON Material = _RetComments.Material AND FldLogsRemotePlant = _RetComments.FldLogsRemotePlant AND FldLogsReferenceDocumentNumber = _RetComments.FldLogsReferenceDocumentNumber AND ReferenceDocumentItem = _RetComments.ReferenceDocumentItem AND FldLogsMaintenanceOrder = _RetComments.FldLogsMaintenanceOrder AND RemoteStorageLocation = _RetComments.RemoteStorageLocation  -- association [0..1]
LEFT OUTER JOIN I_FldLogsRefDocTypeT AS _RefDocTypeText ON FldLogsReferenceDocCategory = _RefDocTypeText.FldLogsReferenceDocCategory  -- association [0..1]
LEFT OUTER JOIN I_FldLogsProdResvnQuantityCalc AS _ReservationQty ON Material = _ReservationQty.Material AND FldLogsRemotePlant = _ReservationQty.FldLogsRemotePlant AND FldLogsReferenceDocumentNumber = _ReservationQty.FldLogsReferenceDocumentNumber AND RemoteStorageLocation = _ReservationQty.RemoteStorageLocation AND FldLogsMaintenanceOrder = _ReservationQty.FldLogsMaintenanceOrder AND ReferenceDocumentItem = _ReservationQty.ReferenceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_FldLogsSuplrItmPackggTypeT AS _SuplrItmPackggTypeT ON FldLogsSuplrItmPackggTypeCode = _SuplrItmPackggTypeT.FldLogsSuplrItmPackggTypeCode  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _PlantText ON FldLogsRemotePlant = _PlantText.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _DestinationPlantText ON FieldLogisticsTransferPlant = _DestinationPlantText.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _RemoteStorageLocationText ON RemoteStorageLocation = _RemoteStorageLocationText.StorageLocation AND FldLogsRemotePlant = _RemoteStorageLocationText.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _SupplyingStorageLocationText ON SupplyingStorageLocation = _SupplyingStorageLocationText.StorageLocation AND FieldLogisticsTransferPlant = _SupplyingStorageLocationText.Plant  -- association [0..1]
LEFT OUTER JOIN I_FldLogsSupplierItem AS _SupplierItem ON FldLogsSuplrItemUUID = _SupplierItem.FldLogsSuplrItemUUID  -- association [0..1]
LEFT OUTER JOIN E_FieldLogisticsReturns AS _ReturnsExtension ON Material = _ReturnsExtension.Material AND FldLogsRemotePlant = _ReturnsExtension.FldLogsRemotePlant AND FldLogsReferenceDocumentNumber = _ReturnsExtension.FldLogsReferenceDocumentNumber AND ReferenceDocumentItem = _ReturnsExtension.ReferenceDocumentItem AND FldLogsMaintenanceOrder = _ReturnsExtension.FldLogsMaintenanceOrder AND RemoteStorageLocation = _ReturnsExtension.RemoteStorageLocation  -- association [1..1]
LEFT OUTER JOIN I_FldLogsRetStockTypeText AS _StockTypeText ON InventoryUsabilityCode = _StockTypeText.InventoryUsabilityCode  -- association [0..*]
LEFT OUTER JOIN I_FieldLogisticsStorageBin AS _StorageBin ON Material = _StorageBin.Material AND FldLogsRemotePlant = _StorageBin.Plant AND RemoteStorageLocation = _StorageBin.StorageLocation  -- association [1..1]
LEFT OUTER JOIN I_OrderCategoryText AS _OrderCategoryText ON OrderCategory = _OrderCategoryText.OrderCategory  -- association [0..*]
LEFT OUTER JOIN I_IntlgntEquipRetRulesRsltFnl AS _RulesFinal ON Material = _RulesFinal.Material AND FldLogsRemotePlant = _RulesFinal.FldLogsRemotePlant AND FldLogsReferenceDocumentNumber = _RulesFinal.FldLogsReferenceDocumentNumber AND ReferenceDocumentItem = _RulesFinal.ReferenceDocumentItem AND FldLogsMaintenanceOrder = _RulesFinal.FldLogsMaintenanceOrder AND RemoteStorageLocation = _RulesFinal.RemoteStorageLocation AND _RulesFinal.FldLogsIntlgntEquipRetStatus = ' '  -- association [0..1]
LEFT OUTER JOIN I_FldLogsRefObjTypeBasic AS _RefObjTypeDesc ON FldLogsReferenceObjectType = _RefObjTypeDesc.FldLogsReferenceObjectType AND _RefObjTypeDesc.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN R_FldLogsSerialItemsTP AS _SerialNo ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_FldLogsReturnsHandlingUnitTP AS _HandlingUnit ON /* condition not available in parsed metadata */  -- association [1..*]
;