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
Portfolio and Project Management :: Portfolio Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/RPM/FIN_GROUPS31Financial GroupsPortfolio Management
SQL:  selectupdate insert create

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

SELECT CLIENT, CATEGORY, GROUP_ID FROM /RPM/FIN_GROUPS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2CATEGORYFinancial Categorynvarchar150CHAR(N' ')No/RPM/FIN_CATG/RPM/TV_FIN_CATG Allow NULL? 
3GROUP_IDFinancial Groupnvarchar150CHAR(N' ')No/RPM/TV_FIN_GRP Allow NULL? 
NamePrimaryUniqueTypeColumns
/RPM/FIN_GROUPS~0YesYesCLUSTEREDGROUP_ID, CATEGORY, CLIENT