SAP GTS Tables

SAP GTS Tables for business partners, Product masters, License masters, embargo, Sanction Party List, compliance documents, customs declaration documents and preference management. etc.

SAP GTS Tables for Business Partner Master Data

SAP GTS Table For Business Partner General, Bank, Payment Data

1. BUT000:- BP: General data
2. BUT030:- BP Usages
3. BUT0BANK:- Business Partner: Bank Data
4. BUT0BK:- BP: Bank Details
5. BUT0CC:- BP: Payment Cards
6. BUT100:- BP: Roles table.

SAP GTS Tables for Business Partner Identification

1. /SAPSLL/ADRLRID:- GTS table Identification Numbers for Address in Business Partner
2. /SAPSLL/BPADDR – Addresses for Business Partner Screening
3. BUT0IS:- BP: Industries table stores the Industry and Industry System.
4. BUT0ID:- BP: ID Numbers which store Identification Type and Identification number.

SAP GTS Tables For Business Partner Address

1. BUT020:- SAP GTS Table store BP: Addresses store business partner address numbers.
2. ADRC:- Addresses (Business Address Services) stores details of address against address number.
3. /SAPSLL/ADRCMP:- Prepared Address for Address Comparison
4. /SAPSLL/BPADDR:- Addresses for Business Partner Screening

SAP GTS Tables For Business Partners Other SAP GTS Tables

1. /SAPSLL/TMPBPI:- Assign BP ID Type to an External Identification Scheme
2. /SAPSLL/PNTBP:- Legal and Logistics Services: Mapping of Business Partners table stores the partner number and business partner type of these parties. table plays a critical role in the SAP GTS module by providing a central repository of information about the parties involved in cross-border trade transactions.
3. /SAPSLL/TPABP:- Legal & Logistics Services: Business Partner – Control Setting of SPL

SAP GTS Tables For Product Master Data

1. /SAPSLL/PR:- Product Master
2. /SAPSLL/PNTPR:- Legal and Logistics Services: Product Master Mapping
3. /SAPSLL/PRUOM:- Legal & Logistics Services: Product Master – Units
4. /SAPSLL/PRGEN:- GTS: Product Master: Generic Characteristic Values
5. /SAPSLL/PRCTR:- Product Master: Authority/Country Data
6. /SAPSLL/PRCTS:- Product Master – Global Customs Tariff Numbers
7. /SAPSLL/PRCTSC:- Product Master – Country-Specific Customs Tariff Numbers
8. /SAPSLL/PRDOC:- Product Master: Documents / Verifications
9. /SAPSLL/PRECIP:- Product Master: Documents / Verifications

SAP GTS License Master Data Tables

