C_PT_BOPCustSuplrBalanceC

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_PT_BOPCustSuplrBalanceC.
-- 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.

CREATE VIEW C_PT_BOPCustSuplrBalanceC AS
SELECT
  item.CompanyCode AS CompanyCode,
  item.AccountingDocument AS AccountingDocument,
  item.FiscalYear AS FiscalYear,
  item.AccountingDocumentItem AS AccountingDocumentItem,
  _ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  _ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  _ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  item.Postingdate AS PostingDate,
  item.ClearingDate AS ClearingDate,
  item.FinancialAccountType AS FinancialAccountType,
  item.GLAccount AS GLAccount,
  item.ClearingJournalEntry AS ClearingJournalEntry,
  item.Customer AS Customer,
  item.Supplier AS Supplier,
  item.BusinessPartner AS BusinessPartner,
  item.VATRegistration AS VATRegistration,
  item.VATRegistrationCountry AS VATRegistrationCountry,
  item.BPCountry AS BusinessPartnerCountry,
  cast(Country.CountryThreeLetterISOCode as fiappt_pais_contraparte ) AS PT_BOPCtptyCountryISOCode,
  item.DebitCreditCode AS DebitCreditCode,
  item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  item.TransactionCurrency AS TransactionCurrency,
  item.CurrencyISOCode AS CurrencyISOCode,
  item.PT_BOPAcctBalDebitClsfctn AS PT_BOPAcctBalDebitClsfctn,
  item.PT_BOPAcctBalCreditClsfctn AS PT_BOPAcctBalCreditClsfctn,
  item.PT_BOPValueType AS PT_BOPValueType,
  item.PT_BOPAccountType AS PT_BOPAccountType,
  item. ReviewComment AS ReviewComment,
  item.AccountingDocumentCategory AS AccountingDocumentCategory,
  item.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  item.AccountingDocumentType AS AccountingDocumentType,
  item.SpecialGLCode AS SpecialGLCode,
  item.PostingKey AS PostingKey,
  item.DocumentDate AS DocumentDate,
  item.FinancialTransactionType AS FinancialTransactionType,
  item.SupplierCountry AS SupplierCountry,
  item.CustomerCountry AS CustomerCountry,
  item.SupplierVATRegistration AS SupplierVATRegistration,
  item.CustomerVATRegistration AS CustomerVATRegistration
FROM P_PT_BOPCustSuplrCountry AS item
LEFT OUTER JOIN I_StRpJournalEntryLog AS _ReportedItemsLog ON CompanyCode = _ReportedItemsLog.CompanyCode AND AccountingDocument = _ReportedItemsLog.AccountingDocument AND FiscalYear = _ReportedItemsLog.FiscalYear  -- association [0..*]
;