Child pages
  • Live Auction history information
Skip to end of metadata
Go to start of metadata

Purpose

This page explains where the entered information in 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

ACTIVITY AND NUMBER

Logon activity of a given user

Logon (1)

Logout activity of a given user

Logout (2)

The purchaser user is banning a given bidder user

Ban (3)

The purchaser user is re-instating (allowing access back into the auction for) a given bidder user

Re-instate (4)

The purchaser user is performing the surrogate logon in the name if a given bidder user (Logon as functionality)

Surrogate logon (5)

The user who gets a timeout message in auction

Timeout (6)

The purchaser user starts the auction

Start auction (7)

The system ends the auction (end time is reached)

End auction (8)

Purchaser activity about pausing an auction

Pause auction (9)

Purchaser activity about resuming an auction

Resume auction (10)

Purchaser activity about extending an auction

Extend auction (11)

Schedules a system background job when the auction startsSchedule a start auction job (50)
Schedules a system background job when the auction endsSchedule a close auction job (51)
Schedules a system background job when the auction startsSchedule a start auction job (60)
Schedules a system background job when the auction endsSchedule a close auction job (61)
System activity for checking the status of the auction. It will also be generated after the auction has ended but the auction window was still open for a given user.Auction activity change (87)
Bid submission lock activity - Submission fails (Not used any more)Submit fails (96)
Bid submission lock activity - Bid rejected (Not used any more)Bid rejected (97)
Bid submission lock activity - Bid accepted (Not used any more)Bid accepted (98)
Bid submission lock activity - Bid submitted (Not used any more)Submit bid (99)

View an activity log

If you would like to view an activity log of an auction in SAP SRM you can use program BBP_LA_ANALYZE_ACTIVITY_LOG with SE38 transaction. This report can be used after the auction has ended.

You will have to enter the AUC_GUID in the Auction Guid (optional) field and press Execute (F8).

The output is displayed on the next outcome screen. With the help of the above BBPD_LA_ACTIVITY table you can find out the actions that were performed in the system.

The timestamps in program BBP_LA_ANALYZE_ACTIVITY_LOG are displayed according the time zone settings of that given logged on user in SAP SRM.

More information are stored in the following 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 tables

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

Related Content

Related Documents

Live Auction tables structures classes function groups and function modules