Skip to Content
-2
Jun 22, 2020 at 11:20 AM

Avoid querying BSEG

253 Views

Hello,

I want to avoid hitting the BSEG table.

My requirement is to get the individual sum of line items in a given PO.

Is there any way that i can avoid querying BSEG table?

My queries are like below :

EKBE -->BKPF(awkey = belnr+year)-->BSEG table

1) Getting BELNR from EKBE .

2) And then using BELNR+GJAHR from EKBE to query the BKPF tables and get the BKPF-BELNR

3) Hit BSEG-BELNR (using above BKPF-BELR) and sum up different items.