topic Re: joining tables in Application Development and Automation Discussions

joining tables

Former Member — Mon, 23 Jul 2007 07:33:25 GMT

Hi,

could you tell which fields use to join tables: BKPF, LIKP and LIPS?

Regards,

Joanna

Re: joining tables

Former Member — Mon, 23 Jul 2007 08:20:04 GMT

Search for the common fields betwwne these tables..

Regards:

Sapna

Re: joining tables

Former Member — Mon, 23 Jul 2007 08:22:35 GMT

do you know where i could find scheme of sap tables?

regards,

Joanna

Re: joining tables

Former Member — Mon, 23 Jul 2007 09:47:59 GMT

Provide me with your email id. i will pass on the doc.

Cheers

Shafiq

Re: joining tables

Former Member — Mon, 23 Jul 2007 09:58:39 GMT

hi Shafiq,

my email: habla_habla(at)poczta.onet.pl

Regards,

Joanna

Re: joining tables

Former Member — Mon, 23 Jul 2007 10:22:56 GMT

thanks Shafiq it is helpful but i still don't know how to join tables: LIKP, LIPS, BKPF and BSEG. I need another table which allows me to do this but i can't find it.

Could someone hepl me?

Regards,

Joanna

Re: joining tables

Former Member — Mon, 23 Jul 2007 10:57:34 GMT

Try the VBRK table. This is a billing table connecting the delivery document number (VBELN) and the accounting document number (BELNR).

Cheers

shafiq

Re: joining tables

Former Member — Tue, 24 Jul 2007 08:57:44 GMT

VBRK-VBELN and LIKP-VBELN aren't the same values.

Has sameone another idea?

Regards,

Joanna

Re: joining tables

Former Member — Tue, 24 Jul 2007 09:32:21 GMT

LIKP and LIPS you can join with VBELn field

LIKP-VBELN = LIPS-VBELN

Why you wants to join these delivery tables with Accounting tables BKPF and BSEG?

for these delivery's a biiling doc is created (which is stored in VBRk and VBRP tables) and then an accounting documnet is created which enters into BKPF and BSEG tables

BSEG is a cluster table you can't join with BKPF though both of them have BELNR,GJHR and BUKRS as common fields

and most of the times you should not fetch the data from BSEG table

You can get the same data from BSID,BSAD(for customer and Billing doc related ), BSIK and BSAK (for Vendor and Pur order related) and BSIS,BSAS (for GL related)

so if you wants the link from LIKP,LIPS to BKPF and BSEG

first take the VBRP-VBELN by passing the LIPS-VBELn and LIPS-POSNR to VBRP-VGBEL and VBRP-VGPOS and take VBRP-VBELN

pass this VBRP-VBELN to BSEG table and tajke the belnr

but this i don't suggest

so be clear to join the tables based on the data you wants

instead you can use the above finance related tables

<b>Reward points for useful Answers</b>

Regards

Anji

Re: joining tables

Former Member — Tue, 24 Jul 2007 09:47:49 GMT

Hi,

I need data connected with weigh which is needed to be placed on the invoice. I need weigh of order. On invoice I have data like bkpf-belnr, bseg-buzei and values of each position but I can manage with joining this tables.

Regards,

Joanna

Re: joining tables

Former Member — Wed, 25 Jul 2007 07:23:33 GMT

Hi,

This is join between three tables:

Try this..Changes marked in bold..

SELECT vbrk_{vbeln vbrp}posnr uepos

fkimg kostl vrkme matnr pstyv kunag

vkorg vtweg knumv fkdat vbrk~erdat kunrg

INTO table it_inv

FROM vbrk

JOIN vbrp on

vbrk_{vbeln = vbrp}vbeln

INNER JOIN vbak

ON vbrp_{aubel = vbak}vbeln

for all entries in it_bkpf

WHERE vbrk~vbeln = it_bkpf-awkey and

vbrk~vbeln in s_vbeln and

fktyp = 'A' and

vbtyp = 'M' and

vbtyp = 'O' and

vkorg in s_vkorg and

vtweg in s_vtweg and

fkdat in s_bdate and

kunrg in s_kunrg and

kunag in s_kunnr and

kostl in s_kostl and

vbrk~spart in s_spart and

vstel in s_vstel and

werks in s_werks

AND vbak~bstnk IN s_bstnk

Reward points if contents are useful...

Regards,

Mandeep.

Re: joining tables

Former Member — Mon, 30 Jul 2007 10:01:17 GMT

Hi,

that is long select but it doesn't take weigh from lips or liks due to BSEG-BELNR what I need.

bkpf-awkey is not the same no what vbrk~vbeln.

Regards,

Joanna

Re: joining tables

former_member274444 — Tue, 05 Feb 2008 16:05:17 GMT

Hi Shafiq,

Can U send me this document?

this will be a goo help for me.

Regards,

Re: joining tables

former_member274444 — Tue, 05 Feb 2008 16:05:59 GMT

Hi Shafiq,

Can U send me this document?

this will be a goo help for me.

email: sergiogal8@hotmail.com

Regards.