on 02-14-2018 2:16 PM
Hello SAP Gurus,
Our client requirement was to extract report for number of items submitted to customs in calendar year either as import declarations or export declarations. Is this kind of report exist in standard GTS? or we need to write a query. please advice.
Thanks in advance
Best Regards
Swathi
Hi Swathi,
If you want a report showing the Declarations and Items, then use Transactions /SAPSLL/CULO_CUS_IMP and /SAPSLL/CULO_CUS_EXP.
But if you need a count (total) of the items, for some reason, then you will need to build your own query. Join tables /SAPSLL/CUHD and /SAPSLL/CUIT where /CUIT-GUID_CUHD = /CUHD-GUID_CUHD. You can restrict using the Declaration Type in field CUHDA (for example, CULOEX for Export Declarations). As the total number of records are not shown in the query, you would need to export the results to a spreadsheet.
Hope that helps.
Regards,
Dave
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Swathi
for import, you can use the standard report
/N/SAPSLL/CUHD_CUS_IMP
for export, i donot find any stabdard report, you can create a query for this.
Santosh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
10 | |
3 | |
1 | |
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.