CRMT_ORDER_ALV SAP (CRM: Structure for Application Workplace - Orders) Structure details
Dictionary Type: Structure
Description: CRM: Structure for Application Workplace - Orders
Description: CRM: Structure for Application Workplace - Orders
ABAP Code to SELECT data from CRMT_ORDER_ALV
Related tables to CRMT_ORDER_ALV
Access table CRMT_ORDER_ALV
Related tables to CRMT_ORDER_ALV
Access table CRMT_ORDER_ALV
Structure field list including key, data, relationships and ABAP select examples
CRMT_ORDER_ALV is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "CRM: Structure for Application Workplace - Orders" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_CRMT_ORDER_ALV TYPE CRMT_ORDER_ALV.
The CRMT_ORDER_ALV table consists of various fields, each holding specific information or linking keys about CRM: Structure for Application Workplace - Orders data available in SAP. These include OBJECT_ID (Transaction Number), PROCESS_TYPE (Business Transaction Type), POSTING_DATE (Posting Date for a Business Transaction), DESCRIPTION (Transaction Description).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP CRMT_ORDER_ALV structure fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| OBJECT_ID | Transaction Number | CRMT_OBJECT_ID_DB | CHAR | 10 | ALPHA | CRM_OBJECT_ID | |||
| PROCESS_TYPE | Business Transaction Type | CRMT_PROCESS_TYPE_DB | CHAR | 4 | Assigned to domain | CRM_PROCESS_TYPE | |||
| POSTING_DATE | Posting Date for a Business Transaction | CRMT_POSTING_DATE | DATS | 8 | |||||
| DESCRIPTION | Transaction Description | CRMT_PROCESS_DESCRIPTION | CHAR | 40 | CRM_PROCESS_DESCRIPTION | ||||
| DESCR_LANGUAGE | Language Key of Description | CRMT_PROCESS_DESCRIPTION_LANGU | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
| LOGICAL_SYSTEM | Logical System | CRMT_LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
| CRM_RELEASE | SAP Release | SAPRELEASE | CHAR | 10 | CHAR10 | ||||
| SCENARIO | Scenario Identity | CRMT_SCENARIO | CHAR | 10 | CRM_SCENARIO | ||||
| TEMPLATE_TYPE | Template Type of CRM Transaction | CRMT_TEMPLATE_TYPE_DB | CHAR | 1 | CRM_TEMPLATE_TYPE | ||||
| CREATED_AT | Created At (Output in User Time Zone) | COMT_CREATED_AT_USR | DEC | 15 | TSTLC | COM_TSTMP | |||
| CREATED_BY | User that Created the Transaction | CRMT_CREATED_BY | CHAR | 12 | UNAME | USER_ADDR | |||
| CHANGED_AT | Changed At (Output in User Time Zone) | COMT_CHANGED_AT_USR | DEC | 15 | TSTLC | COM_TSTMP | |||
| CHANGED_BY | Transaction Last Changed By | CRMT_CHANGED_BY | CHAR | 12 | UNAME | ||||
| HEAD_CHANGED_AT | Time of Last Change to the Transaction | CRMT_CHANGED_AT | DEC | 15 | TSTPS | BCOS_TSTMP | |||
| ORDERADM_H_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
| .INCLU--AP | 0 | ||||||||
| INPUT_CHANNEL | Input channel | CRMT_INPUT_CHANNEL | CHAR | 3 | CRM_INPUT_CHANNEL | ||||
| OBJECT_TYPE | Business Trans. Cat. | CRMT_SUBOBJECT_CATEGORY_DB | CHAR | 10 | Assigned to domain | CRM_OJ_NAME_PROCESS | |||
| ARCHIVING_FLAG | Indicator Whether the Business Transaction Can Be Archived | CRMT_ARCHIVING_FLAG | CHAR | 1 | CRM_BOOLEAN | ||||
| DESCRIPTION_UC | Transaction Description (Upper Case) | CRMT_PROCESS_DESCRIPTION_UC | CHAR | 40 | CRM_PROCESS_DESCRIPTION_UC | ||||
| OBJECT_ID_OK | Indicator Whether Business Transaction Number is Correct | CRMT_OBJECT_ID_OK | CHAR | 1 | CRM_BOOLEAN | ||||
| VERIFY_DATE | Time Period of Last Archiving Attempt | CRMT_VERIFY_DATE | DEC | 15 | TSTPS | BCOS_TSTMP | |||
| CRM_CHANGED_AT | Time of Last Change in CRM Online | CRMT_ONLINE_CHANGED_AT | DEC | 15 | TSTPS | BCOS_TSTMP | |||
| CLIENT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW | 16 | SYSUUID | ||||
| CREATE_DATE | CRM Reporting: 'Created on' Date | CRMT_RPRTNG_CREATED_AT | DATS | 8 | CRM_RPRTNG_DATE | ||||
| FCT_DESCRIPTION | Partner Function: Long Text | CRMT_REPORT_FNKT_LONG | CHAR | 30 | TEXT30 | ||||
| FCT_SHORT_DESC | Partner Function: Short Text | CRMT_REPORT_FNKT_SHORT | CHAR | 4 | TEXT4 | ||||
| MAIN_BP_1 | Additional Business Partner | CRMT_RPRTNG_ADDPARTNER | CHAR | 35 | NAME | ||||
| MAIN_BP_1_NO | Partner Number | CRMT_PARTNER_NO | CHAR | 32 | CRM_PARTNER_NO | ||||
| MAIN_BP_1_FCT | Role of an Additional Business Partner for Display | CRMT_RPRTNG_ADDFUNCTION | CHAR | 8 | CHAR8 | ||||
| MAIN_BP_1_DESC | Partner Function: Long Text | CRMT_REPORT_FNKT_LONG | CHAR | 30 | TEXT30 | ||||
| MAIN_BP_1_DESC_S | Partner Function: Short Text | CRMT_REPORT_FNKT_SHORT | CHAR | 4 | TEXT4 | ||||
| MAIN_BP_1_NAMELIST | One-line short form of formatted address | AD_LINE_S | CHAR | 80 | CHAR80 | ||||
| MAIN_BP_2 | Additional Business Partner | CRMT_RPRTNG_ADDPARTNER | CHAR | 35 | NAME | ||||
| MAIN_BP_2_NO | Partner Number | CRMT_PARTNER_NO | CHAR | 32 | CRM_PARTNER_NO | ||||
| MAIN_BP_2_FCT | Role of an Additional Business Partner for Display | CRMT_RPRTNG_ADDFUNCTION | CHAR | 8 | CHAR8 | ||||
| MAIN_BP_2_DESC | Partner Function: Long Text | CRMT_REPORT_FNKT_LONG | CHAR | 30 | TEXT30 | ||||
| MAIN_BP_2_DESC_S | Partner Function: Short Text | CRMT_REPORT_FNKT_SHORT | CHAR | 4 | TEXT4 | ||||
| MAIN_BP_2_NAMELIST | One-line short form of formatted address | AD_LINE_S | CHAR | 80 | CHAR80 | ||||
| STAT | Object status | J_STATUS | CHAR | 5 | J_STATUS | ||||
| STATUS | Longform Status | CRMT_REPORT_STATUS_L | CHAR | 100 | CHAR100 | ||||
| PO_NUMBER_SOLD | Sold-To Party's External Reference Number | CRMT_PO_NUMBER_SOLD | CHAR | 35 | TEXT35 | ||||
| PO_NUMBER_UC | Sold-to Party's External Reference No. (in Capital Letters) | CRMT_PO_NUMBER_UC | CHAR | 35 | CHAR35 | ||||
| NET_VALUE | Total Net Value of Document in Document Currency | CRMT_NET_VALUE_CUM | CURR | 15(2) | WERTV8 | ||||
| CURRENCY | Currency | CRMT_CURRENCY | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
| HEADER | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW | 16 | SYSUUID |
| Key field | Non-key field |
How do I retrieve data from SAP structure CRMT_ORDER_ALV using ABAP code?
As CRMT_ORDER_ALV is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CRMT_ORDER_ALV as there is no data to select.How to access SAP table CRMT_ORDER_ALV
Within an ECC or HANA version of SAP you can also view further information about CRMT_ORDER_ALV and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects