P_SourcesOfSupplyMatchAgg

DDL: P_SOURCESOFSUPPLYMATCHAGG SQL: PSOSMATCHAGG Type: view COMPOSITE Package: VDM_MM_PUR_SOS
9 Fields 1 Data Sources

Agg. of sources of supply on supplier-material level

P_SourcesOfSupplyMatchAgg is a Composite CDS View that provides data about "Agg. of sources of supply on supplier-material level" in SAP S/4HANA. It reads from 1 data source (P_SourcesOfSupplyTypeAgg) and exposes 9 fields with key fields Supplier, Plant, PurchasingOrganization, Material. Part of development package VDM_MM_PUR_SOS.

Data Sources (1)

SourceAliasJoin Type
P_SourcesOfSupplyTypeAgg P_SourcesOfSupplyTypeAgg from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PSOSMATCHAGG view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier Supplier
KEY Plant Plant Valuation Area
KEY PurchasingOrganization PurchasingOrganization Purchasing Organization
KEY Material Material Vehicle Model
MaterialName MaterialName Material Description
SourceOfSupplyIsBlocked
SourceOfSupplyIsFixed
QuotaArrangementIsFixed
Relevance

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_SourcesOfSupplyMatchAgg.
-- 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: PSOSMATCHAGG

CREATE VIEW P_SourcesOfSupplyMatchAgg AS
SELECT
  Supplier,
  Plant,
  PurchasingOrganization,
  Material,
  MaterialName,
  sum (SourceOfSupplyIsBlocked) AS SourceOfSupplyIsBlocked,
  sum (SourceOfSupplyIsFixed) AS SourceOfSupplyIsFixed,
  sum (QuotaArrangementIsFixed) AS QuotaArrangementIsFixed,
  sum (Relevance) AS Relevance
FROM P_SourcesOfSupplyTypeAgg
;

Learn More