EVER_CRMQ - ISU Contract CRM-Entry Queue
ISU Contract CRM-Entry Queue information is stored in SAP table EVER_CRMQ.
It is part of development package EECRM_CONTRACT in software component IS-U-CS-CRM. This development package consists of objects that can be grouped under "Integration of CRM Contract".
It is part of development package EECRM_CONTRACT in software component IS-U-CS-CRM. This development package consists of objects that can be grouped under "Integration of CRM Contract".
Fields for table EVER_CRMQ
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | * |
| CONTRACTPOS | Globally Unique Identifier | X | GUID | RAW | 16 | |
| NUM | Four-digit number | X | NUM4 | NUMC | 8 | |
| VERTRAG | Contract | VERTRAG | CHAR | 20 | * | |
| ANLAGE | Installation | ANLAGE | CHAR | 20 | * | |
| AB | Date from which time slice is valid | ABZEITSCH | DATS | 16 | ||
| BIS | Date at Which a Time Slice Expires | BISZEITSCH | DATS | 16 | ||
| CRM_PRODUCT | CRM Product | ESALES_CRM_PRODUCT | CHAR | 80 | ||
| PRODID | Node to Describe Master Data Template | EPD_PRODID | CHAR | 40 | * | |
| PRODUCT_GUID | Globally Unique Identifier | GUID | RAW | 16 | ||
| CAMPAIGN | IS-U: Marketing Campaign | ISU_MARKETING_CAMPAIGN | RAW | 16 | ||
| CAMPAIGN_TO_DATE | IS-U: Individual To-Date Campaign Analysis | ISU_CAMPAIGN_TO_DATE | DATS | 16 | ||
| IN_PROGRESS | Indicators | KENNZX | CHAR | 2 | ||
| GEN_AB | Date from which time slice is valid | ABZEITSCH | DATS | 16 | ||
| GEN_BIS | Date at Which a Time Slice Expires | BISZEITSCH | DATS | 16 | ||
| BILLED | Indicators | KENNZX | CHAR | 2 | ||
| INT_UI | Internal key for point of delivery | INT_UI | CHAR | 44 | * | |
| PARTNER_GUID | Business Partner GUID | BU_PARTNER_GUID | RAW | 16 | ||
| VKONTO_GUID | Business Agreement GUID | BUAG_GUID | RAW | 16 | ||
| CRM_OBJECT_ID | Transaction Number in CRM Document | ECRMT_OBJECT_ID | CHAR | 20 | ||
| CRM_OBJECT_POS | Item Number in CRM Document | ECRM_ITEM_NO | NUMC | 20 | ||
| CANCREASON_NEW | Cancellation Reason (CRM) | ECRMT_SRV_CANCEL_REASON | CHAR | 8 | * | |
| ERRORDATE | Date | DATUM | DATS | 16 | ||
| ERRORTIME | Time in CHAR Format | TIME | CHAR | 12 | ||
| MDG_CREATE | Indicators | KENNZX | CHAR | 2 | ||
| LOGHANDLE | Application Log: Log Handle | BALLOGHNDL | CHAR | 44 | ||
| MDG_LOG | GUID in 'CHAR' Format in Uppercase | GUID_32 | CHAR | 64 | ||
| CONTRACTHEAD | Globally Unique Identifier | GUID | RAW | 16 | ||
| .INCLUDE | ECRMINBASICFUNC | 0 | ||||
| MO_CREATE | Create Move-Out | CHAR | 2 | |||
| MO_DATECHANGE | Change Move-Out Date | CHAR | 2 | |||
| MO_REVERSE | Reverse move-out | CHAR | 2 | |||
| MI_CREATE | Create Move-In (Using Master Data Generator) | CHAR | 2 | |||
| MI_DATECHANGE | Change Move-In Date | CHAR | 2 | |||
| MI_REVERSE | Reverse Move-In | CHAR | 2 | |||
| GENERATE | Refresh Master Data Generator for Product | CHAR | 2 | |||
| FULL_GENERATION | CRM Configuration Changed - Regenerate Contract Period | CHAR | 2 | |||
| MO_CREATEH | Finish Time Slice (EVERH) | CHAR | 2 | |||
| MO_DATECHANGEH | Postpone Time Slice (EVERH) | CHAR | 2 | |||
| MO_REVERSEH | Open Time Slice (EVERH) | CHAR | 2 | |||
| MI_CREATEH | Create Time Slice (EVERH) (Using Master Data Generator) | CHAR | 2 | |||
| MI_DATECHANGEH | Postpone Time Slice (EVERH) | CHAR | 2 | |||
| MI_REVERSEH | Delete Time Slice (EVERH) | CHAR | 2 | |||
| MI_NOCONTRGEN | Do Not Generate Contract | CHAR | 2 | |||
| MI_INSERT | Insert move-in/out | CHAR | 2 | |||
| MI_INSERT_REV | Reverse Move-In/Out Insertion | CHAR | 2 | |||
| PC_ADJUSTBBP | Product Change: Adjust Budget Billing Plan | CHAR | 2 | |||
| PC_PRINTDOC | Product Change: Print Rate Change Letter | CHAR | 2 | |||
| CRMBUGCONFIRM | Error for Manual Correction in CRM: User Must Confirm | CHAR | 2 | |||
| INFORMCONFIRM | Backend User Information with Confirmation | CHAR | 2 | |||
| CRMDATAINCMPLT | CRM Data Incomplete | CHAR | 2 | |||
| MO_BILLED | Move-Out Period Already Billed | CHAR | 2 | |||
| MI_BILLED | Move-In Was Already Billed | CHAR | 2 | |||
| MD_ORIGOBJ | Key for Srce.Object During Error Handling in IS-U Sales Repl | ECRM_MD_ORIGOBJ | CHAR | 8 | ||
| PRECOND_GUID | Globally Unique Identifier | GUID | RAW | 16 | ||
| XREPLCNTL | Replication Controls | EXREPLCNTL | CHAR | 2 | ||
| NOD | Indicators | KENNZX | CHAR | 2 | ||
| OUCONTRACT | Master Agreement for Individual Contract | OUCONTRACT | CHAR | 20 | * | |
| INACTIVE | Indicators | KENNZX | CHAR | 2 | ||
| IN_BCKGRDPRC | Indicators | KENNZX | CHAR | 2 | ||
| NUM_RESTART | Four-digit number | NUM4 | NUMC | 8 | ||
| BBP_ADJUST | Adjust Budget Billing Plan | CHAR | 2 | |||
| RTC_PRINT | Print Confirmation of Rate Change | CHAR | 2 | |||
| RTC_FORMKEY | Application form | FORMKEY | CHAR | 60 | * | |
| BBP_ADJUST_FLG | Indicators | KENNZX | CHAR | 2 | ||
| RTC_PRINT_FLG | Indicators | KENNZX | CHAR | 2 | ||
| AMIO_PRDOC | Parked Document Number | ECAMIO_PRDOC | CHAR | 24 | ||
| OUCONTRACT_I | GUID in 'RAW' format | GUID_16 | RAW | 16 | ||
| VBELN | Sales and Distribution Document Number | VBELN | CHAR | 20 | * | |
| POSNR | Item number of the SD document | POSNR | NUMC | 12 | * | |
| PROP | Property | EEWA_CLEAN_PROP | CHAR | 24 | ||
| SERVLOC | Location of Container | SERVLOC | CHAR | 60 | * | |
| .INCLUDE | EVER_CRMQ_CRM_INCLUDE | 0 | ||||
| ACT_SWTCMSG | GUID in 'CHAR' format with upper-/lowercase (!) | GUID_22 | CHAR | 44 | ||
| DEACT_SWTCMSG | GUID in 'CHAR' format with upper-/lowercase (!) | GUID_22 | CHAR | 44 | ||
| RELTOPREV | Component of the Version Number | CHAR2 | CHAR | 4 | ||
| RELTONEXT | Component of the Version Number | CHAR2 | CHAR | 4 | ||
| PREV_TS_GUID | GUID in 'RAW' format | GUID_16 | RAW | 16 | ||
| NEXT_TS_GUID | GUID in 'RAW' format | GUID_16 | RAW | 16 | ||
| DELETED | Checkbox in Reporting | CHECKBOX | CHAR | 2 | ||
| BUNDLE_GUID | GUID in 'RAW' format | GUID_16 | RAW | 16 | ||
| PRODCH_BEG | Indicators | KENNZX | CHAR | 2 | ||
| PRODCH_END | Indicators | KENNZX | CHAR | 2 | ||
| VKONTO | Contract Account Number | VKONT_KK | CHAR | 24 | * | |
| PARTNER | Business Partner Number | BU_PARTNER | CHAR | 20 | * | |
| CANCELED | Indicators | KENNZX | CHAR | 2 | ||
| ACT_SWTCDOC | Switch Document No. | EIDESWTNUM | CHAR | 40 | * | |
| DEACT_SWTCDOC | Switch Document No. | EIDESWTNUM | CHAR | 40 | * | |
| CRM_ITEM_DESCR | Contract Description | ECRM_CONTRACT_DESCR | CHAR | 80 | ||
| EMMA_RUNID | Internal Job Number | EMMA_RUNID | NUMC | 20 | * | |
| EMMA_INTNR | Number of Job Interval | EMMA_INTNR | INT4 | 4 | ||
| CASE_VIA_BADI | Indicators | KENNZX | CHAR | 2 |