Please help me in this.
I have to write query as per following requirement.
To write this query i have to use '/ivl/' tables. Those tables and
fields also i am specifying here.
By passing document type, document (Bill of Entry) number and year to
table /IVL/ZMB_BEDUT, fetch the break up of custom duty from the field
ACTVALU for the respective duty code.
Here document type, document number and year are getting from
this table '/ivl/zmb_behdr'.
'ACTVALU , DUTCODE' are fields in '/IVL/ZMB_BEDUT'table.
In 'DUTCODE' these are duty codes ' BCD,CVD,ZCES,ZHCS,ZEDC,ZHDC,SAD'.
If you want to do hard coding for dutcode do it no problem.
Please give me the solution.