SAP ABAP Table JFRP (IS-M/SD: Billing Document - Item Data)

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	TRANSP	Transparent table
Transparent table	JFRP	Table Relationship Diagram
Short Description	IS-M/SD: Billing Document - Item Data

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	☑	ISPVBELN	ISPVBELN	CHAR	10	0	IS-M/SD: Billing Document	JFRK
3	POSNR	☑	ISPPOSNR	ISPPOSNR	NUMC	6	0	IS-M: Billing Item
4	FKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
5	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
6	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
7	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
8	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
9	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
10	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
11	NETWR	☐	NETWR_FP	WERTV8	CURR	15	2	Net value of the billing item in document currency
12	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
13	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
14	POSPA	☐	ISPPOSPA	ISPPOSNR	NUMC	6	0	IS-M: Item Number of Partner Segment	JFRP
15	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
16	ALAND	☐	ALAND	LAND1	CHAR	3	0	Departure country (country from which the goods are sent)	T005
17	WKREG	☐	WKREG	REGIO	CHAR	3	0	Region in which plant is located	T005S
18	WKCOU	☐	WKCOU	CHAR3	CHAR	3	0	County in which plant is located
19	WKCTY	☐	WKCTY	CHAR4	CHAR	4	0	City in which plant is located
20	TAXM1	☐	TAXM1	TAXKM	CHAR	1	0	Tax classification material	*
21	TAXM2	☐	TAXM2	TAXKM	CHAR	1	0	Tax classification material	*
22	TAXM3	☐	TAXM3	TAXKM	CHAR	1	0	Tax classification material	*
23	TAXM4	☐	TAXM4	TAXKM	CHAR	1	0	Tax Classification 4 Material	*
24	TAXM5	☐	TAXM5	TAXKM	CHAR	1	0	Tax classification 5 for material	*
25	TAXM6	☐	TAXM6	TAXKM	CHAR	1	0	Tax classification 6 for material	*
26	TAXM7	☐	TAXM7	TAXKM	CHAR	1	0	Tax classification 7 for material	*
27	TAXM8	☐	TAXM8	TAXKM	CHAR	1	0	Tax Classification 8 Material	*
28	TAXM9	☐	TAXM9	TAXKM	CHAR	1	0	Tax Classification 9 Material	*
29	SKTOF	☐	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
30	SKFBP	☐	SKFBP	WERTV7	CURR	13	2	Amount eligible for cash discount in document currency
31	SPARA	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	TSPA
32	SHKZG	☐	SHKZG_VA	XFELD	CHAR	1	0	Returns Item
33	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
34	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
35	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
36	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
37	WAVWR	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
38	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
39	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
40	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
41	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
42	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
43	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
44	STCUR	☐	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
45	UVPRS	☐	UVPRS	XFELD	CHAR	1	0	Incomplete with respect to pricing
46	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
47	.INCLUDE	☐				0	0	IS-M/SD: Item Data for Billing
48	ISPAUART	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
49	ISPAUAGRP	☐	ISPAUAGRP	JAUARTGRP	CHAR	1	0	IS-M: Sales Document Type Grouping for Sales Order
50	ISPKOSTL_L	☐	ISPKOSTL_L	KOSTL	CHAR	10	0	IS-M: Cost Center to be Charged	*
51	ISPDRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
52	ISPPVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
53	ISPBEZ	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
54	ISPLIFART	☐	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	TJV01
55	ISPDRUCK	☐	ISPDRUCK	WERKS	CHAR	4	0	IS-M: Plant (Printing Works)	T001W
56	ISPGUTSCH	☐	ISPGUTSCH	GUTSCHEIN	NUMC	8	0	IS-M: Coupon Number
57	ISPXLOGO	☐	XLOGO	XFELD	CHAR	1	0	Print Logo
58	ISPPVAKNTG	☐	ISPPVAKNTG	KTGRM	CHAR	2	0	IS-M: Account Assignment Grouping for Edition	TVKM
59	ISPPVAKONG	☐	ISPPVAKONG	KONDM	CHAR	2	0	IS-M: Edition Condition Grouping	T178
60	ISPPVABONG	☐	ISPPVABONG	BONUS	CHAR	2	0	IS-M: Bonus Grouping for Edition	TVBO
61	ISPFKPER	☐	FKPER	FKPER	CHAR	2	0	Billing Frequency	TJK01
62	ISPPERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
63	ISPZAHLW	☐	JZAHLW	JZAHLW	CHAR	1	0	Billing method
64	ISPPOSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
65	ISPJPERIOD	☐	JPERIOD	XFELD	CHAR	1	0	IS-M: Periodic settlement
66	ISPVBELN	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
67	ISPPOSNR	☐	APNR	APNR	NUMC	6	0	Sales Order Item	JKAP
68	ISPETENR	☐	JAENR	AENR	NUMC	4	0	Sales Order Schedule Line	JKEP
69	ISPETEEX	☐	ETEEX_ISP	ETEEX	NUMC	6	0	IS-M: External Schedule Line Number
70	ISPETART	☐	ETART_ISP	ETART_ISP	CHAR	2	0	Schedule Line Type for Internal Sales Order Schedule Line	TJEP
71	ISPETMENGE	☐	ETMENGE	MENGGPOS	QUAN	10	0	IS-M: Sales Order Schedule Line Quantity
72	ISPETMEINS	☐	ETMEINS	MEINS	UNIT	3	0	IS-M: Sales Unit for Sales Order	T006
73	ISPETVOR	☐	ISPETVOR	VORZEI	CHAR	1	0	IS-M: Plus/Minus Sign for Sch. Line Quantity in Sales Order
74	ISPKPOSN	☐	KPOSN	NUM6	NUMC	6	0	Condition Item Number
75	ISPPRBAS	☐	ISPPRBAS	PRBAS_ISP	CHAR	1	0	IS-M: Price Basis
76	ISPPRSPER	☐	ISPPRSPER	PRSPER	CHAR	2	0	IS-M: Price Frequency	TJK03
77	ISPBZPERF	☐	ISPBZPERF	BEZPER	CHAR	5	0	IS-M: Service Type for Billing	TJD09
78	ISPPRSMLT	☐	ISPPRSMLT	PRSMLT	DEC	5	0	IS-M: Numerator in Conversion Factor for Frequencies
79	ISPPRSDIV	☐	ISPPRSDIV	PRSDIV	DEC	5	0	IS-M: Denominator for Frequency Conversion Factor
80	ISPAEART	☐	ISPAEART	AEART_JSDK	CHAR	1	0	IS-M: Order Change Type
81	ISPANZET	☐	ISPANZET	ANZET	DEC	5	0	IS-M: Number of Publication Dates
82	ISPERSDAT	☐	ERSCHDAT	DATUM	DATS	8	0	Publication Date
83	ISPWRBAKT	☐	WERBEAKT	WERBEAKT	CHAR	8	0	Sales Promotion	TJWAK
84	ISPFAKVON	☐	FAKVON	DATUM	DATS	8	0	IS-M: Billing Period From
85	ISPFAKBIS	☐	FAKBIS	DATUM	DATS	8	0	IS-M: Billing Period To
86	ISPKONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
87	ISPKDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
88	ISPPOART	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	TJAP
89	ISPPRSANTZ	☐	PRSANTZ	ISPWERT8	DEC	8	0	IS-M: Numerator for proportional prices
90	ISPPRSANTN	☐	PRSANTN	ISPWERT8	DEC	8	0	IS-M: Denominator for proportional prices
91	ISPPRSANZP	☐	PRSANZP	ISPWERT8	DEC	8	0	IS-M: Number of periods in billing period
92	ISPBRTWR_P	☐	ISPBRTWR	WERTV8	CURR	15	2	IS-M: Gross Value in Document Currency
93	ISPPRBAS_V	☐	PRBAS_VK	PRBAS_ISP	CHAR	1	0	Price Basis for Shipping Costs
94	ISPLAGRP_V	☐	LANDGRP_VK	LANDGRP_VK	CHAR	2	0	Country grouping for shipping costs	TJG92
95	ISPXFKKOMP	☐	XFKKOMP	XFELD	CHAR	1	0	Indicator: Perform Billing in Full for Billing Period
96	ISPXFKENDE	☐	XFKENDE	XFELD	CHAR	1	0	Indicator: Billing at end of calculation
97	ISPSFPOS	☐	XSEPFKPOS	XFELD	CHAR	1	0	Separate billing document for order item
98	ISPXKOMPP	☐	XKOMPP	XFELD	CHAR	1	0	IS-M: Full period (billing)
99	ISPVERSDAT	☐	VRSNDDATUM	DATUM	DATS	8	0	IS-M: Shipping Date
100	ISPLANDE	☐	LANDE_ISP	LAND1	CHAR	3	0	Current country being supplied	*
101	ISPRKAUFNR	☐	J_RK_AUFNR	J_RK_AUFNR	CHAR	8	0	Order Number of RK Order for Account Assignment
102	ISPRKPOSNR	☐	J_RK_POSNR	J_RK_POSNR	NUMC	2	0	Item Number of RK Order for Account Assignment
103	ISPCOAUFNR	☐	J_CO_AUFNR	AUFNR	CHAR	12	0	Order number of internal CO order for account assignment	AUFK
104	ISPVAUSGB	☐	VAUSGB	VAUSGB	CHAR	10	0	Issue	JDTVAUSGB
105	ISPXFKBALF	☐	XFKBASLIEF	XFELD	CHAR	1	0	IS-M: Billing based on delivery
106	ISPXFKBAAU	☐	XFKBASAUFT	XFELD	CHAR	1	0	IS-M: Billing based on order
107	ISPVKBURZU	☐	VKBURZUS	VKBUR	CHAR	4	0	Sales office responsible	*
108	ISPXSTABGR	☐	JXMWSTABGR	XFELD	CHAR	1	0	VAT to be accrued proportionally for payment in billing
109	ISPXIMMAT	☐	XIMMATRIK	XFELD	CHAR	1	0	Indicator: Proof of matriculation provided
110	ISPIMMATD	☐	IMMATDAT	DATUM	DATS	8	0	Matriculation Certificate Valid To
111	ISPXFKRUEK	☐	XFKRUECK	XFELD	CHAR	1	0	IS-M: Retroactive Billing of Period Already Billed
112	ISPIVWKN	☐	IVWKN	IVWKN	CHAR	8	0	Circulation Audit Report Category ID	*
113	ISPXIVW	☐	XIVW	XFELD	CHAR	1	0	Indicator: Relevant for audit report
114	ISPJKPAVRG	☐	JKPAVONREG	DATUM	DATS	8	0	Normal Start of Address Validity for Retro.Order Items
115	ISPJKPABRG	☐	JKPABISREG	DATUM	DATS	8	0	End of Address Validity if End of Billing Delayed
116	XNEGOPTION	☐	XNEGOPTION	XFELD	CHAR	1	0	IS-M: Item with Automatic Transformation to Chargeable
117	IVWDATUM	☐	IVWDATUM	DATUM	DATS	8	0	Date of Audit Report for Returns
118	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
119	ISPBDPER	☐	BDPER	DATUM	DATS	8	0	IS-M: Basic Date for Billing Frequency
120	FKPERVON	☐	FKPERVON	DATUM	DATS	8	0	IS-M: Initial Date of Full Billing Period
121	FKPERBIS	☐	FKPERBIS	DATUM	DATS	8	0	IS-M: Closing Date of Full Billing Period
122	ISPZSKLS	☐	JZSKLS	JZSKLS	CHAR	1	0	Time slice classification for sales order
123	ISPWRBART	☐	WERBEART	WERBEART	CHAR	4	0	Sales Source	TJWAR
124	POSNR_UR	☐	APNR_UR	APNR	NUMC	6	0	Original Item in Publishing Sales Order	*
125	CYCLENR	☐	CYCLENR	CYCLENR	NUMC	3	0	IS-M/SD: Billing Cycle Number	*
126	FAKNRRUECK	☐	ISPFAKNRRUECK	ISPVBELN	CHAR	10	0	IS-M: Recalculated Billing Document	*
127	XFIXED	☐	XINDEXFIXED	XFELD	CHAR	1	0	Indicator: Billing Index Fixed and Cannot be Deleted
128	RCODE	☐	RATE_CODE	RATE_CODE	CHAR	4	0	IS-M/SD: Rate Code	*
129	XAUTO_REN	☐	XAUTO_REN	XFELD	CHAR	1	0	IS-M/SD: Customer Requests Automatic Renewal
130	STBFREI	☐	JSTBFREI	JSTBFREI	CHAR	2	0	Type of Tax Exemption	TJFSB
131	XNFAK	☐	ISPXNFAK	XFELD	CHAR	1	0	IS-M: Indicator - Repeat Billing After Reversal
132	DELIVSPLIT	☐	DELIVSPLIT	DELIVSPLIT	CHAR	8	0	IS-M/SD: Alternating Address Element	TJD23
133	DELIVSPLITGRP	☐	DELIVSPLITGRP	DELIVSPLITGRP	CHAR	10	0	IS-M/SD: Address Alternation Group	TJD63
134	POSNR_MAIN	☐	APNR_MAIN	APNR	NUMC	6	0	IS-M/SD: Main Item in Sales Order	JKAP
135	POSNR_SUB	☐	APNR_SUB	APNR	NUMC	6	0	IS-M/SD: Sub-Item in Sales Order	JKAP
136	.INCLUDE	☐				0	0	IS-M/SD: Field String for Weekdays
137	X_MONTAG	☐	X_MONTAG	XFELD	CHAR	1	0	IS-M: Monday
138	X_DIENSTAG	☐	X_DIENSTAG	XFELD	CHAR	1	0	IS-M: Tuesday
139	X_MITTWOCH	☐	X_MITTWOCH	XFELD	CHAR	1	0	IS-M: Wednesday
140	X_DONNETAG	☐	X_DONNETAG	XFELD	CHAR	1	0	IS-M: Thursday
141	X_FREITAG	☐	X_FREITAG	XFELD	CHAR	1	0	IS-M: Friday
142	X_SAMSTAG	☐	X_SAMSTAG	XFELD	CHAR	1	0	IS-M: Saturday
143	X_SONNTAG	☐	X_SONNTAG	XFELD	CHAR	1	0	IS-M: Sunday
144	VBELN_FROM	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	*
145	POSNR_UR_FROM	☐	APNR	APNR	NUMC	6	0	Sales Order Item	*
146	CYCLENR_FROM	☐	CYCLENR	CYCLENR	NUMC	3	0	IS-M/SD: Billing Cycle Number	*
147	XPRICEALTER	☐	XPRICEALTERNATION	XFELD	CHAR	1	0	Indicator: Generated Index for Price Change
148	REFUNDTYPE	☐	REFUNDTYPE	REFUNDTYPE	CHAR	2	0	IS-M/SD: Refund Type	TJK19
149	XAUTO_ACCEPT	☐	XAUTO_ACCEPT	XFELD	CHAR	1	0	IS-M/SD: Indicator - Accept Cycle Without Payment
150	BONUSTYPE	☐	JBONUSTYPE	JBONUSTYPE	CHAR	2	0	IS-M/SD: Bonus Type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JFRP	ALAND	T005	LAND1	REF	1	CN
2	JFRP	DELIVSPLIT	TJD23	DELIVSPLIT	REF	C	CN
3	JFRP	DELIVSPLITGRP	TJD63	DELIVSPLITGRP	REF	C	CN
4	JFRP	GSBER	TGSB	GSBER	REF	C	CN
5	JFRP	ISPAUART	TJAK	AUART	KEY	1	CN
6	JFRP	ISPBEZ	JDTBEZTYP	BEZTYP
7	JFRP	ISPBZPERF	TJD09	BEZPER
8	JFRP	ISPCOAUFNR	AUFK	AUFNR
9	JFRP	ISPDRERZ	JDTDRER	DRERZ
10	JFRP	ISPDRUCK	T001W	WERKS
11	JFRP	ISPETART	TJEP	ETART	KEY	1	CN
12	JFRP	ISPETENR	JKEP	ETENR	KEY	1	CN
13	JFRP	ISPETMEINS	T006	MSEHI
14	JFRP	ISPFKPER	TJK01	FKPER
15	JFRP	ISPKDGRP	T151	KDGRP
16	JFRP	ISPKONDA	T188	KONDA
17	JFRP	ISPLAGRP_V	TJG92	LANDGRP_VK
18	JFRP	ISPLIFART	TJV01	LIEFERART
19	JFRP	ISPPERFK	TFACD	IDENT
20	JFRP	ISPPOART	TJAP	POART
21	JFRP	ISPPOSNR	JKAP	POSNR	KEY	1	CN
22	JFRP	ISPPRSPER	TJK03	PRSPER
23	JFRP	ISPPVA	JDTPVA	PVA
24	JFRP	ISPPVABONG	TVBO	BONUS
25	JFRP	ISPPVAKNTG	TVKM	KTGRM
26	JFRP	ISPPVAKONG	T178	KONDM
27	JFRP	ISPVAUSGB	JDTVAUSGB	VAUSGB
28	JFRP	ISPVBELN	JKAK	VBELN	KEY	1	CN
29	JFRP	ISPWRBAKT	TJWAK	WERBEAKT
30	JFRP	ISPWRBART	TJWAR	WERBEART	KEY	C	CN
31	JFRP	MANDT	T000	MANDT	KEY	1	CN
32	JFRP	MATKL	T023	MATKL	REF	C	CN
33	JFRP	MEINS	T006	MSEHI	REF	C	CN
34	JFRP	POSNR_MAIN	JKAP	POSNR	REF	C	CN
35	JFRP	POSNR_SUB	JKAP	POSNR	REF	C	CN
36	JFRP	POSPA	JFRP	POSNR
37	JFRP	REFUNDTYPE	TJK19	REFUNDTYPE	REF	1	CN
38	JFRP	SPARA	TSPA	SPART	REF	C	CN
39	JFRP	SPART	TSPA	SPART	REF	C	CN
40	JFRP	STBFREI	TJFSB	STBFREI	REF	C	CN
41	JFRP	VBELN	JFRK	VBELN	KEY	1	CN
42	JFRP	VRKME	T006	MSEHI	REF	C	CN
43	JFRP	WERKS	T001W	WERKS	REF	C	CN
44	JFRP	WKREG	T005S	BLAND	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in