SAP ABAP View V_REBW_PARTNER (RE BW: View for Extraction of Partner Data)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ RE (Application Component) Real Estate Management
     ⤷ ISRE (Package) Reporting Real Estate Management: Connection IS-RE <-> BW

Basic Data

View Type	D	Database View
Database View	V_REBW_PARTNER
Short Description	RE BW: View for Extraction of Partner Data
Root table	VZGPO	Partner/role object relationship

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VZGPO	VZGPO
2	BP000

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VZGPO	MANDT	JL	EQ				0	0
2	BP000	MANDT	JR	EQ			AND	0	0
3	VZGPO	PARTNR	JL	EQ				0	0
4	BP000	PARTNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	BP000	MANDT		☐	MANDT	☐	Client
2	SNUMOBJ	VZGPO	SNUMOBJ		☐	VVNUMOBJ	☐	Key for number range object
3	SOBJEKT	VZGPO	SOBJEKT		☐	VVSOBJGPO	☐	Internal key for object for business partner table
4	ROLETYP	VZGPO	ROLETYP		☐	BP_ROLETYP	☐	Business Partner Role Category
5	DTRANS	VZGPO	DTRANS		☐	VVDTRANS	☐	Flow data key: System date
6	PARTNR	BP000	PARTNR		☐	BP_PARTNR_OLD	☐	Business Partner Number
7	EXTPARTNR	BP000	EXTPARTNR		☐	BP_EXT_PNR	☐	External Business Partner ID
8	CUSTOMER	BP000	CUSTOMER		☐	KUNNR	☐	Customer Number
9	TYPE	BP000	TYPE		☐	BP_TYPE_OLD	☐	Partner category
10	BP_GROUP	BP000	BP_GROUP		☐	BP_GROUP	☐	BP: Collective Business Partner Indicator
11	GROUP_ID	BP000	GROUP_ID		☐	BP_GRP_ID_OLD	☐	Business Partner Grouping
12	NAME1	BP000	NAME1		☐	BP_NAME1	☐	Name 1 (surname for persons, otherwise company name)
13	NAME2	BP000	NAME2		☐	BP_NAME2	☐	Name 2 (Continuation of NAME 1)
14	LANGU	BP000	LANGU		☐	LANGU	☐	Language Key
15	TITLE	BP000	TITLE		☐	BP_TITLE_OLD	☐	Form of Address (Key)
16	TITLE_LET	BP000	TITLE_LET		☐	BP_TITL_LT	☐	Salutation
17	ADR_REF	BP000	ADR_REF		☐	BP_ADR_REF_OLD	☐	Address ID
18	SORT1	BP000	SORT1		☐	BP_SORT1	☐	Sort Field 1
19	SORT2	BP000	SORT2		☐	BP_SORT2	☐	Sort Field 2
20	SORT_PHON	BP000	SORT_PHON		☐	BP_SORT_PH	☐	Sort Field for Phonetic Search; Obsolete
21	MC_NAME1	BP000	MC_NAME1		☐	BP_MC_NAM1	☐	Field NAME1 in Upper Case
22	MC_NAME2	BP000	MC_NAME2		☐	BP_MC_NAM2	☐	Field NAME2 in Upper Case
23	SOURCE	BP000	SOURCE		☐	BP_SOURCE	☐	Source Key of Business Partner Data
24	CRUSER	BP000	CRUSER		☐	BP_CRUSER	☐	Entered by
25	CRDAT	BP000	CRDAT		☐	BP_CRDAT	☐	Creation Date
26	VIP	BP000	VIP		☐	BP_VIP	☐	Business Partner: VIP Partner
27	GROUP_D	BP000	GROUP_D		☐	BP_GROUP_D	☐	Target Group
28	DEL_IND	BP000	DEL_IND		☐	BP_DEL_IND	☐	Deletion Flag
29	BEGRU	BP000	BEGRU		☐	BEGRU	☐	Authorization Group
30	XTITLE	BP000	XTITLE		☐	BP_XTITLE	☐	Text of Form of Address
31	XTIT_LE	BP000	XTIT_LE		☐	BP_XTIT_LE	☐	Salutation
32	PAR_REL	BP000	PAR_REL		☐	BP_PAR_REL	☐	Business Partner Released
33	NAME_LAST	BP000	NAME_LAST		☐	BP_NAMLAST	☐	Last Name
34	NAME_FIRST	BP000	NAME_FIRST		☐	BP_NAMFRST	☐	First Name
35	TITLE_AC	BP000	TITLE_AC		☐	BP_TITL_AC_OLD	☐	Academic Title
36	N_PREFIX	BP000	N_PREFIX		☐	BP_PREFIX_OLD	☐	Name Prefix
37	N_ADDITION	BP000	N_ADDITION		☐	BP_ADDITN_OLD	☐	Name Affix
38	NICKNAME	BP000	NICKNAME		☐	BP_NICKNAM	☐	Known As
39	SEX	BP000	SEX		☐	BP_SEX_OLD	☐	Gender of Business Partner
40	PROFESSION	BP000	PROFESSION		☐	BP_PROFESS_OLD	☐	Description of Occupation for Business Partner
41	NATION	BP000	NATION		☐	BP_CNTR_N	☐	Nationality
42	STATE	BP000	STATE		☐	BP_CNTR_ST	☐	Citizenship
43	BIRTH_DATE	BP000	BIRTH_DATE		☐	BP_BIRTHD	☐	Date of Birth of Business Partner
44	BIRTH_PLAC	BP000	BIRTH_PLAC		☐	BP_BIRTHPL	☐	Birthplace
45	BIRTH_NAME	BP000	BIRTH_NAME		☐	BP_BIRTHNA	☐	Name at Birth
46	BIRTH_N_AD	BP000	BIRTH_N_AD		☐	BP_BIRTH_A	☐	Name at Birth Affix
47	DEATH_DATE	BP000	DEATH_DATE		☐	BP_DEATH_D	☐	Date of Death
48	MARITAL_ST	BP000	MARITAL_ST		☐	BP_MARITAL_OLD	☐	Marital Status
49	PROPRTY_ST	BP000	PROPRTY_ST		☐	BP_PROPRTY_OLD	☐	Marital property regime
50	CHILDREN	BP000	CHILDREN		☐	BP_CHILDRN	☐	Number of Children Belonging to the Business Partner
51	MEM_HOUSE	BP000	MEM_HOUSE		☐	BP_MEM_HOU	☐	Number of People Living in the Household
52	INCOME_CUR	BP000	INCOME_CUR		☐	BP_INC_CUR	☐	Currency of Net Income
53	NET_INCOME	BP000	NET_INCOME		☐	BP_NET_INC	☐	Net Annual Income
54	MO_NET_INC	BP000	MO_NET_INC		☐	BP_MO_INC	☐	Monthly Net Income of Business Partner
55	NET_INC_Y	BP000	NET_INC_Y		☐	BP_N_INC_Y	☐	Year of Net Annual Income
56	MO_INC_M	BP000	MO_INC_M		☐	BP_M_INC_M	☐	Calendar Month of Monthly Net Income
57	MO_INC_Y	BP000	MO_INC_Y		☐	BP_M_INC_Y	☐	Year of Monthly Net Income
58	PERS_NR	BP000	PERS_NR		☐	BP_PERS_NR	☐	Personnel Number
59	STAFF_GRP	BP000	STAFF_GRP		☐	BP_STAFF_G	☐	Employee Group
60	HR_ORG_REF	BP000	HR_ORG_REF		☐	HR_ORG_REF	☐	HR Org. Link
61	XUBNAME	BP000	XUBNAME		☐	XUBNAME	☐	User Name in User Master Record
62	STAFF_REF	BP000	STAFF_REF		☐	BP_STAFF_R	☐	Employee
63	ORG_NAME	BP000	ORG_NAME		☐	BP_NAME1	☐	Name 1 (surname for persons, otherwise company name)
64	ORG_NAME2	BP000	ORG_NAME2		☐	BP_NAME2	☐	Name 2 (Continuation of NAME 1)
65	CALENDARID	BP000	CALENDARID		☐	BP_CAL_ID	☐	Factory calendar
66	LEGAL_ENTY	BP000	LEGAL_ENTY		☐	BP_LEG_ETY_OLD	☐	Legal Form of Organization
67	LEGAL_ORG	BP000	LEGAL_ORG		☐	BP_LEG_ORG_OLD	☐	Legal Entity of Organization
68	BALANCE_FL	BP000	BALANCE_FL		☐	BP_BAL_FLG	☐	Balance Sheet Display
69	FOUND_YEAR	BP000	FOUND_YEAR		☐	BP_FOUND_Y	☐	Foundation Year of Organization
70	COMM_REGIS	BP000	COMM_REGIS		☐	BP_COM_REG	☐	Entry in Commercial Register
71	COMM_REG_D	BP000	COMM_REG_D		☐	BP_COM_R_D	☐	Date of Entry in Commercial Register
72	CNTRY_COMP	BP000	CNTRY_COMP		☐	BP_CNTR_HD	☐	Country of Organization's Registered Office
73	COMP_HEAD	BP000	COMP_HEAD		☐	BP_COMP_HD	☐	Registered Office
74	LIQUID_DAT	BP000	LIQUID_DAT		☐	BP_LIQUI_D	☐	Date of Liquidation
75	COMP_NR	BP000	COMP_NR		☐	BBBNR	☐	International location number (part 1)
76	COMP_NR_AD	BP000	COMP_NR_AD		☐	BBSNR	☐	International location number (Part 2)
77	BUBKZ	BP000	BUBKZ		☐	BUBKZ	☐	Check digit for the international location number
78	IND_SECTOR	BP000	IND_SECTOR		☐	BP_BRSCH_OLD	☐	Industry Keys
79	MIN_RESERV	BP000	MIN_RESERV		☐	BP_MIN_RSV	☐	Bank Subject to Minimum Reserve Requirement
80	BAL_SH_CUR	BP000	BAL_SH_CUR		☐	BP_BAL_CUR	☐	Balance Sheet Currency
81	CAP_INCR_A	BP000	CAP_INCR_A		☐	BP_CA_IN_A	☐	Amount of last capital increase
82	CAP_INCR_Y	BP000	CAP_INCR_Y		☐	BP_CA_IN_Y	☐	Year of Last Capital Increase
83	BANKL	BP000	BANKL		☐	BANKK	☐	Bank Keys
84	BANKS	BP000	BANKS		☐	BANKS	☐	Bank country key

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in