P_BOPRblsPyblsItemToFormItemR

DDL: P_BOPRBLSPYBLSITEMTOFORMITEMR Type: view_entity COMPOSITE

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.

3 data source(s) 37 fields

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
KEY AccountingDocument P_BOPRblsPyblsItemFilter AccountingDocument
KEY FiscalYear P_BOPRblsPyblsItemFilter FiscalYear
KEY AccountingDocumentItem P_BOPRblsPyblsItemFilter AccountingDocumentItem
KEY BOPForm P_BOPRblsPyblsItemFilter BOPForm
KEY BOPRptgCntry P_BOPRblsPyblsItemFilter BOPRptgCntry
KEY BOPFormItem I_BOPFormItemRule BOPFormItem
KEY CompanyCodeCountry P_BOPRblsPyblsItemFilter CompanyCodeCountry
KEY StatryRptgEntity I_StRpJournalEntryHeaderLog StatryRptgEntity
KEY StatryRptCategory I_StRpJournalEntryHeaderLog StatryRptCategory
KEY StatryRptRunID I_StRpJournalEntryHeaderLog StatryRptRunID
PostingDate P_BOPRblsPyblsItemFilter PostingDate
ClearingDate P_BOPRblsPyblsItemFilter ClearingDate
ChartOfAccounts P_BOPRblsPyblsItemFilter ChartOfAccounts
GLAccount P_BOPRblsPyblsItemFilter GLAccount
TaxCode P_BOPRblsPyblsItemFilter TaxCode
AccountingDocumentType P_BOPRblsPyblsItemFilter AccountingDocumentType
IsEUTriangularDeal P_BOPRblsPyblsItemFilter IsEUTriangularDeal
SpecialGLCode P_BOPRblsPyblsItemFilter SpecialGLCode
DebitCreditCode P_BOPRblsPyblsItemFilter DebitCreditCode
TransactionCurrency P_BOPRblsPyblsItemFilter TransactionCurrency
AmountInTransactionCurrency P_BOPRblsPyblsItemFilter AmountInTransactionCurrency
CompanyCodeCurrency P_BOPRblsPyblsItemFilter CompanyCodeCurrency
AmountInCompanyCodeCurrency P_BOPRblsPyblsItemFilter AmountInCompanyCodeCurrency
ClearingJournalEntry P_BOPRblsPyblsItemFilter ClearingJournalEntry
ClearingJournalEntryFiscalYear P_BOPRblsPyblsItemFilter ClearingJournalEntryFiscalYear
FinancialAccountType P_BOPRblsPyblsItemFilter FinancialAccountType
OffsettingAccountType P_BOPRblsPyblsItemFilter OffsettingAccountType
OffsettingAccount P_BOPRblsPyblsItemFilter OffsettingAccount
PartnerCompany P_BOPRblsPyblsItemFilter PartnerCompany
Customer P_BOPRblsPyblsItemFilter Customer
CustomerIsOneTimeAccount P_BOPRblsPyblsItemFilter CustomerIsOneTimeAccount
CustomerCountry P_BOPRblsPyblsItemFilter CustomerCountry
Supplier P_BOPRblsPyblsItemFilter Supplier
SupplierIsOneTimeAccount P_BOPRblsPyblsItemFilter SupplierIsOneTimeAccount
SupplierCountry P_BOPRblsPyblsItemFilter SupplierCountry
OneTimeAccountBPCountry P_BOPRblsPyblsItemFilter OneTimeAccountBPCountry 
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view entity P_BOPRblsPyblsItemToFormItemR
  as select from I_StRpJournalEntryHeaderLog
    inner join   P_BOPRblsPyblsItemFilter on  P_BOPRblsPyblsItemFilter.CompanyCode        = I_StRpJournalEntryHeaderLog.CompanyCode
                                          and P_BOPRblsPyblsItemFilter.AccountingDocument = I_StRpJournalEntryHeaderLog.AccountingDocument
                                          and P_BOPRblsPyblsItemFilter.FiscalYear         = I_StRpJournalEntryHeaderLog.FiscalYear
    inner join   I_BOPFormItemRule        on  I_BOPFormItemRule.BOPForm                        =       P_BOPRblsPyblsItemFilter.BOPForm
                                          and I_BOPFormItemRule.BOPRptgCntry                   =       P_BOPRblsPyblsItemFilter.BOPRptgCntry
                                          and I_BOPFormItemRule.BOPChtAccts                    =       P_BOPRblsPyblsItemFilter.ChartOfAccounts
                                          and (
                                             (
                                               P_BOPRblsPyblsItemFilter.GLAccount              between I_BOPFormItemRule.BOPLowrBndryGLAcct and I_BOPFormItemRule.BOPUprBndryGLAcct
                                             )
                                             or(
                                               I_BOPFormItemRule.BOPLowrBndryGLAcct            =       P_BOPRblsPyblsItemFilter.GLAccount
                                               and I_BOPFormItemRule.BOPUprBndryGLAcct         =       ''
                                             )
                                           )
                                          and (
                                             I_BOPFormItemRule.BOPAcctgDocType                 =       P_BOPRblsPyblsItemFilter.AccountingDocumentType
                                             or I_BOPFormItemRule.BOPAcctgDocType              =       ''
                                           )
                                          and (
                                             I_BOPFormItemRule.BOPTaxCode                      =       P_BOPRblsPyblsItemFilter.TaxCode
                                             or I_BOPFormItemRule.BOPTaxCode                   =       ''
                                           )
                                          and (
                                             I_BOPFormItemRule.BOPTriangularDealRelevancy      =       ''
                                             or(
                                               I_BOPFormItemRule.BOPTriangularDealRelevancy    =       '+'
                                               and P_BOPRblsPyblsItemFilter.IsEUTriangularDeal =       'X'
                                             )
                                             or(
                                               I_BOPFormItemRule.BOPTriangularDealRelevancy    =       '-'
                                               and P_BOPRblsPyblsItemFilter.IsEUTriangularDeal =       ''
                                             )
                                           )
{
  key P_BOPRblsPyblsItemFilter.CompanyCode,
  key P_BOPRblsPyblsItemFilter.AccountingDocument,
  key P_BOPRblsPyblsItemFilter.FiscalYear,
  key P_BOPRblsPyblsItemFilter.AccountingDocumentItem,
  key P_BOPRblsPyblsItemFilter.BOPForm,
  key P_BOPRblsPyblsItemFilter.BOPRptgCntry,
  key I_BOPFormItemRule.BOPFormItem,
  key P_BOPRblsPyblsItemFilter.CompanyCodeCountry,
  key I_StRpJournalEntryHeaderLog.StatryRptgEntity,
  key I_StRpJournalEntryHeaderLog.StatryRptCategory,
  key I_StRpJournalEntryHeaderLog.StatryRptRunID,

      P_BOPRblsPyblsItemFilter.PostingDate,
      P_BOPRblsPyblsItemFilter.ClearingDate,

      P_BOPRblsPyblsItemFilter.ChartOfAccounts,
      P_BOPRblsPyblsItemFilter.GLAccount,
      P_BOPRblsPyblsItemFilter.TaxCode,
      P_BOPRblsPyblsItemFilter.AccountingDocumentType,
      P_BOPRblsPyblsItemFilter.IsEUTriangularDeal,
      P_BOPRblsPyblsItemFilter.SpecialGLCode,
      P_BOPRblsPyblsItemFilter.DebitCreditCode,

      P_BOPRblsPyblsItemFilter.TransactionCurrency,
      P_BOPRblsPyblsItemFilter.AmountInTransactionCurrency,
      P_BOPRblsPyblsItemFilter.CompanyCodeCurrency,
      P_BOPRblsPyblsItemFilter.AmountInCompanyCodeCurrency,

      P_BOPRblsPyblsItemFilter.ClearingJournalEntry,
      P_BOPRblsPyblsItemFilter.ClearingJournalEntryFiscalYear,

      P_BOPRblsPyblsItemFilter.FinancialAccountType,
      P_BOPRblsPyblsItemFilter.OffsettingAccountType,
      P_BOPRblsPyblsItemFilter.OffsettingAccount,
      P_BOPRblsPyblsItemFilter.PartnerCompany,

      P_BOPRblsPyblsItemFilter.Customer,
      P_BOPRblsPyblsItemFilter.CustomerIsOneTimeAccount,
      P_BOPRblsPyblsItemFilter.CustomerCountry,

      P_BOPRblsPyblsItemFilter.Supplier,
      P_BOPRblsPyblsItemFilter.SupplierIsOneTimeAccount,
      P_BOPRblsPyblsItemFilter.SupplierCountry,

      P_BOPRblsPyblsItemFilter.OneTimeAccountBPCountry
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BOPFORMITEMRULE",
"I_STRPJOURNALENTRYHEADERLOG",
"P_BOPRBLSPYBLSITEMFILTER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More