C_QM_PrftCtrVH

DDL: C_QM_PRFTCTRVH SQL: CQMPRFTCTRVH Type: view CONSUMPTION
5 Fields

Value-Help for Profit Center

C_QM_PrftCtrVH is a Consumption CDS View that provides data about "Value-Help for Profit Center" in SAP S/4HANA.

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CQMPRFTCTRVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Value-Help for Profit Center view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
Search.searchable true view
ObjectModel.representativeKey ProfitCenter view
VDM.viewType #CONSUMPTION view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ProfitCenter I_ProfitCenter ProfitCenter Profit Center
KEY ControllingArea ControllingArea Controlling Area
KEY ValidityEndDate ValidityEndDate ValidTo
ProfitCenterName
CompanyCode CompanyCode Receiver Company Code

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_QM_PrftCtrVH.
-- 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: CQMPRFTCTRVH

CREATE VIEW C_QM_PrftCtrVH AS
SELECT
  I_ProfitCenter.ProfitCenter AS ProfitCenter,
  ControllingArea,
  ValidityEndDate,
  _Text[1:Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  CompanyCode
;

Learn More