SAP ABAP Table JHTFK (IS-M/AM: Settlement Documents (Billing, Commission) - Header)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷ IS-M (Application Component) SAP Media
⤷ JAS (Package) Application development R/3 Publishing Advertising System***
⤷ IS-M (Application Component) SAP Media
⤷ JAS (Package) Application development R/3 Publishing Advertising System***
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | JHTFK | Table Relationship Diagram |
Short Description | IS-M/AM: Settlement Documents (Billing, Commission) - Header |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | VBELN | JJBELNR | JJBELNR | CHAR | 10 | 0 | IS-M/AM: Billing Document | ||
3 | .INCLUDE | 0 | 0 | IS-M/AM: Settlement Documents - Header- Data Part | |||||
4 | .INCLUDE | 0 | 0 | IS-PAM: Settlement Documents - Header - Gen.Customer Fields | |||||
5 | .INCLUDE | 0 | 0 | Created-By Data (Medium Scope) | |||||
6 | ERFUSER | ERFUSER | USNAM | CHAR | 12 | 0 | Created By | ||
7 | ERFDATE | ERFDATE | DATUM | DATS | 8 | 0 | Created On | ||
8 | ERFTIME | ERFTIME | UZEIT | TIMS | 6 | 0 | Time Created | ||
9 | AENUSER | AENUSER | USNAM | CHAR | 12 | 0 | Last Changed By | ||
10 | AENDATE | AENDATE | DATUM | DATS | 8 | 0 | Date of Last Change | ||
11 | AENTIME | AENTIME | UZEIT | TIMS | 6 | 0 | Time of Last Change | ||
12 | .INCLUDE | 0 | 0 | IS-M: Settlement Document - Customer Hdr Fields -Interface | |||||
13 | SFAKN | JJBELNRSV | JJBELNR | CHAR | 10 | 0 | IS-M: Reversal Reference | JHTFK | |
14 | XEZER | XEZER | XFELD | CHAR | 1 | 0 | Indicator: Is there collection authorization ? | ||
15 | BANKS | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | T005 | |
16 | BANKN | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
17 | BANKL | BANKL | BANKL | CHAR | 15 | 0 | Bank number | ||
18 | BKONT | BKONT | BKONT | CHAR | 2 | 0 | Bank Control Key | ||
19 | BVTYP | BVTYP | BVTYP | CHAR | 4 | 0 | Partner bank type | ||
20 | FKART | FKART_PAM | FKART_PAM | CHAR | 4 | 0 | IS-M/AM: Billing/Settlement Document Type | TJH05 | |
21 | FKDAT | JHFKDAT | DATUM | DATS | 8 | 0 | IS-M: Actual Billing/Settlement Date | ||
22 | FKTYP | JHFKTYP | JHFKTYP | CHAR | 1 | 0 | IS-M/AM: Billing Category | TJH19 | |
23 | INCO1 | INCO1 | INCO1 | CHAR | 3 | 0 | Incoterms (part 1) | TINC | |
24 | INCO2 | INCO2 | INCO2 | CHAR | 28 | 0 | Incoterms (part 2) | ||
25 | KNUMV | KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
26 | KURST | KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | TCURV | |
27 | LAND1 | LLAND | LAND1 | CHAR | 3 | 0 | Destination Country | T005 | |
28 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
29 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
30 | .INCLUDE | 0 | 0 | IS-M/AM: Tax classification for business partner | |||||
31 | TAXK1 | JTACLGP1 | JTACLGP | CHAR | 1 | 0 | IS-M: Tax classification for business partner | ||
32 | TAXK2 | JTACLGP2 | JTACLGP | CHAR | 1 | 0 | IS-M: Tax classification 2 for business partner | ||
33 | TAXK3 | JTACLGP3 | JTACLGP | CHAR | 1 | 0 | IS-M: Tax classification 3 for business partner | ||
34 | TAXK4 | JTACLGP4 | JTACLGP | CHAR | 1 | 0 | IS-M: Tax classification 4 for business partner | ||
35 | TAXK5 | JTACLGP5 | JTACLGP | CHAR | 1 | 0 | IS-M: Tax classification 5 for business partner | ||
36 | TAXK6 | JTACLGP6 | JTACLGP | CHAR | 1 | 0 | IS-M: Tax classification 6 for business partner | ||
37 | TAXK7 | JTACLGP7 | JTACLGP | CHAR | 1 | 0 | IS-M: Tax classification 7 for business partner | ||
38 | TAXK8 | JTACLGP8 | JTACLGP | CHAR | 1 | 0 | IS-M: Tax classification 8 for business partner | ||
39 | TAXK9 | JTACLGP9 | JTACLGP | CHAR | 1 | 0 | IS-M: Tax classification 9 for business partner | ||
40 | UEBAR | JHUEBART | JHUEBART | CHAR | 1 | 0 | IS-M: Transfer type | TJH41 | |
41 | WAERK | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | TCURC | |
42 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
43 | VALTG | VALTG | TAGE2 | NUMC | 2 | 0 | Additional value days | ||
44 | VALDT | VALDT | DATUM | DATS | 8 | 0 | Fixed value date | ||
45 | ZLSCH | SCHZW_BSEG | ZLSCH | CHAR | 1 | 0 | Payment Method | T042Z | |
46 | MSCHL | MSCHL | MSCHL | CHAR | 1 | 0 | Dunning key | T040 | |
47 | MANSP | MANSP | MANSP | CHAR | 1 | 0 | Dunning block | T040S | |
48 | NATIO | INTER | NATION | CHAR | 1 | 0 | International address version ID | TSAV | |
49 | ADRNR | ISM_CPDADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | IS-M: One-Time Customer Address | ADRC | |
50 | .INCLUDE | 0 | 0 | IS-M/AM: Payment cards: Data in Billing | |||||
51 | CCINS | CCINS | CCINS | CHAR | 4 | 0 | Payment cards: Card type | TVCIN | |
52 | CCNUM | CCNUM | CCNUM | CHAR | 25 | 0 | Payment cards: Card number | VCNUM | |
53 | DATBI | DATBI_CC | DATUM | DATS | 8 | 0 | Payment Cards: Valid To | ||
54 | CCNAME | CCNAME | TEXT40 | CHAR | 40 | 0 | Payment Cards: Name of Cardholder | ||
55 | CCAUA | CCAUA | CCAUA | CHAR | 1 | 0 | Payment cards: Authorization type | ||
56 | CCACT | CCACT | SAKNR | CHAR | 10 | 0 | G/L Account Number for Payment Card Receivables | SKA1 | |
57 | AUDAT_CC | AUDAT_CC | DATUM | DATS | 8 | 0 | Payment cards: Authorization date | ||
58 | AUTIM | AUTIM | UZEIT | TIMS | 6 | 0 | Payment cards: Authorization time | ||
59 | CCALL | CCALL | CCALL | CHAR | 1 | 0 | Payment cards: Status when external system is called? | ||
60 | REACT | REACT_SD | REACT_SD | CHAR | 1 | 0 | Payment cards: Response to authorization checks | ||
61 | AUTWR | AUTWR | WERTV8 | CURR | 15 | 2 | Payment cards: Authorized amount | ||
62 | CCWAE | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
63 | AUNUM | AUNUM | CHAR10 | CHAR | 10 | 0 | Payment cards: Authorization number | ||
64 | AUTRA | AUTRA | CHAR15 | CHAR | 15 | 0 | Payment cards: Authoriz. reference code of clearing house | ||
65 | SETTL | SETTL | XFELD | CHAR | 1 | 0 | Payment cards: Settlement carried out | ||
66 | .INCLUDE | 0 | 0 | Credit Card Encryption | |||||
67 | CGUID | CARD_GUID | SYSUUID | RAW | 16 | 0 | GUID of a Payment Card | ||
68 | ENCTP | CCSECA_ENCTYPE | CCSECA_ENCTYPE | CHAR | 1 | 0 | Type of Encryption | ||
69 | .INCLUDE | 0 | 0 | IS-M/AM: Include for IBAN | |||||
70 | IBAN | IBAN | IBAN | CHAR | 34 | 0 | IBAN (International Bank Account Number) | ||
71 | .INCLUDE | 0 | 0 | IS-M/AM: Include for SEPA Mandates | |||||
72 | MNDID | SEPA_MNDID | ID035 | CHAR | 35 | 0 | Unique Referene to Mandate per Payment Recipient | ||
73 | STTYP | STORNOTYP | STORNOTYP | CHAR | 1 | 0 | IS-M: Reversal Type | ||
74 | MRNKZ | MRNKZ | XFELD | CHAR | 1 | 0 | Manual invoice maintenance | ||
75 | EXPKZ | EXPKZ | EXPKZ | CHAR | 1 | 0 | Export indicator | ||
76 | EXNUM | EXNUM | EXNUM | CHAR | 10 | 0 | Number of foreign trade data in MM and SD documents | EIKP | |
77 | POPER | POPER | POPER | NUMC | 3 | 0 | Posting period | ||
78 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
79 | MONAT | MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
80 | XBLNR | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
81 | ZUONR | DZUONR | ZUONR | CHAR | 18 | 0 | Assignment number | ||
82 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
83 | UNRFI | JHUNRFI | CHAR10 | CHAR | 10 | 0 | IS-M: Field is not used | ||
84 | KURRF | KURRF | KURRF | DEC | 9 | 5 | Exchange rate for FI postings | ||
85 | CPKUR | CPKUR | CPKUR | CHAR | 1 | 0 | ID:Exchange rate setting (no new rate determ.in bill.doc.) | ||
86 | BRTWK | JHBRTWRK | WERTV8 | CURR | 15 | 2 | IS-M: Gross Value in Document Currency (Header) | ||
87 | NETWK | NETWR | WERTV8 | CURR | 15 | 2 | Net Value in Document Currency | ||
88 | MWSBK | MWSBP | WERTV7 | CURR | 13 | 2 | Tax amount in document currency | ||
89 | STWAE | STWAE | WAERS | CUKY | 5 | 0 | Statistics currency | TCURC | |
90 | STAFO | JHSTAFO | STAFO | CHAR | 6 | 0 | IS-M: Update group for statistics update | TMCB | |
91 | RFBSK | JHRFBSK | JHRFBSK | CHAR | 1 | 0 | IS-M/AM: Status for Transfer to Accounting / HR | ||
92 | STAFI | ISMSTAFI | ISMSTAFI | CHAR | 1 | 0 | IS-M: Status of the Financial Accounting Document | ||
93 | MABER | MABER | MABER | CHAR | 2 | 0 | Dunning Area | T047M | |
94 | VBTYP | ISPVBTYP | ISPVBTYP | CHAR | 1 | 0 | IS-M/AM: Sales Document Category | ||
95 | PERFK | PERFK | WFCID | CHAR | 2 | 0 | Invoice dates (calendar identification) | TFACD | |
96 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
97 | KTGRD | KTGRD | KTGRD | CHAR | 2 | 0 | Account assignment group for this customer | TVKT | |
98 | PLTYP | PLTYP | PLTYP | CHAR | 2 | 0 | Price list type | T189 | |
99 | KUNRG | REGULIERER | GPNR | CHAR | 10 | 0 | IS-M: Payer | JGTGPNR | |
100 | KUNRE | GPNR_RECH | GPNR | CHAR | 10 | 0 | IS-M: Business Partner - Bill-To Party | JGTGPNR | |
101 | STCEG | STCEG | STCEG | CHAR | 20 | 0 | VAT Registration Number | ||
102 | STCEG_H | STCEG_H | STCEG_H | CHAR | 1 | 0 | Origin of sales tax ID number | ||
103 | STCEG_L | STCEG_L | LAND1 | CHAR | 3 | 0 | Country of sales tax ID number | T005 | |
104 | LANDTX | LANDTX | LAND1 | CHAR | 3 | 0 | Tax Departure Country | * | |
105 | COUNC | COUNC | COUNC | CHAR | 3 | 0 | County Code | * | |
106 | CITYC | CITYC | CITYC | CHAR | 4 | 0 | City Code | * | |
107 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
108 | ZUKRI | DZUKRI | CHAR40 | CHAR | 40 | 0 | Combination criteria in the billing document | ||
109 | LOGSYS | LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system | TBDLS | |
110 | .INCLUDE | 0 | 0 | IS-PAM: Settlement documents - gen.vendor header data | |||||
111 | .INCLUDE | 0 | 0 | IS-M: Settlement docs - gen. vendor header data - interface | |||||
112 | EKORG | EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | T024E | |
113 | KREZE | JHKREZE | GPNR | CHAR | 10 | 0 | IS-M: Payee | JGTGPNR | |
114 | KRERS | JHKRERS | GPNR | CHAR | 10 | 0 | IS-M: Invoicing Party | JGTGPNR | |
115 | .INCLUDE | 0 | 0 | IS-PAM: Settlement documents - header - commission fields | |||||
116 | .INCLUDE | 0 | 0 | IS-PAM: Settlement Documents - Header Commission Data-Intrf. | |||||
117 | VNR | JVMVVNR | JVMVVNR | CHAR | 10 | 0 | IS-M: Media Sales Agent Contract Number | JJTVV | |
118 | VTYP | JVERMVTYP | JVERMVTYP | CHAR | 1 | 0 | IS-M: Contract Category for Media Sales Agent Contract | ||
119 | KTGRV | KTGRV | KTGRV | CHAR | 2 | 0 | IS-M: Account Assignment Group for Sales Agent Contract | TJJAF | |
120 | UEBERLART | UEBERLZIEL | UEBERLZIEL | CHAR | 1 | 0 | IS-M: Transfer Destination | ||
121 | PERNR | JJPERNR | JPERNR | CHAR | 20 | 0 | IS-M: Personnel Number | ||
122 | .INCLUDE | 0 | 0 | IS-M: Settlement document headers - COA data interface | |||||
123 | VTNR | ABS_VTNR | ABS_VTNR | NUMC | 6 | 0 | IS-M: Contract Number | JHTVKO | |
124 | ABRGNR | ABRGNR | ABRGNR | NUMC | 4 | 0 | IS-M/AM: Contract Settlement Number | JHTVAABK | |
125 | .INCLUDE | 0 | 0 | IS-M/AM: Billing Documents - BD Header Data Via Interface | |||||
126 | FAB_PROZNT | FAB_PROZNT | DEC3_3 | DEC | 6 | 3 | IS-M: Percentage Rate for Receivables Charge-Off | ||
127 | SD_VBELN_VF | JHVBELN_VF | VBELN | CHAR | 10 | 0 | IS-M: SD Billing Number Referenced | * |
Foreign Keys
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |