SMOLAYSQL is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of SMOLAYSQL in SAP.
- Table description : SDE: Data belonging to SQL statements
- Module : CRM-MSA
- Parent Module : CRM
- Package : SMO3
- Software Component : BBPCRM
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP SMOLAYSQL Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| SFALAYSQL | Global Unique Identifier | SMO_GUID | SMO_GUID |
| REC_PROP | Record Property | SMO_RECPRP | SMO_RECPRP |
| SFALAYITM | Global Unique Identifier | SMO_GUID | SMO_GUID |
| REPKEY | Key of the repository transaction | SMO_REPKEY | SMO_GUID |
| REPSEG | Segment in the Repository | SMO_REPSEG | SMO_TXT50 |
| LAYNAM | Layout Name | SMO_LAYNAM | SMO_TXT50 |
| .INCLUDE | Record Modification Fields for Mobile Sales/Service | ||
| ERFASS | Date of Creation. | SMO_CREATE | SMO_DATE |
| GEAEND | Date last Modified | SMO_MODIFY | SMO_DATE |
| BEARB | Record Edited by User Name | SMO_BEARB | SMO_BEARB |
| .INCLUDE | Communication Fields for Mobile Sales/Service | ||
| TR_USER | Transaction User | SMO_TR_USR | SMO_TR_USR |
| TR_ID | Transaction Identifier | SMO_TR_ID | SMO_TR_ID |
| TR_STATUS | Status of Transaction | SMO_TR_STS | SMO_TR_STS |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | TZNTSTMPS |
| DELETED | Mobile Sales Deleted | SMO_DELETD | SMO_DELETD |
| TR_ROOTID | Identifier of BDoc Root object | SMO_RTGUID | SMO_GUID |
| IMAGELEN | Size of the Image to be stored | SMO_IMAGLG | SMO_IMAGLG |
| SQLTRANS | Attachment Pointer (long text data) | SMO_LNGTXT | SMO_LNGTXT |
| EXTRA1 | Extra1 | SMO_LSEX1 | SMO_TEXT32 |
| EXTRA2 | Extra 2 | SMO_LSEX2 | SMO_TXT60 |
| EXTRA3 | Extra 3 | SMO_LSEX3 | SMO_TXT12 |
| NOTRANS | No transaction specified? | SM_NOTRNS | SMO_LOGICL |
| TRTYPE | Transaction Type | SM_TRTYPE | SMO_TXT4 |
| PICT | Identifier for Picture Handling | SM_ISPICT | SMO_CHAR2 |
| USEICON | Icon Mode or normal Mode? | SM_USICON | SMO_TEXT1 |
SMOLAYSQL related tables
| Table | Note |
|---|---|
| SMOLAYSQL | SDE: Data belonging to SQL statements |
| SMOLAYITM | SDE: data belonging to an item |
| /SDF/SQLHIST | SQL Monitor: Delta records for top SQL statements |
| SADL_V_DATATYPE | Different data types for testing SQL statements |
| AGSRBE_2SQLCOND | Conditions used in SQL statements |
| AGSRBE_2SQLJOIN | Joins used in SQL statements |
| AGSRBE_2SQLORG | OrgUnits used in SQL statements |
| AGSRBE_SQLCOND | Conditions used in SQL statements |
| AGSRBE_SQLJOIN | Joins used in SQL statements |
| AGSRBE_SQLORG | OrgUnits used in SQL statements |
| AMSSU | Global Performance Analysis: Trace Summary SQL Statements |
| DB6_OPTPROFILE | Optimizer Profiles for SQL Statements |
| IUUC_DD_SYNC_SQL | System synchronization: SQL-statements to adjust DB object |
| ORA_SQLC_STMT | Table with statements used by the SQL Command Editor |
| SYSTABSTMT | Contains SQL Statements for Change of Nametab |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP