SAP ABAP Table VBRPJ0 (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	VBRPJ0	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	ISPSHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
40	ISPKONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
41	ISPKDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
42	ISPPOART	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	TJAP
43	ISPPRSANTZ	☐	PRSANTZ	ISPWERT8	DEC	8	0	IS-M: Numerator for proportional prices
44	ISPPRSANTN	☐	PRSANTN	ISPWERT8	DEC	8	0	IS-M: Denominator for proportional prices
45	ISPPRSANZP	☐	PRSANZP	ISPWERT8	DEC	8	0	IS-M: Number of periods in billing period
46	ISPBRTWR_P	☐	ISPBRTWR	WERTV8	CURR	15	2	IS-M: Gross Value in Document Currency
47	ISPPRBAS_V	☐	PRBAS_VK	PRBAS_ISP	CHAR	1	0	Price Basis for Shipping Costs
48	ISPLAGRP_V	☐	LANDGRP_VK	LANDGRP_VK	CHAR	2	0	Country grouping for shipping costs	TJG92
49	ISPXFKKOMP	☐	XFKKOMP	XFELD	CHAR	1	0	Indicator: Perform Billing in Full for Billing Period
50	ISPXFKENDE	☐	XFKENDE	XFELD	CHAR	1	0	Indicator: Billing at end of calculation
51	ISPSFPOS	☐	XSEPFKPOS	XFELD	CHAR	1	0	Separate billing document for order item
52	ISPXKOMPP	☐	XKOMPP	XFELD	CHAR	1	0	IS-M: Full period (billing)
53	ISPVERSDAT	☐	VRSNDDATUM	DATUM	DATS	8	0	IS-M: Shipping Date
54	ISPLANDE	☐	LANDE_ISP	LAND1	CHAR	3	0	Current country being supplied	*
55	ISPRKAUFNR	☐	J_RK_AUFNR	J_RK_AUFNR	CHAR	8	0	Order Number of RK Order for Account Assignment
56	ISPRKPOSNR	☐	J_RK_POSNR	J_RK_POSNR	NUMC	2	0	Item Number of RK Order for Account Assignment
57	ISPCOAUFNR	☐	J_CO_AUFNR	AUFNR	CHAR	12	0	Order number of internal CO order for account assignment	AUFK
58	ISPVAUSGB	☐	VAUSGB	VAUSGB	CHAR	10	0	Issue	JDTVAUSGB
59	ISPXFKBALF	☐	XFKBASLIEF	XFELD	CHAR	1	0	IS-M: Billing based on delivery
60	ISPXFKBAAU	☐	XFKBASAUFT	XFELD	CHAR	1	0	IS-M: Billing based on order
61	ISPVKBURZU	☐	VKBURZUS	VKBUR	CHAR	4	0	Sales office responsible	*
62	ISPXSTABGR	☐	JXMWSTABGR	XFELD	CHAR	1	0	VAT to be accrued proportionally for payment in billing
63	ISPXIMMAT	☐	XIMMATRIK	XFELD	CHAR	1	0	Indicator: Proof of matriculation provided
64	ISPIMMATD	☐	IMMATDAT	DATUM	DATS	8	0	Matriculation Certificate Valid To
65	ISPXFKRUEK	☐	XFKRUECK	XFELD	CHAR	1	0	IS-M: Retroactive Billing of Period Already Billed
66	ISPIVWKN	☐	IVWKN	IVWKN	CHAR	8	0	Circulation Audit Report Category ID	*
67	ISPXIVW	☐	XIVW	XFELD	CHAR	1	0	Indicator: Relevant for audit report
68	ISPJKPAVRG	☐	JKPAVONREG	DATUM	DATS	8	0	Normal Start of Address Validity for Retro.Order Items

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in