@AbapCatalog.sqlViewName: 'PJEBOPFI'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling: { type: #INHERITED, algorithm: #SESSION_VARIABLE }
////////////////////////////////////////////////////////////////////////////////
// This private view is a helper view for C_JrnlEntrItmToFormItmCube
////////////////////////////////////////////////////////////////////////////////
define view P_JrnlEntrItmToBOPFormItm as
select distinct from P_JrnlEntrItmToBOPFormItm21 as m21
join I_JournalEntryItem as itm on itm.Ledger = m21.Ledger and
itm.SourceLedger = m21.SourceLedger and
itm.CompanyCode = m21.CompanyCode and
itm.AccountingDocument = m21.AccountingDocument and
itm.FiscalYear = m21.FiscalYear and
itm.LedgerGLLineItem = m21.LedgerGLLineItem
{
key m21.Ledger,
key m21.SourceLedger,
key m21.CompanyCode,
key m21.AccountingDocument,
key m21.FiscalYear,
key m21.LedgerGLLineItem,
key BOPRptgCntry,
key BOPForm,
key BOPFormItem,
m21.CompanyCodeCountry,
m21.BOPPartnerCntry,
m21.IsEUTriangularDeal,
m21.UniqueAcctgDocClrgDate,
m21.HasUniqueClrgDate,
itm.PostingDate,
itm.FiscalYearVariant,
itm.ChartOfAccounts,
itm.GLAccount,
itm.TaxCode,
itm.AccountingDocumentType,
itm.SpecialGLCode,
itm.DebitCreditCode,
itm.TransactionCurrency,
itm.AmountInTransactionCurrency,
itm.DebitAmountInTransCrcy,
itm.CreditAmountInTransCrcy,
itm.CompanyCodeCurrency,
itm.AmountInCompanyCodeCurrency,
itm.DebitAmountInCoCodeCrcy,
itm.CreditAmountInCoCodeCrcy,
itm.ClearingDate,
itm.ClearingAccountingDocument,
itm.ClearingDocFiscalYear,
itm.IsReversal,
itm.IsReversed,
itm.FinancialAccountType,
itm.Customer,
itm.Supplier,
itm.OffsettingAccountType,
itm.OffsettingAccount,
itm.PartnerCompany //[non-]affiliated
}
union all
select distinct from P_JrnlEntrItmToBOPFormItm32 as m32
join I_JournalEntryItem as itm on itm.Ledger = m32.Ledger and
itm.SourceLedger = m32.SourceLedger and
itm.CompanyCode = m32.CompanyCode and
itm.AccountingDocument = m32.AccountingDocument and
itm.FiscalYear = m32.FiscalYear and
itm.LedgerGLLineItem = m32.LedgerGLLineItem
{
key m32.Ledger,
key m32.SourceLedger,
key m32.CompanyCode,
key m32.AccountingDocument,
key m32.FiscalYear,
key m32.LedgerGLLineItem,
key BOPRptgCntry,
key BOPForm,
key BOPFormItem,
m32.CompanyCodeCountry,
m32.BOPPartnerCntry,
m32.IsEUTriangularDeal,
m32.UniqueAcctgDocClrgDate,
m32.HasUniqueClrgDate,
itm.PostingDate,
itm.FiscalYearVariant,
itm.ChartOfAccounts,
itm.GLAccount,
itm.TaxCode,
itm.AccountingDocumentType,
itm.SpecialGLCode,
itm.DebitCreditCode,
itm.TransactionCurrency,
itm.AmountInTransactionCurrency,
itm.DebitAmountInTransCrcy,
itm.CreditAmountInTransCrcy,
itm.CompanyCodeCurrency,
itm.AmountInCompanyCodeCurrency,
itm.DebitAmountInCoCodeCrcy,
itm.CreditAmountInCoCodeCrcy,
itm.ClearingDate,
itm.ClearingAccountingDocument,
itm.ClearingDocFiscalYear,
itm.IsReversal,
itm.IsReversed,
itm.FinancialAccountType,
itm.Customer,
itm.Supplier,
itm.OffsettingAccountType,
itm.OffsettingAccount,
itm.PartnerCompany //[non-]affiliated
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRYITEM",
"P_JRNLENTRITMTOBOPFORMITM21",
"P_JRNLENTRITMTOBOPFORMITM32"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/