1. /SAPSLL/LCLIC:- Legal Control: License Header
2. /SAPSLL/LCLICA:- Legal Control: Other License Attributes
3. /SAPSLL/LCLICB:- GTS: License – Banks
4. /SAPSLL/LCLICC:- Legal Control – Licenses – Control Classes
5. /SAPSLL/LCLICCO:- Legal Control: License – Application Data
6. /SAPSLL/LCLICCQ:- Legal Control: License – Quantities per Component
7. /SAPSLL/LCLICCQU:- License – Quantities Taken per Component
8. /SAPSLL/LCLICE:- SLL: Legal Control: License – Restitution
9. /SAPSLL/LCLICF:- SLL: Legal Control: License – Prefixation
10. /SAPSLL/LCLICG:- Legal Control – Licenses – Business Transaction Type
11. /SAPSLL/LCLICH:- SLL: Legal Control: – License – Peculiarity Code
12. /SAPSLL/LCLICI:- Legal Control – Licenses – Import Code Number
13. /SAPSLL/LCLICK:- GTS: License – Terms of Payment
14. /SAPSLL/LCLICL:- Legal Control: Licenses – Countries
15. /SAPSLL/LCLICM:- Legal Control – Licenses – Materials
16. /SAPSLL/LCLICN:- SLL Legal Control: License – CAP Numbers
17. /SAPSLL/LCLICO:- Legal Control: Licenses – Org. Units
18. /SAPSLL/LCLICP:- SLL: Legal Control: License – Procedures
19. /SAPSLL/LCLICQ:- Legal Control: Licenses – Quantities
20. /SAPSLL/LCLICAQ:- Legal Control: License Change Log: Available Quantity, GTS Table stores the remaining available quantity per component based on the depreciation level.
21. /SAPSLL/LCLICR:- SLL: Legal Control: License – Country Groups
22. /SAPSLL/LCLICS:- Legal Control: Licenses – Statuses
23. /SAPSLL/LCLICU:- Legal Control: Licenses – Legal Units
24. /SAPSLL/LCLICV:- SLL: Legal Control: License – Values
25. /SAPSLL/LCLICAV:-Legal Control: License: Available Quantity
26. /SAPSLL/LCLICAVL:- License: Change Log of Available Quantity
27. /SAPSLL/LCLICCV:- Legal Control: License – Values per Component.
28. /SAPSLL/LCLICCVU:- License – Values Taken per Component
29. /SAPSLL/LCLICW:- Legal Control – Licenses – Commodity Code
30. /SAPSLL/LCLICY:- GTS: License – Documents
31. /SAPSLL/LCLICZ:- GTS: License – Access Codes
32. /SAPSLL/LCLICVUS:- Legal Control: Licenses – Values Allocated to Sales Order
33. /SAPSLL/LCLICH:- SLL: Legal Control: – License – Peculiarity Code
34. /SAPSLL/LCLICJ:- License – Projects
35. /SAPSLL/LCLICPT:- Processing Trade: Relationship of Merged Products
36. /SAPSLL/LCLICPTB:- Processing Trade: BOM of Merged Products
37. /SAPSLL/LCLICPTM:- Processing Trade: Information About Merged
38. /SAPSLL/LCLICPTP:- Processing Trade: Node Assignments
39. /SAPSLL/LCLICPTT:- P/T: Tariff Number Attributes for Merged Products
40. /SAPSLL/LCLICQ Legal Control: Licenses – Quantities
41. /SAPSLL/LCLICQUS Legal Control: Licenses – Quantities Allocated
42. /SAPSLL/LCLICX:- GTS: License Master – Documents for Letter of Credit
43. /SAPSLL/LEGCON:- Legal Control – Document

How To Find the License number on the basis of the document using SQVI

How to Find the Total Quantity or Total Value of any License using Table.

SAP GTS Tables For Embargo

1. /SAPSLL/CEEMB Country of Departure/Destination (Embargo)
2. /SAPSLL/V_AEMB01 Activate Legal Regulation: Country Level
3. /SAPSLL/V_AEMB02 Activate Legal Regulation: Country/Country Level
4. /SAPSLL/V_AEMB03 Activate Legal Regulation: Country/Country Group Level
5. /SAPSLL/V_AEMB11 Activate Legal Regulation: Country Group Level
6. /SAPSLL/V_AEMB12 Activate Legal Regulation: Country Group/Country Level
7. /SAPSLL/V_AEMB13 Activate Legal Regulation: Ctry Group/Ctry Group Level
8. /SAPSLL/V_AEMB6G “Embargo Check” Service: Activate Legal Regulations
9. /SAPSLL/V_ARGEMB “Embargo Check” Service: Activate Legal Regulations
10. /SAPSLL/V_CEEMB Embargo Check: Legal Regulation/Ctry of Origin/Destin.
11. /SAPSLL/V_T6GEMB Control Settings for Embargo Check
12. /SAPSLL/V_TLHEMB Activation: “Embargo Check” Service
13. /SAPSLL/V_TLIEMB Activation: “Embargo Check” Service
14. /SAPSLL/V_TLSEMB Embargo Check: Determine Active Legal Regulations

SAP GTS Tables for Sanction Party List

SPL Master and Transactional Tables

