Link Between bsak,bsik & bseg,bkpf

[nayanlad]

Dear Experts,

i need PO number EBELN for one report.

problem is it stores while MIRO in BSEG/BKPF and

Account doc.no stores in BSAK/BSIK.

So, i need link between BSIK/BSAK and BSEG/BKPF

please help as soon as possible

thanks

Nayan Lad

Edited by: Nayan Lad on Sep 17, 2008 9:50 AM

[Former Member]

Hi,

The link is the Accounting Documnet Number - BELNR.

Thanks,

Ruthra

[nayanlad]

no but if BELNR is not matching in this perticular case then what do u do ?

[Former Member]

Hi

The link for all the tables is you have bukrs(company code), belnr(Accounting document Number). I think u got the link.

Still if u have problem revert back

Regards,

Kasuladevi Srinivas

[nayanlad]

Ya still have a problem,

bcoz doing MIRO the number which genrated it is not a Accounting docno. so in bkpf it is a doc. no.

and doing F-44,F-48 which genrated is the actual accountno.

now both BELNR are diffrent then what to do ?

[former_member181995]

Hkont.But you should take care with BELNR GJAHR also as this is key.

[former_member387317]

Hi Nayan Lad,

Relation between BSIK BKPF and BSAK is as below...

BUKRS is common Field in all tables...

BSIK-AUGDT == BKPF-BLDAT == BSAK-AUGDT

BSIK-AUGBL == BKPF-BELNR == BSAK-AUGBL

GJAHR Is common field in all tables...

BSIK-BELNR == BKPF-DBBLG == BSAK-BELNR....

Also BSEG contains

BUKRS

BELNR

GJAHR

AUGDT

AUGBL

Try to relate it by seeing data inside tables...

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

[Former Member]

Hi Nayan,

Correct me if I am wrong.

When you do a MIRO there is always an accounting document generated for which you have an ebtry in BKPF(header) and BSEG(Items). These entries can also be found in MKPF and MSEG.

F_44(Clearing Vendor) - This mostly comes into pictuere when you have payed vendor in advance so I think there is generation of new document number. This can be cleared itseld in MIRO or its can be done in F-44.

In all case the link is document number.

BKPF, BSEG- belnr

MKPF, MSEG- mblnr, here you can also find PO number easily(ebeln)

BSAK, BSIK- reference doc number(no SAP access so could'nt find the field name)

Regards

Vijai