Follow us on LinkedIn for your next SAP project

SAP Table JHTFK

IS-M/AM: Settlement Documents (Billing, Commission) - Header

JHTFK (IS-M/AM: Settlement Documents (Billing, Commission) - Header) 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 JHTFK to other SAP tables.

JHTFK table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
MANDT T000
CLNT
3 0
VBELN
IS-M/AM: Billing Document
JJBELNR
CHAR
10 0
ERFUSER
Created By
ERFUSER
CHAR
12 0
ERFDATE
Created On
ERFDATE
DATS
8 0
ERFTIME
Time Created
ERFTIME
TIMS
6 0
AENUSER
Last Changed By
AENUSER
CHAR
12 0
AENDATE
Date of Last Change
AENDATE
DATS
8 0
AENTIME
Time of Last Change
AENTIME
TIMS
6 0
SFAKN
IS-M: Reversal Reference
JJBELNRSV JHTFK
CHAR
10 0
XEZER
Indicator: Is there collection authorization ?
XEZER
CHAR
1 0
BANKS
Bank country key
BANKS T005
CHAR
3 0
BANKN
Bank account number
BANKN
CHAR
18 0
BANKL
Bank number
BANKL
CHAR
15 0
BKONT
Bank Control Key
BKONT
CHAR
2 0
BVTYP
Partner Bank Type
BVTYP
CHAR
4 0
FKART
IS-M/AM: Billing/Settlement Document Type
FKART_PAM TJH05
CHAR
4 0
FKDAT
IS-M: Actual Billing/Settlement Date
JHFKDAT
DATS
8 0
FKTYP
IS-M/AM: Billing Category
JHFKTYP TJH19
CHAR
1 0
INCO1
Incoterms (Part 1)
INCO1 TINC
CHAR
3 0
INCO2
Incoterms (Part 2)
INCO2
CHAR
28 0
KNUMV
Number of the document condition
KNUMV
CHAR
10 0
KURST
Exchange Rate Type
KURST TCURV
CHAR
4 0
LAND1
Country of Destination
LLAND T005
CHAR
3 0
REGIO
Region (State, Province, County)
REGIO T005S
CHAR
3 0
VKORG
Sales Organization
VKORG TVKO
CHAR
4 0
TAXK1
IS-M: Tax classification for business partner
JTACLGP1
CHAR
1 0
TAXK2
IS-M: Tax classification 2 for business partner
JTACLGP2
CHAR
1 0
TAXK3
IS-M: Tax classification 3 for business partner
JTACLGP3
CHAR
1 0
TAXK4
IS-M: Tax classification 4 for business partner
JTACLGP4
CHAR
1 0
TAXK5
IS-M: Tax classification 5 for business partner
JTACLGP5
CHAR
1 0
TAXK6
IS-M: Tax classification 6 for business partner
JTACLGP6
CHAR
1 0
TAXK7
IS-M: Tax classification 7 for business partner
JTACLGP7
CHAR
1 0
TAXK8
IS-M: Tax classification 8 for business partner
JTACLGP8
CHAR
1 0
TAXK9
IS-M: Tax classification 9 for business partner
JTACLGP9
CHAR
1 0
UEBAR
IS-M: Transfer type
JHUEBART TJH41
CHAR
1 0
WAERK
SD Document Currency
WAERK TCURC
CUKY
5 0
ZTERM
Terms of Payment Key
DZTERM
CHAR
4 0
VALTG
Additional value days
VALTG
NUMC
2 0
VALDT
Fixed value date
VALDT
DATS
8 0
ZLSCH
Payment Method
SCHZW_BSEG T042Z
CHAR
1 0
MSCHL
Dunning key
MSCHL T040
CHAR
1 0
MANSP
Dunning block
MANSP T040S
CHAR
1 0
NATIO
International address version ID
INTER TSAV
CHAR
1 0
ADRNR
IS-M: One-Time Customer Address
ISM_CPDADDRNUM ADRC
CHAR
10 0
CCINS
Payment cards: Card type
CCINS TVCIN
CHAR
4 0
CCNUM
Payment cards: Card number
CCNUM VCNUM
CHAR
25 0
DATBI
Payment Cards: Valid To
DATBI_CC
DATS
8 0
CCNAME
Payment cards: Name of cardholder
CCNAME
CHAR
40 0
CCAUA
Payment cards: Authorization type
CCAUA
CHAR
1 0
CCACT
G/L Account Number for Payment Card Receivables
CCACT SKA1
CHAR
10 0
AUDAT_CC
Payment cards: Authorization date
AUDAT_CC
DATS
8 0
AUTIM
Payment cards: Authorization time
AUTIM
TIMS
6 0
CCALL
Payment cards: Status when external system is called?
CCALL
CHAR
1 0
REACT
Payment cards: Response to authorization checks
REACT_SD
CHAR
1 0
AUTWR
Payment cards: Authorized amount
AUTWR
CURR
15 2
CCWAE
Currency Key
WAERS TCURC
CUKY
5 0
AUNUM
Payment cards: Authorization number
AUNUM
CHAR
10 0
AUTRA
Payment cards: Authoriz. reference code of clearing house
AUTRA
CHAR
15 0
SETTL
Payment cards: Settlement carried out
SETTL
CHAR
1 0
CGUID
GUID of a Payment Card
CARD_GUID
RAW
16 0
ENCTP
Type of Encryption
CCSECA_ENCTYPE
CHAR
1 0
IBAN
IBAN (International Bank Account Number)
IBAN
CHAR
34 0
MNDID
Unique Referene to Mandate per Payment Recipient
SEPA_MNDID
CHAR
35 0
STTYP
IS-M: Reversal Type
STORNOTYP
CHAR
1 0
MRNKZ
Manual invoice maintenance
MRNKZ
CHAR
1 0
EXPKZ
Export indicator
EXPKZ
CHAR
1 0
EXNUM
Number of foreign trade data in MM and SD documents
EXNUM EIKP
CHAR
10 0
POPER
Posting period
POPER
NUMC
3 0
GJAHR
Fiscal Year
GJAHR
NUMC
4 0
MONAT
Fiscal Period
MONAT
NUMC
2 0
XBLNR
Reference Document Number
XBLNR1
CHAR
16 0
ZUONR
Assignment Number
DZUONR
CHAR
18 0
BELNR
Accounting Document Number
BELNR_D
CHAR
10 0
UNRFI
IS-M: Field is not used
JHUNRFI
CHAR
10 0
KURRF
Exchange rate for FI postings
KURRF
DEC
9 5
CPKUR
ID:Exchange rate setting (no new rate determ.in bill.doc.)
CPKUR
CHAR
1 0
BRTWK
IS-M: Gross Value in Document Currency (Header)
JHBRTWRK
CURR
15 2
NETWK
Net Value in Document Currency
NETWR
CURR
15 2
MWSBK
Tax amount in document currency
MWSBP
CURR
13 2
STWAE
Statistics currency
STWAE TCURC
CUKY
5 0
STAFO
IS-M: Update group for statistics update
JHSTAFO TMCB
CHAR
6 0
RFBSK
IS-M/AM: Status for Transfer to Accounting / HR
JHRFBSK
CHAR
1 0
STAFI
IS-M: Status of the Financial Accounting Document
ISMSTAFI
CHAR
1 0
MABER
Dunning Area
MABER T047M
CHAR
2 0
VBTYP
IS-M/AM: Sales Document Category
ISPVBTYP
CHAR
1 0
PERFK
Invoice dates (calendar identification)
PERFK TFACD
CHAR
2 0
BUKRS
Company Code
BUKRS T001
CHAR
4 0
KTGRD
Account assignment group for this customer
KTGRD TVKT
CHAR
2 0
PLTYP
Price list type
PLTYP T189
CHAR
2 0
KUNRG
IS-M: Payer
REGULIERER JGTGPNR
CHAR
10 0
KUNRE
IS-M: Business Partner - Bill-To Party
GPNR_RECH JGTGPNR
CHAR
10 0
STCEG
VAT Registration Number
STCEG
CHAR
20 0
STCEG_H
Origin of sales tax ID number
STCEG_H
CHAR
1 0
STCEG_L
Country of Sales Tax ID Number
STCEG_L T005
CHAR
3 0
LANDTX
Tax departure country
LANDTX
CHAR
3 0
COUNC
County Code
COUNC
CHAR
3 0
CITYC
City Code
CITYC
CHAR
4 0
TXJCD
Tax Jurisdiction
TXJCD
CHAR
15 0
ZUKRI
Combination criteria in the billing document
DZUKRI
CHAR
40 0
LOGSYS
Logical system
LOGSYS TBDLS
CHAR
10 0
EKORG
Purchasing Organization
EKORG T024E
CHAR
4 0
KREZE
IS-M: Payee
JHKREZE JGTGPNR
CHAR
10 0
KRERS
IS-M: Invoicing Party
JHKRERS JGTGPNR
CHAR
10 0
VNR
IS-M: Media Sales Agent Contract Number
JVMVVNR JJTVV
CHAR
10 0
VTYP
IS-M: Contract Category for Media Sales Agent Contract
JVERMVTYP
CHAR
1 0
KTGRV
IS-M: Account Assignment Group for Sales Agent Contract
KTGRV TJJAF
CHAR
2 0
UEBERLART
IS-M: Transfer Destination
UEBERLZIEL
CHAR
1 0
PERNR
IS-M: Personnel Number
JJPERNR
CHAR
20 0
VTNR
IS-M: Contract Number
ABS_VTNR JHTVKO
NUMC
6 0
ABRGNR
IS-M/AM: Contract Settlement Number
ABRGNR JHTVAABK
NUMC
4 0
FAB_PROZNT
IS-M: Percentage Rate for Receivables Charge-Off
FAB_PROZNT
DEC
6 3
SD_VBELN_VF
IS-M: SD Billing Number Referenced
JHVBELN_VF
CHAR
10 0
SD_NEWGL_STA
Order Status newGL Enhancement
ISM_SPLIT_CRITERION_STATUS
CHAR
1 0

