1. Home
  2. Resources
  3. SAP Tables
  4. SAPI_LIV_HEADER - Step API: Header Data For LIV Document

SAP Table SAPI_LIV_HEADER

Step API: Header Data For LIV Document

SAPI_LIV_HEADER (Step API: Header Data For LIV Document) 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 SAPI_LIV_HEADER to other SAP tables.

Source: SAPI_LIV_HEADER (Step API: Header Data For LIV Document)

SAPI_LIV_HEADER table fields

Field Data element Checktable Datatype Length Decimals
DOC_KEY Document Key WB2_DOC_KEY CHAR 42 0
BELNR Document Number of an Invoice Document RE_BELNR CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
RBKP WB2_RBKP STRU 0 0
MANDT Client MANDT 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 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 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 CHAR 4 0
LIFNR Different Invoicing Party LIFRE CHAR 10 0
WAERS Currency Key WAERS 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 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 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 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 CHAR 2 0
DIEKZ Service Indicator (Foreign Payment) DIEKZ CHAR 1 0
LANDL Supplying Country LANDL CHAR 3 0
LZBKZ State Central Bank Indicator LZBKZ 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 CHAR 5 0
ZUONR Assignment Number DZUONR CHAR 18 0
ZLSPR Payment Block Key DZLSPR CHAR 1 0
ZLSCH Payment Method DZLSCH 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 CHAR 2 0
BRNCH Branch Number J_1ABRNCH CHAR 4 0
ERFPR Entry profile: Logistics Invoice Verification ERFPR CHAR 12 0
SECCO Section Code SECCO 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
ASSOC_QUAN_B Assoc. Mngt: Actually Associated Quantity of an Item WB2_ASSOCIATED_QUAN QUAN 15 3
UNIT_OF_QUAN_B Base Unit of Measure MEINS UNIT 3 0
ASSOC_QUAN_S Assoc. Mngt: Actually Associated Quantity of an Item WB2_ASSOCIATED_QUAN QUAN 15 3
UNIT_OF_QUAN_S Base Unit of Measure MEINS UNIT 3 0
ASSOC_QUAN_P Assoc. Mngt: Actually Associated Quantity of an Item WB2_ASSOCIATED_QUAN QUAN 15 3
UNIT_OF_QUAN_P Base Unit of Measure MEINS UNIT 3 0
PORTFOLIO Global Trade: (Internal) Portfolio Number WB2_PORTFOLIO CHAR 10 0
INVOICE_IND Indicator: post invoice XRECH CHAR 1 0
X Yes
NULL No
. No
DOC_TYPE Document Type BLART T003 CHAR 2 0
DOC_DATE Document Date in Document BLDAT DATS 8 0
PSTNG_DATE Posting Date in the Document BUDAT DATS 8 0
REF_DOC_NO Reference Document Number XBLNR CHAR 16 0
COMP_CODE Company Code BUKRS T001 CHAR 4 0
DIFF_INV Different Invoicing Party LIFRE CHAR 10 0
CURRENCY Currency Key WAERS TCURC CUKY 5 0
CURRENCY_ISO ISO currency code ISOCD CHAR 3 0
EXCH_RATE Direct Quoted Exchange Rate UKURSP DEC 9 5
EXCH_RATE_V Indirect Quoted Exchange Rate UKURSM DEC 9 5
GROSS_AMOUNT Gross Invoice Amount in Document Currency BAPI_RMWWR DEC 23 4
CALC_TAX_IND Calculate tax automatically XMWST CHAR 1 0
X Yes
NULL No
PMNTTRMS Terms of Payment Key DZTERM CHAR 4 0
BLINE_DATE Baseline Date for Due Date Calculation DZFBDT DATS 8 0
DSCT_DAYS1 Cash discount days 1 DZBD1T DEC 3 0
DSCT_DAYS2 Cash discount days 2 DZBD2T DEC 3 0
NETTERMS Net Payment Terms Period DZBD3T DEC 3 0
DSCT_PCT1 Cash Discount Percentage 1 DZBD1P DEC 5 3
DSCT_PCT2 Cash Discount Percentage 1 DZBD1P DEC 5 3
IV_CATEGORY 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
HEADER_TXT Document Header Text BKTXT CHAR 25 0
PMNT_BLOCK Payment Block Key DZLSPR CHAR 1 0
DEL_COSTS Unplanned delivery costs BAPI_BEZNK DEC 23 4
DEL_COSTS_TAXC Tax code for delivery costs MWSKZ_BNK CHAR 2 0
DEL_COSTS_TAXJ Jurisdiction code for delivery costs TXJCD_BNK CHAR 15 0
PERSON_EXT Entered by external system user ERNAME CHAR 12 0
PYMT_METH Payment Method DZLSCH CHAR 1 0
PMTMTHSUPL Payment Method Supplement UZAWE CHAR 2 0
INV_DOC_NO Document Number of an Invoice Document RE_BELNR CHAR 10 0
SCBANK_IND State Central Bank Indicator LZBKZ T015L CHAR 3 0
SUPCOUNTRY Supplying Country LANDL T005 CHAR 3 0
BLLSRV_IND Service Indicator (Foreign Payment) DIEKZ CHAR 1 0
REF_DOC_NO_LONG Reference Document Number (for Dependencies see Long Text) XBLNR_LONG CHAR 35 0
DSCT_AMOUNT Cash Discount Amount in Document Currency BAPI_WSKTO DEC 23 4
PO_SUB_NO ISR Subscriber Number ESRNR CHAR 11 0
PO_CHECKDG ISR Check Digit ESRPZ CHAR 2 0
PO_REF_NO ISR Reference Number ESRRE CHAR 27 0
PAYEE_PAYER Payee/Payer EMPFB CHAR 10 0
PARTNER_BK Partner Bank Type BVTYP CHAR 4 0
HOUSEBANKID Short Key for a House Bank HBKID T012 CHAR 5 0
ALLOC_NMBR Assignment Number DZUONR CHAR 18 0
PAYMT_REF Payment Reference KIDNO CHAR 30 0
INV_REF_NO Invoice Reference: Document Number for Invoice Reference AWREF_REB CHAR 10 0
INV_YEAR Fiscal Year of the Relevant Invoice (for Credit Memo) REBZJ NUMC 4 0
INV_REC_DATE Invoice Receipt Date REINDAT DATS 8 0
PLANNING_LEVEL Planning level FDLEV T036 CHAR 2 0
PLANNING_DATE Planning date FDTAG DATS 8 0
FIXEDTERMS 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
BUS_AREA Business Area GSBER TGSB CHAR 4 0
LOT_NUMBER Lot Number for Documents LOTKZ CHAR 10 0
ITEM_TEXT Item Text SGTXT CHAR 50 0
J_1BNFTYPE Nota Fiscal Type J_1BNFTYPE CHAR 2 0
EU_TRIANG_DEAL Indicator: Triangular deal within the EU ? XEGDR CHAR 1 0
X Yes
NULL No
REPCOUNTRY Reporting Country for Delivery of Goods within the EU EGMLD_BSEZ CHAR 3 0
VAT_REG_NO VAT Registration Number STCEG CHAR 20 0
BUSINESS_PLACE Business Place BUPLA CHAR 4 0
TAX_EXCH_RATE Exchange Rate for Taxes TXKRS_BKPF DEC 9 5
GOODS_AFFECTED Indicator: Capital Goods Affected? XINVE CHAR 1 0
X Yes
NULL No
RET_DUE_PROP Due Date for Retention (Default) RET_DUE_PROP DATS 8 0
DELIV_POSTING Posting logic for delivery items (invoice/credit memo) XRECHL CHAR 1 0
S Debit posting
H Credit posting
RETURN_POSTING Posting logic for returns items (invoice/credit memo) XRECHR CHAR 1 0
S Debit posting
H Credit posting
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
SIMULATION Simulate Invoice XSIMU CHAR 1 0
X Yes
NULL No

