C_CN_CustBalance

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_CustBalance.
-- 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: CCNCUSTBALANCE
-- Parameters: P_CompanyCode : bukrs, P_FiscalYear : gjahr, P_Language : sylangu, P_KeyDate : sydate, P_CurrencyRole : fac_crcyrole, P_AlternativeGLAccount : fiarcn_dsp_alter

CREATE VIEW C_CN_CustBalance AS
SELECT
  CompanyCode,
  FiscalYear,
  FiscalPeriod,
  FiscalYearPeriod,
  Customer,
  BusinessPartner,
  Supplier,
  GLAccount,
  AlternativeGLAccount,
  SpecialGLCode,
  BusinessArea,
  ProfitCenter,
  Segment,
  AccountingDocumentType,
  DisplayCurrency,
  TransactionCurrency,
  AssignmentReference,
  cast('' as fis_prctr_hryid_42) AS ProfitCenterHierarchy,
  cast('' as fis_prctr_hrynid_50) AS ProfitCenterHierarchyNode,
  CustomerAccountGroup,
  CustomerSearchText,
  CustomerVATRegistration,
  CustomerCountry,
  CustomerCityName,
  CustomerRegion,
  CustomerName,
  BPCustomerName,
  OrganizationBPName1,
  OrganizationBPName2,
  BusinessPartnerName,
  GLAccountName,
  AlternativeGLAccountName,
  CustBalSupplierInfo,
  CustBalBusinessPartnerInfo,
  case when Supplier = '' then CustBalCustomerInfo else cast('' as abap.char(90)) end as CustBalCustomerInfo AS char90endasCustBalCustomerInfo,
  cast( FsclPerdHasAcctgDocPostings as fiarcn_has_postg ) AS FsclPerdHasAcctgDocPostings,
  cast( CustBalCarryFwdAmtInDspCrcy as fiarcn_cfd_dsp ) AS CustBalCarryFwdAmtInDspCrcy,
  cast( CustBalDebitAmtInDspCrcy as fiarcn_dr_dsp ) AS CustBalDebitAmtInDspCrcy,
  cast( CustBalCreditAmtInDspCrcy as fiarcn_cr_dsp) AS CustBalCreditAmtInDspCrcy,
  cast( (CustBalDebitAmtInDspCrcy - CustBalCreditAmtInDspCrcy) as fiarcn_cur_bal_dsp ) AS AmountInCompanyCodeCurrency,
  cast( CustBalYTDDebitAmtInDspCrcy as fiarcn_ytd_dr_dsp) AS CustBalYTDDebitAmtInDspCrcy,
  cast( CustBalYTDCrdtAmtInDspCrcy as fiarcn_ytd_cr_dsp) AS CustBalYTDCrdtAmtInDspCrcy,
  cast( (CustBalYTDDebitAmtInDspCrcy - CustBalYTDCrdtAmtInDspCrcy) as fiarcn_cur_year_bal_dsp) AS YTDAmtInLoclCrcy,
  cast( CustBalStartingBalAmtInDspCrcy as fiarcn_start_bal_dsp) AS CustBalStartingBalAmtInDspCrcy,
  cast( CustBalEndingBalAmtInDspCrcy as fiarcn_end_bal_dsp) AS CustBalEndingBalAmtInDspCrcy,
  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
FROM P_Fiarcn_Cust_Balance
;