C_CN_SupplierBalance

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_CN_SupplierBalance.
-- 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: CCNSUPLRBAL
-- Parameters: P_CompanyCode : bukrs, P_FiscalYear : gjahr, P_Language : sylangu, P_KeyDate : sydate, P_CurrencyRole : fac_crcyrole, P_AlternativeGLAccount : fiapcn_display_altvglaccount

CREATE VIEW C_CN_SupplierBalance AS
SELECT
  CompanyCode,
  FiscalYear,
  FiscalPeriod,
  FiscalYearPeriod,
  Customer,
  BusinessPartner,
  BPSupplierName,
  Supplier AS SuplrBalSupplierInfo,
  GLAccount,
  GLAccountName,
  SpecialGLCode,
  BusinessArea,
  ProfitCenter,
  cast('' as fis_prctr_hryid_42) AS ProfitCenterHierarchy,
  cast('' as fis_prctr_hrynid_50) AS ProfitCenterHierarchyNode,
  Segment,
  AccountingDocumentType,
  cast ( DisplayCurrency as vdm_v_display_currency ) AS DisplayCurrency,
  TransactionCurrency,
  SupplierAccountGroup,
  SupplierVATRegistration,
  SupplierCountry,
  SupplierCityName,
  SupplierRegion,
  SupplierSearchText,
  _Supplier.SupplierName AS SupplierName,
  BusinessPartnerName,
  AssignmentReference,
  cast( BalCarFwdAmtInDspCrcy as fiarcn_cfd_dsp ) AS SuplrBalCarryFwdAmtInDspCrcy,
  cast( DebitAmountInDspCrcy as fiarcn_dr_dsp) AS SuplrBalDebitAmtInDspCrcy,
  cast( CreditAmountInDspCrcy as fiarcn_cr_dsp ) AS SuplrBalCreditAmtInDspCrcy,
  cast( DebitAmountInDspCrcy - CreditAmountInDspCrcy as fiarcn_cur_bal_dsp ) AS AmountInCompanyCodeCurrency,
  cast( YTDDebitAmtInDspCrcy as fiarcn_ytd_dr_dsp ) AS SuplrBalYTDDebitAmtInDspCrcy,
  cast( YTDCrdtAmtInDspCrcy as fiarcn_ytd_cr_dsp ) AS SuplrBalYTDCrdtAmtInDspCrcy,
  cast( YTDDebitAmtInDspCrcy - YTDCrdtAmtInDspCrcy as fiarcn_cur_year_bal_dsp ) AS YTDAmtInLoclCrcy,
  cast( StartingBalAmtInDspCrcy as fiarcn_start_bal_dsp) AS StartingBalAmtInDspCrcy,
  cast( EndingBalAmtInDspCrcy as fiarcn_end_bal_dsp) AS EndingBalAmtInDspCrcy,
  cast( BalCarFwdAmtInTransacCrcy as fiarcn_begin_bal_wsl ) AS BalCarFwdAmtInTransacCrcy,
  cast( DebitAmountInTransCrcy as fiarcn_dr_wsl ) AS DebitAmountInTransCrcy,
  cast( CreditAmountInTransCrcy as fiarcn_cr_wsl ) AS CreditAmountInTransCrcy,
  cast( DebitAmountInTransCrcy - CreditAmountInTransCrcy as fiarcn_cur_bal_wsl ) AS AmountInTransactionCurrency,
  cast( YTDDebitAmtInTransCrcy as fiarcn_ytd_dr_wsl ) AS YTDDebitAmtInTransCrcy,
  cast( YTDCrdtAmtInTransCrcy as fiarcn_ytd_cr_wsl ) AS YTDCrdtAmtInTransCrcy,
  cast( YTDDebitAmtInTransCrcy - YTDCrdtAmtInTransCrcy as fiarcn_cur_year_bal_wsl ) AS YrToDteAmtInTransacCrcy,
  cast( StartingBalanceAmtInTransCrcy as fiarcn_start_bal_wsl) AS StartingBalanceAmtInTransCrcy,
  cast( EndingBalanceAmtInTransCrcy as fiarcn_end_bal_wsl) AS EndingBalanceAmtInTransCrcy,
  _Supplier.DataControllerSet AS DataControllerSet,
  _Supplier.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM P_CN_FiapSuplrBalance04
;