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
- BUT000:- BP: General data
- BUT030:- BP Usages
- BUT0BANK:- Business Partner: Bank Data
- BUT0BK:- BP: Bank Details
- BUT0CC:- BP: Payment Cards
- BUT100:- BP: Roles table.
SAP GTS Tables for Business Partner Identification
- /SAPSLL/ADRLRID:- GTS table Identification Numbers for Address in Business Partner
- /SAPSLL/BPADDR – Addresses for Business Partner Screening
- BUT0IS:- BP: Industries table stores the Industry and Industry System.
- BUT0ID:- BP: ID Numbers which store Identification Type and Identification number.
SAP GTS Tables For Business Partner Address
- BUT020:- SAP GTS Table store BP: Addresses store business partner address numbers.
- ADRC:- Addresses (Business Address Services) stores details of address against address number.
- /SAPSLL/ADRCMP:- Prepared Address for Address Comparison
- /SAPSLL/BPADDR:- Addresses for Business Partner Screening
SAP GTS Tables For Business Partners Other SAP GTS Tables
- /SAPSLL/TMPBPI:- Assign BP ID Type to an External Identification Scheme
- /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.
- /SAPSLL/TPABP:- Legal & Logistics Services: Business Partner – Control Setting of SPL
SAP GTS Tables For Product Master Data
- /SAPSLL/PR:- Product Master
- /SAPSLL/PNTPR:- Legal and Logistics Services: Product Master Mapping
- /SAPSLL/PRUOM:- Legal & Logistics Services: Product Master – Units
- /SAPSLL/PRGEN:- GTS: Product Master: Generic Characteristic Values
- /SAPSLL/PRCTR:- Product Master: Authority/Country Data
- /SAPSLL/PRCTS:- Product Master – Global Customs Tariff Numbers
- /SAPSLL/PRCTSC:- Product Master – Country-Specific Customs Tariff Numbers
- /SAPSLL/PRDOC:- Product Master: Documents / Verifications
- /SAPSLL/PRECIP:- Product Master: Documents / Verifications
SAP GTS License Master Data Tables
- /SAPSLL/LCLIC:- Legal Control: License Header
- /SAPSLL/LCLICA:- Legal Control: Other License Attributes
- /SAPSLL/LCLICB:- GTS: License – Banks
- /SAPSLL/LCLICC:- Legal Control – Licenses – Control Classes
- /SAPSLL/LCLICCO:- Legal Control: License – Application Data
- /SAPSLL/LCLICCQ:- Legal Control: License – Quantities per Component
- /SAPSLL/LCLICCQU:- License – Quantities Taken per Component
- /SAPSLL/LCLICE:- SLL: Legal Control: License – Restitution
- /SAPSLL/LCLICF:- SLL: Legal Control: License – Prefixation
- /SAPSLL/LCLICG:- Legal Control – Licenses – Business Transaction Type
- /SAPSLL/LCLICH:- SLL: Legal Control: – License – Peculiarity Code
- /SAPSLL/LCLICI:- Legal Control – Licenses – Import Code Number
- /SAPSLL/LCLICK:- GTS: License – Terms of Payment
- /SAPSLL/LCLICL:- Legal Control: Licenses – Countries
- /SAPSLL/LCLICM:- Legal Control – Licenses – Materials
- /SAPSLL/LCLICN:- SLL Legal Control: License – CAP Numbers
- /SAPSLL/LCLICO:- Legal Control: Licenses – Org. Units
- /SAPSLL/LCLICP:- SLL: Legal Control: License – Procedures
- /SAPSLL/LCLICQ:- Legal Control: Licenses – Quantities
- /SAPSLL/LCLICAQ:- Legal Control: License Change Log: Available Quantity, GTS Table stores the remaining available quantity per component based on the depreciation level.
- /SAPSLL/LCLICR:- SLL: Legal Control: License – Country Groups
- /SAPSLL/LCLICS:- Legal Control: Licenses – Statuses
- /SAPSLL/LCLICU:- Legal Control: Licenses – Legal Units
- /SAPSLL/LCLICV:- SLL: Legal Control: License – Values
- /SAPSLL/LCLICAV:-Legal Control: License: Available Quantity
- /SAPSLL/LCLICAVL:- License: Change Log of Available Quantity
- /SAPSLL/LCLICCV:- Legal Control: License – Values per Component.
- /SAPSLL/LCLICCVU:- License – Values Taken per Component
- /SAPSLL/LCLICW:- Legal Control – Licenses – Commodity Code
- /SAPSLL/LCLICY:- GTS: License – Documents
- /SAPSLL/LCLICZ:- GTS: License – Access Codes
- /SAPSLL/LCLICVUS:- Legal Control: Licenses – Values Allocated to Sales Order
- /SAPSLL/LCLICH:- SLL: Legal Control: – License – Peculiarity Code
- /SAPSLL/LCLICJ:- License – Projects
- /SAPSLL/LCLICPT:- Processing Trade: Relationship of Merged Products
- /SAPSLL/LCLICPTB:- Processing Trade: BOM of Merged Products
- /SAPSLL/LCLICPTM:- Processing Trade: Information About Merged
- /SAPSLL/LCLICPTP:- Processing Trade: Node Assignments
- /SAPSLL/LCLICPTT:- P/T: Tariff Number Attributes for Merged Products
- /SAPSLL/LCLICQ Legal Control: Licenses – Quantities
- /SAPSLL/LCLICQUS Legal Control: Licenses – Quantities Allocated
- /SAPSLL/LCLICX:- GTS: License Master – Documents for Letter of Credit
- /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
- /SAPSLL/CEEMB Country of Departure/Destination (Embargo)
- /SAPSLL/V_AEMB01 Activate Legal Regulation: Country Level
- /SAPSLL/V_AEMB02 Activate Legal Regulation: Country/Country Level
- /SAPSLL/V_AEMB03 Activate Legal Regulation: Country/Country Group Level
- /SAPSLL/V_AEMB11 Activate Legal Regulation: Country Group Level
- /SAPSLL/V_AEMB12 Activate Legal Regulation: Country Group/Country Level
- /SAPSLL/V_AEMB13 Activate Legal Regulation: Ctry Group/Ctry Group Level
- /SAPSLL/V_AEMB6G “Embargo Check” Service: Activate Legal Regulations
- /SAPSLL/V_ARGEMB “Embargo Check” Service: Activate Legal Regulations
- /SAPSLL/V_CEEMB Embargo Check: Legal Regulation/Ctry of Origin/Destin.
- /SAPSLL/V_T6GEMB Control Settings for Embargo Check
- /SAPSLL/V_TLHEMB Activation: “Embargo Check” Service
- /SAPSLL/V_TLIEMB Activation: “Embargo Check” Service
- /SAPSLL/V_TLSEMB Embargo Check: Determine Active Legal Regulations
SAP GTS Tables for Sanction Party List
SPL Master and Transactional Tables
- /SAPSLL/SPLAT Optimized Audit Trails for Partners, Docs and Ext. Address
- /SAPSLL/SPLATA Optimized Audit Trails for General Addresses
- /SAPSLL/SPLATM Optimized Audit Trail: Matched Terms
- /SAPSLL/SPLAUD Legal Control – SPL – Audit
- /SAPSLL/SPLAUDD Legal Control – SPL – Audit: Details
- /SAPSLL/SPLAUDF Audit Trail for SPL – FTORG Assignment
- /SAPSLL/SPLAUDK Legal Control – SPL – Audit: Comments
- /SAPSLL/SPLAUDM Audit Trail SPL Screening – Matched Search Terms
- /SAPSLL/SPLAUDR Audit Trail for SPL Screening – Additional Object Reference
- /SAPSLL/SPLCTD Legal Control – SPL – Control Data for Comparison: Detai
- /SAPSLL/SPLCTR Legal Control – SPL – Control Data for Comparison
- /SAPSLL/TSPL Legal & Logistics Services: LC: SPL Master (Header Data)
- /SAPSLL/TSPLA Legal Control: SPL Master (Address Data)
- /SAPSLL/TSPLAK Legal Control: SPL Master (Address Data) – Keywords
- /SAPSLL/TSPLB SPL Master (Dates of Birth)
- /SAPSLL/TSPLI SPL Master (Identifications)
- /SAPSLL/TSPLIDX TREX Index ID for Sanctioned Party List Screening
- /SAPSLL/TSPLN Legal Control: SPL Master (Name Data)
- /SAPSLL/TSPLNK Legal Control: SPL Master (Name Data) – Keywords
- /SAPSLL/TSPLR Sanctioned Party List Master (References)
- /SAPSLL/TSPLTRX TREX Index ID for Sanctioned Party List Screening (Delta
- /SAPSLL/TSPLUI Use Conventional SPL UI for User
SPL Configurational GTS Tables
- /SAPSLL/V_ARGSPL “SPL Screening” Service: Activate Legal Regulations
- /SAPSLL/V_ASPL01 Activate Legal Regulation: Country Level
- /SAPSLL/V_ASPL02 Activate Legal Regulation: Country/Country Level
- /SAPSLL/V_ASPL03 Activate Legal Regulation: Country/Country Group Level
- /SAPSLL/V_ASPL11 Activate Legal Regulation: Country Group Level
- /SAPSLL/V_ASPL12 Activate Legal Regulation: Country Group/Country Level
- /SAPSLL/V_ASPL13 Activate Legal Regulation: Ctry Group/Ctry Group Level
- /SAPSLL/V_ASPL6G “SPL Screening” Service: Activate Legal Regulations
- /SAPSLL/V_SPLCTD Sanctioned Party List Screening: Comparison Control – De
- /SAPSLL/V_SPLCTR Sanctioned Party List Screening: Comparison Control
- /SAPSLL/V_T6GSPL Legal Control: Control Settings for “SPL Screening” Serv
- /SAPSLL/V_TLHSPL Activation: “Sanctioned Party List Screening” Service
- /SAPSLL/V_TLISPL GTS: Activate Service ‘Sanctioned Party List’
- /SAPSLL/V_TLSSPL SPL Screening: Determine Active Legal Regulations
- /SAPSLL/V_TLZSPL GTS: Assignm.of Timezone to DateType f.Sanctioned Party
SAP GTS Tables For Customs Document
- /SAPSLL/CORREF:- Reference Data table stores GUI object key with respect to feeder system document number.
- /SAPSLL/CUHD:- Customs Document: Header
- /SAPSLL/CUIT:- Customs Document: Item
- /SAPSLL/CUCAAR:- GTS Toll Types
- /SAPSLL/CUCAART:- SLL Toll Types – Description
- /SAPSLL/CUCAFA:- GTS Requested Concession
- /SAPSLL/CUCAFAT:- GTS Description of Requested Concession
- /SAPSLL/CUCAGG:- GTS Tax Assessment Duty Group
- /SAPSLL/CUCAGGT:- GTS Tax Assessment Duty Group – Description
- /SAPSLL/CUCAOR:- Reason for Rejection
- /SAPSLL/CUCAORT:- Reason for Rejection – Description
- /SAPSLL/CUCAPR GTS:- Additional Procedure
- /SAPSLL/CUCAPRT SLL:- Additional Procedures – Description
- /SAPSLL/CUCARC:- Area Code
- /SAPSLL/CUCARCT:- Area Code – Description
- /SAPSLL/CUCARQ:- Assignment of Document Code – Document
- /SAPSLL/CUCARQT:- Assignment of Document Code – Document Description
- /SAPSLL/CUCBMS:- GTS Tax Assessment Measure
- /SAPSLL/CUCBMST:- GTS Tax Assessment Measure – Description
- /SAPSLL/CUCCAT:- Goods Category
- /SAPSLL/CUCCATT:- Goods Category – Description Text
- /SAPSLL/CUCCNR:- Reason for Cancellation
- /SAPSLL/CUCCNRT:- Reason for Cancellation – Text
- /SAPSLL/CUCCPG:- Container Status
- /SAPSLL/CUCCPGT:- Container Status- Text
- /SAPSLL/CUCCTY:- Country Code
- /SAPSLL/CUCCTYT:- SLL: Country Key – Description
- /SAPSLL/CUCCUR:- Currency Code
- /SAPSLL/CUCCURT:- SLL: Currency Key – Description
- /SAPSLL/CBCMH:- Monitoring of Communication with Customs Broker – Header
- /SAPSLL/CORPAR:- Document Partner
- /SAPSLL/LEGCULC:- SLL: Customs Document: Customs Processing: Duties
- /SAPSLL/LEGCUS:- Customs Document: Customs Management
- /SAPSLL/LEGPLO:- Customs Document: Seals
- /SAPSLL/CUCDAD Definition of Customs Duty Types
- /SAPSLL/CUCDADM Mapping of Customs Duty Types
- /SAPSLL/CUCDADT Definition of Customs Duty Types: Text Tab
- /SAPSLL/CUCDC GTS: Type of Registration for Global Trade
- /SAPSLL/CUCDCT GTS: Description of Registration Type for
- /SAPSLL/CUCDST Type of Destination
- /SAPSLL/CUCDSTT Type of Destination – Name
- /SAPSLL/CUCEQS Transport Equipment Type
- /SAPSLL/CUCEQST Type of Transport Equipment
- /SAPSLL/CUCEQT Type of Transport Equipment
- /SAPSLL/CUCEQTT Type of Transport Equipment
- /SAPSLL/CUCEVI Type of Index
- /SAPSLL/CUCEVIT Type of Index – Description
- /SAPSLL/CUCEXP Explanation
- /SAPSLL/CUCEXPT Explanation – Text
- /SAPSLL/CUCFDP FDA Package Types
- /SAPSLL/CUCFDPT FDA Package Types – Name
- /SAPSLL/CUCGUC Constellation of Guarantors
- /SAPSLL/CUCGUCT Constellation of Guarantors – Text
- /SAPSLL/CUCIND GTS: Customs Processing Indicator
- /SAPSLL/CUCINDT GTS: Customs Processing Indicator
- /SAPSLL/CUCINR Reason for Interruption
- /SAPSLL/CUCINRT Reason for Interruption – Description
- /SAPSLL/CUCLOC Locations, Coded
- /SAPSLL/CUCMAP GTS: Mapping of Objects from Customs Code
- /SAPSLL/CUCMAQ Default Qualifier for Measure Type ID
- /SAPSLL/CUCMES Message Codes
- /SAPSLL/CUCMEST Message Code Names
- /SAPSLL/CUCMOT SLL: Type of Means of Transport
- /SAPSLL/CUCMOTT SLL: Description of Type of Transport
- /SAPSLL/CUCMTR SLL: Mode of Transport
- /SAPSLL/CUCMTRT SLL: Description of Type of Transport
- /SAPSLL/CUCNGA SLL: Range of Goods
- /SAPSLL/CUCNGAT SLL: Range of Goods – Description
- /SAPSLL/CUCORG Type of Departure
- /SAPSLL/CUCORGT Type of Issue – Name
- /SAPSLL/CUCPAQ Assignment: Type of Document / Qualifier
- /SAPSLL/CUCPAS Assign Document to Communication Process
- /SAPSLL/CUCPAT SLL: Documents/Preliminary Documents
- /SAPSLL/CUCPATT SLL: Description of Preliminary Document Type
- /SAPSLL/CUCPAV Link: Procedure / Additional Procedure
- /SAPSLL/CUCPCL Temporary Storage Locations
- /SAPSLL/CUCPOP Issuing Authority
- /SAPSLL/CUCPOPT Issuing Authority Name
- /SAPSLL/CUCPQU Qualifier of Document
- /SAPSLL/CUCPQUT Qualifier of Document – Name
- /SAPSLL/CUCPRO GTS: Place into a Customs Status
- /SAPSLL/CUCPROT GTS: Place into a Customs Status – Descrip
- /SAPSLL/CUCPRS Assign Procedures by Process / Legal Regul
- /SAPSLL/CUCPRT Processing Type
- /SAPSLL/CUCPRTT Processing Type – Description
- /SAPSLL/CUCPST Status of a Document
- /SAPSLL/CUCPSTT Status of a Document – Name
- /SAPSLL/CUCPTY Package Types
- /SAPSLL/CUCPTYT SLL: Package Types – Description
- /SAPSLL/CUCPYT SLL: Payment Methods
- /SAPSLL/CUCPYTT SLL: Description of Payment Methods
- /SAPSLL/CUCRCD Definition: Reason for Reconciliation Summ
- /SAPSLL/CUCRCDT Text Table for /SAPSLL/CUCRCD
- /SAPSLL/CUCRCM Mapping: Reason for Change to Duty Type
- /SAPSLL/CUCRES SLL: Customs Control Results
- /SAPSLL/CUCREST SLL: Description of Customs Control Result
- /SAPSLL/CUCRPD GTS: Type of Registration for Process Acti
- /SAPSLL/CUCRPS GTS: Assign Customs Status per Process/Leg
- /SAPSLL/CUCSLT SLL: Fastening Types
- /SAPSLL/CUCSLTT SLL: Description of Fastening Types
- /SAPSLL/CUCST GTS: Customs Status
- /SAPSLL/CUCSTA SLL: Customs Status of Goods
- /SAPSLL/CUCSTAT SLL: Description of Customs Status of Good
- /SAPSLL/CUCSTT GTS: Customs Status – Description
- /SAPSLL/CUCSUS GTS: Deferment Processing
- /SAPSLL/CUCSUST SLL: Description of Deferment Types
- /SAPSLL/CUCTOE Type of Event
- /SAPSLL/CUCTOET Type of Event – Description
- /SAPSLL/CUCTRS Transport Administrator
- /SAPSLL/CUCTRST Shipper – Name
- /SAPSLL/CUCTVAT GTS: VAT Category
- /SAPSLL/CUCTVATT GTS: VAT Category – Name
- /SAPSLL/CUCUSR Reason for Complaint
- /SAPSLL/CUCUSRT Reason for Complaint – Name
- /SAPSLL/CUCVA GTS: Entry Type
- /SAPSLL/CUCVAS Assign Declaration Type by Process / Legal
- /SAPSLL/CUCVAT GTS: Entry Type – Description
- /SAPSLL/CUCWGR Wine Region
- /SAPSLL/CUCWGRT Wine Region – Name
- /SAPSLL/CUCWOP Treatment of Wine Product
- /SAPSLL/CUCWOPT Processing of Wine Product – Text
- /SAPSLL/CUCWPR Wine Category
- /SAPSLL/CUCWPRT Wine Category – Name
- /SAPSLL/CUCZAF GTS: Payment Demand for Tax Assessment
- /SAPSLL/CUCZAFT GTS: Payment Demand for Tax Assessment – D
- /SAPSLL/CUHD Customs Document: Header
- /SAPSLL/CUHDBLR Customs Document: Header: Blocked Legal Re
- /SAPSLL/CUHDDAT GTS: Customs Document: Header Dates
- /SAPSLL/CUHDR Customs Document (Backup): Header
- /SAPSLL/CUHDSTA GTS: Customs Doc.: Header Status
- /SAPSLL/CUIT Customs Document: Item
- /SAPSLL/CUITBLR Customs Document: Item: Blocked Legal Regu
- /SAPSLL/CUITDAT Customs Document: Item Dates
- /SAPSLL/CUITPRE GTS: Customs Document: Item: Preference Da
- /SAPSLL/CUITR Customs Document (Backup): Item
- /SAPSLL/CUITSTA GTS: Customs Document: Item Status
- /SAPSLL/CUITSUB Legal Services: Customs Document – Subitem
- /SAPSLL/CUIV SLL: Customs Document: Bill
- /SAPSLL/CUPED Supplementary Customs Declaration Header
- /SAPSLL/CUPEDRH GTS: Period Entry Reference to Customs Doc
- /SAPSLL/CUPEDRI GTS: Period Entry Reference to Customs Doc
- /SAPSLL/CUSIDX Store Customizing Data in Application Buff
- /SAPSLL/CUSWLA Worklist for Quantity Comparison Goods Iss
- /SAPSLL/CUSWLAD Link for Requesting External Customs Decla
- /SAPSLL/CUSWLB Customs Worklist: Qty Adjustment – Complet
- /SAPSLL/CUSWLD Customs Processing: Procedures Completed f
- /SAPSLL/CUSWLE Worklist for Processing Domestic Customs W
- /SAPSLL/CUSWLF Customs Worklist: Domestic Issues – Comple
- /SAPSLL/CUSWLM Quantity Comparison: Customs Declaration/G
- /SAPSLL/CUSWLN Completed Quantity Comparisons Customs Dec
- /SAPSLL/CUSWLO Worklist for Transactions with Reference t
- /SAPSLL/CUSWLP Customs Worklist: Periodic Declarations
- /SAPSLL/CUSWLQ Customs Worklist: Per. Declarations – Comp
- /SAPSLL/CUSWLS Customs Worklist: Temporary Storage
- /SAPSLL/CUSWLT Customs Worklist: Completed Temporary Stor
- /SAPSLL/CUSWLX Closing Portions for Stock Issues from For
- /SAPSLL/CUSWLY Foreign-Trade Zone Stock Issues
- /SAPSLL/CUSWLZ Foreign-Trade Zone Closing Portions
- /SAPSLL/CUSZRFR Zone-to-Zone Receiving File Data Records
- /SAPSLL/CUSZSFR Zone-to-Zone Sent File Data Records
- /SAPSLL/LEGDOC:- Customs Document: Documents
- /SAPSLL/LEGTPR:- Customs Document: Shipment Procedure
- /SAPSLL/PRBOPC:- GTS: Outward Processing BOP – Components
- /SAPSLL/PRBOPH:- SLL: Outward Processing BOM – Header Data
- /SAPSLL/PRBWH:- GTS Product Master: BW Relevance per Logical System
- /SAPSLL/PRCON:- Legal Control – Product Master
- /SAPSLL/PRCTR:- Product Master: Authority/Country Data
- /SAPSLL/LEGCON:- Legal Control – Document
SAP GTS Tables For Preference Management
- /SAPSLL/PRFPMRA:- SLL: Preference: Log: Prod: BOM Calculation Result- Assembly
- /SAPSLL/PRPRFC:- SLL: Product Master: Preference Data: Confirm. Pref. Reqmts
- /SAPSLL/VDREC:- Filter: Purchase Orders and Goods Receipt of Current Year
- /SAPSLL/PREVDWL:- SLL: Preference: Long-Term Vendor Declaration – Worklist
- /SAPSLL/LEGCUS:- Customs Document: Customs Processing
Join Our SAP SD & GTS LinkedIn Group