Need a report on credit release with user name whos has released

[Former Member]

Hi All,

Need a report with following details:

1.2. Sales order punched by-user name who has created.

2. User name who has released sales order from credit block.

3. release Date and time of order released.

Please suggest. As I could not find any standard report.

what tables should I join to get the report.

Thanks in advance

Regards,

Mskgnt

[Former Member]

hi Prashant,

let me try and get back to you on this

Thanks

mskgnt

[Former Member]

hI

>

> Need a report with following details:

>

> 1.2. Sales order punched by-user name who has created.

You can get the user name from table VBAK-ERNAM Pass the sales order number in to VBAK-VBELN

> 2. User name who has released sales order from credit block.

> 3. release Date and time of order released.

From the report RSSCD100 enter the object class as VERKBELEG and T code as VKM3 and execute

Or You can use the table CDHDR

User Name CDHDR-username and for release date and time

CDHDR-UDATE

CDHDR-UTIME

REGARDS

PrashanthI

Edited by: Prashanth@SD on Nov 9, 2010 8:03 AM