SAPTechno

Note 614940 - DataSources for the Enterprise Buyer and SRM Server

Header
Version / Date 9 / 2005-05-13
Priority Recommendations/additional info
Category Consulting
Primary Component SRM-BW-EBP Analytics Enterprise Buyer
Secondary Components BW-BCT-BBP Business-to-Business Procurement,SRM-BW SRM Analytics,SRM-BW-SUS Analytics Supplier Self-Services,SRM-BW-VE Vendor Evaluation in BW

Summary
Symptom

This note provides an explanation of the DataSources that need to be activated in SRM and in the SRM components, such as the Enterprise Buyer, to ensure the full reporting functions on SRM data in BW.

Other terms

Enterprise Buyer Professional, SRM, Supplier Relationship Analytics, DataSources, SRM Server, Supplier Self Service, Contract Management, Vendor Evaluation, Bidding Engine, Live Auction Cockpit

Reason and Prerequisites

Prerequisite: You have installed the SRM server and you have allowed repository changes and cross-client changes by setting the system to changeable in Table T000 using Transaction SM30.

Solution

This note lists the DataSources you need to activate in Enterprise Buyer or SRM Server if you want to support the reporting in the BW system.

The note also lists the analyses or processes which the DataSources support. For example, if you do not use contracts in the EBP, you do not need to activate the DataSource which transfers contract data from the EBP to the BW system because it does not contain any data. However, there is no harm in activating more DataSources than required. The additional DataSources can be used for purely informational purposes.

The note is arranged according to SRM releases and contains references to components such as Enterprise Buyer and SRM Server Releases.

SRM 5.0   (with SRM Server 5.5):

Master data:
Product
0PRODUCT_ATTR
0PRODUCT_HIER
0PRODUCT_TEXT
0PROD_CATEG_ATTR
0PROD_CATEG_HIER
0PROD_CATEG_TEXT
0PR_PURCHASE_CATEG_ATTR
0PR_STATUS_ATTR
0PR_TYPE_TEXT
0PR_CATEGORIES_ATTR
0PROD_CATEG_R3_MAP_ATTR

Business partner:
0BPARTNER_ATTR
0BPARTNER_HIER
0SRM_SUPPLIER_HIER
0BPARTNER_TEXT
0BPTYPE_TEXT
0BP_ID_ATTR
0BP_ID_TYPE_TEXT
0BP_IND_CODE_TEXT
0BP_IND_SECTOR_ATTR
0BP_IS_ATTR
0BP_ROLES_ATTR
0BP_ROLE_TEXT
0LEGALFORM_TEXT

All master data you find in application component 0SRM_IO:
0ACCOUNTING_TYPE_ATTR
0BBP_ACCCAT_TEXT
0BBP_BIDDER_ATTR
0BBP_BIDTYP_TEXT
0BBP_BPART_BUYID_ATTR
0BBP_BPCOMPANY_ATTR
0BBP_BPVEND_ATTR
0BBP_BUYID_ATTR
0BBP_BUYID_TEXT
0BBP_CAT_ID_TEXT
0BBP_FLAG_TEXT
0BBP_H_SUBTYPE_TEXT
0BBP_INPTYP_TEXT
0BBP_I_SUBTYPE_TEXT
0BBP_MAT_PR_ATTR
0BBP_ORGUNIT_ATTR
0BBP_ORGUNIT_HR01_HIER
0BBP_ORGUNIT_TEXT
0BBP_ORIGIN_TEXT
0BBP_PARTNER_FLAG_CONTACT
0BBP_PARTNER_FLAG_LOCATION
0BBP_PARTNER_FLAG_VENDOR
0BBP_PC_INS_TEXT
0BBP_PLANT_LOCMAP_ATTR
0BBP_PRODUCT_ATTR
0BBP_PR_MAT_ATTR
0BBP_PURCH_ORG_ATTR
0BBP_PUR_GROUP_ATTR
0BBP_REJCON_TEXT
0BBP_REJINV_TEXT
0BBP_STATUS_TEXT
0BBP_TAXCOD_TEXT
0PROCTYPE_TEXT
0SRM_GLS_VENMAP

