SAP ABAP Table BBPS_BI_TD_LA (Extraction Structure: Transactional Data SRM Purchase Order)

Hierarchy

☛ SRM_SERVER (Software Component) SRM_SERVER
   ⤷ SRM-BW (Application Component) SRM Analytics
     ⤷ BBP_BI (Package) Business Intelligence

Basic Data

Table Category	INTTAB	Structure
Structure	BBPS_BI_TD_LA	Table Relationship Diagram
Short Description	Extraction Structure: Transactional Data SRM Purchase Order

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_BI_DOC_GUID	SYSUUID_C	CHAR	32	0	GUID of Document
2	OBJECT_ID	☐	BBP_BI_DOC_NUMBER	CRM_OBJECT_ID	CHAR	10	0	Document Number
3	REQUESTOR_ID	☐	BBP_BI_REQUESTER_ID	BU_PARTNER	CHAR	10	0	Requester ID	*
4	PROCESS_TYPE	☐	BBP_BI_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
5	POSTING_DATE	☐	BBP_BI_POST_DATE	DATE	DATS	8	0	Posting Date
6	DESCRIPTION	☐	BBP_BI_DOC_DESCR	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Description of Document
7	START_DATE	☐	BBP_BI_START_DATE		DATS	8	0	Start Date of an Auction
8	START_TIME	☐	BBP_BI_START_TIME	TIME	TIMS	6	0	Start Time of an Auction
9	END_DATE	☐	BBP_BI_END_DATE		DATS	8	0	End Date of an Auction
10	END_TIME	☐	BBP_BI_END_TIME	TIME	TIMS	6	0	End Time of an Auction
11	CREATED_AT	☐	BBP_BI_CREAT_DATE		DATS	8	0	Creation Date of Document
12	CHANGED_AT	☐	BBP_BI_CHANG_DATE		DATS	8	0	Change Date of Document
13	CREATED_BY	☐	BBP_BI_CREAT_BY	UNAME	CHAR	12	0	User That Created the Document
14	CHANGED_BY	☐	BBP_BI_CHANG_BY	UNAME	CHAR	12	0	User That Changed the Document
15	CURRENCY	☐	BBP_BI_DOC_CURRENCY	WAERS	CUKY	5	0	Currency of Document	*
16	DOC_COUNT	☐	BBP_BI_DOC_COUNT		DEC	5	4	Counter for Number of Documents
17	CAT_GUID	☐	BBP_CATEGORY_GUID_RAW	SYSUUID	RAW	16	0	Product Category GUID
18	CATEGORY_ID	☐	BBP_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Product Category ID
19	ACTUAL_EXTENSION	☐	BBP_EXT_CURRENT	INT4	INT4	10	0	Current Number of Extensions to an Auction
20	BIDDER_ID	☐	BBP_BI_BIDDER_ID	BU_PARTNER	CHAR	10	0	Bidder ID	*
21	ITM_GUID	☐	BBP_BI_ITEM_GUID	SYSUUID_C	CHAR	32	0	GUID of Item
22	ITM_NUMBER	☐	BBP_BI_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number
23	ITM_COUNT	☐	BBP_BI_ITEM_COUNT		DEC	5	4	Counter for Number of Items
24	ITM_BID_COUNT	☐	BBP_BI_BID_COUNT		DEC	5	4	Counter for Bid
25	ITM_WINNER_COUNT	☐	BBP_BI_WIN_COUNT		DEC	5	4	Counter for Wins
26	ITM_INVITE_COUNT	☐	BBP_BI_INVITE_COUNT		DEC	5	4	Counter for Invitation
27	ITM_CREATED_AT	☐	BBP_BI_ITEM_CREAT_DATE		DATS	8	0	Creation Date of Item
28	ITM_CHANGED_AT	☐	BBP_BI_ITEM_CHANG_DATE		DATS	8	0	Change Date of Item
29	ITM_CREATED_BY	☐	BBP_BI_ITEM_CREAT_BY	UNAME	CHAR	12	0	User That Created the Item
30	ITM_CHANGED_BY	☐	BBP_BI_ITEM_CHANG_BY	UNAME	CHAR	12	0	User That Changed the Item
31	ITM_PRODUCT_GUID	☐	BBP_BI_PROD_GUID	SYSUUID_C	CHAR	32	0	Product GUID
32	ITM_PRODUCT_ID	☐	BBP_BI_PROD_ID	CRM_ORDERED_PROD	CHAR	54	0	Product ID
33	ITM_DESCRIPTION	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
34	ITM_CAT_GUID	☐	BBP_CATEGORY_GUID_RAW	SYSUUID	RAW	16	0	Product Category GUID
35	ITM_CATEGORY_ID	☐	BBP_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Product Category ID
36	ITM_QUANTITY	☐	BBP_MNG	MENG13	QUAN	13	3	Quantity in Order Unit
37	ITM_UNIT	☐	BBP_UNIT	MEINS	UNIT	3	0	Purchase Order Unit	*
38	ITM_BID_PRICE	☐	BBP_BI_BID_PRICE	WERT7	CURR	13	2	Bid Price in Auction Currency
39	ITM_NORM_PRICE	☐	BBP_BI_NORM_PRICE	WERT7	CURR	13	2	Normalized Bid Price
40	ITM_START_PRICE	☐	BBP_START_PRICE	WERT7	CURR	13	2	Auction Start Price
41	ITM_RES_PRICE	☐	BBP_RESERVE_PRICE	WERT7	CURR	13	2	Reserve Price of an Auction
42	ITM_REF_PRICE	☐	BBP_REF_PRICE	WERT7	CURR	13	2	Reference Price of an Item in Auctions
43	ITM_PRICE_UNIT	☐	EPEIN	DEC5	DEC	5	0	Price unit
44	ITM_BIDDER_RANK	☐	BBP_EXTERNAL_RANK	INT4	INT4	10	0	Ranking of Bid in External Auction
45	UPDMOD	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
46	ITM_REV_LEV	☐	CC_REVLV	CC_REVLV	CHAR	2	0	Revision Level

History

Last changed by/on	SAP	20110913
SAP Release Created in	550