SAP TABLES | SAP Media | Advertising Management(IS-M-AM) SAP IS

JHTFK SAP IS-M/AM: Settlement Documents (Billing, Commission) - Header Table and data







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.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP JHTFK Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


SAP JHTFK Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
VBELNJJBELNRCHAR10 IS-M/AM: Billing DocumentALPHA
.INCLUDEJHIFK IS-M/AM: Settlement Documents - Header- Data Part
.INCLUDEJHIFK1 IS-PAM: Settlement Documents - Header - Gen.Customer Fields
.INCLUDEJYTUSER Created-By Data (Medium Scope)
ERFUSERERFUSERCHAR12 Created By
ERFDATEERFDATEDATS8 Created On
ERFTIMEERFTIMETIMS6 Time Created
AENUSERAENUSERCHAR12 Last Changed By
AENDATEAENDATEDATS8 Date of Last Change
AENTIMEAENTIMETIMS6 Time of Last Change
.INCLUDEJHIFK1S IS-M: Settlement Document - Customer Hdr Fields -Interface
SFAKNJJBELNRSVCHAR10 JHTFKIS-M: Reversal ReferenceALPHA
XEZERXEZERCHAR1 Indicator: Is there collection authorization ?
BANKSBANKSCHAR3 T005Bank country key
BANKNBANKNCHAR18 Bank account number
BANKLBANKLCHAR15 Bank number
BKONTBKONTCHAR2 Bank Control Key
BVTYPBVTYPCHAR4 Partner Bank Type
FKARTFKART_PAMCHAR4 TJH05IS-M/AM: Billing/Settlement Document Type
FKDATJHFKDATDATS8 IS-M: Actual Billing/Settlement Date
FKTYPJHFKTYPCHAR1 TJH19IS-M/AM: Billing Category
INCO1INCO1CHAR3 TINCIncoterms (Part 1)
INCO2INCO2CHAR28 Incoterms (Part 2)
KNUMVKNUMVCHAR10 Number of the document condition
KURSTKURSTCHAR4 TCURVExchange Rate Type
LAND1LLANDCHAR3 T005Country of Destination
VKORGVKORGCHAR4 TVKOSales Organization
.INCLUDERJHTAXK IS-M/AM: Tax classification for business partner
TAXK1JTACLGP1CHAR1 IS-M: Tax classification for business partner
TAXK2JTACLGP2CHAR1 IS-M: Tax classification 2 for business partner
TAXK3JTACLGP3CHAR1 IS-M: Tax classification 3 for business partner
TAXK4JTACLGP4CHAR1 IS-M: Tax classification 4 for business partner
TAXK5JTACLGP5CHAR1 IS-M: Tax classification 5 for business partner
TAXK6JTACLGP6CHAR1 IS-M: Tax classification 6 for business partner
TAXK7JTACLGP7CHAR1 IS-M: Tax classification 7 for business partner
TAXK8JTACLGP8CHAR1 IS-M: Tax classification 8 for business partner
TAXK9JTACLGP9CHAR1 IS-M: Tax classification 9 for business partner
UEBARJHUEBARTCHAR1 TJH41IS-M: Transfer type


WAERKWAERKCUKY5 TCURCSD Document Currency
ZTERMDZTERMCHAR4 Terms of Payment Key
VALTGVALTGNUMC2 Additional value days
VALDTVALDTDATS8 Fixed value date
ZLSCHSCHZW_BSEGCHAR1 T042ZPayment Method
MSCHLMSCHLCHAR1 T040Dunning key
MANSPMANSPCHAR1 T040SDunning block
NATIOINTERCHAR1 TSAVInternational address version ID
ADRNRISM_CPDADDRNUMCHAR10 ADRCIS-M: One-Time Customer AddressALPHA
.INCLUDEJHTFK_CCDATA IS-M/AM: Payment cards: Data in Billing
CCINSCCINSCHAR4 TVCINPayment cards: Card type
CCNUMCCNUMCHAR25 VCNUMPayment cards: Card number
DATBIDATBI_CCDATS8 Payment Cards: Valid To
CCNAMECCNAMECHAR40 Payment cards: Name of cardholder
CCAUACCAUACHAR1 Payment cards: Authorization type
CCACTCCACTCHAR10 SKA1G/L Account Number for Payment Card ReceivablesALPHA
AUDAT_CCAUDAT_CCDATS8 Payment cards: Authorization date
AUTIMAUTIMTIMS6 Payment cards: Authorization time
CCALLCCALLCHAR1 Payment cards: Status when external system is called?
REACTREACT_SDCHAR1 Payment cards: Response to authorization checks
AUTWRAUTWRCURR15(2) Payment cards: Authorized amount
CCWAEWAERSCUKY5 TCURCCurrency Key
AUNUMAUNUMCHAR10 Payment cards: Authorization number
AUTRAAUTRACHAR15 Payment cards: Authoriz. reference code of clearing house
SETTLSETTLCHAR1 Payment cards: Settlement carried out
.INCLUDEISM_CCARD_CCSEC Credit Card Encryption
CGUIDCARD_GUIDRAW16 GUID of a Payment Card
ENCTPCCSECA_ENCTYPECHAR1 Type of Encryption
.INCLUDEJHIBANK_IBAN IS-M/AM: Include for IBAN
IBANIBANCHAR34 IBAN (International Bank Account Number)
.INCLUDEJHIBANK_SEPA IS-M/AM: Include for SEPA Mandates
MNDIDSEPA_MNDIDCHAR35 Unique Referene to Mandate per Payment Recipient
STTYPSTORNOTYPCHAR1 IS-M: Reversal Type
MRNKZMRNKZCHAR1 Manual invoice maintenance
EXPKZEXPKZCHAR1 Export indicator
EXNUMEXNUMCHAR10 EIKPNumber of foreign trade data in MM and SD documents
POPERPOPERNUMC3 Posting period
GJAHRGJAHRNUMC4 Fiscal YearGJAHR
MONATMONATNUMC2 Fiscal Period


