P_Productstoragelocationref

DDL: P_PRODUCTSTORAGELOCATIONREF SQL: PPRDSTORAGEREF Type: view BASIC Package: VDM_MD_PRODUCT
7 Fields 2 Data Sources 1 Associations

Storage location for references

P_Productstoragelocationref is a Basic CDS View that provides data about "Storage location for references" in SAP S/4HANA. It reads from 2 data sources (P_PlantReferences, I_ProductStorageLocationBasic) and exposes 7 fields with key fields Product, Plant, StorageLocation. It has 1 association to related views. Part of development package VDM_MD_PRODUCT.

Data Sources (2)

SourceAliasJoin Type
P_PlantReferences Reference left_outer
I_ProductStorageLocationBasic StorageLocation from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Product _Product $projection.Product = _Product.Product

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPRDSTORAGEREF view
VDM.private true view
VDM.viewType #BASIC view
Search.searchable true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Product I_ProductStorageLocationBasic Product Product Sold
KEY Plant I_ProductStorageLocationBasic Plant Valuation Area
KEY StorageLocation I_ProductStorageLocationBasic StorageLocation StorageLocation
PlantCategory P_PlantReferences PlantCategory Plant cat.
ReferenceDistributionCenter P_PlantReferences ReferenceDistributionCenter Ref. distr. ctr
ReferenceStore P_PlantReferences ReferenceStore Reference Store
_Product _Product

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 P_Productstoragelocationref.
-- 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: PPRDSTORAGEREF

CREATE VIEW P_Productstoragelocationref AS
SELECT
  StorageLocation.Product AS Product,
  StorageLocation.Plant AS Plant,
  StorageLocation.StorageLocation AS StorageLocation,
  Reference.PlantCategory AS PlantCategory,
  Reference.ReferenceDistributionCenter AS ReferenceDistributionCenter,
  Reference.ReferenceStore AS ReferenceStore
FROM I_ProductStorageLocationBasic AS StorageLocation
LEFT OUTER JOIN P_PlantReferences AS Reference ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
;

Learn More