SC Current Status Table

[Former Member]

Hi All;

We are using SRM 7.0

I am developing a report to show the status of the SC. However, I could not find the table which gives me the current status of the SC.

In BBP_PD, ican see the following status but I don't know what is the current status or last status.

Stats:

Status Description Inactiv

HEADER I1015 Awaiting Approval X

HEADER I1021 Created

HEADER I1038 Complete

HEADER I1106 Shopping cart ordered

HEADER I1129 Approved

Which table will give me the current status of the SC?

Thanks for help

[Former Member · Accepted solution]

Hi,

Please use the FM BBP_DOC_STATUS_GET.

Give the following details to the FM

Import parameters

IV_OBJTYPE = object_id (BUS2121)

IV_GUID = header guid (SC header GUID)

Tables

IT_STATUS = Give all the entries which in exist in crm_jest table for same header guid of the shopping cart.

In export parameter u will get the status in

EV_STATUS

EV_STATUS_DESCRIPTION

Regards,

Nikhil

[Former Member · Accepted solution]

Dear Nikhil;

Thanks for your swift reply.

I tested this FM but I did not get any output for SC at all. For Other docs, like, conf & RFQ, I get a list of all status, see below, with no mark of the current status.

I1038 COMP Complete

I1009 HELD Held

I1041 REDY RFx Ready

I1015 RELP Awaiting Approval

I1016 RELR Release Rejected

I1040 DELT Deleted

I1011 PUBL Published

I1023 CMPL Transaction Completed

Is there anything missning ?

[Former Member · Accepted solution]

Hi,

I think you are looking at ET_STATUS.

In my system, EV_STATUS gave correct results.

Dear Nikhil,

Thanks. It is very useful info... But unfortunately I could not give you point, as I had not raised the thread.

Ganapathi

[Former Member · Accepted solution]

Dear;

I am looking at the right place but there is nothing at all in EV_STATUS i.e. it is blank next to this status, no entries.

Appreciate if somebody knwos how to get the status

Thanks

[Former Member · Accepted solution]

Hi,

are you filling up the IT_STATUS table? if you wont fill this you wont get the EV_STATUS and ET_STATUS

[Former Member · Accepted solution]

Hi Soumyaprakash

you are right, i was missing that.

Thanks

[Former Member · Accepted solution]

DearNikhi;

Thanks for yor reply. My problem is solved.

Regards