XBLNRXBLNR1CHAR16 Reference Document Number
ZUONRDZUONRCHAR18 Assignment Number
BELNRBELNR_DCHAR10 Accounting Document NumberALPHA
UNRFIJHUNRFICHAR10 IS-M: Field is not used
KURRFKURRFDEC9(5) Exchange rate for FI postingsEXCRT
CPKURCPKURCHAR1 ID:Exchange rate setting (no new rate determ.in bill.doc.)
BRTWKJHBRTWRKCURR15(2) IS-M: Gross Value in Document Currency (Header)
NETWKNETWRCURR15(2) Net Value in Document Currency
MWSBKMWSBPCURR13(2) Tax amount in document currency
STWAESTWAECUKY5 TCURCStatistics currency
STAFOJHSTAFOCHAR6 TMCBIS-M: Update group for statistics updateALPHA
RFBSKJHRFBSKCHAR1 IS-M/AM: Status for Transfer to Accounting / HR
STAFIISMSTAFICHAR1 IS-M: Status of the Financial Accounting Document
MABERMABERCHAR2 T047MDunning Area
VBTYPISPVBTYPCHAR1 IS-M/AM: Sales Document Category
PERFKPERFKCHAR2 TFACDInvoice dates (calendar identification)
BUKRSBUKRSCHAR4 T001Company Code
KTGRDKTGRDCHAR2 TVKTAccount assignment group for this customer
PLTYPPLTYPCHAR2 T189Price list type
KUNRGREGULIERERCHAR10 JGTGPNRIS-M: PayerALPHA
KUNREGPNR_RECHCHAR10 JGTGPNRIS-M: Business Partner - Bill-To PartyALPHA
STCEGSTCEGCHAR20 VAT Registration Number
STCEG_HSTCEG_HCHAR1 Origin of sales tax ID number
STCEG_LSTCEG_LCHAR3 T005Country of Sales Tax ID Number
LANDTXLANDTXCHAR3
*
Tax departure country
COUNCCOUNCCHAR3
*
County Code
CITYCCITYCCHAR4
*
City Code
TXJCDTXJCDCHAR15
*
Tax Jurisdiction
ZUKRIDZUKRICHAR40 Combination criteria in the billing document
LOGSYSLOGSYSCHAR10 TBDLSLogical systemALPHA
.INCLUDEJHIFK3 IS-PAM: Settlement documents - gen.vendor header data
.INCLUDEJHIFK3S IS-M: Settlement docs - gen. vendor header data - interface
EKORGEKORGCHAR4 T024EPurchasing Organization
KREZEJHKREZECHAR10 JGTGPNRIS-M: PayeeALPHA
KRERSJHKRERSCHAR10 JGTGPNRIS-M: Invoicing PartyALPHA
.INCLUDEJHIFK2 IS-PAM: Settlement documents - header - commission fields
.INCLUDEJHIFK2S IS-PAM: Settlement Documents - Header Commission Data-Intrf.
VNRJVMVVNRCHAR10 JJTVVIS-M: Media Sales Agent Contract NumberALPHA
VTYPJVERMVTYPCHAR1 IS-M: Contract Category for Media Sales Agent Contract

KTGRVKTGRVCHAR2 TJJAFIS-M: Account Assignment Group for Sales Agent Contract
UEBERLARTUEBERLZIELCHAR1 IS-M: Transfer Destination
PERNRJJPERNRCHAR20 IS-M: Personnel Number
.INCLUDEJHIFK4S IS-M: Settlement document headers - COA data interface
VTNRABS_VTNRNUMC6 JHTVKOIS-M: Contract Number
ABRGNRABRGNRNUMC4 JHTVAABKIS-M/AM: Contract Settlement Number
.INCLUDEJHIFK5S IS-M/AM: Billing Documents - BD Header Data Via Interface
FAB_PROZNTFAB_PROZNTDEC6(3) IS-M: Percentage Rate for Receivables Charge-Off
SD_VBELN_VFJHVBELN_VFCHAR10
*
IS-M: SD Billing Number ReferencedALPHA
SD_NEWGL_STAISM_SPLIT_CRITERION_STATUSCHAR1 Order Status newGL Enhancement



Key field
Non-key field