how to find Approval data in SRM system

[Former Member]

Hi All,

Kindly let me know from which table / or how can I find the approval data ?

Actually one of the shopping cart is not transfering approval data from r/3 to BW althoufg the shooping cart has been approved (c1). In order to debug this, I wanted to know how can I find the approval data in srm system.

The data is extracted thru function module and i have already searched the table CRMD_PARTNER but there is no approval data in this.

Any help will be appreciated.

Regards,

Dola

[Former Member]

thanks all

[Former Member]

Hello,

Approval table and data are in fact maintained in Workflwo container. If you are using the BADI workflow, then the below logic can be used (assuming you are in SRM 5.0)

1. Use function module BBP_PDH_WFL_WI_FROM_OBJECT_GET to get the work item corresponding to the document (PO/CTR/SC..).

2.Once you have the work item, you can pass this to function module BBP_WFL_DIN_APPR_CONTAINER_GET to get the approval agents.

The return table ET_APPROVAL_AGENTS from function module BBP_WFL_DIN_APPR_CONTAINER_GET will give you back all the approvers in the workflow.

Rgds,

Prasanna

[Former Member]

thanks , I got the approval data for the SC . it has been approved (C1 approval) but I don't understand why this data has not been extracted to BW. From BW side I don't think there is any issue because

all other SC's are having approval data in BW.

Any hint where to check in SRm system .

Regards,

Sushmita

[Former Member]

do u think checking the badi interface will do ? how to check ?

[Former Member]

Can you check with BW person. If the extraction job is running on daily basis, in that caset today data will be extracted on next day into BW.

This could be the reason.

[former_member195032]

if you want to see approval data for a particular SC in SRM system.

You can see that using a transaction

T Code: BBP_PD

Object Type : BUS2121

Object_ID = Shopping Cart number

Execute

Browse the list to bottom

you will get

Workflow Item:

Node ID and Agent will give you approval details.

I hope this help.

Regards,Nishant