EVER_CRMQ SAP (ISU Contract CRM-Entry Queue) Table details
Dictionary Type: Table
Description: ISU Contract CRM-Entry Queue
Description: ISU Contract CRM-Entry Queue
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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
CONTRACTPOS | Globally Unique Identifier | GUID | RAW | 16 | |||||
NUM | Four-digit number | NUM4 | NUMC | 4 | NUM04 | ||||
VERTRAG | Contract | VERTRAG | CHAR | 10 | Assigned to domain | ALPHA | VERTRAG | VTG | EVER |
ANLAGE | Installation | ANLAGE | CHAR | 10 | Assigned to domain | ALPHA | ANLAGE | ANL | EANL |
AB | Date from which time slice is valid | ABZEITSCH | DATS | 8 | DATUM | ||||
BIS | Date at Which a Time Slice Expires | BISZEITSCH | DATS | 8 | DATUM | ||||
CRM_PRODUCT | CRM Product | ESALES_CRM_PRODUCT | CHAR | 40 | ESALES_CRM_PRODUCT | ||||
PRODID | Node to Describe Master Data Template | EPD_PRODID | CHAR | 20 | Assigned to domain | EPD_PRODID | EPD_PRODID | ||
PRODUCT_GUID | Globally Unique Identifier | GUID | RAW | 16 | |||||
CAMPAIGN | IS-U: Marketing Campaign | ISU_MARKETING_CAMPAIGN | RAW | 16 | UCAMP | ISU_MARKETING_CAMPAIGN | PRPM_CGPL_K | ||
CAMPAIGN_TO_DATE | IS-U: Individual To-Date Campaign Analysis | ISU_CAMPAIGN_TO_DATE | DATS | 8 | DATS | ||||
IN_PROGRESS | Indicators | KENNZX | CHAR | 1 | KENNZX | ||||
GEN_AB | Date from which time slice is valid | ABZEITSCH | DATS | 8 | DATUM | ||||
GEN_BIS | Date at Which a Time Slice Expires | BISZEITSCH | DATS | 8 | DATUM | ||||
BILLED | Indicators | KENNZX | CHAR | 1 | KENNZX | ||||
INT_UI | Internal key for point of delivery | INT_UI | CHAR | 22 | Assigned to domain | INT_POD | |||
PARTNER_GUID | Business Partner GUID | BU_PARTNER_GUID | RAW | 16 | SYSUUID | ||||
VKONTO_GUID | Business Agreement GUID | BUAG_GUID | RAW | 16 | SYSUUID | ||||
CRM_OBJECT_ID | Transaction Number in CRM Document | ECRMT_OBJECT_ID | CHAR | 10 | ALPHA | ECRM_OBJECT_ID | |||
CRM_OBJECT_POS | Item Number in CRM Document | ECRM_ITEM_NO | NUMC | 10 | ECRM_ITEM_NO | ||||
CANCREASON_NEW | Cancellation Reason (CRM) | ECRMT_SRV_CANCEL_REASON | CHAR | 4 | Assigned to domain | QCODE | |||
ERRORDATE | Date | DATUM | DATS | 8 | DATUM | ||||
ERRORTIME | Time in CHAR Format | TIME | CHAR | 6 | CHAR6 | ||||
MDG_CREATE | Indicators | KENNZX | CHAR | 1 | KENNZX | ||||
LOGHANDLE | Application Log: Log Handle | BALLOGHNDL | CHAR | 22 | SYSUUID_22 | ||||
MDG_LOG | GUID in 'CHAR' Format in Uppercase | GUID_32 | CHAR | 32 | SYSUUID_C | ||||
CONTRACTHEAD | Globally Unique Identifier | GUID | RAW | 16 | |||||
MO_CREATE | Create Move-Out | 0 | |||||||
MO_DATECHANGE | Change Move-Out Date | 0 | |||||||
MO_REVERSE | Reverse move-out | 0 | |||||||
MI_CREATE | Create Move-In (Using Master Data Generator) | 0 | |||||||
MI_DATECHANGE | Change Move-In Date | 0 | |||||||
MI_REVERSE | Reverse Move-In | 0 | |||||||
GENERATE | Refresh Master Data Generator for Product | 0 | |||||||
FULL_GENERATION | CRM Configuration Changed - Regenerate Contract Period | 0 | |||||||
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 Contract | 0 | |||||||
MI_INSERT | Insert move-in/out | 0 | |||||||
MI_INSERT_REV | Reverse Move-In/Out Insertion | 0 | |||||||
PC_ADJUSTBBP | Product Change: Adjust Budget Billing Plan | 0 | |||||||
PC_PRINTDOC | Product Change: Print Rate Change Letter | 0 | |||||||
CRMBUGCONFIRM | Error for Manual Correction in CRM: User Must Confirm | 0 | |||||||
INFORMCONFIRM | Backend User Information with Confirmation | 0 | |||||||
CRMDATAINCMPLT | CRM Data Incomplete | 0 | |||||||
MO_BILLED | Move-Out Period Already Billed | 0 | |||||||
MI_BILLED | Move-In Was Already Billed | 0 | |||||||
MD_ORIGOBJ | Key for Srce.Object During Error Handling in IS-U Sales Repl | ECRM_MD_ORIGOBJ | CHAR | 4 | ALPHA | ECRM_MD_ORIGOBJ | |||
PRECOND_GUID | Globally Unique Identifier | GUID | RAW | 16 | |||||
XREPLCNTL | Replication Controls | EXREPLCNTL | CHAR | 1 | EXREPLCNTL | ||||
NOD | Indicators | KENNZX | CHAR | 1 | KENNZX | ||||
OUCONTRACT | Master Agreement for Individual Contract | OUCONTRACT | CHAR | 10 | Assigned to domain | ALPHA | VERTRAG | VTG | EVER |
INACTIVE | Indicators | KENNZX | CHAR | 1 | KENNZX | ||||
IN_BCKGRDPRC | Indicators | KENNZX | CHAR | 1 | KENNZX | ||||
NUM_RESTART | Four-digit number | NUM4 | NUMC | 4 | NUM04 | ||||
BBP_ADJUST | Adjust Budget Billing Plan | 0 | |||||||
RTC_PRINT | Print Confirmation of Rate Change | 0 | |||||||
RTC_FORMKEY | Application form | FORMKEY | CHAR | 30 | Assigned to domain | FORMKEY | FOM | ||
BBP_ADJUST_FLG | Indicators | KENNZX | CHAR | 1 | KENNZX | ||||
RTC_PRINT_FLG | Indicators | KENNZX | CHAR | 1 | KENNZX | ||||
AMIO_PRDOC | Parked Document Number | ECAMIO_PRDOC | CHAR | 12 | ALPHA | ECAMIO_PRDOC | ECAMIOPR | ||
OUCONTRACT_I | GUID in 'RAW' format | GUID_16 | RAW | 16 | SYSUUID | ||||
VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
POSNR | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
PROP | Property | EEWA_CLEAN_PROP | CHAR | 12 | ALPHA | EEWA_CLEAN_PROP | ECLEAN | ||
SERVLOC | Location of Container | SERVLOC | CHAR | 30 | Assigned to domain | TPLNR | TPLNR | GEP | ESERVLOC |
ACT_SWTCMSG | GUID in 'CHAR' format with upper-/lowercase (!) | GUID_22 | CHAR | 22 | SYSUUID_22 | ||||
DEACT_SWTCMSG | GUID in 'CHAR' format with upper-/lowercase (!) | GUID_22 | CHAR | 22 | SYSUUID_22 | ||||
RELTOPREV | Version Number Component | CHAR2 | CHAR | 2 | CHAR2 | ||||
RELTONEXT | Version Number Component | CHAR2 | CHAR | 2 | CHAR2 | ||||
PREV_TS_GUID | GUID in 'RAW' format | GUID_16 | RAW | 16 | SYSUUID | ||||
NEXT_TS_GUID | GUID in 'RAW' format | GUID_16 | RAW | 16 | SYSUUID | ||||
DELETED | Checkbox in Reporting | CHECKBOX | CHAR | 1 | FUNC | ||||
BUNDLE_GUID | GUID in 'RAW' format | GUID_16 | RAW | 16 | SYSUUID | ||||
PRODCH_BEG | Indicators | KENNZX | CHAR | 1 | KENNZX | ||||
PRODCH_END | Indicators | KENNZX | CHAR | 1 | KENNZX | ||||
VKONTO | Contract Account Number | VKONT_KK | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | KTO | FKKVKP_F4 |
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
CANCELED | Indicators | KENNZX | CHAR | 1 | KENNZX | ||||
ACT_SWTCDOC | Switch Document No. | EIDESWTNUM | CHAR | 20 | Assigned to domain | EIDESWTNUM | |||
DEACT_SWTCDOC | Switch Document No. | EIDESWTNUM | CHAR | 20 | Assigned to domain | EIDESWTNUM | |||
CRM_ITEM_DESCR | Contract Description | ECRM_CONTRACT_DESCR | CHAR | 40 | ECRM_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 tableDATA: 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 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