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

49 columns | Print definition?ERP 6.0  | TCTOBJVERS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BI0/APERS_BOD00ODS Object 0PERS_BOD : Active Records2TCTOBJVERSObject Versionnvarchar10
2/BI0/APERS_BOD40DataStore Object 0PERS_BOD : Update5TCTOBJVERSObject Versionnvarchar10
3/BI0/APERS_VAR00ODS Object 0PERS_VAR : Active Records7TCTOBJVERSObject Versionnvarchar10
4/BI0/APERS_VAR40DataStore Object 0PERS_VAR : Update10TCTOBJVERSObject Versionnvarchar10
5/BI0/APERS_VR100ODS Object 0PERS_VR1 : Active Records7TCTOBJVERSObject Versionnvarchar10
6/BI0/APERS_VR140DataStore Object 0PERS_VR1 : Update10TCTOBJVERSObject Versionnvarchar10
7/BI0/PTCTAPPLMaster Data (Time-Ind.): Characteristic Appl. Component2TCTOBJVERSObject Versionnvarchar10
8/BI0/PTCTBWOBJCTMaster Data (Time-Ind.): Characteristic BI Object3TCTOBJVERSObject Versionnvarchar10
9/BI0/PTCTIFAREAMaster Data (Time-Ind.): Characteristic InfoArea2TCTOBJVERSObject Versionnvarchar10
10/BI0/PTCTIOBJNMMaster Data (Time-Ind.): Characteristic InfoObject2TCTOBJVERSObject Versionnvarchar10
11/BI0/PTCTIPAKIDMaster Data (Time-Ind.): Characteristic InfoPackage ID10TCTOBJVERSObject Versionnvarchar10
12/BI0/PTCTISOURCMaster Data (Time-Ind.): Characteristic InfoSource10TCTOBJVERSObject Versionnvarchar10
13/BI0/PTCTOBJVERSMaster Data (Time-Ind.): Characteristic Object Version1TCTOBJVERSObject Versionnvarchar10
14/BI0/PTCTPRCHAINMaster Data (Time-Ind.): Characteristic Process Chain ID1TCTOBJVERSObject Versionnvarchar10
15/BI0/PTCTPRCSCHNMaster Data (Time-Ind.): Characteristic Process Chain ID2TCTOBJVERSObject Versionnvarchar10
16/BI0/PTCTPRCSVARMaster Data (Time-Ind.): Characteristic Process Variant2TCTOBJVERSObject Versionnvarchar10
17/BI0/PTCTQUERIDMaster Data (Time-Ind.): Characteristic Query (UID)1TCTOBJVERSObject Versionnvarchar10
18/BI0/PTCTREQUIDMaster Data (Time-Ind.): Characteristic Data Request (GUID)9TCTOBJVERSObject Versionnvarchar10
19/BI0/PTCTUSERNMMaster Data (Time-Ind.): Characteristic User8TCTOBJVERSObject Versionnvarchar10
20/BI0/STCTAPPLMaster Data IDs: InfoObject Appl. Component2TCTOBJVERSObject Versionnvarchar10
21/BI0/STCTBWOBJCTMaster Data IDs: InfoObject BI Object3TCTOBJVERSObject Versionnvarchar10
22/BI0/STCTIFAREAMaster Data IDs: InfoObject InfoArea2TCTOBJVERSObject Versionnvarchar10
23/BI0/STCTIOBJNMMaster Data IDs: InfoObject InfoObject2TCTOBJVERSObject Versionnvarchar10
24/BI0/STCTOBJNMMaster Data IDs: InfoObject Object Metadata2TCTOBJVERSObject Versionnvarchar10
25/BI0/STCTOBJVERSMaster Data IDs: InfoObject Object Version1TCTOBJVERSObject Versionnvarchar10
26/BI0/STCTPRCHAINMaster Data IDs: InfoObject Process Chain ID1TCTOBJVERSObject Versionnvarchar10
27/BI0/STCTPRCSCHNMaster Data IDs: InfoObject Process Chain ID2TCTOBJVERSObject Versionnvarchar10
28/BI0/STCTPRCSVARMaster Data IDs: InfoObject Process Variant2TCTOBJVERSObject Versionnvarchar10
29/BI0/STCTQUERIDMaster Data IDs: InfoObject Query (UID)1TCTOBJVERSObject Versionnvarchar10
30/BI0/TTCTAPPLTexts: Char. Appl. Component2TCTOBJVERSObject Versionnvarchar10
31/BI0/TTCTBWOBJCTTexts: Char. BI Object3TCTOBJVERSObject Versionnvarchar10
32/BI0/TTCTIFAREATexts: Char. InfoArea2TCTOBJVERSObject Versionnvarchar10
33/BI0/TTCTIOBJNMTexts: Char. InfoObject2TCTOBJVERSObject Versionnvarchar10
34/BI0/TTCTOBJVERSTexts: Char. Object Version1TCTOBJVERSObject Versionnvarchar10
35/BI0/TTCTPRCHAINTexts: Char. Process Chain ID1TCTOBJVERSObject Versionnvarchar10
36/BI0/TTCTPRCSCHNTexts: Char. Process Chain ID2TCTOBJVERSObject Versionnvarchar10
37/BI0/TTCTPRCSVARTexts: Char. Process Variant2TCTOBJVERSObject Versionnvarchar10
38/BI0/TTCTQUERIDTexts: Char. Query (UID)1TCTOBJVERSObject Versionnvarchar10
39/BI0/XTCTAPPLAttribute SID Table: InfoObject Appl. Component4TCTOBJVERSObject Versionnvarchar10
40/BI0/XTCTBWOBJCTAttribute SID Table: InfoObject BI Object5TCTOBJVERSObject Versionnvarchar10
41/BI0/XTCTIFAREAAttribute SID Table: InfoObject InfoArea4TCTOBJVERSObject Versionnvarchar10
42/BI0/XTCTIOBJNMAttribute SID Table: InfoObject InfoObject4TCTOBJVERSObject Versionnvarchar10
43/BI0/XTCTPRCHAINAttribute SID Table: InfoObject Process Chain ID3TCTOBJVERSObject Versionnvarchar10
44/BI0/XTCTPRCSCHNAttribute SID Table: InfoObject Process Chain ID4TCTOBJVERSObject Versionnvarchar10
45/BI0/XTCTPRCSVARAttribute SID Table: InfoObject Process Variant4TCTOBJVERSObject Versionnvarchar10
46/BI0/XTCTQUERIDAttribute SID Table: InfoObject Query (UID)3TCTOBJVERSObject Versionnvarchar10
47/BIC/B0000005000Change Log Table of DataStore Object 0PERS_BOD6TCTOBJVERSObject Versionnvarchar10
48/BIC/B0000006000Change Log Table of DataStore Object 0PERS_VAR11TCTOBJVERSObject Versionnvarchar10
49/BIC/B0000135000Change Log Table of DataStore Object 0PERS_VR111TCTOBJVERSObject Versionnvarchar10