Which tables does I_SAFTJournalLineItem use?

I_SAFTJournalLineItem reads from 7 data source(s): I_CFinBillingDocument, I_CompanyCode, I_CompanyCode, I_GLAccountInCompanyCode, I_GLAccountInCompanyCode, I_JournalEntryItem, I_JournalEntryItem.

I_SAFTJournalLineItem

Q: How many fields does I_SAFTJournalLineItem have?

I_SAFTJournalLineItem has 161 fields. Key fields: SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

DDL: I_SAFTJOURNALLINEITEM SQL: ISAFTJOURNALITM Type: view COMPOSITE

SAF-T Journal Item

I_SAFTJournalLineItem is a Composite CDS View that provides data about "SAF-T Journal Item" in SAP S/4HANA. It reads from 7 data sources and exposes 161 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 4 associations to related views.

Data Sources (7)

Source	Alias	Join Type
I_CFinBillingDocument	CFinBillingDocument	inner
I_CompanyCode	CompanyCode	inner
I_CompanyCode	CompanyCode	inner
I_GLAccountInCompanyCode	GLAccount	inner
I_GLAccountInCompanyCode	GLAccount	inner
I_JournalEntryItem	JournalEntryItem	from
I_JournalEntryItem	JournalEntryItem	union

Associations (4)

Cardinality	Target	Alias	Condition
[0..*]	I_TaxItem	_TaxItem	`_TaxItem.AccountingDocument = JournalEntryItem.AccountingDocument and _TaxItem.CompanyCode = JournalEntryItem.CompanyCode and _TaxItem.FiscalYear = JournalEntryItem.FiscalYear and _TaxItem.TaxCode = JournalEntryItem.TaxCode`
[0..*]	I_CFinPurchasingDocHistory	_CFinPurchasingDocHistory	`JournalEntryItem.ReferenceDocument = _CFinPurchasingDocHistory.CFinMaterialDocument and ( JournalEntryItem.ReferenceDocumentType = 'RMRP' or JournalEntryItem.ReferenceDocumentType = 'CF3PM' ) and JournalEntryItem.LogicalSystem = _CFinPurchasingDocHistory.SenderLogicalSystem`
[0..*]	I_CustomerToBusinessPartner	_CustomerToBP	`_CustomerToBP.Customer = JournalEntryItem.Customer`
[0..*]	I_SupplierToBusinessPartner	_SupplierToBP	`_SupplierToBP.Supplier = JournalEntryItem.Supplier`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	ISAFTJOURNALITM	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_INCLUDED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#COMPOSITE	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	SAF-T Journal Item	view

Fields (161)

