Child pages
  • SRM BIDDING INVITATION Info-source, Info-cube,ODS,Queries
Skip to end of metadata
Go to start of metadata

Datacsource 

Technical name

Type of DataSource

Use

Delta Update

Features of Extractor

Bid Invitations

0BBP_TD_BID_1

Transactional data (movement data)

This DataSource provides information on bid invitations on header and item level. This pertains to the bidder registration deadline, type of bid invitation, and bid invitation items, for example.

The DataSource supports the delta update method 'AIMD' (after images with deletion indicator via delta queue).

The extraction of a bid invitation document is structured in such a way that the relevant characteristic and key figure information is extracted into a data record for header and item level.

Invited Bidders

0SRM_TD_BIDDER

Transaction data (movement data)

This DataSource provides information on the bidders invited to participate in a bid invitation.

The DataSource supports the delta update method AIMD (after images with deletion indicator via delta queue).

 

Bids

0BBP_TD_QUOT_1

Transaction data (movement data)

This DataSource provides information on bids on header and item level. This pertains to bidders and bid invitations, for example.

The DataSource supports the delta update method 'AIMD' (after images with deletion indicator via delta queue).

The extraction of a bid document is structured in such a way that the relevant characteristic and key figure information is extracted into a data record for header and item level.

Texts: Bid Invitation Type

0BBP_BIDTYP_TEXT

Texts (master data)

You use this DataSource to extract the texts for the bid invitation types.

None

 

Attributes: Bidder

0BBP_BIDDER_ATTR

