cancel
Showing results for 
Search instead for 
Did you mean: 

PO Quantity in SAP BODS

Former Member
0 Kudos

Hi All,

Am new to SAP BODS,can you please any one help me please.

I got a task to create in PO Quantity in SAP BODS.

i need to join two tables i.e EKPO and EKBE,so i need to calculate po quantity in EKBE fields are (EBELN,EBELP,BEWTP,BWART,).

they providing logic like this,

If the item category is service (EKPO-PSTYP=9) and material (EKPO-MATNR) is blank , po quantity (EKPO-MENGE) in MSAP = PO quantity (EKPO-MENGE) in GSAP
If the item category is standard (EKPO-PSYTP=0) and material (EKPO-MATNR) is NOT blank, po quantity(EKPO-MENGE)  is calculated as below:
PO quantity (EKPO-MENGE) in MSAP = PO quantity (EKPO-MENGE) in GSAP - ( SUM of RECEIVED QTY - SUM of RETURNED qty)

Can you please suggest me,how to create and where i should map this logic.

Thanks you in advance

regards,

mahesh.

Accepted Solutions (0)

Answers (1)

Answers (1)

vijy_mukunthan
Active Contributor
0 Kudos

Hi Mahesh

  First you need to get the data of EKKO, EKPO, EKBE in your template table. Then it will be easy in my understanding you want to calculate the open quantity.

Please follow the above way.

Thanks and Regards

Vijay Mukunthan

Former Member
0 Kudos

Hi Vijay,

Thank you so much for replying.

Am already join in EKKO and EKPO after i need to join EKBE table,

So in EKBE table fields i need to calculate PO Quantity after output i need to join  in some other table.i want final report in one table.

for there fields i wan to calculate the PO Quantity (EKBE-EBELN,EKBE-EBELP,EKBE-BEWTP) for this condition.

Query 1:

Query=>Where clause

ifthenelse(EKPO.PSTYP =0,ifthenelse( EKPO.MATNR = '',EKPO.MENGE))

Quary 2:

Query=>Where clause

ifthenelse(EKPO.PSTYP =9,ifthenelse( EKPO.MATNR IS NOT '',EKPO.MENGE))

is it correct or not,please suggest me.

What about 3rd condition i.e

PO quantity (EKPO-MENGE) in MSAP = PO quantity (EKPO-MENGE) in GSAP - ( SUM of RECEIVED QTY - SUM of RETURNED qty).

Thanks in advance vijay.

Regards,

mahesh