P_BOPRevnCostItemToFormItem20

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_BOPRevnCostItemToFormItem20.
-- 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_BOPRevnCostItemToFormItem20 AS
SELECT
  P_BOPRevnCostItemToFormItem00.Ledger AS Ledger,
  P_BOPRevnCostItemToFormItem00.SourceLedger AS SourceLedger,
  P_BOPRevnCostItemToFormItem00.CompanyCode AS CompanyCode,
  P_BOPRevnCostItemToFormItem00.AccountingDocument AS AccountingDocument,
  P_BOPRevnCostItemToFormItem00.FiscalYear AS FiscalYear,
  P_BOPRevnCostItemToFormItem00.LedgerGLLineItem AS LedgerGLLineItem,
  P_BOPRevnCostItemToFormItem00.BOPForm AS BOPForm,
  P_BOPRevnCostItemToFormItem00.BOPRptgCntry AS BOPRptgCntry,
  P_BOPRevnCostItemToFormItem00.CompanyCodeCountry AS CompanyCodeCountry,
  P_BOPRevnCostItemToFormItem00.StatryRptgEntity AS StatryRptgEntity,
  P_BOPRevnCostItemToFormItem00.StatryRptCategory AS StatryRptCategory,
  P_BOPRevnCostItemToFormItem00.StatryRptRunID AS StatryRptRunID,
  P_BOPRevnCostItemToFormItem00.AccountingDocumentItem AS AccountingDocumentItem,
  P_BOPRevnCostItemToFormItem00.PostingDate AS PostingDate,
  P_BOPRevnCostItemToFormItem00.ClearingDate AS ClearingDate,
  P_BOPRevnCostItemToFormItem00.ChartOfAccounts AS ChartOfAccounts,
  P_BOPRevnCostItemToFormItem00.GLAccount AS GLAccount,
  I_PurOrdAccountAssignment.GLAccount AS PurchasingOrderGLAccount,
  GoodsReceipt.GLAccount AS GoodsReceiptGLAccount,
  P_BOPRevnCostItemToFormItem00.TaxCode AS TaxCode,
  P_BOPRevnCostItemToFormItem00.AccountingDocumentType AS AccountingDocumentType,
  P_BOPRevnCostItemToFormItem00.IsEUTriangularDeal AS IsEUTriangularDeal,
  P_BOPRevnCostItemToFormItem00.SpecialGLCode AS SpecialGLCode,
  P_BOPRevnCostItemToFormItem00.DebitCreditCode AS DebitCreditCode,
  P_BOPRevnCostItemToFormItem00.TransactionCurrency AS TransactionCurrency,
  P_BOPRevnCostItemToFormItem00.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  P_BOPRevnCostItemToFormItem00.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_BOPRevnCostItemToFormItem00.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  P_BOPRevnCostItemToFormItem00.ClearingJournalEntry AS ClearingJournalEntry,
  P_BOPRevnCostItemToFormItem00.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  P_BOPRevnCostItemToFormItem00.FinancialAccountType AS FinancialAccountType,
  P_BOPRevnCostItemToFormItem00.ImportExportFinancialAccType AS ImportExportFinancialAccType,
  P_BOPRevnCostItemToFormItem00.OffsettingAccountType AS OffsettingAccountType,
  P_BOPRevnCostItemToFormItem00.OffsettingAccount AS OffsettingAccount,
  P_BOPRevnCostItemToFormItem00.PartnerCompany AS PartnerCompany,
  P_BOPRevnCostItemToFormItem00.Customer AS Customer,
  P_BOPRevnCostItemToFormItem00.Supplier AS Supplier,
  P_BOPRevnCostItemToFormItem00.BOPCustomerIsOneTimeAccount AS BOPCustomerIsOneTimeAccount,
  P_BOPRevnCostItemToFormItem00.BOPCustomerCountry AS BOPCustomerCountry,
  P_BOPRevnCostItemToFormItem00.BOPSupplierIsOneTimeAccount AS BOPSupplierIsOneTimeAccount,
  P_BOPRevnCostItemToFormItem00.BOPSupplierCountry AS BOPSupplierCountry,
  P_BOPRevnCostItemToFormItem00.BOPOneTimeAccountBPCountry AS BOPOneTimeAccountBPCountry
FROM P_BOPRevnCostItemToFormItem00
;