How to identify who put the billing block in a program

[Former Member]

I'm doing some modifications on a standard report VCUST - to identify the net revenue related to Billing blocks. Additionally, we need to report the user who has put the billing block against the customer. How can we identify this information from the back-end tables? Please assist.

Thanks

Vinod

[Former Member · Accepted solution]

Hi vinod,

I hope you can get change history based on CDPOS and CDHDR tables and based on billing block filed you will get the rest of the details.

Regards

Nishad

[former_member217082]

Hi Vinod

In the report you may have to include (VBAK - ERDAT) and (VBAK - ERNAM) feild details .So that it will meet your requirement who has put the billing block.So once you execute the report then you can get the details who has assigned the billing block.

Before doing changes in VCUST report check in CDPOS and CDHDR tables

Regards

Srinath

[Former Member]

Hi,

I think by the USR02 - BNAME (User name),here we know which user is logged in to system,must be he only set the billing block.

For sale order VBAK - ERNAM. orals through table CDHDR give T.code VCUST and see the USERNAME.

Ram