SAP ABAP Table VBKPF_ALV (RFPUEB00: Structure for ALV Field Catalog)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBAS (Package) Financial accounting 'Basis'

Basic Data

Table Category	INTTAB	Structure
Structure	VBKPF_ALV	Table Relationship Diagram
Short Description	RFPUEB00: Structure for ALV Field Catalog

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	XSELP	☐	XSELP	XFELD	CHAR	1	0	Item selected (selected, chosen, ...)
2	STATE	☐	STATE_ICON	SYCHAR132	CHAR	132	0	Status icon
3	.INCLUDE	☐				0	0	Document Header for Document Parking
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
5	AUSBK	☐	AUSBK	BUKRS	CHAR	4	0	Source Company Code	*
6	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
7	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
8	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
9	BSTAT	☐	BSTAT_D	BSTAT	CHAR	1	0	Document Status
10	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
11	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
12	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
13	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
14	WWERT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
15	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
16	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
17	AEDAT	☐	AEDT_VBKPF	DATUM	DATS	8	0	Date of the Last Document Change
18	UPDDT	☐	UPDDT	DATUM	DATS	8	0	Date of the Last Document Update
19	USNAM	☐	USNM_VBKPF	USNAM	CHAR	12	0	User Name
20	TCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code	*
21	BVORG	☐	BVORG	BVORG	CHAR	16	0	Number of Cross-Company Code Posting Transaction
22	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
23	BKTXT	☐	BKTXT	TEXT25	CHAR	25	0	Document Header Text
24	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
25	KOARS	☐	KOARS_003	CHAR5	CHAR	5	0	Account Types Allowed
26	XBSET	☐	XBSET	XFELD	CHAR	1	0	Tax information exists in the document
27	XSNET	☐	XSNET	XFELD	CHAR	1	0	G/L account amounts entered exclude tax
28	XBWAE	☐	XBWAE	XFELD	CHAR	1	0	Only transfer document in document currency when posting
29	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
30	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
31	HWAE2	☐	HWAE2	WAERS	CUKY	5	0	Currency Key of Second Local Currency	*
32	HWAE3	☐	HWAE3	WAERS	CUKY	5	0	Currency Key of Third Local Currency	*
33	KURSF	☐	KURSF	KURSF	DEC	9	5	Exchange rate
34	KURS2	☐	KURS2	KURSF	DEC	9	5	Exchange Rate for the Second Local Currency
35	KURS3	☐	KURS3	KURSF	DEC	9	5	Exchange Rate for the Third Local Currency
36	BASW2	☐	CURSR	CURSR	CHAR	1	0	Source Currency for Currency Translation
37	BASW3	☐	CURSR	CURSR	CHAR	1	0	Source Currency for Currency Translation
38	UMRD2	☐	UMRD2	CURDT	CHAR	1	0	Translation Date Type for Second Local Currency
39	UMRD3	☐	UMRD3	CURDT	CHAR	1	0	Translation Date Type for Third Local Currency
40	CURT2	☐	CURT2	CURTP	CHAR	2	0	Currency Type of Second Local Currency
41	CURT3	☐	CURT3	CURTP	CHAR	2	0	Currency Type of Third Local Currency
42	KUTY2	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	*
43	KUTY3	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	*
44	XMWST	☐	XMWST	XFELD	CHAR	1	0	Calculate tax automatically
45	PARGB	☐	PGBVW	GSBER	CHAR	4	0	Partner Business Area Default Value	TGSB
46	VBLNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
47	VGJHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
48	XFRGE	☐	XFRGE	XFELD	CHAR	1	0	Released
49	XPRFG	☐	XPRFG	XFELD	CHAR	1	0	Document complete
50	FRATH	☐	FRATH	WERT7	CURR	13	2	Unplanned Delivery Costs
51	XWFFR	☐	XWFFR	XFELD	CHAR	1	0	Release necessary
52	LOTKZ	☐	PSO_LOTKZ	LOTKZ	CHAR	10	0	Lot Number for Requests
53	FRWEG	☐	FRWEG	FRWEG	CHAR	4	0	Release Approv. Path	VBWF03
54	UPDTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
55	RELDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
56	RELTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
57	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
58	SUBN1_LVL	☐	SUBN1_LVL	NUM02	NUMC	2	0	Amount Release Approval Levels
59	BRNCH	☐	J_1ABRNCH	J_1BBRANCH	CHAR	4	0	Branch number	J_1BBRANCH
60	NUMPG	☐	J_1ANOPG	J_1ANOPG	NUMC	3	0	Number of pages of invoice
61	USCMP	☐	USCMP	USNAM	CHAR	12	0	Completed By
62	USREL	☐	USREL	USNAM	CHAR	12	0	Released By
63	USUPD	☐	USUPD	USNAM	CHAR	12	0	Changed By
64	XINVR_CURV	☐	XINVR_CURV	XFELD	CHAR	1	0	Indicator: Calculation allowed with inverted exchange rate ?
65	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
66	AWKEY	☐	AWKEY	AWKEY	CHAR	20	0	Object key
67	AWSYS	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
68	REINDAT	☐	REINDAT	DATUM	DATS	8	0	Invoice Receipt Date
69	TXKRS	☐	TXKRS_BKPF	KURSF	DEC	9	5	Exchange Rate for Taxes
70	PROPMANO	☐	RE_MANDAT	RE_MANDAT	CHAR	13	0	Real Estate Management Mandate
71	LDGRP	☐	FAGL_LDGRP	FAGL_LDGRP	CHAR	4	0	Ledger Group	*
72	VATDATE	☐	VATDATE	DATUM	DATS	8	0	Tax Reporting Date
73	KURSX	☐	GLE_FXR_DTE_RATEX28	GLE_FXR_RATEX28	DEC	28	14	Market Data Exchange Rate
74	KUR2X	☐	GLE_FXR_DTE_RATE2X28	GLE_FXR_RATEX28	DEC	28	14	Market Data Exchange Rate 2
75	KUR3X	☐	GLE_FXR_DTE_RATE3X28	GLE_FXR_RATEX28	DEC	28	14	Market Data Exchange Rate 3
76	XMCA	☐	GLE_DTE_MCA_XMCA	XFELD	CHAR	1	0	Document Originates from Multi Currency Accounting
77	.INCLU--AP	☐				0	0	US federal
78	EXCLUDE_FLAG	☐	EXCLUDE_FLG	XFELD	CHAR	1	0	PPA Exclude Indicator
79	.INCLU--AP	☐				0	0	IS-PS: Append Structure VBKPF for Payment Requests
80	.INCLUDE	☐				0	0	IS-PS: Include for Append Parked Payment Request Doc.Header
81	PSOTY	☐	PSOTY_D	PSOTY	CHAR	2	0	Document category payment requests	PSOTP
82	PSOAK	☐	PSOAK	PSOAK	CHAR	10	0	Reason	PSO12
83	PSOKS	☐	PSOKS	PSOKS	CHAR	10	0	Region	*
84	PSOSG	☐	PSOSG	PSOSG	CHAR	1	0	Reason for reversal - IS-PS requests
85	PSOFN	☐	PSOFN	CHAR30	CHAR	30	0	IS-PS: File number
86	INTFORM	☐	FM_INTFORM	CHAR4	CHAR	4	0	Interest Formula
87	INTDATE	☐	FM_INTDATE	DATUM	DATS	8	0	Interest Calc. Date
88	PSODT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
89	PSOTM	☐	PSOTM	UZEIT	TIMS	6	0	Last changed at
90	DBBLG	☐	DBBLG	BELNR	CHAR	10	0	Recurring Entry Document Number
91	STGRD	☐	STGRD	STGRD	CHAR	2	0	Reason for Reversal	*
92	PSOXWF	☐	PSOXWF	XFELD	CHAR	1	0	Release via request Workflow required
93	.INCLU--AP	☐				0	0	Credit Card: Append for VBKPF
94	.INCLUDE	☐				0	0	Credit Card: Include for Appends for BKPF, VBKPF
95	CCINS	☐	CCINS_30F	CCINS_30F	CHAR	4	0	Payment cards: Card type	TCRIN
96	CCNUM	☐	CCNUM_30F	CCNUM_30F	CHAR	25	0	Payment cards: Card number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VBKPF_ALV	BLART	T003	BLART	REF	1	CN
2	VBKPF_ALV	BRNCH	J_1BBRANCH	BRANCH		1	CN
3	VBKPF_ALV	CCINS	TCRIN	CCINS
4	VBKPF_ALV	FRWEG	VBWF03	FRWEG
5	VBKPF_ALV	PARGB	TGSB	GSBER
6	VBKPF_ALV	PSOAK	PSO12	PSOAK
7	VBKPF_ALV	PSOTY	PSOTP	PSOTYP

History

Last changed by/on	SAP	20130529
SAP Release Created in	470