06-10-2008 9:18 AM
Hi All,
i_dfkkko-xblnr
IF NOT i_dfkkko[] IS INITIAL .
SELECT opbel
belnr
FROM erchc
INTO TABLE i_erchc1
FOR ALL ENTRIES IN i_dfkkko
WHERE opbel EQ i_dfkkko-xblnr.
ENDIF.
I am using the above select query.problem is when i put the value
of i_dfkkko-xblnr by going to the table erchc i am getting the record.But this qury is not resulting any value.
i have checked in debug mode copied the value of xblnr of i_dfkkko
and went to erchc table and passed to opbel of erchc i got the reords.
can anybody pls help..
Rgds,
Sai
06-10-2008 9:22 AM
Hi,
IF NOT i_dfkkko[] IS INITIAL .
SELECT opbel
belnr
FROM erchc
INTO CORRESPONDING FIELDS OF TABLE i_erchc1
FOR ALL ENTRIES IN i_dfkkko
WHERE opbel EQ i_dfkkko-xblnr.
ENDIF.
Thanks & Regards,
Vallamuthu.M
06-10-2008 9:35 AM
Hi,
I tried using 'corresponding fields of' ,that is also not working..
Rgds,
Sai
06-10-2008 9:23 AM
Hi,
IF NOT i_dfkkko[] IS INITIAL .
SELECT opbel
belnr
FROM erchc
INTO *CORRESPONDING FIELDS OF* TABLE i_erchc1
FOR ALL ENTRIES IN i_dfkkko
*WHERE opbel = i_dfkkko-xblnr.*
ENDIF.
Please reward points if it helps
Thanks
Vikranth
06-10-2008 9:29 AM
Hi,
OPBEL and XBLNR both have different lengths. So FOR ALL ENRIES will fail .
06-10-2008 9:37 AM
Hi,
I have defined i_dfkkko like below.
TYPES : BEGIN OF ty_dfkkko,
opbel LIKE dfkkko-opbel,
xblnr(12),
herkf LIKE dfkkko-herkf,
budat LIKE dfkkko-budat,
END OF ty_dfkkko.
Rgds,
Sai
06-10-2008 9:39 AM
HI,
The fields XBLNR and OPBEL or not having same length, please check once. Try to change the field declaration in temp internal table for field XBLNR and move i_dfkkko values to temparary table then use for all entries addition on temp table and also check the below code
SELECT belnr
LFDNR
OPBEL
FROM erchc
INTO TABLE i_erchc1
FOR ALL ENTRIES IN i_dfkkko
WHERE opbel = i_dfkkko-xblnr.
ENDIF.
When ever you want to use for all entries addition then try to retrieve all primary keys, because the for all entries addition would work like select and delete adjacent duplicates.
Rgds,
Bujji
06-10-2008 9:40 AM
Hi,
The database would be having the value with leading zeroes.
Use FM "CONVERSION_EXIT_ALPHA_INPUT" to conver the values & then pass to select query.
_dfkkko-xblnr
IF NOT i_dfkkko[] IS INITIAL .
loop at i_dfkkko.
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
EXPORTING
VALUE(INPUT) = i_dfkkko-xblnr
IMPORITNG
VALUE(OUTPUT) = i_dfkkko-xblnr.
modify i_dfkkko.
endloop.
SELECT opbel
belnr
FROM erchc
INTO TABLE i_erchc1
FOR ALL ENTRIES IN i_dfkkko
WHERE opbel EQ i_dfkkko-xblnr.
ENDIF.
06-10-2008 9:58 AM
Hi,
I have deleted the leading zeroes,but still the same problem...
Rgds,
Sai