SAP ABAP View MBWA (General application)

Basic Data

View Type
	MBWA
Short Description	General application
Root table	BP030	BP: Business partner - address

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	BP030	BP030
2	SANS1	BP030	ADRNR	E
3	BP000	BP030	PARTNR	E
4	VIMI11	BP000	VADRNR	I

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	BP030	MANDT		☐	MANDT	☐	Client
2	PARTNR	BP030	PARTNR		☐	BP_PARTNR	☐	Business Partner Number
3	ADR_REF_K	BP030	ADR_REF_K		☐	BP_ADR_REF	☐	Address ID
4	ADR_DAT	BP030	ADR_DAT		☐	BP_ADR_DAT	☐	Business partner address relationship valid from
5	SBWNR	VIMI11	SBWNR		☐	SBWNR	☐	Application number
6	LAND1	SANS1	LAND1		☐	LAND1	☐	Country Key
7	PSTLZ	SANS1	PSTLZ		☐	PSTLZ	☐	Postal Code
8	ORT01	SANS1	ORT01		☐	ORT01_GP	☐	City
9	ORT02	SANS1	ORT02		☐	ORT02_GP	☐	District
10	PSTBZ	SANS1	PSTBZ		☐	PSTBZ	☐	Post delivery district
11	STRAS	SANS1	STRAS		☐	STRAS_GP	☐	House number and street
12	STRA1	SANS1	STRA1		☐	STRAS_GP	☐	House number and street
13	REGIO	SANS1	REGIO		☐	REGIO	☐	Region (State, Province, County)
14	EXTPARTNR	BP000	EXTPARTNR		☐	BP_EXT_PNR	☐	External Business Partner ID
15	CUSTOMER	BP000	CUSTOMER		☐	KUNNR	☐	Customer Number
16	TYPE	BP000	TYPE		☐	BP_TYPE	☐	Partner category
17	BP_GROUP	BP000	BP_GROUP		☐	BP_GROUP	☐	BP: Collective Business Partner Indicator
18	GROUP_ID	BP000	GROUP_ID		☐	BP_GRP_ID	☐	Business Partner Grouping
19	NAME1	BP000	NAME1		☐	BP_NAME1	☐	Name 1 (surname for persons, otherwise company name)
20	NAME2	BP000	NAME2		☐	BP_NAME2	☐	Name 2 (Continuation of NAME 1)
21	LANGU	BP000	LANGU		☐	LANGU	☐	Language Key
22	TITLE	BP000	TITLE		☐	BP_TITLE	☐	Form of Address (Key)
23	TITLE_LET	BP000	TITLE_LET		☐	BP_TITL_LT	☐	Salutation
24	ADR_REF	BP000	ADR_REF		☐	BP_ADR_REF	☐	Address ID
25	SORT1	BP000	SORT1		☐	BP_SORT1	☐	Sort Field 1
26	SORT2	BP000	SORT2		☐	BP_SORT2	☐	Sort Field 2
27	SORT_PHON	BP000	SORT_PHON		☐	BP_SORT_PH	☐	Sort Field for Phonetic Search; Obsolete
28	MC_NAME1	BP000	MC_NAME1		☐	BP_MC_NAM1	☐	Field NAME1 in Upper Case
29	MC_NAME2	BP000	MC_NAME2		☐	BP_MC_NAM2	☐	Field NAME2 in Upper Case
30	SOURCE	BP000	SOURCE		☐	BP_SOURCE	☐	Source Key of Business Partner Data
31	CRUSER	BP000	CRUSER		☐	BP_CRUSER	☐	Entered by
32	CRDAT	BP000	CRDAT		☐	BP_CRDAT	☐	Creation Date
33	VIP	BP000	VIP		☐	BP_VIP	☐	Business Partner: VIP Partner
34	GROUP_D	BP000	GROUP_D		☐	BP_GROUP_D	☐	Target Group
35	DEL_IND	BP000	DEL_IND		☐	BP_DEL_IND	☐	Deletion Flag
36	BEGRU	BP000	BEGRU		☐	BEGRU	☐	Authorization Group
37	XTITLE	BP000	XTITLE		☐	BP_XTITLE	☐	Text of Form of Address
38	XTIT_LE	BP000	XTIT_LE		☐	BP_XTIT_LE	☐	Salutation
39	PAR_REL	BP000	PAR_REL		☐	BP_PAR_REL	☐	Business Partner Released
40	NAME_LAST	BP000	NAME_LAST		☐	BP_NAMLAST	☐	Last Name
41	NAME_FIRST	BP000	NAME_FIRST		☐	BP_NAMFRST	☐	First Name
42	TITLE_AC	BP000	TITLE_AC		☐	BP_TITL_AC	☐	Academic Title
43	N_PREFIX	BP000	N_PREFIX		☐	BP_PREFIX	☐	Name Prefix
44	N_ADDITION	BP000	N_ADDITION		☐	BP_ADDITN	☐	Name Affix
45	NICKNAME	BP000	NICKNAME		☐	BP_NICKNAM	☐	Known As
46	SEX	BP000	SEX		☐	BP_SEX	☐	Gender of business partner
47	PROFESSION	BP000	PROFESSION		☐	BP_PROFESS	☐	Description of Occupation for Business Partner
48	NATION	BP000	NATION		☐	BP_CNTR_N	☐	Nationality
49	STATE	BP000	STATE		☐	BP_CNTR_ST	☐	Citizenship
50	BIRTH_DATE	BP000	BIRTH_DATE		☐	BP_BIRTHD	☐	Date of Birth of Business Partner
51	BIRTH_PLAC	BP000	BIRTH_PLAC		☐	BP_BIRTHPL	☐	Birthplace
52	BIRTH_NAME	BP000	BIRTH_NAME		☐	BP_BIRTHNA	☐	Name at Birth
53	BIRTH_N_AD	BP000	BIRTH_N_AD		☐	BP_BIRTH_A	☐	Name at Birth Affix
54	DEATH_DATE	BP000	DEATH_DATE		☐	BP_DEATH_D	☐	Date of Death
55	MARITAL_ST	BP000	MARITAL_ST		☐	BP_MARITAL	☐	Marital Status
56	PROPRTY_ST	BP000	PROPRTY_ST		☐	BP_PROPRTY	☐	Marital Property Regime
57	INCOME_CUR	BP000	INCOME_CUR		☐	BP_INC_CUR	☐	Currency of Net Income
58	NET_INC_Y	BP000	NET_INC_Y		☐	BP_N_INC_Y	☐	Year of Net Annual Income
59	MO_INC_M	BP000	MO_INC_M		☐	BP_M_INC_M	☐	Calendar Month of Monthly Net Income
60	MO_INC_Y	BP000	MO_INC_Y		☐	BP_M_INC_Y	☐	Year of Monthly Net Income
61	PERS_NR	BP000	PERS_NR		☐	BP_PERS_NR	☐	Personnel Number
62	STAFF_GRP	BP000	STAFF_GRP		☐	BP_STAFF_G	☐	Employee Group
63	HR_ORG_REF	BP000	HR_ORG_REF		☐	HR_ORG_REF	☐	HR Org. Link
64	XUBNAME	BP000	XUBNAME		☐	XUBNAME	☐	User Name in User Master Record
65	STAFF_REF	BP000	STAFF_REF		☐	BP_STAFF_R	☐	Employee
66	ORG_NAME	BP000	ORG_NAME		☐	BP_NAME1	☐	Name 1 (surname for persons, otherwise company name)
67	ORG_NAME2	BP000	ORG_NAME2		☐	BP_NAME2	☐	Name 2 (Continuation of NAME 1)
68	CALENDARID	BP000	CALENDARID		☐	BP_CAL_ID	☐	Factory calendar
69	LEGAL_ENTY	BP000	LEGAL_ENTY		☐	BP_LEG_ETY	☐	Legal Form of Organization
70	LEGAL_ORG	BP000	LEGAL_ORG		☐	BP_LEG_ORG	☐	Legal Entity of Organization
71	BALANCE_FL	BP000	BALANCE_FL		☐	BP_BAL_FLG	☐	Balance Sheet Display
72	FOUND_YEAR	BP000	FOUND_YEAR		☐	BP_FOUND_Y	☐	Foundation Year of Organization
73	COMM_REGIS	BP000	COMM_REGIS		☐	BP_COM_REG	☐	Entry in Commercial Register
74	COMM_REG_D	BP000	COMM_REG_D		☐	BP_COM_R_D	☐	Date of Entry in Commercial Register
75	CNTRY_COMP	BP000	CNTRY_COMP		☐	BP_CNTR_HD	☐	Country of Organization's Registered Office
76	COMP_HEAD	BP000	COMP_HEAD		☐	BP_COMP_HD	☐	Registered Office
77	LIQUID_DAT	BP000	LIQUID_DAT		☐	BP_LIQUI_D	☐	Date of Liquidation
78	COMP_NR	BP000	COMP_NR		☐	BBBNR	☐	International location number (part 1)
79	COMP_NR_AD	BP000	COMP_NR_AD		☐	BBSNR	☐	International location number (Part 2)
80	BUBKZ	BP000	BUBKZ		☐	BUBKZ	☐	Check digit for the international location number
81	IND_SECTOR	BP000	IND_SECTOR		☐	BRSCH	☐	Industry key
82	MIN_RESERV	BP000	MIN_RESERV		☐	BP_MIN_RSV	☐	Bank Subject to Minimum Reserve Requirement
83	BAL_SH_CUR	BP000	BAL_SH_CUR		☐	BP_BAL_CUR	☐	Balance Sheet Currency
84	CAP_INCR_Y	BP000	CAP_INCR_Y		☐	BP_CA_IN_Y	☐	Year of Last Capital Increase
85	BANKL	BP000	BANKL		☐	BANKK	☐	Bank Keys
86	BANKS	BP000	BANKS		☐	BANKS	☐	Bank country key
87	SBWSTA	VIMI11	SBWSTA		☐	SBWSTA	☐	Applicant status
88	SBWTYP	VIMI11	SBWTYP		☐	SBWTYP	☐	Applicant category
89	XANSPRP	VIMI11	XANSPRP		☐	XANSPRP	☐	Contact person
90	XSTAAT	VIMI11	XSTAAT		☐	XSTAAT	☐	Nationality
91	XPASSNR	VIMI11	XPASSNR		☐	XPASSNR	☐	Passport number
92	DPASSV	VIMI11	DPASSV		☐	DPASSV	☐	Date of submission of passport
93	XARBSTR	VIMI11	XARBSTR		☐	XARBSTR	☐	Employer street
94	XARBORT	VIMI11	XARBORT		☐	XARBORT	☐	Employer postcode/city
95	XAVERM	VIMI11	XAVERM		☐	XAVERM	☐	Current landlord
96	XAVSTR	VIMI11	XAVSTR		☐	XAVSTR	☐	Landlord street
97	XAORT	VIMI11	XAORT		☐	XAORT	☐	Postal code/city current landlord
98	XREFEREN	VIMI11	XREFEREN		☐	XREFEREN	☐	Applicant reference data
99	SBONI	VIMI11	SBONI		☐	SBONI	☐	Credit standing application
100	XWBONI	VIMI11	XWBONI		☐	XWBONI	☐	Reason for credit standing
101	XALTSEX	VIMI11	XALTSEX		☐	XALTSEX	☐	Age/sex of children
102	SBUEADR	VIMI11	SBUEADR		☐	SBUEADR	☐	Guarantor address
103	XTIER1	VIMI11	XTIER1		☐	XTIERE	☐	Domestic animal description
104	XABSAGE	VIMI11	XABSAGE		☐	XABSAGE	☐	Reason for rejection
105	DABSAGE	VIMI11	DABSAGE		☐	DABSAGE	☐	Rejection date
106	XSITZ	VIMI11	XSITZ		☐	XSITZ	☐	Company head office
107	JOPTIO	VIMI11	JOPTIO		☐	JOPTIO	☐	Opting approved
108	RERF	VIMI11	RERF		☐	RERF	☐	Entered by
109	DERF	VIMI11	DERF		☐	DERF	☐	First Entered on
110	TERF	VIMI11	TERF		☐	TERF	☐	Time of Initial Entry
111	REHER	VIMI11	REHER		☐	REHER	☐	Source of initial entry
112	RBEAR	VIMI11	RBEAR		☐	RBEAR	☐	Employee ID
113	DBEAR	VIMI11	DBEAR		☐	DBEAR	☐	Last Edited on
114	TBEAR	VIMI11	TBEAR		☐	TBEAR	☐	Last Edited at
115	RBHER	VIMI11	RBHER		☐	RBHER	☐	Editing Source
116	DEINB	VIMI11	DEINB		☐	DEINB	☐	Date application was received
117	JLOESCH	VIMI11	JLOESCH		☐	JLOESCH	☐	Real Estate Deletion Indicator/Flag
118	IMKEY	VIMI11	IMKEY		☐	IMKEY	☐	Internal Key for Real Estate Object
119	INTRENO	VIMI11	INTRENO		☐	VVINTRENO	☐	Internal Real Estate Master Data Code

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	19971002
SAP Release Created in