SAP ABAP Table BPVJ1 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	BPVJ1	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BELNR	☑	BP_BELNR	BP_BELNR	NUMC	10	0	Document number from budget allocation & structure planning	BPBK
3	BUZEI	☑	CO_BUZEI	BUZEI	NUMC	3	0	Posting row
4	WTJHR	☐	BP_WJT	WERTV8	CURR	15	2	Annual value in transaction currency
5	WLJHR	☐	BP_WJL	WERTV8	CURR	15	2	Annual value in ledger currency
6	KALNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure
7	KLVAR	☐	CK_KLVAR	KLVAR	CHAR	4	0	Costing Variant	TCK03
8	SPRED	☐	SPRED	SPRED	CHAR	4	0	Distribution Key	T821S
9	LEDNR	☐	BP_LEDNR	LEDNR_BP	CHAR	4	0	Budget/Planning Ledger
10	OBJNR	☐	BP_OBJEKT	J_OBJNR	CHAR	22	0	Object number	ONR00
11	POSIT	☐	BP_POSIT	BP_POSIT	CHAR	8	0	Internal commitment item (8 chars)
12	TRGKZ	☐	BP_TRGKZ	BP_TRGKZ	CHAR	1	0	Object indicator
13	WRTTP	☐	CO_WRTTP	CO_WRTTP	CHAR	2	0	Value Type
14	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
15	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	FMFINCODE
16	VERSN	☐	BP_VERSION	BP_VERSION	CHAR	3	0	Planning/budgeting version
17	VORGA	☐	BP_VORGANG	ACTIVITY	CHAR	4	0	Budget Type Budgeting/Planning	T022
18	TWAER	☐	TWAER	WAERS	CUKY	5	0	Transaction Currency	TCURC
19	PLDAT	☐	PLDAT	DATUM	DATS	8	0	Value Date for Currency Translation
20	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
21	CPUDT	☐	CO_CPUDT	DATUM	DATS	8	0	Date Document Was Created
22	USNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
23	SUMBZ	☐	CO_SUMBZ	BUZEI	NUMC	3	0	Number of posting lines for local objects
24	BLDAT	☐	BP_BLDAT	DATUM	DATS	8	0	Document Date
25	SGTEXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
26	NAMTEXT	☐	TDNAM	CHAR32	CHAR	32	0	Text Name
27	DELBZ	☐	CO_DELBZ	BUZEI	NUMC	3	0	Number of deleted line items
28	SUM_BPJA	☐	CO_SUMBZ	BUZEI	NUMC	3	0	Number of posting lines for local objects
29	DEL_BPJA	☐	CO_DELBZ	BUZEI	NUMC	3	0	Number of deleted line items
30	SUM_BPGE	☐	CO_SUMBZ	BUZEI	NUMC	3	0	Number of posting lines for local objects
31	DEL_BPGE	☐	CO_DELBZ	BUZEI	NUMC	3	0	Number of deleted line items
32	SUM_BPPE	☐	CO_SUMBZ	BUZEI	NUMC	3	0	Number of posting lines for local objects
33	DEL_BPPE	☐	CO_DELBZ	BUZEI	NUMC	3	0	Number of deleted line items
34	FOBEL	☐	BP_FOBEL	BP_BELNR	NUMC	10	0	Follow-On Document Number	BPBK
35	VERANT	☐	BP_VERANT	VERAB	CHAR	20	0	Person Responsible for Planning/Budgeting

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BPVJ1	BELNR	BPBK	BELNR	KEY	1	CN
2	BPVJ1	FOBEL	BPBK	BELNR	KEY	1	1
3	BPVJ1	GEBER	FMFINCODE	FINCODE	KEY	1	CN
4	BPVJ1	KLVAR	TCK03	KLVAR	KEY	1	CN
5	BPVJ1	KURST	TCURV	KURST	REF	C	CN
6	BPVJ1	MANDT	T000	MANDT	KEY	1	CN
7	BPVJ1	OBJNR	ONR00	OBJNR	KEY	1	CN
8	BPVJ1	SPRED	T821S	SPRED	REF	1	CN
9	BPVJ1	TWAER	TCURC	WAERS	KEY	1	CN
10	BPVJ1	VORGA	T022	ACTIVITY	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in