Key	Field	Source Table	Source Field
KEY	SourceLedger	I_JournalEntryItem	SourceLedger
KEY	CompanyCode	I_JournalEntryItem	CompanyCode
KEY	FiscalYear	I_JournalEntryItem	FiscalYear
KEY	AccountingDocument	I_JournalEntryItem	AccountingDocument
KEY	LedgerGLLineItem	I_JournalEntryItem	LedgerGLLineItem
KEY	Ledger	I_JournalEntryItem	Ledger
	CompanyCodeCurrency	I_JournalEntryItem	CompanyCodeCurrency
	GLAccount	I_JournalEntryItem	GLAccount
	AlternativeGLAccount	I_JournalEntryItem	AlternativeGLAccount
	ChartOfAccounts	I_JournalEntryItem	ChartOfAccounts
	CountryChartOfAccounts	I_JournalEntryItem	CountryChartOfAccounts
	ReferenceDocument	I_JournalEntryItem	ReferenceDocument
	PostingDate	I_JournalEntryItem	PostingDate
	DocumentItemText	I_JournalEntryItem	DocumentItemText
	AmountInCompanyCodeCurrency	I_JournalEntryItem	AmountInCompanyCodeCurrency
	DebitCreditCode	I_JournalEntryItem	DebitCreditCode
	Customer	I_JournalEntryItem	Customer
	Supplier	I_JournalEntryItem	Supplier
	TaxCode	I_JournalEntryItem	TaxCode
	ReferenceDocumentType	I_JournalEntryItem	ReferenceDocumentType
	ReversalReferenceDocument	I_JournalEntryItem	ReversalReferenceDocument
	IsReversed	I_JournalEntryItem	IsReversed
	CostCenter	I_JournalEntryItem	CostCenter
	ControllingArea	I_JournalEntryItem	ControllingArea
	Quantity	I_JournalEntryItem	Quantity
	LogicalSystem	I_JournalEntryItem	LogicalSystem
	TransactionTypeDetermination	I_JournalEntryItem	TransactionTypeDetermination
	FinancialAccountType	I_JournalEntryItem	FinancialAccountType
	Country
	TaxCalculationProcedure
	OrderID	I_JournalEntryItem	OrderID
	PersonnelNumber	I_JournalEntryItem	PersonnelNumber
	AmountInTransactionCurrency	I_JournalEntryItem	AmountInTransactionCurrency
	WBSElement	I_JournalEntryItem	WBSElement
	TransactionCurrency	I_JournalEntryItem	TransactionCurrency
	ValueDate	I_JournalEntryItem	ValueDate
	AccountingDocumentItem	I_JournalEntryItem	AccountingDocumentItem
	IsReversal	I_JournalEntryItem	IsReversal
	SalesDocument	I_JournalEntryItem	SalesDocument
	SalesDocumentItem	I_JournalEntryItem	SalesDocumentItem
	InvoiceReference	I_JournalEntryItem	InvoiceReference
	InvoiceItemReference	I_JournalEntryItem	InvoiceItemReference
	InvoiceReferenceFiscalYear	I_JournalEntryItem	InvoiceReferenceFiscalYear
	DocumentReferenceID
	PaymentReference
	BillingDocument
	DueCalculationBaseDate	AcctgDocItem	DueCalculationBaseDate
	CashDiscount2Days	AcctgDocItem	CashDiscount2Days
	CashDiscount1Days	AcctgDocItem	CashDiscount1Days
	NetPaymentDays	AcctgDocItem	NetPaymentDays
	AccountingDocumentItemType	AcctgDocItem	AccountingDocumentItemType
	CentralFinanceBillingDocument	I_CFinBillingDocument	CentralFinanceBillingDocument
	CentralFinanceSalesDocument
	ReferenceSDDocument
	SDDocumentCategory	I_CFinBillingDocument	SDDocumentCategory
	ReconciliationAccountType	I_GLAccountInCompanyCode	ReconciliationAccountType
	SpecialGLCode	I_JournalEntryItem	SpecialGLCode
	ExchangeRate
	ReferenceDocumentContext	I_JournalEntryItem	ReferenceDocumentContext
	_TaxItem		_TaxItem
	_CustomerToBP		_CustomerToBP
	_SupplierToBP		_SupplierToBP
	_SourceLedger		_SourceLedger
	_CompanyCode	I_JournalEntryItem	_CompanyCode
	_FiscalYear		_FiscalYear
	_JournalEntry		_JournalEntry
	_Ledger		_Ledger
	_CompanyCodeCurrency		_CompanyCodeCurrency
	_GLAccountInChartOfAccounts		_GLAccountInChartOfAccounts
	_AlternativeGLAccount		_AlternativeGLAccount
	_ChartOfAccounts		_ChartOfAccounts
	_CountryChartOfAccounts		_CountryChartOfAccounts
	_Customer		_Customer
	_Supplier		_Supplier
	_CostCenter		_CostCenter
	_ControllingArea		_ControllingArea
	_LogicalSystem		_LogicalSystem
	_ReferenceDocumentType		_ReferenceDocumentType
	_DebitCreditCode		_DebitCreditCode
	_CFinPurchasingDocHistory		_CFinPurchasingDocHistory
	SourceLedgerasSourceLedger
