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
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
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
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
A Assets
D Customers
K Vendors
M Material
S G/L accounts
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