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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Controlling :: Overhead Cost Controlling :: Cost Center Accounting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0COSPR1592CO Objekt: Enhancement to COSP for Dependency PlanningCost Center Accounting
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, LEDNR, OBJNR, GJAHR, WRTTP, VERSN, KSTAR, HRKFT, VRGNG, VBUND, PARGB, BEKNZ, TWAER, PERBL, RKG001, RKG002, RKG003, RKG004, RKG005, RKG006, RKG007, RKG008, RKG009, RKG010, RKG011, RKG012, RKG013, RKG014, RKG015, RKG016, RKF001, RKF002, RKF003, RKF004, RKF005, RKF006, RKF007, RKF008, RKF009, RKF010, RKF011, RKF012, RKF013, RKF014, RKF015, RKF016, RKE001, RKE002, RKE003, RKE004, RKE005, RKE006, RKE007, RKE008, RKE009, RKE010, RKE011, RKE012, RKE013, RKE014, RKE015, RKE016, ROG001, ROG002, ROG003, ROG004, ROG005, ROG006, ROG007, ROG008, ROG009, ROG010, ROG011, ROG012, ROG013, ROG014, ROG015, ROG016, ROF001, ROF002, ROF003, ROF004, ROF005, ROF006, ROF007, ROF008, ROF009, ROF010, ROF011, ROF012, ROF013, ROF014, ROF015, ROF016, ROE001, ROE002, ROE003, ROE004, ROE005, ROE006, ROE007, ROE008, ROE009, ROE010, ROE011, ROE012, ROE013, ROE014, ROE015, ROE016, MEINH, REG001, REG002, REG003, REG004, REG005, REG006, REG007, REG008, REG009, REG010, REG011, REG012, REG013, REG014, REG015, REG016, REF001, REF002, REF003, REF004, REF005, REF006, REF007, REF008, REF009, REF010, REF011, REF012, REF013, REF014, REF015, REF016, REE001, REE002, REE003, REE004, REE005, REE006, REE007, REE008, REE009, REE010, REE011, REE012, REE013, REE014, REE015, REE016 FROM COSPR
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2LEDNRLedger for Controlling objectsnvarchar20CHAR(N' ')NoLEDNR Allow NULL? 
3OBJNRObject numbernvarchar220CHAR(N' ')NoONR00J_OBJNR Allow NULL? 
4GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
5WRTTPValue Typenvarchar20CHAR(N' ')NoCO_WRTTP Allow NULL? 
6VERSNVersionnvarchar30CHAR(N' ')NoTKA09VERSN Allow NULL? 
7KSTARCost Elementnvarchar100CHAR(N' ')NoCSKAKSTAR Allow NULL? 
8HRKFTCO key subnumbernvarchar140CHAR(N' ')No*CO_SUBKEY Allow NULL? 
9VRGNGCO Business Transactionnvarchar40CHAR(N' ')No*CO_VORGANG Allow NULL? 
10VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')NoT880RASSC Allow NULL? 
11PARGBTrading partner's business areanvarchar40CHAR(N' ')NoTGSBPARGB Allow NULL? 
12BEKNZDebit/credit indicatorchar10CHAR(N' ')NoBEKNZ Allow NULL? 
13TWAERTransaction Currencynvarchar50CUKY(N' ')NoTCURCTWAER Allow NULL? 
14PERBLPeriod blocknvarchar30NUMC(N'000')NoPERBL Allow NULL? 
15RKG001Total Dependency Price Per Source Unit in CO Area Currencydecimal152CURR((0))YesRKGYYY
16RKG002Total Dependency Price Per Source Unit in CO Area Currencydecimal152CURR((0))YesRKGYYY
17RKG003Total Dependency Price Per Source Unit in CO Area Currencydecimal152CURR((0))YesRKGYYY
18RKG004Total Dependency Price Per Source Unit in CO Area Currencydecimal152CURR((0))YesRKGYYY
19RKG005Total Dependency Price Per Source Unit in CO Area Currencydecimal152CURR((0))YesRKGYYY
20RKG006Total Dependency Price Per Source Unit in CO Area Currencydecimal152CURR((0))YesRKGYYY
21RKG007Total Dependency Price Per Source Unit in CO Area Currencydecimal152CURR((0))YesRKGYYY
22RKG008Total Dependency Price Per Source Unit in CO Area Currencydecimal152CURR((0))YesRKGYYY
23RKG009Total Dependency Price Per Source Unit in CO Area Currencydecimal152CURR((0))YesRKGYYY
24RKG010Total Dependency Price Per Source Unit in CO Area Currencydecimal152CURR((0))YesRKGYYY
25RKG011Total Dependency Price Per Source Unit in CO Area Currencydecimal152CURR((0))YesRKGYYY
26RKG012Total Dependency Price Per Source Unit in CO Area Currencydecimal152CURR((0))YesRKGYYY
27RKG013Total Dependency Price Per Source Unit in CO Area Currencydecimal152CURR((0))YesRKGYYY
28RKG014Total Dependency Price Per Source Unit in CO Area Currencydecimal152CURR((0))YesRKGYYY
29RKG015Total Dependency Price Per Source Unit in CO Area Currencydecimal152CURR((0))YesRKGYYY
30RKG016Total Dependency Price Per Source Unit in CO Area Currencydecimal152CURR((0))YesRKGYYY
31RKF001Fixed dependency price per source unit in CO area currencydecimal152CURR((0))YesRKFYYY
32RKF002Fixed dependency price per source unit in CO area currencydecimal152CURR((0))YesRKFYYY
33RKF003Fixed dependency price per source unit in CO area currencydecimal152CURR((0))YesRKFYYY
34RKF004Fixed dependency price per source unit in CO area currencydecimal152CURR((0))YesRKFYYY
35RKF005Fixed dependency price per source unit in CO area currencydecimal152CURR((0))YesRKFYYY
36RKF006Fixed dependency price per source unit in CO area currencydecimal152CURR((0))YesRKFYYY
37RKF007Fixed dependency price per source unit in CO area currencydecimal152CURR((0))YesRKFYYY
38RKF008Fixed dependency price per source unit in CO area currencydecimal152CURR((0))YesRKFYYY
39RKF009Fixed dependency price per source unit in CO area currencydecimal152CURR((0))YesRKFYYY
40RKF010Fixed dependency price per source unit in CO area currencydecimal152CURR((0))YesRKFYYY
41RKF011Fixed dependency price per source unit in CO area currencydecimal152CURR((0))YesRKFYYY
42RKF012Fixed dependency price per source unit in CO area currencydecimal152CURR((0))YesRKFYYY
43RKF013Fixed dependency price per source unit in CO area currencydecimal152CURR((0))YesRKFYYY
44RKF014Fixed dependency price per source unit in CO area currencydecimal152CURR((0))YesRKFYYY
45RKF015Fixed dependency price per source unit in CO area currencydecimal152CURR((0))YesRKFYYY
46RKF016Fixed dependency price per source unit in CO area currencydecimal152CURR((0))YesRKFYYY
47RKE001Dependency price unit in CO area currencynvarchar50NUMC(N'00000')YesRKEYYY Allow NULL? 
48RKE002Dependency price unit in CO area currencynvarchar50NUMC(N'00000')YesRKEYYY Allow NULL? 
49RKE003Dependency price unit in CO area currencynvarchar50NUMC(N'00000')YesRKEYYY Allow NULL? 
50RKE004Dependency price unit in CO area currencynvarchar50NUMC(N'00000')YesRKEYYY Allow NULL? 
51RKE005Dependency price unit in CO area currencynvarchar50NUMC(N'00000')YesRKEYYY Allow NULL? 
52RKE006Dependency price unit in CO area currencynvarchar50NUMC(N'00000')YesRKEYYY Allow NULL? 
53RKE007Dependency price unit in CO area currencynvarchar50NUMC(N'00000')YesRKEYYY Allow NULL? 
54RKE008Dependency price unit in CO area currencynvarchar50NUMC(N'00000')YesRKEYYY Allow NULL? 
55RKE009Dependency price unit in CO area currencynvarchar50NUMC(N'00000')YesRKEYYY Allow NULL? 
56RKE010Dependency price unit in CO area currencynvarchar50NUMC(N'00000')YesRKEYYY Allow NULL? 
57RKE011Dependency price unit in CO area currencynvarchar50NUMC(N'00000')YesRKEYYY Allow NULL? 
58RKE012Dependency price unit in CO area currencynvarchar50NUMC(N'00000')YesRKEYYY Allow NULL? 
59RKE013Dependency price unit in CO area currencynvarchar50NUMC(N'00000')YesRKEYYY Allow NULL? 
60RKE014Dependency price unit in CO area currencynvarchar50NUMC(N'00000')YesRKEYYY Allow NULL? 
61RKE015Dependency price unit in CO area currencynvarchar50NUMC(N'00000')YesRKEYYY Allow NULL? 
62RKE016Dependency price unit in CO area currencynvarchar50NUMC(N'00000')YesRKEYYY Allow NULL? 
63ROG001Total dependency price per source unit in object currencydecimal152CURR((0))YesROGYYY
64ROG002Total dependency price per source unit in object currencydecimal152CURR((0))YesROGYYY
65ROG003Total dependency price per source unit in object currencydecimal152CURR((0))YesROGYYY
66ROG004Total dependency price per source unit in object currencydecimal152CURR((0))YesROGYYY
67ROG005Total dependency price per source unit in object currencydecimal152CURR((0))YesROGYYY
68ROG006Total dependency price per source unit in object currencydecimal152CURR((0))YesROGYYY
69ROG007Total dependency price per source unit in object currencydecimal152CURR((0))YesROGYYY
70ROG008Total dependency price per source unit in object currencydecimal152CURR((0))YesROGYYY
71ROG009Total dependency price per source unit in object currencydecimal152CURR((0))YesROGYYY
72ROG010Total dependency price per source unit in object currencydecimal152CURR((0))YesROGYYY
73ROG011Total dependency price per source unit in object currencydecimal152CURR((0))YesROGYYY
74ROG012Total dependency price per source unit in object currencydecimal152CURR((0))YesROGYYY
75ROG013Total dependency price per source unit in object currencydecimal152CURR((0))YesROGYYY
76ROG014Total dependency price per source unit in object currencydecimal152CURR((0))YesROGYYY
77ROG015Total dependency price per source unit in object currencydecimal152CURR((0))YesROGYYY
78ROG016Total dependency price per source unit in object currencydecimal152CURR((0))YesROGYYY
79ROF001Fixed dependency price per source unit in object currencydecimal152CURR((0))YesROFYYY
80ROF002Fixed dependency price per source unit in object currencydecimal152CURR((0))YesROFYYY
81ROF003Fixed dependency price per source unit in object currencydecimal152CURR((0))YesROFYYY
82ROF004Fixed dependency price per source unit in object currencydecimal152CURR((0))YesROFYYY
83ROF005Fixed dependency price per source unit in object currencydecimal152CURR((0))YesROFYYY
84ROF006Fixed dependency price per source unit in object currencydecimal152CURR((0))YesROFYYY
85ROF007Fixed dependency price per source unit in object currencydecimal152CURR((0))YesROFYYY
86ROF008Fixed dependency price per source unit in object currencydecimal152CURR((0))YesROFYYY
87ROF009Fixed dependency price per source unit in object currencydecimal152CURR((0))YesROFYYY
88ROF010Fixed dependency price per source unit in object currencydecimal152CURR((0))YesROFYYY
89ROF011Fixed dependency price per source unit in object currencydecimal152CURR((0))YesROFYYY
90ROF012Fixed dependency price per source unit in object currencydecimal152CURR((0))YesROFYYY
91ROF013Fixed dependency price per source unit in object currencydecimal152CURR((0))YesROFYYY
92ROF014Fixed dependency price per source unit in object currencydecimal152CURR((0))YesROFYYY
93ROF015Fixed dependency price per source unit in object currencydecimal152CURR((0))YesROFYYY
94ROF016Fixed dependency price per source unit in object currencydecimal152CURR((0))YesROFYYY
95ROE001Dependency price unit in object currencynvarchar50NUMC(N'00000')YesROEYYY Allow NULL? 
96ROE002Dependency price unit in object currencynvarchar50NUMC(N'00000')YesROEYYY Allow NULL? 
97ROE003Dependency price unit in object currencynvarchar50NUMC(N'00000')YesROEYYY Allow NULL? 
98ROE004Dependency price unit in object currencynvarchar50NUMC(N'00000')YesROEYYY Allow NULL? 
99ROE005Dependency price unit in object currencynvarchar50NUMC(N'00000')YesROEYYY Allow NULL? 
100ROE006Dependency price unit in object currencynvarchar50NUMC(N'00000')YesROEYYY Allow NULL? 
101ROE007Dependency price unit in object currencynvarchar50NUMC(N'00000')YesROEYYY Allow NULL? 
102ROE008Dependency price unit in object currencynvarchar50NUMC(N'00000')YesROEYYY Allow NULL? 
103ROE009Dependency price unit in object currencynvarchar50NUMC(N'00000')YesROEYYY Allow NULL? 
104ROE010Dependency price unit in object currencynvarchar50NUMC(N'00000')YesROEYYY Allow NULL? 
105ROE011Dependency price unit in object currencynvarchar50NUMC(N'00000')YesROEYYY Allow NULL? 
106ROE012Dependency price unit in object currencynvarchar50NUMC(N'00000')YesROEYYY Allow NULL? 
107ROE013Dependency price unit in object currencynvarchar50NUMC(N'00000')YesROEYYY Allow NULL? 
108ROE014Dependency price unit in object currencynvarchar50NUMC(N'00000')YesROEYYY Allow NULL? 
109ROE015Dependency price unit in object currencynvarchar50NUMC(N'00000')YesROEYYY Allow NULL? 
110ROE016Dependency price unit in object currencynvarchar50NUMC(N'00000')YesROEYYY Allow NULL? 
111MEINHUnit of Measurenvarchar30UNIT(N' ')YesT006CO_MEINH Allow NULL? 
112REG001Total dependency quantity per source unitdecimal153QUAN((0))YesREGYYY
113REG002Total dependency quantity per source unitdecimal153QUAN((0))YesREGYYY
114REG003Total dependency quantity per source unitdecimal153QUAN((0))YesREGYYY
115REG004Total dependency quantity per source unitdecimal153QUAN((0))YesREGYYY
116REG005Total dependency quantity per source unitdecimal153QUAN((0))YesREGYYY
117REG006Total dependency quantity per source unitdecimal153QUAN((0))YesREGYYY
118REG007Total dependency quantity per source unitdecimal153QUAN((0))YesREGYYY
119REG008Total dependency quantity per source unitdecimal153QUAN((0))YesREGYYY
120REG009Total dependency quantity per source unitdecimal153QUAN((0))YesREGYYY
121REG010Total dependency quantity per source unitdecimal153QUAN((0))YesREGYYY
122REG011Total dependency quantity per source unitdecimal153QUAN((0))YesREGYYY
123REG012Total dependency quantity per source unitdecimal153QUAN((0))YesREGYYY
124REG013Total dependency quantity per source unitdecimal153QUAN((0))YesREGYYY
125REG014Total dependency quantity per source unitdecimal153QUAN((0))YesREGYYY
126REG015Total dependency quantity per source unitdecimal153QUAN((0))YesREGYYY
127REG016Total dependency quantity per source unitdecimal153QUAN((0))YesREGYYY
128REF001Fixed dependency qty per source unitdecimal153QUAN((0))YesREFYYY
129REF002Fixed dependency qty per source unitdecimal153QUAN((0))YesREFYYY
130REF003Fixed dependency qty per source unitdecimal153QUAN((0))YesREFYYY
131REF004Fixed dependency qty per source unitdecimal153QUAN((0))YesREFYYY
132REF005Fixed dependency qty per source unitdecimal153QUAN((0))YesREFYYY
133REF006Fixed dependency qty per source unitdecimal153QUAN((0))YesREFYYY
134REF007Fixed dependency qty per source unitdecimal153QUAN((0))YesREFYYY
135REF008Fixed dependency qty per source unitdecimal153QUAN((0))YesREFYYY
136REF009Fixed dependency qty per source unitdecimal153QUAN((0))YesREFYYY
137REF010Fixed dependency qty per source unitdecimal153QUAN((0))YesREFYYY
138REF011Fixed dependency qty per source unitdecimal153QUAN((0))YesREFYYY
139REF012Fixed dependency qty per source unitdecimal153QUAN((0))YesREFYYY
140REF013Fixed dependency qty per source unitdecimal153QUAN((0))YesREFYYY
141REF014Fixed dependency qty per source unitdecimal153QUAN((0))YesREFYYY
142REF015Fixed dependency qty per source unitdecimal153QUAN((0))YesREFYYY
143REF016Fixed dependency qty per source unitdecimal153QUAN((0))YesREFYYY
144REE001Dependency quantity unitnvarchar50NUMC(N'00000')YesREEYYY Allow NULL? 
145REE002Dependency quantity unitnvarchar50NUMC(N'00000')YesREEYYY Allow NULL? 
146REE003Dependency quantity unitnvarchar50NUMC(N'00000')YesREEYYY Allow NULL? 
147REE004Dependency quantity unitnvarchar50NUMC(N'00000')YesREEYYY Allow NULL? 
148REE005Dependency quantity unitnvarchar50NUMC(N'00000')YesREEYYY Allow NULL? 
149REE006Dependency quantity unitnvarchar50NUMC(N'00000')YesREEYYY Allow NULL? 
150REE007Dependency quantity unitnvarchar50NUMC(N'00000')YesREEYYY Allow NULL? 
151REE008Dependency quantity unitnvarchar50NUMC(N'00000')YesREEYYY Allow NULL? 
152REE009Dependency quantity unitnvarchar50NUMC(N'00000')YesREEYYY Allow NULL? 
153REE010Dependency quantity unitnvarchar50NUMC(N'00000')YesREEYYY Allow NULL? 
154REE011Dependency quantity unitnvarchar50NUMC(N'00000')YesREEYYY Allow NULL? 
155REE012Dependency quantity unitnvarchar50NUMC(N'00000')YesREEYYY Allow NULL? 
156REE013Dependency quantity unitnvarchar50NUMC(N'00000')YesREEYYY Allow NULL? 
157REE014Dependency quantity unitnvarchar50NUMC(N'00000')YesREEYYY Allow NULL? 
158REE015Dependency quantity unitnvarchar50NUMC(N'00000')YesREEYYY Allow NULL? 
159REE016Dependency quantity unitnvarchar50NUMC(N'00000')YesREEYYY Allow NULL? 
NamePrimaryUniqueTypeColumns
COSPR~0YesYesCLUSTEREDPERBL, TWAER, BEKNZ, PARGB, VBUND, VRGNG, HRKFT, KSTAR, VERSN, WRTTP, GJAHR, OBJNR, LEDNR, MANDT
COSPR~1NoNoNONCLUSTEREDVRGNG, GJAHR, WRTTP, VERSN, LEDNR, MANDT, OBJNR