SRM Server transaction data:
0SRM_TD_PO        replaces 0BBP_TD_PO_1
0SRM_TD_PO_ACC    also replaces 0BBP_TD_PO_1
0SRM_TD_IV        replaces 0BBP_TD_INV_1
0SRM_TD_CF        replaces 0BBP_TD_CONF_1
0BBP_TD_SC_1
0BBP_TD_SC_APPR_1

Supplier Self Services authorization data:
0SRM_SUS_AUTH_2

Transaction data if you use contract management in SRM:
0BBP_TD_CONTR_2
0SRM_REL_CT
0SRM_CTR_HIER

DataSources for the Bidding Engine:
0BBP_BIGURE_HIER
0BBP_TD_BID_1
0BBP_TD_QUOT_1
0SRM_TD_LA           -> for auctions
0SRM_QUOT_ATTR_1
0SRM_TD_BIDDER
0SRM_QUOT_ATTR_TEXT

Only if you use the vendor evaluation in SRM in addition: Activate the DataSources in SRM. Before you start, read the Configuration Guide for vendor evaluation, available on the SAP Service Marketplace. Use this as a basis for your decision on which scenario to use for the vendor evaluation before activating the DataSources.
0SRM_EVENT_TEXT
0SRM_VEGUID_ATTR
0WS_ANSWER_TEXT
0WS_APPL_TEXT
0WS_KFIGTYP_TEXT
0WS_QSTNNR_TEXT
0WS_QUEST_TEXT
0WS_STATUS_TEXT
0WS_SURVEY_TEXT
0WS_TAROBJ_ATTR
0WS_TAROBJ_TEXT
0WS_DATA_1

-----------------------------------------------------------------------

SRM 4.0:
Component SRM Server 5.0  (EBP 5.0)
Master data:
Product
0PRODUCT_ATTR    -> replaces 0COM_PRODUCT_ATTR
0PRODUCT_HIER    -> replaces 0COM_PRODUCT_HIER
0PRODUCT_TEXT    -> replaces 0COM_PRODUCT_TEXT
0PROD_CATEG_ATTR
0PROD_CATEG_HIER
0PROD_CATEG_TEXT
0PR_PURCHASE_CATEG_ATTR   -> replaces 0COM_PRODUCT_ATTR
                          -> you only have to use this Datasource if
                          -> you are not using 0BBP_PRODUCT_ATTR.
                          -> 0BBP_PRODUCT_ATTR delivers a partial
                          -> data quantity.
0PR_STATUS_ATTR           -> replaces 0COM_PRODUCT_STATUS_TEXT
0PR_TYPE_TEXT             -> replaces 0COM_PRODUCT_TYPE_TEXT
0PR_CATEGORIES_ATTR       -> replaces 0COM_PRODUCT_CATEGORIES_ATTR
0PROD_CATEG_R3_MAP_ATTR   -> replaces 0PROD_CATEG_2_ATTR

Business partner:
0BPARTNER_ATTR
0BPARTNER_HIER
0BPARTNER_TEXT
0BPTYPE_TEXT
0BP_ID_ATTR
0BP_ID_TYPE_TEXT
0BP_IND_CODE_TEXT
0BP_IND_SECTOR_ATTR
0BP_IS_ATTR
0BP_ROLES_ATTR
0BP_ROLE_TEXT
0LEGALFORM_TEXT

