Linking BSEG

[former_member807739]

Hi,

Currently I am using ekpo, ekko, eket, ekkn table in my report. Now I had a requirement like I need to get G/L account (HKONT) fron BSEG table.

Can any one please let me know how to link BSEG with any of the above tables.

Regards,

Cheritha

[former_member807739]

Hi Cheritha,

Tables BSEG and EKKO have BUKRS, LIFNR and KUNNR in commom.

So you can find a link beween these tables by searching for the Company Code (BUKRS), Vendor(LIFNR) and Customer(KUNNR).

Take these fields from one table (say EKKO) and go to the next table (BSEG).

Tables ekpo, ekko, eket, ekkn have EBELN in common.

Regards,

Harshada

[Former Member]

hi,

BSEG is Cluster Table so u cant link it with any table...

So fetch data from only this table in select query and then merge them with other data.. bacause u cant use join on cluster table

reward if usefulll

[Former Member]

Hello Cheritha-

You cannot join cluster table instead use index table if you are requiremnt is reg G/L open item use BSIS and for close use BSAS.

Cheers,

~Srini.....

[Former Member]

Hi Cheritha,

Tables BSEG and EKKO have BUKRS, LIFNR and KUNNR in commom.

So you can find a link beween these tables by searching for the Company Code (BUKRS), Vendor(LIFNR) and Customer(KUNNR).

Take these fields from one table (say EKKO) and go to the next table (BSEG).

Tables ekpo, ekko, eket, ekkn have EBELN in common.

Regards,

Harshada

[christine_evans]

There is no direct relationship between purchase orders held in EKKO etc and accounting documents held in BKPF, BSEG etc. So, it is not possible to do what you're suggesting you want to do. And anyway, you already have the PO GL account in EKKN-SAKTO.

There is a relationship between invoices raised against POs and accounting documents; you can see both from the PO history in ME23N. If this is what you're really wanting to get, try using ST05 SQL trace while viewing the PO history and you should be able to work out from the trace file how to get the data.

Edited by: Christine Evans on May 7, 2008 12:24 PM