SAP Table WB2_ALV_IV_HEAD

ALV Display Document Header Incoming Invoice

WB2_ALV_IV_HEAD (ALV Display Document Header Incoming Invoice) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link WB2_ALV_IV_HEAD to other SAP tables.

Source: WB2_ALV_IV_HEAD (ALV Display Document Header Incoming Invoice)

WB2_ALV_IV_HEAD table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BELNR Document Number of an Invoice Document RE_BELNR CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BLART Document Type BLART T003 CHAR 2 0
BLDAT Document Date in Document BLDAT DATS 8 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
USNAM User name USNAM CHAR 12 0
TCODE Transaction Code TCODE TSTC CHAR 20 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0
VGART Transaction Type in AG08 (Internal Document Type) M8VGA CHAR 2 0
RP Invoice receipt
KP Account maintenance
KS Account maintenance reversal
PR Price change
BL Material debit
PF Std cost estim. release
RD Logistics invoice
ML Material ledger settlement
MI Material ledger initialization
RS Logistics invoice, cancel
XBLNR Reference Document Number XBLNR1 CHAR 16 0
BUKRS Company Code BUKRS T001 CHAR 4 0
LIFNR Different Invoicing Party LIFRE LFA1 CHAR 10 0
WAERS Currency Key WAERS TCURC CUKY 5 0
KURSF Exchange rate KURSF DEC 9 5
RMWWR Gross invoice amount in document currency RMWWR CURR 13 2
BEZNK Unplanned delivery costs BEZNK CURR 13 2
WMWST1 Tax Amount in Document Currency with +/- Sign FWSTEV CURR 13 2
MWSKZ1 Tax code MWSKZ_MRM1 TMRM007A CHAR 2 0
WMWST2 Obsolete: tax amount in document currency - do NOT use! FWSTEV_OLD CURR 13 2
MWSKZ2 Obsolete: sales tax code MWSKZ_MRMO T007A CHAR 2 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
ZBD1T Cash discount days 1 DZBD1T DEC 3 0
ZBD1P Cash Discount Percentage 1 DZBD1P DEC 5 3
ZBD2T Cash discount days 2 DZBD2T DEC 3 0
ZBD2P Cash Discount Percentage 2 DZBD2P DEC 5 3
ZBD3T Net Payment Terms Period DZBD3T DEC 3 0
WSKTO Cash discount amount in document currency WSKTO CURR 13 2
XRECH Indicator: post invoice XRECH CHAR 1 0
X Yes
NULL No
. No
BKTXT Document Header Text BKTXT CHAR 25 0
SAPRL SAP Release SAPRL CHAR 4 0
LOGSYS Logical system LOGSYS CHAR 10 0
XMWST Calculate tax automatically XMWST CHAR 1 0
X Yes
NULL No
STBLG Reversal document number RE_STBLG CHAR 10 0
STJAH Fiscal year of reversal document RE_STJAH NUMC 4 0
MWSKZ_BNK Tax Code MWSKZ_MRM T007A CHAR 2 0
TXJCD_BNK Tax Jurisdiction TXJCD CHAR 15 0
IVTYP Origin of a Logistics Invoice Verification Document IVTYP CHAR 1 0
NULL Online
1 ERS
2 ERS Zero Document
3 Batch Run
4 EDI
5 Cancellation
6 Invoicing Plan
7 Transfer Prices
8 Revaluation
9 WEB Invoice
B BAPI Invoice
A Invoice from Parking Function
C Account Maintenance
D SRM Invoice
E BAPI Account Maintenance
G SOA A2A
H SOA B2B
I Ariba Invoice
XRBTX Indicator: more than one tax code XRBTX CHAR 1 0
X Yes
NULL No
REPART Indicator: Invoice Verification Type REPART CHAR 1 0
NULL Online verification
1 Time point 1 - background verification
2 Time point 2 - background verification
3 No verification
RBSTAT Invoice document status RBSTAT CHAR 1 0
1 Defined for background verification
2 Deleted
3 With Errors
4 Correct (posted, not completed)
5 Posted
A Parked
B Parked and completed
C Parked and held
D Entered and held
E Parked and released
KNUMVE Document condition - own conditions KNUMVE CHAR 10 0
KNUMVL Document condition - vendor error KNUMVL CHAR 10 0
ARKUEN Automatic Invoice Reduction Amount (Net) ARKUEN CURR 13 2
ARKUEMW Sales Tax Portion of Automatic Invoice Reduction Amount ARKUEMW CURR 13 2
MAKZN Manually accepted net difference amount MAKZN CURR 13 2
MAKZMW Tax Amount Accepted Manually MAKZMW CURR 13 2
LIEFFN Vendor error (exclusive of tax) LIEFFN CURR 13 2
LIEFFMW Tax in vendor error LIEFFMW CURR 13 2
XAUTAKZ Indicates automatically accepted invoices XAUTAKZ CHAR 1 0
X Yes
NULL No
ESRNR ISR Subscriber Number ESRNR CHAR 11 0
ESRPZ ISR Check Digit ESRPZ CHAR 2 0
ESRRE ISR Reference Number ESRRE CHAR 27 0
QSSHB Withholding Tax Base Amount QSSHB CURR 13 2
QSFBT Withholding Tax-Exempt Amount (in Document Currency) QSFBT CURR 13 2
QSSKZ Withholding Tax Code QSSKZ T059Q CHAR 2 0
DIEKZ Service Indicator (Foreign Payment) DIEKZ CHAR 1 0
LANDL Supplying Country LANDL T005 CHAR 3 0
LZBKZ State Central Bank Indicator LZBKZ T015L CHAR 3 0
TXKRS Exchange Rate for Taxes TXKRS_BKPF DEC 9 5
EMPFB Payee/Payer EMPFB CHAR 10 0
BVTYP Partner Bank Type BVTYP CHAR 4 0
HBKID Short Key for a House Bank HBKID T012 CHAR 5 0
ZUONR Assignment Number DZUONR CHAR 18 0
ZLSPR Payment Block Key DZLSPR T008 CHAR 1 0
ZLSCH Payment Method DZLSCH T042Z CHAR 1 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
KIDNO Payment Reference KIDNO CHAR 30 0
REBZG Invoice Reference: Document Number for Invoice Reference AWREF_REB CHAR 10 0
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) REBZJ NUMC 4 0
XINVE Indicator: Capital Goods Affected? XINVE CHAR 1 0
X Yes
NULL No
EGMLD Reporting Country for Delivery of Goods within the EU EGMLD_BSEZ CHAR 3 0
XEGDR Indicator: Triangular deal within the EU ? XEGDR CHAR 1 0
X Yes
NULL No
VATDATE Tax Reporting Date VATDATE DATS 8 0
HKONT General Ledger Account HKONT CHAR 10 0
J_1BNFTYPE Nota Fiscal Type J_1BNFTYPE J_1BAA CHAR 2 0
BRNCH Branch Number J_1ABRNCH J_1BBRANCH CHAR 4 0
ERFPR Entry profile: Logistics Invoice Verification ERFPR T169H CHAR 12 0
SECCO Section Code SECCO SECCODE CHAR 4 0
NAME1 Name 1 NAME1_GP CHAR 35 0
NAME2 Name 2 NAME2_GP CHAR 35 0
NAME3 Name 3 NAME3_GP CHAR 35 0
NAME4 Name 4 NAME4_GP CHAR 35 0
PSTLZ Postal Code PSTLZ CHAR 10 0
ORT01 City ORT01_GP CHAR 35 0
LAND1 Country Key LAND1_GP CHAR 3 0
STRAS House number and street STRAS_GP CHAR 35 0
PFACH PO Box PFACH CHAR 10 0
PSTL2 P.O. Box Postal Code PSTL2 CHAR 10 0
PSKTO Account Number of Bank Account At Post Office PSKTO CHAR 16 0
BANKN Bank account number BANKN CHAR 18 0
BANKL Bank number BANKL CHAR 15 0
BANKS Bank country key BANKS CHAR 3 0
STCD1 Tax Number 1 STCD1 CHAR 16 0
STCD2 Tax Number 2 STCD2 CHAR 11 0
STKZU Liable for VAT STKZU CHAR 1 0
X Yes
NULL No
STKZA Indicator: Business Partner Subject to Equalization Tax? STKZA CHAR 1 0
NULL Not subject to equalization tax
X Subject to equalization tax
REGIO Region (State, Province, County) REGIO CHAR 3 0
BKONT Bank Control Key BKONT CHAR 2 0
DTAWS Instruction key for data medium exchange DTAWS CHAR 2 0
DTAMS Indicator for Data Medium Exchange DTAMS CHAR 1 0
1 Single data record not to be forwarded to the Bundesbank
0 Single data record can be forwarded to the Bundesbank
NULL Use house bank default value
SPRAS Character field of length 1 CHAR_LG_01 CHAR 1 0
XCPDK Indicator: Is the account a one-time account? XCPDK CHAR 1 0
X Yes
NULL No
EMPFG Payee code EMPFG CHAR 16 0
FITYP Tax type J_1AFITP_D CHAR 2 0
STCDT Tax Number Type J_1ATOID CHAR 2 0
STKZN Natural Person STKZN CHAR 1 0
X Natural person
NULL Legal person
STCD3 Tax Number 3 STCD3 CHAR 18 0
STCD4 Tax Number 4 STCD4 CHAR 18 0
BKREF Reference specifications for bank details BKREF CHAR 20 0
J_1KFREPRE Name of Representative REPRES CHAR 10 0
J_1KFTBUS Type of Business GESTYP CHAR 30 0
J_1KFTIND Type of Industry INDTYP CHAR 30 0
ANRED Title ANRED CHAR 15 0
STCEG VAT Registration Number STCEG CHAR 20 0
ERNAME Entered by external system user ERNAME CHAR 12 0
REINDAT Invoice Receipt Date REINDAT DATS 8 0
UZAWE Payment Method Supplement UZAWE CHAR 2 0
FDLEV Planning level FDLEV CHAR 2 0
FDTAG Planning date FDTAG DATS 8 0
ZBFIX Fixed Payment Terms DZBFIX CHAR 1 0
NULL No fixing
1 1st cash disc.percentage rate or cash disc.amount is fixed
2 2nd cash discount percentage rate is fixed
FRGKZ Indicator: Release Required DFRGKZ CHAR 1 0
X Yes
NULL No
ERFNAM Name of the Processor Who Entered the Object ERFNAM CHAR 12 0
BUPLA Business Place BUPLA CHAR 4 0
FILKD Account Number of the Branch FILKD CHAR 10 0
GSBER Business Area GSBER CHAR 4 0
LOTKZ Lot Number for Documents LOTKZ CHAR 10 0
SGTXT Item Text SGTXT CHAR 50 0
INV_TRAN Transaction in Logistics Invoice Verification INV_TRAN CHAR 1 0
1 Invoice
2 Credit Memo
3 Subsequent Debit
4 Subsequent Credit
5 Provisional Invoice
6 Differential Invoice
7 Final Invoice
8 Provisional Invoice/Differential Invoice
PREPAY_STATUS Prepayment Status WRF_PREPAY_STATUS CHAR 1 0
NULL Invoice Not Relevant for Prepayment
A Relevant, Invoice Not Saved Yet
B Relevant; No Prepayment Document due to Error
C Relevant; Prepayment Document under Conditions
D Prepayment Document Was Posted
PREPAY_AWKEY Invoice Document Number Created for Prepayment WRF_PREPAY_AWKEY CHAR 20 0
ASSIGN_STATUS Is the invoice in the assignment test process? WRF_MRM_ASSIGN_STATUS CHAR 1 0
NULL Undefined
A Goods Receipt for Settlement Found
B Within Assignment Test
C End of Assignment Test Period Reached
D Error Occurred
E Error Within the BAdI Implementation
F Processed Manually Before End of Assignment Test
N Never in Assignment Test
ASSIGN_NEXT_DATE Date of Next Assignment Test WRF_MRM_ASSIGN_NEXT_DATE DATS 8 0
ASSIGN_END_DATE End Date of Assignment Test Period WRF_MRM_ASSIGN_END_DATE DATS 8 0
COPY_BY_BELNR Invoice Document Number of Original Invoice COPY_BY_BELNR CHAR 10 0
COPY_BY_YEAR Fiscal Year of Original Invoice COPY_BY_YEAR NUMC 4 0
COPY_TO_BELNR Invoice Document Number of Copied Invoice COPY_TO_BELNR CHAR 10 0
COPY_TO_YEAR Fiscal Year of Copied Invoice COPY_TO_YEAR NUMC 4 0
COPY_USER User That Reversed and Copied the Invoice COPY_USER CHAR 12 0
KURSX Market Data Exchange Rate GLE_FXR_DTE_RATEX28 DEC 28 14
WWERT Translation Date WWERT_D DATS 8 0
XREF3 Reference key for line item XREF3 CHAR 20 0
FILTERED_OUT_GT Filtered Out WB2_FILTERED_OUT CHAR 1 0
EXTERNAL_NO_GT Trading Contract: External Document Number TKONN_EX CHAR 30 0
SCENARIO_GT Business Scenario WB2_BUSINESS_SCENARIO CHAR 2 0
LINECOLOR_GT Color of a Row in ALV WB2_LINECOLOR CHAR 4 0
WB2_LEADER_HEAD_GT Leading Header WB2_LEADER_HEAD CHAR 1 0
X True
NULL False

