SAP ABAP View CRMH_BUAG_BDATA (CRM: Search for Business Partner Using Bank Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP-BAG (Application Component) Business Agreements
     ⤷ CRM_BUPA_FRG0130 (Package) CRM Business Agreements for Business Partner

Basic Data

View Type	D	Database View
Database View	CRMH_BUAG_BDATA
Short Description	CRM: Search for Business Partner Using Bank Data
Root table	CRMM_BUAG	Business Partner: Business Agreement Set (Header)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMM_BUAG	CRMM_BUAG
2	CRMM_BUAG_H	CRMM_BUAG_H
3	CRMM_BUAG_L_FICA
4	BUT000
5	BUT100
6	CRMC_BUAG_ACTV
7	BUT0BK

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMM_BUAG_L_FICA	CLIENT	JL	EQ				0	0
2	BUT000	CLIENT	JR	EQ			AND	0	0
3	CRMM_BUAG_L_FICA	BUPA_GUID	JL	EQ				0	0
4	BUT000	PARTNER_GUID	JR	EQ			AND	0	0
5	CRMM_BUAG_L_FICA	CLIENT	JL	EQ				0	0
6	BUT0BK	MANDT	JR	EQ			AND	0	0
7	CRMM_BUAG_H	CLIENT	JL	EQ				0	0
8	BUT000	CLIENT	JR	EQ			AND	0	0
9	CRMM_BUAG_H	BUAG_GUID	JL	EQ				0	0
10	CRMM_BUAG_L_FICA	BUAG_GUID	JR	EQ			AND	0	0
11	CRMM_BUAG	CLIENT	JL	EQ				0	0
12	CRMM_BUAG_H	CLIENT	JR	EQ			AND	0	0
13	CRMM_BUAG	BUAG_GUID	JL	EQ				0	0
14	CRMM_BUAG_L_FICA	BUAG_GUID	JR	EQ			AND	0	0
15	CRMC_BUAG_ACTV	CLIENT	JL	EQ				0	0
16	BUT000	CLIENT	JR	EQ			AND	0	0
17	BUT100	MANDT	JL	EQ				0	0
18	BUT0BK	MANDT	JR	EQ			AND	0	0
19	BUT100	PARTNER	JL	EQ				0	0
20	BUT0BK	PARTNER	JR	EQ			AND	0	0
21	BUT000	CLIENT	JL	EQ				0	0
22	BUT0BK	MANDT	JR	EQ			AND	0	0
23	BUT000	PARTNER	JL	EQ				0	0
24	BUT0BK	PARTNER	JR	EQ			AND	0	0
25	CRMC_BUAG_ACTV	ACTV_ACCOUNT		EQ	'2'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	BUT000	CLIENT		☐	MANDT	☐	Client
2	PARTNER	BUT000	PARTNER		☐	BU_PARTNER	☐	Business Partner Number
3	BDID	CRMM_BUAG_H	BDID_IN		☐	CRMT_BUAG_BDID_IN	☐	Bank Details ID for Incoming Payments
4	VALID_TO	CRMM_BUAG_H	VALID_TO		☐	BU_DATTO	☐	Validity Date (Valid To)
5	BUAG_ID	CRMM_BUAG	BUAG_ID		☐	CRMT_BUAG_ID	☐	Number of Business Agreement
6	BUAG_GUID	CRMM_BUAG	BUAG_GUID		☐	CRMT_BUAG_GUID	☐	GUID of the Business Agreement
7	BUAG_DEFAULT	CRMM_BUAG_H	BUAG_DEFAULT		☐	CRMT_BUAG_DEFAULT	☐	Standard Business Agreement
8	BUAG_TEXT	CRMM_BUAG	BUAG_TEXT		☐	CRMT_BUAG_TEXT	☐	Text for Business Agreement
9	MC_NAME1	BUT000	MC_NAME1		☐	BU_MCNAME1	☐	Search Help Field 1 (Name 1/Last Name)
10	MC_NAME2	BUT000	MC_NAME2		☐	BU_MCNAME2	☐	Search Help Field 2 (Name 2/First Name)
11	BKVID	BUT0BK	BKVID		☐	BU_BKVID	☐	Bank details ID
12	BANKS	BUT0BK	BANKS		☐	BU_BANKS	☐	Bank Country Key
13	BANKL	BUT0BK	BANKL		☐	BU_BANKK	☐	Bank Key
14	BANKN	BUT0BK	BANKN		☐	BU_BANKN	☐	Bank Account Number
15	RLTYP	BUT100	RLTYP		☐	BU_PARTNERROLE	☐	BP Role
16	DFVAL	BUT100	DFVAL		☐	BU_DFVAL	☐	BP: Differentiation type value

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	20140117
SAP Release Created in	30A