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
Industry Specific :: Bank Components :: Risk Analysis
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0JBRPHDEFBK71RM: Backup for Table JBRPHDEFRisk Analysis
SQL:  selectupdate insert create

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

SELECT MANDT, SICHTID, PHID, MERKMAL, VARIANTE, HIERTYPE, SORT FROM JBRPHDEFBK
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2SICHTIDView of an Analysis Structurenvarchar30CHAR(N' ')NoJBRSIMJBRSICHTID Allow NULL? 
3PHIDPortfolio Hierarchynvarchar30NUMC(N'000')NoJBRPHJBRPHID Allow NULL? 
4MERKMALCharacteristicnvarchar300CHAR(N' ')NoJBRSIMJBRMERKML Allow NULL? 
5VARIANTECharacteristics Hierarchynvarchar30CHAR(N' ')YesJBRMRKHIER Allow NULL? 
6HIERTYPECategory of Characteristic Hierarchychar10CHAR(N' ')YesJBRMHTYPE Allow NULL? 
7SORTSort Order of Characteristic Groupnvarchar30NUMC(N'000')YesJBRSORT Allow NULL? 
NamePrimaryUniqueTypeColumns
JBRPHDEFBK~0YesYesCLUSTEREDMERKMAL, PHID, SICHTID, MANDT