1. Home
  2. Resources
  3. SAP Tables
  4. JHTFK - IS-M/AM: Settlement Documents (Billing, Commission) - Header

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
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
X Yes
NULL No
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
NULL Automatic authorization
A Manual authorization
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
NULL Not Relevant
A External system not reached
B External system reached: no response
C External system reached: response received
REACT Payment cards: Response to authorization checks REACT_SD CHAR 1 0
NULL Not Relevant
A Checks successful
B Unsuccessful: authorize later
C Unsuccessful: set authorization lock
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
X Yes
NULL No
CGUID GUID of a Payment Card CARD_GUID RAW 16 0
ENCTP Type of Encryption CCSECA_ENCTYPE CHAR 1 0
1 Data in PCA_SECURITY_RAW
2 Data in CCSEC_ENC or CCSEC_ENCV
3 Data in CCARDEC
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
X Full Reversal
F Charged Off Receivable
NULL Not Reversed
T Partial Reversal
MRNKZ Manual invoice maintenance MRNKZ CHAR 1 0
X Yes
NULL No
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
NULL No exchange rate setting
X Exchange rate setting
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
A Billing Document Blocked for Transfer
B Posting Document not Created (Account Determ.Error)
C Posting Document has been Created
D Billing Document Not Relevant for Transfer
E Billing Document Completed by Reversal
F Posting Document not Created (Pricing Error)
G Posting Document not Created (Export Data Missing)
H Posting Using Invoice List
I Posting Using Invoice List (Account Determination Error)
J Posting Document Generated, Selection is Still Incomplete
NULL Billing Document Has Not Yet Been Transferred to FI/HR
1 Billing Document is Incomplete (Data Missing) -> See Log
STAFI IS-M: Status of the Financial Accounting Document ISMSTAFI CHAR 1 0
0 Not relevant for status confirmation
1 FI document not cleared
2 FI document cleared
3 FI document not cleared, reversal performed
4 FI document cleared, reversal performed
MABER Dunning Area MABER T047M CHAR 2 0
VBTYP IS-M/AM: Sales Document Category ISPVBTYP CHAR 1 0
A Inquiry
B Offer
C Order
K Credit Memo Request
M Invoice
N Reverse Invoice
O Credit Memo
P Debit Memo
S Reverse Credit Memo
U Pro Forma Invoice (Not Used)
2 External Transaction
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
A Ship-to party
B Payer
C Sold-to party
D Payer (KNAS segment)
E Manually entered or changed
F Entered manually in order
G Own VAT reg. no. in dest. country
H Payer for tax receiving country from order
I Sold-to party for tax receiving country from order
J Sold to party (segment KNAS)
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
2 Sales Agent
1 Occasional Sales Agent
KTGRV IS-M: Account Assignment Group for Sales Agent Contract KTGRV TJJAF CHAR 2 0
UEBERLART IS-M: Transfer Destination UEBERLZIEL CHAR 1 0
NULL No transfer
0 Human Resources
1 Financial Accounting
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
N newGL Enhancement Active
O newGL Enhancement Inactive
X No Billing Dataset Available
NULL newGL Enhancement Inactive

JHTFK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
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 ABRGNR SYST MANDT JHTVAABK IS-M/AM: Contract Settlement Header Data MANDT
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 ADRNR SYST MANDT ADRC Addresses (Business Address Services) CLIENT
JHTFK BANKS SYST MANDT T005 Countries MANDT
JHTFK BANKS JHTFK BANKS T005 Countries LAND1
JHTFK BUKRS JHTFK BUKRS T001 Company Codes BUKRS
JHTFK BUKRS SYST BUKRS T001 Company Codes MANDT
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 JHTFK CCINS TVCIN Payment cards: Type CCINS
JHTFK CCINS SYST MANDT TVCIN Payment cards: Type MANDT
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 JHTFK FKART TJH05 IS-M/AM: Billing: Document Types FKART
JHTFK FKART SYST MANDT TJH05 IS-M/AM: Billing: Document Types MANDT
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 SYST MANDT TVKT Customers: Account Assignment Groups MANDT
JHTFK KTGRD JHTFK KTGRD TVKT Customers: Account Assignment Groups KTGRD
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 SYST MANDT JGTGPNR IS-M: Central Business Partner Table MANDT
JHTFK KUNRE JHTFK KUNRE JGTGPNR IS-M: Central Business Partner Table GPNR
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 JHTFK KURST TCURV Exchange rate types for currency translation KURST
JHTFK KURST SYST MANDT TCURV Exchange rate types for currency translation MANDT
JHTFK LAND1 SYST MANDT T005 Countries MANDT
JHTFK LAND1 JHTFK LAND1 T005 Countries LAND1
JHTFK LOGSYS JHTFK LOGSYS TBDLS Logical system LOGSYS
JHTFK MABER JHTFK MABER T047M Dunning areas MABER
JHTFK MABER SYST MANDT T047M Dunning areas MANDT
JHTFK MABER JHTFK BUKRS T047M Dunning areas BUKRS
JHTFK MANDT JHTFK MANDT T000 Clients MANDT
JHTFK MANSP SYST MANDT T040S Blocking reasons for dunning notices MANDT
JHTFK MANSP JHTFK MANSP T040S Blocking reasons for dunning notices MANSP
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