SAP ABAP Table V_BUT000_READ (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster	BUT000
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PARTNER	☑	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number
3	TYPE	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
4	BU_SORT1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
5	BU_SORT2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
6	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	TSAD3
7	NAME_ORG1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
8	NAME_ORG2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
9	NAME_ORG3	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
10	NAME_ORG4	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
11	NAME_LAST	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
12	NAME_FIRST	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
13	NAME_LST2	☐	BU_NAMEPL2	BU_NAME	CHAR	40	0	Other Last Name of a Person
14	NAME_LAST2	☐	BU_BIRTHNM	BU_NAME	CHAR	40	0	Name at birth of business partner
15	NAMEMIDDLE	☐	BU_NAMEMID	BU_NAME	CHAR	40	0	Middle name or second forename of a person
16	TITLE_ACA1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	TSAD2
17	TITLE_ACA2	☐	AD_TITLE2	AD_TITLE1	CHAR	4	0	Second academic title (key)	TSAD2
18	TITLE_ROYL	☐	AD_TITLES	AD_TITLES	CHAR	4	0	Name supplement, e.g. noble title (key)	TSAD5
19	PREFIX1	☐	AD_PREFIX	AD_PREFIX	CHAR	4	0	Name Prefix (Key)	TSAD4
20	PREFIX2	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	TSAD4
21	NAME1_TEXT	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
22	NICKNAME	☐	BU_NICKNAM	BU_NAME	CHAR	40	0	Nickname of Business Partner (Person)
23	INITIALS	☐	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
24	NAMEFORMAT	☐	AD_FORMAT	AD_NAMFORM	CHAR	2	0	Name format	T005N
25	NAMCOUNTRY	☐	AD_NAMCTRY	LAND1	CHAR	3	0	Country for name format rule	T005
26	LANGU_CORR	☐	BU_LANGU_CORR	SPRAS	LANG	1	0	Business Partner: Correspondence Language	T002
27	XSEXM	☐	BU_XSEXM	XFELD	CHAR	1	0	Selection: Business partner is male
28	XSEXF	☐	BU_XSEXF	XFELD	CHAR	1	0	Selection: Business partner is female
29	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number
30	NAME_GRP1	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
31	NAME_GRP2	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_BUT000_READ	CLIENT	T000	MANDT	KEY	1	CN
2	V_BUT000_READ	LANGU_CORR	T002	SPRAS	REF	C	CN
3	V_BUT000_READ	NAMCOUNTRY	T005	LAND1	REF	C	CN
4	V_BUT000_READ	NAMEFORMAT	T005N	NAMEFORMAT	REF	C	CN
5	V_BUT000_READ	PREFIX1	TSAD4	PREFIX_KEY
6	V_BUT000_READ	PREFIX2	TSAD4	PREFIX_KEY
7	V_BUT000_READ	TITLE	TSAD3	TITLE	REF
8	V_BUT000_READ	TITLE_ACA1	TSAD2	TITLE_KEY
9	V_BUT000_READ	TITLE_ACA2	TSAD2	TITLE_KEY
10	V_BUT000_READ	TITLE_ROYL	TSAD5	TITLE_KEY

History

Last changed by/on	SAP	20140117
SAP Release Created in