SAP ABAP Table BBPS_BID_UI_ITEM (Item Structure Bid Invitation)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ BBP_BID (Package) BBP Bid Invitation Cockpit

Basic Data

Table Category	INTTAB	Structure
Structure	BBPS_BID_UI_ITEM	Table Relationship Diagram
Short Description	Item Structure Bid Invitation

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	GUID	☐	BBP_GUID	SYSUUID	RAW	16	0	Globally Unique identifier
2	PARENT	☐	BBP_PGUID	SYSUUID	RAW	16	0	Parent GUID
3	HEADER	☐	BBP_GUID	SYSUUID	RAW	16	0	Globally Unique identifier
4	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
5	NUMBER_INT	☐	BBP_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item number
6	NUMBER_EXT	☐	BBP_ITEM_NO_EXT		NUMC	10	0	External Item Number
7	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
8	PRODUCT	☐	BBP_PRODUCT	SYSUUID	RAW	16	0	Product GUID
9	DESCRIPTION	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
10	CATEGORY	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
11	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
12	SCHEMA_TYPE	☐	SCHEMA_TYPE	COM_SCHEMA_TYPE	CHAR	10	0	Standard Schema Type	*
13	CT_CATEGORY_ID	☐	BBP_CT_CATEGORY_ID	CHAR60	CHAR	60	0	Category Name
14	ITM_EX_CT_UN_ID	☐	BBP_ITM_EX_CT_UN_ID	CHAR40	CHAR	40	0	Unique Key in External Category
15	MANU_PROD	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
16	MFR_NO_EXT	☐	EMNFR	CHAR10	CHAR	10	0	External manufacturer code name or number
17	CATALOGID	☐	CATALOG	KATALOGID	CHAR	20	0	Catalog ID from which the line was selected	*
18	CATALOGITEM	☐	CATALOGITEM	CATALOGITEM	CHAR	40	0	Catalog Item (Unique Key)
19	EXT_QUOTE_ID	☐	BBP_EXT_QUOTE_ID		CHAR	35	0	Number of External Bid
20	EXT_QUOTE_ITEM	☐	BBP_EXT_QUOTE_ITEM		NUMC	10	0	Item for an External Bid
21	SRC_QUANTITY	☐	BBP_MNG	MENG13	QUAN	13	3	Quantity in Order Unit
22	QUANTITY	☐	BBP_MNG	MENG13	QUAN	13	3	Quantity in Order Unit
23	UNIT	☐	BBP_UNIT	MEINS	UNIT	3	0	Purchase Order Unit	*
24	DEL_IND	☐	BBP_DEL_IND	XFELD	CHAR	1	0	Deletion Indicator EBP Purchasing Document
25	DEDUCT_IND	☐	BBP_DEDUCT_IND	XFELD	CHAR	1	0	Discount/Rejection Indicator at Item Level
26	ORDERED_PROD	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
27	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
28	PRODUCT_SRC_SYS	☐	BBP_LOGSYS	CHAR10	CHAR	10	0	Business Document Service: ID of Logical System
29	PRICE	☐	BBP_PRICE	WERT7	CURR	13	2	Net Price
30	PRICE_UNIT	☐	EPEIN	DEC5	DEC	5	0	Price unit
31	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
32	SUBTYPE	☐	BBP_I_SUBTYPE	BBP_I_SUBTYPE	CHAR	2	0	Specification Purchase Item (e.g. Direct Material/Hierarch.)
33	DEL_DATCAT	☐	LPEIN_INT	PRGRS	CHAR	1	0	Date type (day, week, month, interval)
34	DELIV_DATE	☐	EINDT	DATUM	DATS	8	0	Item delivery date
35	DELIV_TIME	☐	BBP_DELIV_TIME	TIME	TIMS	6	0	Delivery Time of the Item
36	EXT_DEMID	☐	BBP_EXT_DEMID	CHAR32	CHAR	32	0	External Requirement Tracking Number
37	EXT_DEM_POSID	☐	BBP_EXT_DEM_POSID	CHAR32	CHAR	32	0	External Requirement Tracking Number
38	DP_STGE_LOC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location
39	SRC_OBJECT_TYPE	☐	BBP_SRC_I_OBJ_TYP	OJ_NAME	CHAR	10	0	Object Type of Reference Item	*
40	SRC_GUID	☐	BBP_SRC_I_GUID	SYSUUID	RAW	16	0	Reference Item GUID
41	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
42	PRICE_NO_CHANGE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
43	UNIT_DESC	☐	BBP_UNIT_DESC	CHAR40	CHAR	40	0	Description of Unit of Measurement
44	CATEGORY_DESC	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
45	VALUE	☐	BBP_VALUE	WERT8	CURR	15	2	Net Value
46	EXTERNAL_RANK	☐	BBP_EXTERNAL_RANK	INT4	INT4	10	0	Ranking of Bid in External Auction
47	EXTERNAL_SCORE	☐	BBP_EXTERNAL_SCORE	BBP_EXTERNAL_SCORE	DEC	7	2	Valuation of Bid in External Auction
48	START_PRICE	☐	BBP_START_PRICE	WERT7	CURR	13	2	Auction Start Price
49	RESERVED_PRICE	☐	BBP_RESERVE_PRICE	WERT7	CURR	13	2	Reserve Price of an Auction
50	BID_DECR_AMOUNT	☐	BBP_DECREMENT_AMOUNT	WERT7	CURR	13	2	Absolute Bid Decrement
51	BID_DECR_PERCENT	☐	BBP_DECREMENT_PERCENT	BBP_PERCNT	DEC	5	2	Percentage Bid Decrement
52	INCOTERM_KEY	☐	BBP_INCOTERM_KEY	BBP_INCOTERM_KEY	CHAR	3	0	Incoterm Key	*
53	INCOTERM_LOC	☐	BBP_INCOTERM_LOCATION	BBP_INCOTERM_LOCATION	CHAR	28	0	Incoterm Location
54	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BBPS_BID_UI_ITEM	CATALOGID	BBP_CAT_ENTITY	CATALOGID
2	BBPS_BID_UI_ITEM	ICC_BR_CFOP	COMC_CFOP_CODE	CFOP_CODE	KEY	1	CN
3	BBPS_BID_UI_ITEM	ICC_BR_ICMSLAW	COMC_TAX_LAW_1	TAX_LAW	KEY	1	CN
4	BBPS_BID_UI_ITEM	ICC_BR_IPILAW	COMC_TAX_LAW_2	TAX_LAW	KEY	1	CN
5	BBPS_BID_UI_ITEM	ICC_BR_STEUC	CRMC_TAX_TCODE	TAX_TARIFF_CODE
6	BBPS_BID_UI_ITEM	PS_TAX_CODE	BBP_TAX	TAX_CODE	KEY

History

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