P_CN_FiapSuplrBalance04

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_CN_FiapSuplrBalance04.
-- 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: PCNFIAPSBBAL4
-- Parameters: P_CompanyCode : bukrs, P_FiscalYear : gjahr, P_CurrencyRole : fac_crcyrole, P_Language : sylangu, P_AlternativeGLAccount : fiarcn_dsp_alter

CREATE VIEW P_CN_FiapSuplrBalance04 AS
SELECT
  CompanyCode,
  FiscalYear,
  FiscalPeriod,
  cast(concat(FiscalYear,concat( '.', substring(FiscalPeriod,2,2))) as fiscalyearperiod ) AS FiscalYearPeriod,
  GLAccount,
  AlternativeGLAccount,
  Customer,
  Supplier,
  _Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  SpecialGLCode,
  BusinessArea,
  ProfitCenter,
  Segment,
  AccountingDocumentType,
  DisplayCurrency,
  TransactionCurrency,
  AssignmentReference,
  _Supplier.SupplierName AS SupplierName,
  _Supplier.BPSupplierName AS BPSupplierName,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _Supplier.TaxNumber5 AS SupplierVATRegistration,
  _Supplier._AddressRepresentation.Country AS SupplierCountry,
  _Supplier._AddressRepresentation.CityName AS SupplierCityName,
  _Supplier._AddressRepresentation.Region AS SupplierRegion,
  _Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _Supplier._SupplierToBusinessPartner._BusinessPartner.SearchTerm1 AS SupplierSearchText,
  _Supplier._SupplierCompany[CompanyCode = $parameters.P_CompanyCode].IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  case $parameters.P_AlternativeGLAccount when 'X' then _AlternativeGLAccountText.GLAccountName else _AccountText[1:Language = :P_Language].GLAccountName end as GLAccountName AS GLAccountNameendasGLAccountName,
  GLAccount AS SuplrBalGLAccountInfo,
  AlternativeGLAccount AS SuplrBalAltvGLAccountInfo,
  BalCarFwdAmtInDspCrcy,
  DebitAmountInDspCrcy,
  -CreditAmountInDspCrcy AS CreditAmountInDspCrcy,
  YTDDebitAmtInDspCrcy,
  -YTDCrdtAmtInDspCrcy AS YTDCrdtAmtInDspCrcy,
  StartingBalAmtInDspCrcy,
  EndingBalAmtInDspCrcy,
  BalCarFwdAmtInTransacCrcy,
  DebitAmountInTransCrcy,
  -CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
  DebitAmountInTransCrcy + CreditAmountInTransCrcy AS AmountInTransactionCurrency,
  YTDDebitAmtInTransCrcy,
  -YTDCrdtAmtInTransCrcy AS YTDCrdtAmtInTransCrcy,
  YTDDebitAmtInTransCrcy + YTDCrdtAmtInTransCrcy AS YrToDteAmtInTransacCrcy,
  StartingBalanceAmtInTransCrcy,
  EndingBalanceAmtInTransCrcy
FROM P_CN_FiapSuplrBalance03
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount  -- association [1..1]
LEFT OUTER JOIN C_CN_FsclPerdVH AS _FiscalPeriodValueHelp ON CompanyCode = _FiscalPeriodValueHelp.CompanyCode AND FiscalYear = _FiscalPeriodValueHelp.FiscalYear AND FiscalPeriod = _FiscalPeriodValueHelp.FiscalPeriod  -- association [1..1]
LEFT OUTER JOIN C_CN_CrcyVH AS _CurrencyValueHelp ON CompanyCode = _CurrencyValueHelp.CompanyCode  -- association [0..*]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _AccountText ON CompanyCode = _AccountText.CompanyCode AND GLAccount = _AccountText.GLAccount  -- association [1..1]
LEFT OUTER JOIN P_CN_AlternativeGLAccountText AS _AlternativeGLAccountText ON CompanyCode = _AlternativeGLAccountText.CompanyCode AND AlternativeGLAccount = _AlternativeGLAccountText.GLAccount AND _AlternativeGLAccountText.Language = $session.system_language  -- association [1..1]
;