SAP ABAP Table VIBUUSRFLD (RE: Building - User Fields and Additional Fields)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

Table Category	INTTAB	Structure
Structure	VIBUUSRFLD	Table Relationship Diagram
Short Description	RE: Building - User Fields and Additional Fields

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	RE: Object - User Fields and Additional Fields
2	.INCLUDE	☐				0	0	Sort values for object
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	SNUMOBJ	☐	VVNUMOBJ	VVNUMOBJ	CHAR	2	0	Key for number range object
5	SOBJEKT	☐	VVSOBJGPO	CHAR13	CHAR	13	0	Internal key for object for business partner table
6	SLWID	☐	SLWID	SLWID	CHAR	7	0	Key word ID for user-defined fields	TCN00
7	USR00	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
8	USR01	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
9	USR02	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
10	USR03	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
11	USR04	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
12	USE04	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
13	USR05	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
14	USE05	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
15	USR06	☐	USRCURR13	USRCURR13	CURR	13	3	User-defined field for values (length 10,3)
16	USE06	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
17	USR07	☐	USRCURR13	USRCURR13	CURR	13	3	User-defined field for values (length 10,3)
18	USE07	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
19	USR08	☐	USRDATE	USRDATE	DATS	8	0	User field for date
20	USR09	☐	USRDATE	USRDATE	DATS	8	0	User field for date
21	USR10	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
22	USR11	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
23	USE04_3	☐	MSEH3	MSEH3	CHAR	3	0	External Unit of Measurement in Commercial Format (3-Char.)
24	XUSE04_T	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
25	XUSE04_L	☐	MSEHL	TEXT30	CHAR	30	0	Unit of Measurement Text (Maximum 30 Characters)
26	USE05_3	☐	MSEH3	MSEH3	CHAR	3	0	External Unit of Measurement in Commercial Format (3-Char.)
27	XUSE05_T	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
28	XUSE05_L	☐	MSEHL	TEXT30	CHAR	30	0	Unit of Measurement Text (Maximum 30 Characters)
29	XUSE06_K	☐	XWAERSK	TEXT15	CHAR	15	0	Currency key short text
30	XUSE06_L	☐	XWAERSL	TEXT40	CHAR	40	0	Currency key long text
31	XUSE07_K	☐	XWAERSK	TEXT15	CHAR	15	0	Currency key short text
32	XUSE07_L	☐	XWAERSL	TEXT40	CHAR	40	0	Currency key long text
33	.INCLUDE	☐				0	0	Amounts from VZSORT in second currency
34	USE06CUK	☐	SWHRKNDCUK	WAERS	CUKY	5	0	Second Currency for Correspondence	*
35	USR06CUK	☐	USRCR13CUK	USRCURR13	CURR	13	3	User-defined field for values (length 10,3) in 2nd currency
36	USE07CUK	☐	SWHRKNDCUK	WAERS	CUKY	5	0	Second Currency for Correspondence	*
37	USR07CUK	☐	USRCR13CUK	USRCURR13	CURR	13	3	User-defined field for values (length 10,3) in 2nd currency

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIBUUSRFLD	MANDT	T000	MANDT	KEY	1	CN
2	VIBUUSRFLD	SLWID	TCN00	SLWID	KEY	1	CN
3	VIBUUSRFLD	USE04	T006	MSEHI	REF	C	CN
4	VIBUUSRFLD	USE05	T006	MSEHI	REF	C	CN
5	VIBUUSRFLD	USE06	TCURC	WAERS	REF	C	CN
6	VIBUUSRFLD	USE07	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in