SAP ABAP View V_BPSEARCH2 (Business Partner: Search View)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA-FS-BP (Application Component) Business Partner Enhancements for Financial Services
     ⤷ FBPAR (Package) Business Partner (Treasury/Real Estate)

Basic Data

View Type	D	Database View
Database View	V_BPSEARCH2
Short Description	Business Partner: Search View
Root table	BP000	Business Partner Master (General Data)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	BP000	BP000
2	BP030
3	SANS1

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	BP030	MANDT	JR	EQ			AND	0	0
3	BP000	PARTNR	JL	EQ				0	0
4	BP030	PARTNR	JR	EQ			AND	0	0
5	SANS1	MANDT	JL	EQ				0	0
6	BP030	MANDT	JR	EQ			AND	0	0
7	SANS1	ADRNR	JL	EQ				0	0
8	BP030	ADRNR	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	PARTNR	BP000	PARTNR		☐	BP_PARTNR_OLD	☐	Business Partner Number
3	EXTPARTNR	BP000	EXTPARTNR		☐	BP_EXT_PNR	☐	External Business Partner ID
4	CUSTOMER	BP000	CUSTOMER		☐	KUNNR	☐	Customer Number
5	NAME1	BP000	NAME1		☐	BP_NAME1	☐	Name 1 (surname for persons, otherwise company name)
6	NAME2	BP000	NAME2		☐	BP_NAME2	☐	Name 2 (Continuation of NAME 1)
7	GROUP_ID	BP000	GROUP_ID		☐	BP_GRP_ID_OLD	☐	Business Partner Grouping
8	SORT1	BP000	SORT1		☐	BP_SORT1	☐	Sort Field 1
9	SORT2	BP000	SORT2		☐	BP_SORT2	☐	Sort Field 2
10	DEL_IND	BP000	DEL_IND		☐	BP_DEL_IND	☐	Deletion Flag
11	BP_GROUP	BP000	BP_GROUP		☐	BP_GROUP	☐	BP: Collective Business Partner Indicator
12	TYPE	BP000	TYPE		☐	BP_TYPE_OLD	☐	Partner category
13	SORT_PHON	BP000	SORT_PHON		☐	BP_SORT_PH	☐	Sort Field for Phonetic Search; Obsolete
14	ADRNR	BP030	ADRNR		☐	BP_ADRNR_OLD	☐	Address Number
15	ADR_DAT	BP030	ADR_DAT		☐	BP_ADR_DAT	☐	Business partner address relationship valid from
16	ADR_D_E	BP030	ADR_D_E		☐	BP_ADR_D_E	☐	Business Partner Address Relationship Valid Until
17	ADR_REF_K	BP030	ADR_REF_K		☐	BP_ADR_REF_OLD	☐	Address ID
18	PSTL2	BP030	PSTL2		☐	PSTL2	☐	P.O. Box Postal Code
19	LAND1	SANS1	LAND1		☐	LAND1	☐	Country Key
20	PSTLZ	SANS1	PSTLZ		☐	PSTLZ	☐	Postal Code
21	REGIO	SANS1	REGIO		☐	REGIO	☐	Region (State, Province, County)
22	ORT01	SANS1	ORT01		☐	ORT01_GP	☐	City
23	STRAS	SANS1	STRAS		☐	STRAS_GP	☐	House number and street
24	PSTBZ	SANS1	PSTBZ		☐	PSTBZ	☐	Post delivery district

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