P_SourcesOfSupplyTypeAgg

DDL: P_SOURCESOFSUPPLYTYPEAGG SQL: PSOSTYPEAGG Type: view COMPOSITE Package: VDM_MM_PUR_SOS
10 Fields 1 Data Sources

Aggregation of sources of supply on type level

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

Data Sources (1)

SourceAliasJoin Type
P_SourcesOfSupply P_SourcesOfSupply from

Annotations (8)

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

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier Supplier
KEY Plant Plant Valuation Area
KEY PurchasingOrganization PurchasingOrganization Purchasing Organization
KEY Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
MaterialName MaterialName Material Description
PurchasingSourceType PurchasingSourceType
SourceOfSupplyIsFixed
SourceOfSupplyIsBlocked
QuotaArrangementIsFixed

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_SourcesOfSupplyTypeAgg.
-- 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: PSOSTYPEAGG

CREATE VIEW P_SourcesOfSupplyTypeAgg AS
SELECT
  Supplier,
  Plant,
  PurchasingOrganization,
  Material,
  MaterialGroup,
  MaterialName,
  PurchasingSourceType,
  sum( SourceOfSupplyIsFixed) AS SourceOfSupplyIsFixed,
  sum( SourceOfSupplyIsBlocked) AS SourceOfSupplyIsBlocked,
  sum( QuotaArrangementIsFixed) AS QuotaArrangementIsFixed
FROM P_SourcesOfSupply
;

Learn More