Attributes (master data

You use this DataSource to extract the relevant attributes that were entered in your Enterprise Buyer system for a bidder.

None

 

Hierarchy Extractor for Bid Invitations

0BBP_BIGURE_HIER

Hierarchies

To represent complex bid invitations during creation of bid invitations in Enterprise Buyer, hierarchies are used with header, item, and levels.  These hierarchies are created during creation of the individual bid invitations and vary from bid invitation to bid invitation. The job of the extractor is to select hierarchies with texts and to make them available for the BW system.

At the present time, a delta update for hierarchies is not provided in the standard system. Since we are dealing here with hierarchies for transaction data (bid invitations), the possibility of data update has been incorporated for 0BBP_BIGURE with SP04. Prior to SP04 you can only carry out a full update in the hierarchy ALL. From SP04, for a delta update in the BW system, you select the InfoPackage and then the hierarchies with the technical names NEW and CHANGE on the Hierarchy Selection tab. (See also Features of the Extractor, explained below.)  The table bbp_bw_timestamp is used in Enterprise Buyer. This is delivered to the customer empty. A timestamp is entered in this table when an upload is started for the first time. A subsequent delta upload then only selects bid invitations that were created or changed since the timestamp (change date query). This table is not used for a full upload. The hierarchy is indicated as time dependent. However, in the BW system you can enter a selection date on the Update tab via the InfoPackage. This is particularly useful if you want to upload a large number of bid invitation hierarchies, or if you only want to upload bid invitations for a particular timeframe. In the case of a delta upload, the date fields on BW side (Update tab) are not considered. The execution of the extractor checker (RSA3) in the Enterprise Buyer system does not change the bbp_bw_timestamp table.

If no data is selected during an upload (for example, no bid invitations have been created or changed since the last run) the exception Hierarchy_Tab_Not_found is triggered and an appropriate message is output in the BW monitor. The table bbp_bw_timestamp is not updated in this case and the delta upload can be repeated. Bid invitations that do not contain items or hierarchy levels are not transferred to BW. The same is true of bid invitation items where the field crmd_orderadm_h- NUMBER_INT (item number) is not filled. This extractor should always be executed AFTER extraction of the actual bid invitations, and not before. If you create an InfoPackage for this extractor on BW side, you need to note the following:If you load the hierarchy with the technical name NEW, you need to select the update method Insert Subtree. Furthermore, after loading, you need to rename the hierarchy as ALL. In this way, newly created bid invitations are loaded from Enterprise Buyer.If you load the hierarchy with the technical name CHANGE, you need to select the update method Update Subtree. Furthermore, after loading, you need to rename the hierarchy as ALL. In this way, documents that were already loaded but then changed again in Enterprise Buyer are loaded again.If you have loaded both the NEW hierarchy and the CHANGE hierarchy, this should mean that you have loaded all hierarchy data available in the source system. You have then performed a delta loading for hierarchies. If you need to repeat the full update with subsequent NEW and CHANGE runs, remember that you have to:
Delete the hierarchy data on BW side (to avoid loading the data in duplicate)
Reset the timestamp in the table bbp_bw_timestamp in Enterprise Buyer (delete data records in bbp_bw_timestamp) To do this, you can use the standard functions of transaction SE16.









Bids - Dynamic Attributes

0SRM_QUOT_ATTR_1

Transaction data (movement data)

The DataSource serves to update the bid data for the dynamic attributes and customer fields as well as price, quantity, and value of the bid item to the ODS object 0SR_QUODA (bid attributes).

The delta method is AIMD: After images with deletion indicator using delta queue.

 

Text Extractor for Dynamic Attributes of Bid

0SRM_QUOT_ATTR_TEXT

Texts (master data)

This DataSource is used to extract the texts for the attributes of the bid 0SR_QUOATTR in BW. From SRM 3.0 there is an extended model for the dynamic attributes. In this model, the text extractor is no longer used. For compatibility reasons it is still available, though, to connect SRM systems older than 3.0.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Info source 

Technical Name

Use

Invited Bidders

0BBP_BIDDER_TD

This InfoSource provides information on the bidders invited to participate in a bid invitation. Choose Communication Structure to view the fields of the InfoSource.

Bid Invitation - Single Documents

0BBP_BID_TD_1

This InfoSource provides bid invitation data on header and item level. The document item is the most detailed level of information. Attributes that might still belong to the bid invitation item are not supplied with this InfoSource but with the InfoSource 0SRM_QUOT_ATTR_1.  Choose Communication Structure to view the fields of the InfoSource.

Bids - Single Documents

0BBP_QUO_TD_1

This InfoSource provides bid data on header and item level. The document item is the most detailed level of information. Attributes that might still belong to the bid item are not supplied with this InfoSource but with the InfoSource 0SRM_QUOT_ATTR_1. Choose Communication Structure to view the fields of the InfoSource.

Bid Attributes

0SRM_QUOT_ATTR_1

The Infosource 0SRM_QUOT_ATTR_1 updates the movement data of a bid. It contains information on th aattributes of the bid, the customer fields, and the price, quantity, and the value of the bid item. This information is extracted as name value pair and updated in ODS 0SR_QUODA (Bid Attributes). Choose Communication Structure to view the fields of the InfoSource.

Bid Attribute - Texts

0SR_QUOATTR

he Infosource 0SR_QUOATTR updates the descriptive texts for an attribute of a bid. Choose Communication Structure to view the fields of the InfoSource. From SRM 3.0 there is an extended model for the dynamic attributes. In this model, the text extractor is no longer used. For compatibility reasons it is still available, though, to connect SRM systems older than 3.0.

 

 

 

 

 

 

ODS Object

Technical Name

Use

Delta Update

Invited Bidders

0SR_BIDO1

This ODS object contains the bidders that were invited to take part in a bid invitation. It also contains information on whether a bidder submitted a bid. You can use it to calculate how often a bidder was invited and whether the bidder submitted a bid. This information is particularly useful for the selection of bidders for a bid invitation.

The delta update occurs via the AIMD (After-Images with deletion indicator via delta queue) procedure entered in the DataSource.

Bid Invitation - Single Documents

0BBP_BID

This ODS object contains information on header and item data from the bid invitation document area. In addition, information on the number of bids submitted for a bid invitation is updated from the bid. You can use this ODS object to carry out all detail evaluations of the bid invitation. In other words, you can find out how many items a bid invitation contains, how many invitations have been sent, and how many bids have already been received for a bid invitation.

The delta update occurs via the AIMD (After-Images with deletion indicator via delta queue) procedure entered in the DataSource.

Bids - Single Documents

0BBP_QUO

This ODS object contains information on header and item data of the bids for bid invitations. Quantities, prices, and requested delivery dates are saved, but customer fields are not. Only those prices that are entered are stored, and no detailed price information (scales, conditions) are considered.

The delta update occurs via the AIMD (After-Images with deletion indicator via delta queue) procedure entered in the DataSource.

Bid Attributes

0SR_QUODA

This ODS object contains bid data based on customer fields and attributes of the bid or the bid invitation. Price, quantity, and value data of the bid item is also updated.

The delta update occurs using the AIMD (after images with deletion indicator using delta queue) process defined in the DataSource.

Bid Invitations and Bids  INFO CUBE 

0SR_BIDC1

This InfoCube contains information on bid invitations and bids. You can use the InfoCube to see how many bid invitations/bid invitation items and how many bids/bid items have been added. You can analyze to what extent bidders have participated in bid invitations and display the product categories for which they have submitted bids. The InfoCube also contains the number of invitations per bidder.

Bitmap

 

 

 

 

Queries 

Technical Name

Use

Analysis of Bid Invitations 

0BBP_BID_Q001

This query provides an overview of all bid invitations with information on the number of submitted bids and the number of items. You can navigate from here and analyze a bid invitation down to item level or branch to a bid comparison.

Analysis of Bid Invitation Items

0BBP_BID_Q004

This query provides an analysis of bid invitation items.

Bidder analysis

0BBP_QUO_Q004

This query provides an overview of the individual bidders and the number of bids submitted

Price Comparison List

0BBP_QUO_Q003

This query provides an analysis of the bids submitted in response to a specific bid invitation. Here, the quantities, prices, and values of the respective bids are displayed per item. The query permits a bid comparison on price/quantity basis. It is important to note that no conditions are taken into account for the values. They are calculated with price * quantity.

Bid Comparison with Other Bid Invitations

0BBP_BID_Q006

This query more or less corresponds to 0BBP_BID_Q003 (Comparison of Bids Submitted) but supplies an analysis of bids for several bid invitations. You can use it to compare bids for several bid invitations. For example, you could compare a current bid invitation with a similar bid invitation from last year, to establish a trend.

Price Comparison for Several Bid Invitations

0BBP_QUO_Q007

This query more or less corresponds to 0BBP_QUO_Q003 (comparison of bids submitted) but supplies an analysis of bids for several bid invitations. It is useful in scenarios where a large bid invitation is split into several smaller bid invitations. You can use this query to analyze the bids of bidders quickly and easily. In addition to the key figures value, price, and quantity, the query contains a key figure that counts the items for which the bidder has submitted a bid. In this way, you can easily determine how many items a bidder has submitted a bid for, even in the case of large bid invitations with several thousand items

Number of Bids per Bidder

0SR_BIDC01_Q001

You can navigate to this evaluation that displays for a bid invitation all bidders and the number of their bids in previous years and the current year. Additionally, you can see which bids were successful. You can use this evaluation to determine the extent to which bidders participated in bid invitations and how successful they were. (You can also display data per purchasing organization or purchasing group.) From the query, you can navigate to the bids of a bidder that were accepted. The time restriction is transferred here.  The query always refers to only one bid invitation. It can be used to obtain more information on bidders during a bid comparison.

Bidders by Product Category

0SR_BIDC01_Q002

This evaluation shows (for one or more product category) the bidders that placed bids and whose bids were successful. From the query, you can navigate to the bids of a bidder that were accepted. The time restriction is transferred here.

Bid Invitation Information

0BBP_BID_Q005

This evaluation displays the most important master data information for a bid invitation header. It is used in Web templates with other queries in which further information is displayed for a bid invitation, for example all items of a bid invitation or all bids for a bid invitation.

Information for Several Bid Invitations

0BBP_BID_Q009

Like 0BBP_BID_Q005 (Bid Invitation Information), this evaluation shows the most important master data information for bid invitations. It is optimized for use with 0BBP_BID_Q007 (bid comparison with several bid invitations) in a Web template. The query displays the number of items of a bid invitation as well as the total number of items for all bid invitations represented. Used in conjunction with the bid comparison, you can determine the percentage of bid items to which a bidder reacted.

Bidders for Product Categories

0SR_BIDC01_Q004

This query determines the bidders for one or more product categories. The result can then be used in a variable with replacement path (0S_BDDRE).

Bid Invitations per Product Category

0SR_BIDC01_Q005

This query displays the number of bid invitations, the number of invitations sent for these bid invitations, and the response rate (percentage of bidders that replied to an invitation) for one or more selected product categories. The query is a strategic report that you can use to measure the success of bid invitations in certain product categories.

Invitations per Product Category of Bid Invitation

0SR_BIDC01_Q007

This query displays information on bidders who have participated in bid invitations for one or more selected product categories. For each bidder, this query displays the total number of bid invitations executed, the number of invitations sent to the bidder, and the response rate (how often a bidder reacted to an invitation). The query is intended to be displayed in conjunction with 0SR_BIDC01_Q002 (Bidders per Product Category) in a Web template. You can use both queries to help you select bidders to take part in a bid invitation.  Note that query 0SR_BIDC01_Q007 uses the product category entered in the bid invitation header. 0SR_BIDC01_Q002 uses the product category of the bid invitation item.

Bidders for a Bid Invitation

0BBP_QUO_Q002

This query determines all bidders for a bid invitation. The result can then be used in a variable with replacement path (0Q_BIDDE).

Bids of a Bidder in Detail

0BBP_QUO_Q001

This evaluation displays all bids that were accepted with the associated bid invitations. Price, quantity, and purchase value are displayed, though the purchase value does not take any conditions into consideration.

Bid Comparison of Attributes

0SR_QUODA_Q001

This query is used by the Web template 0TPL_SR_BID_ATTR_OF_BIDS (Bid Comparison of Attributes), representing the respective attributes and the submitted bids for the bid invitation items, as database.  This query is not intended for end users.

Attributes for a Bid Invitation

0SR_QUODA_Q002

This query displays all items for a freely definable bid invitation. The assigned attributes are also displayed for the items.