Bookshelf v7.8: EIM Table Mappings to Base Tables Without User Keys

Some EIM tables contain table mappings to base tables without user keys. When using these EIM tables, you should note the EIM behavior for the relevant process type as described in Process Issues for Base Tables Without User Keys.

EIM Tables and Base Tables Without User Keys

Table 5 lists some examples of EIM tables containing table mappings to base tables without user keys.

Table 5. Example EIM Tables With Table Mappings to Base Tables Without User Keys
EIM Table	Target Base Table Without User Key
EIM_ACCNT_DTL	S_NOTE_ACCNT
EIM_ACCSRCPIDTL	S_NOTE_ACCSRCPI
EIM_ACC_SRC_DTL	S_NOTE_ACC_SRC
EIM_ACT_DTL	S_NOTE_ACT
EIM_ASGN_GRP	S_ASGN_RESULT
EIM_ASSET_DTL	S_NOTE_ASSET
EIM_BASELN_DTL	S_NOTE_BASELINE
EIM_CON_DTL	S_NOTE_CON
EIM_CONSUM_DTL	S_NOTE_CONSUME
EIM_CON_PI_DTL	S_NOTE_CON_PI
EIM_DCP_DTL	S_NOTE_DCP
EIM_DEFECT_DTL	S_NOTE_DEFECT
EIM_INVC_DTL	S_NOTE_INVOICE
EIM_NOTE	S_NOTE
EIM_OPTY_DTL	S_NOTE_OPTY
EIM_ORDER1	S_NOTE_ORDER
EIM_ORDER_ITEM1	S_NOTE_ORDER_IT
EIM_GROUP_DTL	S_NOTE_ORGGROUP
EIM_PRDINT_DTL	S_NOTE_PROD_INT
EIM_PROJECTDTL	S_NOTE_PROJ
EIM_PROJITMDTL	S_NOTE_PROJITEM
EIM_PROJRSRCDTL	S_NOTE_PROJRSRC
EIM_QUOTE_DTL	S_NOTE_QUOTE
EIM_QUO_IT_DTL	S_NOTE_QUOTE_IT
EIM_PDSHIP_DTL	S_NOTE_SHIPMENT
EIM_SR_DTL	S_NOTE_SR
EIM_SRC_DTL	S_NOTE_SRC
EIM_TARGET_DTL	S_NOTE_TARGET
EIM_USR_MSG_DTL	S_NOTE_USR_MSG
EIM_WFM_ACTION	S_ACTION_ARG
EIM_WFM_RULE	S_ESCL_ACTION

Process Issues for Base Tables Without User Keys

This subsection describes issues that you should be aware of when performing EIM processes involving base tables without user keys.

Importing Data into Base Tables Without User Keys. Import works but EIM does not check and prevent duplicate records from being imported into the base tables without user keys. If an import batch is executed repeatedly, the same records are imported repeatedly because EIM cannot check whether the records to be imported already exist in the base table without user keys.

Updating Data in Base Tables Without User Keys. Update on base tables without user keys cannot work, because EIM cannot uniquely identify the record to update.

Exporting Data from Base Tables Without User Keys. Exporting data from base tables without user keys is done the same way as exporting data from base tables with user keys.

Deleting Data from Base Tables Without User Keys. DELETE ALL ROWS and DELETE MATCHES can be used to delete data in target base tables. If a table without a user key is the target table, then delete works as it does for base tables with user keys. In most cases, however, a table without a user key is a secondary table and its data can only be deleted with the table as a child of its parent table.

NOTE: EIM_NOTE_DEL and EIM_SKLI_DEL are special EIM tables used for deleting from the S_NOTE* and S_*SKILL_IT tables, which do not have the normal U1 user key.

Merging Data in Base Tables Without User Keys. Merge does not work on base tables without user keys.