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

76 columns | Print definition?ERP 6.0  | TCTSYSID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BI0/APERS_BOD00ODS Object 0PERS_BOD : Active Records3TCTSYSIDBW Systemnvarchar100
2/BI0/APERS_BOD40DataStore Object 0PERS_BOD : Update6TCTSYSIDBW Systemnvarchar100
3/BI0/APERS_VAR00ODS Object 0PERS_VAR : Active Records6TCTSYSIDBW Systemnvarchar100
4/BI0/APERS_VAR40DataStore Object 0PERS_VAR : Update9TCTSYSIDBW Systemnvarchar100
5/BI0/APERS_VR100ODS Object 0PERS_VR1 : Active Records6TCTSYSIDBW Systemnvarchar100
6/BI0/APERS_VR140DataStore Object 0PERS_VR1 : Update9TCTSYSIDBW Systemnvarchar100
7/BI0/APERS_WTE00ODS Object 0PERS_WTE : Active Records2TCTSYSIDBW Systemnvarchar100
8/BI0/APERS_WTE40DataStore Object 0PERS_WTE : Update5TCTSYSIDBW Systemnvarchar100
9/BI0/ATCTHP24O00ODS Object 0TCTHP24O : Active Records1TCTSYSIDBW Systemnvarchar100
10/BI0/ATCTHP24O40DataStore Object 0TCTHP24O : Update4TCTSYSIDBW Systemnvarchar100
11/BI0/PTCAIFAREAMaster Data (Time-Ind.): Characteristic InfoArea Analys. Aut7TCTSYSIDBW Systemnvarchar100
12/BI0/PTCTAPPLMaster Data (Time-Ind.): Characteristic Appl. Component1TCTSYSIDBW Systemnvarchar100
13/BI0/PTCTBWOBJCTMaster Data (Time-Ind.): Characteristic BI Object1TCTSYSIDBW Systemnvarchar100
14/BI0/PTCTDAEMONMaster Data (Time-Ind.): Characteristic Daemon ID1TCTSYSIDBW Systemnvarchar100
15/BI0/PTCTDSOURCMaster Data (Time-Ind.): Characteristic DataSource1TCTSYSIDBW Systemnvarchar100
16/BI0/PTCTIFAREAMaster Data (Time-Ind.): Characteristic InfoArea1TCTSYSIDBW Systemnvarchar100
17/BI0/PTCTIGRIDMaster Data (Time-Ind.): Characteristic InfoPackage Group ID1TCTSYSIDBW Systemnvarchar100
18/BI0/PTCTIOBJNMMaster Data (Time-Ind.): Characteristic InfoObject1TCTSYSIDBW Systemnvarchar100
19/BI0/PTCTIPAKIDMaster Data (Time-Ind.): Characteristic InfoPackage ID1TCTSYSIDBW Systemnvarchar100
20/BI0/PTCTISOURCMaster Data (Time-Ind.): Characteristic InfoSource1TCTSYSIDBW Systemnvarchar100
21/BI0/PTCTPRCHAINMaster Data (Time-Ind.): Characteristic Process Chain ID5TCTSYSIDBW Systemnvarchar100
22/BI0/PTCTPRCSCHNMaster Data (Time-Ind.): Characteristic Process Chain ID1TCTSYSIDBW Systemnvarchar100
23/BI0/PTCTPRCSVARMaster Data (Time-Ind.): Characteristic Process Variant1TCTSYSIDBW Systemnvarchar100
24/BI0/PTCTQUERIDMaster Data (Time-Ind.): Characteristic Query (UID)10TCTSYSIDBW Systemnvarchar100
25/BI0/PTCTREQIDERMaster Data (Time-Ind.): Characteristic Error request ID1TCTSYSIDBW Systemnvarchar100
26/BI0/PTCTREQUIDMaster Data (Time-Ind.): Characteristic Data Request (GUID)12TCTSYSIDBW Systemnvarchar100
27/BI0/PTCTSOURSYSMaster Data (Time-Ind.): Characteristic Source System1TCTSYSIDBW Systemnvarchar100
28/BI0/PTCTSYSIDMaster Data (Time-Ind.): Characteristic BW System1TCTSYSIDBW Systemnvarchar100
29/BI0/PTCTUSERNMMaster Data (Time-Ind.): Characteristic User1TCTSYSIDBW Systemnvarchar100
30/BI0/PTCTUSRNMMaster Data (Time-Ind.): Characteristic User ID1TCTSYSIDBW Systemnvarchar100
31/BI0/STCTAPPLMaster Data IDs: InfoObject Appl. Component1TCTSYSIDBW Systemnvarchar100
32/BI0/STCTBWOBJCTMaster Data IDs: InfoObject BI Object1TCTSYSIDBW Systemnvarchar100
33/BI0/STCTDAEMONMaster Data IDs: InfoObject Daemon ID1TCTSYSIDBW Systemnvarchar100
34/BI0/STCTDSOURCMaster Data IDs: InfoObject DataSource1TCTSYSIDBW Systemnvarchar100
35/BI0/STCTIFAREAMaster Data IDs: InfoObject InfoArea1TCTSYSIDBW Systemnvarchar100
36/BI0/STCTIGRIDMaster Data IDs: InfoObject InfoPackage Group ID1TCTSYSIDBW Systemnvarchar100
37/BI0/STCTIOBJNMMaster Data IDs: InfoObject InfoObject1TCTSYSIDBW Systemnvarchar100
38/BI0/STCTIPAKIDMaster Data IDs: InfoObject InfoPackage ID1TCTSYSIDBW Systemnvarchar100
39/BI0/STCTISOURCMaster Data IDs: InfoObject InfoSource1TCTSYSIDBW Systemnvarchar100
40/BI0/STCTPRCSCHNMaster Data IDs: InfoObject Process Chain ID1TCTSYSIDBW Systemnvarchar100
41/BI0/STCTPRCSVARMaster Data IDs: InfoObject Process Variant1TCTSYSIDBW Systemnvarchar100
42/BI0/STCTREQIDERMaster Data IDs: InfoObject Error request ID1TCTSYSIDBW Systemnvarchar100
43/BI0/STCTREQSIDMaster Data IDs: InfoObject Data Request (SID)1TCTSYSIDBW Systemnvarchar100
44/BI0/STCTSOURSYSMaster Data IDs: InfoObject Source System1TCTSYSIDBW Systemnvarchar100
45/BI0/STCTSYSIDMaster Data IDs: InfoObject BW System1TCTSYSIDBW Systemnvarchar100
46/BI0/STCTUSERNMMaster Data IDs: InfoObject User1TCTSYSIDBW Systemnvarchar100
47/BI0/STCTUSRNMMaster Data IDs: InfoObject User ID1TCTSYSIDBW Systemnvarchar100
48/BI0/TTCTAPPLTexts: Char. Appl. Component1TCTSYSIDBW Systemnvarchar100
49/BI0/TTCTBWOBJCTTexts: Char. BI Object1TCTSYSIDBW Systemnvarchar100
50/BI0/TTCTDSOURCTexts: Char. DataSource1TCTSYSIDBW Systemnvarchar100
51/BI0/TTCTIFAREATexts: Char. InfoArea1TCTSYSIDBW Systemnvarchar100
52/BI0/TTCTIGRIDTexts: Char. InfoPackage Group ID1TCTSYSIDBW Systemnvarchar100
53/BI0/TTCTIOBJNMTexts: Char. InfoObject1TCTSYSIDBW Systemnvarchar100
54/BI0/TTCTIPAKIDTexts: Char. InfoPackage ID1TCTSYSIDBW Systemnvarchar100
55/BI0/TTCTISOURCTexts: Char. InfoSource1TCTSYSIDBW Systemnvarchar100
56/BI0/TTCTPRCSCHNTexts: Char. Process Chain ID1TCTSYSIDBW Systemnvarchar100
57/BI0/TTCTPRCSVARTexts: Char. Process Variant1TCTSYSIDBW Systemnvarchar100
58/BI0/TTCTSOURSYSTexts: Char. Source System1TCTSYSIDBW Systemnvarchar100
59/BI0/TTCTSYSIDTexts: Char. BW System1TCTSYSIDBW Systemnvarchar100
60/BI0/TTCTUSERNMTexts: Char. User1TCTSYSIDBW Systemnvarchar100
61/BI0/TTCTUSRNMTexts: Char. User ID1TCTSYSIDBW Systemnvarchar100
62/BI0/XTCTAPPLAttribute SID Table: InfoObject Appl. Component3TCTSYSIDBW Systemnvarchar100
63/BI0/XTCTBWOBJCTAttribute SID Table: InfoObject BI Object3TCTSYSIDBW Systemnvarchar100
64/BI0/XTCTIFAREAAttribute SID Table: InfoObject InfoArea3TCTSYSIDBW Systemnvarchar100
65/BI0/XTCTIOBJNMAttribute SID Table: InfoObject InfoObject3TCTSYSIDBW Systemnvarchar100
66/BI0/XTCTIPAKIDAttribute SID Table: InfoObject InfoPackage ID3TCTSYSIDBW Systemnvarchar100
67/BI0/XTCTISOURCAttribute SID Table: InfoObject InfoSource3TCTSYSIDBW Systemnvarchar100
68/BI0/XTCTPRCSCHNAttribute SID Table: InfoObject Process Chain ID3TCTSYSIDBW Systemnvarchar100
69/BI0/XTCTPRCSVARAttribute SID Table: InfoObject Process Variant3TCTSYSIDBW Systemnvarchar100
70/BI0/XTCTSOURSYSAttribute SID Table: InfoObject Source System3TCTSYSIDBW Systemnvarchar100
71/BIC/B0000005000Change Log Table of DataStore Object 0PERS_BOD7TCTSYSIDBW Systemnvarchar100
72/BIC/B0000006000Change Log Table of DataStore Object 0PERS_VAR10TCTSYSIDBW Systemnvarchar100
73/BIC/B0000007000Change Log Table of DataStore Object 0PERS_WTE6TCTSYSIDBW Systemnvarchar100
74/BIC/B0000017000Change Log Table of DataStore Object 0TCTHP24O5TCTSYSIDBW Systemnvarchar100
75/BIC/B0000018000Error Stack DTP_7KU36MOUFNCES7S4B2PZC13FM 00015TCTSYSIDnvarchar100
76/BIC/B0000135000Change Log Table of DataStore Object 0PERS_VR110TCTSYSIDBW Systemnvarchar100