Skip to Content
0

Print ECCN and HTS number on Customs Invoice in GTS

Feb 17, 2017 at 09:41 AM

157

avatar image

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.

10 |10000 characters needed characters left characters exceeded

Hi Experts,

Can anyone help on this query please?

Regards,

Alok Kumar

0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

venu gopal Feb 17, 2017 at 10:09 AM
0

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

Show 1 Share
10 |10000 characters needed characters left 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

0
Alok Kumar Feb 21, 2017 at 03:49 AM
0

Hi Experts,

Can anyone help me on above posted query please?

Regards,

Alok Kumar

Share
10 |10000 characters needed characters left characters exceeded
A K V Mar 01, 2017 at 09:12 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded