on 04-17-2008 7:47 AM
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.
Hi,
Check this.
Table:BSIM
Field:DMBTR
regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.