KEY	CompanyCode	I_JournalEntryItem	CompanyCode
KEY	FiscalYear	I_JournalEntryItem	FiscalYear
KEY	AccountingDocument	I_JournalEntryItem	AccountingDocument
KEY	LedgerGLLineItem	I_JournalEntryItem	LedgerGLLineItem
KEY	Ledger	I_JournalEntryItem	Ledger
	CompanyCodeCurrency	I_JournalEntryItem	CompanyCodeCurrency
	GLAccount	I_JournalEntryItem	GLAccount
	AlternativeGLAccount	I_JournalEntryItem	AlternativeGLAccount
	ChartOfAccounts	I_JournalEntryItem	ChartOfAccounts
	CountryChartOfAccounts	I_JournalEntryItem	CountryChartOfAccounts
	ReferenceDocument	I_JournalEntryItem	ReferenceDocument
	PostingDate	I_JournalEntryItem	PostingDate
	DocumentItemText	I_JournalEntryItem	DocumentItemText
	AmountInCompanyCodeCurrency	I_JournalEntryItem	AmountInCompanyCodeCurrency
	DebitCreditCode	I_JournalEntryItem	DebitCreditCode
	Customer	I_JournalEntryItem	Customer
	Supplier	I_JournalEntryItem	Supplier
	TaxCode	I_JournalEntryItem	TaxCode
	ReferenceDocumentType	I_JournalEntryItem	ReferenceDocumentType
	ReversalReferenceDocument	I_JournalEntryItem	ReversalReferenceDocument
	IsReversed	I_JournalEntryItem	IsReversed
	CostCenter	I_JournalEntryItem	CostCenter
	ControllingArea	I_JournalEntryItem	ControllingArea
	Quantity	I_JournalEntryItem	Quantity
	LogicalSystem	I_JournalEntryItem	LogicalSystem
	TransactionTypeDetermination	I_JournalEntryItem	TransactionTypeDetermination
	FinancialAccountType	I_JournalEntryItem	FinancialAccountType
	Country
	TaxCalculationProcedure
	OrderID	I_JournalEntryItem	OrderID
	PersonnelNumber	I_JournalEntryItem	PersonnelNumber
	AmountInTransactionCurrency	I_JournalEntryItem	AmountInTransactionCurrency
	WBSElement	I_JournalEntryItem	WBSElement
	TransactionCurrency	I_JournalEntryItem	TransactionCurrency
	ValueDate	I_JournalEntryItem	ValueDate
	AccountingDocumentItem	I_JournalEntryItem	AccountingDocumentItem
	IsReversal	I_JournalEntryItem	IsReversal
	SalesDocument	I_JournalEntryItem	SalesDocument
	SalesDocumentItem	I_JournalEntryItem	SalesDocumentItem
	InvoiceReference	I_JournalEntryItem	InvoiceReference
	InvoiceItemReference	I_JournalEntryItem	InvoiceItemReference
	InvoiceReferenceFiscalYear	I_JournalEntryItem	InvoiceReferenceFiscalYear
	DocumentReferenceID
	PaymentReference
	BillingDocument
	DueCalculationBaseDate	AcctgDocItem	DueCalculationBaseDate
	CashDiscount2Days	AcctgDocItem	CashDiscount2Days
	CashDiscount1Days	AcctgDocItem	CashDiscount1Days
	NetPaymentDays	AcctgDocItem	NetPaymentDays
	AccountingDocumentItemType	AcctgDocItem	AccountingDocumentItemType
	CentralFinanceBillingDocument
	CentralFinanceSalesDocument
	ReferenceSDDocument
	SDDocumentCategory
	ReconciliationAccountType	I_GLAccountInCompanyCode	ReconciliationAccountType
	SpecialGLCode	I_JournalEntryItem	SpecialGLCode
	ExchangeRate
	ReferenceDocumentContext	I_JournalEntryItem	ReferenceDocumentContext
	_TaxItem		_TaxItem
	_CustomerToBP		_CustomerToBP
	_SupplierToBP		_SupplierToBP
	_SourceLedger		_SourceLedger
	_CompanyCode	I_JournalEntryItem	_CompanyCode
	_FiscalYear		_FiscalYear
	_JournalEntry		_JournalEntry
	_Ledger		_Ledger
	_CompanyCodeCurrency		_CompanyCodeCurrency
	_GLAccountInChartOfAccounts		_GLAccountInChartOfAccounts
	_AlternativeGLAccount		_AlternativeGLAccount
	_ChartOfAccounts		_ChartOfAccounts
	_CountryChartOfAccounts		_CountryChartOfAccounts
	_Customer		_Customer
	_Supplier		_Supplier
	_CostCenter		_CostCenter
	_ControllingArea		_ControllingArea
	_LogicalSystem		_LogicalSystem
	_ReferenceDocumentType		_ReferenceDocumentType
	_DebitCreditCode		_DebitCreditCode
	_CFinPurchasingDocHistory		_CFinPurchasingDocHistory
	_Order		_Order

@AbapCatalog.sqlViewName: 'ISAFTJOURNALITM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'SAF-T Journal Item'
define view I_SAFTJournalLineItem
  as select from           I_JournalEntryItem        as JournalEntryItem

    inner join             I_CFinBillingDocument     as CFinBillingDocument on  CFinBillingDocument.CentralFinanceBillingDocument = JournalEntryItem.ReferenceDocument
                                                                            and CFinBillingDocument.SenderLogicalSystem           = JournalEntryItem.LogicalSystem
                                                                            and CFinBillingDocument.CompanyCode                   = JournalEntryItem.CompanyCode

    inner join             I_GLAccountInCompanyCode  as GLAccount           on  GLAccount.GLAccount   = JournalEntryItem.GLAccount
                                                                            and GLAccount.CompanyCode = JournalEntryItem.CompanyCode

    inner join             I_CompanyCode             as CompanyCode         on CompanyCode.CompanyCode = JournalEntryItem.CompanyCode

    left outer to one join I_OperationalAcctgDocItem as AcctgDocItem        on  AcctgDocItem.CompanyCode            = JournalEntryItem.CompanyCode
                                                                            and AcctgDocItem.FiscalYear             = JournalEntryItem.FiscalYear
                                                                            and AcctgDocItem.AccountingDocument     = JournalEntryItem.AccountingDocument
                                                                            and AcctgDocItem.AccountingDocumentItem = JournalEntryItem.AccountingDocumentItem

  association [0..*] to I_TaxItem                   as _TaxItem                  on  _TaxItem.AccountingDocument = JournalEntryItem.AccountingDocument
                                                                                 and _TaxItem.CompanyCode        = JournalEntryItem.CompanyCode
                                                                                 and _TaxItem.FiscalYear         = JournalEntryItem.FiscalYear
                                                                                 and _TaxItem.TaxCode            = JournalEntryItem.TaxCode

  association [0..*] to I_CFinPurchasingDocHistory  as _CFinPurchasingDocHistory on  JournalEntryItem.ReferenceDocument       = _CFinPurchasingDocHistory.CFinMaterialDocument
                                                                                 and (
                                                                                    JournalEntryItem.ReferenceDocumentType    = 'RMRP'
                                                                                    or JournalEntryItem.ReferenceDocumentType = 'CF3PM'
                                                                                  )
                                                                                 and JournalEntryItem.LogicalSystem           = _CFinPurchasingDocHistory.SenderLogicalSystem

  association [0..*] to I_CustomerToBusinessPartner as _CustomerToBP             on  _CustomerToBP.Customer = JournalEntryItem.Customer
  association [0..*] to I_SupplierToBusinessPartner as _SupplierToBP             on  _SupplierToBP.Supplier = JournalEntryItem.Supplier


