SAP ABAP View BBPV_LIM_CTR_LOC (View to Search for Local Contracts)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ BBP_PRODOC (Package) B2B Procurement Document

Basic Data

View Type	D	Database View
Database View	BBPV_LIM_CTR_LOC
Short Description	View to Search for Local Contracts
Root table	BBPD_PD_INDEX	Index Table for Fast Access to Contracts and AVLs

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	BBPD_PD_INDEX	BBPD_PD_INDEX
2	CRMD_ORDERADM_H
3	CRMD_ORDERADM_I
4	BBP_PDIGP
5	BUT000

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMD_ORDERADM_H	CLIENT	JL	EQ				0	0
2	BBPD_PD_INDEX	CLIENT	JR	EQ			AND	0	0
3	CRMD_ORDERADM_H	GUID	JL	EQ				0	0
4	BBPD_PD_INDEX	HEADER	JR	EQ			AND	0	0
5	CRMD_ORDERADM_I	CLIENT	JL	EQ				0	0
6	BBPD_PD_INDEX	CLIENT	JR	EQ			AND	0	0
7	CRMD_ORDERADM_I	GUID	JL	EQ				0	0
8	BBPD_PD_INDEX	ITEM	JR	EQ			AND	0	0
9	BBP_PDIGP	CLIENT	JL	EQ				0	0
10	BBPD_PD_INDEX	CLIENT	JR	EQ			AND	0	0
11	BBP_PDIGP	GUID	JL	EQ				0	0
12	BBPD_PD_INDEX	ITEM	JR	EQ			AND	0	0
13	BUT000	CLIENT	JL	EQ				0	0
14	BBPD_PD_INDEX	CLIENT	JR	EQ			AND	0	0
15	BUT000	PARTNER	JL	EQ				0	0
16	BBPD_PD_INDEX	VENDOR_ID	JR	EQ			AND	0	0
17	BBPD_PD_INDEX	OBJECT_TYPE		EQ	'BUS2000136'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	BBPD_PD_INDEX	CLIENT		☐	MANDT	☐	Client
2	CTR_HDR_GUID	CRMD_ORDERADM_H	GUID		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
3	CTR_HDR_NUMBER	BBPD_PD_INDEX	CTR_HDR_NUMBER		☐	CRMT_OBJECT_ID	☐	Transaction ID
4	PRODUCT	CRMD_ORDERADM_I	PRODUCT		☐	CRMT_PRODUCT_GUID_DB	☐	Internal Unique ID of Product
5	CATEGORY	BBP_PDIGP	CATEGORY		☐	BBP_CATEGORY_GUID_RAW	☐	Product Category GUID
6	CATEGORY_ID	BBPD_PD_INDEX	CATEGORY_ID		☐	BBP_CATEGORY_ID	☐	Product Category ID
7	ORDERED_PROD	BBPD_PD_INDEX	ORDERED_PROD		☐	CRMT_ORDERED_PROD	☐	Product Name Entered
8	PROC_ORG	BBPD_PD_INDEX	PROC_ORG		☐	BBP_PROC_ORG	☐	Responsible Purchasing Organization
9	VENDOR_ID	BBPD_PD_INDEX	VENDOR_ID		☐	BU_PARTNER	☐	Business Partner Number
10	VENDOR_NAME	BUT000	MC_NAME1		☐	BU_MCNAME1	☐	Search Help Field 1 (Name 1/Last Name)
11	COMPANY_ID	BBPD_PD_INDEX	COMPANY_ID		☐	BU_PARTNER	☐	Business Partner Number
12	HDR_DESCRIPTION	CRMD_ORDERADM_H	DESCRIPTION		☐	CRMT_PROCESS_DESCRIPTION	☐	Transaction Description
13	IS_CATEG_ITEM	BBPD_PD_INDEX	IS_CATEG_ITEM		☐	BBP_FLAG_CATEG_ITEM	☐	Item is Product Category Item

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	350