1. Home
  2. Resources
  3. SAP Tables
  4. EVER_CRMQ - ISU Contract CRM-Entry Queue

SAP Table EVER_CRMQ

ISU Contract CRM-Entry Queue

EVER_CRMQ (ISU Contract CRM-Entry Queue) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link EVER_CRMQ to other SAP tables.

EVER_CRMQ table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
CONTRACTPOS Globally Unique Identifier GUID RAW 16 0
NUM Four-digit number NUM4 NUMC 4 0
VERTRAG Contract VERTRAG CHAR 10 0
ANLAGE Installation ANLAGE CHAR 10 0
AB Date from which time slice is valid ABZEITSCH DATS 8 0
BIS Date at Which a Time Slice Expires BISZEITSCH DATS 8 0
CRM_PRODUCT CRM Product ESALES_CRM_PRODUCT CHAR 40 0
PRODID Node to Describe Master Data Template EPD_PRODID CHAR 20 0
PRODUCT_GUID Globally Unique Identifier GUID RAW 16 0
CAMPAIGN IS-U: Marketing Campaign ISU_MARKETING_CAMPAIGN RAW 16 0
CAMPAIGN_TO_DATE IS-U: Individual To-Date Campaign Analysis ISU_CAMPAIGN_TO_DATE DATS 8 0
IN_PROGRESS Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
GEN_AB Date from which time slice is valid ABZEITSCH DATS 8 0
GEN_BIS Date at Which a Time Slice Expires BISZEITSCH DATS 8 0
BILLED Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
INT_UI Internal key for point of delivery INT_UI CHAR 22 0
PARTNER_GUID Business Partner GUID BU_PARTNER_GUID RAW 16 0
VKONTO_GUID Business Agreement GUID BUAG_GUID RAW 16 0
CRM_OBJECT_ID Transaction Number in CRM Document ECRMT_OBJECT_ID CHAR 10 0
CRM_OBJECT_POS Item Number in CRM Document ECRM_ITEM_NO NUMC 10 0
CANCREASON_NEW Cancellation Reason (CRM) ECRMT_SRV_CANCEL_REASON CHAR 4 0
ERRORDATE Date DATUM DATS 8 0
ERRORTIME Time in CHAR Format TIME CHAR 6 0
MDG_CREATE Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
LOGHANDLE Application Log: Log Handle BALLOGHNDL CHAR 22 0
MDG_LOG GUID in 'CHAR' Format in Uppercase GUID_32 CHAR 32 0
CONTRACTHEAD Globally Unique Identifier GUID RAW 16 0
MO_CREATE CHAR 1 0
MO_DATECHANGE CHAR 1 0
MO_REVERSE CHAR 1 0
MI_CREATE CHAR 1 0
MI_DATECHANGE CHAR 1 0
MI_REVERSE CHAR 1 0
GENERATE CHAR 1 0
FULL_GENERATION CHAR 1 0
MO_CREATEH CHAR 1 0
MO_DATECHANGEH CHAR 1 0
MO_REVERSEH CHAR 1 0
MI_CREATEH CHAR 1 0
MI_DATECHANGEH CHAR 1 0
MI_REVERSEH CHAR 1 0
MI_NOCONTRGEN CHAR 1 0
MI_INSERT CHAR 1 0
MI_INSERT_REV CHAR 1 0
PC_ADJUSTBBP CHAR 1 0
PC_PRINTDOC CHAR 1 0
CRMBUGCONFIRM CHAR 1 0
INFORMCONFIRM CHAR 1 0
CRMDATAINCMPLT CHAR 1 0
MO_BILLED CHAR 1 0
MI_BILLED CHAR 1 0
MD_ORIGOBJ Key for Srce.Object During Error Handling in IS-U Sales Repl ECRM_MD_ORIGOBJ CHAR 4 0
CONT CRM: Replication of Contracts
BUCA EC70: Create/Change Bus.Part.and Contr.Acc. for Accel.Entry
CONN CRM: Replication of Connection Object
NULL CRM: General Replication
MOUT EC70: Create Move-Out for Accelerated Entry
EPOD CRM: Replication of Point of Delivery
RGEN CRM: Replication of Marked Contract Changes
MVIN EC70: Create Move-In for Accelerated Entry
MPCH CRM: Mass Product Change
PRECOND_GUID Globally Unique Identifier GUID RAW 16 0
XREPLCNTL Replication Controls EXREPLCNTL CHAR 1 0
A CRM
B Reserved
C IS-U - Generated for Initial and Deltaload
D IS-U - Move-In (dummy)
E IS-U - Efficiency
F Force Download (as A, but due to Change in IS-U)
M Generated for Masses (Download Only in Request+Initial Load)
N Generated with M or P. However, Already Replicated.
O IS-U Only, No Replication
NULL Unknown
NOD Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
OUCONTRACT Master Agreement for Individual Contract OUCONTRACT CHAR 10 0
INACTIVE Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
IN_BCKGRDPRC Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
NUM_RESTART Four-digit number NUM4 NUMC 4 0
BBP_ADJUST CHAR 1 0
RTC_PRINT CHAR 1 0
RTC_FORMKEY Application form FORMKEY CHAR 30 0
BBP_ADJUST_FLG Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
RTC_PRINT_FLG Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
AMIO_PRDOC Parked Document Number ECAMIO_PRDOC CHAR 12 0
OUCONTRACT_I GUID in 'RAW' format GUID_16 RAW 16 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
POSNR Item number of the SD document POSNR NUMC 6 0
PROP Property EEWA_CLEAN_PROP CHAR 12 0
SERVLOC Location of Container SERVLOC CHAR 30 0
ACT_SWTCMSG GUID in 'CHAR' format with upper-/lowercase (!) GUID_22 CHAR 22 0
DEACT_SWTCMSG GUID in 'CHAR' format with upper-/lowercase (!) GUID_22 CHAR 22 0
RELTOPREV Version Number Component CHAR2 CHAR 2 0
RELTONEXT Version Number Component CHAR2 CHAR 2 0
PREV_TS_GUID GUID in 'RAW' format GUID_16 RAW 16 0
NEXT_TS_GUID GUID in 'RAW' format GUID_16 RAW 16 0
DELETED Checkbox in Reporting CHECKBOX CHAR 1 0
BUNDLE_GUID GUID in 'RAW' format GUID_16 RAW 16 0
PRODCH_BEG Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
PRODCH_END Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
VKONTO Contract Account Number VKONT_KK CHAR 12 0
PARTNER Business Partner Number BU_PARTNER CHAR 10 0
CANCELED Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
ACT_SWTCDOC Switch Document No. EIDESWTNUM CHAR 20 0
DEACT_SWTCDOC Switch Document No. EIDESWTNUM CHAR 20 0
CRM_ITEM_DESCR Contract Description ECRM_CONTRACT_DESCR CHAR 40 0