SAP ABAP Table AFVU (DB structure of the user fields of the operation)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CIC (Application Component) Interaction Center WinClient
     ⤷ CO (Package) R/3 Application development: PP Production orders

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	AFVU	Table Relationship Diagram
Short Description	DB structure of the user fields of the operation

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	AUFPL	☑	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
3	APLZL	☑	CO_APLZL	CO_APLZL	NUMC	8	0	General counter for order	AFVC
4	.INCLUDE	☐				0	0	Include structure of the user fields of the operation
5	SLWID	☐	SLWID	SLWID	CHAR	7	0	Key word ID for user-defined fields	*
6	USR00	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
7	USR01	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
8	USR02	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
9	USR03	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
10	USR04	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
11	USE04	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
12	USR05	☐	USRQUAN13	USRQUAN13	QUAN	13	3	User field for quantity (length 10.3)
13	USE05	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
14	USR06	☐	USRCURR13	USRCURR13	CURR	13	3	User-defined field for values (length 10,3)
15	USE06	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
16	USR07	☐	USRCURR13	USRCURR13	CURR	13	3	User-defined field for values (length 10,3)
17	USE07	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
18	USR08	☐	USRDATE	USRDATE	DATS	8	0	User field for date
19	USR09	☐	USRDATE	USRDATE	DATS	8	0	User field for date
20	USR10	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
21	USR11	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
22	.INCLUDE	☐				0	0	JV data: (GJV_DATA_2),jv_oco
23	.INCLUDE	☐				0	0	JV data: (vname,recid,etype),jv_otype,jv_jibcl,jv_jibsa
24	.INCLUDE	☐				0	0	General assignments of application objects
25	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
26	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	*
27	ETYPE	☐	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	*
28	JV_OTYPE	☐	JV_OTYPE	JV_OTYPE	CHAR	4	0	Joint Venture Object Type
29	JV_JIBCL	☐	JV_JIBCL	JV_JIBCL	CHAR	3	0	JIB/JIBE Class	*
30	JV_JIBSA	☐	JV_JIBSA	JV_JIBSA	CHAR	5	0	JIB/JIBE Subclass A	*
31	JV_OCO	☐	JV_OR_CO	JV_OR_COB	CHAR	1	0	JV original cost object
32	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AFVU	APLZL	AFVC	APLZL	KEY	1	1
2	AFVU	MANDT	T000	MANDT
3	AFVU	USE04	T006	MSEHI
4	AFVU	USE05	T006	MSEHI
5	AFVU	USE06	TCURC	WAERS
6	AFVU	USE07	TCURC	WAERS

History

Last changed by/on	SAP	20130604
SAP Release Created in