SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

46 columns | Print definition?ERP 6.0  | STCTS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPGlobal Trade Services
1/SAPSLL/BOPITCOEGTS: Bill of Product - Basic Products per Item5STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
2/SAPSLL/CMLPRCase Management Audit Customs Product5STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
3/SAPSLL/CORCTSDocument - Customs Tariff Numbers: Non-Country-Specific6STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
4/SAPSLL/CORCTSCL&L Services: Document - Customs Tariff Nos. (Country-Spec.)6STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
5/SAPSLL/CORCTZCustoms Document Reference Codes7STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
6/SAPSLL/CTSGENLegal&Logistics Services: Generic Part of Customs Tariff No.3STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
7/SAPSLL/CTSMAESLL: Measure10STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
8/SAPSLL/CTSNUMCustoms Tariff Number3STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
9/SAPSLL/CTSNUMCL & L Services - Country-Specific Customs Tariff No.4STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
10/SAPSLL/CTSNZRCustoms Tariff Numbers: Number-Custom Code Relation6STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
11/SAPSLL/CTSSETGTS: Assignment of Number to Set4STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
12/SAPSLL/CTSTXTTexts for Customs Tariff Numbering System (Rule Set)- Header3STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
13/SAPSLL/LCLICCLegal Control - Licenses - Control Classes5STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
14/SAPSLL/LCLICILegal Control - Licenses - Import Code Number5STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
15/SAPSLL/LCLICNSLL: Legal Control: License - CAP Numbers5STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
16/SAPSLL/LCLICWLegal Control - Licenses - Commodity Code5STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
17/SAPSLL/LC_CUSB1GTS: Custs Prcssng: Duty Cat: Non-EU Country Duty, Pharmac.18STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
18/SAPSLL/LC_CUSB2GTS Customs Management: Toll Category: Preferred Customs19STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
19/SAPSLL/LC_CUSMNGTS: Customs Processing: Measures Relating to Duty Rate14STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
20/SAPSLL/LEGCONLegal Control - Document11STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
21/SAPSLL/PRCTSProduct Master - Global Customs Tariff Numbers8STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
22/SAPSLL/PRCTSCProduct Master - Country-Specific Customs Tariff Numbers8STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
23/SAPSLL/PRFLRGSLL: Preference: Log: Preferred Zones11STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
24/SAPSLL/RESCOEFSLL: Restitution: Translation Coefficients9STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
25/SAPSLL/RXPLRGRe-Export: Log: Legal Regulation5STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
26/SAPSLL/TCOSETGTS: Grouping of Number Set3STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
27/SAPSLL/TCOTSBasic Structure of Customs Tariff System2STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
28/SAPSLL/TCOTSAStructure and Content of Customs Tariff System2STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
29/SAPSLL/TCOTSATStructure and Content for Customs Tariff System - Text3STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
30/SAPSLL/TCOTSBGTS: Def. of an Alt. Numbering Scheme for Data Upload5STCTSAlternative Numbering Scheme for Uploadnvarchar100
31/SAPSLL/TCOTSJSLL: Unit of Measurement Systems for Each Numbering System2STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
32/SAPSLL/TCOTSKSLL: Measure Type2STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
33/SAPSLL/TCOTSKTSLL: Category Text of Custom Codes3STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
34/SAPSLL/TCOTSTBasic Structure of Customs Tariff System - Text3STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
35/SAPSLL/TCOTSUSLL: Mapping of Special Units of Measure in SAP UoMs2STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
36/SAPSLL/TCOTSUTGTS: Mapping Special UoMs in SAP UoMs - Texts3STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
37/SAPSLL/TCOTSVLAssignment of End Use to Numbering Scheme3STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
38/SAPSLL/TCOTSZSLL: Assigned Numbering Systems2STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
39/SAPSLL/TCTSCVRecoding Groups for Number Systems4STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
40/SAPSLL/TCTSCVARecoding Groups: Assignment to Number Systems4STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
41/SAPSLL/TLEZCUUsage of Measures2STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
42/SAPSLL/TPFONAGTS: Rule Set for Preference Agreement5STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
43/SAPSLL/TPRCTSGTS: Product Master: Control Table for Number Procedures3STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
44/SAPSLL/TPRTXAssignment of Text Determination Procedure for Product Texts3STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
45/SAPSLL/TVDCTRLSLL: Preference: Control Settings for Vendor Declaration18STCTSNumbering Scheme for Customs Tariff Systemnvarchar100
46/SAPSLL/VDMTWLPreference: Worklist to Maintain LTVD via Web Dynpro15STCTSNumbering Scheme for Customs Tariff Systemnvarchar100