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 :: Profitability Analysis
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0CECOEJ2011CO-PA Account Based Line ItemsProfitability Analysis
SQL:  selectupdate insert create

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

SELECT MANDT, KOKRS, BELNR, BUZEI, PERBL, ERKRS, CE4KEY, WTG001, WTG002, WTG003, WTG004, WTG005, WTG006, WTG007, WTG008, WTG009, WTG010, WTG011, WTG012, WTG013, WTG014, WTG015, WTG016, WOG001, WOG002, WOG003, WOG004, WOG005, WOG006, WOG007, WOG008, WOG009, WOG010, WOG011, WOG012, WOG013, WOG014, WOG015, WOG016, WKG001, WKG002, WKG003, WKG004, WKG005, WKG006, WKG007, WKG008, WKG009, WKG010, WKG011, WKG012, WKG013, WKG014, WKG015, WKG016, WKF001, WKF002, WKF003, WKF004, WKF005, WKF006, WKF007, WKF008, WKF009, WKF010, WKF011, WKF012, WKF013, WKF014, WKF015, WKF016, PAG001, PAG002, PAG003, PAG004, PAG005, PAG006, PAG007, PAG008, PAG009, PAG010, PAG011, PAG012, PAG013, PAG014, PAG015, PAG016, PAF001, PAF002, PAF003, PAF004, PAF005, PAF006, PAF007, PAF008, PAF009, PAF010, PAF011, PAF012, PAF013, PAF014, PAF015, PAF016, MEG001, MEG002, MEG003, MEG004, MEG005, MEG006, MEG007, MEG008, MEG009, MEG010, MEG011, MEG012, MEG013, MEG014, MEG015, MEG016, MEF001, MEF002, MEF003, MEF004, MEF005, MEF006, MEF007, MEF008, MEF009, MEF010, MEF011, MEF012, MEF013, MEF014, MEF015, MEF016, MBG001, MBG002, MBG003, MBG004, MBG005, MBG006, MBG007, MBG008, MBG009, MBG010, MBG011, MBG012, MBG013, MBG014, MBG015, MBG016, MBF001, MBF002, MBF003, MBF004, MBF005, MBF006, MBF007, MBF008, MBF009, MBF010, MBF011, MBF012, MBF013, MBF014, MBF015, MBF016, LEDNR, OBJNR, GJAHR, WRTTP, VERSN, KSTAR, HRKFT, VRGNG, PAROB, PAROB1, USPOB, VBUND, PARGB, BEKNZ, TWAER, MEINH, MEINB, SGTXT, REFBZ, ZLENR, BW_REFBZ, BELTP, TIMESTMP, PAOBJNR, FKBER, PFKBER, GEBER, PGEBER, GRANT_NBR, PGRANT_NBR, SEGMENT, PSEGMENT, BUDGET_PD, PBUDGET_PD FROM CECOEJ
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2KOKRSControlling Areanvarchar40CHAR(N' ')NoTKA01KOKRS Allow NULL? 
3BELNRDocument Numbernvarchar100CHAR(N' ')NoCOBKCO_BELNR Allow NULL? 
4BUZEIPosting rownvarchar30NUMC(N'000')NoCO_BUZEI Allow NULL? 
5PERBLPeriod blocknvarchar30NUMC(N'000')NoPERBL Allow NULL? 
6ERKRSOperating concernnvarchar40CHAR(N' ')Yes*ERKRS Allow NULL? 
7CE4KEYProfitability Segment Number (CO-PA)nvarchar100NUMC(N'0000000000')YesRKEOBJNR Allow NULL? 
8WTG001Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
9WTG002Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
10WTG003Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
11WTG004Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
12WTG005Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
13WTG006Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
14WTG007Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
15WTG008Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
16WTG009Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
17WTG010Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
18WTG011Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
19WTG012Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
20WTG013Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
21WTG014Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
22WTG015Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
23WTG016Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
24WOG001Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
25WOG002Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
26WOG003Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
27WOG004Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
28WOG005Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
29WOG006Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
30WOG007Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
31WOG008Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
32WOG009Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
33WOG010Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
34WOG011Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
35WOG012Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
36WOG013Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
37WOG014Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
38WOG015Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
39WOG016Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
40WKG001Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
41WKG002Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
42WKG003Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
43WKG004Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
44WKG005Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
45WKG006Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
46WKG007Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
47WKG008Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
48WKG009Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
49WKG010Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
50WKG011Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
51WKG012Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
52WKG013Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
53WKG014Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
54WKG015Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
55WKG016Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
56WKF001Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
57WKF002Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
58WKF003Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
59WKF004Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
60WKF005Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
61WKF006Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
62WKF007Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
63WKF008Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
64WKF009Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
65WKF010Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
66WKF011Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
67WKF012Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
68WKF013Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
69WKF014Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
70WKF015Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
71WKF016Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
72PAG001Total Price Variance in CO Area Currencydecimal152CURR((0))YesPAGXXX
73PAG002Total Price Variance in CO Area Currencydecimal152CURR((0))YesPAGXXX
74PAG003Total Price Variance in CO Area Currencydecimal152CURR((0))YesPAGXXX
75PAG004Total Price Variance in CO Area Currencydecimal152CURR((0))YesPAGXXX
76PAG005Total Price Variance in CO Area Currencydecimal152CURR((0))YesPAGXXX
77PAG006Total Price Variance in CO Area Currencydecimal152CURR((0))YesPAGXXX
78PAG007Total Price Variance in CO Area Currencydecimal152CURR((0))YesPAGXXX
79PAG008Total Price Variance in CO Area Currencydecimal152CURR((0))YesPAGXXX
80PAG009Total Price Variance in CO Area Currencydecimal152CURR((0))YesPAGXXX
81PAG010Total Price Variance in CO Area Currencydecimal152CURR((0))YesPAGXXX
82PAG011Total Price Variance in CO Area Currencydecimal152CURR((0))YesPAGXXX
83PAG012Total Price Variance in CO Area Currencydecimal152CURR((0))YesPAGXXX
84PAG013Total Price Variance in CO Area Currencydecimal152CURR((0))YesPAGXXX
85PAG014Total Price Variance in CO Area Currencydecimal152CURR((0))YesPAGXXX
86PAG015Total Price Variance in CO Area Currencydecimal152CURR((0))YesPAGXXX
87PAG016Total Price Variance in CO Area Currencydecimal152CURR((0))YesPAGXXX
88PAF001Fixed Price Variance in CO Area Currencydecimal152CURR((0))YesPAFXXX
89PAF002Fixed Price Variance in CO Area Currencydecimal152CURR((0))YesPAFXXX
90PAF003Fixed Price Variance in CO Area Currencydecimal152CURR((0))YesPAFXXX
91PAF004Fixed Price Variance in CO Area Currencydecimal152CURR((0))YesPAFXXX
92PAF005Fixed Price Variance in CO Area Currencydecimal152CURR((0))YesPAFXXX
93PAF006Fixed Price Variance in CO Area Currencydecimal152CURR((0))YesPAFXXX
94PAF007Fixed Price Variance in CO Area Currencydecimal152CURR((0))YesPAFXXX
95PAF008Fixed Price Variance in CO Area Currencydecimal152CURR((0))YesPAFXXX
96PAF009Fixed Price Variance in CO Area Currencydecimal152CURR((0))YesPAFXXX
97PAF010Fixed Price Variance in CO Area Currencydecimal152CURR((0))YesPAFXXX
98PAF011Fixed Price Variance in CO Area Currencydecimal152CURR((0))YesPAFXXX
99PAF012Fixed Price Variance in CO Area Currencydecimal152CURR((0))YesPAFXXX
100PAF013Fixed Price Variance in CO Area Currencydecimal152CURR((0))YesPAFXXX
101PAF014Fixed Price Variance in CO Area Currencydecimal152CURR((0))YesPAFXXX
102PAF015Fixed Price Variance in CO Area Currencydecimal152CURR((0))YesPAFXXX
103PAF016Fixed Price Variance in CO Area Currencydecimal152CURR((0))YesPAFXXX
104MEG001Total Quantitydecimal153QUAN((0))YesMEGXXX
105MEG002Total Quantitydecimal153QUAN((0))YesMEGXXX
106MEG003Total Quantitydecimal153QUAN((0))YesMEGXXX
107MEG004Total Quantitydecimal153QUAN((0))YesMEGXXX
108MEG005Total Quantitydecimal153QUAN((0))YesMEGXXX
109MEG006Total Quantitydecimal153QUAN((0))YesMEGXXX
110MEG007Total Quantitydecimal153QUAN((0))YesMEGXXX
111MEG008Total Quantitydecimal153QUAN((0))YesMEGXXX
112MEG009Total Quantitydecimal153QUAN((0))YesMEGXXX
113MEG010Total Quantitydecimal153QUAN((0))YesMEGXXX
114MEG011Total Quantitydecimal153QUAN((0))YesMEGXXX
115MEG012Total Quantitydecimal153QUAN((0))YesMEGXXX
116MEG013Total Quantitydecimal153QUAN((0))YesMEGXXX
117MEG014Total Quantitydecimal153QUAN((0))YesMEGXXX
118MEG015Total Quantitydecimal153QUAN((0))YesMEGXXX
119MEG016Total Quantitydecimal153QUAN((0))YesMEGXXX
120MEF001Fixed Quantitydecimal153QUAN((0))YesMEFXXX
121MEF002Fixed Quantitydecimal153QUAN((0))YesMEFXXX
122MEF003Fixed Quantitydecimal153QUAN((0))YesMEFXXX
123MEF004Fixed Quantitydecimal153QUAN((0))YesMEFXXX
124MEF005Fixed Quantitydecimal153QUAN((0))YesMEFXXX
125MEF006Fixed Quantitydecimal153QUAN((0))YesMEFXXX
126MEF007Fixed Quantitydecimal153QUAN((0))YesMEFXXX
127MEF008Fixed Quantitydecimal153QUAN((0))YesMEFXXX
128MEF009Fixed Quantitydecimal153QUAN((0))YesMEFXXX
129MEF010Fixed Quantitydecimal153QUAN((0))YesMEFXXX
130MEF011Fixed Quantitydecimal153QUAN((0))YesMEFXXX
131MEF012Fixed Quantitydecimal153QUAN((0))YesMEFXXX
132MEF013Fixed Quantitydecimal153QUAN((0))YesMEFXXX
133MEF014Fixed Quantitydecimal153QUAN((0))YesMEFXXX
134MEF015Fixed Quantitydecimal153QUAN((0))YesMEFXXX
135MEF016Fixed Quantitydecimal153QUAN((0))YesMEFXXX
136MBG001Total quantity entereddecimal153QUAN((0))YesMBGXXX
137MBG002Total quantity entereddecimal153QUAN((0))YesMBGXXX
138MBG003Total quantity entereddecimal153QUAN((0))YesMBGXXX
139MBG004Total quantity entereddecimal153QUAN((0))YesMBGXXX
140MBG005Total quantity entereddecimal153QUAN((0))YesMBGXXX
141MBG006Total quantity entereddecimal153QUAN((0))YesMBGXXX
142MBG007Total quantity entereddecimal153QUAN((0))YesMBGXXX
143MBG008Total quantity entereddecimal153QUAN((0))YesMBGXXX
144MBG009Total quantity entereddecimal153QUAN((0))YesMBGXXX
145MBG010Total quantity entereddecimal153QUAN((0))YesMBGXXX
146MBG011Total quantity entereddecimal153QUAN((0))YesMBGXXX
147MBG012Total quantity entereddecimal153QUAN((0))YesMBGXXX
148MBG013Total quantity entereddecimal153QUAN((0))YesMBGXXX
149MBG014Total quantity entereddecimal153QUAN((0))YesMBGXXX
150MBG015Total quantity entereddecimal153QUAN((0))YesMBGXXX
151MBG016Total quantity entereddecimal153QUAN((0))YesMBGXXX
152MBF001Fixed quantity entereddecimal153QUAN((0))YesMBFXXX
153MBF002Fixed quantity entereddecimal153QUAN((0))YesMBFXXX
154MBF003Fixed quantity entereddecimal153QUAN((0))YesMBFXXX
155MBF004Fixed quantity entereddecimal153QUAN((0))YesMBFXXX
156MBF005Fixed quantity entereddecimal153QUAN((0))YesMBFXXX
157MBF006Fixed quantity entereddecimal153QUAN((0))YesMBFXXX
158MBF007Fixed quantity entereddecimal153QUAN((0))YesMBFXXX
159MBF008Fixed quantity entereddecimal153QUAN((0))YesMBFXXX
160MBF009Fixed quantity entereddecimal153QUAN((0))YesMBFXXX
161MBF010Fixed quantity entereddecimal153QUAN((0))YesMBFXXX
162MBF011Fixed quantity entereddecimal153QUAN((0))YesMBFXXX
163MBF012Fixed quantity entereddecimal153QUAN((0))YesMBFXXX
164MBF013Fixed quantity entereddecimal153QUAN((0))YesMBFXXX
165MBF014Fixed quantity entereddecimal153QUAN((0))YesMBFXXX
166MBF015Fixed quantity entereddecimal153QUAN((0))YesMBFXXX
167MBF016Fixed quantity entereddecimal153QUAN((0))YesMBFXXX
168LEDNRLedger for Controlling objectsnvarchar20CHAR(N' ')YesLEDNR Allow NULL? 
169OBJNRObject numbernvarchar220CHAR(N' ')YesONR00J_OBJNR Allow NULL? 
170GJAHRFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
171WRTTPValue Typenvarchar20CHAR(N' ')YesCO_WRTTP Allow NULL? 
172VERSNVersionnvarchar30CHAR(N' ')Yes*VERSN Allow NULL? 
173KSTARCost Elementnvarchar100CHAR(N' ')YesCSKAKSTAR Allow NULL? 
174HRKFTCO key subnumbernvarchar140CHAR(N' ')Yes*CO_SUBKEY Allow NULL? 
175VRGNGCO Business Transactionnvarchar40CHAR(N' ')Yes*CO_VORGANG Allow NULL? 
176PAROBPartner Objectnvarchar220CHAR(N' ')YesONR00PAROB Allow NULL? 
177PAROB1Partner object (always filled)nvarchar220CHAR(N' ')YesONR00PAROB1 Allow NULL? 
178USPOBSource Object (Cost Center/Activity Type)nvarchar220CHAR(N' ')YesONR00USPOB Allow NULL? 
179VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')YesT880RASSC Allow NULL? 
180PARGBTrading partner's business areanvarchar40CHAR(N' ')YesTGSBPARGB Allow NULL? 
181BEKNZDebit/credit indicatorchar10CHAR(N' ')YesBEKNZ Allow NULL? 
182TWAERTransaction Currencynvarchar50CUKY(N' ')YesTCURCTWAER Allow NULL? 
183MEINHUnit of Measurenvarchar30UNIT(N' ')YesT006CO_MEINH Allow NULL? 
184MEINBPosted Unit of Measurenvarchar30UNIT(N' ')YesT006MEINB Allow NULL? 
185SGTXTSegment textnvarchar500CHAR(N' ')YesCO_SGTXT Allow NULL? 
186REFBZPosting row of reference documentnvarchar30NUMC(N'000')YesCO_REFBZ Allow NULL? 
187ZLENRDocument Item Numbernvarchar30NUMC(N'000')YesDZLENR Allow NULL? 
188BW_REFBZPosting Row in Operative Versionnvarchar30NUMC(N'000')YesBW_REFBZ Allow NULL? 
189BELTPDebit typechar10NUMC(N'0')YesBP_INOUT Allow NULL? 
190TIMESTMPTime created (Greenwich Meantime)decimal160DEC((0))YesRKE_HZSTMP
191PAOBJNRProfitability Segment Number (CO-PA)nvarchar100NUMC(N'0000000000')YesRKEOBJNR Allow NULL? 
192FKBERFunctional Areanvarchar160CHAR(N' ')Yes*FKBER Allow NULL? 
193PFKBERPartner Functional Areanvarchar160CHAR(N' ')Yes*SFKBER Allow NULL? 
194GEBERFundnvarchar100CHAR(N' ')Yes*FM_FUND Allow NULL? 
195PGEBERPartner Fundnvarchar100CHAR(N' ')Yes*FM_PFUND Allow NULL? 
196GRANT_NBRGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
197PGRANT_NBRPartner Grantnvarchar200CHAR(N' ')YesGM_GRANT_PARTNER Allow NULL? 
198SEGMENTSegment for Segmental Reportingnvarchar100CHAR(N' ')YesFAGL_SEGMFB_SEGMENT Allow NULL? 
199PSEGMENTPartner Segment for Segmental Reportingnvarchar100CHAR(N' ')YesFAGL_SEGMFB_PSEGMENT Allow NULL? 
200BUDGET_PDFM: Budget Periodnvarchar100CHAR(N' ')Yes*FM_BUDGET_PERIOD Allow NULL? 
201PBUDGET_PDFM: Partner Budget Periodnvarchar100CHAR(N' ')Yes*FM_PBUDGET_PERIOD Allow NULL? 
NamePrimaryUniqueTypeColumns
CECOEJ~0YesYesCLUSTEREDPERBL, BUZEI, BELNR, KOKRS, MANDT