cancel
Showing results for 
Search instead for 
Did you mean: 

ESTDH table - Report status codes

imachoshvili
Explorer
0 Kudos
611

Hi all,

I would like to generate a report using ESTDH which shows SDS in "Completed" status highlighted in yellow below. I´m using W6 as Report Status code in ESTDH, however W6 is showing Completed SDSs and some already released SDSs.

Is there a Report Status code that returns SDS in "Completed" status only?

Thanks.

Igor

Accepted Solutions (0)

Answers (6)

Answers (6)

christoph_bergemann
Active Contributor
0 Kudos

Hello

based on your current feedback: pay attention with the "user id" story. Because of the EHS internal process we have "many user IDs" in the game.

For safety reasons: please check this discussion:

https://answers.sap.com/questions/13722628/sap-user-details-in-wwi-report-based-on-status-rel.html

C.B.

christoph_bergemann
Active Contributor
0 Kudos

Hello

a.) if the user "reject" a "prepared" report in CG50: next day you will not see this any more in the user interface

b.) If you start with CG02 you can "select" the status of the report ot be displayed (e.g. "generation with warning" etc.)

c.) if you start using CG50 you can do the same: So in the user interface there is an option to select the "status". Here you can define whatever kind of "list". If you select: show only thos which are "completed": this is a natural option of transaction CG50... PLease check the SAP online help

C.B.

imachoshvili
Explorer
0 Kudos

Hi C.B.,

Thanks for the comments.

I will use CG50 as you mentioned and cross information with ESTDH because I need user ID.

Thanks.

Igor

imachoshvili
Explorer
0 Kudos

Hi all,

Thanks for the comments.

Let me rephrase.

I generate SDSs in CG02 and I expect to put Report Status = W6 in ESTDH and get a table that shows what is actually in W6 status, however I´m getting some records that were W6 few months ago but they are not W6 anymore today, they are W7 or even rejected by the user, so I have to go GC50 to check what is really W6.

Thanks.

Igor

christoph_bergemann
Active Contributor
0 Kudos

Hello

in the SAP standard is techical value "W6" is assigned to the status "completed"; W7 is "released". You should not change that.

Between "W6" and "W7" you can add customer specific status

In the generation variant you define the "first" status which is "relevant" from user perspective. Normally you use "Completed" here; but you can change that to "Released".

If you use then CG02 you should get only "Released" documents in CG50. There are some exemptions. Examples are: e.g. phrase is not translated, potential other status are "System Error" etc.

Using transaction CG50 you can display the generated report "ignoring" the status. In Transaction CG54 you will see only "Released" reports (and "historic reports as well"). Only "Released" reports do have a value in the subsequent processes.

The "Status net" is explained e.g. here:

https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/ff6d35a34fbe4bea99e4ac41b0d5db03/bba4ce5314894208e10...

An example you find here:

https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/ff6d35a34fbe4bea99e4ac41b0d5db03/bea4ce5314894208e10...

C.B.

PS: the "status net" etc. is defined in customizing.

imachoshvili
Explorer
0 Kudos

Hi Ralph,

How to check status network setup?

Thanks

Igor

Ralph_P
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Igor,

only W6 should be status completed, whereas W7 should be status released. Are you sure your status network is set up correctly?

Ralph