I_IE_InvcGeneralLedgerItem

DDL: I_IE_INVCGENERALLEDGERITEM Type: view_entity COMPOSITE Package: GLO_FIN_IS_IE_AP

ERR GL Item

I_IE_InvcGeneralLedgerItem is a Composite CDS View that provides data about "ERR GL Item" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 12 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem. Part of development package GLO_FIN_IS_IE_AP.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label ERR GL Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem
GLAccount I_OperationalAcctgDocItem GLAccount
PostingDate I_OperationalAcctgDocItem PostingDate
CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency
AmountInCompanyCodeCurrency I_OperationalAcctgDocItem AmountInCompanyCodeCurrency
PersonnelNumber I_OperationalAcctgDocItem PersonnelNumber
AssignmentReference I_OperationalAcctgDocItem AssignmentReference
ExpenseTypeCategory Mapping ExpenseTypeCategory
ExpenseTypeSubcategory Mapping ExpenseTypeSubcategory 
@VDM.viewType: #COMPOSITE
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'ERR GL Item'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED

define view entity I_IE_InvcGeneralLedgerItem as select from I_OperationalAcctgDocItem

  inner many to one join I_IE_ExpenseTypeAssignment as Mapping 
    on  Mapping.CompanyCode = I_OperationalAcctgDocItem.CompanyCode
    and Mapping.GLAccount   = I_OperationalAcctgDocItem.GLAccount

{
  key I_OperationalAcctgDocItem.CompanyCode,
  key I_OperationalAcctgDocItem.FiscalYear,
  key I_OperationalAcctgDocItem.AccountingDocument,
  key I_OperationalAcctgDocItem.AccountingDocumentItem,
      I_OperationalAcctgDocItem.GLAccount,
      I_OperationalAcctgDocItem.PostingDate,
      I_OperationalAcctgDocItem.CompanyCodeCurrency,
      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      I_OperationalAcctgDocItem.AmountInCompanyCodeCurrency,
      I_OperationalAcctgDocItem.PersonnelNumber,
      I_OperationalAcctgDocItem.AssignmentReference,
      Mapping.ExpenseTypeCategory,
      Mapping.ExpenseTypeSubcategory
}

where
  I_OperationalAcctgDocItem.FinancialAccountType           =  'S'
  and I_OperationalAcctgDocItem.AccountingDocumentCategory <> 'D'
  and I_OperationalAcctgDocItem.AccountingDocumentCategory <> 'M'
// Expense reports created from Concur have a specific reference document type

  and I_OperationalAcctgDocItem._JournalEntry.ReferenceDocumentType = 'CTE'

Learn More