P_RU_BPBalance0

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_RU_BPBalance0.
-- 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: PRUBPBAL0
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_IsReversal : flag, P_ReportingEntity : srf_reporting_entity

CREATE VIEW P_RU_BPBalance0 AS
SELECT
  I_GLAccountLineItem.Ledger AS Ledger,
  I_GLAccountLineItem.CompanyCode AS CompanyCode,
  I_GLAccountLineItem.FiscalYear AS FiscalYear,
  I_GLAccountLineItem.AccountingDocument AS AccountingDocument,
  I_GLAccountLineItem.LedgerGLLineItem AS LedgerGLLineItem,
  I_GLAccountLineItem.SourceLedger AS SourceLedger,
  I_GLAccountLineItem.LedgerFiscalYear AS LedgerFiscalYear,
  I_GLAccountLineItem.PostingDate AS PostingDate,
  I_GLAccountLineItem.DocumentDate AS DocumentDate,
  I_GLAccountLineItem.AssignmentReference AS AssignmentReference,
  I_GLAccountLineItem.AccountingDocumentCategory AS AccountingDocumentCategory,
  I_GLAccountLineItem.Supplier AS Supplier,
  I_GLAccountLineItem.Customer AS Customer,
  I_GLAccountLineItem._Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  I_GLAccountLineItem._Supplier.AuthorizationGroup AS SupplierFinsAuthorizationGrp,
  I_GLAccountLineItem._SupplierCompany.AuthorizationGroup AS SupplierCompanyAuthznGroup,
  I_GLAccountLineItem._Customer.CustomerAccountGroup AS CustomerAccountGroup,
  I_GLAccountLineItem._Customer.AuthorizationGroup AS CustomerFinsAuthorizationGrp,
  I_GLAccountLineItem._CustomerCompany.AuthorizationGroup AS CustomerCompanyAuthznGroup,
  I_GLAccountLineItem.FinancialAccountType AS FinancialAccountType,
  I_GLAccountLineItem.ClearingDate AS ClearingDate,
  I_GLAccountLineItem.ClearingAccountingDocument AS ClearingAccountingDocument,
  I_GLAccountLineItem.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  I_GLAccountLineItem.AccountingDocumentType AS AccountingDocumentType,
  I_GLAccountLineItem.IsReversal AS IsReversal,
  I_GLAccountLineItem.IsReversed AS IsReversed,
  I_GLAccountLineItem.TransactionCurrency AS TransactionCurrency,
  I_GLAccountLineItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GLAccountLineItem.DebitCreditCode AS DebitCreditCode,
  I_GLAccountLineItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  I_GLAccountLineItem.ReversalReferenceDocument AS ReversalReferenceDocument,
  I_GLAccountLineItem.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  cast( cast( AmountInCompanyCodeCurrency as abap.curr( 23,2) ) as fis_end_bal_hsl ) AS EndingBalanceAmtInCoCodeCrcy,
  cast( cast( AmountInTransactionCurrency as abap.curr( 23,2) ) as fis_end_bal_wsl ) AS EndingBalanceAmtInTransCrcy,
  $parameters.P_IsReversal AS SelectReversal
FROM I_GLAccountLineItem
;