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

114 columns | Print definition?ERP 6.0  | PARTNO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000005000Change Log Table of DataStore Object 0PERS_BOD3PARTNOPartition value for PSA tableint100
2/BIC/B0000006000Change Log Table of DataStore Object 0PERS_VAR3PARTNOPartition value for PSA tableint100
3/BIC/B0000007000Change Log Table of DataStore Object 0PERS_WTE3PARTNOPartition value for PSA tableint100
4/BIC/B0000008000Transfer Structure Application 80RSPL_AGS3PARTNOPartition value for PSA tableint100
5/BIC/B0000009000Transfer Structure Application 80RSPL_AST3PARTNOPartition value for PSA tableint100
6/BIC/B0000010000Transfer Structure Application 80RSPL_CST3PARTNOPartition value for PSA tableint100
7/BIC/B0000011000Transfer Structure Application 80RSPL_HST3PARTNOPartition value for PSA tableint100
8/BIC/B0000012000Transfer Structure Application 80RSPL_LCK3PARTNOPartition value for PSA tableint100
9/BIC/B0000013000Transfer Structure Application 80RSPL_PLC3PARTNOPartition value for PSA tableint100
10/BIC/B0000014000Transfer Structure Application 80RSPL_PSS3PARTNOPartition value for PSA tableint100
11/BIC/B0000015000Transfer Structure Application 80RSPL_SEL3PARTNOPartition value for PSA tableint100
12/BIC/B0000016000Transfer Structure Application 80RSPL_SPS3PARTNOPartition value for PSA tableint100
13/BIC/B0000017000Change Log Table of DataStore Object 0TCTHP24O3PARTNOPartition value for PSA tableint100
14/BIC/B0000018000Error Stack DTP_7KU36MOUFNCES7S4B2PZC13FM 00013PARTNOPartition value for PSA tableint100
15/BIC/B0000103000PSA for /CPD/PFP_DS_AFVC T90CLNT090 DataSource for NWA3PARTNOPartition value for PSA tableint100
16/BIC/B0000103001PSA for /CPD/PFP_DS_AFVC T90CLNT090 DataSource for NWA3PARTNOPartition value for PSA tableint100
17/BIC/B0000104000PSA for /CPD/PFP_DS_AUFK T90CLNT090 DataSource for Ntwrk3PARTNOPartition value for PSA tableint100
18/BIC/B0000104001PSA for /CPD/PFP_DS_AUFK T90CLNT090 DataSource for Ntwrk3PARTNOPartition value for PSA tableint100
19/BIC/B0000105000PSA for /CPD/PFP_DS_PROJ T90CLNT090 DataSource for Proj.3PARTNOPartition value for PSA tableint100
20/BIC/B0000105001PSA for /CPD/PFP_DS_PROJ T90CLNT090 DataSource for Proj.3PARTNOPartition value for PSA tableint100
21/BIC/B0000106000PSA for /CPD/PFP_DS_PROJ_TEXT T90CLNT090 DataSource for Proj3PARTNOPartition value for PSA tableint100
22/BIC/B0000107000PSA for /CPD/PFP_DS_SALES T90CLNT090 DataSource for SO3PARTNOPartition value for PSA tableint100
23/BIC/B0000107001PSA for /CPD/PFP_DS_SALES T90CLNT090 DataSource for SO3PARTNOPartition value for PSA tableint100
24/BIC/B0000108000PSA for /CPD/PFP_DS_WBS T90CLNT090 DataSource for WBS3PARTNOPartition value for PSA tableint100
25/BIC/B0000108001PSA for /CPD/PFP_DS_WBS T90CLNT090 DataSource for WBS3PARTNOPartition value for PSA tableint100
26/BIC/B0000109000PSA for /CPD/PFP_DS_WBS_DATE T90CLNT090 DataSource for WBS3PARTNOPartition value for PSA tableint100
27/BIC/B0000109001PSA for /CPD/PFP_DS_WBS_DATE T90CLNT090 DataSource for WBS3PARTNOPartition value for PSA tableint100
28/BIC/B0000110000PSA for /CPD/PFP_DS_WBS_TEXT T90CLNT090 DataSource for WBS3PARTNOPartition value for PSA tableint100
29/BIC/B0000135000Change Log Table of DataStore Object 0PERS_VR13PARTNOPartition value for PSA tableint100
30/BIC/B0000136000PSA for 0DPR_PROJECT_TEXT T90CLNT090 Project Def. Texts3PARTNOPartition value for PSA tableint100
31/BIC/B0000137000PSA for 0DPR_PHASE_TEXT T90CLNT090 Phase Texts3PARTNOPartition value for PSA tableint100
32/BIC/B0000138000PSA for 0DPR_TASK_TEXT T90CLNT090 Task Texts3PARTNOPartition value for PSA tableint100
33/BIC/B0000139000PSA for 0DPR_PROJECT_DATE T90CLNT090 Proj. Def. Dates3PARTNOPartition value for PSA tableint100
34/BIC/B0000140000PSA for 0DPR_PHASE_DATE T90CLNT090 Phase Dates3PARTNOPartition value for PSA tableint100
35/BIC/B0000141000PSA for 0DPR_TASK_DATE T90CLNT090 Task Dates3PARTNOPartition value for PSA tableint100
36/BIC/B0000149000PSA for 0DPR_TASK_ATTR T90CLNT090 Task Attributes3PARTNOPartition value for PSA tableint100
37/BIC/B0000151000PSA for 0DPR_PROJECT_ATTR T90CLNT090 Proj. Def. Attr.3PARTNOPartition value for PSA tableint100
38/BIC/B0000152000PSA for 0DPR_PHASE_ATTR T90CLNT090 Phase Attributes3PARTNOPartition value for PSA tableint100
39/BIC/B0000157000PSA for 0CO_AREA_ATTR T90CLNT090 CO Area3PARTNOPartition value for PSA tableint100
40/BIC/B0000158000PSA for 0CO_AREA_TEXT T90CLNT090 CO Area3PARTNOPartition value for PSA tableint100
41/BIC/B0000159000PSA for 0COSTCENTER_ATTR T90CLNT090 Cost center3PARTNOPartition value for PSA tableint100
42/BIC/B0000160000PSA for 0COSTCENTER_TEXT T90CLNT090 Cost Center3PARTNOPartition value for PSA tableint100
43/BIC/B0000164000PSA for 0FI_AP_20 T90CLNT090 Vendor Balances3PARTNOPartition value for PSA tableint100
44/BIC/B0000165000PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta3PARTNOPartition value for PSA tableint100
45/BIC/B0000166000PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta3PARTNOPartition value for PSA tableint100
46/BIC/B0000167000PSA for 0FI_AR_20 T90CLNT090 Customer Balances3PARTNOPartition value for PSA tableint100
47/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items3PARTNOPartition value for PSA tableint100
48/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact3PARTNOPartition value for PSA tableint100
49/BIC/B0000170000PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta3PARTNOPartition value for PSA tableint100
50/BIC/B0000171000PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances3PARTNOPartition value for PSA tableint100
51/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items3PARTNOPartition value for PSA tableint100
52/BIC/B0000173000PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.3PARTNOPartition value for PSA tableint100
53/BIC/B0000174000PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs3PARTNOPartition value for PSA tableint100
54/BIC/B0000175000PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)3PARTNOPartition value for PSA tableint100
55/BIC/B0000176000PSA for 2LIS_11_VAHDR T90CLNT090 Sales Doc. Header3PARTNOPartition value for PSA tableint100
56/BIC/B0000177000PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item3PARTNOPartition value for PSA tableint100
57/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item3PARTNOPartition value for PSA tableint100
58/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule3PARTNOPartition value for PSA tableint100
59/BIC/B0000180000PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.3PARTNOPartition value for PSA tableint100
60/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.3PARTNOPartition value for PSA tableint100
61/BIC/B0000182000PSA for 2LIS_12_VCHDR T90CLNT090 Delivery Header Data3PARTNOPartition value for PSA tableint100
62/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item3PARTNOPartition value for PSA tableint100
63/BIC/B0000184000PSA for 2LIS_13_VDHDR T90CLNT090 Bill.Doc.Header Data3PARTNOPartition value for PSA tableint100
64/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item3PARTNOPartition value for PSA tableint100
65/BIC/B0000186000PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.3PARTNOPartition value for PSA tableint100
66/BIC/B0000187000PSA for 2LIS_02_ITM T90CLNT090 Purch. Data (Item)3PARTNOPartition value for PSA tableint100
67/BIC/B0000188000PSA for 2LIS_02_HDR T90CLNT090 Purch.Data (Header)3PARTNOPartition value for PSA tableint100
68/BIC/B0000189000PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line3PARTNOPartition value for PSA tableint100
69/BIC/B0000190000PSA for 0MM_PUR_PURCH_DATA T90CLNT090 Purchasing Data3PARTNOPartition value for PSA tableint100
70/BIC/B0000191000PSA for 0MM_PUR_PURCH_GROUPS T90CLNT090 Purchasing Groups3PARTNOPartition value for PSA tableint100
71/BIC/B0000192000PSA for 0MM_PUR_SRV_LEVEL T90CLNT090 PO Service Level3PARTNOPartition value for PSA tableint100
72/BIC/B0000193000PSA for EIM_DS_SD DI_SOURCE Segment 00013PARTNOPartition value for PSA tableint100
73/BIC/B0000193001PSA for EIM_DS_SD DI_SOURCE Segment 00013PARTNOPartition value for PSA tableint100
74/BIC/B0000199000Change Log Table of DataStore Object DS_AFPO3PARTNOPartition value for PSA tableint100
75/BIC/B0000200000Change Log Table of DataStore Object DS_LIPS3PARTNOPartition value for PSA tableint100
76/BIC/B0000201000Change Log Table of DataStore Object DS_VBAK3PARTNOPartition value for PSA tableint100
77/BIC/B0000202000Change Log Table of DataStore Object DS_VBAP3PARTNOPartition value for PSA tableint100
78/BIC/B0000203000Change Log Table of DataStore Object DS_VBEP3PARTNOPartition value for PSA tableint100
79/BIC/B0000204000Change Log Table of DataStore Object DS_SD3PARTNOPartition value for PSA tableint100
80/BIC/B0000218000PSA for 0CO_OM_OPA_1 T90CLNT090 Orders: Costs3PARTNOPartition value for PSA tableint100
81/BIC/B0000219000PSA for 0CO_OM_OPA_3 T90CLNT090 Orders: Total plan3PARTNOPartition value for PSA tableint100
82/BIC/B0000220000PSA for 0CO_OM_OPA_4 T90CLNT090 Orders: Statist. KFs3PARTNOPartition value for PSA tableint100
83/BIC/B0000221000PSA for 0CO_OM_OPA_2 T90CLNT090 Orders: Budget3PARTNOPartition value for PSA tableint100
84/BIC/B0000222000PSA for 0CO_OM_OPA_5 T90CLNT090 Orders: Selections3PARTNOPartition value for PSA tableint100
85/BIC/B0000223000PSA for 0CO_OM_OPA_6 T90CLNT090 Orders: ActCostDelta3PARTNOPartition value for PSA tableint100
86/BIC/B0000228000PSA for DS_MM DI_SOURCE Segment 00013PARTNOPartition value for PSA tableint100
87/BIC/B0000231000PSA for DS_AFPO DI_SOURCE Segment 00013PARTNOPartition value for PSA tableint100
88/BIC/B0000232000PSA for DS_LIPS DI_SOURCE Segment 00013PARTNOPartition value for PSA tableint100
89/BIC/B0000233000PSA for DS_VBAP DI_SOURCE Segment 00013PARTNOPartition value for PSA tableint100
90/BIC/B0000235000Change Log Table of DataStore Object DSO_MM3PARTNOPartition value for PSA tableint100
91/BIC/B0000240000Change Log Table of DataStore Object DSO_LIPS3PARTNOPartition value for PSA tableint100
92/BIC/B0000244000Change Log Table of DataStore Object DSO_AFPO3PARTNOPartition value for PSA tableint100
93/BIC/B0000248000Change Log Table of DataStore Object DSO_VBAP3PARTNOPartition value for PSA tableint100
94/BIC/B0000271000PSA for DS_VBEP DI_SOURCE Segment 00013PARTNOPartition value for PSA tableint100
95/BIC/B0000272000Change Log Table of DataStore Object DSO_VBEP3PARTNOPartition value for PSA tableint100
96/BIC/B0000276000Transfer Structure Application /CPD/8PFP_C013PARTNOPartition value for PSA tableint100
97/BIC/B0000277000Change Log Table of DataStore Object DSO_APD3PARTNOPartition value for PSA tableint100
98/BIC/B0000280000PSA for 0HR_PA_0 T90CLNT090 Employee3PARTNOPartition value for PSA tableint100
99/BIC/B0000281000PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee3PARTNOPartition value for PSA tableint100
100/BIC/B0000282000PSA for 0EMPLOYEE_TEXT T90CLNT090 Employee3PARTNOPartition value for PSA tableint100
101/BIC/B0000283000PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee3PARTNOPartition value for PSA tableint100
102/BIC/B0000284000PSA for 0EMPLOYEE_2_TEXT T90CLNT090 Employee (Texts)3PARTNOPartition value for PSA tableint100
103/BIC/B0000285000PSA for 0PERSON_ATTR T90CLNT090 Person3PARTNOPartition value for PSA tableint100
104/BIC/B0000286000PSA for 0PERSON_TEXT T90CLNT090 Person3PARTNOPartition value for PSA tableint100
105RSDAREFTABDB2_ORDB2-z/OS HiPe NLS: Template for reqstate table3PARTNOint100
106RSDB2A_CONTROLDB2 Accelerator: conrol center TOC10PARTNONumber of partitions of the tablespace or indexspacesmallint50
107RSDB2A_STATUSDB2 Accelerator: current table data status in accelerator2PARTNONumber of partitions of the tablespace or indexspacesmallint50
108RSDB2A_STA_STDDB2 Accelerator: current table data status in accelerator2PARTNONumber of partitions of the tablespace or indexspacesmallint50
109RSDB2NLS_CHKRSLTDB2-z/OS HiPe NLS: Check results4PARTNOint100
110RSDB2NLS_CONTROLDB2-z/OS HiPe NLS: Table of Content5PARTNOsmallint50
TOPData Staging
111RSTSODSOperational Data Store for the transfer structure13PARTNOPartition number for PSA partitioningnvarchar40
112RSTSODSPARTPartitioning Information2PARTNOPartition number for PSA partitioningnvarchar40
TOPReturnable Packaging Logistics
113RLACSTHDReturnable Packaging Account Statement5PARTNOSequence number for RP account postings per acct and deltypeint100
114RLPODLMTDelimitation Record for Returnable Packaging Acct Postings4PARTNOSequence number for RP account postings per acct and deltypeint100