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

86 columns | Print definition?ERP 6.0  | RECORDMODE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BI0/APERS_BOD00ODS Object 0PERS_BOD : Active Records7RECORDMODEBW Delta Process: Record Modenvarchar10
2/BI0/APERS_BOD40DataStore Object 0PERS_BOD : Update10RECORDMODEBW Delta Process: Record Modenvarchar10
3/BI0/APERS_VAR00ODS Object 0PERS_VAR : Active Records13RECORDMODEBW Delta Process: Record Modenvarchar10
4/BI0/APERS_VAR40DataStore Object 0PERS_VAR : Update16RECORDMODEBW Delta Process: Record Modenvarchar10
5/BI0/APERS_VR100ODS Object 0PERS_VR1 : Active Records11RECORDMODEBW Delta Process: Record Modenvarchar10
6/BI0/APERS_VR140DataStore Object 0PERS_VR1 : Update14RECORDMODEBW Delta Process: Record Modenvarchar10
7/BI0/APERS_WTE00ODS Object 0PERS_WTE : Active Records5RECORDMODEBW Delta Process: Record Modenvarchar10
8/BI0/APERS_WTE40DataStore Object 0PERS_WTE : Update8RECORDMODEBW Delta Process: Record Modenvarchar10
9/BI0/ARSPL_AGS00ODS Object 0RSPL_AGS : Active Records7RECORDMODEBW Delta Process: Record Modenvarchar10
10/BI0/ARSPL_AST00ODS Object 0RSPL_AST : Active Records6RECORDMODEBW Delta Process: Record Modenvarchar10
11/BI0/ARSPL_CST00ODS Object 0RSPL_CST : Active Records6RECORDMODEBW Delta Process: Record Modenvarchar10
12/BI0/ARSPL_HST00ODS Object 0RSPL_HST : Active Records7RECORDMODEBW Delta Process: Record Modenvarchar10
13/BI0/ARSPL_LCK00ODS Object 0RSPL_LCK : Active Records7RECORDMODEBW Delta Process: Record Modenvarchar10
14/BI0/ARSPL_PLC00ODS Object 0RSPL_PLC : Active Records5RECORDMODEBW Delta Process: Record Modenvarchar10
15/BI0/ARSPL_PSS00ODS Object 0RSPL_PSS : Active Records5RECORDMODEBW Delta Process: Record Modenvarchar10
16/BI0/ARSPL_SEL00ODS Object 0RSPL_SEL : Active Records10RECORDMODEBW Delta Process: Record Modenvarchar10
17/BI0/ARSPL_SPS00ODS Object 0RSPL_SPS : Active Records9RECORDMODEBW Delta Process: Record Modenvarchar10
18/BI0/ATCTHP24O00ODS Object 0TCTHP24O : Active Records18RECORDMODEBW Delta Process: Record Modenvarchar10
19/BI0/ATCTHP24O40DataStore Object 0TCTHP24O : Update21RECORDMODEBW Delta Process: Record Modenvarchar10
20/BI0/SRECORDMODEMaster Data IDs: InfoObject Update Mode1RECORDMODEBW Delta Process: Record Modenvarchar10
21/BIC/ADSO_AFPO00ODS Object DSO_AFPO : Active Records3RECORDMODEBW Delta Process: Record Modenvarchar10
22/BIC/ADSO_AFPO40DataStore Object DSO_AFPO : Update6RECORDMODEBW Delta Process: Record Modenvarchar10
23/BIC/ADSO_APD00ODS Object DSO_APD : Active Records15RECORDMODEBW Delta Process: Record Modenvarchar10
24/BIC/ADSO_APD40DataStore Object DSO_APD : Update18RECORDMODEBW Delta Process: Record Modenvarchar10
25/BIC/ADSO_LIPS00ODS Object DSO_LIPS : Active Records10RECORDMODEBW Delta Process: Record Modenvarchar10
26/BIC/ADSO_LIPS40DataStore Object DSO_LIPS : Update13RECORDMODEBW Delta Process: Record Modenvarchar10
27/BIC/ADSO_MM00ODS Object DSO_MM : Active Records14RECORDMODEBW Delta Process: Record Modenvarchar10
28/BIC/ADSO_MM40DataStore Object DSO_MM : Update17RECORDMODEBW Delta Process: Record Modenvarchar10
29/BIC/ADSO_VBAP00ODS Object DSO_VBAP : Active Records5RECORDMODEBW Delta Process: Record Modenvarchar10
30/BIC/ADSO_VBAP40DataStore Object DSO_VBAP : Update8RECORDMODEBW Delta Process: Record Modenvarchar10
31/BIC/ADSO_VBEP00ODS Object DSO_VBEP : Active Records5RECORDMODEBW Delta Process: Record Modenvarchar10
32/BIC/ADSO_VBEP40DataStore Object DSO_VBEP : Update8RECORDMODEBW Delta Process: Record Modenvarchar10
33/BIC/ADS_AFPO00ODS Object DS_AFPO : Active Records2RECORDMODEBW Delta Process: Record Modenvarchar10
34/BIC/ADS_AFPO40DataStore Object DS_AFPO : Update5RECORDMODEBW Delta Process: Record Modenvarchar10
35/BIC/ADS_LIPS00ODS Object DS_LIPS : Active Records9RECORDMODEBW Delta Process: Record Modenvarchar10
36/BIC/ADS_LIPS40DataStore Object DS_LIPS : Update12RECORDMODEBW Delta Process: Record Modenvarchar10
37/BIC/ADS_SD00ODS Object DS_SD : Active Records10RECORDMODEBW Delta Process: Record Modenvarchar10
38/BIC/ADS_SD40DataStore Object DS_SD : Update13RECORDMODEBW Delta Process: Record Modenvarchar10
39/BIC/ADS_VBAK00ODS Object DS_VBAK : Active Records2RECORDMODEBW Delta Process: Record Modenvarchar10
40/BIC/ADS_VBAK40DataStore Object DS_VBAK : Update5RECORDMODEBW Delta Process: Record Modenvarchar10
41/BIC/ADS_VBAP00ODS Object DS_VBAP : Active Records2RECORDMODEBW Delta Process: Record Modenvarchar10
42/BIC/ADS_VBAP40DataStore Object DS_VBAP : Update5RECORDMODEBW Delta Process: Record Modenvarchar10
43/BIC/ADS_VBEP00ODS Object DS_VBEP : Active Records3RECORDMODEBW Delta Process: Record Modenvarchar10
44/BIC/ADS_VBEP40DataStore Object DS_VBEP : Update6RECORDMODEBW Delta Process: Record Modenvarchar10
45/BIC/B0000005000Change Log Table of DataStore Object 0PERS_BOD11RECORDMODEBW Delta Process: Record Modenvarchar10
46/BIC/B0000006000Change Log Table of DataStore Object 0PERS_VAR17RECORDMODEBW Delta Process: Record Modenvarchar10
47/BIC/B0000007000Change Log Table of DataStore Object 0PERS_WTE9RECORDMODEBW Delta Process: Record Modenvarchar10
48/BIC/B0000008000Transfer Structure Application 80RSPL_AGS11RECORDMODEBW Delta Process: Record Modenvarchar10
49/BIC/B0000009000Transfer Structure Application 80RSPL_AST10RECORDMODEBW Delta Process: Record Modenvarchar10
50/BIC/B0000010000Transfer Structure Application 80RSPL_CST10RECORDMODEBW Delta Process: Record Modenvarchar10
51/BIC/B0000011000Transfer Structure Application 80RSPL_HST11RECORDMODEBW Delta Process: Record Modenvarchar10
52/BIC/B0000012000Transfer Structure Application 80RSPL_LCK11RECORDMODEBW Delta Process: Record Modenvarchar10
53/BIC/B0000013000Transfer Structure Application 80RSPL_PLC9RECORDMODEBW Delta Process: Record Modenvarchar10
54/BIC/B0000014000Transfer Structure Application 80RSPL_PSS9RECORDMODEBW Delta Process: Record Modenvarchar10
55/BIC/B0000015000Transfer Structure Application 80RSPL_SEL14RECORDMODEBW Delta Process: Record Modenvarchar10
56/BIC/B0000016000Transfer Structure Application 80RSPL_SPS13RECORDMODEBW Delta Process: Record Modenvarchar10
57/BIC/B0000017000Change Log Table of DataStore Object 0TCTHP24O24RECORDMODEBW Delta Process: Record Modenvarchar10
58/BIC/B0000135000Change Log Table of DataStore Object 0PERS_VR115RECORDMODEBW Delta Process: Record Modenvarchar10
59/BIC/B0000199000Change Log Table of DataStore Object DS_AFPO6RECORDMODEBW Delta Process: Record Modenvarchar10
60/BIC/B0000200000Change Log Table of DataStore Object DS_LIPS13RECORDMODEBW Delta Process: Record Modenvarchar10
61/BIC/B0000201000Change Log Table of DataStore Object DS_VBAK6RECORDMODEBW Delta Process: Record Modenvarchar10
62/BIC/B0000202000Change Log Table of DataStore Object DS_VBAP6RECORDMODEBW Delta Process: Record Modenvarchar10
63/BIC/B0000203000Change Log Table of DataStore Object DS_VBEP7RECORDMODEBW Delta Process: Record Modenvarchar10
64/BIC/B0000204000Change Log Table of DataStore Object DS_SD14RECORDMODEBW Delta Process: Record Modenvarchar10
65/BIC/B0000235000Change Log Table of DataStore Object DSO_MM18RECORDMODEBW Delta Process: Record Modenvarchar10
66/BIC/B0000240000Change Log Table of DataStore Object DSO_LIPS14RECORDMODEBW Delta Process: Record Modenvarchar10
67/BIC/B0000244000Change Log Table of DataStore Object DSO_AFPO7RECORDMODEBW Delta Process: Record Modenvarchar10
68/BIC/B0000248000Change Log Table of DataStore Object DSO_VBAP9RECORDMODEBW Delta Process: Record Modenvarchar10
69/BIC/B0000272000Change Log Table of DataStore Object DSO_VBEP9RECORDMODEBW Delta Process: Record Modenvarchar10
70/BIC/B0000277000Change Log Table of DataStore Object DSO_APD19RECORDMODEBW Delta Process: Record Modenvarchar10
TOPContract Accounts Receivable and Payable
71DFKKIPBW_HEADInstallment Plan Header Data for Business Warehouse3RECORDMODEBW Delta Procedure: Update Modenvarchar10
72DFKKIPBW_ITEMInstallment Plan Items for Business Warehouse6RECORDMODEBW Delta Procedure: Update Modenvarchar10
73DFKKIPBW_ORIGInstallment Plan Original Items for Business Warehouse6RECORDMODEBW Delta Procedure: Update Modenvarchar10
74DFKKWLIABWTrigger for Delta Extraction for Notification Work Items4RECORDMODEBW Delta Process: Record Modenvarchar10
75DFKKWLIBWTrigger for Delta Extraction for Work Items3RECORDMODEBW Delta Process: Record Modenvarchar10
TOPIntercompany Data Exchange
76TINV_BW_TRIG_THITrigger for Delta Extraction of Transfer Recs f. Third Party7RECORDMODEBW Delta Process: Record Modenvarchar10
TOPOLAP Technology
77RSECHIE_CLAuthorization Hierarchies Changes Change Log7RECORDMODEBW Delta Process: Record Modenvarchar10
78RSECTXT_CLChange Documents for Document Texts10RECORDMODEBW Delta Process: Record Modenvarchar10
79RSECUSERAUTH_CLBI AS Authorizations: Assignment of User Auth (Change Log)6RECORDMODEBW Delta Process: Record Modenvarchar10
80RSECVAL_CLAuthorization Value Change (Change Log)7RECORDMODEBW Delta Process: Record Modenvarchar10
TOPOperational Data Provisioning ODP
81RODPS_TEST_ADDADD = ADDD = CUBE Delta6RECORDMODEBW Delta Process: Record Modenvarchar10
82RODPS_TEST_AIEAIE = AIM Delta6RECORDMODEBW Delta Process: Record Modenvarchar10
83RODPS_TEST_AIEDAIED = AIMD Delta6RECORDMODEBW Delta Process: Record Modenvarchar10
84RODPS_TEST_NEWENEWE = NEWD Delta6RECORDMODEBW Delta Process: Record Modenvarchar10
85RODPS_TEST_ODSODS = ABR = ABR1 Delta6RECORDMODEBW Delta Process: Record Modenvarchar10
86RODPS_TEST_SNAPSSnapshot of All Test Data Sources7RECORDMODEBW Delta Process: Record Modenvarchar10