topic problem with where join condition in Application Development and Automation Discussions

problem with where join condition

Former Member — Sat, 10 Jan 2009 09:46:35 GMT

Hi,

how to match in the where condition of different data types of different length.

I have problem here,vbuk-vbeln(10) and cdhdr-objectid(90).I need to check in where condition for joining

to get the information for username date time for the particular sales document.(vbak-vbeln).

regards,

nag.

Re: problem with where join condition

Former Member — Sat, 10 Jan 2009 09:53:23 GMT

put that field in another variable with the required length

move the value in that variable

and then compare..

hope this helps.

Re: problem with where join condition

Former Member — Sat, 10 Jan 2009 10:37:30 GMT

take the values of VBUK-VBELN.....put these into CDPOS...where objectid = vbuk-vbeln & tabname = 'VBUK'.....to get the change in item level.....now take those OBJECTID.......go to table CDHDR......and take the value that you require...

Re: problem with where join condition

Former Member — Mon, 12 Jan 2009 09:17:47 GMT

Hi ,

I think rather than using JOIN you can go for FOR ALL ENTRIES.

Firstly fetch all the resperctive values form VABK and put in a table that has a structure that is compatible with the next table of fetch CDHDR. ( as VBELN of length 90).

Then use this table to fetch the values from CDHDR.

Regards,

Radhika,

Re: problem with where join condition

Former Member — Mon, 12 Jan 2009 09:23:37 GMT


> I think rather than using JOIN you can go for FOR ALL ENTRIES.

Hi radhika,

Performance wise joins are far better than for all entries specially when the number opf entries is large, so better to use joins as much as possible.

кu03B1ятu03B9к

Re: problem with where join condition

Former Member — Mon, 12 Jan 2009 09:27:22 GMT

Hi,

Can you try as below

vbuk-vbeln = cdhdr-objectid+(10).

Means it will check first 10 characters of object id with VBUK-VBELN.

But make sure that first 10 characters of object id is equal to VBELN.

Thanks,