Skip to Content
0
Former Member
Apr 20, 2007 at 05:50 AM

query

23 Views

Hi,

Hi,

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.

Query :

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.

Thanks