JHTFK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JHTFK ABRGNR SYST MANDT JHTVAABK
IS-M/AM: Contract Settlement Header Data
MANDT
JHTFK ABRGNR JHTFK VTNR JHTVAABK
IS-M/AM: Contract Settlement Header Data
VTNR
JHTFK ABRGNR JHTFK ABRGNR JHTVAABK
IS-M/AM: Contract Settlement Header Data
ABRGNR
JHTFK ADRNR SYST MANDT ADRC
Addresses (Business Address Services)
CLIENT
JHTFK ADRNR JHTFK ADRNR ADRC
Addresses (Business Address Services)
ADDRNUMBER
JHTFK ADRNR * ADRC
Addresses (Business Address Services)
DATE_FROM
JHTFK ADRNR * ADRC
Addresses (Business Address Services)
NATION
JHTFK BANKS SYST MANDT T005
Countries
MANDT
JHTFK BANKS JHTFK BANKS T005
Countries
LAND1
JHTFK BUKRS SYST BUKRS T001
Company Codes
MANDT
JHTFK BUKRS JHTFK BUKRS T001
Company Codes
BUKRS
JHTFK CCACT SYST MANDT SKA1
G/L Account Master (Chart of Accounts)
MANDT
JHTFK CCACT * SKA1
G/L Account Master (Chart of Accounts)
KTOPL
JHTFK CCACT JHTFK CCACT SKA1
G/L Account Master (Chart of Accounts)
SAKNR
JHTFK CCINS SYST MANDT TVCIN
Payment cards: Type
MANDT
JHTFK CCINS JHTFK CCINS TVCIN
Payment cards: Type
CCINS
JHTFK CCNUM SYST MANDT VCNUM
Credit card master
MANDT
JHTFK CCNUM JHTFK CCINS VCNUM
Credit card master
CCINS
JHTFK CCNUM JHTFK CCNUM VCNUM
Credit card master
CCNUM
JHTFK CCWAE JHTFK CCWAE TCURC
Currency Codes
WAERS
JHTFK CCWAE SYST MANDT TCURC
Currency Codes
MANDT
JHTFK EKORG SYST MANDT T024E
Purchasing Organizations
MANDT
JHTFK EKORG JHTFK EKORG T024E
Purchasing Organizations
EKORG
JHTFK EXNUM SYST MANDT EIKP
Foreign Trade: Export/Import Header Data
MANDT
JHTFK EXNUM JHTFK EXNUM EIKP
Foreign Trade: Export/Import Header Data
EXNUM
JHTFK FKART SYST MANDT TJH05
IS-M/AM: Billing: Document Types
MANDT
JHTFK FKART JHTFK FKART TJH05
IS-M/AM: Billing: Document Types
FKART
JHTFK FKTYP SYST MANDT TJH19
IS-M/AM: Billing Category
MANDT
JHTFK FKTYP JHTFK FKTYP TJH19
IS-M/AM: Billing Category
FKTYP
JHTFK INCO1 SYST MANDT TINC
Customers: Incoterms
MANDT
JHTFK INCO1 JHTFK INCO1 TINC
Customers: Incoterms
INCO1
JHTFK KRERS JHTFK MANDT JGTGPNR
IS-M: Central Business Partner Table
MANDT
JHTFK KRERS JHTFK KRERS JGTGPNR
IS-M: Central Business Partner Table
GPNR
JHTFK KREZE JHTFK MANDT JGTGPNR
IS-M: Central Business Partner Table
MANDT
JHTFK KREZE JHTFK KREZE JGTGPNR
IS-M: Central Business Partner Table
GPNR
JHTFK KTGRD JHTFK KTGRD TVKT
Customers: Account Assignment Groups
KTGRD
JHTFK KTGRD SYST MANDT TVKT
Customers: Account Assignment Groups
MANDT
JHTFK KTGRV * TJJAF
IS-M/AM: Account Assignment Group for Sales Agent Contract
MANDT
JHTFK KTGRV JHTFK KTGRV TJJAF
IS-M/AM: Account Assignment Group for Sales Agent Contract
KTGRV
JHTFK KUNRE JHTFK KUNRE JGTGPNR
IS-M: Central Business Partner Table
GPNR
JHTFK KUNRE SYST MANDT JGTGPNR
IS-M: Central Business Partner Table
MANDT
JHTFK KUNRG SYST MANDT JGTGPNR
IS-M: Central Business Partner Table
MANDT
JHTFK KUNRG JHTFK KUNRG JGTGPNR
IS-M: Central Business Partner Table
GPNR
JHTFK KURST SYST MANDT TCURV
Exchange rate types for currency translation
MANDT
JHTFK KURST JHTFK KURST TCURV
Exchange rate types for currency translation
KURST
JHTFK LAND1 JHTFK LAND1 T005
Countries
LAND1
JHTFK LAND1 SYST MANDT T005
Countries
MANDT
JHTFK LOGSYS JHTFK LOGSYS TBDLS
Logical system
LOGSYS
JHTFK MABER JHTFK BUKRS T047M
Dunning areas
BUKRS
JHTFK MABER JHTFK MABER T047M
Dunning areas
MABER
JHTFK MABER SYST MANDT T047M
Dunning areas
MANDT
JHTFK MANDT JHTFK MANDT T000
Clients
MANDT
JHTFK MANSP JHTFK MANSP T040S
Blocking reasons for dunning notices
MANSP
JHTFK MANSP SYST MANDT T040S
Blocking reasons for dunning notices
MANDT
JHTFK MSCHL SYST MANDT T040
Dunning keys
MANDT
JHTFK MSCHL JHTFK MSCHL T040
Dunning keys
MSCHL
JHTFK NATIO JHTFK NATIO TSAV
Address Versions (Business Address Services) (Obsolete)
NATIO
JHTFK PERFK JHTFK PERFK TFACD
Factory calendar definition
IDENT
JHTFK PLTYP SYST MANDT T189
Conditions: Price List Categories
MANDT
JHTFK PLTYP JHTFK PLTYP T189
Conditions: Price List Categories
PLTYP
JHTFK REGIO SYST MANDT T005S
Taxes: Region (Province) Key
MANDT
JHTFK REGIO JHTFK LAND1 T005S
Taxes: Region (Province) Key
LAND1
JHTFK REGIO JHTFK REGIO T005S
Taxes: Region (Province) Key
BLAND
JHTFK SFAKN SYST MANDT JHTFK
IS-M/AM: Settlement Documents (Billing, Commission) - Header
MANDT
JHTFK SFAKN JHTFK SFAKN JHTFK
IS-M/AM: Settlement Documents (Billing, Commission) - Header
VBELN
JHTFK STAFO SYST MANDT TMCB
Update groups
MANDT
JHTFK STAFO JHTFK STAFO TMCB
Update groups
STAFO
JHTFK STCEG_L SYST MANDT T005
Countries
MANDT
JHTFK STCEG_L JHTFK STCEG_L T005
Countries
LAND1
JHTFK STWAE SYST MANDT TCURC
Currency Codes
MANDT
JHTFK STWAE JHTFK STWAE TCURC
Currency Codes
WAERS
JHTFK UEBAR SYST MANDT TJH41
IS-M/AM: Transfer Type
MANDT
JHTFK UEBAR JHTFK UEBAR TJH41
IS-M/AM: Transfer Type
UEBAR
JHTFK VKORG SYST MANDT TVKO
Organizational Unit: Sales Organizations
MANDT
JHTFK VKORG JHTFK VKORG TVKO
Organizational Unit: Sales Organizations
VKORG
JHTFK VNR JHTFK VNR JJTVV
IS-M/AM: Media Sales Agent Contract
VNR
JHTFK VNR SYST MANDT JJTVV
IS-M/AM: Media Sales Agent Contract
MANDT
JHTFK VTNR SYST MANDT JHTVKO
IS-M/AM: Contract
MANDT
JHTFK VTNR JHTFK VTNR JHTVKO
IS-M/AM: Contract
VTNR
JHTFK WAERK SYST MANDT TCURC
Currency Codes
MANDT
JHTFK WAERK JHTFK WAERK TCURC
Currency Codes
WAERS
JHTFK ZLSCH SYST MANDT T042Z
Payment Methods for Automatic Payment
MANDT
JHTFK ZLSCH JHTFK LAND1 T042Z
Payment Methods for Automatic Payment
LAND1
JHTFK ZLSCH JHTFK ZLSCH T042Z
Payment Methods for Automatic Payment
ZLSCH