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

180 columns | Print definition?ERP 6.0  | RECORD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BI0/APERS_BOD40DataStore Object 0PERS_BOD : Update3RECORDData record numberint100
2/BI0/APERS_VAR40DataStore Object 0PERS_VAR : Update3RECORDData record numberint100
3/BI0/APERS_VR140DataStore Object 0PERS_VR1 : Update3RECORDData record numberint100
4/BI0/APERS_WTE40DataStore Object 0PERS_WTE : Update3RECORDData record numberint100
5/BI0/ATCTHP24O40DataStore Object 0TCTHP24O : Update3RECORDData record numberint100
6/BI0/SRECORDMaster Data IDs: InfoObject Data Record1RECORDData Record Numberint100
7/BIC/ADSO_AFPO40DataStore Object DSO_AFPO : Update3RECORDData record numberint100
8/BIC/ADSO_APD40DataStore Object DSO_APD : Update3RECORDData record numberint100
9/BIC/ADSO_LIPS40DataStore Object DSO_LIPS : Update3RECORDData record numberint100
10/BIC/ADSO_MM40DataStore Object DSO_MM : Update3RECORDData record numberint100
11/BIC/ADSO_VBAP40DataStore Object DSO_VBAP : Update3RECORDData record numberint100
12/BIC/ADSO_VBEP40DataStore Object DSO_VBEP : Update3RECORDData record numberint100
13/BIC/ADS_AFPO40DataStore Object DS_AFPO : Update3RECORDData record numberint100
14/BIC/ADS_LIPS40DataStore Object DS_LIPS : Update3RECORDData record numberint100
15/BIC/ADS_SD40DataStore Object DS_SD : Update3RECORDData record numberint100
16/BIC/ADS_VBAK40DataStore Object DS_VBAK : Update3RECORDData record numberint100
17/BIC/ADS_VBAP40DataStore Object DS_VBAP : Update3RECORDData record numberint100
18/BIC/ADS_VBEP40DataStore Object DS_VBEP : Update3RECORDData record numberint100
19/BIC/B0000005000Change Log Table of DataStore Object 0PERS_BOD4RECORDData record numberint100
20/BIC/B0000006000Change Log Table of DataStore Object 0PERS_VAR4RECORDData record numberint100
21/BIC/B0000007000Change Log Table of DataStore Object 0PERS_WTE4RECORDData record numberint100
22/BIC/B0000008000Transfer Structure Application 80RSPL_AGS4RECORDData record numberint100
23/BIC/B0000009000Transfer Structure Application 80RSPL_AST4RECORDData record numberint100
24/BIC/B0000010000Transfer Structure Application 80RSPL_CST4RECORDData record numberint100
25/BIC/B0000011000Transfer Structure Application 80RSPL_HST4RECORDData record numberint100
26/BIC/B0000012000Transfer Structure Application 80RSPL_LCK4RECORDData record numberint100
27/BIC/B0000013000Transfer Structure Application 80RSPL_PLC4RECORDData record numberint100
28/BIC/B0000014000Transfer Structure Application 80RSPL_PSS4RECORDData record numberint100
29/BIC/B0000015000Transfer Structure Application 80RSPL_SEL4RECORDData record numberint100
30/BIC/B0000016000Transfer Structure Application 80RSPL_SPS4RECORDData record numberint100
31/BIC/B0000017000Change Log Table of DataStore Object 0TCTHP24O4RECORDData record numberint100
32/BIC/B0000018000Error Stack DTP_7KU36MOUFNCES7S4B2PZC13FM 00014RECORDData record numberint100
33/BIC/B0000020000Error Stack DTP_2A5Z40NS1YWKXF2SVP67BN60Z 00013RECORDData record numberint100
34/BIC/B0000021000Error Stack DTP_6IRBVE9XUG23ADD5OVSAZGAPV 00013RECORDData record numberint100
35/BIC/B0000022000Error Stack DTP_6Q0G7XQAXLGVPAQWU3CGHWF2B 00013RECORDData record numberint100
36/BIC/B0000103000PSA for /CPD/PFP_DS_AFVC T90CLNT090 DataSource for NWA4RECORDData record numberint100
37/BIC/B0000103001PSA for /CPD/PFP_DS_AFVC T90CLNT090 DataSource for NWA4RECORDData record numberint100
38/BIC/B0000104000PSA for /CPD/PFP_DS_AUFK T90CLNT090 DataSource for Ntwrk4RECORDData record numberint100
39/BIC/B0000104001PSA for /CPD/PFP_DS_AUFK T90CLNT090 DataSource for Ntwrk4RECORDData record numberint100
40/BIC/B0000105000PSA for /CPD/PFP_DS_PROJ T90CLNT090 DataSource for Proj.4RECORDData record numberint100
41/BIC/B0000105001PSA for /CPD/PFP_DS_PROJ T90CLNT090 DataSource for Proj.4RECORDData record numberint100
42/BIC/B0000106000PSA for /CPD/PFP_DS_PROJ_TEXT T90CLNT090 DataSource for Proj4RECORDData record numberint100
43/BIC/B0000107000PSA for /CPD/PFP_DS_SALES T90CLNT090 DataSource for SO4RECORDData record numberint100
44/BIC/B0000107001PSA for /CPD/PFP_DS_SALES T90CLNT090 DataSource for SO4RECORDData record numberint100
45/BIC/B0000108000PSA for /CPD/PFP_DS_WBS T90CLNT090 DataSource for WBS4RECORDData record numberint100
46/BIC/B0000108001PSA for /CPD/PFP_DS_WBS T90CLNT090 DataSource for WBS4RECORDData record numberint100
47/BIC/B0000109000PSA for /CPD/PFP_DS_WBS_DATE T90CLNT090 DataSource for WBS4RECORDData record numberint100
48/BIC/B0000109001PSA for /CPD/PFP_DS_WBS_DATE T90CLNT090 DataSource for WBS4RECORDData record numberint100
49/BIC/B0000110000PSA for /CPD/PFP_DS_WBS_TEXT T90CLNT090 DataSource for WBS4RECORDData record numberint100
50/BIC/B0000111000Error Stack DTP_00O2TFWN1YKGA5W5VMZCQUQ9C 00013RECORDData record numberint100
51/BIC/B0000112000Error Stack DTP_00O2TFWN1YKGA5W5VZK10DGTS 00013RECORDData record numberint100
52/BIC/B0000113000Error Stack DTP_00O2TFWN1YKGA5W5VZK10DN5C 00013RECORDData record numberint100
53/BIC/B0000114000Error Stack DTP_00O2TFWN1YKGA5W5VZK10DTGW 00013RECORDData record numberint100
54/BIC/B0000115000Error Stack DTP_00O2TFWN1YKGA5W5VZK10DZSG 00013RECORDData record numberint100
55/BIC/B0000116000Error Stack DTP_00O2TFWN1YKGA5W5VZK10E640 00013RECORDData record numberint100
56/BIC/B0000119000Error Stack DTP_00O2TFWN1YKGA5W5VZK10EVE8 00013RECORDData record numberint100
57/BIC/B0000120000Error Stack DTP_00O2TFWN1YKGA5W5VZK10F1PS 00013RECORDData record numberint100
58/BIC/B0000121000Error Stack DTP_00O2TFWN1YKGA5W5VZK10F81C 00013RECORDData record numberint100
59/BIC/B0000122000Error Stack DTP_00O2TFWN1YKGA5W5VZK10FECW 00013RECORDData record numberint100
60/BIC/B0000135000Change Log Table of DataStore Object 0PERS_VR14RECORDData record numberint100
61/BIC/B0000136000PSA for 0DPR_PROJECT_TEXT T90CLNT090 Project Def. Texts4RECORDData record numberint100
62/BIC/B0000137000PSA for 0DPR_PHASE_TEXT T90CLNT090 Phase Texts4RECORDData record numberint100
63/BIC/B0000138000PSA for 0DPR_TASK_TEXT T90CLNT090 Task Texts4RECORDData record numberint100
64/BIC/B0000139000PSA for 0DPR_PROJECT_DATE T90CLNT090 Proj. Def. Dates4RECORDData record numberint100
65/BIC/B0000140000PSA for 0DPR_PHASE_DATE T90CLNT090 Phase Dates4RECORDData record numberint100
66/BIC/B0000141000PSA for 0DPR_TASK_DATE T90CLNT090 Task Dates4RECORDData record numberint100
67/BIC/B0000142000Error Stack DTP_00O2TFWN1YKGADIODUBANX15I 00013RECORDData record numberint100
68/BIC/B0000143000Error Stack DTP_00O2TFWN1YKGADIOMZUJZ77YU 00013RECORDData record numberint100
69/BIC/B0000145000Error Stack DTP_00O2TFWN1YKGADIXV9YL070NQ 00013RECORDData record numberint100
70/BIC/B0000146000Error Stack DTP_00O2TFWN1YKGADIXWOUPRJLLI 00013RECORDData record numberint100
71/BIC/B0000147000Error Stack DTP_00O2TFWN1YKGADIYBBPTNB0NQ 00013RECORDData record numberint100
72/BIC/B0000148000Error Stack DTP_00O2TFWN1YKGADIYCCY0NJZTI 00013RECORDData record numberint100
73/BIC/B0000149000PSA for 0DPR_TASK_ATTR T90CLNT090 Task Attributes4RECORDData record numberint100
74/BIC/B0000150000Error Stack DTP_00O2TFWN1YKGADJ6HB3FA591Y 00013RECORDData record numberint100
75/BIC/B0000151000PSA for 0DPR_PROJECT_ATTR T90CLNT090 Proj. Def. Attr.4RECORDData record numberint100
76/BIC/B0000152000PSA for 0DPR_PHASE_ATTR T90CLNT090 Phase Attributes4RECORDData record numberint100
77/BIC/B0000153000Error Stack DTP_00O2TFWN1YKGADJ9O05RMDVKM 00013RECORDData record numberint100
78/BIC/B0000155000Error Stack DTP_00O2TFWN1YKGADJE6KMX3PIXI 00013RECORDData record numberint100
79/BIC/B0000156000Error Stack DTP_00O2TFWN1YKGADJEJVZ1LZITY 00013RECORDData record numberint100
80/BIC/B0000157000PSA for 0CO_AREA_ATTR T90CLNT090 CO Area4RECORDData record numberint100
81/BIC/B0000158000PSA for 0CO_AREA_TEXT T90CLNT090 CO Area4RECORDData record numberint100
82/BIC/B0000159000PSA for 0COSTCENTER_ATTR T90CLNT090 Cost center4RECORDData record numberint100
83/BIC/B0000160000PSA for 0COSTCENTER_TEXT T90CLNT090 Cost Center4RECORDData record numberint100
84/BIC/B0000161000Error Stack DTP_00O2TFZRKJJTTMXXZL7N57I2W 00013RECORDData record numberint100
85/BIC/B0000162000Error Stack DTP_00O2TFZRKJJTTMXY0UCUMUCEG 00013RECORDData record numberint100
86/BIC/B0000163000Error Stack DTP_00O2TFZRKJJTTNB2KAIPKOBIG 00013RECORDData record numberint100
87/BIC/B0000164000PSA for 0FI_AP_20 T90CLNT090 Vendor Balances4RECORDData record numberint100
88/BIC/B0000165000PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta4RECORDData record numberint100
89/BIC/B0000166000PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta4RECORDData record numberint100
90/BIC/B0000167000PSA for 0FI_AR_20 T90CLNT090 Customer Balances4RECORDData record numberint100
91/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items4RECORDData record numberint100
92/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact4RECORDData record numberint100
93/BIC/B0000170000PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta4RECORDData record numberint100
94/BIC/B0000171000PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances4RECORDData record numberint100
95/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items4RECORDData record numberint100
96/BIC/B0000173000PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.4RECORDData record numberint100
97/BIC/B0000174000PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs4RECORDData record numberint100
98/BIC/B0000175000PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)4RECORDData record numberint100
99/BIC/B0000176000PSA for 2LIS_11_VAHDR T90CLNT090 Sales Doc. Header4RECORDData record numberint100
100/BIC/B0000177000PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item4RECORDData record numberint100
101/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item4RECORDData record numberint100
102/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule4RECORDData record numberint100
103/BIC/B0000180000PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.4RECORDData record numberint100
104/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.4RECORDData record numberint100
105/BIC/B0000182000PSA for 2LIS_12_VCHDR T90CLNT090 Delivery Header Data4RECORDData record numberint100
106/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item4RECORDData record numberint100
107/BIC/B0000184000PSA for 2LIS_13_VDHDR T90CLNT090 Bill.Doc.Header Data4RECORDData record numberint100
108/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item4RECORDData record numberint100
109/BIC/B0000186000PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.4RECORDData record numberint100
110/BIC/B0000187000PSA for 2LIS_02_ITM T90CLNT090 Purch. Data (Item)4RECORDData record numberint100
111/BIC/B0000188000PSA for 2LIS_02_HDR T90CLNT090 Purch.Data (Header)4RECORDData record numberint100
112/BIC/B0000189000PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line4RECORDData record numberint100
113/BIC/B0000190000PSA for 0MM_PUR_PURCH_DATA T90CLNT090 Purchasing Data4RECORDData record numberint100
114/BIC/B0000191000PSA for 0MM_PUR_PURCH_GROUPS T90CLNT090 Purchasing Groups4RECORDData record numberint100
115/BIC/B0000192000PSA for 0MM_PUR_SRV_LEVEL T90CLNT090 PO Service Level4RECORDData record numberint100
116/BIC/B0000193000PSA for EIM_DS_SD DI_SOURCE Segment 00014RECORDData record numberint100
117/BIC/B0000193001PSA for EIM_DS_SD DI_SOURCE Segment 00014RECORDData record numberint100
118/BIC/B0000199000Change Log Table of DataStore Object DS_AFPO4RECORDData record numberint100
119/BIC/B0000200000Change Log Table of DataStore Object DS_LIPS4RECORDData record numberint100
120/BIC/B0000201000Change Log Table of DataStore Object DS_VBAK4RECORDData record numberint100
121/BIC/B0000202000Change Log Table of DataStore Object DS_VBAP4RECORDData record numberint100
122/BIC/B0000203000Change Log Table of DataStore Object DS_VBEP4RECORDData record numberint100
123/BIC/B0000204000Change Log Table of DataStore Object DS_SD4RECORDData record numberint100
124/BIC/B0000218000PSA for 0CO_OM_OPA_1 T90CLNT090 Orders: Costs4RECORDData record numberint100
125/BIC/B0000219000PSA for 0CO_OM_OPA_3 T90CLNT090 Orders: Total plan4RECORDData record numberint100
126/BIC/B0000220000PSA for 0CO_OM_OPA_4 T90CLNT090 Orders: Statist. KFs4RECORDData record numberint100
127/BIC/B0000221000PSA for 0CO_OM_OPA_2 T90CLNT090 Orders: Budget4RECORDData record numberint100
128/BIC/B0000222000PSA for 0CO_OM_OPA_5 T90CLNT090 Orders: Selections4RECORDData record numberint100
129/BIC/B0000223000PSA for 0CO_OM_OPA_6 T90CLNT090 Orders: ActCostDelta4RECORDData record numberint100
130/BIC/B0000224000Error Stack DTP_00O2TFWN1YKGA5W5VZK10ECFK 00013RECORDData record numberint100
131/BIC/B0000225000Error Stack DTP_00O2TFWN1YKGA5W5VZK10FKOG 00013RECORDData record numberint100
132/BIC/B0000228000PSA for DS_MM DI_SOURCE Segment 00014RECORDData record numberint100
133/BIC/B0000231000PSA for DS_AFPO DI_SOURCE Segment 00014RECORDData record numberint100
134/BIC/B0000232000PSA for DS_LIPS DI_SOURCE Segment 00014RECORDData record numberint100
135/BIC/B0000233000PSA for DS_VBAP DI_SOURCE Segment 00014RECORDData record numberint100
136/BIC/B0000235000Change Log Table of DataStore Object DSO_MM4RECORDData record numberint100
137/BIC/B0000236000Error Stack DTP_00O2TFZRKJJTXIV6GVLF1A9US 00013RECORDData record numberint100
138/BIC/B0000239000Error Stack DTP_00O2TFZRKJJTXIV6XZRUGXX0K 00013RECORDData record numberint100
139/BIC/B0000240000Change Log Table of DataStore Object DSO_LIPS4RECORDData record numberint100
140/BIC/B0000241000Error Stack DTP_00O2TFZRKJJTXIV7AUFQUKRC4 00013RECORDData record numberint100
141/BIC/B0000244000Change Log Table of DataStore Object DSO_AFPO4RECORDData record numberint100
142/BIC/B0000245000Error Stack DTP_00O2TFZRKJJTXIV7H86N4C3MS 00013RECORDData record numberint100
143/BIC/B0000248000Change Log Table of DataStore Object DSO_VBAP4RECORDData record numberint100
144/BIC/B0000249000Error Stack DTP_00O2TFZRKJJTXIV7NTEN8F8MC 00013RECORDData record numberint100
145/BIC/B0000271000PSA for DS_VBEP DI_SOURCE Segment 00014RECORDData record numberint100
146/BIC/B0000272000Change Log Table of DataStore Object DSO_VBEP4RECORDData record numberint100
147/BIC/B0000273000Error Stack DTP_00O2TFZRKJJTXIVD2NP2LCK10 00013RECORDData record numberint100
148/BIC/B0000275000Error Stack DTP_00O2TFZRKJJS7989O6XE0R34W 00013RECORDData record numberint100
149/BIC/B0000276000Transfer Structure Application /CPD/8PFP_C014RECORDData record numberint100
150/BIC/B0000277000Change Log Table of DataStore Object DSO_APD4RECORDData record numberint100
151/BIC/B0000278000Error Stack DTP_00O2TFZRKJJS7AP8VXS1PV657 00013RECORDData record numberint100
152/BIC/B0000279000Error Stack DTP_00O2TFZRKJJS7AP9S537RKR8B 00013RECORDData record numberint100
153/BIC/B0000280000PSA for 0HR_PA_0 T90CLNT090 Employee4RECORDData record numberint100
154/BIC/B0000281000PSA for 0EMPLOYEE_ATTR T90CLNT090 Employee4RECORDData record numberint100
155/BIC/B0000282000PSA for 0EMPLOYEE_TEXT T90CLNT090 Employee4RECORDData record numberint100
156/BIC/B0000283000PSA for 0EMPLOYEE_2_ATTR T90CLNT090 Employee4RECORDData record numberint100
157/BIC/B0000284000PSA for 0EMPLOYEE_2_TEXT T90CLNT090 Employee (Texts)4RECORDData record numberint100
158/BIC/B0000285000PSA for 0PERSON_ATTR T90CLNT090 Person4RECORDData record numberint100
159/BIC/B0000286000PSA for 0PERSON_TEXT T90CLNT090 Person4RECORDData record numberint100
160LTR_DELIM_RLT_TDelimitation Result - Trace Data6RECORDntext10737418230
161YRELOGLog-Tabelle für mit Korrekturreports geänderte Re-Daten9RECORDntext10737418230
TOPBatches
162TCUDB_PROCESSDocumentary Batch Settings - Manaual Process Steps3RECORDEntry of Documentary Batchesnvarchar10
TOPCross-Application Components
163QDATTable For Storing Received Queue Data2RECORDnvarchar10
TOPData Basis
164RSDMODSTAB_MPPModel Table for DataStore Object: Table for MPP3RECORDData record numberint100
165RSDMODSTAB_URModel Table for ODS Update and Rollback3RECORDData record numberint100
TOPData Staging
166RSAR_BUFFERGeneric Buffer for Error Stack Records4RECORDData record numberint100
167RSBERRORCHANGEDLog of Changed Records4RECORDData record numberint100
168RSBERRORLOGLogs for Incorrect Records5RECORDData record numberint100
169RSBKDTPSTATStatus Information on Data Transfer Process8RECORDData record numberint100
170RSDSRTSEGCOUNTDataSource: Data Package ID Counter, Record6RECORDData record numberint100
171RSERRORHEADIncorrect Records (Header Table)4RECORDData record numberint100
172RSERRORLOGLogs for Incorrect Records (Header RSERRORHEAD)4RECORDData record numberint100
TOPF4 Help
173DDSHHVALUEHistoric Help Values5RECORDvarbinary1320
174DDSHPVAL50Personal Help Values from Release 5.07RECORDnvarchar2550
175DDSHPVALUEPersonal Help Values7RECORDvarbinary2550
TOPRuntime Analysis
176SATR_PRFLRECSSAT: Records in the Flexible Profile2RECORDProgram/Transaction in SQL Trace Evaluationnvarchar400
177SATR_PRFLRECSTSAT: Language Table for Profile Records3RECORDProgram/Transaction in SQL Trace Evaluationnvarchar400
TOPSAP Healthcare - Industry-Specific Components for Hospitals
178TNLCINV01Sammelrechnung strukturen pro sammelrechnung type and rekord2RECORDSammelrechnung recordnvarchar20
TOPSocial Services and Social Security
179PSSCD_SXP_ELIGEligibility Periods3RECORDSocial Services: Record of Eligibility datavarbinary160
TOPWeb Dynpro ABAP
180MEM_ALLOCtest for WDA mem allocation2RECORDCharacter 1024nvarchar10240