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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Production Planning and Control :: Production Planning for Process Industries :: Basic Data :: Master Recipe
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0KALC171Material Quantity Calculation - FormulasMaster Recipe
SQL:  selectupdate insert create

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

SELECT MANDT, APPLID, FORM_KEY, VERSION, LINE, ROW_POS, ROW_ID, ROW_TEXT, COL_POS, COL_ID, COL_TEXT, COL_UOM, VALUE, FORMULA, FORM_IND, FORM_ORD, VALUE_FLT FROM KALC
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2APPLIDApplication of material quantity calculationnvarchar20CHAR(N' ')NoCALC_APPL Allow NULL? 
3FORM_KEYFormula key of material quantity calculationnvarchar300CHAR(N' ')NoCALC_KEY Allow NULL? 
4VERSIONVersion number of formulasnvarchar120CHAR(N' ')No*CALC_VERS Allow NULL? 
5LINEItem of an objectnvarchar40NUMC(N'0000')NoCALC_LINE Allow NULL? 
6ROW_POSLine item numbernvarchar40NUMC(N'0000')NoCALC_POS Allow NULL? 
7ROW_IDObject IDnvarchar300CHAR(N' ')NoCALC_OBJID Allow NULL? 
8ROW_TEXTObject descriptionnvarchar300CHAR(N' ')NoCALC_TEXT Allow NULL? 
9COL_POSLine item numbernvarchar40NUMC(N'0000')NoCALC_POS Allow NULL? 
10COL_IDObject IDnvarchar300CHAR(N' ')NoCALC_OBJID Allow NULL? 
11COL_TEXTObject descriptionnvarchar300CHAR(N' ')NoCALC_TEXT Allow NULL? 
12COL_UOMUnit of measure in material quantity calculationnvarchar30UNIT(N' ')NoCALC_UOM Allow NULL? 
13VALUEQuantity calculation value (no longer used)decimal124DEC((0))NoCALC_VAL2
14FORMULAFormula in material quantity calculationnvarchar2500CHAR(N' ')NoCALC_FORM Allow NULL? 
15FORM_INDFormula indicatorchar10CHAR(N' ')NoCALC_IND Allow NULL? 
16FORM_ORDLine number in material quantity calculationnvarchar30NUMC(N'000')YesCALC_SEQ Allow NULL? 
17VALUE_FLTField of type FLTPfloat1516FLTP((0))YesFLOAT
NamePrimaryUniqueTypeColumns
KALC~0YesYesCLUSTEREDLINE, VERSION, FORM_KEY, APPLID, MANDT