SAP SRM Tables and Link between them

[Former Member]

Dear All,

I am in the process of designing a SRM report which should display following fields:

a. Purchase Order number

b. Purchase Order date

c. Vendor

d. Net Value

e. Requisitioner name

f. Approving Manager name

g. Item(s) Description

h. Quantity ordered

i. Unit of measure

j. Net Unit Price

k. Extended price (Net unit price x Quantity ordered)

l. General Ledger Account number

m. Cost Center number

n. Internal Order number, if applicable

I require links between different tables (GUID not matching). Can you please provide me with links between different tables or available function modules so that we can stand with the report.

Thank you.

Best wishes,

Atanu Dey

[Former Member]

Hi Atanu,

If you know the field name like Material Number(matnr) then follow the below procedure you will get the list of table these filed is there by which you can get the data from those tables and develop a report

1) type t-code SE15.

2) Select ABAP Dictionary

3) Select "fields" folder

4) Click on table fields

5) Then you can enter the desired field name (In your case EKGRP)

6) Run OR press F8.

You will get the tables that this filed is releted.

Sameer

[former_member206968]

Hi

You can try using FMs BBP_PD_PO_GETLIST and BBP_PD_PO_GETDETAIL for most of the data that you have mentioned. Only data which would be missing here is the approver of the PO.To get this you can use FM BBP_PDH_WFL_APPROVER_COUNT.

Regards,

Sanjeev

[Former Member]

Hi,

You can check this in TCode BBP_PD here you will get all the data and the tables with relationship

Regards,

Sachin

[Former Member]

Hi Sachin,

I have already used BBP_PD to get relevant table name, but the guid of one is not matching with another, so I am not able to find out correct value. I was trying to find out function modules that can be of similar use.

Thanks and regards,

Atanu

[Former Member]

Hi,

Can you just give me the fields for which you are not getting the links,

Regards,

Sachin

[Former Member]

Hi Sachin,

We can take example of vendor for which GUID is not matching with that of header GUID. Another thing how can we find the approver name, say manager is he approver.

Thanks and regards,

Atanu

[Former Member]

Hi,

Check this link

http://www.scribd.com/doc/946498/SAP-CRM-Tech-DRAFTtablesrelationships

this will help you.

Regards,

Sachin

[Former Member]

Hi Sachin,

I do not have permission in office. If you can send to deyatanu304.ya.cm, it will be of great help. Is it applicable to SRM as well.

Thanks and regards,

Atanu

[Former Member]

send...

Regards,

Sachin