SAPI_LIV_HEADER foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SAPI_LIV_HEADER BUS_AREA SYST MANDT TGSB Business Areas MANDT
SAPI_LIV_HEADER BUS_AREA SAPI_LIV_HEADER BUS_AREA TGSB Business Areas GSBER
SAPI_LIV_HEADER COMP_CODE SAPI_LIV_HEADER COMP_CODE T001 Company Codes BUKRS
SAPI_LIV_HEADER COMP_CODE SY MANDT T001 Company Codes MANDT
SAPI_LIV_HEADER CURRENCY SAPI_LIV_HEADER CURRENCY TCURC Currency Codes WAERS
SAPI_LIV_HEADER CURRENCY SY MANDT TCURC Currency Codes MANDT
SAPI_LIV_HEADER DOC_TYPE SAPI_LIV_HEADER DOC_TYPE T003 Document Types BLART
SAPI_LIV_HEADER DOC_TYPE SY MANDT T003 Document Types MANDT
SAPI_LIV_HEADER HOUSEBANKID SAPI_LIV_HEADER HOUSEBANKID T012 House Banks HBKID
SAPI_LIV_HEADER HOUSEBANKID SAPI_LIV_HEADER COMP_CODE T012 House Banks BUKRS
SAPI_LIV_HEADER HOUSEBANKID SYST MANDT T012 House Banks MANDT
SAPI_LIV_HEADER PLANNING_LEVEL SYST MANDT T036 Planning levels MANDT
SAPI_LIV_HEADER PLANNING_LEVEL SAPI_LIV_HEADER PLANNING_LEVEL T036 Planning levels EBENE
SAPI_LIV_HEADER SCBANK_IND SYST MANDT T015L SCB Ratios MANDT
SAPI_LIV_HEADER SCBANK_IND SAPI_LIV_HEADER SCBANK_IND T015L SCB Ratios LZBKZ
SAPI_LIV_HEADER SUPCOUNTRY SAPI_LIV_HEADER SUPCOUNTRY T005 Countries LAND1
SAPI_LIV_HEADER SUPCOUNTRY SYST MANDT T005 Countries MANDT