What is C_SalesView_FS in SAP S/4HANA?

C_SalesView_FS is a consumption CDS view in SAP S/4HANA. Consumption Factsheet - sales view facet It contains 14 fields.

Which tables does C_SalesView_FS read from?

C_SalesView_FS reads data from: P_Salesview_Fs.

What VDM layer is C_SalesView_FS?

C_SalesView_FS is classified as a Consumption view optimized for specific business scenarios and reporting.

C_SalesView_FS

DDL: C_SALESVIEW_FS SQL: CSALESVIEW Type: view CONSUMPTION

14 Fields 1 Data Sources 1 Associations

Consumption Factsheet - sales view facet

C_SalesView_FS is a Consumption CDS View that provides data about "Consumption Factsheet - sales view facet" in SAP S/4HANA. It reads from 1 data source (P_Salesview_Fs) and exposes 14 fields with key fields Product, ValuationArea, ValuationType. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
P_Salesview_Fs	SalesView	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	C_Product_Fs	_Product	`$projection.Product = _Product.Material`

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	CSALESVIEW	view
AbapCatalog.compiler.compareFilter	true	view
EndUserText.label	Consumption Factsheet - sales view facet	view
VDM.viewType	#CONSUMPTION	view
UI.headerInfo.typeName	Sales	view
UI.headerInfo.typeNamePlural	Saless	view
UI.headerInfo.title.value	Product	view
UI.headerInfo.title.label	Material	view
UI.headerInfo.typeImageUrl		view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.dataClass	#MASTER	view
Search.searchable	true	view
AccessControl.authorizationCheck	#CHECK	view
VDM.lifecycle.status	#DEPRECATED	view

Fields (14)

Key	Field	Source Table	Source Field	Description
KEY	Product	P_Salesview_Fs	Product	Product Sold
KEY	ValuationArea	P_Salesview_Fs	ValuationArea	Valuation Area
KEY	ValuationType	P_Salesview_Fs	ValuationType	Valuation Type
	MovingAveragePrice	P_Salesview_Fs	MovingAveragePrice	Per. Unit Price
	PriceUnitQty	P_Salesview_Fs	PriceUnitQty	Price unit
	InventoryValuationProcedure	P_Salesview_Fs	InventoryValuationProcedure	Price Control
	StandardPrice	P_Salesview_Fs	StandardPrice	Standard price
	CompanyCode	P_Salesview_Fs	CompanyCode	Receiver Company Code
	Currency	P_Salesview_Fs	Currency	Valuation Crcy
	Plant	P_Salesview_Fs	Plant	Valuation Area
	PlantName	P_Salesview_Fs	PlantName	Plant Name
	PriceControlText	P_Salesview_Fs	PriceControlText	Well Code Des.
	UnitOfMeasureLongName	P_Salesview_Fs	UnitOfMeasureLongName
	_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 C_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: CSALESVIEW

CREATE VIEW C_SalesView_FS AS
SELECT
  SalesView.Product AS Product,
  SalesView.ValuationArea AS ValuationArea,
  SalesView.ValuationType AS ValuationType,
  SalesView.MovingAveragePrice AS MovingAveragePrice,
  SalesView.PriceUnitQty AS PriceUnitQty,
  SalesView.InventoryValuationProcedure AS InventoryValuationProcedure,
  SalesView.StandardPrice AS StandardPrice,
  SalesView.CompanyCode AS CompanyCode,
  SalesView.Currency AS Currency,
  SalesView.Plant AS Plant,
  SalesView.PlantName AS PlantName,
  SalesView.PriceControlText AS PriceControlText,
  SalesView.UnitOfMeasureLongName AS UnitOfMeasureLongName
FROM P_Salesview_Fs AS SalesView
LEFT OUTER JOIN C_Product_Fs AS _Product ON Product = _Product.Material  -- association [1..1]
;

Depth:

C_SalesView_FS view

P_Salesview_Fs view