P_PT_BOPCustSuplrBalance

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_BOPCustSuplrBalance.
-- 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_BOPCustSuplrBalance AS
SELECT
  Item.CompanyCode AS CompanyCode,
  Item.AccountingDocument AS AccountingDocument,
  Item.FiscalYear AS FiscalYear,
  Item.AccountingDocumentItem AS AccountingDocumentItem,
  Item.ClearingAccountingDocument AS ClearingAccountingDocument,
  Item.ClearingJournalEntry AS ClearingJournalEntry,
  Item.ClearingDate AS ClearingDate,
  Item.PostingDate AS Postingdate,
  Item.FinancialAccountType AS FinancialAccountType,
  Item.GLAccount AS GLAccount,
  Item.Customer AS Customer,
  Item.Supplier AS Supplier,
  case when Item.FinancialAccountType = 'K' then Item._Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartner when Item.FinancialAccountType = 'D' then Item._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner else '' end as BusinessPartner AS BusinessPartnerelseendasBusinessPartner,
  cast( 'P' as fipt_cope_value_type ) AS PT_BOPValueType,
  cast( 'X' as fipt_cope_acctype ) AS PT_BOPAccountType,
  Item.DebitCreditCode AS DebitCreditCode,
  Item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  Item.TransactionCurrency AS TransactionCurrency,
  Item._TransactionCurrency.CurrencyISOCode AS CurrencyISOCode,
  CONFIG.LowerBoundaryAccount AS LowerBoundaryAccount,
  CONFIG.UpperBoundaryAccount AS UpperBoundaryAccount,
  CONFIG.PT_BOPAcctBalDebitClsfctn AS PT_BOPAcctBalDebitClsfctn,
  CONFIG.PT_BOPAcctBalCreditClsfctn AS PT_BOPAcctBalCreditClsfctn,
  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._Supplier.VATRegistration AS SupplierVATRegistration,
  Item._Customer.VATRegistration AS CustomerVATRegistration,
  left(Item._Supplier.VATRegistration ,2) AS SupplierVATRegistrationCountry,
  left(Item._Customer.VATRegistration,2) AS CustomerVATRegistrationCountry,
  Item._Supplier.Country AS SupplierCountry,
  Item._Customer.Country AS CustomerCountry,
  Item._Supplier.IsOneTimeAccount AS OneTimeVendor,
  Item._Customer.IsOneTimeAccount AS OneTimeCustomer,
  Item._OneTimeAccountBP.Country AS OneTimeCountry
FROM I_OperationalAcctgDocItem AS Item
INNER JOIN I_PT_BOPEndOfPeriodGLAccount AS CONFIG ON /* join condition not captured in parsed metadata */
;