SAP ABAP Table JHIFP1S (IS-PAM: Settlement Documents - Cust.Item Fields - Interface)

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	JHIFP1S	Table Relationship Diagram
Short Description	IS-PAM: Settlement Documents - Cust.Item Fields - Interface

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	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
2	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
3	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
4	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
5	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
6	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
7	ARKTX	☐	ISM_ARKTX	TEXT40	CHAR	40	0	IS-M: Short Text for Document Item (Billing Doc.,Settlement)
8	AUBEL	☐	AVM_NR	AVM_NR	CHAR	10	0	IS-M/AM: Sales Document Number	JHAK
9	AUPOS	☐	POS_NR	AVM_PNR	NUMC	3	0	IS-M: Order Item Number	JHAP
10	AUGRP	☐	GRUPPABRNR	GRUPPABR	NUMC	3	0	IS-M/AM: Billing Dataset	JHAGA
11	AUETE	☐	EIN_NR	AVMENR	NUMC	6	0	IS-M: Schedule Line	JHAE
12	AVMAUART	☐	AUART_PAM	AUART_PAM	CHAR	4	0	IS-M: Sales Document Type	TJHAK
13	AUREF	☐	AUREF	XFELD	CHAR	1	0	Sales document was created from reference
14	BEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	JJTBE
15	BEINH_BAS	☐	BE_BASIS	BELEINH	CHAR	10	0	IS-M: Basic Booking Unit	JJTBE
16	DRERZ	☐	JHDRERZ	DRERZ	CHAR	8	0	IS-M: Publication	JDTDRER
17	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
18	IHKOMP	☐	IKO_PREIS	INHALTSKOM	CHAR	8	0	IS-M: Content component for pricing call	JJTIKO
19	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
20	INHK_TECH2	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	JJTIKO
21	AZAFOV	☐	AZART_AREA	AZART_AREA	CHAR	4	0	IS-M/AM: Fixed Format Proposal /Ad Dimensions	TJJ13
22	AZAFO	☐	AZART_FORM	AZART_FORM	CHAR	4	0	IS-M: Shape Ad Type	TJJ17
23	AZAFA	☐	AZART_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Ad Type	TJJ11
24	AZAGST	☐	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	TJJ19
25	TERMINSPEZ	☐	TERMINSPEZ	TERMINSPEZ	CHAR	6	0	IS-M/AM: Specify Dates for Date Combinations	*
26	VAVTYP	☐	VAVARTYP	VAVARTYP	CHAR	2	0	Issue Variant Type	TJD05
27	CHIFFRE	☐	CHIFFRE_KZ	CHIFFRE_KZ	CHAR	1	0	IS-M: Box Number Indicator	TJH59
28	ABSRB	☐	AB_RABATT	RABATT	DEC	5	2	IS-M: Current Valid Contract Discount Rate
29	ABSBO	☐	AKTBONUS	RABATT	DEC	5	2	IS-M/AM: Current Valid Contract Bonus
30	ABSFMPR	☐	AB_PREIS	WERTV8	CURR	15	2	IS-M: Current Valid Price from Contract
31	GO_PREIS	☐	GO_PREIS	GO_PREIS	CHAR	1	0	IS-M: Basic/Local Price
32	INSERENT	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JJVDB_MK_FK
33	STICHW	☐	STICHW	TEXT40	CHAR	40	0	IS-M: Keyword
34	DIENSTL	☐	MATNR_DIEN	MATNR_DIEN	CHAR	18	0	IS-M: Service material number	JJTDIEN
35	DITYP	☐	DIENTYP	DIENTYP	CHAR	4	0	IS-M: Service Type	TJH71
36	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
37	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
38	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
39	FSART	☐	ISP_FSART	ISP_FSART	CHAR	1	0	IS-M/AM: Billing Method
40	KTGRM	☐	KTGRM	KTGRM	CHAR	2	0	Account assignment group for this material	TVKM
41	KTGRB	☐	KTGRB	KTGRB	CHAR	2	0	IS-M: Booking Unit Account Assignment Group	TJJ39
42	PRSFD	☐	PRSFD	PRSFD	CHAR	1	0	Carry out pricing
43	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
44	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
45	SHKZG	☐	JHSHKZG	JHSHKZG	CHAR	1	0	IS-M: Debit/Credit indicator
46	SMENG	☐	SMENG	MENG13	QUAN	13	3	Scale quantity in base unit of measure
47	FKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
48	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
49	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
50	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
51	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
52	VGBEL	☐	JHVGBEL	JHVGBEL	CHAR	10	0	IS-M: Document Number of Template Document
53	VGPOS	☐	JHVGPOS	JHVGPOS	NUMC	6	0	IS-M: Item Number of the Template Business Item
54	VGETE	☐	GRABR_VG	GRUPPABR	NUMC	3	0	IS-M: Group/Settlement Number of Template Document	*
55	VGTYP	☐	ISPVBTYP_V	ISPVBTYP	CHAR	1	0	IS-M: Preceding Sales Document Category
56	VGOBJ	☐	JHOBJAR_V	JHOBJKT	CHAR	2	0	IS-M: Preceding object type	TJH97
57	VGFKTYP	☐	JHVGFKTYP	JHFKTYP	CHAR	1	0	IS-M: Billing Category for Preceding Billing Document	TJH19
58	VBELV	☐	ISMVBELV	ISMVBELV	CHAR	10	0	IS-M: Originating sales document
59	POSNV	☐	ISMPOSNV	ISMPOSNR	NUMC	6	0	IS-M: Originating item
60	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
61	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
62	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
63	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
64	POSAR	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
65	PRODH	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	JJT179
66	PSTYV	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
67	TAXM1	☐	TAXM1	TAXKM	CHAR	1	0	Tax classification material	*
68	TAXM2	☐	TAXM2	TAXKM	CHAR	1	0	Tax classification material	*
69	TAXM3	☐	TAXM3	TAXKM	CHAR	1	0	Tax classification material	*
70	TAXM4	☐	TAXM4	TAXKM	CHAR	1	0	Tax Classification 4 Material	*
71	TAXM5	☐	TAXM5	TAXKM	CHAR	1	0	Tax classification 5 for material	*
72	TAXM6	☐	TAXM6	TAXKM	CHAR	1	0	Tax classification 6 for material	*
73	TAXM7	☐	TAXM7	TAXKM	CHAR	1	0	Tax classification 7 for material	*
74	TAXM8	☐	TAXM8	TAXKM	CHAR	1	0	Tax Classification 8 Material	*
75	TAXM9	☐	TAXM9	TAXKM	CHAR	1	0	Tax Classification 9 Material	*
76	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
77	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
78	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
79	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
80	RK_AUFNR	☐	J_RK_AUFNR	J_RK_AUFNR	CHAR	8	0	Order Number of RK Order for Account Assignment
81	RK_POSNR	☐	J_RK_POSNR	J_RK_POSNR	NUMC	2	0	Item Number of RK Order for Account Assignment
82	KOSTL_R2	☐	KOSTL_R2	KOSTL_R2	CHAR	8	0	Cost center in R/2
83	STGRB	☐	BEGRP_STAT	BEGRP_STAT	CHAR	4	0	IS-M: BU Grouping for Statistics	TJJ67
84	STAFO	☐	JHSTAFO	STAFO	CHAR	6	0	IS-M: Update group for statistics update	TMCB
85	SKTOF	☐	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
86	RRREL	☐	ISMRR_RELTYP	ISMRR_RELTYP	CHAR	1	0	IS-M/AM: Revenue Recognition Category
87	RRSTA	☐			CHAR	1	0
88	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHIFP1S	AUBEL	JHAK	AVM_NR	REF	1	CN
2	JHIFP1S	AUETE	JHAE	EIN_NR		1	CN
3	JHIFP1S	AUFNR	AUFK	AUFNR	REF	1	CN
4	JHIFP1S	AUGRP	JHAGA	GRUPPABRNR	REF	1	CN
5	JHIFP1S	AUPOS	JHAP	POS_NR	REF	1	CN
6	JHIFP1S	AVMAUART	TJHAK	AUART	REF	1	CN
7	JHIFP1S	AZAFA	TJJ11	AZART_FARB	REF	1	CN
8	JHIFP1S	AZAFO	TJJ17	AZART_FORM	REF	1	CN
9	JHIFP1S	AZAFOV	TJJ13	AZART_AREA	REF	1	CN
10	JHIFP1S	AZAGST	TJJ19	AZART_GEST	REF	1	CN
11	JHIFP1S	BEINH	JJTBE	BELEINH	REF	1	CN
12	JHIFP1S	BEINH_BAS	JJTBE	BELEINH	REF	1	CN
13	JHIFP1S	CHIFFRE	TJH59	CHIFFRE_KZ	REF	1	CN
14	JHIFP1S	DIENSTL	JJTDIEN	MATNR	REF	1	CN
15	JHIFP1S	DITYP	TJH71	DIENTYP	REF	1	CN
16	JHIFP1S	DRERZ	JDTDRER	DRERZ	REF	1	CN
17	JHIFP1S	GEWEI	T006	MSEHI	REF	1	CN
18	JHIFP1S	IHKOMP	JJTIKO	INHALTSKOM	REF	1	CN
19	JHIFP1S	INHK_KFM	JJTIKO	INHALTSKOM	REF	1	CN
20	JHIFP1S	INHK_TECH2	JJTIKO	INHALTSKOM	REF	1	CN
21	JHIFP1S	INSERENT	JJVDB_MK_FK	GPNR	REF	1	CN
22	JHIFP1S	KALSM	T683	KALSM	REF	1	CN
23	JHIFP1S	KAPPL	T681A	KAPPL	REF	1	CN
24	JHIFP1S	KDGRP	T151	KDGRP	REF	1	CN
25	JHIFP1S	KONDA	T188	KONDA	REF	1	CN
26	JHIFP1S	KOSTL	CSKS	KOSTL	REF	1	CN
27	JHIFP1S	KTGRB	TJJ39	KTGRB	REF	1	CN
28	JHIFP1S	KTGRM	TVKM	KTGRM	REF	1	CN
29	JHIFP1S	MATNR	MARA	MATNR	REF	1	CN
30	JHIFP1S	MEINS	T006	MSEHI	REF	1	CN
31	JHIFP1S	POSAR	TJH17	AVMPOS_ART	REF	1	CN
32	JHIFP1S	PRCTR	CEPC	PRCTR	REF	1	CN
33	JHIFP1S	PRODH	JJT179	PRODH	REF	1	CN
34	JHIFP1S	PSTYV	TJHAP	PSTYV	REF	1	CN
35	JHIFP1S	PVA	JDTPVA	PVA	REF	1	CN
36	JHIFP1S	SPART	TSPA	SPART		1	CN
37	JHIFP1S	STAFO	TMCB	STAFO	REF	1	CN
38	JHIFP1S	STGRB	TJJ67	BEGRP_STAT	REF	1	CN
39	JHIFP1S	VAVTYP	TJD05	VAVARTYP	REF	1	CN
40	JHIFP1S	VGFKTYP	TJH19	FKTYP
41	JHIFP1S	VGOBJ	TJH97	OBJKT	REF
42	JHIFP1S	VKBUR	TVBUR	VKBUR	REF	1	CN
43	JHIFP1S	VKGRP	TVKGR	VKGRP	REF	1	CN
44	JHIFP1S	VRKME	T006	MSEHI	REF	1	CN
45	JHIFP1S	VTWEG	TVTW	VTWEG	REF	1	CN
46	JHIFP1S	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in