joining tables

[Former Member]

Hi,

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

Regards,

Joanna

[Former Member]

Search for the common fields betwwne these tables..

Regards:

Sapna

[Former Member]

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

regards,

Joanna

[Former Member]

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

Cheers

Shafiq

[Former Member]

hi Shafiq,

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

Regards,

Joanna

[Former Member]

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

[Former Member]

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

Cheers

shafiq

[Former Member]

Hi

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

Has sameone another idea?

Regards,

Joanna

[Former Member]

Hi

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

[Former Member]

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

[former_member274444]

Hi Shafiq,

Can U send me this document?

this will be a goo help for me.

Regards,

[former_member274444]

Hi Shafiq,

Can U send me this document?

this will be a goo help for me.

email: sergiogal8@hotmail.com

Regards.

[Former Member]

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.

[Former Member]

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