P_RU_BPBalance1

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

CREATE VIEW P_RU_BPBalance1 AS
SELECT
  cast( P_RU_BPBalance0.Ledger as fis_rldnr ) AS Ledger,
  cast( P_RU_BPBalance0.CompanyCode as fis_bukrs ) AS CompanyCode,
  cast( P_RU_BPBalance0.FiscalYear as fis_gjahr) AS FiscalYear,
  P_RU_BPBalance0.AccountingDocument AS AccountingDocument,
  P_RU_BPBalance0.AssignmentReference AS AssignmentReference,
  P_RU_BPBalance0.Supplier AS Supplier,
  P_RU_BPBalance0.Customer AS Customer,
  P_RU_BPBalance0.FinancialAccountType AS FinancialAccountType,
  P_RU_BPBalance0.AccountingDocumentType AS AccountingDocumentType,
  P_RU_BPBalance0.PostingDate AS PostingDate,
  P_RU_BPBalance0.DocumentDate AS DocumentDate,
  P_RU_BPBalance0.IsReversal AS IsReversal,
  P_RU_BPBalance0.IsReversed AS IsReversed,
  P_RU_BPBalance0.TransactionCurrency AS TransactionCurrency,
  P_RU_BPBalance0.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_RU_BPBalance0.SupplierFinsAuthorizationGrp AS SupplierFinsAuthorizationGrp,
  P_RU_BPBalance0.SupplierAccountGroup AS SupplierAccountGroup,
  P_RU_BPBalance0.SupplierCompanyAuthznGroup AS SupplierCompanyAuthznGroup,
  P_RU_BPBalance0.CustomerFinsAuthorizationGrp AS CustomerFinsAuthorizationGrp,
  P_RU_BPBalance0.CustomerAccountGroup AS CustomerAccountGroup,
  P_RU_BPBalance0.CustomerCompanyAuthznGroup AS CustomerCompanyAuthznGroup,
  sum( P_RU_BPBalance0.AmountInTransactionCurrency ) AS AmountInTransactionCurrency,
  sum( P_RU_BPBalance0.AmountInCompanyCodeCurrency ) AS AmountInCompanyCodeCurrency,
  sum( P_RU_BPBalance0.DebitAmountInCoCodeCrcy ) AS DebitAmountInCoCodeCrcy,
  sum( P_RU_BPBalance0.CreditAmountInCoCodeCrcy ) AS CreditAmountInCoCodeCrcy,
  sum( P_RU_BPBalance0.DebitAmountInTransCrcy ) AS DebitAmountInTransCrcy,
  sum( P_RU_BPBalance0.CreditAmountInTransCrcy ) AS CreditAmountInTransCrcy,
  sum( P_RU_BPBalance0.EndingBalanceAmtInCoCodeCrcy ) AS EndingBalanceAmtInCoCodeCrcy,
  sum( P_RU_BPBalance0.EndingBalanceAmtInTransCrcy ) AS EndingBalanceAmtInTransCrcy,
  sum( P_RU_BPBalance0.StartingBalanceAmtInCoCodeCrcy ) AS StartingBalanceAmtInCoCodeCrcy,
  sum( P_RU_BPBalance0.StartingBalanceAmtInTransCrcy ) AS StartingBalanceAmtInTransCrcy
FROM P_RU_BPBalance0
INNER JOIN I_Ledger ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON Customer = _BusinessPartnerCustomer.Customer  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartnerSupplier AS _BusinessPartnerSupplier ON Supplier = _BusinessPartnerSupplier.Supplier  -- association [0..*]
;