CRMT_COMP_LO SAP (Search Result for Complaints) Structure details

Dictionary Type: Structure
Description: Search Result for Complaints




ABAP Code to SELECT data from CRMT_COMP_LO
Related tables to CRMT_COMP_LO
Access table CRMT_COMP_LO




Structure field list including key, data, relationships and ABAP select examples

CRMT_COMP_LO 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 "Search Result for Complaints" 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_COMP_LO TYPE CRMT_COMP_LO.

The CRMT_COMP_LO table consists of various fields, each holding specific information or linking keys about Search Result for Complaints data available in SAP. These include OBJECT_ID (Transaction ID), PROCESS_TYPE (Business Transaction Type), TEMPLATE_TYPE (CRM Transaction: Template Type), 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_COMP_LO 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_IDTransaction ID CRMT_OBJECT_IDCHAR10ALPHACRM_OBJECT_IDCRM_OBJECT_IDCRM_ORDER_OBJECT_ID
PROCESS_TYPEBusiness Transaction Type CRMT_PROCESS_TYPECHAR4Assigned to domainCRM_PROCESS_TYPECRM_PROCESS_TYPECRM_PROCESS_TYPE
TEMPLATE_TYPECRM Transaction: Template Type CRMT_TEMPLATE_TYPECHAR1CRM_TEMPLATE_TYPECRM_TEMPLATE_TYPE_SH_WO_BLANK
DESCRIPTIONTransaction Description CRMT_PROCESS_DESCRIPTIONCHAR40CRM_PROCESS_DESCRIPTION
POSTING_DATEPosting Date for a Business Transaction CRMT_POSTING_DATEDATS8
CHANGED_ATChanged On (Output in User Time Zone) CRMT_CHANGED_AT_USRDEC15TSTLCCRM_TSTMP
CREATED_ATCreated On (Output in User Time Zone) CRMT_CREATED_AT_USRDEC15TSTLCCRM_TSTMP
CHANGED_AT_DATEDate on Which Transaction Was Last Changed CRMT_CHANGED_AT_DATEDATS8SYDATS
CREATED_AT_DATETransaction Was Created on This Date CRMT_CREATED_AT_DATEDATS8SYDATS
CONCATSTATSystem status line J_STEXTCHAR40TEXT40
CONCATSTATUSERUser Status CRMT_REPORT_USERSTATUSCHAR40TEXT40
PROCESS_TYPE_TXTText Description for Transaction Category CRMT_REPORT_PROCESS_TYPE_TXTCHAR60DDTEXT
CREATED_BYUser that Created the Transaction CRMT_CREATED_BYCHAR12UNAMEUSER_ADDR
KURZTEXTCode Group Short Text QKTEXTGRCDCHAR80CHAR80S
ACT_TEXTCode Group Short Text QKTEXTGRCDCHAR80CHAR80S
NET_VALUE_MANTotal Expected Net Value Products in Document Currency CRMT_NET_VALUE_MANCURR15(2) WERTV8
SALES_EMPLOYEEEmployee CRMT_SALES_EMPLOYEECHAR10Assigned to domainALPHABU_PARTNER
PERSON_RESPEmployee Responsible CRMT_PERSON_RESPCHAR10Assigned to domainALPHABU_PARTNER
CONTACT_PERSONCustomer Contact Person CRMT_CONTACT_PERSONCHAR10Assigned to domainALPHABU_PARTNER
SALESPARTNERSales Partners CRMT_SALESPARTNERCHAR10Assigned to domainALPHABU_PARTNER
SALES_EMPLOYEE_LISTSales Representative CRMT_SALES_EMPLOYEE_LISTCHAR80TEXT80
PERSON_RESP_LISTEmployee Responsible CRMT_PERSON_RESP_LISTCHAR80TEXT80
CONTACT_PERSON_LISTContact Person CRMT_CONTACT_PERSON_LISTCHAR80TEXT80
OBJECT_TYPE_TXTObject text for language-dependent table SAEOBJTEXTCHAR40SADC40
FROMStart Date CRMT_DATES_START_DATEDATS8DATUM
TOEnd Date CRMT_DATES_END_DATEDATS8DATS
FROM_TIMEFrom CRMT_BSP_TIME_HHMM_FROMTIMS6CRM_BSP_TIME_HHMM
TO_TIMETo CRMT_BSP_TIME_HHMM_TOTIMS6CRM_BSP_TIME_HHMM
OBJECT_TYPEObject Type SWO_OBJTYPCHAR10Assigned to domainOJ_NAMEOBJ
VALID_FROMStart Date CRMT_DATES_START_DATEDATS8DATUM
VALID_TOEnd Date CRMT_DATES_END_DATEDATS8DATS
VALID_FROM_TIMEFrom CRMT_BSP_TIME_HHMM_FROMTIMS6CRM_BSP_TIME_HHMM
VALID_TO_TIMETo CRMT_BSP_TIME_HHMM_TOTIMS6CRM_BSP_TIME_HHMM
SALES_ORGSales Organization CRMT_SALES_ORGCHAR14HROBJEC_14CRM_ORGMAN_SALES_ORG
SERVICE_ORGService Organization CRMT_SERVICE_ORGCHAR14HROBJEC_14CRM_ORGMAN_SERVICE_ORG
SALES_OFFICESales Office CRMT_SALES_OFFICECHAR14HROBJEC_14CRM_ORGMAN_SALES_OFFICE
SERVICE_ORG_RESPOrganizational Unit (Service) CRMT_SERVICE_ORG_RESPCHAR14HROBJEC_14
SALES_GROUPSales Group CRMT_SALES_GROUPCHAR14HROBJEC_14CRM_ORGMAN_SALES_GROUP
SALES_ORG_RESPOrganizational Unit (Sales) CRMT_SALES_ORG_RESPCHAR14HROBJEC_14
PURCH_ORGPurchasing Organization CRMT_PURCH_ORGCHAR14HROBJEC_14
PURCH_GROUPPurchasing Group CRMT_PURCH_GROUPCHAR14HROBJEC_14
PURCH_ORG_RESPOrganizational Unit (Purchasing) CRMT_PURCH_ORG_RESPCHAR14HROBJEC_14
DIS_CHANNELDistribution Channel CRMT_DISTRIBUTION_CHANNELCHAR2Assigned to domainCRM_DISTRIBUTION_CHANNELCRM_ORGMAN_DIS_CHANNEL
STATUSObject Status CRM_J_STATUSCHAR5CRM_J_STATUS
STATUS_SYSTEMObject Status CRM_J_STATUSCHAR5CRM_J_STATUS
USER_STAT_PROCStatus Profile CRM_J_STSMACHAR8Assigned to domainCRM_J_STSMA
PROCESSBusiness Transaction J_VORGANGCHAR4Assigned to domainJ_VORGANG
KINDObject Type CRMT_OBJECT_KINDCHAR1CRM_OBJECTKIND
TXT04Individual status of an object (short form) J_TXT04CHAR4TEXT4
TXT30Object status J_TXT30CHAR30TEXT30
COMPETITOR_LISTCompetitor CRMT_COMPETITOR_LISTCHAR80TEXT80
PROSPECT_LISTSales Prospect CRMT_PROSPECT_LISTCHAR80TEXT80
SALESPARTNER_LISTSales Partner CRMT_SALESPARTNER_LISTCHAR80TEXT80
ACTIVITY_PARTNER_LISTActivity Partner CRMT_ACTIVITY_PARTNER_LISTCHAR80TEXT80
SOLD_TO_PARTY_LISTSold-To Party CRMT_SOLD_TO_PART_LISTCHAR80TEXT80
SHIP_TO_PARTY_LISTShip-To Party: Name CRMT_SHIP_TO_PART_LISTCHAR80TEXT80
BILL_TO_PARTY_LISTBill-To Party: Name CRMT_BILL_TO_PART_LISTCHAR80TEXT80
PAYER_LISTPayer: Name CRMT_RP_PAYER_LISTCHAR80TEXT80
SERVICE_TEAM_LISTService Employee Group CRMT_SERVICE_GROUP_LISTCHAR80TEXT80
SERVICE_EMPLOYEE_LISTResponsible Service Employee CRMT_SERVICE_EMPLOYEE_LISTCHAR80TEXT80
SERVICE_TEAMService Team CRMT_SERVICE_TEAMCHAR10Assigned to domainALPHABU_PARTNER
SERVICE_EMPLOYEEExecuting Service Employee CRMT_SERVICE_EMPLOYEECHAR10Assigned to domainALPHABU_PARTNER
RESPONS_AT_PARTNERPerson Responsible at Partners (Channel Management) CRMT_RESPONSIBLE_AT_PARTNERCHAR10Assigned to domainALPHABU_PARTNER
RESPONS_AT_PARTNER_LISTPerson Responsible at Partners - Name (Channel Management) CRMT_RESPONS_AT_PARTNER_LISTCHAR80TEXT80
END_CUSTOMEREnd Customer (Channel Management) CRMT_END_CUSTOMERCHAR10Assigned to domainALPHABU_PARTNER
END_CUSTOMER_LISTEnd Customer Name (Channel Management) CRMT_END_CUSTOMER_LISTCHAR80TEXT80
STAT_QUOTLogical Variable CRMT_BOOLEANCHAR1CRM_BOOLEAN
STAT_OPENTransaction is Still Open CRMT_STATUS_OPENCHAR1CRM_BOOLEAN
STAT_PLANNEDStatus: Planned CRMT_STATUS_PLANNEDCHAR1CRM_BOOLEAN
PO_NUMBER_UCSold-to Party's External Reference No. (in Capital Letters) CRMT_PO_NUMBER_UCCHAR35CHAR35
NET_VALUETotal Net Value of Document in Document Currency CRMT_NET_VALUE_CUMCURR15(2) WERTV8
CURRENCYCurrency CRMT_CURRENCYCUKY5Assigned to domainWAERSFWS
SOLD_TO_PARTYSold-To Party CRMT_SOLD_TO_PARTCHAR10Assigned to domainALPHABU_PARTNER
SHIP_TO_PARTYShip-To Party CRMT_SHIP_TO_PARTCHAR10Assigned to domainALPHABU_PARTNER
BILL_TO_PARTYBill-To Party CRMT_BILL_TO_PARTCHAR10Assigned to domainALPHABU_PARTNER
PAYERPayer CRMT_RP_PAYERCHAR10Assigned to domainALPHABU_PARTNER
SOLD_FROMSalesperson ID CRMT_SOLD_FROM_PARTY_IDCHAR10Assigned to domainALPHABU_PARTNERBUPA
CUST_GROUP1Customer Group 1 CRMT_CUST_GROUP1CHAR3CRMC_CUSTGRP1CRM_CUST_GROUP1
CUST_GROUP2Customer Group 2 CRMT_CUST_GROUP2CHAR3CRMC_CUSTGRP2CRM_CUST_GROUP2
CUST_GROUP3Dishonour Reason CRMT_CUST_GROUP3CHAR3CRMC_CUSTGRP3CRM_CUST_GROUP3
CUST_GROUP4Customer Group 4 CRMT_CUST_GROUP4CHAR3CRMC_CUSTGRP4CRM_CUST_GROUP4
CUST_GROUP5Customer Group 5 CRMT_CUST_GROUP5CHAR3CRMC_CUSTGRP5CRM_CUST_GROUP5
PO_NUMBER_SOLDSold-To Party's External Reference Number CRMT_PO_NUMBER_SOLDCHAR35TEXT35
PO_DATE_SOLDReference Document Date CRMT_PO_DATE_SOLDDATS8DATUM
YOUR_REF_SOLDSold-to Party Reference CRMT_YOUR_REFERENCE_SOLDCHAR12TEXT12
PO_NUMBER_SHIPShip-To Party's External Reference Number CRMT_PO_NUMBER_SHIPCHAR35TEXT35
PO_DATE_SHIPShip-To Party's Reference Document Date CRMT_PO_DATE_SHIPDATS8DATUM
YOUR_REF_SHIPShip-To Party Reference CRMT_YOUR_REFERENCE_SHIPCHAR12TEXT12
USAGE_TYPEUsage Indicator CRMT_USAGECHAR3CRMC_USAGECRM_USAGE
SUBMISSIONCollective Number for Quotations CRMT_SUBMISSIONCHAR10TEXT10
REJECTIONCancellation Reason Code CRMT_REJECTION_CODECHAR2CRMC_REJECTIONCRM_REJECTION_CODE
PRIORITYActivity Priority CRMT_PRIORITYNUMC1Assigned to domainSC_PRIO
RMA_NRApproval Number - Return Delivery CRMT_RMACHAR20CRM_RMA

Key field Non-key field



How do I retrieve data from SAP structure CRMT_COMP_LO using ABAP code?

As CRMT_COMP_LO 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_COMP_LO as there is no data to select.

How to access SAP table CRMT_COMP_LO

Within an ECC or HANA version of SAP you can also view further information about CRMT_COMP_LO and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!