on 02-13-2006 6:49 PM
Hi
I need to populate one field (VBKUM From MBEW) into custom developed datasource.But it has reference table MARA and reference field MEINS.
Can anyone exlpain me procedure.
Thanks
Suma
You can follow the following path:
1. Go To SAP R/3 TCODE-RSA6
2. Open the SAP R/3 Tab & select the module & the masterdata extractor name for ex.MM -> MM-IO ->0VENDOR_ATTR
3. Double click on it. It will show you the extract structure name under "ExtractStru" as BIW_LFA1_S.
4. Double click on it or copy the name & open SE11 & paste the name open the structure.
5. There you can find append structure field name in ZZ. i.e all append structure fields should start with ZZ as prefix.
6. To find the source field you have to go to CMOD.
7. Provide the project name which is created.
8. Then select the "Enhancement components" option.
9. Click on display button.
10. Select the function exits "Exit_SAPLRSAP_002" it will open the include program "include zxrsau02".
11. Double click on "zxrsau02".
12.You will find the case program with datasource name.
13.Choose your master datasource & check the table names & the logic
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Suma,
try steps
- rsa6 (or rso2 if generic) -> choose your data source, click enhance structure -> in next screen of the structure, click 'append structure'. system will propose structure name, just accept. in new structure, add field zzvbkum and zz[name you want] e.g zzmeins. component/type for zzvbkum use same as vbkum and zzmeins use same as meins. then reference for zzvbkum fill with append structure and field with zzmeins.
- maintain datasource again, remove 'hidden' from that 2 new fields, save datasource.
- transaction cmod, create new project and assign enhancement rspa0001. double click exit_...002, and double click 'zxrsau02', create new, will prompt something sap reserved name, just press enter.
- in zxrsau02 fill with code
data : l_s_ds like [your data source extract structure],
l_vbkum like mbew-vbkum,
l_meins like mara-meins,
l_tabix like sy-tabix.
case i_datasource.
when 'your datasource name'
loop at c_t_data into l_s_ds.
l_tabix = sy-tabix.
select single vbkum meins into l_vbkum l_meins
from mbew
where [condition, field = l_s_ds-fieldname ....].
if sy-subrc = 0.
l_s_ds-zzvbkum = l_vbkum.
l_s_ds-zzmeins = l_meins.
modify c_t_data from l_s_ds index l_tabix.
endif.
endloop.
endcase.
hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.