Regarding select query

[Former Member]

Hi,

There are two tables PRPS & VBAP

I am going to link this both table by.

PRPS-POSID = VBAP-PS_PSP_PNR.

The Data type of both the fields are different

POSID data Type is CHar24

PS_PSP_PNR data type is NUMC 8

selecting from vbap

for all entries of prps

where ps_psp_pnr = posid.

gives an error .

becouse of different data elements.

what should i do to run this query?.

[Former Member]

Hi

You need find out Primary key for joining 2 tables. otherwise it will show error.

Thanks

sasmita

[Former Member]

Hi,

I think the length and domain are different then joining will not work.

Instead of joinning these two tables, you can fetch the records from one table and make an internal table, and use the "for all entries" option.

Regards

R. Rengaraj

[Azeemquadri]

You can use subset of the field which is longer

[Former Member]

link this way:

<b>prps-posid = vbap-PS_PSP_PNR</b>

**reward if helpful

regards,

madhumitha

[Former Member]

Hi,

I think you will have equate PRPS-PSPNR = VBAP-PS_PSP_PNR and not

PRPS-POSID = VBAP-PS_PSP_PNR.

PSPNR field is the one holding the WBS Elements in the table PRPS.

regards,

Mahesh

[Former Member]

Vikram,

I come across the same problem when I was working for PS module.

The solution is,

U need to select the data from two individual tables based on the condition specified and then loop in one table, and read another table equating both the fileds, and if they are equal, consider that record.

Hope this may add a bit to u.

Regards,

Sujatha.

[sreeramkumar_madisetty]

Hi

U need to select the data from two individual tables based on the condition specified and then loop in one table, and read another table equating both the fileds, and if they are equal, consider that record.

like

Loop at table1.

read table 2 with key mapping field.

statement.

Regards,

kumar

[Former Member]

Hey ...do this way...

while retrieving details using prps make declare the length of the prps-posid in internal table as length of vbap-ps_psp_pnr...

and then by using for all entries pass the values by using internal table...

either ways u link u have to shift the declaration length which will be helpful...

[Former Member]

How do you declare the length of the prps-posid in the internal table as length of vbap-ps_psp_pnr???

[Former Member]

Thanks to all