P_Salesview_Fs

DDL: P_SALESVIEW_FS SQL: PSALESVIEWFS Type: view COMPOSITE
13 Fields 8 Data Sources

P_Salesview_Fs is a Composite CDS View in SAP S/4HANA. It reads from 8 data sources and exposes 13 fields with key fields Product, ValuationArea, ValuationType.

Data Sources (8)

SourceAliasJoin Type
I_CompanyCode CCode left_outer
I_MaterialText MaterialText left_outer
P_PlantAddrDetails_Fs PlantData left_outer
I_Product PrdData left_outer
P_Matlpricecntrltext PriceControl left_outer
I_ProductValuation ProdVal from
I_UnitOfMeasureText UnitOfMeasureText left_outer
I_Purreqvaluationarea ValArea left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PSALESVIEWFS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Product I_ProductValuation Product Product Sold
KEY ValuationArea I_ProductValuation ValuationArea Valuation Area
KEY ValuationType I_ProductValuation ValuationType Valuation Type
MovingAveragePrice I_ProductValuation MovingAveragePrice Per. Unit Price
PriceUnitQty I_ProductValuation PriceUnitQty Price unit
InventoryValuationProcedure I_ProductValuation InventoryValuationProcedure Price Control
StandardPrice I_ProductValuation StandardPrice Standard price
CompanyCode I_Purreqvaluationarea CompanyCode Receiver Company Code
Currency I_CompanyCode Currency Valuation Crcy
Plant P_PlantAddrDetails_Fs Plant Valuation Area
PlantName P_PlantAddrDetails_Fs PlantName Plant Name
PriceControlText P_Matlpricecntrltext Description Well Code Des.
UnitOfMeasureLongName I_UnitOfMeasureText UnitOfMeasureLongName Meas. Unit Text

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_Salesview_Fs.
-- 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: PSALESVIEWFS

CREATE VIEW P_Salesview_Fs AS
SELECT
  ProdVal.Product AS Product,
  ProdVal.ValuationArea AS ValuationArea,
  ProdVal.ValuationType AS ValuationType,
  ProdVal.MovingAveragePrice AS MovingAveragePrice,
  ProdVal.PriceUnitQty AS PriceUnitQty,
  ProdVal.InventoryValuationProcedure AS InventoryValuationProcedure,
  ProdVal.StandardPrice AS StandardPrice,
  ValArea.CompanyCode AS CompanyCode,
  CCode.Currency AS Currency,
  PlantData.Plant AS Plant,
  PlantData.PlantName AS PlantName,
  PriceControl.Description AS PriceControlText,
  UnitOfMeasureText.UnitOfMeasureLongName AS UnitOfMeasureLongName
FROM I_ProductValuation AS ProdVal
LEFT OUTER JOIN I_Purreqvaluationarea AS ValArea ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Product AS PrdData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PlantAddrDetails_Fs AS PlantData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialText AS MaterialText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS CCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Matlpricecntrltext AS PriceControl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UnitOfMeasureText AS UnitOfMeasureText ON /* join condition not captured in parsed metadata */
;

Learn More