In SD, we have removal of Billing block before creation of invoice or billing document.
In the Change Sales Order: Item Data Screen, in the billing block field under Billing Tab, remove the data from the field and leave the field blank. PFB the screen (I got it from internet)
How can I get the details of user who unblocked the billing block? I need this data to BI report.
Info on the field, VBRK-RFBSK (value A for this filed represents blocked and C represents unblocked) can be used to know the status of billing block.
As discussed with SD team, details of changed orders are available from tables CDHDR (Change document header) and CDPOS (Change document items). The field USERNAME (User name of the person responsible in change document) gives the user details.
If no changes are done to orders after unblocking it, then the Username is the one who unblocked the billing block . But another user might change some other field after the unblocking and his user comes up as last changed by. In such cases how to find the user who unblocked it?
It would be great if you could provide your inputs to get this data to BI.