topic Re: Regarding select query in Application Development and Automation Discussions

Regarding select query

Former Member — Fri, 16 Mar 2007 08:53:15 GMT

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?.

Re: Regarding select query

Former Member — Fri, 16 Mar 2007 08:59:06 GMT

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

Thanks

sasmita

Re: Regarding select query

Former Member — Fri, 16 Mar 2007 08:59:47 GMT

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

Re: Regarding select query

Former Member — Fri, 16 Mar 2007 09:01:16 GMT

link this way:

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

**reward if helpful

regards,

madhumitha

Re: Regarding select query

Former Member — Fri, 16 Mar 2007 09:02:51 GMT

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

Re: Regarding select query

Former Member — Fri, 16 Mar 2007 09:14:36 GMT

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.

Re: Regarding select query

sreeramkumar_madisetty — Fri, 16 Mar 2007 09:16:42 GMT

Loop at table1.

read table 2 with key mapping field.

statement.

Regards,

kumar

Re: Regarding select query

Former Member — Fri, 16 Mar 2007 09:22:05 GMT

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...

Re: Regarding select query

Azeemquadri — Fri, 16 Mar 2007 09:24:21 GMT

You can use subset of the field which is longer

Re: Regarding select query

Former Member — Fri, 16 Mar 2007 09:47:58 GMT

Thanks to all

Re: Regarding select query

Former Member — Tue, 30 Oct 2007 18:39:39 GMT

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