I_FldLogsStorLocation

DDL: I_FLDLOGSSTORLOCATION SQL: IFLSTORLOC Type: view COMPOSITE Package: FLOG_RETURN
6 Fields 3 Data Sources

Storage location

I_FldLogsStorLocation is a Composite CDS View that provides data about "Storage location" in SAP S/4HANA. It reads from 3 data sources (I_FieldLogisticsPlantAll, P_ProductStorageLocationBasic, I_StorageLocation) and exposes 6 fields with key fields StorageLocation, Plant, Material. Part of development package FLOG_RETURN.

Data Sources (3)

SourceAliasJoin Type
I_FieldLogisticsPlantAll _Plant from
P_ProductStorageLocationBasic _ProdStrLoc inner
I_StorageLocation _StorageLocation inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IFLSTORLOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Storage location 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

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY StorageLocation P_ProductStorageLocationBasic StorageLocation StorageLocation
KEY Plant P_ProductStorageLocationBasic Plant Valuation Area
KEY Material P_ProductStorageLocationBasic Product Product Sold
StorageLocationName I_StorageLocation StorageLocationName Storage Loc. Name
PlantName
WarehouseStorageBin P_ProductStorageLocationBasic WarehouseStorageBin Storage Bin

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_FldLogsStorLocation.
-- 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: IFLSTORLOC

CREATE VIEW I_FldLogsStorLocation AS
SELECT
  _ProdStrLoc.StorageLocation AS StorageLocation,
  _ProdStrLoc.Plant AS Plant,
  _ProdStrLoc.Product AS Material,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  _StorageLocation._Plant.PlantName AS PlantName,
  _ProdStrLoc.WarehouseStorageBin AS WarehouseStorageBin
FROM I_FieldLogisticsPlantAll AS _Plant
INNER JOIN P_ProductStorageLocationBasic AS _ProdStrLoc ON /* join condition not captured in parsed metadata */
INNER JOIN I_StorageLocation AS _StorageLocation ON /* join condition not captured in parsed metadata */
;

Learn More