SAP ABAP Table JHTFP (IS-M/AM: Billing/Settlement Documents - Item)
Hierarchy
IS-M (Software Component) SAP MEDIA
   IS-M (Application Component) SAP Media
     JAS (Package) Application development R/3 Publishing Advertising System***
Basic Data
Table Category TRANSP    Transparent table 
Transparent table JHTFP   Table Relationship Diagram
Short Description IS-M/AM: Billing/Settlement Documents - Item    
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 JHTFK
3 POSNR JJPOSNR JJPOSNR NUMC 6   0   IS-M/AM: Item (number) in settlement document  
4 .INCLUDE       0   0   IS-PAM: Settlement Documents - Item - Data Part  
5 .INCLUDE       0   0   IS-M/AM: Settlement Documents - Item - Gen.Customer Fields  
6 .INCLUDE       0   0   IS-PAM: Settlement Documents - Cust.Item Fields - Interface  
7 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
8 SPART SPART SPART CHAR 2   0   Division TSPA
9 KDGRP KDGRP KDGRP CHAR 2   0   Customer group T151
10 KONDA KONDA KONDA CHAR 2   0   Price Group (Customer) T188
11 KAPPL KAPPL KAPPL CHAR 2   0   Application T681A
12 KALSM KALSMASD KALSM CHAR 6   0   Sales and Distribution: Pricing Procedure in Pricing T683
13 ARKTX ISM_ARKTX TEXT40 CHAR 40   0   IS-M: Short Text for Document Item (Billing Doc.,Settlement)  
14 AUBEL AVM_NR AVM_NR CHAR 10   0   IS-M/AM: Sales Document Number JHAK
15 AUPOS POS_NR AVM_PNR NUMC 3   0   IS-M: Order Item Number JHAP
16 AUGRP GRUPPABRNR GRUPPABR NUMC 3   0   IS-M/AM: Billing Dataset JHAGA
17 AUETE EIN_NR AVMENR NUMC 6   0   IS-M: Schedule Line JHAE
18 AVMAUART AUART_PAM AUART_PAM CHAR 4   0   IS-M: Sales Document Type TJHAK
19 AUREF AUREF XFELD CHAR 1   0   Sales document was created from reference  
20 BEINH BELEGEINH BELEINH CHAR 10   0   IS-M/AM: Booking Unit JJTBE
21 BEINH_BAS BE_BASIS BELEINH CHAR 10   0   IS-M: Basic Booking Unit JJTBE
22 DRERZ JHDRERZ DRERZ CHAR 8   0   IS-M: Publication JDTDRER
23 PVA PVA PVA CHAR 8   0   Edition JDTPVA
24 IHKOMP IKO_PREIS INHALTSKOM CHAR 8   0   IS-M: Content component for pricing call JJTIKO
25 INHK_KFM INHK_KFM INHALTSKOM CHAR 8   0   IS-M: Business Content Component JJTIKO
26 INHK_TECH2 INHK_SOVER INHALTSKOM CHAR 8   0   IS-M: Special Publication Content Component JJTIKO
27 AZAFOV AZART_AREA AZART_AREA CHAR 4   0   IS-M/AM: Fixed Format Proposal /Ad Dimensions TJJ13
28 AZAFO AZART_FORM AZART_FORM CHAR 4   0   IS-M: Shape Ad Type TJJ17
29 AZAFA AZART_FARB AZART_FARB CHAR 4   0   IS-M: Color Scheme Ad Type TJJ11
30 AZAGST AZART_GEST AZART_GEST CHAR 4   0   IS-M: Design Ad Type TJJ19
31 TERMINSPEZ TERMINSPEZ TERMINSPEZ CHAR 6   0   IS-M/AM: Specify Dates for Date Combinations *
32 VAVTYP VAVARTYP VAVARTYP CHAR 2   0   Issue Variant Type TJD05
33 CHIFFRE CHIFFRE_KZ CHIFFRE_KZ CHAR 1   0   IS-M: Box Number Indicator TJH59
34 ABSRB AB_RABATT RABATT DEC 5   2   IS-M: Current Valid Contract Discount Rate  
35 ABSBO AKTBONUS RABATT DEC 5   2   IS-M/AM: Current Valid Contract Bonus  
36 ABSFMPR AB_PREIS WERTV8 CURR 15   2   IS-M: Current Valid Price from Contract  
37 GO_PREIS GO_PREIS GO_PREIS CHAR 1   0   IS-M: Basic/Local Price  
38 INSERENT INSERENT GPNR CHAR 10   0   IS-M: Advertiser JJVDB_MK_FK
39 STICHW STICHW TEXT40 CHAR 40   0   IS-M: Keyword  
40 DIENSTL MATNR_DIEN MATNR_DIEN CHAR 18   0   IS-M: Service material number JJTDIEN
41 DITYP DIENTYP DIENTYP CHAR 4   0   IS-M: Service Type TJH71
42 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
43 EAN11 EAN11 EAN11 CHAR 18   0   International Article Number (EAN/UPC)  
44 FBUDA FBUDA DATUM DATS 8   0   Date When Services Rendered  
45 FSART ISP_FSART ISP_FSART CHAR 1   0   IS-M/AM: Billing Method  
46 KTGRM KTGRM KTGRM CHAR 2   0   Account assignment group for this material TVKM
47 KTGRB KTGRB KTGRB CHAR 2   0   IS-M: Booking Unit Account Assignment Group TJJ39
48 PRSFD PRSFD PRSFD CHAR 1   0   Carry out pricing  
49 KURSK KURSK KURRF DEC 9   5   Exchange Rate for Pricing and Statistics  
50 PRSDT PRSDT DATUM DATS 8   0   Date for pricing and exchange rate  
51 SHKZG JHSHKZG JHSHKZG CHAR 1   0   IS-M: Debit/Credit indicator  
52 SMENG SMENG MENG13 QUAN 13   3   Scale quantity in base unit of measure  
53 FKIMG FKIMG MENG13 QUAN 13   3   Actual billed quantity  
54 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure T006
55 BRGEW BRGEW MENG13 QUAN 13   3   Gross weight  
56 NTGEW NTGEW MENG13 QUAN 13   3   Net weight  
57 GEWEI GEWEI MEINS UNIT 3   0   Weight Unit T006
58 VGBEL JHVGBEL JHVGBEL CHAR 10   0   IS-M: Document Number of Template Document *
59 VGPOS JHVGPOS JHVGPOS NUMC 6   0   IS-M: Item Number of the Template Business Item  
60 VGETE GRABR_VG GRUPPABR NUMC 3   0   IS-M: Group/Settlement Number of Template Document *
61 VGTYP ISPVBTYP_V ISPVBTYP CHAR 1   0   IS-M: Preceding Sales Document Category  
62 VGOBJ JHOBJAR_V JHOBJKT CHAR 2   0   IS-M: Preceding object type TJH97
63 VGFKTYP JHVGFKTYP JHFKTYP CHAR 1   0   IS-M: Billing Category for Preceding Billing Document TJH19
64 VBELV ISMVBELV ISMVBELV CHAR 10   0   IS-M: Originating sales document  
65 POSNV ISMPOSNV ISMPOSNR NUMC 6   0   IS-M: Originating item  
66 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVBUR
67 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVKGR
68 VRKME VRKME MEINS UNIT 3   0   Sales unit T006
69 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
70 POSAR AVMPOS_ART AVMPOS_ART CHAR 2   0   IS-M: Order-Publishing-Media - Item Type TJH17
71 PRODH J_PRODH J_PRODH CHAR 18   0   IS-M/AM: Product Hierarchy JJT179
72 PSTYV PSTYV_PAM PSTYV_PAM CHAR 4   0   IS-M: Item Category for Sales Document TJHAP
73 TAXM1 TAXM1 TAXKM CHAR 1   0   Tax classification material *
74 TAXM2 TAXM2 TAXKM CHAR 1   0   Tax classification material *
75 TAXM3 TAXM3 TAXKM CHAR 1   0   Tax classification material *
76 TAXM4 TAXM4 TAXKM CHAR 1   0   Tax Classification 4 Material *
77 TAXM5 TAXM5 TAXKM CHAR 1   0   Tax classification 5 for material *
78 TAXM6 TAXM6 TAXKM CHAR 1   0   Tax classification 6 for material *
79 TAXM7 TAXM7 TAXKM CHAR 1   0   Tax classification 7 for material *
80 TAXM8 TAXM8 TAXKM CHAR 1   0   Tax Classification 8 Material *
81 TAXM9 TAXM9 TAXKM CHAR 1   0   Tax Classification 9 Material *
82 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
83 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
84 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center CSKS
85 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center CEPC
86 RK_AUFNR J_RK_AUFNR J_RK_AUFNR CHAR 8   0   Order Number of RK Order for Account Assignment  
87 RK_POSNR J_RK_POSNR J_RK_POSNR NUMC 2   0   Item Number of RK Order for Account Assignment  
88 KOSTL_R2 KOSTL_R2 KOSTL_R2 CHAR 8   0   Cost center in R/2  
89 STGRB BEGRP_STAT BEGRP_STAT CHAR 4   0   IS-M: BU Grouping for Statistics TJJ67
90 STAFO JHSTAFO STAFO CHAR 6   0   IS-M: Update group for statistics update TMCB
91 SKTOF SKTOF XFELD CHAR 1   0   Cash discount indicator  
92 RRREL ISMRR_RELTYP ISMRR_RELTYP CHAR 1   0   IS-M/AM: Revenue Recognition Category  
93 RRSTA     CHAR 1   0    
94 CAMPAIGN ISM_MARKETING_CAMPAIGN ISM_MARKETING_CAMPAIGN RAW 16   0   IS-M: Marketing Campaign  
95 .INCLUDE       0   0   Created-By Data (Medium Scope)  
96 ERFUSER ERFUSER USNAM CHAR 12   0   Created By  
97 ERFDATE ERFDATE DATUM DATS 8   0   Created On  
98 ERFTIME ERFTIME UZEIT TIMS 6   0   Time Created  
99 AENUSER AENUSER USNAM CHAR 12   0   Last Changed By  
100 AENDATE AENDATE DATUM DATS 8   0   Date of Last Change  
101 AENTIME AENTIME UZEIT TIMS 6   0   Time of Last Change  
102 KUNAG GPAG GPNR CHAR 10   0   Business Partner: Sold-to Party JGTGPNR
103 ELAND LLAND LAND1 CHAR 3   0   Destination Country T005
104 POSPA POSPA POSNR NUMC 6   0   Item number in the partner segment *
105 PLTYP_AUFT PLTYP_AUFT PLTYP CHAR 2   0   Price list type of sales order *
106 MPROK MPROK MPROK CHAR 1   0   Status manual price change  
107 KOWRR KOWRR KOWRR CHAR 1   0   Statistical values  
108 BONBA BONBA WERTV7 CURR 13   2   Rebate basis 1  
109 KZWI1 KZWI1 WERTV7 CURR 13   2   Subtotal 1 from pricing procedure for condition  
110 KZWI2 KZWI2 WERTV7 CURR 13   2   Subtotal 2 from pricing procedure for condition  
111 KZWI3 KZWI3 WERTV7 CURR 13   2   Subtotal 3 from pricing procedure for condition  
112 KZWI4 KZWI4 WERTV7 CURR 13   2   Subtotal 4 from pricing procedure for condition  
113 KZWI5 KZWI5 WERTV7 CURR 13   2   Subtotal 5 from pricing procedure for condition  
114 KZWI6 KZWI6 WERTV7 CURR 13   2   Subtotal 6 from pricing procedure for condition  
115 WAVWR WAVWR WERTV7 CURR 13   2   Cost in document currency  
116 SKFBP SKFBP WERTV7 CURR 13   2   Amount eligible for cash discount in document currency  
117 BRTWP JHBRTWRP WERTV8 CURR 15   2   IS-M: Gross Value in Document Currency (Item)  
118 NETWP NETWR_FP WERTV8 CURR 15   2   Net value of the billing item in document currency  
119 MWSBP MWSBP WERTV7 CURR 13   2   Tax amount in document currency  
120 CMPRE     CURR 11   2    
121 CMPRE_FLT CMPRE_FLT FLTP FLTP 16   16   Item credit price  
122 UVPRS ISM_UVPRS XFELD CHAR 1   0   Incomplete with Regard to Pricing  
123 UVALL JHUVALL XFELD CHAR 1   0   IS-M: Generally incomplete  
124 XERLV JHXERLV JHXERLV CHAR 1   0   IS-M: Revenue Distribution Status  
125 XPEAB JHXPEAB XFELD CHAR 1   0   IS-M: Period end accrual performed indicator  
126 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction *
127 UMVKZ UMVKZ UMBSZ DEC 5   0   Numerator (factor) for conversion of sales quantity into SKU  
128 UMVKN UMVKN UMBSN DEC 5   0   Denominator (divisor) for conversion of sales qty. into SKU  
129 STCUR STCUR_AP KURRF DEC 9   5   Exchange rate for statistics (Exch.rate at time of creation)  
130 PAOBJNR RKEOBJNR RKEOBJNR NUMC 10   0   Profitability Segment Number (CO-PA)  
131 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
132 ZUONR JHZUONR ZUONR CHAR 18   0   IS-M: Assignment number in FI document  
133 KOUPD KOUPD XFELD CHAR 1   0   Condition update  
134 XCNCL JH_XCNCL XFELD CHAR 1   0   IS-M/AM: Reversal Indicator for Billing Item  
135 .INCLUDE       0   0   IS-PAM: Settlement Documents - Item - Commission Fields  
136 .INCLUDE       0   0   Settlement documents - item commission data - interface  
137 BEDNR VM_BEDNR VM_BEDNR NUMC 6   0   IS-M: Number of Media Sales Agent Contract Requirement JJTVB
138 PROVTYP PROVTYP PROVTYP CHAR 1   0   IS-M/AM: Commission Category  
139 VZUONR JH_VZUONR JH_VZUONR NUMC 2   0   IS-M/AM: Sales Agent Assignment Number (Corrections) *
140 BERART JBERART BERART CHAR 1   0   IS-M/AM: Calculation Type for Media Sales Agent Commission  
141 PBSCHL JPROVSCHL PRSCHL CHAR 5   0   IS-M/AM: Commission Key for Media Sales Agent TJH23
142 SCBAS JHSCBAS JHSCBAS CHAR 1   0   IS-M/AM: Scale Base Value for Commission Key  
143 VERMART JVERMART JVERMART CHAR 2   0   IS-M: Media Sales Agent Type: General/City/Special Agent TJJ09
144 PR_BETRAG VPROZP DEC4_3 DEC 7   3   IS-M: Sales Agent Share of Commission (in %)  
145 PBBASIS JPBBASIS WERTV7 CURR 13   2   IS-M/AM: Commission/Bonus Basis Amount (Percentage Calc.)  
146 ISPBEDART VMBEDART JVMBEDART CHAR 2   0   IS-M/AM: Requirement Type in Media Sales Agent Contract *
147 ALAND ALAND LAND1 CHAR 3   0   Departure country (country from which the goods are sent) T005
148 XSTEIG XJSTEIG XFELD CHAR 1   0   IS-M: Can be Incremented Indicator  
149 .INCLUDE       0   0   IS-PAM: Billing item fields for revenue distribution  
150 .INCLUDE       0   0   IS-PAM: Billing item fields for revenue distribution  
151 VKORG_AUFT JHVKORGAUF VKORG CHAR 4   0   IS-M: Sales Organization for Customer Order TVKO
152 EPROZ ISPPROZERL ISPPROZERL DEC 8   5   IS-M: Percentage rate from rev.distributed billing item  
153 NETWPV NETWR_FP WERTV8 CURR 15   2   Net value of the billing item in document currency  
154 KTGRP JPVAKNTGRP KTGRM CHAR 2   0   Account assignment grouping for edition TVKM
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 JHTFP ALAND T005 LAND1    
2 JHTFP AUBEL JHAK AVM_NR REF 1 CN
3 JHTFP AUETE JHAE EIN_NR 1 CN
4 JHTFP AUFNR AUFK AUFNR KEY 1 CN
5 JHTFP AUGRP JHAGA GRUPPABRNR REF 1 CN
6 JHTFP AUPOS JHAP POS_NR REF 1 CN
7 JHTFP AVMAUART TJHAK AUART REF 1 CN
8 JHTFP AZAFA TJJ11 AZART_FARB REF 1 CN
9 JHTFP AZAFO TJJ17 AZART_FORM REF 1 CN
10 JHTFP AZAFOV TJJ13 AZART_AREA REF 1 CN
11 JHTFP AZAGST TJJ19 AZART_GEST REF 1 CN
12 JHTFP BEDNR JJTVB BEDNR REF 1 CN
13 JHTFP BEINH JJTBE BELEINH REF 1 CN
14 JHTFP BEINH_BAS JJTBE BELEINH REF 1 CN
15 JHTFP CHIFFRE TJH59 CHIFFRE_KZ REF 1 CN
16 JHTFP DIENSTL JJTDIEN MATNR REF 1 CN
17 JHTFP DITYP TJH71 DIENTYP REF 1 CN
18 JHTFP DRERZ JDTDRER DRERZ REF 1 CN
19 JHTFP ELAND T005 LAND1    
20 JHTFP GEWEI T006 MSEHI REF 1 CN
21 JHTFP GSBER TGSB GSBER REF 1 CN
22 JHTFP IHKOMP JJTIKO INHALTSKOM REF 1 CN
23 JHTFP INHK_KFM JJTIKO INHALTSKOM REF 1 CN
24 JHTFP INHK_TECH2 JJTIKO INHALTSKOM REF 1 CN
25 JHTFP INSERENT JJVDB_MK_FK GPNR REF 1 CN
26 JHTFP KALSM T683 KALSM REF 1 CN
27 JHTFP KAPPL T681A KAPPL REF 1 CN
28 JHTFP KDGRP T151 KDGRP REF 1 CN
29 JHTFP KOKRS TKA01 KOKRS REF 1 CN
30 JHTFP KONDA T188 KONDA REF 1 CN
31 JHTFP KOSTL CSKS KOSTL REF 1 CN
32 JHTFP KTGRB TJJ39 KTGRB REF 1 CN
33 JHTFP KTGRM TVKM KTGRM REF 1 CN
34 JHTFP KTGRP TVKM KTGRM REF 1 CN
35 JHTFP KUNAG JGTGPNR GPNR    
36 JHTFP MANDT T000 MANDT KEY 1 CN
37 JHTFP MATNR MARA MATNR REF 1 CN
38 JHTFP MEINS T006 MSEHI REF 1 CN
39 JHTFP PBSCHL TJH23 PRSCHL REF C CN
40 JHTFP POSAR TJH17 AVMPOS_ART REF 1 CN
41 JHTFP PRCTR CEPC PRCTR REF 1 CN
42 JHTFP PRODH JJT179 PRODH REF 1 CN
43 JHTFP PSTYV TJHAP PSTYV REF 1 CN
44 JHTFP PVA JDTPVA PVA REF 1 CN
45 JHTFP SPART TSPA SPART REF 1 CN
46 JHTFP STAFO TMCB STAFO REF 1 CN
47 JHTFP STGRB TJJ67 BEGRP_STAT REF 1 CN
48 JHTFP VAVTYP TJD05 VAVARTYP REF 1 CN
49 JHTFP VBELN JHTFK VBELN KEY 1 CN
50 JHTFP VERMART TJJ09 JVERMART REF C CN
51 JHTFP VGFKTYP TJH19 FKTYP    
52 JHTFP VGOBJ TJH97 OBJKT REF    
53 JHTFP VKBUR TVBUR VKBUR REF 1 CN
54 JHTFP VKGRP TVKGR VKGRP REF 1 CN
55 JHTFP VKORG_AUFT TVKO VKORG REF 1 CN
56 JHTFP VRKME T006 MSEHI REF 1 CN
57 JHTFP VTWEG TVTW VTWEG REF 1 CN
58 JHTFP WERKS T001W WERKS REF 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in