SAP ABAP Table BBPS_SOS_FIND_EXT (Structure for Sourcing from External Systems)

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_EXT	Table Relationship Diagram
Short Description	Structure for Sourcing from External Systems

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	.INCLUDE	☐				0	0	Search Criteria for Sourcing
2	POS_ID	☐	BBP_GUID	SYSUUID	RAW	16	0	Globally Unique identifier
3	PRODUCT	☐	BBP_PRODUCT	SYSUUID	RAW	16	0	Product GUID
4	ORDERED_PROD	☐	BBP_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
5	PRODUCT_TYPE	☐	BBP_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
6	PARTNER_PROD	☐	BBP_PARTNER_PROD	PRSHTEXT40	CHAR	40	0	Product Number of Vendor
7	CATALOGID	☐	CATALOG	KATALOGID	CHAR	20	0	Catalog ID from which the line was selected	*
8	CATALOGITEM	☐	CATALOGITEM	CATALOGITEM	CHAR	40	0	Catalog Item (Unique Key)
9	CATEGORY	☐	BBP_CATEGORY_GUID_RAW	SYSUUID	RAW	16	0	Product Category GUID
10	CATEGORY_ID	☐	BBP_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Product Category ID
11	SCHEMA_TYPE	☐	SCHEMA_TYPE	COM_SCHEMA_TYPE	CHAR	10	0	Standard Schema Type	*
12	CT_CATEGORY_ID	☐	BBP_CT_CATEGORY_ID	CHAR60	CHAR	60	0	Category Name
13	QUANTITY	☐	BBP_MNG	MENG13	QUAN	13	3	Quantity in Order Unit
14	UNIT	☐	BBP_UNIT	MEINS	UNIT	3	0	Purchase Order Unit	*
15	SEARCH_DATE	☐	BBP_SEARCH_DATE	DATS	DATS	8	0	Date for Sourcing and Pricing
16	GROSS_PRICE	☐	BBP_GROSS_PRICE	WERT7	CURR	13	2	Gross Price
17	PRICE_UNIT	☐	EPEIN	DEC5	DEC	5	0	Price unit
18	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
19	PROC_ORG	☐	BBP_PROC_ORG	HROBJEC_14	CHAR	14	0	Responsible Purchasing Organization
20	VENDOR_GUID	☐	BBP_VENDOR	SYSUUID	RAW	16	0	Vendor GUID
21	VENDOR_ID	☐	BBP_VENDOR_ID	BU_PARTNER	CHAR	10	0	Vendor ID	*
22	LOCATION_GUID	☐	CRMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
23	LOCATION_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
24	RECIPIENT_GUID	☐	CRMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
25	RECIPIENT_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
26	COMPANY_GUID	☐	CRMT_PARTNER_GUID	SYSUUID	RAW	16	0	GUID for an Individual Partner
27	COMPANY_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
28	CTR_HDR_GUID	☐	BBP_CTR_H_GUID	SYSUUID	RAW	16	0	GUID Contract
29	CTR_HDR_NUMBER	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
30	CTR_ITEM_GUID	☐	BBP_CTR_I_GUID	SYSUUID	RAW	16	0	Contract Template Item GUID
31	CTR_ITEM_NUMBER	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
32	CTR_LOG_SYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
33	.INCLUDE	☐				0	0
34	PRODUCT_GTIN	☐	COMT_GTIN	COM_GTIN	CHAR	40	0	Global Trade Item Number (GTIN)
35	MANU_PROD	☐	BBP_MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
36	MFR_NO_EXT	☐	EMNFR	CHAR10	CHAR	10	0	External manufacturer code name or number
37	UNIT_ISO	☐	BBP_UNIT_ISO	ISOCD_UNIT	CHAR	3	0	ISO Code for Unit of Measurement	*
38	CURRENCY_ISO	☐	BBP_ISOCD	ISOCD	CHAR	3	0	ISO Currency Code
39	CONTRACTS_ONLY	☐	XFELD	XFELD	CHAR	1	0	Checkbox

Foreign Keys

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

History

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