SAP table EVERH (IS-U Contract History)

SAP table EVERH has 4 primary key fields being MANDT,VERTRAG,BIS,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
VERTRAG Contract CHAR 10 0 VERTRAG
BIS Date at Which a Time Slice Expires DATS 8 0 BISZEITSCH
NUM Four-digit number NUMC 4 0 NUM4
AB Date from which time slice is valid DATS 8 0 ABZEITSCH
ANLAGE Installation CHAR 10 0 ANLAGE
CONTRACTHEAD GUID in 'RAW' format RAW 16 0 GUID_16
CONTRACTPOS GUID in 'RAW' format RAW 16 0 GUID_16
CRM_PRODUCT CRM Product CHAR 40 0 ESALES_CRM_PRODUCT
PRODID Node to Describe Master Data Template CHAR 20 0 * EPD_PRODID
PRODUCT_GUID GUID in 'RAW' format RAW 16 0 GUID_16
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
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
LOEVM Deletion Indicator CHAR 1 0 LOEVM
PRODCH_BEG Indicators CHAR 1 0 KENNZX
Field inactive
X Field active
PRODCH_END Indicators CHAR 1 0 KENNZX
Field inactive
X Field active
OUCONTRACT Master Agreement for Individual Contract CHAR 10 0 OUCONTRACT
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
BUNDLE_GUID GUID in 'RAW' format RAW 16 0 GUID_16
GEN_DATE Generation Date of EVERH (for Initial Load) DATS 8 0 ECRM_GEN_DATE
CRM_ITEM_DESCR Contract Description CHAR 40 0 ECRM_CONTRACT_DESCR
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM