Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Variance

hi ,

i have to find variance for price and quantity.

from EKBE table i need to fetch bewtp , menge , dmbtr, ebeln and ebelp.

for example

if for a particular ebeln

ebeln ebelp bewtp menge dmbtr

4500000390 0010 E 7 200

4500000390 0020 E 5 400

4500000390 0020 Q 2 300

4500000390 0030 E 9 800

4500000390 0030 Q 4 500

I need to get output as

if for line item 0010 there is no Q

then E-Q

MENGE = 7-0 =7

DMBTR = 200-0 =200

for line item 0020

E-Q

MENGE = 5-2 =3

DMBTR = 400-300 =100

same way for line item 0030

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question