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