SAP ABAP Table JFRPVB (Reference Structure for XJFRP/YJFRP)

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	JFRPVB	Table Relationship Diagram
Short Description	Reference Structure for XJFRP/YJFRP

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in