All master data you find in application component 0SRM_IO:
0ACCOUNTING_TYPE_ATTR
0BBP_ACCCAT_TEXT
0BBP_BIDDER_ATTR
0BBP_BIDTYP_TEXT
0BBP_BPART_BUYID_ATTR
0BBP_BPCOMPANY_ATTR
0BBP_BPVEND_ATTR
0BBP_BUYID_ATTR
0BBP_BUYID_TEXT
0BBP_CAT_ID_TEXT
0BBP_FLAG_TEXT
0BBP_H_SUBTYPE_TEXT
0BBP_INPTYP_TEXT
0BBP_I_SUBTYPE_TEXT
0BBP_MAT_PR_ATTR
0BBP_ORGUNIT_ATTR
0BBP_ORGUNIT_HR01_HIER
0BBP_ORGUNIT_TEXT
0BBP_ORIGIN_TEXT
0BBP_PARTNER_FLAG_CONTACT
0BBP_PARTNER_FLAG_LOCATION
0BBP_PARTNER_FLAG_VENDOR
0BBP_PC_INS_TEXT
0BBP_PLANT_LOCMAP_ATTR
0BBP_PRODUCT_ATTR
0BBP_PR_MAT_ATTR
0BBP_PURCH_ORG_ATTR
0BBP_PUR_GROUP_ATTR
0BBP_REJCON_TEXT
0BBP_REJINV_TEXT
0BBP_STATUS_TEXT
0BBP_TAXCOD_TEXT
0PROCTYPE_TEXT
0SRM_GLS_VENMAP

SRM Server transaction data:
0BBP_TD_CONF_1
0BBP_TD_INV_1
0BBP_TD_PO_1
0BBP_TD_SC_1
0BBP_TD_SC_APPR_1

Supplier Self Service authorization data:
0SRM_SUS_AUTH_2

Transaction data if you are using contract management in SRM:
0BBP_TD_CONTR_2
0SRM_REL_CT

Data sources for the Bidding Engine:
0BBP_BIGURE_HIER
0BBP_TD_BID_1
0BBP_TD_QUOT_1
0SRM_QUOT_ATTR_1
0SRM_TD_BIDDER
0SRM_QUOT_ATTR_TEXT

Only if you are using vendor evaluation in SRM in addition:
Activate the DataSources in SRM. Before you start, read the Configuration Guide for vendor evaluation available on the SAP Service Marketplace. Use this as a basis for your decision on which scenario to use for the vendor evaluation before activating the DataSources.
0SRM_EVENT_TEXT
0SRM_VEGUID_ATTR
0WS_ANSWER_TEXT
0WS_APPL_TEXT
0WS_KFIGTYP_TEXT
0WS_QSTNNR_TEXT
0WS_QUEST_TEXT
0WS_STATUS_TEXT
0WS_SURVEY_TEXT
0WS_TAROBJ_ATTR
0WS_TAROBJ_TEXT
0WS_DATA_1

