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
Payroll :: Payroll General Parts
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T53GC51Description of the Model for the net amountPayroll General Parts
SQL:  selectupdate insert create

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

SELECT MANDT, SPRSL, MOLGA, NEMOD, NETXT FROM T53GC
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2SPRSLLanguage Keychar10 Allow NULL? 
3MOLGACountry Groupingnvarchar20 Allow NULL? 
4NEMODCode for the net modelnvarchar60 Allow NULL? 
5NETXTDescription of the net modelnvarchar400 Allow NULL? 
NamePrimaryUniqueTypeColumns
T53GC~0YesYesCLUSTEREDNEMOD, MOLGA, SPRSL, MANDT