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 :: Product Cost Controlling :: Cost Object
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0COSB1612CO Object: Total Variances/Results AnalysesCost Object
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, ABKAT, KSTAR, HRKFT, VRGNG, PAROB, BEKNZ, AWKUS, TWAER, PERBL, 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, FTG001, FTG002, FTG003, FTG004, FTG005, FTG006, FTG007, FTG008, FTG009, FTG010, FTG011, FTG012, FTG013, FTG014, FTG015, FTG016, FOG001, FOG002, FOG003, FOG004, FOG005, FOG006, FOG007, FOG008, FOG009, FOG010, FOG011, FOG012, FOG013, FOG014, FOG015, FOG016, FKG001, FKG002, FKG003, FKG004, FKG005, FKG006, FKG007, FKG008, FKG009, FKG010, FKG011, FKG012, FKG013, FKG014, FKG015, FKG016, FKF001, FKF002, FKF003, FKF004, FKF005, FKF006, FKF007, FKF008, FKF009, FKF010, FKF011, FKF012, FKF013, FKF014, FKF015, FKF016, ZLNID, MEINH, MEG001, MEG002, MEG003, MEG004, MEG005, MEG006, MEG007, MEG008, MEG009, MEG010, MEG011, MEG012, MEG013, MEG014, MEG015, MEG016 FROM COSB
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' ')NoTKVSVERSN Allow NULL? 
7ABKATCategory for Variance/Results Analysisnvarchar20NUMC(N'00')NoABKAT Allow NULL? 
8KSTARCost Elementnvarchar100CHAR(N' ')NoCSKAKSTAR Allow NULL? 
9HRKFTCO key subnumbernvarchar140CHAR(N' ')NoCOKEYCO_SUBKEY Allow NULL? 
10VRGNGCO Business Transactionnvarchar40CHAR(N' ')NoTJ01CO_VORGANG Allow NULL? 
11PAROBPartner Objectnvarchar220CHAR(N' ')NoONR00PAROB Allow NULL? 
12BEKNZDebit/credit indicatorchar10CHAR(N' ')NoBEKNZ Allow NULL? 
13AWKUSVariances: Cost Overrun/Underrunchar10CHAR(N' ')NoAWKUS Allow NULL? 
14TWAERTransaction Currencynvarchar50CUKY(N' ')NoTCURCTWAER Allow NULL? 
15PERBLPeriod blocknvarchar30NUMC(N'000')NoPERBL Allow NULL? 
16WTG001Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
17WTG002Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
18WTG003Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
19WTG004Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
20WTG005Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
21WTG006Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
22WTG007Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
23WTG008Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
24WTG009Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
25WTG010Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
26WTG011Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
27WTG012Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
28WTG013Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
29WTG014Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
30WTG015Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
31WTG016Total Value in Transaction Currencydecimal152CURR((0))YesWTGXXX
32WOG001Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
33WOG002Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
34WOG003Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
35WOG004Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
36WOG005Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
37WOG006Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
38WOG007Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
39WOG008Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
40WOG009Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
41WOG010Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
42WOG011Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
43WOG012Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
44WOG013Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
45WOG014Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
46WOG015Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
47WOG016Total Value in Object Currencydecimal152CURR((0))YesWOGXXX
48WKG001Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
49WKG002Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
50WKG003Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
51WKG004Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
52WKG005Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
53WKG006Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
54WKG007Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
55WKG008Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
56WKG009Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
57WKG010Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
58WKG011Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
59WKG012Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
60WKG013Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
61WKG014Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
62WKG015Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
63WKG016Total Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
64WKF001Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
65WKF002Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
66WKF003Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
67WKF004Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
68WKF005Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
69WKF006Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
70WKF007Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
71WKF008Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
72WKF009Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
73WKF010Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
74WKF011Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
75WKF012Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
76WKF013Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
77WKF014Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
78WKF015Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
79WKF016Fixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
80FTG001Total Foreign Value in Transaction Currencydecimal152CURR((0))YesFTGXXX
81FTG002Total Foreign Value in Transaction Currencydecimal152CURR((0))YesFTGXXX
82FTG003Total Foreign Value in Transaction Currencydecimal152CURR((0))YesFTGXXX
83FTG004Total Foreign Value in Transaction Currencydecimal152CURR((0))YesFTGXXX
84FTG005Total Foreign Value in Transaction Currencydecimal152CURR((0))YesFTGXXX
85FTG006Total Foreign Value in Transaction Currencydecimal152CURR((0))YesFTGXXX
86FTG007Total Foreign Value in Transaction Currencydecimal152CURR((0))YesFTGXXX
87FTG008Total Foreign Value in Transaction Currencydecimal152CURR((0))YesFTGXXX
88FTG009Total Foreign Value in Transaction Currencydecimal152CURR((0))YesFTGXXX
89FTG010Total Foreign Value in Transaction Currencydecimal152CURR((0))YesFTGXXX
90FTG011Total Foreign Value in Transaction Currencydecimal152CURR((0))YesFTGXXX
91FTG012Total Foreign Value in Transaction Currencydecimal152CURR((0))YesFTGXXX
92FTG013Total Foreign Value in Transaction Currencydecimal152CURR((0))YesFTGXXX
93FTG014Total Foreign Value in Transaction Currencydecimal152CURR((0))YesFTGXXX
94FTG015Total Foreign Value in Transaction Currencydecimal152CURR((0))YesFTGXXX
95FTG016Total Foreign Value in Transaction Currencydecimal152CURR((0))YesFTGXXX
96FOG001Total Foreign Value in Object Currencydecimal152CURR((0))YesFOGXXX
97FOG002Total Foreign Value in Object Currencydecimal152CURR((0))YesFOGXXX
98FOG003Total Foreign Value in Object Currencydecimal152CURR((0))YesFOGXXX
99FOG004Total Foreign Value in Object Currencydecimal152CURR((0))YesFOGXXX
100FOG005Total Foreign Value in Object Currencydecimal152CURR((0))YesFOGXXX
101FOG006Total Foreign Value in Object Currencydecimal152CURR((0))YesFOGXXX
102FOG007Total Foreign Value in Object Currencydecimal152CURR((0))YesFOGXXX
103FOG008Total Foreign Value in Object Currencydecimal152CURR((0))YesFOGXXX
104FOG009Total Foreign Value in Object Currencydecimal152CURR((0))YesFOGXXX
105FOG010Total Foreign Value in Object Currencydecimal152CURR((0))YesFOGXXX
106FOG011Total Foreign Value in Object Currencydecimal152CURR((0))YesFOGXXX
107FOG012Total Foreign Value in Object Currencydecimal152CURR((0))YesFOGXXX
108FOG013Total Foreign Value in Object Currencydecimal152CURR((0))YesFOGXXX
109FOG014Total Foreign Value in Object Currencydecimal152CURR((0))YesFOGXXX
110FOG015Total Foreign Value in Object Currencydecimal152CURR((0))YesFOGXXX
111FOG016Total Foreign Value in Object Currencydecimal152CURR((0))YesFOGXXX
112FKG001Total Foreign Value in Controlling Area Currencydecimal152CURR((0))YesFKGXXX
113FKG002Total Foreign Value in Controlling Area Currencydecimal152CURR((0))YesFKGXXX
114FKG003Total Foreign Value in Controlling Area Currencydecimal152CURR((0))YesFKGXXX
115FKG004Total Foreign Value in Controlling Area Currencydecimal152CURR((0))YesFKGXXX
116FKG005Total Foreign Value in Controlling Area Currencydecimal152CURR((0))YesFKGXXX
117FKG006Total Foreign Value in Controlling Area Currencydecimal152CURR((0))YesFKGXXX
118FKG007Total Foreign Value in Controlling Area Currencydecimal152CURR((0))YesFKGXXX
119FKG008Total Foreign Value in Controlling Area Currencydecimal152CURR((0))YesFKGXXX
120FKG009Total Foreign Value in Controlling Area Currencydecimal152CURR((0))YesFKGXXX
121FKG010Total Foreign Value in Controlling Area Currencydecimal152CURR((0))YesFKGXXX
122FKG011Total Foreign Value in Controlling Area Currencydecimal152CURR((0))YesFKGXXX
123FKG012Total Foreign Value in Controlling Area Currencydecimal152CURR((0))YesFKGXXX
124FKG013Total Foreign Value in Controlling Area Currencydecimal152CURR((0))YesFKGXXX
125FKG014Total Foreign Value in Controlling Area Currencydecimal152CURR((0))YesFKGXXX
126FKG015Total Foreign Value in Controlling Area Currencydecimal152CURR((0))YesFKGXXX
127FKG016Total Foreign Value in Controlling Area Currencydecimal152CURR((0))YesFKGXXX
128FKF001Foreign Value, Fixed, in Controlling Area Currencydecimal152CURR((0))YesFKFXXX
129FKF002Foreign Value, Fixed, in Controlling Area Currencydecimal152CURR((0))YesFKFXXX
130FKF003Foreign Value, Fixed, in Controlling Area Currencydecimal152CURR((0))YesFKFXXX
131FKF004Foreign Value, Fixed, in Controlling Area Currencydecimal152CURR((0))YesFKFXXX
132FKF005Foreign Value, Fixed, in Controlling Area Currencydecimal152CURR((0))YesFKFXXX
133FKF006Foreign Value, Fixed, in Controlling Area Currencydecimal152CURR((0))YesFKFXXX
134FKF007Foreign Value, Fixed, in Controlling Area Currencydecimal152CURR((0))YesFKFXXX
135FKF008Foreign Value, Fixed, in Controlling Area Currencydecimal152CURR((0))YesFKFXXX
136FKF009Foreign Value, Fixed, in Controlling Area Currencydecimal152CURR((0))YesFKFXXX
137FKF010Foreign Value, Fixed, in Controlling Area Currencydecimal152CURR((0))YesFKFXXX
138FKF011Foreign Value, Fixed, in Controlling Area Currencydecimal152CURR((0))YesFKFXXX
139FKF012Foreign Value, Fixed, in Controlling Area Currencydecimal152CURR((0))YesFKFXXX
140FKF013Foreign Value, Fixed, in Controlling Area Currencydecimal152CURR((0))YesFKFXXX
141FKF014Foreign Value, Fixed, in Controlling Area Currencydecimal152CURR((0))YesFKFXXX
142FKF015Foreign Value, Fixed, in Controlling Area Currencydecimal152CURR((0))YesFKFXXX
143FKF016Foreign Value, Fixed, in Controlling Area Currencydecimal152CURR((0))YesFKFXXX
144ZLNIDLine IDnvarchar30CHAR(N' ')Yes*DZEILEN_ID Allow NULL? 
145MEINHUnit of Measurenvarchar30UNIT(N' ')Yes*CO_MEINH Allow NULL? 
146MEG001Total Quantitydecimal153QUAN((0))YesMEGXXX
147MEG002Total Quantitydecimal153QUAN((0))YesMEGXXX
148MEG003Total Quantitydecimal153QUAN((0))YesMEGXXX
149MEG004Total Quantitydecimal153QUAN((0))YesMEGXXX
150MEG005Total Quantitydecimal153QUAN((0))YesMEGXXX
151MEG006Total Quantitydecimal153QUAN((0))YesMEGXXX
152MEG007Total Quantitydecimal153QUAN((0))YesMEGXXX
153MEG008Total Quantitydecimal153QUAN((0))YesMEGXXX
154MEG009Total Quantitydecimal153QUAN((0))YesMEGXXX
155MEG010Total Quantitydecimal153QUAN((0))YesMEGXXX
156MEG011Total Quantitydecimal153QUAN((0))YesMEGXXX
157MEG012Total Quantitydecimal153QUAN((0))YesMEGXXX
158MEG013Total Quantitydecimal153QUAN((0))YesMEGXXX
159MEG014Total Quantitydecimal153QUAN((0))YesMEGXXX
160MEG015Total Quantitydecimal153QUAN((0))YesMEGXXX
161MEG016Total Quantitydecimal153QUAN((0))YesMEGXXX
NamePrimaryUniqueTypeColumns
COSB~0YesYesCLUSTEREDPERBL, TWAER, AWKUS, BEKNZ, PAROB, VRGNG, HRKFT, KSTAR, ABKAT, VERSN, WRTTP, GJAHR, OBJNR, LEDNR, MANDT
COSB~1NoNoNONCLUSTEREDVRGNG, GJAHR, WRTTP, VERSN, LEDNR, MANDT, OBJNR