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
Financials :: Corporate Governance :: Management of Internal Controls
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0FOPCAISREPORT41AIS Reports for a Role (for MIC)Management of Internal Controls
SQL:  selectupdate insert create

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

SELECT MANDT, AIS_ID, TCODE, PARAM FROM FOPCAISREPORT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2AIS_IDID of the AIS Systemnvarchar160CHAR(N' ')NoFOPCAISFOPC_AIS_ID Allow NULL? 
3TCODEAIS Report (Transaction Code)nvarchar480CHAR(N' ')NoFOPC_AIS_TCODE Allow NULL? 
4PARAMParameters for transactionsnvarchar2540CHAR(N' ')YesTCDPARAM Allow NULL? 
NamePrimaryUniqueTypeColumns
FOPCAISREPORT~0YesYesCLUSTEREDTCODE, AIS_ID, MANDT