I_NetReturnStock

DDL: I_NETRETURNSTOCK SQL: INETRETSTOCK Type: view COMPOSITE Package: FLOG_RETURN
54 Fields 1 Data Sources 3 Associations

FL - Net Stock Calculation at Remote

I_NetReturnStock is a Composite CDS View that provides data about "FL - Net Stock Calculation at Remote" in SAP S/4HANA. It reads from 1 data source (I_AllReturnStock) and exposes 54 fields with key fields Material, FldLogsRemotePlant, FldLogsReferenceDocumentNumber, ReferenceDocumentItem, FldLogsMaintenanceOrder. It has 3 associations to related views. Part of development package FLOG_RETURN.

Data Sources (1)

SourceAliasJoin Type
I_AllReturnStock I_AllReturnStock from

Associations (3)

CardinalityTargetAliasCondition
[0..1] P_ProductPlantBasic _SafetyStock $projection.Material = _SafetyStock.Product and $projection.FldLogsRemotePlant = _SafetyStock.Plant
[0..1] I_FldLogsUserPlant _SupplyingPlant $projection.FldLogsRemotePlant = _SupplyingPlant.FldLogsRemotePlant
[1..1] E_FieldLogisticsReturns _ReturnsExtension $projection.Material = _ReturnsExtension.Material and $projection.FldLogsRemotePlant = _ReturnsExtension.FldLogsRemotePlant and $projection.FldLogsReferenceDocumentNumber = _ReturnsExtension.FldLogsReferenceDocumentNumber and $projection.ReferenceDocumentItem = _ReturnsExtension.ReferenceDocumentItem and $projection.FldLogsMaintenanceOrder = _ReturnsExtension.FldLogsMaintenanceOrder and $projection.RemoteStorageLocation = _ReturnsExtension.RemoteStorageLocation

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName INETRETSTOCK view
AbapCatalog.compiler.compareFilter true view
EndUserText.label FL - Net Stock Calculation at Remote view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY FldLogsRemotePlant FldLogsRemotePlant Plant
KEY FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber Reference Doc Number
KEY ReferenceDocumentItem ReferenceDocumentItem Reference item
KEY FldLogsMaintenanceOrder FldLogsMaintenanceOrder
KEY RemoteStorageLocation RemoteStorageLocation
FldLogsReferenceDocCategory FldLogsReferenceDocCategory Ref. Document Type
EWMWarehouse EWMWarehouse Warehouse No.
FldLogsReturnStatus FldLogsReturnStatus
RetblQtyBaseUnit RetblQtyBaseUnit
RetblQtyInOrderUnit RetblQtyInOrderUnit
RetblQtyOrderUnit RetblQtyOrderUnit
LoadingQtyInOrderUnit LoadingQtyInOrderUnit
DispatchedStartDate DispatchedStartDate Dispatch Date
SupplyingStorageLocation SupplyingStorageLocation Location
RequestedShippingDate RequestedShippingDate
RequestedShippingTime RequestedShippingTime
FldLogsRecommendedAction FldLogsRecommendedAction Recommended Action
FldLogsSupplyProcess I_AllReturnStock FldLogsSupplyProcess Supply Process
ReferenceOrder ReferenceOrder Reference Order
ReferencePurchasingDocument ReferencePurchasingDocument Purchasing Doc.
FldLogsContainerID FldLogsContainerID Container ID
InventoryUsabilityCode InventoryUsabilityCode Stock Type
FldLogsItemType FldLogsItemType
ReturnRecordCreationDateTime ReturnRecordCreationDateTime
ReturnRecordChangeDateTime ReturnRecordChangeDateTime
FieldLogisticsTransferPlant FieldLogisticsTransferPlant Plant
Batch Batch Lot No.
ValuationType ValuationType Valuation Type
SerialNumber SerialNumber Serial Number
FldLogsSuplrItemUUID FldLogsSuplrItemUUID Suplr Item UUID
FldLogsContainerUUID FldLogsContainerUUID Container UUID
FldLogsContainerUnitUUID FldLogsContainerUnitUUID Container Unit ID
FldLogsShptItemUUID FldLogsShptItemUUID Shipment Item ID
FldLogsRetOutbDelivIsCreated FldLogsRetOutbDelivIsCreated Checkbox
FieldLogisticsStorageBin FieldLogisticsStorageBin Storage Bin
FldLogsTransferType FldLogsTransferType Transfer Type
MaterialMinSftyStockQuantity _SafetyStock MinimumSafetyStockQuantity Min. Saf. Stock
IsInternalBatchManaged _SafetyStock IsInternalBatchManaged Batches
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
OutboundDelivery OutboundDelivery LE Delivery
OutboundDeliveryItem OutboundDeliveryItem Logistics Execution Delivery Item
FldLogsRefurbishmentOrder FldLogsRefurbishmentOrder Order
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
InboundDelivery InboundDelivery LE Delivery
InboundDeliveryItem InboundDeliveryItem Item
MaterialDocument MaterialDocument Material Doc.
MaterialDocumentItem MaterialDocumentItem Material Document Item
Reservation Reservation Reservation
ReservationItem ReservationItem Reservation Item
FldLogsVoyageDestStage FldLogsVoyageDestStage Destination Stage
OrderOperation OrderOperation Operation or Phase
BillOfMaterialItemNumber BillOfMaterialItemNumber Item
_SupplyingPlant _SupplyingPlant

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_NetReturnStock.
-- 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.
-- SQL view name: INETRETSTOCK

