SRM tables description

[Former Member]

Hi, guys!!! I'm learning SRM and i need full information about following:

1. Products & Product Categories

2. Suppliers

3. Org Mgmt. & Biz. Partners

I need to know how data stored and in which tables. In otherwords, all technical info about tables that stored data and relationship between them.

I'll be appreciate for any info or links.

Thanks.

[Former Member · Accepted solution]

Hi

<u>Welcome to world of SRM !!!</u>

<b>Please go through this - Here are the required details -></b>

<u>1. For Product and product category </u> using SE16 transaction, see the table data ->

COMM_PRODUCT (Product table)

COMM_CATEGORY (Product category table)

<u>2. Supplier tables</u>

<u>3. Org plan related tables and function modules</u>

<u>Function modules for Org plan -></u>

RH_BUF_GEN_USER_POSITION_ORG

RH_GENERATE_POSITION_AT_ORG

RH_DELIMIT_POSITION_0F_USER

<u>Business partner related links -></u>

<u><b>Note -></b> Most important tables You find in transaction BBP_PD. Choose object type (eg. BUS2121 for SC) and run transaction. You will see document detalis with table and field names.

About FM's: most important Function Modules in SRM begins on "BBP*".</u>

Hope this will definitely help.

Incase you send me your email id, i can send you some other important details as well.

Regards

- Atul

[Former Member · Accepted solution]

Hi again!!!

Thanks for useful answer.

You can use next email: george_mb@mail.ru

Thanks.

[Former Member · Accepted solution]

Hi

Sent some very good info... )

Cheers

- Atul

[Former Member]

Hi Atul,

i see we've some misunderstanding here )))))))))))))))))

My previous post is my new question!!!

I have non-SAP web-based system. The functionality of this system is similar to SRM. I should create solution, that establishes a correspondence between master data of that system and SAP SRM.

I'm really need to know the following:

I know how master data stores in my system, so my question is "how master data stores in SRM"?

Thanks.

[Former Member]

Hi

<b>Please elaborate in detail. Are you looking for BW Functionality using ODS (operation data storage) ? .</b>

<u>Then, some links to refer are -></u>

http://help.sap.com/saphelp_srm50/helpdata/en/75/cada385925044ae10000000a114084/frameset.htm

http://help.sap.com/saphelp_srm50/helpdata/en/7e/1d2b3df1e5cc40e10000000a114084/frameset.htm

Regards

- Atul

[Former Member]

No, it's not BW functionality.

At this moment my task is to study SRM master data.

I need to know what exactly master data means?

In which tables i can find master data?

What does master data consist of (materials, vendors etc.)?

[Former Member]

Hi

Master data in SRM can be downloaded from the SAP back end. This data includes product master records, business partner master records, and product categories. products (material), service masters, and product categories (material groups) are downloaded via the middleware. The middleware is a set of programs that exist partly in the EBP and partly in the SAP back-end plug-in.

EBP uses the SAP business partner concept. An internal or external business partner is created in EBP for every person, organization, or group of people who could be involved in a business transaction. The vendor is an external business partner. Conversely, plant is an internal business partner. A shopping cart requester, a plant, an organization, a creditor, vendor, a bidder, or a marketplace are all business partners within SRM.

Vendors are not downloaded via the middleware -- instead using a transaction "BBPGETVD" or via the synchronization.

The SRM solution uses the business intelligence capabilities of SAP NetWeaver to access any number of connected systems and extract the information (especially FI documents) needed to paint a detailed picture of spend across the entire corporate group. The Local Master Data Alignment in SAP BW allows harmonization of central master data for reporting purposes. Advanced sorting capabilities help to quickly identify inconsistencies such as duplicate vendors or products. Moreover, this tool supports assigning purchasing categories to standard classification schemas such as the United Nations/Standard Products and Services Code (UN/SPSC) and eCl@ss.

Thus, mySAP SRM provides you with a clear view of procurement costs and supply-base data by highlighting consolidated spend volume, supplier redundancies, and demand aggregation opportunities.

<u>Please go through the links below -></u>

http://help.sap.com/saphelp_srm50/helpdata/en/e5/f5e938b4ece075e10000000a114084/frameset.htm

http://help.sap.com/saphelp_srm50/helpdata/en/42/d3b671ba67136fe10000000a1553f7/frameset.htm

http://help.sap.com/saphelp_srm50/helpdata/en/b3/c6c93f3c903c1ce10000000a114084/frameset.htm

http://www.camelot-idpro.de/index.php?id=137&L=1

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/c0102a91-bae4-2910-f298-acbae13e...

http://www.supplierforce.com/solutions/master_data_repository.446.html

Regards

- Atul

[Former Member]

Thanks for information, Atul!!!

But i still want to know:

1. In which tables i can find master data?

2. Is there any sign, that separate master data and non master data?

3. How can i understand that some records in, for example, COMM_PRODUCT are master data?

4. Is there tables that contain only master data, or master data and non master data is saved in cofusion?

Thank you!

[Former Member]

Hi

<b>As i have given the links earlier, Master data is nothing but Vendors, products, partners, etc..</b>

<b>SRM Master Data Tables</b>

Please refer to Tablesbelow ->

<u>BUT000</u> table for all kind of partners in SRM (Bidders, Vendors, contact persons, suppliers, goods receipients, etc..)

Table <u>VENMAP</u> for Vendors replicated from R/3 backend using BBPGETVD Transaction.

Table <u>COMM_CATEGORY</u> for Product categories.

Table <u>COMM_PRODUCT</u> for Products.

Hope this will help.

Regards

- Atul

[Former Member]

Hi, Atul!!!

I think, everything's clear now.

Thank you!!!

Best Regards.

Yury.

[Former Member]

Thanks a lot for your information - it's very helpful!!!

Maybe you can say some words about following:

I have non-SAP web-based system. The functionality of this system is similar to SRM. I should create solution, that establishes a correspondence between <b>master data</b> of that system and SAP SRM. I know how master data stores in my system, so i need to know how it stores in SRM. (I don't know yet, how this solution will be look like. That's why i decided to start from understanding of how master data is stored in SRM.) That's why i asked about description of tables.

Thanks.

[Former Member]

Hi

Welcome. Anytime come with your queries.

Wl try to help you out. )

Cheers

- Atul

[Former Member]

There're some additional data

[Former Member]

Hi,

Tables for :

1.For product & product categories :COMM_PRODUCT,COMM_CATEGORY,COMM_HIERARCHY.

related links:- http://help.sap.com/saphelp_srm50/helpdata/en/02/faeb38d391aa6ce10000000a11402f/frameset.htm

http://help.sap.com/saphelp_srm50/helpdata/en/43/2022b83fbc2be8e10000000a11466f/frameset.htm

2.For Vendors/Suppliers:

BBP_VENMAP,BUT000.All the vendors which are replicated from R/3 or created in SRM are created as BUSINESS PARTNERS.

related links:

http://help.sap.com/saphelp_srm50/helpdata/en/b8/43df428949f140e10000000a1550b0/frameset.htm

http://help.sap.com/saphelp_srm50/helpdata/en/43/9e81410d23c37de10000000a155106/frameset.htm

http://help.sap.com/saphelp_srm50/helpdata/en/fb/fa5a0cba1411d497a30004ac962ee6/frameset.htm

3.For Organisation related data:

HRP1000.

Related link:

http://help.sap.com/saphelp_srm50/helpdata/en/fa/fa7d3cb7f58910e10000000a114084/frameset.htm

HTH.

BR,

Disha.

Pls reward points for useful answers.