on 05-10-2011 5:06 AM
There is requirement of report containing Sales contract (Sales data) against Material against contracts Validity dates (From u2013To).
How can we fetch this.
Hello,
You can either generate a ABAP Query (T-Code SQ00) or Ask your ABAPer to write a simple program which will also give you required Selection Screen.
In either of the case, you hvae to join VBAK, VBAP & VEDA tables.
Hope this helpsm
Thanks,
Jignesh Mehta
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
Try list of contracts by using TCode VA45N.
Thanks & Regards
JP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amol,
I am not sure but try this :--
01. Go to SE16N -> VBAP--> Enter material and execute . You will get list of all the Sale doc Number.
02. Now again go to SE16N --> VEDA- > Copy all ABAP Sales doc Number and upload here ( VBELN ) from the clipboard option and execute; enter 0 at item ( VPOSN ) and execute.
03. You will get here all the relevant material specific contract data Viz. Contract satart date , contract end date , contract signed date etc.
Test this and if it suits your requirements , you can ask ABAPer to write a Zprogram for this.
Regards/Rajesh
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
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.