SAP ABAP View VIGW_V_VZGPO (View auf Geschäftspartner Gewerbeprojekt)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-MI (Application Component) Migration
     ⤷ RE_MI_CR (Package) RE: Migration CRE (Data Dictionary Only)

Basic Data

View Type	D	Database View
Database View	VIGW_V_VZGPO
Short Description	View auf Geschäftspartner Gewerbeprojekt
Root table	BP000	Business Partner Master (General Data)

Table

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

Join Conditions

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

View Fields

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

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