Skip to Content
avatar image
Former Member

SAP GTS RELEVANT TRANSPARENT TABLES

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 10, 2017 at 12:42 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 21, 2017 at 12:44 PM

    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.

    Add comment
    10|10000 characters needed 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