JHTFK SAP (IS-M/AM: Settlement Documents (Billing, Commission) - Header) Table details
Dictionary Type: Table
Description: IS-M/AM: Settlement Documents (Billing, Commission) - Header
Description: IS-M/AM: Settlement Documents (Billing, Commission) - Header
Table field list including key, data, relationships and ABAP select examples
JHTFK is a standard SAP Table which is used to store IS-M/AM: Settlement Documents (Billing, Commission) - Header data and is available within R/3 SAP systems depending on the version and release level.
The JHTFK table consists of various fields, each holding specific information or linking keys about IS-M/AM: Settlement Documents (Billing, Commission) - Header data available in SAP. These include VBELN (IS-M/AM: Billing Document), ERFUSER (Created By), ERFDATE (Created On), ERFTIME (Time Created).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP JHTFK table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| VBELN | IS-M/AM: Billing Document | JJBELNR | CHAR | 10 | ALPHA | JJBELNR | JHB | MJHF | |
| ERFUSER | Created By | ERFUSER | CHAR | 12 | USNAM | ||||
| ERFDATE | Created On | ERFDATE | DATS | 8 | DATUM | ||||
| ERFTIME | Time Created | ERFTIME | TIMS | 6 | UZEIT | ||||
| AENUSER | Last Changed By | AENUSER | CHAR | 12 | USNAM | ||||
| AENDATE | Date of Last Change | AENDATE | DATS | 8 | DATUM | ||||
| AENTIME | Time of Last Change | AENTIME | TIMS | 6 | UZEIT | ||||
| SFAKN | IS-M: Reversal Reference | JJBELNRSV | CHAR | 10 | JHTFK | ALPHA | JJBELNR | ||
| XEZER | Indicator: Is there collection authorization ? | XEZER | CHAR | 1 | XFELD | ||||
| BANKS | Bank country key | BANKS | CHAR | 3 | T005 | LAND1 | BKL | ||
| BANKN | Bank account number | BANKN | CHAR | 18 | BANKN | ||||
| BANKL | Bank number | BANKL | CHAR | 15 | BANKL | BLZ | |||
| BKONT | Bank Control Key | BKONT | CHAR | 2 | BKONT | ||||
| BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
| FKART | IS-M/AM: Billing/Settlement Document Type | FKART_PAM | CHAR | 4 | TJH05 | FKART_PAM | MJHFKART | ||
| FKDAT | IS-M: Actual Billing/Settlement Date | JHFKDAT | DATS | 8 | DATUM | ||||
| FKTYP | IS-M/AM: Billing Category | JHFKTYP | CHAR | 1 | TJH19 | JHFKTYP | |||
| INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | TINC | INCO1 | |||
| INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
| KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
| KURST | Exchange Rate Type | KURST | CHAR | 4 | TCURV | KURST | KUT | ||
| LAND1 | Country of Destination | LLAND | CHAR | 3 | T005 | LAND1 | VLL | ||
| REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
| VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
| TAXK1 | IS-M: Tax classification for business partner | JTACLGP1 | CHAR | 1 | JTACLGP | ||||
| TAXK2 | IS-M: Tax classification 2 for business partner | JTACLGP2 | CHAR | 1 | JTACLGP | ||||
| TAXK3 | IS-M: Tax classification 3 for business partner | JTACLGP3 | CHAR | 1 | JTACLGP | ||||
| TAXK4 | IS-M: Tax classification 4 for business partner | JTACLGP4 | CHAR | 1 | JTACLGP | ||||
| TAXK5 | IS-M: Tax classification 5 for business partner | JTACLGP5 | CHAR | 1 | JTACLGP | ||||
| TAXK6 | IS-M: Tax classification 6 for business partner | JTACLGP6 | CHAR | 1 | JTACLGP | ||||
| TAXK7 | IS-M: Tax classification 7 for business partner | JTACLGP7 | CHAR | 1 | JTACLGP | ||||
| TAXK8 | IS-M: Tax classification 8 for business partner | JTACLGP8 | CHAR | 1 | JTACLGP | ||||
| TAXK9 | IS-M: Tax classification 9 for business partner | JTACLGP9 | CHAR | 1 | JTACLGP | ||||
| UEBAR | IS-M: Transfer type | JHUEBART | CHAR | 1 | TJH41 | JHUEBART | |||
| WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | WAERS | FWS | ||
| ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
| VALTG | Additional value days | VALTG | NUMC | 2 | TAGE2 | ||||
| VALDT | Fixed value date | VALDT | DATS | 8 | DATUM | ||||
| ZLSCH | Payment Method | SCHZW_BSEG | CHAR | 1 | T042Z | ZLSCH | |||
| MSCHL | Dunning key | MSCHL | CHAR | 1 | T040 | MSCHL | |||
| MANSP | Dunning block | MANSP | CHAR | 1 | T040S | MANSP | |||
| NATIO | International address version ID | INTER | CHAR | 1 | TSAV | NATION | |||
| ADRNR | IS-M: One-Time Customer Address | ISM_CPDADDRNUM | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ||
| CCINS | Payment cards: Card type | CCINS | CHAR | 4 | TVCIN | CCINS | |||
| CCNUM | Payment cards: Card number | CCNUM | CHAR | 25 | VCNUM | CCNUM | |||
| DATBI | Payment Cards: Valid To | DATBI_CC | DATS | 8 | DATUM | ||||
| CCNAME | Payment cards: Name of cardholder | CCNAME | CHAR | 40 | TEXT40 | ||||
| CCAUA | Payment cards: Authorization type | CCAUA | CHAR | 1 | CCAUA | ||||
| CCACT | G/L Account Number for Payment Card Receivables | CCACT | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
| AUDAT_CC | Payment cards: Authorization date | AUDAT_CC | DATS | 8 | DATUM | ||||
| AUTIM | Payment cards: Authorization time | AUTIM | TIMS | 6 | UZEIT | ||||
| CCALL | Payment cards: Status when external system is called? | CCALL | CHAR | 1 | CCALL | ||||
| REACT | Payment cards: Response to authorization checks | REACT_SD | CHAR | 1 | REACT_SD | ||||
| AUTWR | Payment cards: Authorized amount | AUTWR | CURR | 15(2) | WERTV8 | ||||
| CCWAE | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
| AUNUM | Payment cards: Authorization number | AUNUM | CHAR | 10 | CHAR10 | ||||
| AUTRA | Payment cards: Authoriz. reference code of clearing house | AUTRA | CHAR | 15 | CHAR15 | ||||
| SETTL | Payment cards: Settlement carried out | SETTL | CHAR | 1 | XFELD | ||||
| CGUID | GUID of a Payment Card | CARD_GUID | RAW | 16 | SYSUUID | ||||
| ENCTP | Type of Encryption | CCSECA_ENCTYPE | CHAR | 1 | CCSECA_ENCTYPE | ||||
| IBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | IBAN | ||||
| MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
| STTYP | IS-M: Reversal Type | STORNOTYP | CHAR | 1 | STORNOTYP | ||||
| MRNKZ | Manual invoice maintenance | MRNKZ | CHAR | 1 | XFELD | ||||
| EXPKZ | Export indicator | EXPKZ | CHAR | 1 | EXPKZ | ||||
| EXNUM | Number of foreign trade data in MM and SD documents | EXNUM | CHAR | 10 | EIKP | EXNUM | |||
| POPER | Posting period | POPER | NUMC | 3 | POPER | POPR | |||
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
| MONAT | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
| XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
| ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
| BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
| UNRFI | IS-M: Field is not used | JHUNRFI | CHAR | 10 | CHAR10 | ||||
| KURRF | Exchange rate for FI postings | KURRF | DEC | 9(5) | KURRF | ||||
| CPKUR | ID:Exchange rate setting (no new rate determ.in bill.doc.) | CPKUR | CHAR | 1 | CPKUR | ||||
| BRTWK | IS-M: Gross Value in Document Currency (Header) | JHBRTWRK | CURR | 15(2) | WERTV8 | ||||
| NETWK | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
| MWSBK | Tax amount in document currency | MWSBP | CURR | 13(2) | WERTV7 | ||||
| STWAE | Statistics currency | STWAE | CUKY | 5 | TCURC | WAERS | |||
| STAFO | IS-M: Update group for statistics update | JHSTAFO | CHAR | 6 | TMCB | ALPHA | STAFO | MCF | |
| RFBSK | IS-M/AM: Status for Transfer to Accounting / HR | JHRFBSK | CHAR | 1 | JHRFBSK | ||||
| STAFI | IS-M: Status of the Financial Accounting Document | ISMSTAFI | CHAR | 1 | ISMSTAFI | ||||
| MABER | Dunning Area | MABER | CHAR | 2 | T047M | MABER | |||
| VBTYP | IS-M/AM: Sales Document Category | ISPVBTYP | CHAR | 1 | ISPVBTYP | ||||
| PERFK | Invoice dates (calendar identification) | PERFK | CHAR | 2 | TFACD | WFCID | |||
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| KTGRD | Account assignment group for this customer | KTGRD | CHAR | 2 | TVKT | KTGRD | |||
| PLTYP | Price list type | PLTYP | CHAR | 2 | T189 | PLTYP | VPL | ||
| KUNRG | IS-M: Payer | REGULIERER | CHAR | 10 | JGTGPNR | ALPHA | GPNR | MJG0 | |
| KUNRE | IS-M: Business Partner - Bill-To Party | GPNR_RECH | CHAR | 10 | JGTGPNR | ALPHA | GPNR | KUN | |
| STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
| STCEG_H | Origin of sales tax ID number | STCEG_H | CHAR | 1 | STCEG_H | ||||
| STCEG_L | Country of Sales Tax ID Number | STCEG_L | CHAR | 3 | T005 | LAND1 | LND | ||
| LANDTX | Tax departure country | LANDTX | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
| COUNC | County Code | COUNC | CHAR | 3 | Assigned to domain | COUNC | |||
| CITYC | City Code | CITYC | CHAR | 4 | Assigned to domain | CITYC | |||
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
| ZUKRI | Combination criteria in the billing document | DZUKRI | CHAR | 40 | CHAR40 | ||||
| LOGSYS | Logical system | LOGSYS | CHAR | 10 | TBDLS | ALPHA | LOGSYS | ||
| EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
| KREZE | IS-M: Payee | JHKREZE | CHAR | 10 | JGTGPNR | ALPHA | GPNR | ||
| KRERS | IS-M: Invoicing Party | JHKRERS | CHAR | 10 | JGTGPNR | ALPHA | GPNR | ||
| VNR | IS-M: Media Sales Agent Contract Number | JVMVVNR | CHAR | 10 | JJTVV | ALPHA | JVMVVNR | JJA | MJJV |
| VTYP | IS-M: Contract Category for Media Sales Agent Contract | JVERMVTYP | CHAR | 1 | JVERMVTYP | ||||
| KTGRV | IS-M: Account Assignment Group for Sales Agent Contract | KTGRV | CHAR | 2 | TJJAF | KTGRV | |||
| UEBERLART | IS-M: Transfer Destination | UEBERLZIEL | CHAR | 1 | UEBERLZIEL | ||||
| PERNR | IS-M: Personnel Number | JJPERNR | CHAR | 20 | JPERNR | ||||
| VTNR | IS-M: Contract Number | ABS_VTNR | NUMC | 6 | JHTVKO | ABS_VTNR | JHW | MJHW | |
| ABRGNR | IS-M/AM: Contract Settlement Number | ABRGNR | NUMC | 4 | JHTVAABK | ABRGNR | |||
| FAB_PROZNT | IS-M: Percentage Rate for Receivables Charge-Off | FAB_PROZNT | DEC | 6(3) | DEC3_3 | ||||
| SD_VBELN_VF | IS-M: SD Billing Number Referenced | JHVBELN_VF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VF | |
| SD_NEWGL_STA | Order Status newGL Enhancement | ISM_SPLIT_CRITERION_STATUS | CHAR | 1 | ISM_SPLIT_CRITERION_STATUS |
| Key field | Non-key field |
How do I retrieve data from SAP table JHTFK using ABAP code
The following ABAP code Example will allow you to do a basic selection on JHTFK to SELECT all data from the tableDATA: WA_JHTFK TYPE JHTFK.
SELECT SINGLE *
FROM JHTFK
INTO CORRESPONDING FIELDS OF WA_JHTFK
WHERE...
How to access SAP table JHTFK
Within an ECC or HANA version of SAP you can also view further information about JHTFK and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects