on 02-17-2017 9:41 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Experts,
Can anyone help me on above posted query please?
Regards,
Alok Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.