Skip to Content
0

SAP GTS RELEVANT TRANSPARENT TABLES

Sep 09, 2017 at 08:56 AM

84

avatar image
Former Member

Can anyone help to advise the SAP GTS relevant transparent table to store the customs delarance doc data. Thanks.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Dave Willis Sep 10, 2017 at 12:42 PM
0

Hi Binghong Hu,

It's not a simple answer. The header data is recorded in table /SAPSLL/CUHD, but you should take a look at dictionary structure /SAPSLL/CUHD_OBJ_S to assess the complexity of the hierarchy. The sub-structures there point to the other transparent tables involved. Unless you are quite experienced, I suggest that you should find someone else who is.

Regards,
Dave

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Sep 21, 2017 at 12:44 PM
0

I am GTS consultant as green hand. I need to find the tables which store item details-general data(such as Duty Quantity and Uom fields.) Can you help. thanks.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Binghong,

If you`re new to GTS and want to immediately understand the underlying data model it wont be easy :) but hopefully you understand the classic relational database concepts, ie foreign key, etc., which is all you need.

As Dave mentioned, the main table is the //CUHD table ( I`ll replace the namespace /sapsll/ with // for better readability )

Lets consider this //CUHD (CUstoms document HeaDer ) table as primary table, where the key to secondary tables is the GUID of the declaration (GUID_CUHD, first field of //CUHD table). The key is the GUID, not document number, like in classic ECC modules like SD, this can take some time to get used to, but its actually simpler.

A small shortlist of what you seem to be looking for:

- //LEGCULC - Duty calculation, for getting details for a particular declaration, you need to join/link with //CUHD-GUID_CUHD on GUID_MOBJ field

- //CUIT - Item level information, for getting details for a particular declaration, you need to join/link with //CUHD-GUID_CUHD on GUID_MOBJ field

Its a bit of a deep dive, but hopefully it helps.

Regards,

Branio

0