Follow us on LinkedIn for your next SAP project

SAP Table J_3RF_HD_INV

Invoice Header: Transfer Structure to Smart Forms

J_3RF_HD_INV (Invoice Header: Transfer Structure to Smart Forms) 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 J_3RF_HD_INV to other SAP tables.

J_3RF_HD_INV table fields

Field Data element Checktable Datatype Length Decimals Possible values
BELNR
Accounting Document Number
BELNR_D
CHAR
10 0
GJAHR
Fiscal Year
GJAHR
NUMC
4 0
VBELN
Sales and Distribution Document Number
VBELN
CHAR
10 0
FKDAT
Billing date for billing index and printout
FKDAT
DATS
8 0
BUDAT
Posting Date in the Document
BUDAT
DATS
8 0
EXT_ORIG
Comment
CHAR50
CHAR
50 0
REVNO
Counter
NUM03
NUMC
3 0
DATE_REV
Date
DATUM
DATS
8 0
VBTYP
SD document category
VBTYP
CHAR
1 0
SLAND
Sending country for processing address
SLAND
CHAR
3 0
WAERK
SD Document Currency
WAERK
CUKY
5 0
BUKRS
Company Code
BUKRS
CHAR
4 0
HWAER
Local Currency
HWAER
CUKY
5 0
KURRF
Exchange rate for FI postings
KURRF
DEC
9 5
ADRNR
Address number
AD_ADDRNUM
CHAR
10 0
STCEG
VAT Registration Number
STCEG
CHAR
20 0
STCEG_1
VAT Registration Number
STCEG
CHAR
20 0
FULL_NAME
Char255
CHAR255
CHAR
255 0
NAME1
Name 1
AD_NAME1
CHAR
40 0
NAME2
Name 2
AD_NAME2
CHAR
40 0
NAME3
Name 3
AD_NAME3
CHAR
40 0
NAME4
Name 4
AD_NAME4
CHAR
40 0
SELLERADDR
Char255
CHAR255
CHAR
255 0
CITY1
City
AD_CITY1
CHAR
40 0
CITY2
District
AD_CITY2
CHAR
40 0
CITY3
City (different from postal city)
AD_CITY3
CHAR
40 0
PCODE1
City postal code
AD_PSTCD1
CHAR
10 0
STREET
Street
AD_STREET
CHAR
60 0
HNUM1
House Number
AD_HSNM1
CHAR
10 0
HNUM2
House number supplement
AD_HSNM2
CHAR
10 0
LOCATION
Street 5
AD_LCTN
CHAR
40 0
TELNUM
First telephone no.: dialling code+number
AD_TLNMBR1
CHAR
30 0
REG
Region (State, Province, County)
REGIO
CHAR
3 0
REGION
Description
BEZEI20
CHAR
20 0
LAND
Country Name
LANDX
CHAR
15 0
VKORG
Sales Organization
VKORG
CHAR
4 0
VKORG_ADR
Address
ADRNR
CHAR
10 0
NAME1_CO
Name 1
AD_NAME1
CHAR
40 0
NAME2_CO
Name 2
AD_NAME2
CHAR
40 0
NAME3_CO
Name 3
AD_NAME3
CHAR
40 0
NAME4_CO
Name 4
AD_NAME4
CHAR
40 0
CONSRNAME
Char255
CHAR255
CHAR
255 0
CONSRADDR
Char255
CHAR255
CHAR
255 0
CITY1_CO
City
AD_CITY1
CHAR
40 0
CITY2_CO
District
AD_CITY2
CHAR
40 0
CITY3_CO
City (different from postal city)
AD_CITY3
CHAR
40 0
PCODE1_CO
City postal code
AD_PSTCD1
CHAR
10 0
STREET_CO
Street
AD_STREET
CHAR
60 0
HNUM1_CO
House Number
AD_HSNM1
CHAR
10 0
HNUM2_CO
House number supplement
AD_HSNM2
CHAR
10 0
LOCATION_CO
Street 5
AD_LCTN
CHAR
40 0
TELNUM_CO
First telephone no.: dialling code+number
AD_TLNMBR1
CHAR
30 0
LAND_CO
Country Key
LAND1
CHAR
3 0
LANDT_CO
Country Name
LANDX
CHAR
15 0
REG_CO
Region (State, Province, County)
REGIO
CHAR
3 0
REGIO_CO
Description
BEZEI20
CHAR
20 0
KOART
Account Type
KOART
CHAR
1 0
KUNAG
Sold-to party
KUNAG
CHAR
10 0
ADRNR_AG
Address number
AD_ADDRNUM
CHAR
10 0
STCEG_AG
Tax Number 1
STCD1
CHAR
16 0
STCEG1_AG
Tax Number 3
STCD3
CHAR
18 0
BUYERNAME
Partner Name
J_3RFINV_NAME
CHAR
255 0
NAME1_AG
Name 1
AD_NAME1
CHAR
40 0
NAME2_AG
Name 2
AD_NAME2
CHAR
40 0
NAME3_AG
Name 3
AD_NAME3
CHAR
40 0
NAME4_AG
Name 4
AD_NAME4
CHAR
40 0
BUYERADDR
Char255
CHAR255
CHAR
255 0
CITY1_AG
City
AD_CITY1
CHAR
40 0
CITY2_AG
District
AD_CITY2
CHAR
40 0
CITY3_AG
City (different from postal city)
AD_CITY3
CHAR
40 0
PCODE1_AG
City postal code
AD_PSTCD1
CHAR
10 0
STREET_AG
Street
AD_STREET
CHAR
60 0
HNUM1_AG
House Number
AD_HSNM1
CHAR
10 0
HNUM2_AG
House number supplement
AD_HSNM2
CHAR
10 0
LOCATION_AG
Street 5
AD_LCTN
CHAR
40 0
TELNUM_AG
First telephone no.: dialling code+number
AD_TLNMBR1
CHAR
30 0
LAND_AG
Country Key
LAND1
CHAR
3 0
LANDT_AG
Country Name
LANDX
CHAR
15 0
REG_AG
Region (State, Province, County)
REGIO
CHAR
3 0
REGIO_AG
Description
BEZEI20
CHAR
20 0
KUNWE
Ship-to party
KUNWE
CHAR
10 0
ADRNR_WE
Address number
AD_ADDRNUM
CHAR
10 0
STCEG_WE
Tax Number 1
STCD1
CHAR
16 0
STCEG1_WE
Tax Number 3
STCD3
CHAR
18 0
NAME1_WE
Name 1
AD_NAME1
CHAR
40 0
NAME2_WE
Name 2
AD_NAME2
CHAR
40 0
NAME3_WE
Name 3
AD_NAME3
CHAR
40 0
NAME4_WE
Name 4
AD_NAME4
CHAR
40 0
SHIP_TO_ADDR
Char255
CHAR255
CHAR
255 0
CITY1_WE
City
AD_CITY1
CHAR
40 0
CITY2_WE
District
AD_CITY2
CHAR
40 0
CITY3_WE
City (different from postal city)
AD_CITY3
CHAR
40 0
PCODE1_WE
City postal code
AD_PSTCD1
CHAR
10 0
STREET_WE
Street
AD_STREET
CHAR
60 0
HNUM1_WE
House Number
AD_HSNM1
CHAR
10 0
HNUM2_WE
House number supplement
AD_HSNM2
CHAR
10 0
LOCATION_WE
Street 5
AD_LCTN
CHAR
40 0
TELNUM_WE
First telephone no.: dialling code+number
AD_TLNMBR1
CHAR
30 0
LAND_WE
Country Key
LAND1
CHAR
3 0
LANDT_WE
Country Name
LANDX
CHAR
15 0
REG_WE
Region (State, Province, County)
REGIO
CHAR
3 0
REGIO_WE
Description
BEZEI20
CHAR
20 0
SMNET
Condition subtotal
KZWIS
CURR
15 2
SMVAT
Condition subtotal
KZWIS
CURR
15 2
SMTOT
Condition subtotal
KZWIS
CURR
15 2
SMEXC
Condition subtotal
KZWIS
CURR
15 2
SMNSP
Condition subtotal
KZWIS
CURR
15 2
HMNET
Condition subtotal
KZWIS
CURR
15 2
HMVAT
Condition subtotal
KZWIS
CURR
15 2
HMTOT
Condition subtotal
KZWIS
CURR
15 2
BKTXT
Char255
CHAR255
CHAR
255 0
CURTXT
Long Text
LTEXT
CHAR
40 0
WAERC
Alternative key for currencies
ALTWR
CHAR
3 0