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

45 columns | Print definition?ERP 6.0  | NUMMER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CIDEON/LOGLogtabelle7NUMMERNachrichtennummernvarchar30
2CHK_DECIDEVerification table for decider in DD_DECIDE1NUMMERConsecutive numberingnvarchar30
3CLUSTERVER1NUMMERnvarchar40
4T258ADetermining the costing sheet for condition access6NUMMERSequence in costing sheet for CO-PA valuationnvarchar20
5TBSP1Test Terminology Database2NUMMERLink numbernvarchar100
6TKKPAScreen Sequence Control Path4NUMMERFCode numbernvarchar30
7VDIREVergleichstabelle: Test des Massenverteilers1NUMMERTestdtel NUMCnvarchar40
8VERCLUSTER1NUMMERnvarchar40
9ZAH_MCTable for multiple choice quiz6NUMMERNumber of a multiple choice questionnvarchar30
10ZKN_MULTIPLETabelle für Multiple-Choice-Quiz2NUMMERDummy für B20 int1 (überall lokal!)tinyint30
11ZWORKSHOPWorkshops3NUMMERnvarchar40
12ZWORKSHOP_DIFFWorkshops3NUMMERnvarchar40
13ZWORKSHOP_NEWWorkshops3NUMMERnvarchar40
TOPAccrual Engine
14TACE_TREEORDERTable for the Sequence in the Tree Structure4NUMMERField Sequence in Tree Structuredecimal20
TOPComplaints Processing
15CMP_VBFS_EXTStatus Messages from Mass Complaints Processing4NUMMERCounter for Status Messages CMP_MASS Background Processingnvarchar50
TOPCost Object
16TKKAETable of Supported Results Analysis Methods2NUMMERSequence Number for Display Sequence in F4 (Technical)nvarchar10
TOPCross-Application Components
17ZKN_MULTIPLE_401Tabelle für Multiple-Choice-Quiz2NUMMERDummy für B20 int1 (überall lokal!)tinyint30
TOPFunction Builder
18EUFUNCDevelopment Environment Objects4NUMMERName of ABAP/4 Development Workbench objectnvarchar300
19FUSEQDIRTest sequences5NUMMERName of ABAP/4 Development Workbench objectnvarchar300
TOPI18N Unicode
20UMG_TEST_15UMG test table to test CDHDR,CDPOS7NUMMERnvarchar100
TOPInformation System
21T001MData on Z5A Foreign Trade Regulations Report, Germany3NUMMERRegistration Number for Z5A Reportnvarchar70
TOPLocal Currency Changeover
22EWUCMP_RESResult of the CMP Comparison3NUMMERSequence numbernvarchar50
TOPMaintenance Program Definition
23MPDCYCLEMPD: Cycle Data for Maintenance Document Items5NUMMERCounter in control tablesnvarchar20
TOPMaintenance Task Lists
24MMPTCycle definitions and MeasPoints for MaintPlan3NUMMERCounter in control tablesnvarchar20
25MMPXMaintenance cycle short texts3NUMMERCounter in control tablesnvarchar20
TOPOLAP Technology
26RSECHIE_CLAuthorization Hierarchies Changes Change Log2NUMMERNatural Numberint100
27RSECLOGStorage for Authorizations Logs xml2NUMMERNatural Numberint100
28RSECLOPDLOGCStore for LOPD Logs2NUMMERNatural Numberint100
29RSECTXT_CLChange Documents for Document Texts2NUMMERNatural Numberint100
30RSECUSERAUTH_CLBI AS Authorizations: Assignment of User Auth (Change Log)2NUMMERNatural Numberint100
31RSECVAL_CLAuthorization Value Change (Change Log)2NUMMERNatural Numberint100
TOPPatient Management
32TN00MIS-H: Conversion table for phonetic search3NUMMERIS-H: Sequence Numbernvarchar20
TOPProfitability Analysis
33TKEANCO-PA: Control Table for PA Derivation of Characteristics4NUMMERDerivation sequence in CO-PAnvarchar20
34TKEVA02Valuation Strategies (CO-PA)4NUMMERSequence in costing sheet for CO-PA valuationnvarchar20
TOPReal Estate Management
35TIVM8Logical Database Select Options Used5NUMMERFor Table Sortingnvarchar40
TOPRecycling Administration Core Functions
36J_7LV1SREA Document: Selection Criteria Log4NUMMER5 Character Numeric NUMCnvarchar50
TOPRemaining Beverage - Obsolete Objects
37/BEV1/CLCONT1Container Information15NUMMERTruck or Container Numbernvarchar150
38/BEV3/CHCL_PRUEFExternal Amount: Function Modules for Content Checks3NUMMERSequence Numbernvarchar40
TOPSAP Business Workflow
39SWBTESTCURTest Table for Currency Translation1NUMMERnvarchar100
TOPSAP Healthcare - Industry-Specific Components for Hospitals
40NWCH94Fees: Further Breakdown3NUMMERNumber for Assignment of Further Breakdownnvarchar100
41TNWCH99Fee Breakdown Code14NUMMERNumber for Assignment of Further Breakdownnvarchar100
42TNWCHHONPOS99Fee Item Data for Codes - Breakdown Code15NUMMERNumber for Assignment of Further Breakdownnvarchar100
TOPTransport Organizer
43TESTFBParametersätze zu Tests von Funktionsbausteinen4NUMMERName des Objekts der Entwicklungsumgebungnvarchar300
TOPWorkbench Tools Editors, Painters, Modelers
44DVSEQDIRTest sequence list for dialog module management5NUMMERCounternvarchar30
45EUDIALTest data for dialog module management4NUMMERCounternvarchar30