CREATE VIEW I_NetReturnStock AS
SELECT
  Material,
  FldLogsRemotePlant,
  FldLogsReferenceDocumentNumber,
  ReferenceDocumentItem,
  FldLogsMaintenanceOrder,
  RemoteStorageLocation,
  FldLogsReferenceDocCategory,
  EWMWarehouse,
  FldLogsReturnStatus,
  RetblQtyBaseUnit,
  RetblQtyInOrderUnit,
  RetblQtyOrderUnit,
  LoadingQtyInOrderUnit,
  DispatchedStartDate,
  SupplyingStorageLocation,
  RequestedShippingDate,
  RequestedShippingTime,
  FldLogsRecommendedAction,
  I_AllReturnStock.FldLogsSupplyProcess AS FldLogsSupplyProcess,
  ReferenceOrder,
  ReferencePurchasingDocument,
  FldLogsContainerID,
  InventoryUsabilityCode,
  FldLogsItemType,
  ReturnRecordCreationDateTime,
  ReturnRecordChangeDateTime,
  FieldLogisticsTransferPlant,
  Batch,
  ValuationType,
  SerialNumber,
  FldLogsSuplrItemUUID,
  FldLogsContainerUUID,
  FldLogsContainerUnitUUID,
  FldLogsShptItemUUID,
  FldLogsRetOutbDelivIsCreated,
  FieldLogisticsStorageBin,
  FldLogsTransferType,
  _SafetyStock.MinimumSafetyStockQuantity AS MaterialMinSftyStockQuantity,
  _SafetyStock.IsInternalBatchManaged AS IsInternalBatchManaged,
  IsMarkedForDeletion,
  OutboundDelivery,
  OutboundDeliveryItem,
  FldLogsRefurbishmentOrder,
  PurchaseOrderItem,
  InboundDelivery,
  InboundDeliveryItem,
  MaterialDocument,
  MaterialDocumentItem,
  Reservation,
  ReservationItem,
  FldLogsVoyageDestStage,
  OrderOperation,
  BillOfMaterialItemNumber
FROM I_AllReturnStock
LEFT OUTER JOIN P_ProductPlantBasic AS _SafetyStock ON Material = _SafetyStock.Product AND FldLogsRemotePlant = _SafetyStock.Plant  -- association [0..1]
LEFT OUTER JOIN I_FldLogsUserPlant AS _SupplyingPlant ON FldLogsRemotePlant = _SupplyingPlant.FldLogsRemotePlant  -- 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]
;

Learn More