Generate a report on Text

[former_member185462]

Hi,

My client requirement is Sales Order will be created,based on approval from GOVT,the order will be released for delivery.

So we have planned to configure Header text in Sales document.It have 3 levels.

I have maintained 3 text Id's.ZPRD-Govt Approval 1,ZZ99-Govt Approval 2,ZIGN-Govt Approval .

Based on each stage of approval we will got to header of sales document maintain it as text.

Suppose if we got approval at stage 1 on it will be maintained at Govt Approval 1,stage 2 at Govt Approval 2,stage 3 at Govt Approval 3.

The client wants to generate a report which will have sales document no,approval stage.

If approval is got at all 3 stages,the sales order is ready for delivery.

I have checked with abaper,he wanted me to provide the field name and table for text which we entered.

Thanks,

Pradeep M

[od_manikandan]

Dear Pradeep,

Please check this

Hope this code can retrieve the data

Regards,

Mani

[former_member185462]

The table STXH was use full ,but the problem is i cannot able to the text what what we key in against the Text Id's in sales document.