is there any link between tables bkpf and ekbe

[Former Member]

Hi All,

i have a doubt .what i want to display is invoice entry no , invoice entry date and invoice amount in my existing report .my report is mm releated.what is the flow and how can i get this.

my enduser showed me fields in me23n .in me23n we put p.o no then he clicked items details and then he selected purchase order history then he clicked on ir num next screen appeared there he clicked on follow-on-documents in that screen he showed document no and posting date .that fields he wants in his report as well as invoice amount .

Regards,

[former_member188685]

From EKBE you get the Material document and year, using this go to BKPF table with

AWKEY = concatenate materialdocument + year

AWTYP = 'MKPF'

you get the realtion between BKPF and EKBE.

[Former Member]

Hi,

ya there is a link between the two as shown below:

EKKO (Purch Doc Hdr)

EKPO (Purch Doc Item)----

---

EBAN (Req Item)

COOI (Commitmt Itm)--EKKN (Purch Doc Acct Asgmnt)----EBKN (Req Acct Asgmnt)

BKPF/BSEG (FI)----

---

EKBE (Purch Doc History)

PAYR (Payments)