SAP table VIAOM_CRMSRV_OBJ (Generated Table for View)

SAP table VIAOM_CRMSRV_OBJ has 17 primary key fields being MANDT,EXT_OBJECT_ID,OBJECT_ID,PROCESS_DESCRIPT,PROCESS_TYPE,SERVICE_ORG_RESP,SERVICE_ORG,ENTERPRISE_SERVICE_ORG,SERVICE_TEAM,NUMBER_INT,ITEM_DESCRIPTION,ITM_TYPE,SERVICE_TECH_ORG,CATEGORY_ID,KUNNR,OBJECT_NO,ACC_ASS_OBJECT.

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 T000 MANDT
EXT_OBJECT_ID External Object Technical Key CHAR 34 0 IAOM_EXT_OBJ_INF IAOM_EXT_OBJECT_ID
OBJECT_ID Transaction CHAR 10 0 CRMT_OBJECT_ID_CO
PROCESS_DESCRIPT Business Transaction Description CHAR 40 0 CRMT_PROCESS_DESCRIPTION_CO
PROCESS_TYPE Business Transaction Type CHAR 4 0 CRMT_PROCESS_TYPE_CO
SERVICE_ORG_RESP Responsible Organizational Unit (Service) CHAR 14 0 CRMT_SERVICE_ORG_RESP_CO
SERVICE_ORG Service Organization CHAR 14 0 CRMT_SERVICE_ORG_CO
ENTERPRISE_SERVICE_ORG Enterprise Service Organization CHAR 4 0 CRMS4_ENTERPRISE_SERVICE_ORG
SERVICE_TEAM Service Team ID NUMC 8 0 CRMS4_SERVICE_TEAM_ID_CO
NUMBER_INT Item NUMC 10 0 CRMT_ITEM_NO_CO
ITEM_DESCRIPTION Description of an Item CHAR 40 0 CRMT_ITEM_DESCRIPTION_CO
ITM_TYPE Item Category CHAR 4 0 CRMT_ITEM_TYPE_CO
SERVICE_TECH_ORG Service Technician Organization / Team CHAR 14 0 CRMT_SERVICE_TECH_ORG_CO
CATEGORY_ID Produkt Category ID CHAR 18 0 COMT_CATEGORY_ID_CO_18
KUNNR Sold-to Party CHAR 10 0 KUNAG
OBJECT_NO Object number CHAR 22 0 J_OBJNR
ACC_ASS_OBJECT External Object Technical Key CHAR 34 0 IAOM_EXT_OBJECT_ID

VIAOM_CRMSRV_OBJ foreign key relationships

Table Field Check Table Check Field
0 VIAOM_CRMSRV_OBJ EXT_OBJECT_ID IAOM_EXT_OBJ_INF General Information on External Object - See Documentation MANDT
1 VIAOM_CRMSRV_OBJ MANDT T000 Clients MANDT