Live Auction history information

Purpose

This post explaines where the entered information are stored in the Live Auction system. 

Overview

This should be an executive summary of the bidding history data in SRM Live Auction. Here you will find information how to create an activity log and how to get an activity log in SRM. 

Bid History and Charts

The Bid History and Charts are stored in SAP SRM system even after the auction has ended. The Live Auction cockpit remains accessible until the auction is completed or archived.
All the information except the system messages remain accessible in the cockpit after the auction has ended. 

Read information from tables

BBPD_LA_ACTIVITY - User activities log

Get the user activities log with AUCTION_GUID. 

BBPD_LA_BIDHIST - Bid history

Get the whole bid history data with AUC_GUID or filter the history for items with AUC_ITEM_GUID. 

BBPD_LA_CHAT - Chat messages

Get the chat messages from table BBPD_LA_CHAT by filtering with AUC_GUID 

BBPD_LA_LASTBID - Auction last (best) bid

Get the last bid from the auction by entering the AUC_ITM_GUID or AUC_GUID. 

BBPD_LA_MESSAGE - Message

Get the system message like Pause, Extend, etc. by entering the GUID. 

BBPD_LA_PALASTB - Bidders' best bid

Get the bidders best bid by entering the AUC_GUID or AUC_ITEM_GUID and PARTNER_GUID. 

Create an activity log

Create an activity log with function module BBP_LA_ACTIVITY_LOG_CREATE 

The imported values are:

• VALUE(I_AUC_GUID) TYPE BBP_GUID
• VALUE(I_SUBJECT_PARTNER_GUID) TYPE BBP_GUID
• VALUE(I_OBJECT_PARTNER_GUID) TYPE BBP_GUID OPTIONAL
• VALUE(I_ACTIVITY) TYPE BBPD_LA_ACTIVITY-ACTIVITY

Import parameter I_ACTIVITY

You must only use values taken from the constant include BBP_LA_ACTIVITY_CON 

This is how data are stored in table BBPD_LA_ACTIVITY

SUB_PARTNER_GUID	OBJ_PARTNER_GUID	ACTIVITY
The user who logon		Logon (1)
The user who logout		Logout (2)
Purchaser who do the ban	Bidder who is banned	Ban (3)
Purchaser who reinstate	Bidder who is reinstated	Reinstate (4)
Purchaser who surrogate logon	Bidder whom the purchaser logon as	Surrogate logon(5)
The user who gets		Timeout (6)
Purchaser who start auc		Start auction(7)
Purchaser who end auc		End auction(8)
Purchaser who pause auc		pause auction(9)
Purchaser who resume auc		resume auction(10)
Purchaser who extend auc		extend auction(11)

Get an activity log

Get an activity log with function module BBP_LA_ACTIVITY_LOG_GET 

The imported values are:

• VALUE(I_AUCTION_GUID) TYPE BBP_GUID OPTIONAL
• VALUE(I_PARTNER_GUID) TYPE BBP_GUID OPTIONAL
• VALUE(I_ACTION) TYPE BBPD_LA_ACTIVITY-ACTIVITY OPTIONAL
• VALUE(I_FROM) TYPE BBPTIMEST_PI OPTIONAL
• VALUE(I_TO) TYPE BBPTIMEST_PI OPTIONAL

The imported structure is:

• ET_ACTIVITIES STRUCTURE BBPS_LA_ACTIVITY

The information are stored in these tables:

Table name	Short description
BBPD_LA_ACTIVITY	User activities log
BBPD_LA_AUCPROFL	Auction profiles
BBPD_LA_AUCPROMP	Map auction profile details to auction
BBPD_LA_BIDHIST	Bid history
BBPD_LA_CHAT	Chat
BBPD_LA_CLTOBJ	Client and auction relationship
BBPD_LA_CLTSTAT	Client status
BBPD_LA_LASTBID	Auction last (best) bid
BBPD_LA_MESSAGE	Message
BBPD_LA_PALASTB	Bidders' best bid
BBPD_LA_PARTNERB	Best bid per bidder and auction item
BBPD_LA_PROFILE	Auction profile
BBPD_LA_PROP_KEY	Properties management: TEXT table
BBPD_LA_PROP_KY2	Properties management: properties key and description
BBPD_LA_PROP_TXT	Properties management: properties key and description
BBPD_LA_PROP_VAL	Properties management: properties value
BBPD_LA_PROXYBID	Proxy bid status

Table name	Short description
BBPV_LA_AUCPROFL	Maintenance of profile information for auctions
BBPV_LA_BID	View of bid history and partner's best bid ttables
BBPV_LA_CLTAUC	View of client status and client auction tables
BBPV_LA_PROP	Auction properties management
BBPV_LA_PROP_DB	Database view of properties key and value
BBPV_LA_PROP_KY2	Maintenance view for bbpd_la_ky2