Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

get the final approved date for creating SO

Hi,Expert,

I have using the approved module in sbo. I want to create query to run a report regarding the so approved situation.

In addtion ,I could created some approved templete including 2or 3 stage.

I write the statment as follow:

select T1.updatedate,T1.wddcode,T0.*,T1.*,T1.updatedate,T3.docnum,T3.numatcard,itemcode,quantity,canceled from owdd T0
 join wdd1 T1 on T0.wddcode = T1.wddcode
 join rdr1 T2 on T0.docentry = T2.docentry 
 join ordr T3 on T2.docentry = T3.docentry 
where  isdraft='N' and 
T3.[CANCELED] = 'N'

Please give me some hint.

Thank you

Regard

Eric

Former Member
Not what you were looking for? View more on this topic or Ask a question