Skip to Content

Print ECCN and HTS number on Customs Invoice in GTS

Hello Experts,

We have requirement to print ECCN and HTS on Customs Invoice. We are building logic using table CUHD, CIUT, CORREF, CORCTS, LEGCON but looks like its getting complex. Is there any FM available in GTS to achieve this or any enhanced logic to achieve this. Please help. Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 17, 2017 at 10:09 AM

    Hi Alok,

    There is no function module is available to fetch ECCN & HTS codes rather than provided tables by you.

    Let me know, where you feeling it is complexity..

    Thanks

    Venugopal

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks Venu for quick response. I want to fetch the ECCN/HTS based on Customs Declaration only but when I enter GUID_POBJ (from table CORREF based on GUID_CUIT) into table CORCTS, I don't get any data to pick CTSNUM. Hence I was thinking to first find Delivery Number of Customs Declaration and then find its custom document number from table CORREF then find its GUID_CUIT which can be used further IN table CORCTS to find CTSNUM. This CTSNUM can we use in table /SAPSLL/CTSNUM to find ECCN/HTS.

      This looks bit complex as multiple tables involved and also extra steps of fetching delivery customs document then to achieve this. So I think this will give me the ECCN assigned to Delivery Custom Document. Hope this is explained in simple. Please help

      Thanks,

      Alok kumar

  • Feb 21, 2017 at 03:49 AM

    Hi Experts,

    Can anyone help me on above posted query please?

    Regards,

    Alok Kumar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 01, 2017 at 09:12 PM

    Step1:

    Key in GTS document number (Customs declaration document ) in field CORDER table /SAPSLL/CUHD

    Step2:

    Get GUID from GUID_CUHD field from table /SAPSLL/CUHD

    Step 3:

    Key in the above copied GUID to table /SAPSLL/CUIT _GUID_CUHD

    Step4 :

    Get GUID from GUID_PR field from table /SAPSLL/CUIT

    Step 5:

    Key in the above copied GUID to table /SAPSLL/PRCTS_ GUID_PR

    Step6:

    Get country of departure key and country arrival key from step 1 and match the HTS Number scheme (STCTS) i.e

    Step7

    Get Number Scheme(STCTS) value from the above step and get GUID from GUID_CTSNUM for the same

    Step8

    Key in GUID and Number scheme (STCTS) from above step to table /SAPSLL/CTSNUM_ GUID_CTSNUM and /SAPSLL/CTSNUM_STCTS to get Harmonized Tariff Code (CCNGN)

    Please try above steps for HTS

    Add comment
    10|10000 characters needed characters exceeded