SAP table EVER_CRMQ (ISU Contract CRM-Entry Queue)

SAP table EVER_CRMQ has 3 primary key fields being MANDT,CONTRACTPOS,NUM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
CONTRACTPOS Globally Unique Identifier RAW 16 0 GUID
NUM Four-digit number NUMC 4 0 NUM4
VERTRAG Contract CHAR 10 0 VERTRAG
ANLAGE Installation CHAR 10 0 ANLAGE
AB Date from which time slice is valid DATS 8 0 ABZEITSCH
BIS Date at Which a Time Slice Expires DATS 8 0 BISZEITSCH
CRM_PRODUCT CRM Product CHAR 40 0 ESALES_CRM_PRODUCT
PRODID Node to Describe Master Data Template CHAR 20 0 EPD_PRODID
PRODUCT_GUID Globally Unique Identifier RAW 16 0 GUID
CAMPAIGN IS-U: Marketing Campaign RAW 16 0 ISU_MARKETING_CAMPAIGN
CAMPAIGN_TO_DATE IS-U: Individual To-Date Campaign Analysis DATS 8 0 ISU_CAMPAIGN_TO_DATE
IN_PROGRESS Indicators CHAR 1 0 KENNZX
Field inactive
X Field active
GEN_AB Date from which time slice is valid DATS 8 0 ABZEITSCH
GEN_BIS Date at Which a Time Slice Expires DATS 8 0 BISZEITSCH
BILLED Indicators CHAR 1 0 KENNZX
Field inactive
X Field active
INT_UI Internal key for point of delivery CHAR 22 0 INT_UI
PARTNER_GUID Business Partner GUID RAW 16 0 BU_PARTNER_GUID
VKONTO_GUID Business Agreement GUID RAW 16 0 BUAG_GUID
CRM_OBJECT_ID Transaction Number in CRM Document CHAR 10 0 ECRMT_OBJECT_ID
CRM_OBJECT_POS Item Number in CRM Document NUMC 10 0 ECRM_ITEM_NO
CANCREASON_NEW Cancellation Reason (CRM) CHAR 4 0 ECRMT_SRV_CANCEL_REASON
ERRORDATE Date DATS 8 0 DATUM
ERRORTIME Time in CHAR Format CHAR 6 0 TIME
MDG_CREATE Indicators CHAR 1 0 KENNZX
Field inactive
X Field active
LOGHANDLE Application Log: Log Handle CHAR 22 0 BALLOGHNDL
MDG_LOG GUID in 'CHAR' Format in Uppercase CHAR 32 0 GUID_32
CONTRACTHEAD Globally Unique Identifier RAW 16 0 GUID
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 CHAR 4 0 ECRM_MD_ORIGOBJ
CRM: General Replication
BUCA EC70: Create/Change Bus.Part.and Contr.Acc. for Accel.Entry
CONN CRM: Replication of Connection Object
CONT CRM: Replication of Contracts
EPOD CRM: Replication of Point of Delivery
MOUT EC70: Create Move-Out for Accelerated Entry
MPCH CRM: Mass Product Change
MVIN EC70: Create Move-In for Accelerated Entry
RGEN CRM: Replication of Marked Contract Changes
PRECOND_GUID Globally Unique Identifier RAW 16 0 GUID
XREPLCNTL Replication Controls CHAR 1 0 EXREPLCNTL
Unknown
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
NOD Indicators CHAR 1 0 KENNZX
Field inactive
X Field active
OUCONTRACT Master Agreement for Individual Contract CHAR 10 0 OUCONTRACT
INACTIVE Indicators CHAR 1 0 KENNZX
Field inactive
X Field active
IN_BCKGRDPRC Indicators CHAR 1 0 KENNZX
Field inactive
X Field active
NUM_RESTART Four-digit number NUMC 4 0 NUM4
BBP_ADJUST CHAR 1 0
RTC_PRINT CHAR 1 0
RTC_FORMKEY Application form CHAR 30 0 FORMKEY
BBP_ADJUST_FLG Indicators CHAR 1 0 KENNZX
Field inactive
X Field active
RTC_PRINT_FLG Indicators CHAR 1 0 KENNZX
Field inactive
X Field active
AMIO_PRDOC Parked Document Number CHAR 12 0 ECAMIO_PRDOC
OUCONTRACT_I GUID in 'RAW' format RAW 16 0 GUID_16
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
POSNR Item number of the SD document NUMC 6 0 POSNR
PROP Property CHAR 12 0 EEWA_CLEAN_PROP
SERVLOC Location of Container CHAR 30 0 SERVLOC
ACT_SWTCMSG GUID in 'CHAR' format with upper-/lowercase (!) CHAR 22 0 GUID_22
DEACT_SWTCMSG GUID in 'CHAR' format with upper-/lowercase (!) CHAR 22 0 GUID_22
RELTOPREV Component of the Version Number CHAR 2 0 CHAR2
RELTONEXT Component of the Version Number CHAR 2 0 CHAR2
PREV_TS_GUID GUID in 'RAW' format RAW 16 0 GUID_16
NEXT_TS_GUID GUID in 'RAW' format RAW 16 0 GUID_16
DELETED Checkbox in Reporting CHAR 1 0 CHECKBOX
BUNDLE_GUID GUID in 'RAW' format RAW 16 0 GUID_16
PRODCH_BEG Indicators CHAR 1 0 KENNZX
Field inactive
X Field active
PRODCH_END Indicators CHAR 1 0 KENNZX
Field inactive
X Field active
VKONTO Contract Account Number CHAR 12 0 VKONT_KK
PARTNER Business Partner Number CHAR 10 0 BU_PARTNER
CANCELED Indicators CHAR 1 0 KENNZX
Field inactive
X Field active
ACT_SWTCDOC Switch Document No. CHAR 20 0 * EIDESWTNUM
DEACT_SWTCDOC Switch Document No. CHAR 20 0 * EIDESWTNUM
CRM_ITEM_DESCR Contract Description CHAR 40 0 ECRM_CONTRACT_DESCR
EMMA_RUNID Internal Job Number NUMC 10 0 EMMA_RUNID
EMMA_INTNR Number of Job Interval INT4 10 0 EMMA_INTNR
CASE_VIA_BADI Indicators CHAR 1 0 KENNZX
Field inactive
X Field active