WB2_ALV_IV_HEAD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
WB2_ALV_IV_HEAD BLART WB2_ALV_IV_HEAD BLART T003 Document Types BLART
WB2_ALV_IV_HEAD BLART WB2_ALV_IV_HEAD MANDT T003 Document Types MANDT
WB2_ALV_IV_HEAD BRNCH WB2_ALV_IV_HEAD BRNCH J_1BBRANCH Business Place BRANCH
WB2_ALV_IV_HEAD BRNCH RBKPV BUKRS J_1BBRANCH Business Place BUKRS
WB2_ALV_IV_HEAD BRNCH WB2_ALV_IV_HEAD MANDT J_1BBRANCH Business Place MANDT
WB2_ALV_IV_HEAD BUKRS WB2_ALV_IV_HEAD BUKRS T001 Company Codes BUKRS
WB2_ALV_IV_HEAD BUKRS WB2_ALV_IV_HEAD MANDT T001 Company Codes MANDT
WB2_ALV_IV_HEAD ERFPR WB2_ALV_IV_HEAD ERFPR T169H Entry Profile ERFPR
WB2_ALV_IV_HEAD ERFPR WB2_ALV_IV_HEAD MANDT T169H Entry Profile MANDT
WB2_ALV_IV_HEAD HBKID RBKPV BUKRS T012 House Banks BUKRS
WB2_ALV_IV_HEAD HBKID RBKPV MANDT T012 House Banks MANDT
WB2_ALV_IV_HEAD HBKID WB2_ALV_IV_HEAD HBKID T012 House Banks HBKID
WB2_ALV_IV_HEAD J_1BNFTYPE WB2_ALV_IV_HEAD MANDT J_1BAA Nota Fiscal type MANDT
WB2_ALV_IV_HEAD J_1BNFTYPE WB2_ALV_IV_HEAD J_1BNFTYPE J_1BAA Nota Fiscal type NFTYPE
WB2_ALV_IV_HEAD LANDL WB2_ALV_IV_HEAD MANDT T005 Countries MANDT
WB2_ALV_IV_HEAD LANDL WB2_ALV_IV_HEAD LANDL T005 Countries LAND1
WB2_ALV_IV_HEAD LIFNR WB2_ALV_IV_HEAD LIFNR LFA1 Vendor Master (General Section) LIFNR
WB2_ALV_IV_HEAD LIFNR WB2_ALV_IV_HEAD MANDT LFA1 Vendor Master (General Section) MANDT
WB2_ALV_IV_HEAD LZBKZ WB2_ALV_IV_HEAD LZBKZ T015L SCB Ratios LZBKZ
WB2_ALV_IV_HEAD LZBKZ WB2_ALV_IV_HEAD MANDT T015L SCB Ratios MANDT
WB2_ALV_IV_HEAD MANDT WB2_ALV_IV_HEAD MANDT T000 Clients MANDT
WB2_ALV_IV_HEAD MWSKZ1 WB2_ALV_IV_HEAD MWSKZ1 TMRM007A Tax Codes: Invoice Verification/Invoice Entry (FI) MWSKZ
WB2_ALV_IV_HEAD MWSKZ1 * TMRM007A Tax Codes: Invoice Verification/Invoice Entry (FI) KOART
WB2_ALV_IV_HEAD MWSKZ1 TMRM007A KALSM TMRM007A Tax Codes: Invoice Verification/Invoice Entry (FI) KALSM
WB2_ALV_IV_HEAD MWSKZ1 WB2_ALV_IV_HEAD MANDT TMRM007A Tax Codes: Invoice Verification/Invoice Entry (FI) MANDT
WB2_ALV_IV_HEAD MWSKZ2 WB2_ALV_IV_HEAD MANDT T007A Tax Keys MANDT
WB2_ALV_IV_HEAD MWSKZ2 T007A KALSM T007A Tax Keys KALSM
WB2_ALV_IV_HEAD MWSKZ2 WB2_ALV_IV_HEAD MWSKZ2 T007A Tax Keys MWSKZ
WB2_ALV_IV_HEAD MWSKZ_BNK WB2_ALV_IV_HEAD MANDT T007A Tax Keys MANDT
WB2_ALV_IV_HEAD MWSKZ_BNK T007A KALSM T007A Tax Keys KALSM
WB2_ALV_IV_HEAD MWSKZ_BNK WB2_ALV_IV_HEAD MWSKZ_BNK T007A Tax Keys MWSKZ
WB2_ALV_IV_HEAD QSSKZ WB2_ALV_IV_HEAD MANDT T059Q Withholding Tax MANDT
WB2_ALV_IV_HEAD QSSKZ WB2_ALV_IV_HEAD LANDL T059Q Withholding Tax LAND1
WB2_ALV_IV_HEAD QSSKZ WB2_ALV_IV_HEAD QSSKZ T059Q Withholding Tax QSSKZ
WB2_ALV_IV_HEAD SECCO WB2_ALV_IV_HEAD SECCO SECCODE Section Code SECCODE
WB2_ALV_IV_HEAD SECCO SY MANDT SECCODE Section Code MANDT
WB2_ALV_IV_HEAD SECCO RBKPV BUKRS SECCODE Section Code BUKRS
WB2_ALV_IV_HEAD TCODE WB2_ALV_IV_HEAD TCODE TSTC SAP Transaction Codes TCODE
WB2_ALV_IV_HEAD WAERS WB2_ALV_IV_HEAD WAERS TCURC Currency Codes WAERS
WB2_ALV_IV_HEAD WAERS WB2_ALV_IV_HEAD MANDT TCURC Currency Codes MANDT
WB2_ALV_IV_HEAD ZLSCH RM08M LAND1 T042Z Payment Methods for Automatic Payment LAND1
WB2_ALV_IV_HEAD ZLSCH WB2_ALV_IV_HEAD ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH
WB2_ALV_IV_HEAD ZLSCH SY MANDT T042Z Payment Methods for Automatic Payment MANDT
WB2_ALV_IV_HEAD ZLSPR WB2_ALV_IV_HEAD ZLSPR T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
WB2_ALV_IV_HEAD ZLSPR WB2_ALV_IV_HEAD MANDT T008 Blocking Reasons for Automatic Payment Transcations MANDT