topic Re: Select Logic in Application Development and Automation Discussions

Select Logic

Former Member — Fri, 20 Oct 2006 21:36:47 GMT

Hi,

Iam getting input PO, Company Code, Change date and changed user fields in selection screen. for this i have written this.

SELECT AEDAT EKGRP EBELN

BEDAT LIFNR WAERS

ERNAM FROM EKKO INTO TABLE GT_EKKO WHERE

EBELN IN SO_EBELN AND

BUKRS IN SO_BUKRS AND

EKGRP IN SO_EKGRP.

SELECT OBJECTID

USERNAME

UDATE FROM CDHDR INTO TABLE GT_HDR

FOR ALL ENTRIES IN GT_EKKO WHERE

OBJECTID EQ GT_EKKO-EBELN AND

OBJECTCLAS = 'EINKBELEG' AND

USERNAME IN SO_ERNAM AND

UDATE IN SO_ERDAT.

Problem is "OBJECTID" and "GT_EKKO-EBELN" does not have same length. how should i proceed.

Regards

Reddy

Re: Select Logic

Former Member — Fri, 20 Oct 2006 21:40:56 GMT

Hi ,

You can use the offset in the where condition to match the object id and the ebeln. For example if the ebeln starts at 4 position and ends at 14 position i.e 10 charecters you can use the where condition as

SELECT OBJECTID

USERNAME

UDATE FROM CDHDR INTO TABLE GT_HDR

FOR ALL ENTRIES IN GT_EKKO WHERE

<b>OBJECTID+3(10) EQ GT_EKKO-EBELN AND</b>

OBJECTCLAS = 'EINKBELEG' AND

USERNAME IN SO_ERNAM AND

UDATE IN SO_ERDAT.

Hope this helps.

Re: Select Logic

Former Member — Fri, 20 Oct 2006 21:43:30 GMT

Hi,

Try this...

DATA: BEGIN OF ITAB_OBJECTID OCCURS 0,

OBJECTID LIKE CDHDR-OBJECTID,

END OF ITAB_OBJECTID.

LOOP AT GT_EKKO.

ITAB_OBJECTID-OBJECTID = GT_EKKO-EBELN.

APPEND ITAB_OBJECTID.

ENDLOOP.

IF NOT ITAB_OBJECTID[] IS INITIAL.

SELECT OBJECTID

USERNAME

UDATE FROM CDHDR INTO TABLE GT_HDR

FOR ALL ENTRIES IN ITAB_OBJECTID WHERE

OBJECTID EQ ITAB_OBJECTID-OBJECTID AND

OBJECTCLAS = 'EINKBELEG' AND

USERNAME IN SO_ERNAM AND

UDATE IN SO_ERDAT.

ENDIF.

Thanks,

Naren

Re: Select Logic

Former Member — Fri, 20 Oct 2006 21:48:51 GMT

Hi Reddy,

Its good to have the same sequence as in DB table using WHERE CLAUSE. And seems u r missing CHANGE NO from CDHDR (I assume u r going to get details from CDPOS also)

SELECT OBJECTCLAS OBJECTID CHANGENR USERNAME UDATE

FROM CDHDR INTO TABLE GT_HDR

FOR ALL ENTRIES IN GT_EKKO WHERE

OBJECTCLAS = 'EINKBELEG' AND

OBJECTID EQ GT_EKKO-EBELN AND

USERNAME IN SO_ERNAM AND

UDATE IN SO_ERDAT.

Are you not able to get data from CDHDR based on ur data?