cancel
Showing results for 
Search instead for 
Did you mean: 

Sales contract validity

Former Member
0 Kudos

There is requirement of report containing Sales contract (Sales data) against Material against contracts Validity dates (From u2013To).

How can we fetch this.

Accepted Solutions (0)

Answers (2)

Answers (2)

jignesh_mehta3
Active Contributor
0 Kudos

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

jpfriends079
Active Contributor
0 Kudos

Hello

Try list of contracts by using TCode VA45N.

Thanks & Regards

JP

Former Member
0 Kudos

That wont help.I tried it. I want list against material,doc no,validity(from -to)

Former Member
0 Kudos

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