{
      @ObjectModel.foreignKey.association: '_SourceLedger'
  key JournalEntryItem.SourceLedger                                      as SourceLedger,
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key JournalEntryItem.CompanyCode                                       as CompanyCode,
      @ObjectModel.foreignKey.association: '_FiscalYear'
  key JournalEntryItem.FiscalYear                                        as FiscalYear,
      @ObjectModel.foreignKey.association: '_JournalEntry'
  key JournalEntryItem.AccountingDocument                                as AccountingDocument,
  key JournalEntryItem.LedgerGLLineItem                                  as LedgerGLLineItem,
      @ObjectModel.foreignKey.association: '_Ledger'
  key JournalEntryItem.Ledger                                            as Ledger,

      @Semantics.currencyCode: true
      JournalEntryItem.CompanyCodeCurrency,
      @ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
      JournalEntryItem.GLAccount                                         as GLAccount,
      @ObjectModel.foreignKey.association: '_AlternativeGLAccount'
      JournalEntryItem.AlternativeGLAccount                              as AlternativeGLAccount,
      @ObjectModel.foreignKey.association: '_ChartOfAccounts'
      JournalEntryItem.ChartOfAccounts                                   as ChartOfAccounts,
      @ObjectModel.foreignKey.association: '_CountryChartOfAccounts'
      JournalEntryItem.CountryChartOfAccounts                            as CountryChartOfAccounts,
      JournalEntryItem.ReferenceDocument                                 as ReferenceDocument,
      JournalEntryItem.PostingDate                                       as PostingDate,
      JournalEntryItem.DocumentItemText                                  as DocumentItemText,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      JournalEntryItem.AmountInCompanyCodeCurrency                       as AmountInCompanyCodeCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      case
        when JournalEntryItem.DebitCreditCode = 'H'
         then abs(JournalEntryItem.AmountInCompanyCodeCurrency)
          else 0
       end                                                               as DebitAmountInCoCodeCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      case
        when JournalEntryItem.DebitCreditCode = 'S'
         then abs(JournalEntryItem.AmountInCompanyCodeCurrency)
          else 0
       end                                                               as CreditAmountInCoCodeCrcy,

      @ObjectModel.foreignKey.association: '_DebitCreditCode'
      JournalEntryItem.DebitCreditCode                                   as DebitCreditCode,
      @ObjectModel.foreignKey.association: '_Customer'
      JournalEntryItem.Customer                                          as Customer,
      @ObjectModel.foreignKey.association: '_Supplier'
      JournalEntryItem.Supplier                                          as Supplier,
      JournalEntryItem.TaxCode                                           as TaxCode,

      @ObjectModel.foreignKey.association: '_ReferenceDocumentType'
      JournalEntryItem.ReferenceDocumentType,
      JournalEntryItem.ReversalReferenceDocument,
      JournalEntryItem.IsReversed,
      @ObjectModel.foreignKey.association: '_CostCenter'
      JournalEntryItem.CostCenter                                        as CostCenter,
      @ObjectModel.foreignKey.association: '_ControllingArea'
      JournalEntryItem.ControllingArea                                   as ControllingArea,
      JournalEntryItem.Quantity                                          as Quantity,

      @ObjectModel.foreignKey.association: '_LogicalSystem'
      JournalEntryItem.LogicalSystem                                     as LogicalSystem,

      JournalEntryItem.TransactionTypeDetermination                      as TransactionTypeDetermination,
      JournalEntryItem.FinancialAccountType                              as FinancialAccountType,
      JournalEntryItem._CompanyCode.Country                              as Country,

      JournalEntryItem._CompanyCode._Country.TaxCalculationProcedure,
      @ObjectModel.foreignKey.association: '_Order'
      JournalEntryItem.OrderID,
      JournalEntryItem.PersonnelNumber,
      JournalEntryItem.AmountInTransactionCurrency,
      JournalEntryItem.WBSElement,
      JournalEntryItem.TransactionCurrency,
      JournalEntryItem.ValueDate,
      JournalEntryItem.AccountingDocumentItem,
      JournalEntryItem.IsReversal,
      JournalEntryItem.SalesDocument,
      JournalEntryItem.SalesDocumentItem,
      JournalEntryItem.InvoiceReference,
      JournalEntryItem.InvoiceItemReference,
      JournalEntryItem.InvoiceReferenceFiscalYear,
      JournalEntryItem._JournalEntry.DocumentReferenceID,

      coalesce(AcctgDocItem.PaymentReference, ' ')                       as PaymentReference,
      coalesce(AcctgDocItem.BillingDocument, ' ')                        as BillingDocument,
      AcctgDocItem.DueCalculationBaseDate,
      AcctgDocItem.CashDiscount2Days,
      AcctgDocItem.CashDiscount1Days,
      AcctgDocItem.NetPaymentDays,
      AcctgDocItem.AccountingDocumentItemType,

      //CFin fields

      CFinBillingDocument.CentralFinanceBillingDocument,
      CFinBillingDocument._Item.CentralFinanceSalesDocument,
      CFinBillingDocument._Item.ReferenceSDDocument,
      CFinBillingDocument.SDDocumentCategory,

      GLAccount.ReconciliationAccountType,
      JournalEntryItem.SpecialGLCode,
      cast( JournalEntryItem._JournalEntry.ExchangeRate as  cade_kursf ) as ExchangeRate,
      JournalEntryItem.ReferenceDocumentContext,

      //Associations

      _TaxItem,
      _CustomerToBP,
      _SupplierToBP,
      _SourceLedger,
      JournalEntryItem._CompanyCode,
      _FiscalYear,
      _JournalEntry,
      _Ledger,
      _CompanyCodeCurrency,
      _GLAccountInChartOfAccounts,
      _AlternativeGLAccount,
      _ChartOfAccounts,
      _CountryChartOfAccounts,
      _Customer,
      _Supplier,
      _CostCenter,
      _ControllingArea,
      _LogicalSystem,
      _ReferenceDocumentType,
      _DebitCreditCode,
      _CFinPurchasingDocHistory,
      _Order

}
where
      JournalEntryItem.ReferenceDocumentType =  'VBRK'
  and CompanyCode.Country                    <> 'PT'

