problem with where join condition

[Former Member]

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.

[Former Member]

put that field in another variable with the required length

move the value in that variable

and then compare..

hope this helps.

[Former Member]

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

[Former Member]

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,

[Former Member]

>

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

[Former Member]

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,