SAP ABAP Table BBPS_SOS_FIND (Search Criteria for Sourcing)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	BBPS_SOS_FIND	Table Relationship Diagram
Short Description	Search Criteria for Sourcing

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	POS_ID	☐	BBP_GUID	SYSUUID	RAW	16	0	Globally Unique identifier
2	PRODUCT	☐	BBP_PRODUCT	SYSUUID	RAW	16	0	Product GUID
3	ORDERED_PROD	☐	BBP_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
4	PRODUCT_TYPE	☐	BBP_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
5	PARTNER_PROD	☐	BBP_PARTNER_PROD	PRSHTEXT40	CHAR	40	0	Product Number of Vendor
6	CATALOGID	☐	CATALOG	KATALOGID	CHAR	20	0	Catalog ID from which the line was selected	*
7	CATALOGITEM	☐	CATALOGITEM	CATALOGITEM	CHAR	40	0	Catalog Item (Unique Key)
8	CATEGORY	☐	BBP_CATEGORY_GUID_RAW	SYSUUID	RAW	16	0	Product Category GUID
9	CATEGORY_ID	☐	BBP_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Product Category ID
10	SCHEMA_TYPE	☐	SCHEMA_TYPE	COM_SCHEMA_TYPE	CHAR	10	0	Standard Schema Type	*
11	CT_CATEGORY_ID	☐	BBP_CT_CATEGORY_ID	CHAR60	CHAR	60	0	Category Name
12	QUANTITY	☐	BBP_MNG	MENG13	QUAN	13	3	Quantity in Order Unit
13	UNIT	☐	BBP_UNIT	MEINS	UNIT	3	0	Purchase Order Unit	*
14	SEARCH_DATE	☐	BBP_SEARCH_DATE	DATS	DATS	8	0	Date for Sourcing and Pricing
15	GROSS_PRICE	☐	BBP_GROSS_PRICE	WERT7	CURR	13	2	Gross Price
16	PRICE_UNIT	☐	EPEIN	DEC5	DEC	5	0	Price unit
17	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
18	PROC_ORG	☐	BBP_PROC_ORG	HROBJEC_14	CHAR	14	0	Responsible Purchasing Organization
19	VENDOR_GUID	☐	BBP_VENDOR	SYSUUID	RAW	16	0	Vendor GUID
20	VENDOR_ID	☐	BBP_VENDOR_ID	BU_PARTNER	CHAR	10	0	Vendor ID	*
21	LOCATION_GUID	☐	CRMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
22	LOCATION_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
23	RECIPIENT_GUID	☐	CRMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
24	RECIPIENT_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
25	COMPANY_GUID	☐	CRMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
26	COMPANY_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
27	CTR_HDR_GUID	☐	BBP_CTR_H_GUID	SYSUUID	RAW	16	0	GUID Contract
28	CTR_HDR_NUMBER	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
29	CTR_ITEM_GUID	☐	BBP_CTR_I_GUID	SYSUUID	RAW	16	0	Contract Template Item GUID
30	CTR_ITEM_NUMBER	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
31	CTR_LOG_SYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
32	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BBPS_SOS_FIND	ICC_BR_CFOP	COMC_CFOP_CODE	CFOP_CODE	KEY	1	CN
2	BBPS_SOS_FIND	ICC_BR_ICMSLAW	COMC_TAX_LAW_1	TAX_LAW	KEY	1	CN
3	BBPS_SOS_FIND	ICC_BR_IPILAW	COMC_TAX_LAW_2	TAX_LAW	KEY	1	CN
4	BBPS_SOS_FIND	ICC_BR_STEUC	CRMC_TAX_TCODE	TAX_TARIFF_CODE

History

Last changed by/on	SAP	20110908
SAP Release Created in	350