P_CN_GLAcctPerd

DDL: P_CN_GLACCTPERD SQL: PVCNGLAPERD Type: view CONSUMPTION
10 Fields 3 Data Sources

Cartesian Product of G/L Account and Fiscal Period

P_CN_GLAcctPerd is a Consumption CDS View that provides data about "Cartesian Product of G/L Account and Fiscal Period" in SAP S/4HANA. It reads from 3 data sources (I_GLAccountInChartOfAccounts, I_GLAccountInCompanyCode, I_FiscalCalYearPeriodForLedger) and exposes 10 fields with key fields CompanyCode, FiscalYear, FiscalPeriod, Ledger, GLAccount.

Data Sources (3)

SourceAliasJoin Type
I_GLAccountInChartOfAccounts ChartOfAccounts inner
I_GLAccountInCompanyCode GlAccount inner
I_FiscalCalYearPeriodForLedger Yearperiod from

Parameters (4)

NameTypeDefault
P_CompanyCode fis_bukrs
P_FiscalYear fis_gjahr
P_DisplayAltvAcct figlcn_disalteracct
P_Ledger fis_rldnr

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PVCNGLAPERD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #CONSUMPTION view
EndUserText.label Cartesian Product of G/L Account and Fiscal Period view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_FiscalCalYearPeriodForLedger CompanyCode Receiver Company Code
KEY FiscalYear I_FiscalCalYearPeriodForLedger FiscalYear G/L Fiscal Year
KEY FiscalPeriod I_FiscalCalYearPeriodForLedger FiscalPeriod Tax period
KEY Ledger I_FiscalCalYearPeriodForLedger Ledger Ledger
KEY GLAccount
AlternativeGLAccount I_GLAccountInCompanyCode AlternativeGLAccount Group Account
ChartOfAccounts I_GLAccountInChartOfAccounts ChartOfAccounts Node Class
GLAccountGroup I_GLAccountInChartOfAccounts GLAccountGroup Account Group
AccountIsMarkedForDeletion I_GLAccountInCompanyCode AccountIsMarkedForDeletion Deletion Flag
AuthorizationGroup AuthorizationGroup AuthorizGroup

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_GLAcctPerd.
-- 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: PVCNGLAPERD
-- Parameters: P_CompanyCode : fis_bukrs, P_FiscalYear : fis_gjahr, P_DisplayAltvAcct : figlcn_disalteracct, P_Ledger : fis_rldnr

CREATE VIEW P_CN_GLAcctPerd AS
SELECT
  Yearperiod.CompanyCode AS CompanyCode,
  Yearperiod.FiscalYear AS FiscalYear,
  Yearperiod.FiscalPeriod AS FiscalPeriod,
  Yearperiod.Ledger AS Ledger,
  GlAccount. GLAccount AS GLAccount,
  GlAccount.AlternativeGLAccount AS AlternativeGLAccount,
  ChartOfAccounts.ChartOfAccounts AS ChartOfAccounts,
  ChartOfAccounts.GLAccountGroup AS GLAccountGroup,
  GlAccount.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
  AuthorizationGroup
FROM I_FiscalCalYearPeriodForLedger AS Yearperiod
INNER JOIN I_GLAccountInCompanyCode AS GlAccount ON /* join condition not captured in parsed metadata */
INNER JOIN I_GLAccountInChartOfAccounts AS ChartOfAccounts ON /* join condition not captured in parsed metadata */
;

Learn More