P_BOPRevnCostItemToFormItem25

DDL: P_BOPREVNCOSTITEMTOFORMITEM25 Type: view_entity COMPOSITE

P_BOPRevnCostItemToFormItem25 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_BOPFormItemRule, P_BOPRevnCostItemToFormItem20) and exposes 41 fields with key fields Ledger, SourceLedger, CompanyCode, AccountingDocument, FiscalYear.

Data Sources (2)

SourceAliasJoin Type
I_BOPFormItemRule I_BOPFormItemRule inner
P_BOPRevnCostItemToFormItem20 P_BOPRevnCostItemToFormItem20 from

Annotations (3)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY Ledger P_BOPRevnCostItemToFormItem20 Ledger Ledger
KEY SourceLedger P_BOPRevnCostItemToFormItem20 SourceLedger Source Ledger
KEY CompanyCode P_BOPRevnCostItemToFormItem20 CompanyCode Receiver Company Code
KEY AccountingDocument P_BOPRevnCostItemToFormItem20 AccountingDocument Journal Entry
KEY FiscalYear P_BOPRevnCostItemToFormItem20 FiscalYear G/L Fiscal Year
KEY LedgerGLLineItem P_BOPRevnCostItemToFormItem20 LedgerGLLineItem Journal Entry Item
KEY BOPForm P_BOPRevnCostItemToFormItem20 BOPForm Form
KEY BOPRptgCntry P_BOPRevnCostItemToFormItem20 BOPRptgCntry Reporting Ctry/Reg.
KEY BOPFormItem I_BOPFormItemRule BOPFormItem Form Item
KEY CompanyCodeCountry P_BOPRevnCostItemToFormItem20 CompanyCodeCountry Reporting Ctry/Reg.
KEY StatryRptgEntity P_BOPRevnCostItemToFormItem20 StatryRptgEntity Reporting Entity
KEY StatryRptCategory P_BOPRevnCostItemToFormItem20 StatryRptCategory Report ID
KEY StatryRptRunID P_BOPRevnCostItemToFormItem20 StatryRptRunID Report Run ID
AccountingDocumentItem P_BOPRevnCostItemToFormItem20 AccountingDocumentItem Posting View Item
PostingDate P_BOPRevnCostItemToFormItem20 PostingDate Posting Date for GR
ClearingDate P_BOPRevnCostItemToFormItem20 ClearingDate Clearing Date
ChartOfAccounts P_BOPRevnCostItemToFormItem20 ChartOfAccounts Node Class
GLAccount P_BOPRevnCostItemToFormItem20 GLAccount General Ledger
TaxCode P_BOPRevnCostItemToFormItem20 TaxCode Tax Code
AccountingDocumentType P_BOPRevnCostItemToFormItem20 AccountingDocumentType Journal Entry Type
IsEUTriangularDeal P_BOPRevnCostItemToFormItem20 IsEUTriangularDeal Is EU Triangular Deal
SpecialGLCode P_BOPRevnCostItemToFormItem20 SpecialGLCode Special G/L Ind
DebitCreditCode P_BOPRevnCostItemToFormItem20 DebitCreditCode Single-Character Flag
TransactionCurrency P_BOPRevnCostItemToFormItem20 TransactionCurrency Transaction Currency
AmountInTransactionCurrency P_BOPRevnCostItemToFormItem20 AmountInTransactionCurrency Pt Crcy Amt
CompanyCodeCurrency P_BOPRevnCostItemToFormItem20 CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency P_BOPRevnCostItemToFormItem20 AmountInCompanyCodeCurrency Local Crcy Amt
ClearingJournalEntry P_BOPRevnCostItemToFormItem20 ClearingJournalEntry Clrng doc.
ClearingJournalEntryFiscalYear P_BOPRevnCostItemToFormItem20 ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
FinancialAccountType P_BOPRevnCostItemToFormItem20 FinancialAccountType Fin. Account Type
ImportExportFinancialAccType P_BOPRevnCostItemToFormItem20 ImportExportFinancialAccType
OffsettingAccountType P_BOPRevnCostItemToFormItem20 OffsettingAccountType Offset Acct Type
OffsettingAccount P_BOPRevnCostItemToFormItem20 OffsettingAccount Offsetting Acct
PartnerCompany P_BOPRevnCostItemToFormItem20 PartnerCompany Trading Partner
Customer P_BOPRevnCostItemToFormItem20 Customer Sold-to Party
Supplier P_BOPRevnCostItemToFormItem20 Supplier Supplier
BOPCustomerIsOneTimeAccount P_BOPRevnCostItemToFormItem20 BOPCustomerIsOneTimeAccount
BOPCustomerCountry P_BOPRevnCostItemToFormItem20 BOPCustomerCountry
BOPSupplierIsOneTimeAccount P_BOPRevnCostItemToFormItem20 BOPSupplierIsOneTimeAccount
BOPSupplierCountry P_BOPRevnCostItemToFormItem20 BOPSupplierCountry
BOPOneTimeAccountBPCountry P_BOPRevnCostItemToFormItem20 BOPOneTimeAccountBPCountry

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_BOPRevnCostItemToFormItem25.
-- 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_BOPRevnCostItemToFormItem25 AS
SELECT
  P_BOPRevnCostItemToFormItem20.Ledger AS Ledger,
  P_BOPRevnCostItemToFormItem20.SourceLedger AS SourceLedger,
  P_BOPRevnCostItemToFormItem20.CompanyCode AS CompanyCode,
  P_BOPRevnCostItemToFormItem20.AccountingDocument AS AccountingDocument,
  P_BOPRevnCostItemToFormItem20.FiscalYear AS FiscalYear,
  P_BOPRevnCostItemToFormItem20.LedgerGLLineItem AS LedgerGLLineItem,
  P_BOPRevnCostItemToFormItem20.BOPForm AS BOPForm,
  P_BOPRevnCostItemToFormItem20.BOPRptgCntry AS BOPRptgCntry,
  I_BOPFormItemRule.BOPFormItem AS BOPFormItem,
  P_BOPRevnCostItemToFormItem20.CompanyCodeCountry AS CompanyCodeCountry,
  P_BOPRevnCostItemToFormItem20.StatryRptgEntity AS StatryRptgEntity,
  P_BOPRevnCostItemToFormItem20.StatryRptCategory AS StatryRptCategory,
  P_BOPRevnCostItemToFormItem20.StatryRptRunID AS StatryRptRunID,
  P_BOPRevnCostItemToFormItem20.AccountingDocumentItem AS AccountingDocumentItem,
  P_BOPRevnCostItemToFormItem20.PostingDate AS PostingDate,
  P_BOPRevnCostItemToFormItem20.ClearingDate AS ClearingDate,
  P_BOPRevnCostItemToFormItem20.ChartOfAccounts AS ChartOfAccounts,
  P_BOPRevnCostItemToFormItem20.GLAccount AS GLAccount,
  P_BOPRevnCostItemToFormItem20.TaxCode AS TaxCode,
  P_BOPRevnCostItemToFormItem20.AccountingDocumentType AS AccountingDocumentType,
  P_BOPRevnCostItemToFormItem20.IsEUTriangularDeal AS IsEUTriangularDeal,
  P_BOPRevnCostItemToFormItem20.SpecialGLCode AS SpecialGLCode,
  P_BOPRevnCostItemToFormItem20.DebitCreditCode AS DebitCreditCode,
  P_BOPRevnCostItemToFormItem20.TransactionCurrency AS TransactionCurrency,
  P_BOPRevnCostItemToFormItem20.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  P_BOPRevnCostItemToFormItem20.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_BOPRevnCostItemToFormItem20.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  P_BOPRevnCostItemToFormItem20.ClearingJournalEntry AS ClearingJournalEntry,
  P_BOPRevnCostItemToFormItem20.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  P_BOPRevnCostItemToFormItem20.FinancialAccountType AS FinancialAccountType,
  P_BOPRevnCostItemToFormItem20.ImportExportFinancialAccType AS ImportExportFinancialAccType,
  P_BOPRevnCostItemToFormItem20.OffsettingAccountType AS OffsettingAccountType,
  P_BOPRevnCostItemToFormItem20.OffsettingAccount AS OffsettingAccount,
  P_BOPRevnCostItemToFormItem20.PartnerCompany AS PartnerCompany,
  P_BOPRevnCostItemToFormItem20.Customer AS Customer,
  P_BOPRevnCostItemToFormItem20.Supplier AS Supplier,
  P_BOPRevnCostItemToFormItem20.BOPCustomerIsOneTimeAccount AS BOPCustomerIsOneTimeAccount,
  P_BOPRevnCostItemToFormItem20.BOPCustomerCountry AS BOPCustomerCountry,
  P_BOPRevnCostItemToFormItem20.BOPSupplierIsOneTimeAccount AS BOPSupplierIsOneTimeAccount,
  P_BOPRevnCostItemToFormItem20.BOPSupplierCountry AS BOPSupplierCountry,
  P_BOPRevnCostItemToFormItem20.BOPOneTimeAccountBPCountry AS BOPOneTimeAccountBPCountry
FROM P_BOPRevnCostItemToFormItem20
INNER JOIN I_BOPFormItemRule ON /* join condition not captured in parsed metadata */
;