---------------------------------------------------------------------
SRM 3.0:
Enterprise Buyer 4.0 (SRM Server 4.0)
0BBP_TD_CONTR_2          -> only if you use contracts in EBP
0BBP_ACCCAT_TEXT
0BBP_BIDDER_ATTR         -> only if you use the Bidding Engine
0BBP_BIDTYP_TEXT         -> only if you use the Bidding Engine
0BBP_BPART_BUYID_ATTR
0BBP_BPCOMPANY_ATTR
0BBP_BPPLANT_ATTR
0BBP_BPVEND_ATTR
0BBP_BUYID_ATTR
0BBP_BUYID_TEXT
0BBP_CAT_ID_TEXT
0BBP_FLAG_TEXT
0BBP_H_SUBTYPE_TEXT
0BBP_INPTYP_TEXT
0BBP_I_SUBTYPE_TEXT
0BBP_MAT_PR_ATTR
0BBP_ORGUNIT_ATTR
0BBP_ORGUNIT_HR01_HIER
0BBP_ORGUNIT_TEXT
0BBP_ORIGIN_TEXT
0BBP_PARTNER_FLAG_CONTACT
0BBP_PARTNER_FLAG_LOCATION
0BBP_PARTNER_FLAG_VENDOR
0BBP_PC_INS_TEXT         -> only if you use P-Cards
0BBP_PLANT_ATTR
0BBP_PLANT_LOCMAP_ATTR
0BBP_PR_MAT_ATTR
0BBP_PURCH_ORG_ATTR
0BBP_PUR_GROUP_ATTR
0BBP_REJCON_TEXT
0BBP_REJINV_TEXT
0BBP_STATUS_TEXT
0BBP_TAXCOD_TEXT
0BBP_VEND_ATTR
0PROCTYPE_TEXT
0SRM_QUOT_ATTR_TEXT      -> only if you use the Bidding Engine
0BBP_BIGURE_HIER         -> only if you use Bidding Engine
0BBP_TD_BID_1            -> only if you use the Bidding Engine
0BBP_TD_QUOT_1           -> only if you use the Bidding Engine
0SRM_QUOT_ATTR_1         -> only if you use the Bidding Engine
0BBP_TD_CONF_1
0BBP_TD_DOCFLOW_H_1      -> only if you analyze the document flow
0BBP_TD_INV_1
0BBP_TD_PO_1
0BBP_TD_SC_1
0BBP_TD_SC_APPR_1
0BBP_PROD_2_ATTR
0BANKKEY_TEXT     -> only required if you analyze partners extensively
0BPARTNER_ATTR
0BPARTNER_TEXT
0BPTYPE_TEXT
0BP_ACTITLE_TEXT  -> only required if you analyze partners extensively
0BP_BANK_ATTR     -> only required if you analyze partners extensively
0BP_CAT_TEXT
0BP_CCARD_ATTR
0BP_CONTACT_TEXT
0BP_DEF_ADDRESS_ATTR
0BP_GROUP_TEXT   -> only required if you analyze partners extensively
0BP_GRPTYPE_TEXT -> only required if you analyze partners extensively
0BP_ID_ATTR      -> only required if you analyze partners extensively
0BP_ID_TYPE_TEXT -> only required if you analyze partners extensively
0BP_IND_CODE_TEXT -> only required if you analyze partners extensively
0BP_IND_SECTOR_ATTR -> only required if you analyze partners extensively
0BP_IS_ATTR      -> only required if you analyze partners extensively
0BP_MARST_TEXT   -> only required if you analyze partners extensively
0BP_TAXCAT_TEXT  -> only required if you analyze partners extensively
0BP_TAXNUMB_ATTR
0BP_TITLESPPL_TEXT -> only required if you analyze partners extensively
0BP_UNAME_ORGUNIT_ATTR  -> only required if you analyze partners extensively
0CAM_CITYCODE_TEXT
0CAM_CITYPCODE_TEXT
0CAM_STREETCODE_TEXT
0CCARDTYPE_TEXT
0IND_NUMSYS_TEXT -> only required if you analyze partners extensively
0IND_SECTOR_HIER -> only required if you analyze partners extensively
0IND_SECTOR_TEXT -> only required if you analyze partners extensively
0LEGALFORM_TEXT  -> only required if you analyze partners extensively
0COUNTRY_TEXT
0REGION_TEXT
0VTYPE_TEXT
0COM_PRODUCT_ATTR          -> replaces 0BBP_PROD_ATTR from EBP 3.5
0COM_PRODUCT_TEXT          -> replaces 0BBP_PROD_TEXT from EBP 3.5
0PROD_CATEG_HIER
0PROD_CATEG_2_ATTR
0COM_PR_COMPETITOR_PROD_TEXT
0COM_PRODUCT_TYPE_TEXT
0COM_PRODUCT_STATUS_ATTR
0COM_PRODUCT_STAPROSYS1_TEXT -> only required if you want to analyze the product extensively
0COM_PRODUCT_STAPROSYS0_TEXT -> only required if you want to analyze the product extensively
0COM_OBJECT_FAMILY_TEXT
0BBP_PRODUCT_ATTR           -> replaces 0BBP_PROD_ATTR from EBP 3.5
0SRM_TD_BIDDER        -> only if you use the Bidding Engine


