SAP ABAP Table MCJHTFP (IS-M: Billing item, LIS communication structure)

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	MCJHTFP	Table Relationship Diagram
Short Description	IS-M: Billing item, LIS communication structure

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

History

Last changed by/on	SAP	20110901
SAP Release Created in