C_GR_CACustTrialBalCube

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_GR_CACustTrialBalCube.
-- 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_FiscalYear : fis_gjahr

CREATE VIEW C_GR_CACustTrialBalCube AS
SELECT
  DOC.GLAccount AS GLAccount,
  DOC.FiscalYear AS FiscalYear,
  DOC.CompanyCode AS CompanyCode,
  DOC.CADocumentNumber AS CADocumentNumber,
  DOC.CARepetitionItemNumber AS CARepetitionItemNumber,
  DOC.CABPItemNumber AS CABPItemNumber,
  DOC.CASubItemNumber AS CASubItemNumber,
  DOC.BusinessPartner AS BusinessPartner,
  DOC.CompanyCodeCurrency AS CompanyCodeCurrency,
  DOC.TransactionCurrency AS TransactionCurrency,
  Log.StatryRptgEntity AS StatryRptgEntity,
  Log.StatryRptCategory AS StatryRptCategory,
  Log.StatryRptRunID AS StatryRptRunID,
  cast( '0' as farp_belnr_d ) AS AccountingDocument,
  DOC.FiscalPeriod AS FiscalPeriod,
  DOC.PostingDate AS PostingDate,
  DOC.DocumentDate AS DocumentDate,
  DOC.BusinessPartnerName AS BusinessPartnerName,
  DOC.VATRegistration AS VATRegistration,
  DOC.BPTaxNumber AS BPTaxNumber,
  DOC.ChartOfAccounts AS ChartOfAccounts,
  DOC.DebitCreditCode AS DebitCreditCode,
  DOC.CreatedByUser AS CreatedByUser,
  DOC.PostingKey AS PostingKey,
  DOC.FinancialAccountType AS FinancialAccountType,
  DOC.CAReferenceDocument AS CAReferenceDocument,
  DOC.BusinessPartnerCountry AS BusinessPartnerCountry,
  DOC.GLAccountLongName AS GLAccountLongName,
  DOC.CarryFwdBalAmtInCCCrcy AS CarryFwdBalAmtInCCCrcy,
  DOC.DebitCarryFwdBalAmtInCCCrcy AS DebitCarryFwdBalAmtInCCCrcy,
  DOC.CreditCarryFwdBalAmtInCCCrcy AS CreditCarryFwdBalAmtInCCCrcy,
  DOC.PrevPeriodYTDAmtInCCCrcy AS PrevPeriodYTDAmtInCCCrcy,
  DOC.DebitPrevPeriodYTDAmtInCCCrcy AS DebitPrevPeriodYTDAmtInCCCrcy,
  DOC.CreditPrevPeriodYTDAmtInCCCrcy AS CreditPrevPeriodYTDAmtInCCCrcy,
  DOC.StartingBalanceAmtInCoCodeCrcy AS StartingBalanceAmtInCoCodeCrcy,
  DOC.DebitStartingBalAmtInCCCrcy AS DebitStartingBalAmtInCCCrcy,
  DOC.CreditStartingBalAmtInCCCrcy AS CreditStartingBalAmtInCCCrcy,
  DOC.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  DOC.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  DOC.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  DOC.EndingBalanceAmtInCoCodeCrcy AS EndingBalanceAmtInCoCodeCrcy,
  DOC.DebitEndingBalAmtInCCCrcy AS DebitEndingBalAmtInCCCrcy,
  DOC.CreditEndingBalAmtInCCCrcy AS CreditEndingBalAmtInCCCrcy,
  DOC.YTDAmtInLoclCrcy AS YTDAmtInLoclCrcy,
  DOC.YTDDebitAmtInCoCodeCrcy AS YTDDebitAmtInCoCodeCrcy,
  DOC.YTDCrdtAmtInCoCodeCrcy AS YTDCrdtAmtInCoCodeCrcy,
  DOC.CarryFwdBalanceAmtInTransCrcy AS CarryFwdBalanceAmtInTransCrcy,
  DOC.DebitCarryFwdBalAmtInTransCrcy AS DebitCarryFwdBalAmtInTransCrcy,
  DOC.CrdtCarryFwdBalAmtInTransCrcy AS CrdtCarryFwdBalAmtInTransCrcy,
  DOC.PrevPerdYTDAmountInTransCrcy AS PrevPerdYTDAmountInTransCrcy,
  DOC.DebitPrevPerdYTDAmtInTransCrcy AS DebitPrevPerdYTDAmtInTransCrcy,
  DOC.CrdtPrevPerdYTDAmtInTransCrcy AS CrdtPrevPerdYTDAmtInTransCrcy,
  DOC.StartingBalanceAmtInTransCrcy AS StartingBalanceAmtInTransCrcy,
  DOC.DebitStartingBalAmtInTransCrcy AS DebitStartingBalAmtInTransCrcy,
  DOC.CrdtStartingBalAmtInTransCrcy AS CrdtStartingBalAmtInTransCrcy,
  DOC.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  DOC.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
  DOC.CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
  DOC.EndingBalanceAmtInTransCrcy AS EndingBalanceAmtInTransCrcy,
  DOC.DebitEndingBalAmtInTransCrcy AS DebitEndingBalAmtInTransCrcy,
  DOC.CreditEndingBalAmtInTransCrcy AS CreditEndingBalAmtInTransCrcy,
  DOC.YrToDteAmtInTransacCrcy AS YrToDteAmtInTransacCrcy,
  DOC.YTDDebitAmtInTransCrcy AS YTDDebitAmtInTransCrcy,
  DOC.YTDCrdtAmtInTransCrcy AS YTDCrdtAmtInTransCrcy
FROM I_CACustTrialBalItem
INNER JOIN I_CAStRpDocItmJournalLog AS Log ON /* join condition not captured in parsed metadata */
;