SAP Basic Functions Tables

Are you looking for the right table related to SAP Basic Functions Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Basic Functions (SD-FT-PRO) module.

Top 10 tables in Basic Functions

TableDescription
T612NFT/Customs: Electr. procedures: Type of identity of goods
T604_PREF_MTARTPreference: Material Exemption Parameters
FSLSForeign Trade: Legal Control-Sanctioned Party List-Master
EIEIForeign Trade: Export/Import Communication Data
MAPEWGMaterial master: Preference determination: Cross-plant
MMPREK_PRO_02Log table - Main component - Information
MMPREK_PRO_01_BLog table - Preference - Info from rule
EMBKLegal Control: License Master - Header Data
T604FImport Processing: Control Code
MMPREW_PRO_01Log table for archiving object MMPREW

List of tables in Basic Functions

TableDescription
T612NFT/Customs: Electr. procedures: Type of identity of goods
T604_PREF_MTARTPreference: Material Exemption Parameters
FSLSForeign Trade: Legal Control-Sanctioned Party List-Master
EIEIForeign Trade: Export/Import Communication Data
MAPEWGMaterial master: Preference determination: Cross-plant
MMPREK_PRO_02Log table - Main component - Information
MMPREK_PRO_01_BLog table - Preference - Info from rule
EMBKLegal Control: License Master - Header Data
T604FImport Processing: Control Code
MMPREW_PRO_01Log table for archiving object MMPREW
T604GPreference: Preference Zone
T604NImport Processing: Control Code Description
MMPREK_PRO_01Log table for archiving object MMPREK
T604WForeign Trade: Sections With Regard to Customs Law
T606MLegal Control: Product Classification by Destinat. Ctry
MMPREF_PRO_03Log table - Component - Information
T604_PREF_PARAMPreference: Preference determination parameters
T610FAImport Processing: Anti-dumping Code Determination
T604OForeign Trade: Sections With Regard to Customs Law - Descr.
T612NTFT/Customs: Electr. Proced.: Type of ident. of goods - descr
T610AImport Processing: Anti-dumping Code
T610OTForeign Trade: Authorities - Descriptions
T606SLegal Control: Grouping of Dest. Countries - Descriptions
T607DDocumentary Payments: Documents to be Presented
T610RImport Processing: Reference Countries
T618MECAP-relevant material components
T604ZForeign Trade: Chapter - Descriptions
T612ATFT/Customs: Elect. Procedure: Duty Type - Means of Transport
T610LGForeign Trade: Country Groups for Import Processing
T606VLegal Control: Export Control Class Descriptions
T612VTFT/Customs: Electr. procedure - Description
T612AForeign Trade/Customs: Electronic Procedure: Duty Types
FTUSEForeign Trade: Control Table: User-dependent Settings
T610KPTForeign Trade: Import Processing: Quota or Ceiling Number
T604UForeign Trade: Convert Commodity Code/Import Code No.
T606ULegal Control: Grouping Descriptions
T607EDocumentary Payments: Control Documents per Indicator
T618UForeign Trade: Conversion of Import/Export Mode of Transport
T618WEU Market: Market Organization Number
FSLSTAForeign Trade: Legal Control - SLS - Audit Trail
FTGKLLegal Control: Log (Up-to-Date)
T607FDocumentary Payments: Indicators - Field Ctrl/Doc.Check
T606ASLegal Control: Export Control Class - Commodity Code
T606XLegal Control: Destination Countries for License
T610FPImport Processing: Preferential Duty Rate Determination
T608Legal Control: Sanctioned Party Lists - Type of Check
T606TLegal Control: License Type Descriptions
T606PTLegal Control: Grouping Partners - Descriptions
T610NAImport Processing: Verification Documents
T604PPreference: Preference Zone/Rule
T610PAForeign Trade: Preference Type
T615UForeign Trade: Import/Export Customs Office Conversion
FTGKLALegal Control: Log (Prestep for Archiving)
VEKABKOBRA (B Record) Export
T618METMaterial Component Texts (EU Market Products)
VEKAAKOBRA (A+D Record) Export
T612STFT/Customs: Electr. procedure: Status - Description
T618OTEU Market: Market Organization Descriptions
MMPREW_PRO_02Preference CPG: Log main component - Information
A121Legal Control: Values for Calculating Foreign Percentage
T604RPreference: Preference Rule / Percentages
T618EMBOM of CAP material components
T612PFT/Customs: Electr. Procedure: Type of Shipping Unit
FSLSTForeign Trade: Legal Control - SLS - Audit Trail
T606BLegal Control: Grouping Materials
FSLSWForeign Trade: Legal Control - Sanct. Party List - Keyword
MMPREF_PRO_01Logging table for archiving object MMPREF
T606DTLegal Control: Special Char. Code for Goods - Description
T604XPreference: Procedure - Description
T618MCAP: Number of CAP products list
T618GTEU Market: EU Market Products Group - Descriptions
MMPREF_PRO_01_BLog table - Preference - Information from rules
T606KLegal Control: Control Situation of Dest.Ctry.
T612GTForeign Trade/Customs: Electr. procedures: Duty type group.
AKKBDocumentary Payment Guarantee: Financial Doc. - Bank Data
T607FTDoc. Payments: Indicators: Field Ctrl/Doc.Check-Descriptions
T610WForeign Trade: Customs Approval Numbers per Plant
T610PATForeign Trade: Preference Type - Description
T604YForeign Trade: Sections/Chapters With Regard to Customs Law
T610UForeign Trade: Upload: Duty Rate Types, Legal Regulations
T607KDocumentary Payments: Bank Indicators
T604WGTPreference determination: Cross-plant grouping - Description
T616Procedure
T604IInput Table for Collective Calculation for Goods Origin
FSLSIForeign Trade: Legal Control - Sanct. Party List - Indices
T618MSComponents of EU Market Products
T604LForeign Trade: Preference: Single-plant control data VD
T607GDocumentary Payments: Reasons for Change
T609ATForeign Trade: Decl. to Auth.: Exclusion Ind. - Descriptions
T606RLegal Control: Legal Regulation Descriptions
T610ZForeign Trade: Customs Identification Nos -Supplier/Customer
T616UForeign Trade: Import/Export Procedure Conversion
MMPREF_PRO_IDXArchiving object MM_PREF customs logs - Index table
T609BTFT: Incompl.: Doc.Pric.Proced. - Header and Item - Descript.
T616TProcedure Description
T618Mode of Transport at the Border
T612SForeign Trade/Customs: Electr. Procedure: Status
FTGOVPAForeign Trade: Periodic Declarations
T608RLegal Control: Sanctioned Party Lists - Reference Type
VBEXSD Document: Export Control: Data at Item Level
T606PLegal Control: Grouping Partners
EIZOFT: Exp/Imp ident. of goods, pres. of goods for cust.declar.
VBKKSD Doc.Export Letter of Credit
T612KFT/Customs: Electr. Procedure: Duty Type - Condition type
T606NLegal Control: Product Classification by Country Grouping
T610BTForeign Trade: Customs Approval Number Descriptions
T610KTImport Processing: Customs Quota Code Descriptions
T609SForeign Trade: Control Export/Import Data in SD/MM Document
T612BTFT/Customs: Elect. Procedure: Type of Means of Transport - D
CONUForeign Trade: Duty Rate Numbers and Commodity Codes
T609FForeign Trade: Incompletion Procedure - Document Fields
T606LLegal Control: Country Classification by Destination Ctry
T609PPTForeign Trade: Communication: Characteristics texts
AKKDDocumentary Paym. Guarantee: Fin.Doc.Master-Export Doc.Data
MMPREW_PRO_03Preference CPG: Log components - Information
T606ILegal Control: Export Control Class / Grouping
FTULOForeign Trade: Work Table for UPLOAD of Foreign Trade Data
T610NATImport Processing: Verification Document Descriptions
T606CLegal Control: Import code numbers for license
VEKACKOBRA (C Record) Export
T604Foreign Trade: Commodity Code / Import Code Number
T606PGLegal Control: Partner Functions for Grouping Partners
T610FSImport Processing: Customs Exemption Determination
T609LTForeign Trade: Incompleteness: Country proced. - Descript.
T612BFT/Customs: Electr. Procedure: Type of means of transport
T607BDocumentary Payments: Bank Functions
T608TLegal Control: Sanctioned Party Lists - Type of Check
T610LGZForeign Trade: Assignment of Countries to Country Groups
T618WTEU Market: Market Organization Number - Descriptions
FSLSNForeign Trade: Legal Control - Sanctioned Party List - Names
T607GTDocumentary Payments: Reasons for Change - Descriptions
MMPREF_PRO_02Log table - Main component - Information
T607SDocumentary Payments: Fld Ctrl for Banks in Financial Doc.
VEXAVEXTRASTAT / VAR Export/Import
VESEDSED / AERP Export
T610OForeign Trade: Authorities
T609IForeign Trade: Declarations to Auth.: Control/Incompleteness
MAFUForeign Trade: Additional Information for Material/Code No.
T606ZLegal Control: Partners - Customers for License
MMPREW_PRO_01_BPreference CPG: Log - Information from rule
T605ZForeign Trade: Proposal for Bus. Transaction Type in Export
FTCOMTForeign Trade: Communication: Audit table for FT documents
T605Business Transaction Type
T609PPFT: Communication: Control Change of FT documents
T610FLImport Processing: Third-country Duty Rate Determination
T608NLegal Control: Sanctioned Party Lists: Normalizations
T607BTDocumentary Payments: Bank Function Descriptions
T604VPreference: Preference Determination / Procedure
MAZOForeign Trade: Customs Law Description
T604WGGPreference determination: Assignment of plants
T618KForeign Trade: Valid Comb. f. Mode of Transp./Customs Office
T612GForeign Trade/Customs: Electr. procedures: Duty type group.
T609LForeign Trade: Incompleteness: Country procedure
T607IDocumentary Payments: Financial Document Control
T610DTImport Processing: Pharmaceutical Products Code Descriptions
T609VForeign Trade: Incompletion Procedures for Document Data
T604SPreference: Determine Preference Zone in Export
T607KTDocumentary Payments: Bank Function ID Descriptions
T604CPreference: Preference Procedure Code
T606DLegal Control: Special Characteristic Code for Goods
T609POFT: Communication: Assignment form fields - Characteristics
T604WGPreference determination: Cross-plant grouping
T610DImport Processing: Pharmaceutical Products Code
T610LGTForeign Trade: Country Groups for Import Processing - Descr.
EIUVForeign Trade: Incompletion Log for Foreign Trade Data
T612VForeign Trade/Customs: Electr. Procedure
AKKPDocumentary Payment Guarantee: Fin.Doc.Master - Header Data
MMPREW_PRO_IDXArchiving object MM_PREW customs logs - Index table
T618MTEU Market: EU Market Products List No. - Descriptions
T605KForeign Trade: Bus. Transaction Type - Procedure Combination
T605TBusiness Transaction Type Description
T610ATImport Processing: Anti-dumping Code Descriptions
T610FKImport Processing: Customs Quota Code Determination
T607ATDocumentary Payments: Financial Document Type Descriptions
FSLSDKWForeign Trade: Legal Control: SLS: Keywords from Addresses
T604STWForeign Trade: Keywords for commodity codes
ECCNLegal Control: Foreign Percentages
T610FEImport Processing: Import Verification Doc. Determination
T610FDImport Processing: Pharmaceut. Products Code Determination
T606OLegal Control: Embargo - Dependent on Departure Country
T604DPreference: Description of Preference Procedure Code
FSLSAForeign Trade: Legal Control-Sanctioned Party List-Address
T612PTFT/Customs: Electr. procedure: Shp. unit type - Description
T609PForeign Trade: Communication: Control Printing of FT Docs
MMPREK_PRO_03Log table - Component - Information
T610BForeign Trade: Customs Approval Numbers
T608LTLegal Control: Sanctioned Party Lists - List Type Descript.
T609VTForeign Trade: Incompletion Procedures in Docs - Descript.
T605UForeign Trade: Convert Export/Import Bus. Trans. Type
T608DLegal Control: Sanctioned Party Lists: Delimiter
FSLSWCFT: Legal Control: Sanct. Party List - Collected Key Words
T606YLegal Control: Export Control Classes for License
T606ELegal Control: Grouping Destination Countries
T609RForeign Trade: Export/Import Conversion - Reference Country
T609UKForeign Trade: Incompleteness: Combination WR - L - L - B
T604APreference: Tariff alternation
T618GEU Market: EU Market Products Group
T606ALegal Control: Departure Country / Legal Regulations
T618OEU Market: Market organizations
T608ELegal Control: Sanctioned Party Lists - Exclusion Texts
T608ALegal Control: Sanctioned Party Lists - Aliases
T610KImport Processing: Customs Quota Codes
FTUSESForeign Trade: Control table: User settings
TVFMTMaterial Group for Intrastat - Description
T604BPreference: Preference Zone Description
T606WLegal Control: Materials for license
VEIAVINTRASTAT Receipt/Dispatch
T606HLegal Control: Export Control Classes
T606ZKLegal Control: Partners - Suppliers License
T615TForeign Trade: Customs Offices - Descriptions