cancel
Showing results for 
Search instead for 
Did you mean: 

Pending bills for purchase order.

Former Member
0 Kudos

Hai MM Consultants,

I am doing a report fro pending bills for all type of purchase orders.

i am using the following tables EKBE, EKBZ.

ekbe - for all type of movements and Grir cleared value.

ekbz - import purchace orders(asset) - only goods received

details are available.

that particular asset purchase order is cleared in fb03.

And the cleared value is available in BSEG.

Due to Performance issue i cant fetch data from BSEG.

Please advise me.

Regards,

P.Ravishankar.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Check this.

Table:BSIM

Field:DMBTR

regards

Former Member
0 Kudos

Hai Rahim,

Thanks For your Reply. i checked BSIM table. No Data. Table Entries found in BSEG and BSIS Tables.

My Input is Purchase Order Number. For particular PO. i can get relavent data from Bseg by giving PO. number as input.

But for BSIS table - thru Accounting Document Number only we can get the data.

This Accounting Number is different from BKPF Accounting doc no. accounting number(bsis) and bseg accounting number are same.

Bseg - po.no -> belnr ->dmbtr (amount)

bsis - belnr -> dmbtr (amt).

i cant get the link for bsis with PO number.

please advice me.

Ravi Shankar.

Answers (0)