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

163 columns | Print definition?ERP 6.0  | LDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BPCA_TABK_EXCBPCA Table Key Recording: Table to always include4LDATESystem Datenvarchar80
2CNVCMIS_A_1_MSAGMessage IDs for T10010LDATEDate of Last Changenvarchar80
3ETALLPAIRS_HEADHeader Data of AllPairs Objects8LDATELast Changed Onnvarchar80
4MDS_OBJHMDS: OBJH to a specific simulation version18LDATEDatenvarchar80
5P2B2_ATHCM Declustering B2 - Table for AT7LDATELogical Datenvarchar80
6P2B2_CWSTHCM Declustering B2 - PDC Time Tickets7LDATELogical Datenvarchar80
7P2B2_FEHLERHCM Declustering B2 - Messages (Table FEHLER)7LDATELogical Datenvarchar80
8P2B2_PTHCM Declustering B2 - Time Event Pairs7LDATELogical Datenvarchar80
9P2B2_WSTHCM Declustering B2 - PDC Time Tickets7LDATELogical Datenvarchar80
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
10CRM_TCKADDCOMPSTCK Checkman for Solutions: Additional Components7LDATESystem Datenvarchar80
11CRM_TCKCOMP4PRODTCK Checkman for Solutions: Product's Components9LDATESystem Datenvarchar80
12CRM_TCKDBSYSTCK Checkman for Solutions: Database Systems10LDATESystem Datenvarchar80
13CRM_TCKHOSTSTCK Checkman for Solutions: Hosts9LDATESystem Datenvarchar80
14CRM_TCKINSTANCESTCK Checkman for Solutions: Instances15LDATESystem Datenvarchar80
15CRM_TCKPRODUCTSTCK Checkman for Solutions: Products of Solutions6LDATESystem Datenvarchar80
16CRM_TCKSOLPRODTCK Checkman for Solutions: Products5LDATESystem Datenvarchar80
17CRM_TCKSOLUTIONSTCK Checkman for Solutions: Solution List5LDATESystem Datenvarchar80
18CRM_TCKSYSTEMSTCK Checkman for Solutions: R/3 Systems8LDATESystem Datenvarchar80
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
19T100AMessage IDs for T1006LDATEDate of Last Changenvarchar80
20UTCMPVerification Table for Decider in DD_DECIDE16LDATEDate of Last Changenvarchar80
TOPALE Integration Technology
21EDBASBasic types11LDATEIDoc development: Last changed onnvarchar80
22EDCIMExtensions11LDATEIDoc development: Last changed onnvarchar80
23EDISDEFIDoc Development : IDoc Segment Definitions8LDATEIDoc development: Last changed onnvarchar80
24EDISEGMENTIDoc Development : IDoc Segment9LDATEIDoc development: Last changed onnvarchar80
TOPASAP AcceleratedSAP
25IATNODE01Node Table for Implementation Assistant35LDATELast Changed Onnvarchar80
26TCUSTEMPCustomizing templates entity table6LDATEChanged Onnvarchar80
27TNODEREVStructure Item Table for Review Structures35LDATELast Changed Onnvarchar80
TOPASAP Tools and Contents
28SMAPTNODESolution Map: Node table35LDATELast Changed Onnvarchar80
TOPAuthoring Tools
29QMM_NODEQMM: Node Table for General Structure Storage35LDATELast Changed Onnvarchar80
TOPBusiness Configuration Sets
30SCPREXCPTBC Set: Control Table for Exceptions10LDATEBC Set: Changed onnvarchar80
TOPBusiness Navigator
31BMTNODE01Structure repository for process model objects: Node table35LDATELast Changed Onnvarchar80
32DFTNODE01Structure repository for process model objects: Node table35LDATELast Changed Onnvarchar80
TOPBW Service API
33AQBWCATInfoSource Catalog (SAP Query) Customer9LDATESAP Query (S): Datenvarchar80
34AQBWCAT_SAPInfoSource Catalog (SAP Query) Used by SAP9LDATESAP Query (S): Datenvarchar80
TOPCanada
35T5KSNROE Serial Number4LDATEDate of last day workednvarchar80
TOPClinical System
36N2TRANSPORTLOGi.s.h.med: Log File on N2TRANSPORT5LDATEi.s.h.med: Log Datenvarchar80
TOPConfirmations
37AFRP0Table of planned changes for confirmation (PDC)99LDATELogical Datenvarchar80
38AFRVConfirmation pool49LDATEEntry Datenvarchar80
39AFRV_DELBackup Copy for Confirmation Pool49LDATEEntry Datenvarchar80
TOPContract Accounts Receivable and Payable
40EKLPCIHistory of Charges for Installment Plan Items (LPC in USA)5LDATEDate on Which Entry Was Creatednvarchar80
41TFKSYSSTATStatus Table for Contract Accounts Receivable and Payable4LDATEnvarchar80
TOPCross-System Tools
42MCSTATLISTMultiple Client Analysis: Status List13LDATEDatenvarchar80
43SCDTOBJECTCross-System Customizing Object6LDATESystem Datenvarchar80
TOPCustomer Interaction Center
44CCMLOGActivity log3LDATESystem Datenvarchar80
TOPCustomizing Tools Techniques
45TCTM_ATTRTable of Attributes for Context Management9LDATEChanged Onnvarchar80
46TCTM_COTYCentral Context Management Context Object Types12LDATEChanged Onnvarchar80
TOPData Collection
47TKEBXAdministration of exceptions9LDATEDate of last threshold value checknvarchar80
TOPDocument Management Framework
48KDS_NODENode Table for General Structure Storage35LDATELast Changed Onnvarchar80
TOPDocument Management Services
49SDOKNODESDOK: Node table for general structure repository35LDATELast Changed Onnvarchar80
TOPeCATT Extended Computer Aided Test Tool
50ECATT_VERTable for Storing Versions of eCATTs12LDATELast Changed Onnvarchar80
51ECBR_NODESHI3 ECBR/ECBO - Node Table for eCATT Browser Nodes35LDATELast Changed Onnvarchar80
52ECRP_DEFOBSOLETE -7LDATELast Changed Onnvarchar80
53ECSD_DEFTable for Defining System Data Containers7LDATELast Changed Onnvarchar80
54ECSP_DEFTable for eCATT Start Profiles (eCATT Core)7LDATELast Changed Onnvarchar80
55ECTC_ATTACHExternal Documents linked to eCATT Objects15LDATELast Changed Onnvarchar80
56ECTC_VERTable for Storing Versions of Test Configurations12LDATELast Changed Onnvarchar80
57ECTD_SYNCXSynchronization for ECTD_DATAX5LDATELast Changed Onnvarchar80
58ECTD_VERTable for Storing Versions of Test Data Containers12LDATELast Changed Onnvarchar80
59ECTP_JOB_DATATest Proxy: Data for test executions4LDATETest Proxy: Last Changed On Datenvarchar80
60ECTP_JOB_LISTForeground Scheduler: List of test executions13LDATETest Proxy: Last Changed On Datenvarchar80
61ECVO_VEReCATT Table for Versions of Validation Objects12LDATELast Changed Onnvarchar80
62ECWS_SECURETable for Security Aspects in Web Service5LDATELast Changed Onnvarchar80
TOPEnvironment, Health and Safety
63T7EHS00_FKATALOGAdministration Data EH&S Question Catalog16LDATEChanged Onnvarchar80
64T7EHS00_QUESTQuestionnaire Definition6LDATEChanged Onnvarchar80
65T7EHS00_QUESTQIndividual Questions in Questionnaire12LDATEChanged Onnvarchar80
TOPForms
66T59_PROTERPDSYS-SE61 Conversion: Log Table Error7LDATEChanged Onnvarchar80
67T59_PROTLRPDSYS-SE61 Conversion: Log Table Reference7LDATEChanged Onnvarchar80
68T59_PROTMRPDSYS-SE61 Conversion: Log Table Modules7LDATEChanged Onnvarchar80
TOPHierarchy Storage
69TARCH01Node Table for General Structure Storage35LDATELast Changed Onnvarchar80
70TNODE01Node Table for General Structure Storage35LDATELast Changed Onnvarchar80
71TNODEHList of valid node types8LDATELast Changed Onnvarchar80
72TRTYPEHList of valid link types15LDATELast Changed Onnvarchar80
73TTREEDefinition table for structures19LDATELast Changed Onnvarchar80
74TTREETYPEList of valid structure types14LDATELast Changed Onnvarchar80
75TTREVVersions: Header Data18LDATELast Changed Onnvarchar80
76TTREV_NODEHierarchy Tool: Structure Versioning Node Table31LDATELast Changed Onnvarchar80
TOPImplementation Guide
77CTIMPEXCLogical import: exception table8LDATEDatenvarchar80
78CUS_ATRVSEAttribute Variant Sequence5LDATESystem Datenvarchar80
79CUS_IMGACHIMG Activities10LDATELast Changed Onnvarchar80
80DSYAHStructures: Header Data11LDATEDate of last change to documentationnvarchar80
81DSYAVStructures: Directory of Views on Books9LDATEDate of last change to documentationnvarchar80
82DSYOHHypertext: Version Management Structure13LDATEChanged Onnvarchar80
83DSYOIDSYS Grouping - Aspect, Status, Version, Processed by12LDATEChanged Onnvarchar80
84EXCEPT1IMG Activity-Specific BC Set Error Exception Table16LDATEDatenvarchar80
85EXCEPT2Object-Specific BC Set Error Case Exception Table13LDATEDatenvarchar80
86TCUSPCustomizing: Implementation project profile15LDATEChanged Onnvarchar80
87TCUSP40Customizing: Implementation project profile15LDATEChanged Onnvarchar80
88TDOKUIMGNode Table for General Structure Storage35LDATELast Changed Onnvarchar80
89TNODEIMGNode table for the new IMG35LDATELast Changed Onnvarchar80
90TNODEPRNode Table for General Structure Storage35LDATELast Changed Onnvarchar80
91TNODERELNNode Table for General Structure Storage35LDATELast Changed Onnvarchar80
92TPRCLASSProject Management Project Classes5LDATEChanged Onnvarchar80
93TPROJECTSPROJECT: Project Table24LDATEChanged Onnvarchar80
94TSTAHPRStatus: Project Status Information20LDATEChanged Onnvarchar80
95TSTAHTWTWB Status Management: Status Information24LDATEChanged Onnvarchar80
96TSTATHStatus fields for an activity in a project24LDATEChanged Onnvarchar80
97TSTATH4Status information for Test Workbench12LDATEChanged Onnvarchar80
98TVARHHeader entries for screen variants8LDATEDate of last change to documentationnvarchar80
TOPInterest
99TPI03CO Objects: Date of Last Interest Run3LDATEProject: date of last interest runnvarchar80
TOPInvoicing
100EKLPCINVHistory of Charges for Installment Plan Items (LPC in USA)6LDATEDate on Which Entry Was Creatednvarchar80
TOPKnowledge Warehouse
101CUSTNODENode Table for General Structure Storage35LDATELast Changed Onnvarchar80
102IWB0NODENode Table for General Structure Storage35LDATELast Changed Onnvarchar80
103IWB1NODENode Table for General Structure Storage35LDATELast Changed Onnvarchar80
104IWB2NODENode Table for General Structure Storage35LDATELast Changed Onnvarchar80
105IWB7NODENode Table for General Structure Storage35LDATELast Changed Onnvarchar80
106KWN_NODENode Table for General Structure Storage35LDATELast Changed Onnvarchar80
107TXML_NODEXML: table of nodes35LDATELast Changed Onnvarchar80
TOPLocalization
108ITFM_D_RESIDUALSITFM: Residuals: EFD Residuals data Table10LDATEDate of last generationnvarchar80
TOPMaster Data
109T442CControl: activity reqmts transfer MRP/SOP -> CO11LDATEDate of the last activity reqmt transfer from SAP/MRP to COnvarchar80
TOPMenu Painter
110D344LHeader for language load of master language2LDATEDate of last generationnvarchar80
TOPOccupational Health
111T7EHS00_BEFUSLResult Code8LDATEChanged onnvarchar80
112T7EHS00_DIAGSLDiagnosis Key8LDATEChanged onnvarchar80
TOPPackage Tools
113AKB_SYSLISTObsolete: BCB System List for Replication12LDATEDatenvarchar80
114AKB_TRANS_CHECKObsolete: Compatibility Control25LDATEDate of Last Changenvarchar80
115AKB_TRANS_HEADObsolete: List of Checked Transports5LDATEDate of Last Changenvarchar80
116APAUSEDBasis Objects Used in Other Packages13LDATEChanged Onnvarchar80
117APAUSED_TESTBasis Objects Used in Other Packages13LDATEChanged Onnvarchar80
TOPPayroll
118T7ROG3EE register - EE history21LDATEStart Datenvarchar80
119T7ROG7EE register - Contract History24LDATEStart Datenvarchar80
TOPPerformance Assessment Workbench
120KWPWNODENode Table for General Structure Storage35LDATELast Changed Onnvarchar80
TOPPersonnel Time Events
121TPTCOR_CORECore Information (Correction Scenario)6LDATELogical Datenvarchar80
TOPPersonnel Time Management
122CC1ERPIncorrect Time Events from CC1, Postings6LDATELogical Datenvarchar80
123CC1TEVTemporary Buffer for Time Events from CC15LDATELogical Datenvarchar80
124TEVENTime Events4LDATELogical Datenvarchar80
125TEVEN_MOREAdditional Data for Time Events5LDATELogical Datenvarchar80
126TEXLGAEmployee Expenditures5LDATELogical Datenvarchar80
TOPPlant Data Collection
127RUECKTemp. storage for subsystem confirmations44LDATELogical Datenvarchar80
TOPProduct Cost Planning
128TCWB_TESTDATATestdaten10LDATEDatum der letzten Änderungnvarchar80
129TDATASETCATT-Daten11LDATEDatum der letzten Änderungnvarchar80
TOPProfitability Analysis
130TKENODE01CO-PA: Node Table for General Structure Repository35LDATELast Changed Onnvarchar80
TOPPurchasing
131T16LFRoutines for Data Retrieval in Requisition Lists1LDATEName of Routine for Data Retrieval for Linenvarchar30
132T16LGTexts for Routines for Data Retrieval in Requisition Lists2LDATEName of Routine for Data Retrieval for Linenvarchar30
133T16LIData Retrieval for List Scope: Purchase Requisitions4LDATEName of Routine for Data Retrieval for Linenvarchar30
TOPRemaining Beverage - Obsolete Objects
134/BEV1/RSFFRHDHeader Data for Collection Assignment4LDATEDate of Collection Assignmentnvarchar80
135/BEV1/RSFFRINTable of Invoice Data7LDATEDate of Collection Assignmentnvarchar80
TOPSAP Business Workflow
136WFERRWorkflow: Error in processes14LDATEWorkflow: Last changed: Datenvarchar80
137WFPRCWorkflow: Process object: Definition11LDATEWorkflow: Last changed: Datenvarchar80
TOPSAP Healthcare - Industry-Specific Components for Hospitals
138NWCH_BOA_ARCHProtokoll-Archiv für die Massendeckungsabfrage9LDATELetzte Abfrage vor demnvarchar80
139NWCH_BOA_PROTProtokoll für die Massendeckungsabfrage9LDATELetzte Abfrage vor demnvarchar80
TOPSAPscript
140TFORM01Node Table for SAPscript Form Tree35LDATELast Changed Onnvarchar80
TOPService
141DVS1NODENode Table for General Structure Storage35LDATELast Changed Onnvarchar80
TOPSession Manager
142BMENTTREEDefinition Table for Structures16LDATELast Changed Onnvarchar80
143TMENU01Node Table for General Structure Storage35LDATELast Changed Onnvarchar80
144TMENUBK01Node Table for General Structure Storage35LDATELast Changed Onnvarchar80
TOPTest Organizer
145STWB_SETCentral Settings7LDATELast Changed Onnvarchar80
146TNODE02Test Organizer, Node Table35LDATELast Changed Onnvarchar80
147TNODE02_ATest case attributes: Management7LDATELast Changed Onnvarchar80
148TWB_CUST_PRIOCustomizing of Message Priorities5LDATELast Changed Onnvarchar80
149TWB_CUST_STATMessage Status Customizing6LDATELast Changed Onnvarchar80
150TWB_PRODUCTProduct and Product Release7LDATELast Changed Onnvarchar80
151TWB_RMPWork Breakdown Structure Elements (WBS Elements)8LDATELast Changed Onnvarchar80
152TWB_TPRProduct4LDATELast Changed Onnvarchar80
TOPTest Plan Management
153E2ET_TR_RT_MAPPE2W Testing Agent: Transport Object-Runtime Object Mapping10LDATESystem Datenvarchar80
154E2ET_TR_RT_MAPPKBPCA: Transport Object-Runtime Object Mapping Key15LDATESystem Datenvarchar80
TOPTime Tickets
155EVHRHR Order Confirmations (Times/Time Events)5LDATELogical Datenvarchar80
156LSHRHR Order Confirmations (Durations/Time Tickets)5LDATELogical Datenvarchar80
TOPTransport Organizer
157OBJHObject: Header17LDATEDatenvarchar80
158OBJSUBSubobjects14LDATEDatenvarchar80
TOPUser Administration
159BAPIUSW01User ID Table for Internet Appplication Components11LDATELast Logon Datenvarchar80
160SPERS_OBJPersonalization object repository7LDATEDatenvarchar80
TOPWeb Dynpro ABAP Runtime
161WDRCSFCHECKTable for Web Dynpro CSF Strings for a Later Analysis2LDATEFlight datenvarchar80
TOPWorkbench Tools Editors, Painters, Modelers
162EUINFOLIRepository Infosystem: Save background lists11LDATEDatenvarchar80
TOPWorkbench Utilities
163RLB_DB_TRReuse Library: Structure Repository: Nodes35LDATELast Changed Onnvarchar80