1. /SAPSLL/SPLAT Optimized Audit Trails for Partners, Docs and Ext. Address
2. /SAPSLL/SPLATA Optimized Audit Trails for General Addresses
3. /SAPSLL/SPLATM Optimized Audit Trail: Matched Terms
4. /SAPSLL/SPLAUD Legal Control – SPL – Audit
5. /SAPSLL/SPLAUDD Legal Control – SPL – Audit: Details
6. /SAPSLL/SPLAUDF Audit Trail for SPL – FTORG Assignment
7. /SAPSLL/SPLAUDK Legal Control – SPL – Audit: Comments
8. /SAPSLL/SPLAUDM Audit Trail SPL Screening – Matched Search Terms
9. /SAPSLL/SPLAUDR Audit Trail for SPL Screening – Additional Object Reference
10. /SAPSLL/SPLCTD Legal Control – SPL – Control Data for Comparison: Detai
11. /SAPSLL/SPLCTR Legal Control – SPL – Control Data for Comparison
12. /SAPSLL/TSPL Legal & Logistics Services: LC: SPL Master (Header Data)
13. /SAPSLL/TSPLA Legal Control: SPL Master (Address Data)
14. /SAPSLL/TSPLAK Legal Control: SPL Master (Address Data) – Keywords
15. /SAPSLL/TSPLB SPL Master (Dates of Birth)
16. /SAPSLL/TSPLI SPL Master (Identifications)
17. /SAPSLL/TSPLIDX TREX Index ID for Sanctioned Party List Screening
18. /SAPSLL/TSPLN Legal Control: SPL Master (Name Data)
19. /SAPSLL/TSPLNK Legal Control: SPL Master (Name Data) – Keywords
20. /SAPSLL/TSPLR Sanctioned Party List Master (References)
21. /SAPSLL/TSPLTRX TREX Index ID for Sanctioned Party List Screening (Delta
22. /SAPSLL/TSPLUI Use Conventional SPL UI for User

SPL Configurational GTS Tables

1. /SAPSLL/V_ARGSPL “SPL Screening” Service: Activate Legal Regulations
2. /SAPSLL/V_ASPL01 Activate Legal Regulation: Country Level
3. /SAPSLL/V_ASPL02 Activate Legal Regulation: Country/Country Level
4. /SAPSLL/V_ASPL03 Activate Legal Regulation: Country/Country Group Level
5. /SAPSLL/V_ASPL11 Activate Legal Regulation: Country Group Level
6. /SAPSLL/V_ASPL12 Activate Legal Regulation: Country Group/Country Level
7. /SAPSLL/V_ASPL13 Activate Legal Regulation: Ctry Group/Ctry Group Level
8. /SAPSLL/V_ASPL6G “SPL Screening” Service: Activate Legal Regulations
9. /SAPSLL/V_SPLCTD Sanctioned Party List Screening: Comparison Control – De
10. /SAPSLL/V_SPLCTR Sanctioned Party List Screening: Comparison Control
11. /SAPSLL/V_T6GSPL Legal Control: Control Settings for “SPL Screening” Serv
12. /SAPSLL/V_TLHSPL Activation: “Sanctioned Party List Screening” Service
13. /SAPSLL/V_TLISPL GTS: Activate Service ‘Sanctioned Party List’
14. /SAPSLL/V_TLSSPL SPL Screening: Determine Active Legal Regulations
15. /SAPSLL/V_TLZSPL GTS: Assignm.of Timezone to DateType f.Sanctioned Party

SAP GTS Tables For Customs Document

1. /SAPSLL/CORREF:- Reference Data table stores GUI object key with respect to feeder system document number.
2. /SAPSLL/CUHD:- Customs Document: Header
3. /SAPSLL/CUIT:- Customs Document: Item
4. /SAPSLL/CUCAAR:- GTS Toll Types
5. /SAPSLL/CUCAART:- SLL Toll Types – Description
6. /SAPSLL/CUCAFA:- GTS Requested Concession
7. /SAPSLL/CUCAFAT:- GTS Description of Requested Concession
8. /SAPSLL/CUCAGG:- GTS Tax Assessment Duty Group
9. /SAPSLL/CUCAGGT:- GTS Tax Assessment Duty Group – Description
10. /SAPSLL/CUCAOR:- Reason for Rejection
11. /SAPSLL/CUCAORT:- Reason for Rejection – Description
12. /SAPSLL/CUCAPR GTS:- Additional Procedure
13. /SAPSLL/CUCAPRT SLL:- Additional Procedures – Description
14. /SAPSLL/CUCARC:- Area Code
15. /SAPSLL/CUCARCT:- Area Code – Description
16. /SAPSLL/CUCARQ:- Assignment of Document Code – Document
17. /SAPSLL/CUCARQT:- Assignment of Document Code – Document Description
18. /SAPSLL/CUCBMS:- GTS Tax Assessment Measure
19. /SAPSLL/CUCBMST:- GTS Tax Assessment Measure – Description
20. /SAPSLL/CUCCAT:- Goods Category
21. /SAPSLL/CUCCATT:- Goods Category – Description Text
22. /SAPSLL/CUCCNR:- Reason for Cancellation
23. /SAPSLL/CUCCNRT:- Reason for Cancellation – Text
24. /SAPSLL/CUCCPG:- Container Status
25. /SAPSLL/CUCCPGT:- Container Status- Text
26. /SAPSLL/CUCCTY:- Country Code
27. /SAPSLL/CUCCTYT:- SLL: Country Key – Description
28. /SAPSLL/CUCCUR:- Currency Code
29. /SAPSLL/CUCCURT:- SLL: Currency Key – Description
30. /SAPSLL/CBCMH:- Monitoring of Communication with Customs Broker – Header
31. /SAPSLL/CORPAR:- Document Partner
32. /SAPSLL/LEGCULC:- SLL: Customs Document: Customs Processing: Duties
33. /SAPSLL/LEGCUS:- Customs Document: Customs Management
34. /SAPSLL/LEGPLO:- Customs Document: Seals
35. /SAPSLL/CUCDAD Definition of Customs Duty Types
36. /SAPSLL/CUCDADM Mapping of Customs Duty Types
37. /SAPSLL/CUCDADT Definition of Customs Duty Types: Text Tab
38. /SAPSLL/CUCDC GTS: Type of Registration for Global Trade
39. /SAPSLL/CUCDCT GTS: Description of Registration Type for
40. /SAPSLL/CUCDST Type of Destination
41. /SAPSLL/CUCDSTT Type of Destination – Name
42. /SAPSLL/CUCEQS Transport Equipment Type
43. /SAPSLL/CUCEQST Type of Transport Equipment
44. /SAPSLL/CUCEQT Type of Transport Equipment
45. /SAPSLL/CUCEQTT Type of Transport Equipment
46. /SAPSLL/CUCEVI Type of Index
47. /SAPSLL/CUCEVIT Type of Index – Description
48. /SAPSLL/CUCEXP Explanation
49. /SAPSLL/CUCEXPT Explanation – Text
50. /SAPSLL/CUCFDP FDA Package Types
51. /SAPSLL/CUCFDPT FDA Package Types – Name
52. /SAPSLL/CUCGUC Constellation of Guarantors
53. /SAPSLL/CUCGUCT Constellation of Guarantors – Text
54. /SAPSLL/CUCIND GTS: Customs Processing Indicator
55. /SAPSLL/CUCINDT GTS: Customs Processing Indicator
56. /SAPSLL/CUCINR Reason for Interruption
57. /SAPSLL/CUCINRT Reason for Interruption – Description
58. /SAPSLL/CUCLOC Locations, Coded
59. /SAPSLL/CUCMAP GTS: Mapping of Objects from Customs Code
60. /SAPSLL/CUCMAQ Default Qualifier for Measure Type ID
61. /SAPSLL/CUCMES Message Codes
62. /SAPSLL/CUCMEST Message Code Names
63. /SAPSLL/CUCMOT SLL: Type of Means of Transport
64. /SAPSLL/CUCMOTT SLL: Description of Type of Transport
65. /SAPSLL/CUCMTR SLL: Mode of Transport
66. /SAPSLL/CUCMTRT SLL: Description of Type of Transport
67. /SAPSLL/CUCNGA SLL: Range of Goods
68. /SAPSLL/CUCNGAT SLL: Range of Goods – Description
69. /SAPSLL/CUCORG Type of Departure
70. /SAPSLL/CUCORGT Type of Issue – Name
71. /SAPSLL/CUCPAQ Assignment: Type of Document / Qualifier
72. /SAPSLL/CUCPAS Assign Document to Communication Process
73. /SAPSLL/CUCPAT SLL: Documents/Preliminary Documents
74. /SAPSLL/CUCPATT SLL: Description of Preliminary Document Type
75. /SAPSLL/CUCPAV Link: Procedure / Additional Procedure
76. /SAPSLL/CUCPCL Temporary Storage Locations
77. /SAPSLL/CUCPOP Issuing Authority
78. /SAPSLL/CUCPOPT Issuing Authority Name
79. /SAPSLL/CUCPQU Qualifier of Document
80. /SAPSLL/CUCPQUT Qualifier of Document – Name
81. /SAPSLL/CUCPRO GTS: Place into a Customs Status
82. /SAPSLL/CUCPROT GTS: Place into a Customs Status – Descrip
83. /SAPSLL/CUCPRS Assign Procedures by Process / Legal Regul
84. /SAPSLL/CUCPRT Processing Type
85. /SAPSLL/CUCPRTT Processing Type – Description
86. /SAPSLL/CUCPST Status of a Document
87. /SAPSLL/CUCPSTT Status of a Document – Name
88. /SAPSLL/CUCPTY Package Types
89. /SAPSLL/CUCPTYT SLL: Package Types – Description
90. /SAPSLL/CUCPYT SLL: Payment Methods
91. /SAPSLL/CUCPYTT SLL: Description of Payment Methods
92. /SAPSLL/CUCRCD Definition: Reason for Reconciliation Summ
93. /SAPSLL/CUCRCDT Text Table for /SAPSLL/CUCRCD
94. /SAPSLL/CUCRCM Mapping: Reason for Change to Duty Type
95. /SAPSLL/CUCRES SLL: Customs Control Results
96. /SAPSLL/CUCREST SLL: Description of Customs Control Result
97. /SAPSLL/CUCRPD GTS: Type of Registration for Process Acti
98. /SAPSLL/CUCRPS GTS: Assign Customs Status per Process/Leg
99. /SAPSLL/CUCSLT SLL: Fastening Types
100. /SAPSLL/CUCSLTT SLL: Description of Fastening Types
101. /SAPSLL/CUCST GTS: Customs Status
102. /SAPSLL/CUCSTA SLL: Customs Status of Goods
103. /SAPSLL/CUCSTAT SLL: Description of Customs Status of Good
104. /SAPSLL/CUCSTT GTS: Customs Status – Description
105. /SAPSLL/CUCSUS GTS: Deferment Processing
106. /SAPSLL/CUCSUST SLL: Description of Deferment Types
107. /SAPSLL/CUCTOE Type of Event
108. /SAPSLL/CUCTOET Type of Event – Description
109. /SAPSLL/CUCTRS Transport Administrator
110. /SAPSLL/CUCTRST Shipper – Name
111. /SAPSLL/CUCTVAT GTS: VAT Category
112. /SAPSLL/CUCTVATT GTS: VAT Category – Name
113. /SAPSLL/CUCUSR Reason for Complaint
114. /SAPSLL/CUCUSRT Reason for Complaint – Name
115. /SAPSLL/CUCVA GTS: Entry Type
116. /SAPSLL/CUCVAS Assign Declaration Type by Process / Legal
117. /SAPSLL/CUCVAT GTS: Entry Type – Description
118. /SAPSLL/CUCWGR Wine Region
119. /SAPSLL/CUCWGRT Wine Region – Name
120. /SAPSLL/CUCWOP Treatment of Wine Product
121. /SAPSLL/CUCWOPT Processing of Wine Product – Text
122. /SAPSLL/CUCWPR Wine Category
123. /SAPSLL/CUCWPRT Wine Category – Name
124. /SAPSLL/CUCZAF GTS: Payment Demand for Tax Assessment
125. /SAPSLL/CUCZAFT GTS: Payment Demand for Tax Assessment – D
126. /SAPSLL/CUHD Customs Document: Header
127. /SAPSLL/CUHDBLR Customs Document: Header: Blocked Legal Re
128. /SAPSLL/CUHDDAT GTS: Customs Document: Header Dates
129. /SAPSLL/CUHDR Customs Document (Backup): Header
130. /SAPSLL/CUHDSTA GTS: Customs Doc.: Header Status
131. /SAPSLL/CUIT Customs Document: Item
132. /SAPSLL/CUITBLR Customs Document: Item: Blocked Legal Regu
133. /SAPSLL/CUITDAT Customs Document: Item Dates
134. /SAPSLL/CUITPRE GTS: Customs Document: Item: Preference Da
135. /SAPSLL/CUITR Customs Document (Backup): Item
136. /SAPSLL/CUITSTA GTS: Customs Document: Item Status
137. /SAPSLL/CUITSUB Legal Services: Customs Document – Subitem
138. /SAPSLL/CUIV SLL: Customs Document: Bill
139. /SAPSLL/CUPED Supplementary Customs Declaration Header
140. /SAPSLL/CUPEDRH GTS: Period Entry Reference to Customs Doc
141. /SAPSLL/CUPEDRI GTS: Period Entry Reference to Customs Doc
142. /SAPSLL/CUSIDX Store Customizing Data in Application Buff
143. /SAPSLL/CUSWLA Worklist for Quantity Comparison Goods Iss
144. /SAPSLL/CUSWLAD Link for Requesting External Customs Decla
145. /SAPSLL/CUSWLB Customs Worklist: Qty Adjustment – Complet
146. /SAPSLL/CUSWLD Customs Processing: Procedures Completed f
147. /SAPSLL/CUSWLE Worklist for Processing Domestic Customs W
148. /SAPSLL/CUSWLF Customs Worklist: Domestic Issues – Comple
149. /SAPSLL/CUSWLM Quantity Comparison: Customs Declaration/G
150. /SAPSLL/CUSWLN Completed Quantity Comparisons Customs Dec
151. /SAPSLL/CUSWLO Worklist for Transactions with Reference t
152. /SAPSLL/CUSWLP Customs Worklist: Periodic Declarations
153. /SAPSLL/CUSWLQ Customs Worklist: Per. Declarations – Comp
154. /SAPSLL/CUSWLS Customs Worklist: Temporary Storage
155. /SAPSLL/CUSWLT Customs Worklist: Completed Temporary Stor
156. /SAPSLL/CUSWLX Closing Portions for Stock Issues from For
157. /SAPSLL/CUSWLY Foreign-Trade Zone Stock Issues
158. /SAPSLL/CUSWLZ Foreign-Trade Zone Closing Portions
159. /SAPSLL/CUSZRFR Zone-to-Zone Receiving File Data Records
160. /SAPSLL/CUSZSFR Zone-to-Zone Sent File Data Records
161. /SAPSLL/LEGDOC:- Customs Document: Documents
162. /SAPSLL/LEGTPR:- Customs Document: Shipment Procedure
163. /SAPSLL/PRBOPC:- GTS: Outward Processing BOP – Components
164. /SAPSLL/PRBOPH:- SLL: Outward Processing BOM – Header Data
165. /SAPSLL/PRBWH:- GTS Product Master: BW Relevance per Logical System
166. /SAPSLL/PRCON:- Legal Control – Product Master
167. /SAPSLL/PRCTR:- Product Master: Authority/Country Data
168. /SAPSLL/LEGCON:- Legal Control – Document

SAP GTS Tables For Preference Management

1. /SAPSLL/PRFPMRA:- SLL: Preference: Log: Prod: BOM Calculation Result- Assembly
2. /SAPSLL/PRPRFC:- SLL: Product Master: Preference Data: Confirm. Pref. Reqmts
3. /SAPSLL/VDREC:- Filter: Purchase Orders and Goods Receipt of Current Year
4. /SAPSLL/PREVDWL:- SLL: Preference: Long-Term Vendor Declaration – Worklist
5. /SAPSLL/LEGCUS:- Customs Document: Customs Processing

Join Our SAP SD & GTS LinkedIn Group