union

select from              I_JournalEntryItem        as JournalEntryItem

  inner join             I_GLAccountInCompanyCode  as GLAccount    on  GLAccount.GLAccount   = JournalEntryItem.GLAccount
                                                                   and GLAccount.CompanyCode = JournalEntryItem.CompanyCode

  inner join             I_CompanyCode             as CompanyCode  on CompanyCode.CompanyCode = JournalEntryItem.CompanyCode

  left outer to one join I_OperationalAcctgDocItem as AcctgDocItem on  AcctgDocItem.CompanyCode            = JournalEntryItem.CompanyCode
                                                                   and AcctgDocItem.FiscalYear             = JournalEntryItem.FiscalYear
                                                                   and AcctgDocItem.AccountingDocument     = JournalEntryItem.AccountingDocument
                                                                   and AcctgDocItem.AccountingDocumentItem = JournalEntryItem.AccountingDocumentItem


association [0..*] to I_TaxItem                   as _TaxItem                  on  _TaxItem.AccountingDocument = JournalEntryItem.AccountingDocument
                                                                               and _TaxItem.CompanyCode        = JournalEntryItem.CompanyCode
                                                                               and _TaxItem.FiscalYear         = JournalEntryItem.FiscalYear
                                                                               and _TaxItem.TaxCode            = JournalEntryItem.TaxCode


association [0..*] to I_CFinPurchasingDocHistory  as _CFinPurchasingDocHistory on  JournalEntryItem.ReferenceDocument       = _CFinPurchasingDocHistory.CFinMaterialDocument
                                                                               and (
                                                                                  JournalEntryItem.ReferenceDocumentType    = 'RMRP'
                                                                                  or JournalEntryItem.ReferenceDocumentType = 'CF3PM'
                                                                                )
                                                                               and JournalEntryItem.LogicalSystem           = _CFinPurchasingDocHistory.SenderLogicalSystem

