I_PL_SAFTGenLdgrAcctBalCube

DDL: I_PL_SAFTGENLDGRACCTBALCUBE Type: view_entity COMPOSITE
40 Fields 1 Data Sources

SAFT PL KR General Ledger - Cube

I_PL_SAFTGenLdgrAcctBalCube is a Composite CDS View (Cube) that provides data about "SAFT PL KR General Ledger - Cube" in SAP S/4HANA. It reads from 1 data source (I_StRpTrialBalanceItemCube) and exposes 40 fields with key fields Ledger, CompanyCode, FiscalYear, SourceLedger, AccountingDocument.

Data Sources (1)

SourceAliasJoin Type
I_StRpTrialBalanceItemCube I_StRpTrialBalanceItemCube from

Parameters (5)

NameTypeDefault
P_FromPostingDate fis_budat_from
P_ToPostingDate fis_budat_to
P_FromFiscalPeriod fis_period_from
P_ToFiscalPeriod fis_period_to
P_PL_IndicatorIsTrueOrFalse fipl_consider_vendor_customer

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #CUBE view
EndUserText.label SAFT PL KR General Ledger - Cube view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.allowExtensions true view
Analytics.internalName #LOCAL view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY Ledger I_StRpTrialBalanceItemCube Ledger Ledger
KEY CompanyCode I_StRpTrialBalanceItemCube CompanyCode Receiver Company Code
KEY FiscalYear I_StRpTrialBalanceItemCube FiscalYear G/L Fiscal Year
KEY SourceLedger I_StRpTrialBalanceItemCube SourceLedger Source Ledger
KEY AccountingDocument I_StRpTrialBalanceItemCube AccountingDocument Journal Entry
KEY LedgerGLLineItem I_StRpTrialBalanceItemCube LedgerGLLineItem Journal Entry Item
KEY StatryRptCategory I_StRpTrialBalanceItemCube StatryRptCategory Report ID
KEY StatryRptgEntity I_StRpTrialBalanceItemCube StatryRptgEntity Reporting Entity
KEY StatryRptRunID I_StRpTrialBalanceItemCube StatryRptRunID Report Run ID
PostingDate I_StRpTrialBalanceItemCube PostingDate Posting Date for GR
DocumentDate I_StRpTrialBalanceItemCube DocumentDate Journal Entry Date
GLAccount I_StRpTrialBalanceItemCube GLAccount General Ledger
GLAccountLongName I_StRpTrialBalanceItemCube GLAccountLongName Long Text
GLAccountType
GLAccountGroup
AccountGroupNameendasAccountGroupName
CompanyCodeCurrency I_StRpTrialBalanceItemCube CompanyCodeCurrency Local Currency
StartingBalanceAmtInCoCodeCrcy I_StRpTrialBalanceItemCube StartingBalanceAmtInCoCodeCrcy
DebitStartingBalAmtInCCCrcy I_StRpTrialBalanceItemCube DebitStartingBalAmtInCCCrcy
CreditStartingBalAmtInCCCrcy I_StRpTrialBalanceItemCube CreditStartingBalAmtInCCCrcy
AmountInCompanyCodeCurrency I_StRpTrialBalanceItemCube AmountInCompanyCodeCurrency Local Crcy Amt
DebitAmountInCoCodeCrcy I_StRpTrialBalanceItemCube DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy I_StRpTrialBalanceItemCube CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
EndingBalanceAmtInCoCodeCrcy I_StRpTrialBalanceItemCube EndingBalanceAmtInCoCodeCrcy
DebitEndingBalAmtInCCCrcy I_StRpTrialBalanceItemCube DebitEndingBalAmtInCCCrcy
CreditEndingBalAmtInCCCrcy I_StRpTrialBalanceItemCube CreditEndingBalAmtInCCCrcy
YTDDebitAmtInCoCodeCrcy I_StRpTrialBalanceItemCube YTDDebitAmtInCoCodeCrcy
YTDCrdtAmtInCoCodeCrcy I_StRpTrialBalanceItemCube YTDCrdtAmtInCoCodeCrcy
ReconciliationAccountType I_StRpTrialBalanceItemCube ReconciliationAccountType Reconcil. ID
AlternativeGLAccount I_StRpTrialBalanceItemCube AlternativeGLAccount Group Account
PL_IndicatorIsCustomerSupplier
Customer I_StRpTrialBalanceItemCube Customer Sold-to Party
Supplier I_StRpTrialBalanceItemCube Supplier Supplier
CustomerName
SupplierName
ChartOfAccounts I_StRpTrialBalanceItemCube ChartOfAccounts Node Class
FinancialAccountType I_StRpTrialBalanceItemCube FinancialAccountType Fin. Account Type
_CompanyCode I_StRpTrialBalanceItemCube _CompanyCode
_Customer I_StRpTrialBalanceItemCube _Customer
_Supplier I_StRpTrialBalanceItemCube _Supplier

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 I_PL_SAFTGenLdgrAcctBalCube.
-- 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_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_FromFiscalPeriod : fis_period_from, P_ToFiscalPeriod : fis_period_to, P_PL_IndicatorIsTrueOrFalse : fipl_consider_vendor_customer

