EVER_CRMQ SAP (ISU Contract CRM-Entry Queue) Table details

Dictionary Type: Table
Description: ISU Contract CRM-Entry Queue




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




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

EVER_CRMQ is a standard SAP Table which is used to store ISU Contract CRM-Entry Queue data and is available within R/3 SAP systems depending on the version and release level.

The EVER_CRMQ table consists of various fields, each holding specific information or linking keys about ISU Contract CRM-Entry Queue data available in SAP. These include CONTRACTPOS (Globally Unique Identifier), NUM (Four-digit number), VERTRAG (Contract), ANLAGE (Installation).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP EVER_CRMQ table 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
CONTRACTPOSGlobally Unique Identifier GUIDRAW16
NUMFour-digit number NUM4NUMC4NUM04
VERTRAGContract VERTRAGCHAR10Assigned to domainALPHAVERTRAGVTGEVER
ANLAGEInstallation ANLAGECHAR10Assigned to domainALPHAANLAGEANLEANL
ABDate from which time slice is valid ABZEITSCHDATS8DATUM
BISDate at Which a Time Slice Expires BISZEITSCHDATS8DATUM
CRM_PRODUCTCRM Product ESALES_CRM_PRODUCTCHAR40ESALES_CRM_PRODUCT
PRODIDNode to Describe Master Data Template EPD_PRODIDCHAR20Assigned to domainEPD_PRODIDEPD_PRODID
PRODUCT_GUIDGlobally Unique Identifier GUIDRAW16
CAMPAIGNIS-U: Marketing Campaign ISU_MARKETING_CAMPAIGNRAW16UCAMPISU_MARKETING_CAMPAIGNPRPM_CGPL_K
CAMPAIGN_TO_DATEIS-U: Individual To-Date Campaign Analysis ISU_CAMPAIGN_TO_DATEDATS8DATS
IN_PROGRESSIndicators KENNZXCHAR1KENNZX
GEN_ABDate from which time slice is valid ABZEITSCHDATS8DATUM
GEN_BISDate at Which a Time Slice Expires BISZEITSCHDATS8DATUM
BILLEDIndicators KENNZXCHAR1KENNZX
INT_UIInternal key for point of delivery INT_UICHAR22Assigned to domainINT_POD
PARTNER_GUIDBusiness Partner GUID BU_PARTNER_GUIDRAW16SYSUUID
VKONTO_GUIDBusiness Agreement GUID BUAG_GUIDRAW16SYSUUID
CRM_OBJECT_IDTransaction Number in CRM Document ECRMT_OBJECT_IDCHAR10ALPHAECRM_OBJECT_ID
CRM_OBJECT_POSItem Number in CRM Document ECRM_ITEM_NONUMC10ECRM_ITEM_NO
CANCREASON_NEWCancellation Reason (CRM) ECRMT_SRV_CANCEL_REASONCHAR4Assigned to domainQCODE
ERRORDATEDate DATUMDATS8DATUM
ERRORTIMETime in CHAR Format TIMECHAR6CHAR6
MDG_CREATEIndicators KENNZXCHAR1KENNZX
LOGHANDLEApplication Log: Log Handle BALLOGHNDLCHAR22SYSUUID_22
MDG_LOGGUID in 'CHAR' Format in Uppercase GUID_32CHAR32SYSUUID_C
CONTRACTHEADGlobally Unique Identifier GUIDRAW16
MO_CREATE Create Move-Out0
MO_DATECHANGE Change Move-Out Date0
MO_REVERSE Reverse move-out0
MI_CREATE Create Move-In (Using Master Data Generator)0
MI_DATECHANGE Change Move-In Date0
MI_REVERSE Reverse Move-In0
GENERATE Refresh Master Data Generator for Product0
FULL_GENERATION CRM Configuration Changed - Regenerate Contract Period0
MO_CREATEH Finish Time Slice (EVERH)0
MO_DATECHANGEH Postpone Time Slice (EVERH)0
MO_REVERSEH Open Time Slice (EVERH)0
MI_CREATEH Create Time Slice (EVERH) (Using Master Data Generator)0
MI_DATECHANGEH Postpone Time Slice (EVERH)0
MI_REVERSEH Delete Time Slice (EVERH)0
MI_NOCONTRGEN Do Not Generate Contract0
MI_INSERT Insert move-in/out0
MI_INSERT_REV Reverse Move-In/Out Insertion0
PC_ADJUSTBBP Product Change: Adjust Budget Billing Plan0
PC_PRINTDOC Product Change: Print Rate Change Letter0
CRMBUGCONFIRM Error for Manual Correction in CRM: User Must Confirm0
INFORMCONFIRM Backend User Information with Confirmation0
CRMDATAINCMPLT CRM Data Incomplete0
MO_BILLED Move-Out Period Already Billed0
MI_BILLED Move-In Was Already Billed0
MD_ORIGOBJKey for Srce.Object During Error Handling in IS-U Sales Repl ECRM_MD_ORIGOBJCHAR4ALPHAECRM_MD_ORIGOBJ
PRECOND_GUIDGlobally Unique Identifier GUIDRAW16
XREPLCNTLReplication Controls EXREPLCNTLCHAR1EXREPLCNTL
NODIndicators KENNZXCHAR1KENNZX
OUCONTRACTMaster Agreement for Individual Contract OUCONTRACTCHAR10Assigned to domainALPHAVERTRAGVTGEVER
INACTIVEIndicators KENNZXCHAR1KENNZX
IN_BCKGRDPRCIndicators KENNZXCHAR1KENNZX
NUM_RESTARTFour-digit number NUM4NUMC4NUM04
BBP_ADJUST Adjust Budget Billing Plan0
RTC_PRINT Print Confirmation of Rate Change0
RTC_FORMKEYApplication form FORMKEYCHAR30Assigned to domainFORMKEYFOM
BBP_ADJUST_FLGIndicators KENNZXCHAR1KENNZX
RTC_PRINT_FLGIndicators KENNZXCHAR1KENNZX
AMIO_PRDOCParked Document Number ECAMIO_PRDOCCHAR12ALPHAECAMIO_PRDOCECAMIOPR
OUCONTRACT_IGUID in 'RAW' format GUID_16RAW16SYSUUID
VBELNSales and Distribution Document Number VBELNCHAR10Assigned to domainALPHAVBELNAUN
POSNRItem number of the SD document POSNRNUMC6Assigned to domainPOSNR
PROPProperty EEWA_CLEAN_PROPCHAR12ALPHAEEWA_CLEAN_PROPECLEAN
SERVLOCLocation of Container SERVLOCCHAR30Assigned to domainTPLNRTPLNRGEPESERVLOC
ACT_SWTCMSGGUID in 'CHAR' format with upper-/lowercase (!) GUID_22CHAR22SYSUUID_22
DEACT_SWTCMSGGUID in 'CHAR' format with upper-/lowercase (!) GUID_22CHAR22SYSUUID_22
RELTOPREVVersion Number Component CHAR2CHAR2CHAR2
RELTONEXTVersion Number Component CHAR2CHAR2CHAR2
PREV_TS_GUIDGUID in 'RAW' format GUID_16RAW16SYSUUID
NEXT_TS_GUIDGUID in 'RAW' format GUID_16RAW16SYSUUID
DELETEDCheckbox in Reporting CHECKBOXCHAR1FUNC
BUNDLE_GUIDGUID in 'RAW' format GUID_16RAW16SYSUUID
PRODCH_BEGIndicators KENNZXCHAR1KENNZX
PRODCH_ENDIndicators KENNZXCHAR1KENNZX
VKONTOContract Account Number VKONT_KKCHAR12Assigned to domainALPHAVKONT_KKKTOFKKVKP_F4
PARTNERBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
CANCELEDIndicators KENNZXCHAR1KENNZX
ACT_SWTCDOCSwitch Document No. EIDESWTNUMCHAR20Assigned to domainEIDESWTNUM
DEACT_SWTCDOCSwitch Document No. EIDESWTNUMCHAR20Assigned to domainEIDESWTNUM
CRM_ITEM_DESCRContract Description ECRM_CONTRACT_DESCRCHAR40ECRM_CONTRACT_DESCR

Key field Non-key field



How do I retrieve data from SAP table EVER_CRMQ using ABAP code

The following ABAP code Example will allow you to do a basic selection on EVER_CRMQ to SELECT all data from the table
DATA: WA_EVER_CRMQ TYPE EVER_CRMQ.

SELECT SINGLE *
FROM EVER_CRMQ
INTO CORRESPONDING FIELDS OF WA_EVER_CRMQ
WHERE...

How to access SAP table EVER_CRMQ

Within an ECC or HANA version of SAP you can also view further information about EVER_CRMQ 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!