association [0..*] to I_CustomerToBusinessPartner as _CustomerToBP             on  _CustomerToBP.Customer = JournalEntryItem.Customer
association [0..*] to I_SupplierToBusinessPartner as _SupplierToBP             on  _SupplierToBP.Supplier = JournalEntryItem.Supplier


{
      @ObjectModel.foreignKey.association: '_SourceLedger'
  key JournalEntryItem.SourceLedger                                      as SourceLedger,
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key JournalEntryItem.CompanyCode                                       as CompanyCode,
      @ObjectModel.foreignKey.association: '_FiscalYear'
  key JournalEntryItem.FiscalYear                                        as FiscalYear,
      @ObjectModel.foreignKey.association: '_JournalEntry'
  key JournalEntryItem.AccountingDocument                                as AccountingDocument,
  key JournalEntryItem.LedgerGLLineItem                                  as LedgerGLLineItem,
      @ObjectModel.foreignKey.association: '_Ledger'
  key JournalEntryItem.Ledger                                            as Ledger,

      @Semantics.currencyCode: true
      JournalEntryItem.CompanyCodeCurrency,
      @ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
      JournalEntryItem.GLAccount                                         as GLAccount,
      @ObjectModel.foreignKey.association: '_AlternativeGLAccount'
      JournalEntryItem.AlternativeGLAccount                              as AlternativeGLAccount,
      @ObjectModel.foreignKey.association: '_ChartOfAccounts'
      JournalEntryItem.ChartOfAccounts                                   as ChartOfAccounts,
      @ObjectModel.foreignKey.association: '_CountryChartOfAccounts'
      JournalEntryItem.CountryChartOfAccounts                            as CountryChartOfAccounts,
      JournalEntryItem.ReferenceDocument                                 as ReferenceDocument,
      JournalEntryItem.PostingDate                                       as PostingDate,
      JournalEntryItem.DocumentItemText                                  as DocumentItemText,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      JournalEntryItem.AmountInCompanyCodeCurrency                       as AmountInCompanyCodeCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      case
        when JournalEntryItem.DebitCreditCode = 'H'
         then abs(JournalEntryItem.AmountInCompanyCodeCurrency)
          else 0
       end                                                               as DebitAmountInCoCodeCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      case
        when JournalEntryItem.DebitCreditCode = 'S'
         then abs(JournalEntryItem.AmountInCompanyCodeCurrency)
          else 0
       end                                                               as CreditAmountInCoCodeCrcy,

      @ObjectModel.foreignKey.association: '_DebitCreditCode'
      JournalEntryItem.DebitCreditCode                                   as DebitCreditCode,
      @ObjectModel.foreignKey.association: '_Customer'
      JournalEntryItem.Customer                                          as Customer,
      @ObjectModel.foreignKey.association: '_Supplier'
      JournalEntryItem.Supplier                                          as Supplier,
      JournalEntryItem.TaxCode                                           as TaxCode,

      @ObjectModel.foreignKey.association: '_ReferenceDocumentType'
      JournalEntryItem.ReferenceDocumentType,
      JournalEntryItem.ReversalReferenceDocument,
      JournalEntryItem.IsReversed,
      @ObjectModel.foreignKey.association: '_CostCenter'
      JournalEntryItem.CostCenter                                        as CostCenter,
      @ObjectModel.foreignKey.association: '_ControllingArea'
      JournalEntryItem.ControllingArea                                   as ControllingArea,
      JournalEntryItem.Quantity                                          as Quantity,

      @ObjectModel.foreignKey.association: '_LogicalSystem'
      JournalEntryItem.LogicalSystem                                     as LogicalSystem,
      JournalEntryItem.TransactionTypeDetermination                      as TransactionTypeDetermination,
      JournalEntryItem.FinancialAccountType                              as FinancialAccountType,
      JournalEntryItem._CompanyCode.Country                              as Country,

      JournalEntryItem._CompanyCode._Country.TaxCalculationProcedure,
      @ObjectModel.foreignKey.association: '_Order'
      JournalEntryItem.OrderID,
      JournalEntryItem.PersonnelNumber,
      JournalEntryItem.AmountInTransactionCurrency,
      JournalEntryItem.WBSElement,
      JournalEntryItem.TransactionCurrency,
      JournalEntryItem.ValueDate,
      JournalEntryItem.AccountingDocumentItem,
      JournalEntryItem.IsReversal,
      JournalEntryItem.SalesDocument,
      JournalEntryItem.SalesDocumentItem,
      JournalEntryItem.InvoiceReference,
      JournalEntryItem.InvoiceItemReference,
      JournalEntryItem.InvoiceReferenceFiscalYear,
      JournalEntryItem._JournalEntry.DocumentReferenceID,

      coalesce(AcctgDocItem.PaymentReference, ' ')                       as PaymentReference,
      coalesce(AcctgDocItem.BillingDocument, ' ')                        as BillingDocument,
      AcctgDocItem.DueCalculationBaseDate,
      AcctgDocItem.CashDiscount2Days,
      AcctgDocItem.CashDiscount1Days,
      AcctgDocItem.NetPaymentDays,
      AcctgDocItem.AccountingDocumentItemType,

      //CFin fields

      ' '                                                                as CentralFinanceBillingDocument,
      ' '                                                                as CentralFinanceSalesDocument,
      ' '                                                                as ReferenceSDDocument,
      ' '                                                                as SDDocumentCategory,

      GLAccount.ReconciliationAccountType,
      JournalEntryItem.SpecialGLCode,
      cast( JournalEntryItem._JournalEntry.ExchangeRate as  cade_kursf ) as ExchangeRate,
      JournalEntryItem.ReferenceDocumentContext,

      //Associations

      _TaxItem,
      _CustomerToBP,
      _SupplierToBP,
      _SourceLedger,
      JournalEntryItem._CompanyCode,
      _FiscalYear,
      _JournalEntry,
      _Ledger,
      _CompanyCodeCurrency,
      _GLAccountInChartOfAccounts,
      _AlternativeGLAccount,
      _ChartOfAccounts,
      _CountryChartOfAccounts,
      _Customer,
      _Supplier,
      _CostCenter,
      _ControllingArea,
      _LogicalSystem,
      _ReferenceDocumentType,
      _DebitCreditCode,
      _CFinPurchasingDocHistory,
      _Order
}
where
     JournalEntryItem.ReferenceDocumentType <> 'VBRK'
  or CompanyCode.Country                    =  'PT'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CFINBILLINGDOCUMENT",
"I_CFINBILLINGDOCUMENTITEM",
"I_COMPANYCODE",
"I_COUNTRY",
"I_GLACCOUNTINCOMPANYCODE",
"I_JOURNALENTRY",
"I_JOURNALENTRYITEM",
"I_OPERATIONALACCTGDOCITEM"
],
"ASSOCIATED":
[
"I_CFINPURCHASINGDOCHISTORY",
"I_CHARTOFACCOUNTS",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_CURRENCY",
"I_CUSTOMER",
"I_CUSTOMERTOBUSINESSPARTNER",
"I_DEBITCREDITCODE",
"I_FISCALYEARFORCOMPANYCODE",
"I_GLACCOUNTINCHARTOFACCOUNTS",
"I_JOURNALENTRY",
"I_LEDGER",
"I_LOGICALSYSTEM",
"I_ORDER",
"I_REFERENCEDOCUMENTTYPE",
"I_SUPPLIER",
"I_SUPPLIERTOBUSINESSPARTNER",
"I_TAXITEM"
],
"BASE":
[
"I_JOURNALENTRYITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_SAFTJournalLineItem view