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

120 columns | Print definition?ERP 6.0  | LUSER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BPCA_TABK_EXCBPCA Table Key Recording: Table to always include3LUSERUser Namenvarchar120
2ETALLPAIRS_HEADHeader Data of AllPairs Objects7LUSERLast changed bynvarchar120
3MDS_OBJHMDS: OBJH to a specific simulation version17LUSERUser Namenvarchar120
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
4CRM_TCKADDCOMPSTCK Checkman for Solutions: Additional Components6LUSERUser Namenvarchar120
5CRM_TCKCOMP4PRODTCK Checkman for Solutions: Product's Components8LUSERUser Namenvarchar120
6CRM_TCKDBSYSTCK Checkman for Solutions: Database Systems9LUSERUser Namenvarchar120
7CRM_TCKHOSTSTCK Checkman for Solutions: Hosts8LUSERUser Namenvarchar120
8CRM_TCKINSTANCESTCK Checkman for Solutions: Instances14LUSERUser Namenvarchar120
9CRM_TCKPRODUCTSTCK Checkman for Solutions: Products of Solutions5LUSERUser Namenvarchar120
10CRM_TCKSOLPRODTCK Checkman for Solutions: Products4LUSERUser Namenvarchar120
11CRM_TCKSOLUTIONSTCK Checkman for Solutions: Solution List4LUSERUser Namenvarchar120
12CRM_TCKSYSTEMSTCK Checkman for Solutions: R/3 Systems7LUSERUser Namenvarchar120
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
13UTCMPVerification Table for Decider in DD_DECIDE15LUSERLast Changed bynvarchar120
TOPArchiveLink
14TOALOGCUSTTable for Customizing ArchiveLink Log6LUSERUser Name in User Master Recordnvarchar120
TOPASAP AcceleratedSAP
15IATNODE01Node Table for Implementation Assistant34LUSERLast changed bynvarchar120
16TCUSTEMPCustomizing templates entity table7LUSERChanged bynvarchar120
17TNODEREVStructure Item Table for Review Structures34LUSERLast changed bynvarchar120
TOPASAP Tools and Contents
18SMAPTNODESolution Map: Node table34LUSERLast changed bynvarchar120
TOPAuthoring Tools
19QMM_NODEQMM: Node Table for General Structure Storage34LUSERLast changed bynvarchar120
TOPBusiness Navigator
20BMTNODE01Structure repository for process model objects: Node table34LUSERLast changed bynvarchar120
21DFTNODE01Structure repository for process model objects: Node table34LUSERLast changed bynvarchar120
TOPClinical System
22N2TRANSPORTLOGi.s.h.med: Log File on N2TRANSPORT4LUSERi.s.h.med: Log Usernvarchar120
TOPCollaborative Cross Applications
23/POA/D_CLM_CM02Content Group Comparison7LUSERLast Changed Bynvarchar120
TOPCross-System Tools
24MCSTATLISTMultiple Client Analysis: Status List14LUSERUser Namenvarchar120
25SCDTOBJECTCross-System Customizing Object5LUSERUser Namenvarchar120
TOPCustomizing Tools Techniques
26TCMPHeader Table, Generic Comparison Tool7LUSERUser Namenvarchar120
27TCTM_ATTRTable of Attributes for Context Management8LUSERLast Changed Bynvarchar120
28TCTM_COTYCentral Context Management Context Object Types11LUSERLast Changed Bynvarchar120
TOPDocument Management Framework
29KDS_NODENode Table for General Structure Storage34LUSERLast changed bynvarchar120
TOPDocument Management Services
30SDOKNODESDOK: Node table for general structure repository34LUSERLast changed bynvarchar120
TOPeCATT Extended Computer Aided Test Tool
31ECATT_VERTable for Storing Versions of eCATTs11LUSERLast changed bynvarchar120
32ECBR_NODESHI3 ECBR/ECBO - Node Table for eCATT Browser Nodes34LUSERLast changed bynvarchar120
33ECRP_DEFOBSOLETE -6LUSERLast changed bynvarchar120
34ECSD_DEFTable for Defining System Data Containers6LUSERLast changed bynvarchar120
35ECSP_DEFTable for eCATT Start Profiles (eCATT Core)6LUSERLast changed bynvarchar120
36ECTC_ATTACHExternal Documents linked to eCATT Objects14LUSERLast changed bynvarchar120
37ECTC_VERTable for Storing Versions of Test Configurations11LUSERLast changed bynvarchar120
38ECTD_SYNCXSynchronization for ECTD_DATAX4LUSERLast changed bynvarchar120
39ECTD_VERTable for Storing Versions of Test Data Containers11LUSERLast changed bynvarchar120
40ECTP_JOB_DATATest Proxy: Data for test executions3LUSERTest Proxy: Last changed by Usernvarchar120
41ECTP_JOB_LISTForeground Scheduler: List of test executions12LUSERTest Proxy: Last changed by Usernvarchar120
42ECVO_VEReCATT Table for Versions of Validation Objects11LUSERLast changed bynvarchar120
43ECWS_SECURETable for Security Aspects in Web Service4LUSERLast changed bynvarchar120
TOPEnvironment, Health and Safety
44T7EHS00_FKATALOGAdministration Data EH&S Question Catalog15LUSERLast Changed Bynvarchar120
45T7EHS00_QUESTQuestionnaire Definition7LUSERLast Changed Bynvarchar120
46T7EHS00_QUESTQIndividual Questions in Questionnaire11LUSERLast Changed Bynvarchar120
TOPForms
47T59_PROTMRPDSYS-SE61 Conversion: Log Table Modules9LUSERLast changed bynvarchar120
TOPHierarchy Storage
48TARCH01Node Table for General Structure Storage34LUSERLast changed bynvarchar120
49TNODE01Node Table for General Structure Storage34LUSERLast changed bynvarchar120
50TNODEHList of valid node types7LUSERLast changed bynvarchar120
51TRTYPEHList of valid link types14LUSERLast changed bynvarchar120
52TTREEDefinition table for structures18LUSERLast changed bynvarchar120
53TTREETYPEList of valid structure types13LUSERLast changed bynvarchar120
54TTREVVersions: Header Data17LUSERLast changed bynvarchar120
55TTREV_NODEHierarchy Tool: Structure Versioning Node Table30LUSERLast changed bynvarchar120
TOPImplementation Guide
56CTIMPEXCLogical import: exception table7LUSERUser Namenvarchar120
57CUS_ACTHCustomizing Activity - Header Data5LUSERLast changed bynvarchar120
58CUS_ATRHCustomizing Attributes - Header Data9LUSERLast changed bynvarchar120
59CUS_ATRVSEAttribute Variant Sequence4LUSERUser Namenvarchar120
60CUS_IMGACHIMG Activities9LUSERLast changed bynvarchar120
61DSYAHStructures: Header Data10LUSERDocumentation last changed bynvarchar120
62DSYAVStructures: Directory of Views on Books8LUSERDocumentation last changed bynvarchar120
63DSYOHHypertext: Version Management Structure11LUSERLast changed bynvarchar120
64DSYOIDSYS Grouping - Aspect, Status, Version, Processed by10LUSERLast changed bynvarchar120
65EXCEPT1IMG Activity-Specific BC Set Error Exception Table15LUSERUser Namenvarchar120
66EXCEPT2Object-Specific BC Set Error Case Exception Table12LUSERUser Namenvarchar120
67TCUSPCustomizing: Implementation project profile14LUSERChanged bynvarchar120
68TCUSP40Customizing: Implementation project profile14LUSERChanged bynvarchar120
69TDOKUIMGNode Table for General Structure Storage34LUSERLast changed bynvarchar120
70TNODEIMGNode table for the new IMG34LUSERLast changed bynvarchar120
71TNODEPRNode Table for General Structure Storage34LUSERLast changed bynvarchar120
72TNODERELNNode Table for General Structure Storage34LUSERLast changed bynvarchar120
73TPRCLASSProject Management Project Classes6LUSERChanged bynvarchar120
74TPROJECTSPROJECT: Project Table25LUSERChanged bynvarchar120
75TSTAHPRStatus: Project Status Information21LUSERChanged bynvarchar120
76TSTAHTWTWB Status Management: Status Information25LUSERChanged bynvarchar120
77TSTATHStatus fields for an activity in a project25LUSERChanged bynvarchar120
78TSTATH4Status information for Test Workbench13LUSERChanged bynvarchar120
79TVARHHeader entries for screen variants7LUSERDocumentation last changed bynvarchar120
TOPKnowledge Warehouse
80CUSTNODENode Table for General Structure Storage34LUSERLast changed bynvarchar120
81IWB0NODENode Table for General Structure Storage34LUSERLast changed bynvarchar120
82IWB1NODENode Table for General Structure Storage34LUSERLast changed bynvarchar120
83IWB2NODENode Table for General Structure Storage34LUSERLast changed bynvarchar120
84IWB7NODENode Table for General Structure Storage34LUSERLast changed bynvarchar120
85KWN_NODENode Table for General Structure Storage34LUSERLast changed bynvarchar120
86TXML_NODEXML: table of nodes34LUSERLast changed bynvarchar120
TOPLocalization
87ITFM_D_RESIDUALSITFM: Residuals: EFD Residuals data Table12LUSERName of last user to generatenvarchar120
TOPMenu Painter
88D344LHeader for language load of master language4LUSERName of last user to generatenvarchar120
TOPOccupational Health
89T7EHS00_BEFUSLResult Code7LUSERUser Namenvarchar120
90T7EHS00_DIAGSLDiagnosis Key7LUSERUser Namenvarchar120
TOPPackage Tools
91AKB_RUNLISTObsolete: Information for Decoupling Administration20LUSERUser Namenvarchar120
92AKB_SYSLISTObsolete: BCB System List for Replication11LUSERUser Namenvarchar120
93AKB_TRANS_CHECKObsolete: Compatibility Control24LUSERLast Changed bynvarchar120
94AKB_TRANS_HEADObsolete: List of Checked Transports4LUSERLast Changed bynvarchar120
95APAUSEDBasis Objects Used in Other Packages14LUSERLast changed bynvarchar120
96APAUSED_TESTBasis Objects Used in Other Packages14LUSERLast changed bynvarchar120
TOPPerformance Assessment Workbench
97KWPWNODENode Table for General Structure Storage34LUSERLast changed bynvarchar120
TOPProduct Cost Planning
98TCWB_TESTDATATestdaten9LUSERLetzter Änderernvarchar120
99TDATASETCATT-Daten10LUSERLetzter Änderernvarchar120
TOPProfitability Analysis
100TKENODE01CO-PA: Node Table for General Structure Repository34LUSERLast changed bynvarchar120
TOPSAP Business Workflow
101WFERRWorkflow: Error in processes13LUSERWorkflow: SAP name of the user who last changed the processnvarchar120
102WFPRCWorkflow: Process object: Definition10LUSERWorkflow: SAP name of the user who last changed the processnvarchar120
TOPSAPscript
103TFORM01Node Table for SAPscript Form Tree34LUSERLast changed bynvarchar120
TOPService
104DVS1NODENode Table for General Structure Storage34LUSERLast changed bynvarchar120
TOPSession Manager
105BMENTTREEDefinition Table for Structures15LUSERLast changed bynvarchar120
106TMENU01Node Table for General Structure Storage34LUSERLast changed bynvarchar120
107TMENUBK01Node Table for General Structure Storage34LUSERLast changed bynvarchar120
TOPTest Organizer
108STWB_SETCentral Settings6LUSERLast changed bynvarchar120
109TNODE02Test Organizer, Node Table34LUSERLast changed bynvarchar120
110TNODE02_ATest case attributes: Management6LUSERLast changed bynvarchar120
111TWB_CUST_PRIOCustomizing of Message Priorities4LUSERLast changed bynvarchar120
112TWB_CUST_STATMessage Status Customizing5LUSERLast changed bynvarchar120
113TWB_PRODUCTProduct and Product Release6LUSERLast Changed Bynvarchar120
114TWB_RMPWork Breakdown Structure Elements (WBS Elements)7LUSERLast Changed Bynvarchar120
115TWB_TPRProduct3LUSERLast changed bynvarchar120
TOPTest Plan Management
116E2ET_TR_RT_MAPPE2W Testing Agent: Transport Object-Runtime Object Mapping9LUSERUser Namenvarchar120
117E2ET_TR_RT_MAPPKBPCA: Transport Object-Runtime Object Mapping Key14LUSERUser Namenvarchar120
TOPTransport Organizer
118OBJHObject: Header16LUSERUser Namenvarchar120
119OBJSUBSubobjects13LUSERUser Namenvarchar120
TOPWorkbench Utilities
120RLB_DB_TRReuse Library: Structure Repository: Nodes34LUSERLast changed bynvarchar120