2007 Dec 10 1:00 PM
DEAR FRIENDS,
I HAVE TO GET DATA FROM BSEG TABLE ACCRODING FOLLOWING SELECTION DATA IN WHERE CONDITION MENTIONED IN BELOW QUERIES.
I HAVE DATA IN TEMP_VBRK BUT AFTER EXCUTING FOLLOWING QUEREY I AM GETTING ITAB_BSEG INITIAL. NO DATA.
WHILE SAME SELECTION DATA PUTTING IN SE16-BSEG,THEN I AM GETTING REQUIRED DATA.
I HAD TRY SOME DIFFERENT WAY ALSO BUT STILL GET NO DATA.
PLEASE SUGGEST POSSIBLE WAY OF SOLUTIONS.
**********************************
LOOP AT TEMP_VBRK.
READ TABLE ITAB_VBRK WITH KEY VBELN = TEMP_VBRK-VBELN.
IF SY-SUBRC EQ '0'.
TEMP_VBRK-BUKRS = '54'.
*TEMP_VBRK-VBELN = ITAB_VBRK-VBELN.
TEMP_VBRK-GJAHR = '2007'.
TEMP_VBRK-GSBER = 'MKTG'.
TEMP_VBRK-HKONT = '2711001'.
MODIFY TEMP_VBRK TRANSPORTING BUKRS GJAHR GSBER HKONT.
ENDIF.
ENDLOOP.
*getting data from bseg
IF NOT TEMP_VBRK[] IS INITIAL.
SELECT BUKRS BELNR GJAHR SHKZG GSBER WRBTR PSWSL VBELN HKONT KUNNR
ZFBDT FROM BSEG INTO CORRESPONDING FIELDS OF TABLE ITAB_BSEG
FOR ALL ENTRIES IN TEMP_VBRK
WHERE BUKRS = TEMP_VBRK-BUKRS
AND BELNR = TEMP_VBRK-VBELN
AND GJAHR = TEMP_VBRK-GJAHR
AND GSBER = TEMP_VBRK-GSBER
AND HKONT = TEMP_VBRK-HKONT.
ENDIF.
2007 Dec 10 1:52 PM
Hi Ricky,
Just check what is value being passed for BELNR field. If this is less than 10 chars then use FM CONVERSION_EXIT_ALPHA_INPUT for this field while populating table temp_vbrk.
then try the same once. I hope this is the issue because of the conversion exit.
Thanks,
Lalit
Hi Ricky,
Just check what is value being passed for BELNR field. If this is less than 10 chars then use FM CONVERSION_EXIT_ALPHA_INPUT for this field while populating table temp_vbrk.
then try the same once. I hope this is the issue because of the conversion exit.
Thanks,
Lalit
2007 Dec 10 1:52 PM
Hi Ricky,
Just check what is value being passed for BELNR field. If this is less than 10 chars then use FM CONVERSION_EXIT_ALPHA_INPUT for this field while populating table temp_vbrk.
then try the same once. I hope this is the issue because of the conversion exit.
Thanks,
Lalit
2007 Dec 10 2:05 PM
2007 Dec 10 2:11 PM
hi Ricky,
change this line:
TEMP_VBRK-HKONT = '2711001'.
to:
TEMP_VBRK-HKONT = '0002711001'.
ec
2007 Dec 10 2:36 PM
Hi Eric,
Thanks for your valuable advise.It's really help me out.
Thanks a lot.
Please give me ur email id so further I can ask you dout.
| User | Count |
|---|---|
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |