on 01-07-2011 6:38 PM
when ever table is displayed , the first column will be focused
Hi,
Here my problem is solved.
Thanks&Regards,
chiru.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.