P_CN_FinancialStatementVersion

DDL: P_CN_FINANCIALSTATEMENTVERSION Type: view CONSUMPTION Package: GLO_FIN_CN
12 Fields 1 Data Sources

Financial Statement Version for China

P_CN_FinancialStatementVersion is a Consumption CDS View that provides data about "Financial Statement Version for China" in SAP S/4HANA. It reads from 1 data source (I_FinancialStatementHier) and exposes 12 fields with key field FinancialStatementVariant. Part of development package GLO_FIN_CN.

Data Sources (1)

SourceAliasJoin Type
I_FinancialStatementHier I_FinancialStatementHier from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PCNFSVERSION view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.representativeKey FinancialStatementVariant view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Financial Statement Version for China view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY FinancialStatementVariant FinancialStatementHierarchy Hierarchy ID
MaintenanceLanguage
ChartOfAccounts ChartOfAccounts Node Class
GroupChartOfAccountIsUsed GroupChartOfAccountIsUsed
FunctionalAreaIsUsed FunctionalAreaIsUsed
FinStmntAssetItem FinancialStatementAssetsItem
FinStmntLiabilityItem FinStatementLiabilitiesItem
NotAssgdAccountNode FinancialStatementOrphansItem
FinancialStatementNetLossItem FinancialStatementNetLossItem
FinStatementNetProfitItem FinStatementNetProfitItem
FinStatementProfitAndLossItem FinStatementProfitAndLossItem
FinancialStatementNotesItem FinancialStatementNotesItem

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_CN_FinancialStatementVersion.
-- 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.

CREATE VIEW P_CN_FinancialStatementVersion AS
SELECT
  FinancialStatementHierarchy AS FinancialStatementVariant,
  _Text[1:Language=$session.system_language].Language AS MaintenanceLanguage,
  ChartOfAccounts,
  GroupChartOfAccountIsUsed,
  FunctionalAreaIsUsed,
  FinancialStatementAssetsItem AS FinStmntAssetItem,
  FinStatementLiabilitiesItem AS FinStmntLiabilityItem,
  FinancialStatementOrphansItem AS NotAssgdAccountNode,
  FinancialStatementNetLossItem,
  FinStatementNetProfitItem,
  FinStatementProfitAndLossItem,
  FinancialStatementNotesItem
FROM I_FinancialStatementHier
;

Learn More