Status profile in SAP BI

[Former Member]

Hi Experts,

Our user want to see status profile (in va03 -> status tab - > Object status button -> status w/o status no.) details in BI report against each sales order and item.

Do you have idea how we can bring this data into SAP BW, any standard extractor is present for same?

Have a good day !!

[former_member188080 · Accepted solution]

Hi,

You are talking about Sales order details so you have many datasources as follows,check following document

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d07aa007-84ab-2d10-46ba-a5a2679f0...

Thanks and regards

Kiran

[Former Member · Accepted solution]

Hi Kiran,

There is no datasource which provide status profile information which i have mentioned in my question.

Regards,

Ganesh Wathare

[former_member188080 · Accepted solution]

Hi Ganesh,

Check with your functional team which table this data is stored and try to enhance your existing datasource then by doing look up..

Thanks and regards

Kiran

[Former Member · Accepted solution]

Hi Kiran,

This is a standard functionality in SD, hence i am trying to see if there is and standard option is available.

I will go for this option at end when there is no other option is available. Thanks

[Former Member · Accepted solution]

In case you have to build a custom setup (which I believe will be the case), the tables involved are JSTO, JEST, JCDS (change history of statuses), VBELN, TJ20(T), TJ30(T), TJ02(T).

[former_member188080]

Hi.

I am not sure which datasource you are using..

You can see the technical name of the field and see if it is avaialble in BD52.

Thanks and regards

Kiran