CREATE VIEW I_PL_SAFTGenLdgrAcctBalCube AS
SELECT
  I_StRpTrialBalanceItemCube.Ledger AS Ledger,
  I_StRpTrialBalanceItemCube.CompanyCode AS CompanyCode,
  I_StRpTrialBalanceItemCube.FiscalYear AS FiscalYear,
  I_StRpTrialBalanceItemCube.SourceLedger AS SourceLedger,
  I_StRpTrialBalanceItemCube.AccountingDocument AS AccountingDocument,
  I_StRpTrialBalanceItemCube.LedgerGLLineItem AS LedgerGLLineItem,
  I_StRpTrialBalanceItemCube.StatryRptCategory AS StatryRptCategory,
  I_StRpTrialBalanceItemCube.StatryRptgEntity AS StatryRptgEntity,
  I_StRpTrialBalanceItemCube.StatryRptRunID AS StatryRptRunID,
  I_StRpTrialBalanceItemCube.PostingDate AS PostingDate,
  I_StRpTrialBalanceItemCube.DocumentDate AS DocumentDate,
  I_StRpTrialBalanceItemCube.GLAccount AS GLAccount,
  I_StRpTrialBalanceItemCube.GLAccountLongName AS GLAccountLongName,
  I_StRpTrialBalanceItemCube._GLAccountInChartOfAccounts.GLAccountType AS GLAccountType,
  I_StRpTrialBalanceItemCube._GLAccountInChartOfAccounts.GLAccountGroup AS GLAccountGroup,
  case when I_StRpTrialBalanceItemCube._GLAccountInChartOfAccounts._GLAccountGroupText[1: Language = $session.system_language].AccountGroupName is initial or I_StRpTrialBalanceItemCube._GLAccountInChartOfAccounts._GLAccountGroupText[1: Language = $session.system_language].AccountGroupName is null then 'Nie dotyczy' else I_StRpTrialBalanceItemCube._GLAccountInChartOfAccounts._GLAccountGroupText[1: Language = $session.system_language].AccountGroupName end as AccountGroupName AS AccountGroupNameendasAccountGroupName,
  I_StRpTrialBalanceItemCube.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_StRpTrialBalanceItemCube.StartingBalanceAmtInCoCodeCrcy AS StartingBalanceAmtInCoCodeCrcy,
  I_StRpTrialBalanceItemCube.DebitStartingBalAmtInCCCrcy AS DebitStartingBalAmtInCCCrcy,
  I_StRpTrialBalanceItemCube.CreditStartingBalAmtInCCCrcy AS CreditStartingBalAmtInCCCrcy,
  I_StRpTrialBalanceItemCube.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_StRpTrialBalanceItemCube.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  I_StRpTrialBalanceItemCube.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  I_StRpTrialBalanceItemCube.EndingBalanceAmtInCoCodeCrcy AS EndingBalanceAmtInCoCodeCrcy,
  I_StRpTrialBalanceItemCube.DebitEndingBalAmtInCCCrcy AS DebitEndingBalAmtInCCCrcy,
  I_StRpTrialBalanceItemCube.CreditEndingBalAmtInCCCrcy AS CreditEndingBalAmtInCCCrcy,
  I_StRpTrialBalanceItemCube.YTDDebitAmtInCoCodeCrcy AS YTDDebitAmtInCoCodeCrcy,
  I_StRpTrialBalanceItemCube.YTDCrdtAmtInCoCodeCrcy AS YTDCrdtAmtInCoCodeCrcy,
  I_StRpTrialBalanceItemCube.ReconciliationAccountType AS ReconciliationAccountType,
  I_StRpTrialBalanceItemCube.AlternativeGLAccount AS AlternativeGLAccount,
  $parameters.P_PL_IndicatorIsTrueOrFalse AS PL_IndicatorIsCustomerSupplier,
  I_StRpTrialBalanceItemCube.Customer AS Customer,
  I_StRpTrialBalanceItemCube.Supplier AS Supplier,
  I_StRpTrialBalanceItemCube._Customer.CustomerName AS CustomerName,
  I_StRpTrialBalanceItemCube._Supplier.SupplierName AS SupplierName,
  I_StRpTrialBalanceItemCube.ChartOfAccounts AS ChartOfAccounts,
  I_StRpTrialBalanceItemCube.FinancialAccountType AS FinancialAccountType,
  I_StRpTrialBalanceItemCube._CompanyCode AS _CompanyCode,
  I_StRpTrialBalanceItemCube._Customer AS _Customer,
  I_StRpTrialBalanceItemCube._Supplier AS _Supplier
FROM I_StRpTrialBalanceItemCube
;

Learn More