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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

135 columns | Print definition?ERP 6.0  | LTIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BPCA_TABK_EXCBPCA Table Key Recording: Table to always include5LTIMESystem Timenvarchar60
2CNVCMIS_A_1_MSAGMessage IDs for T10011LTIMELast changed atnvarchar60
3ETALLPAIRS_HEADHeader Data of AllPairs Objects9LTIMETime of Last Changenvarchar60
4P2B2_FEHLERHCM Declustering B2 - Messages (Table FEHLER)8LTIMELogical timenvarchar60
5ZIDES_USR02Logon data of certain users14LTIMELast Logon Timenvarchar60
6ZUSR02Users and passwords14LTIMELast Logon Timenvarchar60
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
7CRM_TCKADDCOMPSTCK Checkman for Solutions: Additional Components8LTIMESystem Timenvarchar60
8CRM_TCKCOMP4PRODTCK Checkman for Solutions: Product's Components10LTIMESystem Timenvarchar60
9CRM_TCKDBSYSTCK Checkman for Solutions: Database Systems11LTIMESystem Timenvarchar60
10CRM_TCKHOSTSTCK Checkman for Solutions: Hosts10LTIMESystem Timenvarchar60
11CRM_TCKINSTANCESTCK Checkman for Solutions: Instances16LTIMESystem Timenvarchar60
12CRM_TCKPRODUCTSTCK Checkman for Solutions: Products of Solutions7LTIMESystem Timenvarchar60
13CRM_TCKSOLPRODTCK Checkman for Solutions: Products6LTIMESystem Timenvarchar60
14CRM_TCKSOLUTIONSTCK Checkman for Solutions: Solution List6LTIMESystem Timenvarchar60
15CRM_TCKSYSTEMSTCK Checkman for Solutions: R/3 Systems9LTIMESystem Timenvarchar60
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
16T100AMessage IDs for T1007LTIMELast changed atnvarchar60
17UTCMPVerification Table for Decider in DD_DECIDE17LTIMELast changed atnvarchar60
TOPALE Integration Technology
18EDBASBasic types12LTIMEIDoc development: Time of last changenvarchar60
19EDCIMExtensions12LTIMEIDoc development: Time of last changenvarchar60
20EDISDEFIDoc Development : IDoc Segment Definitions9LTIMEIDoc development: Time of last changenvarchar60
21EDISEGMENTIDoc Development : IDoc Segment10LTIMEIDoc development: Time of last changenvarchar60
TOPASAP AcceleratedSAP
22IATNODE01Node Table for Implementation Assistant36LTIMETime of Last Changenvarchar60
23TCUSTEMPCustomizing templates entity table9LTIMEChanged Atnvarchar60
24TNODEREVStructure Item Table for Review Structures36LTIMETime of Last Changenvarchar60
TOPASAP Tools and Contents
25SMAPTNODESolution Map: Node table36LTIMETime of Last Changenvarchar60
TOPAuthentication and SSO
26USR02Logon Data (Kernel-Side Use)14LTIMELast Logon Timenvarchar60
TOPAuthoring Tools
27QMM_NODEQMM: Node Table for General Structure Storage36LTIMETime of Last Changenvarchar60
TOPBusiness Navigator
28BMTNODE01Structure repository for process model objects: Node table36LTIMETime of Last Changenvarchar60
29DFTNODE01Structure repository for process model objects: Node table36LTIMETime of Last Changenvarchar60
TOPBW Service API
30AQBWCATInfoSource Catalog (SAP Query) Customer10LTIMESAP Query (S): Timenvarchar60
31AQBWCAT_SAPInfoSource Catalog (SAP Query) Used by SAP10LTIMESAP Query (S): Timenvarchar60
TOPClinical System
32N2TRANSPORTLOGi.s.h.med: Log File on N2TRANSPORT6LTIMEi.s.h.med: Log Timenvarchar60
TOPConfirmations
33AFRP0Table of planned changes for confirmation (PDC)100LTIMELogical timenvarchar60
34AFRVConfirmation pool50LTIMETime receivednvarchar60
35AFRV_DELBackup Copy for Confirmation Pool50LTIMETime receivednvarchar60
TOPContract Accounts Receivable and Payable
36EKLPCIHistory of Charges for Installment Plan Items (LPC in USA)6LTIMETime of Entrynvarchar60
TOPCross-System Tools
37SCDTOBJECTCross-System Customizing Object7LTIMETIME Data Element for SYSTnvarchar60
TOPCustomer Interaction Center
38CCMLOGActivity log4LTIMESystem Timenvarchar60
TOPCustomizing Tools Techniques
39TCTM_ATTRTable of Attributes for Context Management10LTIMELast changed atnvarchar60
40TCTM_COTYCentral Context Management Context Object Types13LTIMELast changed atnvarchar60
TOPData Collection
41TKEBXAdministration of exceptions10LTIMETime of last threshold value checknvarchar60
TOPDocument Management Framework
42KDS_NODENode Table for General Structure Storage36LTIMETime of Last Changenvarchar60
TOPDocument Management Services
43SDOKNODESDOK: Node table for general structure repository36LTIMETime of Last Changenvarchar60
TOPeCATT Extended Computer Aided Test Tool
44ECATT_VERTable for Storing Versions of eCATTs13LTIMETime of Last Changenvarchar60
45ECBR_NODESHI3 ECBR/ECBO - Node Table for eCATT Browser Nodes36LTIMETime of Last Changenvarchar60
46ECRP_DEFOBSOLETE -8LTIMETime of Last Changenvarchar60
47ECSD_DEFTable for Defining System Data Containers8LTIMETime of Last Changenvarchar60
48ECSP_DEFTable for eCATT Start Profiles (eCATT Core)8LTIMETime of Last Changenvarchar60
49ECTC_ATTACHExternal Documents linked to eCATT Objects16LTIMETime of Last Changenvarchar60
50ECTC_VERTable for Storing Versions of Test Configurations13LTIMETime of Last Changenvarchar60
51ECTD_SYNCXSynchronization for ECTD_DATAX6LTIMETime of Last Changenvarchar60
52ECTD_VERTable for Storing Versions of Test Data Containers13LTIMETime of Last Changenvarchar60
53ECTP_JOB_DATATest Proxy: Data for test executions5LTIMETest Proxy: Time of Last Changenvarchar60
54ECTP_JOB_LISTForeground Scheduler: List of test executions14LTIMETest Proxy: Time of Last Changenvarchar60
55ECVO_VEReCATT Table for Versions of Validation Objects13LTIMETime of Last Changenvarchar60
56ECWS_SECURETable for Security Aspects in Web Service6LTIMETime of Last Changenvarchar60
TOPEnvironment, Health and Safety
57T7EHS00_FKATALOGAdministration Data EH&S Question Catalog17LTIMETime of Last Changenvarchar60
58T7EHS00_QEDITORQuestion Text EH&S Question Catalog (Language-Specific)11LTIMETime of Last Changenvarchar60
59T7EHS00_QUESTQuestionnaire Definition8LTIMETime of Last Changenvarchar60
60T7EHS00_QUESTQIndividual Questions in Questionnaire13LTIMETime of Last Changenvarchar60
TOPForms
61T59_PROTERPDSYS-SE61 Conversion: Log Table Error8LTIMELast Changed atnvarchar60
62T59_PROTLRPDSYS-SE61 Conversion: Log Table Reference8LTIMELast Changed atnvarchar60
63T59_PROTMRPDSYS-SE61 Conversion: Log Table Modules8LTIMELast Changed atnvarchar60
TOPGlobal Trade Services
64/SAPSLL/TDPDATGTS: Rule Definition for Default Date6LTIMELead Time in Days for Data Defaultingdecimal30
TOPHierarchy Storage
65TARCH01Node Table for General Structure Storage36LTIMETime of Last Changenvarchar60
66TNODE01Node Table for General Structure Storage36LTIMETime of Last Changenvarchar60
67TNODEHList of valid node types9LTIMETime of Last Changenvarchar60
68TRTYPEHList of valid link types16LTIMETime of Last Changenvarchar60
69TTREEDefinition table for structures20LTIMETime of Last Changenvarchar60
70TTREETYPEList of valid structure types15LTIMETime of Last Changenvarchar60
71TTREVVersions: Header Data19LTIMETime of Last Changenvarchar60
72TTREV_NODEHierarchy Tool: Structure Versioning Node Table32LTIMETime of Last Changenvarchar60
TOPImplementation Guide
73CUS_IMGACHIMG Activities11LTIMETime of Last Changenvarchar60
74DSYAHStructures: Header Data12LTIMETime of last change to documentationnvarchar60
75DSYAVStructures: Directory of Views on Books10LTIMETime of last change to documentationnvarchar60
76DSYOHHypertext: Version Management Structure14LTIMELast Changed atnvarchar60
77DSYOIDSYS Grouping - Aspect, Status, Version, Processed by13LTIMELast Changed atnvarchar60
78EXCEPT1IMG Activity-Specific BC Set Error Exception Table17LTIMETimenvarchar60
79EXCEPT2Object-Specific BC Set Error Case Exception Table14LTIMETimenvarchar60
80TCUSPCustomizing: Implementation project profile16LTIMECreation/change timenvarchar60
81TCUSP40Customizing: Implementation project profile16LTIMECreation/change timenvarchar60
82TDOKUIMGNode Table for General Structure Storage36LTIMETime of Last Changenvarchar60
83TNODEIMGNode table for the new IMG36LTIMETime of Last Changenvarchar60
84TNODEPRNode Table for General Structure Storage36LTIMETime of Last Changenvarchar60
85TNODERELNNode Table for General Structure Storage36LTIMETime of Last Changenvarchar60
86TPRCLASSProject Management Project Classes8LTIMEChanged Atnvarchar60
87TPROJECTSPROJECT: Project Table27LTIMEChanged Atnvarchar60
88TSTAHPRStatus: Project Status Information23LTIMEChanged Atnvarchar60
89TSTAHTWTWB Status Management: Status Information27LTIMEChanged Atnvarchar60
TOPIndia
90T7INJ5HR-IN: Loans Dusbursement Schedule7LTIMETime Duration for each sequence number of tranchenvarchar50
TOPInvoicing
91EKLPCINVHistory of Charges for Installment Plan Items (LPC in USA)7LTIMETime of Entrynvarchar60
TOPKnowledge Warehouse
92CUSTNODENode Table for General Structure Storage36LTIMETime of Last Changenvarchar60
93IWB0NODENode Table for General Structure Storage36LTIMETime of Last Changenvarchar60
94IWB1NODENode Table for General Structure Storage36LTIMETime of Last Changenvarchar60
95IWB2NODENode Table for General Structure Storage36LTIMETime of Last Changenvarchar60
96IWB7NODENode Table for General Structure Storage36LTIMETime of Last Changenvarchar60
97KWN_NODENode Table for General Structure Storage36LTIMETime of Last Changenvarchar60
98TXML_NODEXML: table of nodes36LTIMETime of Last Changenvarchar60
TOPLocalization
99ITFM_D_RESIDUALSITFM: Residuals: EFD Residuals data Table11LTIMETime of last generation (in connection with date)nvarchar60
TOPMenu Painter
100D344LHeader for language load of master language3LTIMETime of last generation (in connection with date)nvarchar60
TOPPerformance Assessment Workbench
101KWPWNODENode Table for General Structure Storage36LTIMETime of Last Changenvarchar60
TOPPersonnel Time Events
102TPTCOR_CORECore Information (Correction Scenario)7LTIMELogical timenvarchar60
TOPPersonnel Time Management
103CC1ERPIncorrect Time Events from CC1, Postings7LTIMELogical timenvarchar60
104CC1TEVTemporary Buffer for Time Events from CC16LTIMELogical timenvarchar60
105TEVENTime Events5LTIMELogical timenvarchar60
106TEVEN_MOREAdditional Data for Time Events6LTIMELogical timenvarchar60
107TEXLGAEmployee Expenditures6LTIMELogical timenvarchar60
TOPPlant Data Collection
108RUECKTemp. storage for subsystem confirmations45LTIMELogical timenvarchar60
TOPProduct Cost Planning
109TCWB_TESTDATATestdaten11LTIMEZeitpunkt der letzten Änderungnvarchar60
110TDATASETCATT-Daten12LTIMEZeitpunkt der letzten Änderungnvarchar60
TOPProfitability Analysis
111TKENODE01CO-PA: Node Table for General Structure Repository36LTIMETime of Last Changenvarchar60
TOPSAP Business Workflow
112WFERRWorkflow: Error in processes15LTIMEWorkflow: Last change: Timenvarchar60
113WFPRCWorkflow: Process object: Definition12LTIMEWorkflow: Last change: Timenvarchar60
TOPSAPscript
114TFORM01Node Table for SAPscript Form Tree36LTIMETime of Last Changenvarchar60
TOPService
115DVS1NODENode Table for General Structure Storage36LTIMETime of Last Changenvarchar60
TOPSession Manager
116BMENTTREEDefinition Table for Structures17LTIMETime of Last Changenvarchar60
117TMENU01Node Table for General Structure Storage36LTIMETime of Last Changenvarchar60
118TMENUBK01Node Table for General Structure Storage36LTIMETime of Last Changenvarchar60
TOPTest Organizer
119STWB_SETCentral Settings8LTIMETime of Last Changenvarchar60
120TNODE02Test Organizer, Node Table36LTIMETime of Last Changenvarchar60
121TNODE02_ATest case attributes: Management8LTIMETime of Last Changenvarchar60
122TWB_CUST_PRIOCustomizing of Message Priorities6LTIMETime of Last Changenvarchar60
123TWB_CUST_STATMessage Status Customizing7LTIMETime of Last Changenvarchar60
124TWB_PRODUCTProduct and Product Release8LTIMETime of Last Changenvarchar60
125TWB_RMPWork Breakdown Structure Elements (WBS Elements)9LTIMETime of Last Changenvarchar60
126TWB_TPRProduct5LTIMETime of Last Changenvarchar60
TOPTest Plan Management
127E2ET_TR_RT_MAPPE2W Testing Agent: Transport Object-Runtime Object Mapping11LTIMESystem Timenvarchar60
128E2ET_TR_RT_MAPPKBPCA: Transport Object-Runtime Object Mapping Key16LTIMESystem Timenvarchar60
TOPTime Tickets
129EVHRHR Order Confirmations (Times/Time Events)6LTIMELogical timenvarchar60
130LSHRHR Order Confirmations (Durations/Time Tickets)6LTIMELogical timenvarchar60
TOPTreasury
131VTB_DFPRTDatafeed: Printer/Login Information for Asynchronous Users26LTIMELast Logon Timenvarchar60
TOPUser Administration
132BAPIUSW01User ID Table for Internet Appplication Components12LTIMELast Logon Timenvarchar60
133SPERS_OBJPersonalization object repository8LTIMETimenvarchar60
TOPWeb Dynpro ABAP Runtime
134WDRCSFCHECKTable for Web Dynpro CSF Strings for a Later Analysis3LTIMELast changed atnvarchar60
TOPWorkbench Utilities
135RLB_DB_TRReuse Library: Structure Repository: Nodes36LTIMETime of Last Changenvarchar60