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

B1 9.2: Top 10 requests

TableColumnsDescription

B1 8.8: Top 10 requests

TableColumnsDescription
Public Sector Management :: Funds Management :: Budgeting and Availability Control
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0FMCDRBE111Revenues Increasing Budget Government of Canada (Receiver)Budgeting and Availability Control
SQL:  selectupdate insert create

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

SELECT MANDT, GJAHR, FIKRS, FONDS, FISTL, FIPEX, E_FONDS, E_FISTL, E_FIPEX, E_PROZENT, EV_PROZENT FROM FMCDRBE
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoFMCDRBMANDT Allow NULL? 
2GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoFMCDRBGJAHR Allow NULL? 
3FIKRSFinancial Management Areanvarchar40CHAR(N' ')NoFMCDRBFIKRS Allow NULL? 
4FONDSSender fundnvarchar100CHAR(N' ')No*FM_SFONDS Allow NULL? 
5FISTLSender funds centernvarchar160CHAR(N' ')NoFMCDRBFM_SFICTR Allow NULL? 
6FIPEXCommitment item (No longer in use -> FM_FIPEX)nvarchar240CHAR(N' ')NoFIPEX Allow NULL? 
7E_FONDSReceiver fundnvarchar100CHAR(N' ')No*FM_EFONDS Allow NULL? 
8E_FISTLReceiver funds centernvarchar160CHAR(N' ')No*FM_EFICTR Allow NULL? 
9E_FIPEXCommitment item (No longer in use -> FM_FIPEX)nvarchar240CHAR(N' ')NoFIPEX Allow NULL? 
10E_PROZENT% of a Revenue Allotted to Expenditure FM Account Assignmentdecimal52DEC((0))YesFM_ERHPROZ
11EV_PROZENT% of a Revenue Allotted to Expenditure FM Account Assignmentdecimal52DEC((0))YesFM_ERHPROZ
NamePrimaryUniqueTypeColumns
FMCDRBE~0YesYesCLUSTEREDE_FIPEX, E_FISTL, E_FONDS, FIPEX, FISTL, FONDS, FIKRS, GJAHR, MANDT