cancel
Showing results for 
Search instead for 
Did you mean: 

set focus on table column

Former Member
0 Kudos

when ever table is displayed , the first column will be focused

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Here my problem is solved.

Thanks&Regards,

chiru.

Former Member
0 Kudos

For example Address data,

Select aadrnr bname1 bstreet bstr_suppl1 sb~tr_suppl2

bcity1 bpost_code from kna1 as a inner join adrc as b

INTO TABLE (uR TABLENAME)

on aadrnr eq badrnr

where a~kunnr eq knvp-kunn2

  • Material details..

Select matnr from KOTG001 INTO TABLE (UR TABLE naME)

where KSCHL = z001

and kunnr = xvbpa-kunnr

and DATBI GE sy-datum.

Select matnr from KOTG595 INTO TABLE (UR TABLE naME)

where kappl = '1A'

and KSCHL = z001

AND kunnr = xvbpa-kunnr

and DATBI GE sy-datum.

Select matnr from KOTG595 INTO TABLE (UR TABLE naME)

where kappl = '1B'

and KSCHL = z001

AND kunnr = xvbpa-kunnr

and DATBI GE sy-datum.

Former Member
0 Kudos

For Example,

To get item details, select a~matnr into table(ur program table name)

from mara as a inner join marc as b

on amatnr eq bmatnr

where werks eq marc-werks(your respective location )

and mtart eq 'ur material type'.

for ur reference, one more example,

Bonus information...

Build logic of OBJEK...

CONCATENATE MATNR BATCH INTO LV_OBJEK.

noW.

sELECT single CUOBj FROM inob into lv_cuobj(ur variable declaration

where obtab EQ MCH1

AND OBJEK EQ LV_OBJEK.

IF SY-SUBRC EQ 0.

SELECT single atinn atwrt from ausp into lv_atinn lv_atwrt(ur varibles)

where objek = lv_cuobj

ENDIF.