And only if you use the vendor evaluation in SRM in addition:
0SRM_EVENT_TEXT
0SRM_VEGUID_ATTR
0WS_ANSWER_TEXT
0WS_APPL_TEXT
0WS_KFIGTYP_TEXT
0WS_QSTNNR_TEXT
0WS_QUEST_TEXT
0WS_STATUS_TEXT
0WS_SURVEY_TEXT
0WS_TAROBJ_ATTR
0WS_TAROBJ_TEXT
0WS_DATA_1

---------------------------------------------------------------------
SRM 2.0
Enterprise Buyer Professional 3.5
0BBP_TD_CONTR_2         -> only if you use contracts in EBP
0BBP_ACCCAT_TEXT
0BBP_BIDDER_ATTR    -> only if you use the Bidding Engine
0BBP_BIDTYP_TEXT    -> only if you use the Bidding Engine
0BBP_BPART_ATTR
0BBP_BPART_BUYID_ATTR
0BBP_BPART_TEXT
0BBP_BPCCARD_ATTR -> only required if you analyze partners extensively
0BBP_BPCOMPANY_ATTR
0BBP_BPDEFADDR_ATTR
0BBP_BPPLANT_ATTR
0BBP_BPTYPE_TEXT
0BBP_BPVEND_ATTR
0BBP_BP_BANK_ATTR -> only required if you analyze partners extensively
0BBP_BP_ID_ATTR  -> only required if you analyze partners extensively
0BBP_BP_ID_TYPE_TEXT
0BBP_BP_IND_CODE_TEXT -> only required if you analyze partners extensively
0BBP_BP_IND_SECTOR_ATTR -> only required if you analyze partners extensively
0BBP_BP_IS_ATTR
0BBP_BP_STATUS_ATTR  -> only required if you analyze partners extensively
0BBP_BP_TAXCAT_TEXT  -> only required if you analyze partners extensively
0BBP_BP_TAXNUMB_ATTR -> only required if you analyze partners extensively
0BBP_BP_UNAME_ATTR
0BBP_BUYID_ATTR
0BBP_BUYID_TEXT
0BBP_CAT_ID_TEXT
0BBP_CITYCODE_TEXT
0BBP_FLAG_TEXT
0BBP_H_SUBTYPE_TEXT
0BBP_IND_NUMSYS_TEXT
0BBP_IND_SECTOR_HIER
0BBP_IND_SECTOR_TEXT
0BBP_INPTYP_TEXT
0BBP_I_SUBTYPE_TEXT
0BBP_MAT_PR_ATTR
0BBP_ORGUNIT_ATTR
0BBP_ORGUNIT_HR01_HIER
0BBP_ORGUNIT_TEXT
0BBP_ORIGIN_TEXT
0BBP_PARTNER_FLAG_VENDOR
0BBP_PC_INS_TEXT             -> only if you use P-Cards
0BBP_PLANT_ATTR
0BBP_PROD_ATTR
0BBP_PROD_HIER
0BBP_PROD_STATUS_ATTR
0BBP_PROD_TEXT
0BBP_PR_MAT_ATTR
0BBP_PURCH_ORG_ATTR
0BBP_PUR_GROUP_ATTR
0BBP_REJCON_TEXT
0BBP_REJINV_TEXT
0BBP_STATUS_TEXT
0BBP_STREETCODE_TEXT
0BBP_TAXCOD_TEXT
0BBP_VEND_ATTR
0PROCTYPE_TEXT
0SRM_QUOT_ATTR_TEXT  -> only if you use the Bidding Engine
0BBP_BIGURE_HIER     -> only if you use the Bidding Engine
0BBP_TD_BID_1        -> only if you use the Bidding Engine
0BBP_TD_QUOT_1       -> only if you use the Bidding Engine
0SRM_QUOT_ATTR_1     -> only if you use the Bidding Engine
0BBP_TD_CONF_1
0BBP_TD_INV_1
0BBP_TD_PO_1
0BBP_TD_SC_1
0BBP_TD_SC_APPR_1
0PROD_CATEG_2_ATTR
0PROD_CATEG_ATTR
0PROD_CATEG_HIER
0PROD_CATEG_TEXT
0BBP_PROD_2_ATTR

----------------------------------------------------------------------
SRM 1.0
Enterprise Buyer Professional 3.0
0BBP_TD_CONTR_2           -> only if you use contracts in EBP
0BBP_ACCCAT_TEXT
0BBP_BIDDER_ATTR          -> only if you use the Bidding Engine
0BBP_BIDTYP_TEXT          -> only if you use the Bidding Engine
0BBP_BPART_ATTR
0BBP_BPART_BUYID_ATTR
0BBP_BPART_TEXT
0BBP_BPCCARD_ATTR -> only required if you analyze partners extensively
0BBP_BPDEFADDR_ATTR
0BBP_BPPLANT_ATTR
0BBP_BPVEND_ATTR
0BBP_BP_BANK_ATTR -> only required if you analyze partners extensively
0BBP_BP_IND_SECTOR_ATTR -> only required if you analyze partners extensively
0BBP_BP_TAXCAT_TEXT -> only required if you analyze partners extensively
0BBP_BP_TAXNUMB_ATTR -> only required if you analyze partners extensively
0BBP_BP_UNAME_ATTR
0BBP_BUYID_ATTR
0BBP_BUYID_TEXT
0BBP_CAT_ID_TEXT
0BBP_CITYCODE_TEXT
0BBP_CITYPCODE_TEXT
0BBP_FLAG_TEXT
0BBP_H_SUBTYPE_TEXT
0BBP_INPTYP_TEXT
0BBP_I_SUBTYPE_TEXT
0BBP_MAT_PR_ATTR
0BBP_ORGUNIT_ATTR
0BBP_ORGUNIT_HR01_HIER
0BBP_ORGUNIT_TEXT
0BBP_ORIGIN_TEXT
0BBP_PC_INS_TEXT         -> only if you use P-Cards
0BBP_PLANT_ATTR
0BBP_PROD_ATTR
0BBP_PROD_HIER
0BBP_PROD_TEXT
0BBP_PR_MAT_ATTR
0BBP_STATUS_TEXT
0BBP_STREETCODE_TEXT
0BBP_TAXCOD_TEXT
0BBP_VEND_ATTR
0PROCTYPE_TEXT
0BBP_TD_BID_1          -> only if you use the Bidding Engine
0BBP_TD_QUOT_1         -> only if you use the Bidding Engine
0BBP_TD_CONF_1
0BBP_TD_INV_1
0BBP_TD_PO_1
0EBP_TD_SC_1           -> Refer to Note 594067
0EBP_TD_SC_APPR_1      -> Refer to Note 594067
0PROD_CATEG_2_ATTR
0PROD_CATEG_ATTR
0PROD_CATEG_HIER
0PROD_CATEG_TEXT
0BBP_PROD_2_ATTR

Affected Releases
Software Component Release From Release To Release And subsequent
BI_CONT310310310
BI_CONT330330330
BI_CONT352352352
BI_CONT353353353X
BI_CONT702702702X
SRM_SERVER500500500
SRM_SERVER550550550X
BBPCRM3.0300300
BBPCRM4.0400400

Correction delivered in Support Package
Support Packages Release Package Name
BBPCRM400SAPKU40002

Related Notes
856911SRM 5.0 Installation: Composite Note
637346EBP Business Content during EBP upgrade to EBP 4.0
559160DataSources for product texts do not contain a category
515737Flexible master data upload for generic InfoObjects
507175EBP 3.5: Business partner/product extraction
456992Information on e-Procurement Analytics