Custom Report in SRM

[former_member184028]

HI

i am working on a custom report,

Our system is SRM 702  Extended classic and  using PDP.

i am trying to build a report where  upon inputting  SC or PR or BID number i should fetch all the details

ex: If i input PR,  the report should fetch corresponding  SC and BID ..  and vice versa for BID & SC..

can you provide me tables where i can establish link between SC/PR/BID?

[Former Member · Accepted solution]

Hi Satish,

You can get the document/ item history using this function module.

BBP_GET_DOC_HISTORY.

Watchout for the import parameter IT_OBJECT_KEY. It has various parameters

H_OBJECT_TYPE

H_GUID

I_OBJECT_TYPE

I_GUID

OBJECT_ID

NUMBER_INT

LOGSYS

H_SRC_OBJTYPE

H_SRC_GUID

H_SRC_VERSION_GUID

Observe that here, H stands for Header and I stands for Item. Pass corresponding information, to get the desired output.

Regards,

Karthik Babu

[pablo_ruiznavas]

Hi Satish,

I propose to use classes instead of function modules, for example you can use the /sapsrm/cl_pdo_model_factory standard class. See following details:

Get instance of the document:
   lo_pd_model = /sapsrm/cl_pdo_model_factory=>get_instance( ).

Get details of the document:
CALL METHOD lo_pd_model->get_detail

It works for all Purchasing documents and all relevant information is retrieved.

Kind regards,

Pablo.

[Former Member]

Hi Satish,

There are no specific tables to serve your purpose but as in previous post told you can use FM BBP_GET_DOC_HISTORY. Here you need to be specific which document number is provided by user. Accordingly you can define the document type and fetch details.

Thanks

Siddarth

[former_member184111]

Hi Satish,

You can read object link s to get this data.

BBP_PD_SC_GETDETAIL

BBP_PD_BID_GETDETAIL

both have table parameter

E_HEADER_REL

E_ITMLIM_REL

for object relations.

Thanks,

Anubhav