P_GLACCTBALWITHCOMPRNPERIODLG

DDL: P_GLACCTBALWITHCOMPRNPERIODLG Type: view_entity COMPOSITE
56 Fields 2 Data Sources

P_GLACCTBALWITHCOMPRNPERIODLG is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_StRpJournalEntryLog, P_GLAcctBalWithComprnPeriod) and exposes 56 fields with key fields Ledger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

Data Sources (2)

SourceAliasJoin Type
I_StRpJournalEntryLog _StRpJournalEntryLog inner
P_GLAcctBalWithComprnPeriod P_GLAcctBalWithComprnPeriod from

Parameters (9)

NameTypeDefault
P_Ledger fis_rldnr
P_StartPostingDate fis_budat
P_EndPostingDate fis_budat
P_ComprnFromPostingDate fis_budat
P_ComprnToPostingDate fis_budat
P_ComparisonFromPostingDate2 fis_budat
P_ComparisonToPostingDate2 fis_budat
P_CurrencyRole fis_curtp
P_AlternativeGLAccountIsUsed char1

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY Ledger _GLAcctBalWithComprnPeriod Ledger Ledger
KEY CompanyCode _GLAcctBalWithComprnPeriod CompanyCode Receiver Company Code
KEY FiscalYear _GLAcctBalWithComprnPeriod FiscalYear G/L Fiscal Year
KEY AccountingDocument _GLAcctBalWithComprnPeriod AccountingDocument Journal Entry
KEY LedgerGLLineItem _GLAcctBalWithComprnPeriod LedgerGLLineItem Journal Entry Item
KEY StatryRptgEntity I_StRpJournalEntryLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpJournalEntryLog StatryRptCategory Report ID
KEY StatryRptRunID I_StRpJournalEntryLog StatryRptRunID Report Run ID
GLAccountInfo _GLAcctBalWithComprnPeriod GLAccountInfo
FinancialStatementLeafItem _GLAcctBalWithComprnPeriod FinancialStatementLeafItem Node
LedgerFiscalYear _GLAcctBalWithComprnPeriod LedgerFiscalYear
ChartOfAccounts _GLAcctBalWithComprnPeriod ChartOfAccounts Node Class
AccountingDocumentType _GLAcctBalWithComprnPeriod AccountingDocumentType Journal Entry Type
GLAccount _GLAcctBalWithComprnPeriod GLAccount General Ledger
CountryChartOfAccounts _GLAcctBalWithComprnPeriod CountryChartOfAccounts Chart of Accts
AlternativeGLAccount _GLAcctBalWithComprnPeriod AlternativeGLAccount Group Account
GLAccountExternal _GLAcctBalWithComprnPeriod GLAccountExternal G/L Acct External ID
ControllingArea _GLAcctBalWithComprnPeriod ControllingArea Controlling Area
CostCenter _GLAcctBalWithComprnPeriod CostCenter Cost Center
ProfitCenter _GLAcctBalWithComprnPeriod ProfitCenter Profit Center
FinancialTransactionType _GLAcctBalWithComprnPeriod FinancialTransactionType Transact. Type
FunctionalArea _GLAcctBalWithComprnPeriod FunctionalArea Sendr Fctl Area
BusinessArea _GLAcctBalWithComprnPeriod BusinessArea Business Area
Segment _GLAcctBalWithComprnPeriod Segment Segment number
DebitCreditCode _GLAcctBalWithComprnPeriod DebitCreditCode Single-Character Flag
PostingDate _GLAcctBalWithComprnPeriod PostingDate Posting Date for GR
FiscalPeriod _GLAcctBalWithComprnPeriod FiscalPeriod Tax period
PartnerCompany _GLAcctBalWithComprnPeriod PartnerCompany Trading Partner
WBSElement _GLAcctBalWithComprnPeriod WBSElement WBS Internal ID
GLAccountType _GLAcctBalWithComprnPeriod GLAccountType G/L Account Type
ReportingPeriod _GLAcctBalWithComprnPeriod ReportingPeriod Single-Character Flag
PeriodFlag _GLAcctBalWithComprnPeriod PeriodFlag
Currency _GLAcctBalWithComprnPeriod Currency Valuation Crcy
DebitPeriodBalAmtInDspCrcy _GLAcctBalWithComprnPeriod DebitPeriodBalAmtInDspCrcy
CreditPeriodBalAmtInDspCrcy _GLAcctBalWithComprnPeriod CreditPeriodBalAmtInDspCrcy
PeriodBalAmtInDspCrcy _GLAcctBalWithComprnPeriod PeriodBalAmtInDspCrcy
YearOpeningBalAmtInDspCrcy _GLAcctBalWithComprnPeriod YearOpeningBalAmtInDspCrcy
OpeningPeriodBalAmtInDspCrcy _GLAcctBalWithComprnPeriod OpeningPeriodBalAmtInDspCrcy
EndingPeriodBalAmtInDspCrcy _GLAcctBalWithComprnPeriod EndingPeriodBalAmtInDspCrcy
_FinancialStatementLeafItem _GLAcctBalWithComprnPeriod _FinancialStatementLeafItem
_Ledger _GLAcctBalWithComprnPeriod _Ledger
_CompanyCode _GLAcctBalWithComprnPeriod _CompanyCode
_FiscalYear _GLAcctBalWithComprnPeriod _FiscalYear
_LedgerFiscalYear _GLAcctBalWithComprnPeriod _LedgerFiscalYear
_ChartOfAccounts _GLAcctBalWithComprnPeriod _ChartOfAccounts
_AccountingDocumentType _GLAcctBalWithComprnPeriod _AccountingDocumentType
_GLAccountInChartOfAccounts _GLAcctBalWithComprnPeriod _GLAccountInChartOfAccounts
_GLAccountInCompanyCode _GLAcctBalWithComprnPeriod _GLAccountInCompanyCode
_GLAccountExternal _GLAcctBalWithComprnPeriod _GLAccountExternal
_ControllingArea _GLAcctBalWithComprnPeriod _ControllingArea
_Segment _GLAcctBalWithComprnPeriod _Segment
_ProfitCenter _GLAcctBalWithComprnPeriod _ProfitCenter
_FinancialTransactionType _GLAcctBalWithComprnPeriod _FinancialTransactionType
_CostCenter _GLAcctBalWithComprnPeriod _CostCenter
_BusinessArea _GLAcctBalWithComprnPeriod _BusinessArea
_FunctionalArea _GLAcctBalWithComprnPeriod _FunctionalArea

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_GLACCTBALWITHCOMPRNPERIODLG.
-- 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.
-- Parameters: P_Ledger : fis_rldnr, P_StartPostingDate : fis_budat, P_EndPostingDate : fis_budat, P_ComprnFromPostingDate : fis_budat, P_ComprnToPostingDate : fis_budat, P_ComparisonFromPostingDate2 : fis_budat, P_ComparisonToPostingDate2 : fis_budat, P_CurrencyRole : fis_curtp, P_AlternativeGLAccountIsUsed : char1

