P_PT_BOPCustSuplrCountry

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_PT_BOPCustSuplrCountry.
-- 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 P_PT_BOPCustSuplrCountry AS
SELECT
  item.CompanyCode AS CompanyCode,
  item.FiscalYear AS FiscalYear,
  item.AccountingDocument AS AccountingDocument,
  item.AccountingDocumentItem AS AccountingDocumentItem,
  item.FinancialAccountType AS FinancialAccountType,
  item.ClearingAccountingDocument AS ClearingAccountingDocument,
  item.ClearingJournalEntry AS ClearingJournalEntry,
  item.ClearingDate AS ClearingDate,
  item.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  item.AccountingDocumentType AS AccountingDocumentType,
  item.AccountingDocumentCategory AS AccountingDocumentCategory,
  item.SpecialGLCode AS SpecialGLCode,
  item.FinancialTransactionType AS FinancialTransactionType,
  item.Postingdate AS Postingdate,
  item.PostingKey AS PostingKey,
  item.DocumentDate AS DocumentDate,
  item.Customer AS Customer,
  item.Supplier AS Supplier,
  item.BusinessPartner AS BusinessPartner,
  item.PT_BOPValueType AS PT_BOPValueType,
  item.PT_BOPAccountType AS PT_BOPAccountType,
  item.PT_BOPAcctBalDebitClsfctn AS PT_BOPAcctBalDebitClsfctn,
  item.PT_BOPAcctBalCreditClsfctn AS PT_BOPAcctBalCreditClsfctn,
  item.DebitCreditCode AS DebitCreditCode,
  item.TransactionCurrency AS TransactionCurrency,
  item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  item.GLAccount AS GLAccount,
  item.CurrencyISOCode AS CurrencyISOCode,
  item.ReviewComment AS ReviewComment,
  item.VATRegistration AS VATRegistration,
  item.VATRegistrationCountry AS VATRegistrationCountry,
  item.SupplierVATRegistration AS SupplierVATRegistration,
  item.CustomerVATRegistration AS CustomerVATRegistration,
  item.SupplierVATRegistrationCountry AS SupplierVATRegistrationCountry,
  item.CustomerVATRegistrationCountry AS CustomerVATRegistrationCountry,
  item.OneTimeVendor AS OneTimeVendor,
  item.OneTimeCustomer AS OneTimeCustomer,
  item.OneTimeCountry AS OneTimeCountry,
  item.SupplierCountry AS SupplierCountry,
  item.CustomerCountry AS CustomerCountry
FROM P_PT_BOPCustSuplrBalance AS item
;