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

Home | ERP 6.0  | FOPCAISREPORT
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

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy