P_BOPRblsPyblsItemBase

DDL: P_BOPRBLSPYBLSITEMBASE Type: view_entity COMPOSITE
30 Fields 1 Data Sources

P_BOPRblsPyblsItemBase is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 30 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Annotations (3)

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

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode Receiver Company Code
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
PostingDate I_OperationalAcctgDocItem PostingDate Posting Date for GR
ClearingDate I_OperationalAcctgDocItem ClearingDate Clearing Date
ChartOfAccounts I_OperationalAcctgDocItem ChartOfAccounts Node Class
GLAccount I_OperationalAcctgDocItem GLAccount General Ledger
TaxCode I_OperationalAcctgDocItem TaxCode Tax Code
AccountingDocumentType I_OperationalAcctgDocItem AccountingDocumentType Journal Entry Type
IsEUTriangularDeal I_OperationalAcctgDocItem IsEUTriangularDeal Is EU Triangular Deal
SpecialGLCode I_OperationalAcctgDocItem SpecialGLCode Special G/L Ind
DebitCreditCode I_OperationalAcctgDocItem DebitCreditCode Single-Character Flag
TransactionCurrency I_OperationalAcctgDocItem TransactionCurrency Transaction Currency
AmountInTransactionCurrency I_OperationalAcctgDocItem AmountInTransactionCurrency Pt Crcy Amt
CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency I_OperationalAcctgDocItem AmountInCompanyCodeCurrency Local Crcy Amt
ClearingJournalEntry I_OperationalAcctgDocItem ClearingJournalEntry Clrng doc.
ClearingJournalEntryFiscalYear I_OperationalAcctgDocItem ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
FinancialAccountType I_OperationalAcctgDocItem FinancialAccountType Fin. Account Type
OffsettingAccountType I_OperationalAcctgDocItem OffsettingAccountType Offset Acct Type
OffsettingAccount I_OperationalAcctgDocItem OffsettingAccount Offsetting Acct
PartnerCompany I_OperationalAcctgDocItem PartnerCompany Trading Partner
Customer I_OperationalAcctgDocItem Customer Sold-to Party
CustomerIsOneTimeAccount
CustomerCountry
Supplier I_OperationalAcctgDocItem Supplier Supplier
SupplierIsOneTimeAccount
SupplierCountry
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_BOPRblsPyblsItemBase.
-- 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_BOPRblsPyblsItemBase AS
SELECT
  I_OperationalAcctgDocItem.CompanyCode AS CompanyCode,
  I_OperationalAcctgDocItem.AccountingDocument AS AccountingDocument,
  I_OperationalAcctgDocItem.FiscalYear AS FiscalYear,
  I_OperationalAcctgDocItem.AccountingDocumentItem AS AccountingDocumentItem,
  I_OperationalAcctgDocItem.PostingDate AS PostingDate,
  I_OperationalAcctgDocItem.ClearingDate AS ClearingDate,
  I_OperationalAcctgDocItem.ChartOfAccounts AS ChartOfAccounts,
  I_OperationalAcctgDocItem.GLAccount AS GLAccount,
  I_OperationalAcctgDocItem.TaxCode AS TaxCode,
  I_OperationalAcctgDocItem.AccountingDocumentType AS AccountingDocumentType,
  I_OperationalAcctgDocItem.IsEUTriangularDeal AS IsEUTriangularDeal,
  I_OperationalAcctgDocItem.SpecialGLCode AS SpecialGLCode,
  I_OperationalAcctgDocItem.DebitCreditCode AS DebitCreditCode,
  I_OperationalAcctgDocItem.TransactionCurrency AS TransactionCurrency,
  I_OperationalAcctgDocItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  I_OperationalAcctgDocItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_OperationalAcctgDocItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_OperationalAcctgDocItem.ClearingJournalEntry AS ClearingJournalEntry,
  I_OperationalAcctgDocItem.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  I_OperationalAcctgDocItem.FinancialAccountType AS FinancialAccountType,
  I_OperationalAcctgDocItem.OffsettingAccountType AS OffsettingAccountType,
  I_OperationalAcctgDocItem.OffsettingAccount AS OffsettingAccount,
  I_OperationalAcctgDocItem.PartnerCompany AS PartnerCompany,
  I_OperationalAcctgDocItem.Customer AS Customer,
  I_OperationalAcctgDocItem._Customer.IsOneTimeAccount AS CustomerIsOneTimeAccount,
  I_OperationalAcctgDocItem._Customer.Country AS CustomerCountry,
  I_OperationalAcctgDocItem.Supplier AS Supplier,
  I_OperationalAcctgDocItem._Supplier.IsOneTimeAccount AS SupplierIsOneTimeAccount,
  I_OperationalAcctgDocItem._Supplier.Country AS SupplierCountry,
  I_OperationalAcctgDocItem._OneTimeAccountBP.Country AS OneTimeAccountBPCountry
FROM I_OperationalAcctgDocItem
;

Learn More