P_BOPRblsPyblsItemFilter

DDL: P_BOPRBLSPYBLSITEMFILTER Type: view_entity COMPOSITE Package: GLO_FIN_IS_BOP_GEN
33 Fields 2 Data Sources

BOP: Receivables/Payables Base Item Filter

P_BOPRblsPyblsItemFilter is a Composite CDS View that provides data about "BOP: Receivables/Payables Base Item Filter" in SAP S/4HANA. It reads from 2 data sources (P_BOPRblsPyblsItemBase, P_JrnlEntrItmToBOPFormItm11) and exposes 33 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, BOPForm. Part of development package GLO_FIN_IS_BOP_GEN.

Data Sources (2)

SourceAliasJoin Type
P_BOPRblsPyblsItemBase P_BOPRblsPyblsItemBase from
P_JrnlEntrItmToBOPFormItm11 P_JrnlEntrItmToBOPFormItm11 inner

Annotations (3)

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

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_BOPRblsPyblsItemBase CompanyCode Receiver Company Code
KEY AccountingDocument P_BOPRblsPyblsItemBase AccountingDocument Journal Entry
KEY FiscalYear P_BOPRblsPyblsItemBase FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem P_BOPRblsPyblsItemBase AccountingDocumentItem Posting View Item
KEY BOPForm P_JrnlEntrItmToBOPFormItm11 BOPForm Form
KEY BOPRptgCntry P_JrnlEntrItmToBOPFormItm11 BOPRptgCntry Reporting Ctry/Reg.
KEY CompanyCodeCountry P_JrnlEntrItmToBOPFormItm11 CompanyCodeCountry Reporting Ctry/Reg.
PostingDate P_BOPRblsPyblsItemBase PostingDate Posting Date for GR
ClearingDate P_BOPRblsPyblsItemBase ClearingDate Clearing Date
ChartOfAccounts P_BOPRblsPyblsItemBase ChartOfAccounts Node Class
GLAccount P_BOPRblsPyblsItemBase GLAccount General Ledger
TaxCode P_BOPRblsPyblsItemBase TaxCode Tax Code
AccountingDocumentType P_BOPRblsPyblsItemBase AccountingDocumentType Journal Entry Type
IsEUTriangularDeal P_BOPRblsPyblsItemBase IsEUTriangularDeal Is EU Triangular Deal
SpecialGLCode P_BOPRblsPyblsItemBase SpecialGLCode Special G/L Ind
DebitCreditCode P_BOPRblsPyblsItemBase DebitCreditCode Single-Character Flag
TransactionCurrency P_BOPRblsPyblsItemBase TransactionCurrency Transaction Currency
AmountInTransactionCurrency P_BOPRblsPyblsItemBase AmountInTransactionCurrency Pt Crcy Amt
CompanyCodeCurrency P_BOPRblsPyblsItemBase CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency P_BOPRblsPyblsItemBase AmountInCompanyCodeCurrency Local Crcy Amt
ClearingJournalEntry P_BOPRblsPyblsItemBase ClearingJournalEntry Clrng doc.
ClearingJournalEntryFiscalYear P_BOPRblsPyblsItemBase ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
FinancialAccountType P_BOPRblsPyblsItemBase FinancialAccountType Fin. Account Type
OffsettingAccountType P_BOPRblsPyblsItemBase OffsettingAccountType Offset Acct Type
OffsettingAccount P_BOPRblsPyblsItemBase OffsettingAccount Offsetting Acct
PartnerCompany P_BOPRblsPyblsItemBase PartnerCompany Trading Partner
Customer P_BOPRblsPyblsItemBase Customer Sold-to Party
CustomerIsOneTimeAccount P_BOPRblsPyblsItemBase CustomerIsOneTimeAccount
CustomerCountry P_BOPRblsPyblsItemBase CustomerCountry
Supplier P_BOPRblsPyblsItemBase Supplier Supplier
SupplierIsOneTimeAccount P_BOPRblsPyblsItemBase SupplierIsOneTimeAccount
SupplierCountry P_BOPRblsPyblsItemBase SupplierCountry
OneTimeAccountBPCountry P_BOPRblsPyblsItemBase 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_BOPRblsPyblsItemFilter.
-- 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_BOPRblsPyblsItemFilter AS
SELECT
  P_BOPRblsPyblsItemBase.CompanyCode AS CompanyCode,
  P_BOPRblsPyblsItemBase.AccountingDocument AS AccountingDocument,
  P_BOPRblsPyblsItemBase.FiscalYear AS FiscalYear,
  P_BOPRblsPyblsItemBase.AccountingDocumentItem AS AccountingDocumentItem,
  P_JrnlEntrItmToBOPFormItm11.BOPForm AS BOPForm,
  P_JrnlEntrItmToBOPFormItm11.BOPRptgCntry AS BOPRptgCntry,
  P_JrnlEntrItmToBOPFormItm11.CompanyCodeCountry AS CompanyCodeCountry,
  P_BOPRblsPyblsItemBase.PostingDate AS PostingDate,
  P_BOPRblsPyblsItemBase.ClearingDate AS ClearingDate,
  P_BOPRblsPyblsItemBase.ChartOfAccounts AS ChartOfAccounts,
  P_BOPRblsPyblsItemBase.GLAccount AS GLAccount,
  P_BOPRblsPyblsItemBase.TaxCode AS TaxCode,
  P_BOPRblsPyblsItemBase.AccountingDocumentType AS AccountingDocumentType,
  P_BOPRblsPyblsItemBase.IsEUTriangularDeal AS IsEUTriangularDeal,
  P_BOPRblsPyblsItemBase.SpecialGLCode AS SpecialGLCode,
  P_BOPRblsPyblsItemBase.DebitCreditCode AS DebitCreditCode,
  P_BOPRblsPyblsItemBase.TransactionCurrency AS TransactionCurrency,
  P_BOPRblsPyblsItemBase.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  P_BOPRblsPyblsItemBase.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_BOPRblsPyblsItemBase.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  P_BOPRblsPyblsItemBase.ClearingJournalEntry AS ClearingJournalEntry,
  P_BOPRblsPyblsItemBase.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  P_BOPRblsPyblsItemBase.FinancialAccountType AS FinancialAccountType,
  P_BOPRblsPyblsItemBase.OffsettingAccountType AS OffsettingAccountType,
  P_BOPRblsPyblsItemBase.OffsettingAccount AS OffsettingAccount,
  P_BOPRblsPyblsItemBase.PartnerCompany AS PartnerCompany,
  P_BOPRblsPyblsItemBase.Customer AS Customer,
  P_BOPRblsPyblsItemBase.CustomerIsOneTimeAccount AS CustomerIsOneTimeAccount,
  P_BOPRblsPyblsItemBase.CustomerCountry AS CustomerCountry,
  P_BOPRblsPyblsItemBase.Supplier AS Supplier,
  P_BOPRblsPyblsItemBase.SupplierIsOneTimeAccount AS SupplierIsOneTimeAccount,
  P_BOPRblsPyblsItemBase.SupplierCountry AS SupplierCountry,
  P_BOPRblsPyblsItemBase.OneTimeAccountBPCountry AS OneTimeAccountBPCountry
FROM P_BOPRblsPyblsItemBase
INNER JOIN P_JrnlEntrItmToBOPFormItm11 ON /* join condition not captured in parsed metadata */
;

Learn More