on 04-10-2017 9:50 AM
We have a requirement where in we need to capture the TCode used for creation of SD Documents( Sales orders, Delivery and Invoices). We have a few Z Tcodes that also can be used for Sales document creations. Like changes for all Sales documents are logged into CDHDR/CDPOS tables , including tcode used to make the changes. Here, my requirement is to find , which tcode was used to "create" a sales document, like VA01 for sales orders or some other Z tcode.
I have already tried to get the information from SLG1, STAD, and System Audit logs without any success. I am looking for a way to find this information without writing a new logic in all the Z tcodes.
Regards
Manpreet Singh
Hi,
go to SE16 and type TSTC then go for z* for searching
may be you can find the desired tcodes.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That is not my requirement. CDHDR table contains the "Tcode" used for every change done on a sales document. I want to know, if there is a table that stores the tcode used to "create" a sales document. Looking for something like below in a table or system log.
SalesDoumentNumber Username Tcodeusedforcreation
123 ABC VA01
124 ABC ZVA01
Hi Manpreet,
As you mentioned change documents should give this information even for Z* transactions. CDHDR-TCODE = 'Z*' and CHANGE_ID = 'I'.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is the standard behaviour for sales documents (object VERKBELEG) - only update and delete are recorded. Read 1460780 - VA01 is not capturing change documents (CDHDR/CDPOS).
Manpreet - As Veselina pointed out there is no change documents are generated for creation of sales documents. You can still find transaction code in change document tables for Update and Delete records. If your requirement is for creation it seems there is no way to find transaction codes, it seems you can approach to custom development solutions for ongoing tracks.
Why is this needed? What's the importance and what business purpose would this serve?
To my knowledge, there is no such option without doing some ABAP. But normally creating ZVA01s is not recommended either. The orders can also be submitted using different interfaces (e.g. EDI) but those scenarios can be easily tracked by user IDs. Interface orders would have generic user IDs, not real people.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.