Home > IT Answers > SAP > Get PO using Accounting Document Number
Techieimran
0 pts.
 Get PO using Accounting Document Number
ABAP, SAP
Hi, I have to retrieve Purchasing Document(PO) using Material= Document(Accounting Document) based on Company Code from table= EKBE, but this table doesnt has company code column=2E Are there= any views related to this table or some other way to get PO?= Related scenarios welcomed Regards, Imran

Software/Hardware used:
ASKED: November 21, 2005  2:38 AM
UPDATED: November 22, 2005  4:23 AM
RELATED QUESTIONS
Answer Wiki:
Dear Imran bhai Can you elaborate on this like what is the transaction code for viewing the Accounting document/ P.O etc. For tables you must be using se11/or se16. Though I am not a functional consultant, I have played with lot of data modifications and retrival from tables. I think I will be able to help you once you furnish above. Regards Sanjay
Last Wiki Answer Submitted:  November 21, 2005  4:07 am  by  Sgb1480   0 pts.
All Answer Wiki Contributors:  Sgb1480   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

The P.O.# and Company Code is in table EKBE, see below:
Client 010
Purchasing doc. (EBELN) 7500052910
Company Code (BUKRS) 0600
Doc. category F
Vendor 100341
Document date 06/16/2000
Purch. group 16
Deletion ind. (LOEKK)
Plant 0610
Deletion ind. (LOEKZ)
Item 10
Trans./ev. type 2
Quantity 1.000
Debit/credit S

Dxhsfh
 0 pts.
 

I’m not totally sure what you are asking – but if you are first reading the Material Accounting Document(MKPF) – the document item table – MSEG does contain the company code (BUKRS)- unfortunately not a key. However, this is a transparent table not a cluster.

If you are just trying to read the PO data and want to read by company code – you could use the PO header table EKKO.

CAT0821
 35 pts.
 

Try View EKBI, hopefuly you are using a fairly plain vanilla SAP set up and the view is populated.

Good Luck.

PerryS
 0 pts.
 

Thx everyone for the response.

To put it more simpler, what I’m looking at is a view where I can get the PO, Company Code and the Accounting Document Number.

Regards,
Imran

Techieimran
 0 pts.