SAP ABAP Table JFRPJ0 (IS-M/SD: Item Data for Billing)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	INTTAB	Structure
Structure	JFRPJ0	Table Relationship Diagram
Short Description	IS-M/SD: Item Data for Billing

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	ISPAUART	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
2	ISPAUAGRP	☐	ISPAUAGRP	JAUARTGRP	CHAR	1	0	IS-M: Sales Document Type Grouping for Sales Order
3	ISPKOSTL_L	☐	ISPKOSTL_L	KOSTL	CHAR	10	0	IS-M: Cost Center to be Charged	*
4	ISPDRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
5	ISPPVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
6	ISPBEZ	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
7	ISPLIFART	☐	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	TJV01
8	ISPDRUCK	☐	ISPDRUCK	WERKS	CHAR	4	0	IS-M: Plant (Printing Works)	T001W
9	ISPGUTSCH	☐	ISPGUTSCH	GUTSCHEIN	NUMC	8	0	IS-M: Coupon Number
10	ISPXLOGO	☐	XLOGO	XFELD	CHAR	1	0	Print Logo
11	ISPPVAKNTG	☐	ISPPVAKNTG	KTGRM	CHAR	2	0	IS-M: Account Assignment Grouping for Edition	TVKM
12	ISPPVAKONG	☐	ISPPVAKONG	KONDM	CHAR	2	0	IS-M: Edition Condition Grouping	T178
13	ISPPVABONG	☐	ISPPVABONG	BONUS	CHAR	2	0	IS-M: Bonus Grouping for Edition	TVBO
14	ISPFKPER	☐	FKPER	FKPER	CHAR	2	0	Billing Frequency	TJK01
15	ISPPERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
16	ISPZAHLW	☐	JZAHLW	JZAHLW	CHAR	1	0	Billing method
17	ISPPOSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
18	ISPJPERIOD	☐	JPERIOD	XFELD	CHAR	1	0	IS-M: Periodic settlement
19	ISPVBELN	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
20	ISPPOSNR	☐	APNR	APNR	NUMC	6	0	Sales Order Item	JKAP
21	ISPETENR	☐	JAENR	AENR	NUMC	4	0	Sales Order Schedule Line	JKEP
22	ISPETEEX	☐	ETEEX_ISP	ETEEX	NUMC	6	0	IS-M: External Schedule Line Number
23	ISPETART	☐	ETART_ISP	ETART_ISP	CHAR	2	0	Schedule Line Type for Internal Sales Order Schedule Line	TJEP
24	ISPETMENGE	☐	ETMENGE	MENGGPOS	QUAN	10	0	IS-M: Sales Order Schedule Line Quantity
25	ISPETMEINS	☐	ETMEINS	MEINS	UNIT	3	0	IS-M: Sales Unit for Sales Order	T006
26	ISPETVOR	☐	ISPETVOR	VORZEI	CHAR	1	0	IS-M: Plus/Minus Sign for Sch. Line Quantity in Sales Order
27	ISPKPOSN	☐	KPOSN	NUM6	NUMC	6	0	Condition Item Number
28	ISPPRBAS	☐	ISPPRBAS	PRBAS_ISP	CHAR	1	0	IS-M: Price Basis
29	ISPPRSPER	☐	ISPPRSPER	PRSPER	CHAR	2	0	IS-M: Price Frequency	TJK03
30	ISPBZPERF	☐	ISPBZPERF	BEZPER	CHAR	5	0	IS-M: Service Type for Billing	TJD09
31	ISPPRSMLT	☐	ISPPRSMLT	PRSMLT	DEC	5	0	IS-M: Numerator in Conversion Factor for Frequencies
32	ISPPRSDIV	☐	ISPPRSDIV	PRSDIV	DEC	5	0	IS-M: Denominator for Frequency Conversion Factor
33	ISPAEART	☐	ISPAEART	AEART_JSDK	CHAR	1	0	IS-M: Order Change Type
34	ISPANZET	☐	ISPANZET	ANZET	DEC	5	0	IS-M: Number of Publication Dates
35	ISPERSDAT	☐	ERSCHDAT	DATUM	DATS	8	0	Publication Date
36	ISPWRBAKT	☐	WERBEAKT	WERBEAKT	CHAR	8	0	Sales Promotion	TJWAK
37	ISPFAKVON	☐	FAKVON	DATUM	DATS	8	0	IS-M: Billing Period From
38	ISPFAKBIS	☐	FAKBIS	DATUM	DATS	8	0	IS-M: Billing Period To
39	ISPKONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
40	ISPKDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
41	ISPPOART	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	TJAP
42	ISPPRSANTZ	☐	PRSANTZ	ISPWERT8	DEC	8	0	IS-M: Numerator for proportional prices
43	ISPPRSANTN	☐	PRSANTN	ISPWERT8	DEC	8	0	IS-M: Denominator for proportional prices
44	ISPPRSANZP	☐	PRSANZP	ISPWERT8	DEC	8	0	IS-M: Number of periods in billing period
45	ISPBRTWR_P	☐	ISPBRTWR	WERTV8	CURR	15	2	IS-M: Gross Value in Document Currency
46	ISPPRBAS_V	☐	PRBAS_VK	PRBAS_ISP	CHAR	1	0	Price Basis for Shipping Costs
47	ISPLAGRP_V	☐	LANDGRP_VK	LANDGRP_VK	CHAR	2	0	Country grouping for shipping costs	TJG92
48	ISPXFKKOMP	☐	XFKKOMP	XFELD	CHAR	1	0	Indicator: Perform Billing in Full for Billing Period
49	ISPXFKENDE	☐	XFKENDE	XFELD	CHAR	1	0	Indicator: Billing at end of calculation
50	ISPSFPOS	☐	XSEPFKPOS	XFELD	CHAR	1	0	Separate billing document for order item
51	ISPXKOMPP	☐	XKOMPP	XFELD	CHAR	1	0	IS-M: Full period (billing)
52	ISPVERSDAT	☐	VRSNDDATUM	DATUM	DATS	8	0	IS-M: Shipping Date
53	ISPLANDE	☐	LANDE_ISP	LAND1	CHAR	3	0	Current country being supplied	*
54	ISPRKAUFNR	☐	J_RK_AUFNR	J_RK_AUFNR	CHAR	8	0	Order Number of RK Order for Account Assignment
55	ISPRKPOSNR	☐	J_RK_POSNR	J_RK_POSNR	NUMC	2	0	Item Number of RK Order for Account Assignment
56	ISPCOAUFNR	☐	J_CO_AUFNR	AUFNR	CHAR	12	0	Order number of internal CO order for account assignment	AUFK
57	ISPVAUSGB	☐	VAUSGB	VAUSGB	CHAR	10	0	Issue	JDTVAUSGB
58	ISPXFKBALF	☐	XFKBASLIEF	XFELD	CHAR	1	0	IS-M: Billing based on delivery
59	ISPXFKBAAU	☐	XFKBASAUFT	XFELD	CHAR	1	0	IS-M: Billing based on order
60	ISPVKBURZU	☐	VKBURZUS	VKBUR	CHAR	4	0	Sales office responsible	*
61	ISPXSTABGR	☐	JXMWSTABGR	XFELD	CHAR	1	0	VAT to be accrued proportionally for payment in billing
62	ISPXIMMAT	☐	XIMMATRIK	XFELD	CHAR	1	0	Indicator: Proof of matriculation provided
63	ISPIMMATD	☐	IMMATDAT	DATUM	DATS	8	0	Matriculation Certificate Valid To
64	ISPXFKRUEK	☐	XFKRUECK	XFELD	CHAR	1	0	IS-M: Retroactive Billing of Period Already Billed
65	ISPIVWKN	☐	IVWKN	IVWKN	CHAR	8	0	Circulation Audit Report Category ID	*
66	ISPXIVW	☐	XIVW	XFELD	CHAR	1	0	Indicator: Relevant for audit report
67	ISPJKPAVRG	☐	JKPAVONREG	DATUM	DATS	8	0	Normal Start of Address Validity for Retro.Order Items
68	ISPJKPABRG	☐	JKPABISREG	DATUM	DATS	8	0	End of Address Validity if End of Billing Delayed
69	XNEGOPTION	☐	XNEGOPTION	XFELD	CHAR	1	0	IS-M: Item with Automatic Transformation to Chargeable
70	IVWDATUM	☐	IVWDATUM	DATUM	DATS	8	0	Date of Audit Report for Returns

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JFRPJ0	ISPAUART	TJAK	AUART	KEY	1	CN
2	JFRPJ0	ISPBEZ	JDTBEZTYP	BEZTYP
3	JFRPJ0	ISPBZPERF	TJD09	BEZPER
4	JFRPJ0	ISPCOAUFNR	AUFK	AUFNR
5	JFRPJ0	ISPDRERZ	JDTDRER	DRERZ
6	JFRPJ0	ISPDRUCK	T001W	WERKS
7	JFRPJ0	ISPETART	TJEP	ETART	KEY	1	CN
8	JFRPJ0	ISPETENR	JKEP	ETENR	KEY	1	CN
9	JFRPJ0	ISPETMEINS	T006	MSEHI
10	JFRPJ0	ISPFKPER	TJK01	FKPER
11	JFRPJ0	ISPKDGRP	T151	KDGRP
12	JFRPJ0	ISPKONDA	T188	KONDA
13	JFRPJ0	ISPLAGRP_V	TJG92	LANDGRP_VK
14	JFRPJ0	ISPLIFART	TJV01	LIEFERART
15	JFRPJ0	ISPPERFK	TFACD	IDENT
16	JFRPJ0	ISPPOART	TJAP	POART
17	JFRPJ0	ISPPOSNR	JKAP	POSNR	KEY	1	CN
18	JFRPJ0	ISPPRSPER	TJK03	PRSPER
19	JFRPJ0	ISPPVA	JDTPVA	PVA
20	JFRPJ0	ISPPVABONG	TVBO	BONUS
21	JFRPJ0	ISPPVAKNTG	TVKM	KTGRM
22	JFRPJ0	ISPPVAKONG	T178	KONDM
23	JFRPJ0	ISPVAUSGB	JDTVAUSGB	VAUSGB
24	JFRPJ0	ISPVBELN	JKAK	VBELN	KEY	1	CN
25	JFRPJ0	ISPWRBAKT	TJWAK	WERBEAKT

History

Last changed by/on	SAP	20110901
SAP Release Created in