P_BOPRblsPyblsItemToFormItemR

DDL: P_BOPRBLSPYBLSITEMTOFORMITEMR Type: view_entity COMPOSITE
37 Fields 3 Data Sources

P_BOPRblsPyblsItemToFormItemR is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_BOPFormItemRule, I_StRpJournalEntryHeaderLog, P_BOPRblsPyblsItemFilter) and exposes 37 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, BOPForm.

Data Sources (3)

SourceAliasJoin Type
I_BOPFormItemRule I_BOPFormItemRule inner
I_StRpJournalEntryHeaderLog I_StRpJournalEntryHeaderLog from
P_BOPRblsPyblsItemFilter P_BOPRblsPyblsItemFilter inner

Annotations (3)

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

Fields (37)

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

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_BOPRblsPyblsItemToFormItemR.
-- 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_BOPRblsPyblsItemToFormItemR AS
SELECT
  P_BOPRblsPyblsItemFilter.CompanyCode AS CompanyCode,
  P_BOPRblsPyblsItemFilter.AccountingDocument AS AccountingDocument,
  P_BOPRblsPyblsItemFilter.FiscalYear AS FiscalYear,
  P_BOPRblsPyblsItemFilter.AccountingDocumentItem AS AccountingDocumentItem,
  P_BOPRblsPyblsItemFilter.BOPForm AS BOPForm,
  P_BOPRblsPyblsItemFilter.BOPRptgCntry AS BOPRptgCntry,
  I_BOPFormItemRule.BOPFormItem AS BOPFormItem,
  P_BOPRblsPyblsItemFilter.CompanyCodeCountry AS CompanyCodeCountry,
  I_StRpJournalEntryHeaderLog.StatryRptgEntity AS StatryRptgEntity,
  I_StRpJournalEntryHeaderLog.StatryRptCategory AS StatryRptCategory,
  I_StRpJournalEntryHeaderLog.StatryRptRunID AS StatryRptRunID,
  P_BOPRblsPyblsItemFilter.PostingDate AS PostingDate,
  P_BOPRblsPyblsItemFilter.ClearingDate AS ClearingDate,
  P_BOPRblsPyblsItemFilter.ChartOfAccounts AS ChartOfAccounts,
  P_BOPRblsPyblsItemFilter.GLAccount AS GLAccount,
  P_BOPRblsPyblsItemFilter.TaxCode AS TaxCode,
  P_BOPRblsPyblsItemFilter.AccountingDocumentType AS AccountingDocumentType,
  P_BOPRblsPyblsItemFilter.IsEUTriangularDeal AS IsEUTriangularDeal,
  P_BOPRblsPyblsItemFilter.SpecialGLCode AS SpecialGLCode,
  P_BOPRblsPyblsItemFilter.DebitCreditCode AS DebitCreditCode,
  P_BOPRblsPyblsItemFilter.TransactionCurrency AS TransactionCurrency,
  P_BOPRblsPyblsItemFilter.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  P_BOPRblsPyblsItemFilter.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_BOPRblsPyblsItemFilter.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  P_BOPRblsPyblsItemFilter.ClearingJournalEntry AS ClearingJournalEntry,
  P_BOPRblsPyblsItemFilter.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  P_BOPRblsPyblsItemFilter.FinancialAccountType AS FinancialAccountType,
  P_BOPRblsPyblsItemFilter.OffsettingAccountType AS OffsettingAccountType,
  P_BOPRblsPyblsItemFilter.OffsettingAccount AS OffsettingAccount,
  P_BOPRblsPyblsItemFilter.PartnerCompany AS PartnerCompany,
  P_BOPRblsPyblsItemFilter.Customer AS Customer,
  P_BOPRblsPyblsItemFilter.CustomerIsOneTimeAccount AS CustomerIsOneTimeAccount,
  P_BOPRblsPyblsItemFilter.CustomerCountry AS CustomerCountry,
  P_BOPRblsPyblsItemFilter.Supplier AS Supplier,
  P_BOPRblsPyblsItemFilter.SupplierIsOneTimeAccount AS SupplierIsOneTimeAccount,
  P_BOPRblsPyblsItemFilter.SupplierCountry AS SupplierCountry,
  P_BOPRblsPyblsItemFilter.OneTimeAccountBPCountry AS OneTimeAccountBPCountry
FROM I_StRpJournalEntryHeaderLog
INNER JOIN P_BOPRblsPyblsItemFilter ON /* join condition not captured in parsed metadata */
INNER JOIN I_BOPFormItemRule ON /* join condition not captured in parsed metadata */
;

Learn More