I_DuplicateSupplierInvoice

Suspicious Duplicate Supplier Invoices | view: ISUPPLIERINVOIDS | TRAN | Extraction: Not supported | Component: Fiori UI for Accounts Payable
Tables used: ACDOCAEKKORBKPT003TT001TKA02LFA1T077YUSR21
Column Name Description
SupplierInvoice Document Number of an Invoice Document
PurchaseOrder Purchasing Document Number
Column Name Description
💲 Currency Key (DocumentCurrency):
InvoiceAmountInInvoiceDocCrcy Gross Invoice Amount in Document Currency
💲 null (ReportingCurrency):
InvoiceAmountInTransactionCrcy null
Column Name Description
Column Name Description
DocumentDate Invoice Date in Document
PostingDate Posting Date in the Document
CurrentDate null
Column Name Description
Column Name Description Domain name
AccountingDocument Document Number of an Accounting Document BELNR
FiscalYear Fiscal Year GJAHR
AccountingDocumentTypeName Document Type Name TEXT20
PostingPeriod Posting period POPER
FiscalYearPeriod null
CompanyCodeName Name of Company Code or Company TEXT25
CreatedByUser Name of the Processor Who Entered the Object USNAM
LastChangedByUser User Name XUBNAME
SupplierAccountGroupName Account Group Name TEXT30
SupplierName Name 1 NAME
CreatedByUserName User Description SUIDTECHDESC
ChangedByUserName User Description SUIDTECHDESC
ClearingDocumentNumber Document Number of the Clearing Document BELNR
ItemDescription Item Text TEXT50
AccountingDocExternalReference Reference Document Number XBLNR1
Master Data Relations Join Conditions
Document Type
  • Document Type
  • Client
  • I_DUPLICATESUPPLIERINVOICE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_DUPLICATESUPPLIERINVOICE.MANDT == T003.MANDT
Company Code
  • Company Code
  • Client
  • I_DUPLICATESUPPLIERINVOICE.COMPANYCODE == T001.BUKRS
  • I_DUPLICATESUPPLIERINVOICE.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • I_DUPLICATESUPPLIERINVOICE.DOCUMENTCURRENCY == TCURC.WAERS
  • I_DUPLICATESUPPLIERINVOICE.MANDT == TCURC.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • I_DUPLICATESUPPLIERINVOICE.SUPPLIER == LFA1.LIFNR
  • I_DUPLICATESUPPLIERINVOICE.MANDT == LFA1.MANDT
Vendor account group
  • Vendor account group
  • Client
  • I_DUPLICATESUPPLIERINVOICE.SUPPLIERACCOUNTGROUP == T077K.KTOKK
  • I_DUPLICATESUPPLIERINVOICE.MANDT == T077K.MANDT