I_SuplrInvcItmQtyVarianceTrain

Supplier Invoice Items with Quantity Variance ML Training | view: ISIQTYVARTRAIN | TRAN | Extraction: Not supported | Component: General Functions
Tables used: CDHDR, RBKP, EKKO, EKPO, RSEG, BSEG, CDPOS, CDPOS
Column Name Description
SupplierInvoice Document Number of an Accounting Document
FiscalYear Fiscal Year
SupplierInvoiceItem Document Item in Invoice Document
Column Name Description
SupplierInvoiceItemAmount Amount in Document Currency
AmountAsPerInvoicingParty Invoice Amount in Document Currency of Supplier Invoice
RetentionAmountInDocCurrency Retention Amount in Document Currency
DownPaymentAmount Down Payment Amount in Document Currency
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
Quantity Quantity
QuantityAsPerInvoicingParty Quantity Invoiced in Supplier Invoice in PO Order Units
📏 Order Price Unit (Purchasing) (PurchaseOrderPriceUnit):
QtyInPurchaseOrderPriceUnit Quantity in Purchase Order Price Unit
Column Name Description
RetentionDueDate Due Date for Retention
CreationDate Day On Which Accounting Document Was Entered
CreationTime Time of Entry
DueCalculationBaseDate Baseline Date for Due Date Calculation
PurchaseOrderCreationDate Creation Date of Purchasing Document
PurchaseOrderDate Purchasing Document Date
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
DownPaymentDueDate Due Date for Down Payment
EarliestCashDiscountDate Field of type DATS
Column Name Description
DebitCreditCode Debit/Credit Indicator Show values
SuplrInvcItemHasPriceVariance Blocking Reason: Price Show values
SuplrInvcItemHasDateVariance Blocking Reason: Date Show values
SuplrInvcItemHasOrdPrcQtyVarc Blocking Reason: Order Price Quantity Show values
SuplrInvcItemHasProjBdgtVarc Blocking Reason: Project Budget Show values
SuplrInvcItemHasOtherVariance Manual Blocking Reason Show values
SuplrInvcItemHasAmountOutsdTol Blocking Reason: Item Amount Show values
SuplrInvcItmHasQualityVariance Blocking Reason: Quality Show values
IsLIFOAndFIFORelevant LIFO/FIFO-Relevant Show values
SuplrInvcVerificatSuplrErrType Type of Supplier Error Show values
SuplrInvcItemCorrectionInd Correction indicator Show values
SuplrInvcItemHasQtyVariance Blocking Reason: Quantity Show values
Column Name Description Domain name
IsSubsequentDebitCredit Indicator: Subsequent Debit/Credit TBTKZ
StockIdentifyingMaterial Material in Respect of Which Stock is Managed MATNR
SupplierPostingLineItemText Item Text TEXT50
SupplierInvoiceComplaintReason Complaints Reason in an Invoice COMPLAINT_REASON
RetentionPercentage Retention in Percent PRZ32
ProductType Product Type Group CHAR2
StockSegment Stock Segment SGT_SRCA
PaymentTerms Terms of payment key ZTERM
CashDiscount1Days Cash discount days 1 ZBDXT
CashDiscount1Percent Cash discount percentage 1 PRZ23
CashDiscount2Days Cash discount days 2 ZBDXT
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
NetPaymentDays Net Payment Terms Period ZBDXT
IncotermsPart2 Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
DownPaymentType Down Payment Indicator ME_DPTYPE_DOMAIN
DownPaymentPercentageOfTotAmt Down Payment Percentage PRZ32
ShippingType Shipping Type VERSART
ShippingCondition Shipping Conditions VSBED
DaysSuplrInvcCrtnToCshDiscDte Days Between Invoice Creation and Cash Discount Date INT4
SuplrInvcIsGROnTimeForCashDisc null
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MANDT == T163K.MANDT
  • I_SUPLRINVCITMQTYVARIANCETRAIN.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Company Code
  • Company Code
  • Client
  • I_SUPLRINVCITMQTYVARIANCETRAIN.COMPANYCODE == T001.BUKRS
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MANDT == T001.MANDT
Customer Number
  • Client
  • Customer Number
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MANDT == KNA1.MANDT
  • I_SUPLRINVCITMQTYVARIANCETRAIN.CUSTOMER == KNA1.KUNNR
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MANDT == TINC.MANDT
  • I_SUPLRINVCITMQTYVARIANCETRAIN.INCOTERMSPART1 == TINC.INCO1
Valuation Type
  • Client
  • Valuation Type
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MANDT == T149D.MANDT
  • I_SUPLRINVCITMQTYVARIANCETRAIN.INVENTORYVALUATIONTYPE == T149D.BWTAR
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MANDT == LFA1.MANDT
  • I_SUPLRINVCITMQTYVARIANCETRAIN.INVOICINGPARTY == LFA1.LIFNR
Material Number
  • Client
  • Material Number
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MANDT == MARA.MANDT
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MATERIAL == MARA.MATNR
Valuation Class
  • Client
  • Valuation Class
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MANDT == T025.MANDT
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MATERIALVALUATIONCLASS == T025.BKLAS
Order Price Unit (Purchasing)
  • Client
  • Order Price Unit (Purchasing)
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MANDT == T006.MANDT
  • I_SUPLRINVCITMQTYVARIANCETRAIN.PURCHASEORDERPRICEUNIT == T006.MSEHI
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MANDT == T006.MANDT
  • I_SUPLRINVCITMQTYVARIANCETRAIN.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MANDT == T163.MANDT
  • I_SUPLRINVCITMQTYVARIANCETRAIN.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • I_SUPLRINVCITMQTYVARIANCETRAIN.PURCHASINGGROUP == T024.EKGRP
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MANDT == T024E.MANDT
  • I_SUPLRINVCITMQTYVARIANCETRAIN.PURCHASINGORGANIZATION == T024E.EKORG
Plant
  • Client
  • Plant
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MANDT == T001W.MANDT
  • I_SUPLRINVCITMQTYVARIANCETRAIN.RECEIVINGPLANT == T001W.WERKS
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MANDT == LFA1.MANDT
  • I_SUPLRINVCITMQTYVARIANCETRAIN.SUPPLIER == LFA1.LIFNR
Goods Supplier
  • Client
  • Goods Supplier
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MANDT == LFA1.MANDT
  • I_SUPLRINVCITMQTYVARIANCETRAIN.SUPPLYINGSUPPLIER == LFA1.LIFNR
Tax on sales/purchases code
  • Client
  • Tax on sales/purchases code
  • ?
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MANDT == T007A.MANDT
  • I_SUPLRINVCITMQTYVARIANCETRAIN.TAXCODE == T007A.MWSKZ
  • I_SUPLRINVCITMQTYVARIANCETRAIN.[column in domain "KALSM_D"] == T007A.KALSM
Tax Jurisdiction
  • Client
  • Tax Jurisdiction
  • ?
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MANDT == TTXJ.MANDT
  • I_SUPLRINVCITMQTYVARIANCETRAIN.TAXJURISDICTION == TTXJ.TXJCD
  • I_SUPLRINVCITMQTYVARIANCETRAIN.[column in domain "TAX_KALSM"] == TTXJ.KALSM
Valuation area
  • Client
  • Valuation area
  • I_SUPLRINVCITMQTYVARIANCETRAIN.MANDT == T001K.MANDT
  • I_SUPLRINVCITMQTYVARIANCETRAIN.VALUATIONAREA == T001K.BWKEY