I_SuplrInvcItemLogsUnion

SI Item union of batch and online items | view: ISIITMLOGUNION | TRAN | Extraction: Not supported | Component: Logistics Invoice Verification
Tables used: RBKPRBKPBRBDRSEGRSEG
Column Name Description
SupplierInvoice Document Number of an Accounting Document
FiscalYear Fiscal Year
SupplierInvoiceItem Document Item in Invoice Document
Column Name Description
💲 Currency Key (DocumentCurrency):
SupplierInvoiceItemAmount Amount in Document Currency
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
QuantityInPurchaseOrderUnit Quantity
📏 Order Price Unit (Purchasing) (PurchaseOrderPriceUnit):
QtyInPurchaseOrderPriceUnit Quantity in Purchase Order Price Unit
Column Name Description
Column Name Description
DebitCreditCode Debit/Credit Indicator Show values
IsNotCashDiscountLiable Indicator: Line Item Not Liable to Cash Discount? Show values
SuplrInvcItemHasPriceVariance Blocking Reason: Price Show values
SuplrInvcItemHasQtyVariance Blocking Reason: Quantity Show values
SuplrInvcItemHasDateVariance Blocking Reason: Date Show values
SuplrInvcItemHasOrdPrcQtyVarc Blocking Reason: Order Price Quantity Show values
SuplrInvcItemHasOtherVariance Manual Blocking Reason Show values
SuplrInvcItemHasAmountOutsdTol Blocking Reason: Item Amount Show values
SuplrInvcItmHasQualityVariance Blocking Reason: Quality Show values
Column Name Description Domain name
SupplierInvoiceItemText Item Text TEXT50
SuplrInvcDeliveryCostCndnType Condition Type KSCHL
SuplrInvcDeliveryCostCndnStep Step Number STUNR
SuplrInvcDeliveryCostCndnCount Condition Counter ZAEHK
IsSubsequentDebitCredit Indicator: Subsequent Debit/Credit TBTKZ
ReferenceDocument Document No. of a Reference Document BELNR
ReferenceDocumentFiscalYear Fiscal Year of Current Period GJAHR
ReferenceDocumentItem Item of a Reference Document MBLPO
PurchaseContract Number of principal purchase agreement EBELN
PurchaseContractItem Item number of principal purchase agreement EBELP
FreightSupplier Account Number of Supplier LIFNR
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_SUPLRINVCITEMLOGSUNION.COMPANYCODE == T001.BUKRS
  • I_SUPLRINVCITEMLOGSUNION.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • I_SUPLRINVCITEMLOGSUNION.MANDT == TCURC.MANDT
  • I_SUPLRINVCITEMLOGSUNION.DOCUMENTCURRENCY == TCURC.WAERS
Plant
  • Client
  • Plant
  • I_SUPLRINVCITEMLOGSUNION.MANDT == T001W.MANDT
  • I_SUPLRINVCITEMLOGSUNION.PLANT == T001W.WERKS
Material Number
  • Client
  • Material Number
  • I_SUPLRINVCITEMLOGSUNION.MANDT == MARA.MANDT
  • I_SUPLRINVCITEMLOGSUNION.PURCHASEORDERITEMMATERIAL == MARA.MATNR
Order Price Unit (Purchasing)
  • Client
  • Order Price Unit (Purchasing)
  • I_SUPLRINVCITEMLOGSUNION.MANDT == T006.MANDT
  • I_SUPLRINVCITEMLOGSUNION.PURCHASEORDERPRICEUNIT == T006.MSEHI
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • I_SUPLRINVCITEMLOGSUNION.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • I_SUPLRINVCITEMLOGSUNION.MANDT == T006.MANDT
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • I_SUPLRINVCITEMLOGSUNION.MANDT == T163.MANDT
  • I_SUPLRINVCITEMLOGSUNION.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Tax on sales/purchases code
  • Client
  • ?
  • Tax on sales/purchases code
  • I_SUPLRINVCITEMLOGSUNION.MANDT == T007A.MANDT
  • I_SUPLRINVCITEMLOGSUNION.[column in domain "KALSM_D"] == T007A.KALSM
  • I_SUPLRINVCITEMLOGSUNION.TAXCODE == T007A.MWSKZ
Tax Jurisdiction
  • Client
  • ?
  • Tax Jurisdiction
  • I_SUPLRINVCITEMLOGSUNION.MANDT == TTXJ.MANDT
  • I_SUPLRINVCITEMLOGSUNION.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • I_SUPLRINVCITEMLOGSUNION.TAXJURISDICTION == TTXJ.TXJCD