Skip to Content
avatar image
Former Member

How to identify who put the billing block in a program

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 21, 2011 at 09:54 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 21, 2011 at 09:54 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 21, 2011 at 10:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded