2LIS_06_INV

Extraction of Invoice Verification Data into BW | #TRAN | Extraction method: F1 | Delta: ABR | Component: Materials Management
Tables used: BSEG, RBCO, EKPO, QALS, LIPS ... +189 more
Column Name Description
BELNR Document Number of an Accounting Document
BUZEI Document Item in Invoice Document
GJAHR Fiscal Year
COBL_NR Four Character Sequential Number for Coding Block Show values
BUKRS Company Code
LIFNR Different Invoicing Party
LOGSYS Logical system
EBELN Purchasing Document Number
EBELP Item Number of Purchasing Document
EKGRP Purchasing Group
EKORG Purchasing organization
MATNR FK Material Number
WERKS Plant
AUFNR Order Number
KOART Account type Show values
Column Name Description
💲 Currency Key (WAERS):
ARKUEMW Sales Tax Portion of Automatic Invoice Reduction Amount
ARKUEN Automatic Invoice Reduction Amount (Net)
BEZNK Unplanned Delivery Costs
DIFFMW Sales Tax Portion of the Invoice Verification Difference
DIFFN Document Balance
LIEFFMW Tax in Supplier Error
LIEFFN Supplier Error (Exclusive of Tax)
MAKZMW Tax Amount Accepted Manually
MAKZN Manually accepted net difference amount
RMWWR Gross Invoice Amount in Document Currency
WMWST1 Tax Amount in Document Currency with +/- Sign
AREWR GR/IR account clearing value in local currency
NETWR Net Value in Document Currency
RBWWR Invoice Amount in Document Currency of Supplier Invoice
REFWR Invoice Value in Foreign Currency
REWWR Invoice Amount in Foreign Currency
WENWR Accepted net value of service in foreign currency
WEWWR Value of goods received in foreign currency
WRBTR Amount in Document Currency
AREWW Clearing value on GR/IR clearing account (transac. currency)
💲 Purchase order currency (BEWAE):
NETPR Net Price in Purchasing Document (in Document Currency)
Column Name Description
📏 Order Price Unit (Purchasing) (BPRME):
BPMNG Quantity in Purchase Order Price Unit
BPRBM Quantity Invoiced in Supplier Invoice in PO Price Units
BPREM Invoice receipt quantity in order price unit
BPWEM Goods Receipt Quantity in Purchase Order Price Unit
📏 Base Unit of Measure (MEINS):
BSMNG Quantity ordered against this purchase requisition
REMNG Quantity invoiced
WEMNG Quantity of Goods Received
📏 Purchase Order Unit of Measure (BSTME):
MENGE Quantity
RBMNG Quantity Invoiced in Supplier Invoice in PO Order Units
Column Name Description
BLDAT Document Date in Document
BUDAT Posting Date in the Document
Column Name Description
COBL_NR Four Character Sequential Number for Coding Block Show values
IVTYP Origin of a Logistics Invoice Verification Document Show values
MRM_ZLSPR Logistics payment block Show values
RBSTAT Invoice document status Show values
XRECH Indicator: post invoice Show values
EREKZ Final Invoice Indicator Show values
NOQUANTITY No quantity logic (document item without quantity) Show values
RETPO Returns Item Show values
SHKZG Debit/Credit Indicator Show values
SPGRC Blocking Reason: Quality Show values
SPGRG Blocking Reason: Order Price Quantity Show values
SPGRM Blocking Reason: Quantity Show values
SPGRP Blocking Reason: Price Show values
SPGRQ Manual Blocking Reason Show values
SPGRS Blocking Reason: Item Amount Show values
SPGRT Blocking Reason: Date Show values
SPGRV Blocking Reason: Project Budget Show values
WEPOS Goods Receipt Indicator Show values
WEUNB Goods Receipt, Non-Valuated Show values
KOART Account type Show values
ROCANCEL Record Type in Extraction of Invoice Verification Data Show values
Column Name Description Domain name
BKTXT Document Header Text TEXT25
MWSKZ_BNK Tax Code MWSKZ
STBLG Reversal document number BELNR
STJAH Fiscal year of reversal document GJAHR
XBLNR Reference Document Number XBLNR1
ZLSPR Payment Block Key ZAHLS
AFNAM Name of requisitioner/requester AFNAM
BPUMN Denominator for Conv. of Order Price Unit into Order Unit UMBSN
BPUMZ Numerator for Conversion of Order Price Unit into Order Unit UMBSZ
KNTTP Account Assignment Category KNTTP
KONNR Number of principal purchase agreement EBELN
KTPNR Item number of principal purchase agreement EBELP
LFBNR Document No. of a Reference Document BELNR
LFGJA Fiscal Year of Current Period GJAHR
LFPOS Item of a Reference Document MBLPO
LIFNR2 Vendor's account number LIFNR
MATKL Material Group MATKL
PEINH Price unit PACK3
PSTYP Item category in purchasing document PSTYP
TBTKZ Indicator: Subsequent Debit/Credit TBTKZ
TXZ01 Short Text TEXT40
UMREN Denominator for conversion to base units of measure UMBSN
UMREZ Numerator for Conversion to Base Units of Measure UMBSZ
ANLN1 Main Asset Number ANLN1
ANLN2 Asset Subnumber ANLN2
BPMNG_F Quantity in PO Price Unit (as Floating Point No. - Int. Fld)
FIKRS Financial Management Area FIKRS
FIPOS Commitment Item FIPOS
FISTL Funds Center FISTL
FKBER Functional Area FKBER
GEBER Fund BP_GEBER
KOKRS Controlling Area CACCD
KTOPL Chart of Accounts KTOPL
LSTAR Activity Type LSTAR
NPLNR Network Number for Account Assignment AUFNR
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR
PRCTR Profit Center PRCTR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_POSNR
SAKNR G/L Account Number SAKNR
VORNR Operation/Activity Number VORNR
BUDGET_PD Budget Period FM_BUDGET_PERIOD
Master Data Relations Join Conditions
Material Number
  • Client
  • Material Number
  • 2LIS_06_INV.MANDT == MARA.MANDT
  • 2LIS_06_INV.MATNR == MARA.MATNR