on ‎2013 Jul 01 2:29 PM
Hi Experts,
In my requirement i have to populate BILL_DATE from DSO table (ZSC_O0600),
key fields are: BILL_NUM
and BILL_ITEM
I am populating BILL_DATE into ZORIGIND
where BILL_NUM = ZSUBDOCN
BILL_ITEM =ZSUBDOCI
I am getting syntax error
E: No Component EXISTS WITH THE NAME "bill". "bill".
I declared the type but still coming.
Please check the code and recommend what can do.
Thanks
Pawan
Request clarification before answering.
Hi.
Please close the thread if your issue is solved.
Regards.
AL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
For Reference below code. Lookup the 3 fields data while updated to target.
data : wa_RESULT_PACKAGE type _ty_s_TG_1,
lt_lookup type table of ty_lookup,
wa_lookup type ty_lookup,
lv_tabix type sy-tabix.
BREAK-POINT.
* read table RESULT_PACKAGE into wa_result_package index 1.
if RESULT_PACKAGE is not initial.
select material distr_chan PROV_GROUP REBATE_GRP MAT_KONDM
from /BIC/AZDSO_MGR00
into table lt_lookup
for all entries in RESULT_PACKAGE
where MATERIAL = RESULT_PACKAGE-MATERIAL
and DISTR_CHAN = RESULT_PACKAGE-DISTR_CHAN.
if sy-subrc = 0.
sort lt_lookup by material distr_chan.
loop at RESULT_PACKAGE into wa_RESULT_PACKAGE.
lv_tabix = sy-tabix.
read table lt_lookup into wa_lookup with key
MATERIAL = wa_RESULT_PACKAGE-MATERIAL
DISTR_CHAN = wa_RESULT_PACKAGE-DISTR_CHAN binary search.
if sy-subrc = 0.
wa_RESULT_PACKAGE-PROV_GROUP = wa_lookup-PROV_GROUP.
wa_RESULT_PACKAGE-REBATE_GRP = wa_lookup-REBATE_GRP.
wa_RESULT_PACKAGE-MAT_KONDM = wa_lookup-MAT_KONDM.
modify RESULT_PACKAGE index lv_tabix from wa_RESULT_PACKAGE
transporting PROV_GROUP REBATE_GRP MAT_KONDM .
endif.
endloop.
endif.
endif.
Thanks,
Srinu.Rapolu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
As stated by Ethan you need to replace Bill item by Bill_item in your sort statement.
This will solve your issue.
Hope that helps.
Regards,
AL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Look at line 150. It ends with "BILL ITEM." and should probably by "BILL_ITEM."
Also, if you're using BW 7.3x, seriously consider using the provided DSO lookup rule type. It shouldn't be any slower and you won't get a syntax error if you don't use ABAP .
Cheers,
Ethan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 9 | |
| 7 | |
| 7 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.