CREATE VIEW P_GLACCTBALWITHCOMPRNPERIODLG AS
SELECT
  _GLAcctBalWithComprnPeriod.Ledger AS Ledger,
  _GLAcctBalWithComprnPeriod.CompanyCode AS CompanyCode,
  _GLAcctBalWithComprnPeriod.FiscalYear AS FiscalYear,
  _GLAcctBalWithComprnPeriod.AccountingDocument AS AccountingDocument,
  _GLAcctBalWithComprnPeriod.LedgerGLLineItem AS LedgerGLLineItem,
  _StRpJournalEntryLog.StatryRptgEntity AS StatryRptgEntity,
  _StRpJournalEntryLog.StatryRptCategory AS StatryRptCategory,
  _StRpJournalEntryLog.StatryRptRunID AS StatryRptRunID,
  _GLAcctBalWithComprnPeriod.GLAccountInfo AS GLAccountInfo,
  _GLAcctBalWithComprnPeriod.FinancialStatementLeafItem AS FinancialStatementLeafItem,
  _GLAcctBalWithComprnPeriod.LedgerFiscalYear AS LedgerFiscalYear,
  _GLAcctBalWithComprnPeriod.ChartOfAccounts AS ChartOfAccounts,
  _GLAcctBalWithComprnPeriod.AccountingDocumentType AS AccountingDocumentType,
  _GLAcctBalWithComprnPeriod.GLAccount AS GLAccount,
  _GLAcctBalWithComprnPeriod.CountryChartOfAccounts AS CountryChartOfAccounts,
  _GLAcctBalWithComprnPeriod.AlternativeGLAccount AS AlternativeGLAccount,
  _GLAcctBalWithComprnPeriod.GLAccountExternal AS GLAccountExternal,
  _GLAcctBalWithComprnPeriod.ControllingArea AS ControllingArea,
  _GLAcctBalWithComprnPeriod.CostCenter AS CostCenter,
  _GLAcctBalWithComprnPeriod.ProfitCenter AS ProfitCenter,
  _GLAcctBalWithComprnPeriod.FinancialTransactionType AS FinancialTransactionType,
  _GLAcctBalWithComprnPeriod.FunctionalArea AS FunctionalArea,
  _GLAcctBalWithComprnPeriod.BusinessArea AS BusinessArea,
  _GLAcctBalWithComprnPeriod.Segment AS Segment,
  _GLAcctBalWithComprnPeriod.DebitCreditCode AS DebitCreditCode,
  _GLAcctBalWithComprnPeriod.PostingDate AS PostingDate,
  _GLAcctBalWithComprnPeriod.FiscalPeriod AS FiscalPeriod,
  _GLAcctBalWithComprnPeriod.PartnerCompany AS PartnerCompany,
  _GLAcctBalWithComprnPeriod.WBSElement AS WBSElement,
  _GLAcctBalWithComprnPeriod.GLAccountType AS GLAccountType,
  _GLAcctBalWithComprnPeriod.ReportingPeriod AS ReportingPeriod,
  _GLAcctBalWithComprnPeriod.PeriodFlag AS PeriodFlag,
  _GLAcctBalWithComprnPeriod.Currency AS Currency,
  _GLAcctBalWithComprnPeriod.DebitPeriodBalAmtInDspCrcy AS DebitPeriodBalAmtInDspCrcy,
  _GLAcctBalWithComprnPeriod.CreditPeriodBalAmtInDspCrcy AS CreditPeriodBalAmtInDspCrcy,
  _GLAcctBalWithComprnPeriod.PeriodBalAmtInDspCrcy AS PeriodBalAmtInDspCrcy,
  _GLAcctBalWithComprnPeriod.YearOpeningBalAmtInDspCrcy AS YearOpeningBalAmtInDspCrcy,
  _GLAcctBalWithComprnPeriod.OpeningPeriodBalAmtInDspCrcy AS OpeningPeriodBalAmtInDspCrcy,
  _GLAcctBalWithComprnPeriod.EndingPeriodBalAmtInDspCrcy AS EndingPeriodBalAmtInDspCrcy,
  _GLAcctBalWithComprnPeriod._FinancialStatementLeafItem AS _FinancialStatementLeafItem,
  _GLAcctBalWithComprnPeriod._Ledger AS _Ledger,
  _GLAcctBalWithComprnPeriod._CompanyCode AS _CompanyCode,
  _GLAcctBalWithComprnPeriod._FiscalYear AS _FiscalYear,
  _GLAcctBalWithComprnPeriod._LedgerFiscalYear AS _LedgerFiscalYear,
  _GLAcctBalWithComprnPeriod._ChartOfAccounts AS _ChartOfAccounts,
  _GLAcctBalWithComprnPeriod._AccountingDocumentType AS _AccountingDocumentType,
  _GLAcctBalWithComprnPeriod._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  _GLAcctBalWithComprnPeriod._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  _GLAcctBalWithComprnPeriod._GLAccountExternal AS _GLAccountExternal,
  _GLAcctBalWithComprnPeriod._ControllingArea AS _ControllingArea,
  _GLAcctBalWithComprnPeriod._Segment AS _Segment,
  _GLAcctBalWithComprnPeriod._ProfitCenter AS _ProfitCenter,
  _GLAcctBalWithComprnPeriod._FinancialTransactionType AS _FinancialTransactionType,
  _GLAcctBalWithComprnPeriod._CostCenter AS _CostCenter,
  _GLAcctBalWithComprnPeriod._BusinessArea AS _BusinessArea,
  _GLAcctBalWithComprnPeriod._FunctionalArea AS _FunctionalArea
FROM P_GLAcctBalWithComprnPeriod
INNER JOIN I_StRpJournalEntryLog AS _StRpJournalEntryLog ON /* join condition not captured in parsed metadata */
;

Learn More