cancel
Showing results for 
Search instead for 
Did you mean: 

MWST Value for 50 Sales Orders

0 Kudos

Hello Experts,

Previously I was into LE, I am new to SD.

I need help in a scenario, i.e I have 50 sales orders, I want the total value of MWST condition type for 50 SO.

I tried to get the information in google but not able to get required information. Kindly help..

Thanks in Advance    

Best Regards

Praveen

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Praveen,

If you know the SO numbers of all 50 SOs:

Pass all of them to VBAK-VBELN to get VBAK-KNUMV. Pass VBAK-KNUMV to KONV-KNUMV with KONV-KSCHL = 'MWST' to get KONV-KBETR and add all of them.

May I know what would you do with sum of MWST of 50 sales orders?

Regards

SD

0 Kudos

HI Samier,

Thanks for sharing the knowledge. What you  explained is very nice and helpfull. But while Passing VBAK-KNUMV to KONV-KNUMV with KONV-KSCHL= "MWST" I am getting all the condition types along with MWST, I need only MWST

Kindly Help

Thanks in advance

Praven Kumar

prashant_sharma21
Contributor
0 Kudos

Hello Praveen,

I believe you have forgotten to maintain field "KSCHL" with MWST.

0 Kudos

Thank you very much Samier and Prashanth

Best Regards

Praveen Kumar    

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi

u can use item condition tab and press analysis that find out the condition table.

then using condition rec. no.  to table KONP-KBETR for Conditions (Item).

Hop that can help u.