SAP table IAOM_CRMSRV_CTP (Customizing: Determination Controlling Type CRM Service)

SAP table IAOM_CRMSRV_CTP has 8 primary key fields being MANDT,VALID_FROM_DATE,VALID_FROM_TIME,TOPPROC_TYPE_CTP,PROCESS_TYPE_CTP,SERVICE_ORG_CTP,SRV_ORG_RESP_CTP,ENTERPRISE_SERVICE_ORG_CTP.

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
VALID_FROM_DATE Enter Valid From Date DATS 8 0 IAOM_VALID_FROM_DATE
VALID_FROM_TIME Enter Valid-From Time TIMS 6 0 IAOM_VALID_FROM_TIME
TOPPROC_TYPE_CTP Leading Business Transaction Type CHAR 4 0 CRMC_PR_TYP_CO CRMT_TOP_PROCESS_TYPE_CO
PROCESS_TYPE_CTP Business Transaction Type CHAR 4 0 CRMC_PR_TYP_CO CRMT_PROCESS_TYPE_CO
SERVICE_ORG_CTP Service Organization CHAR 14 0 CRMC_SVORG_CO CRMT_SERVICE_ORG_CO
SRV_ORG_RESP_CTP Responsible Organizational Unit (Service) CHAR 14 0 CRMC_RSVORG_CO CRMT_SERVICE_ORG_RESP_CO
ENTERPRISE_SERVICE_ORG_CTP Enterprise Service Organization CHAR 4 0 CRMS4_ENTERPRISE_SERVICE_ORG
CO_TYPE Controlling Type CHAR 1 0 IAOM_CONTROLLING_TYPE
M Mass-Object Controlling
N No Controlling
P Single Controlling for PS Projects
S Single-Object Controlling
T Controlling for Account Assignment Object
CO_LEVEL Controlling Level NUMC 2 0 IAOM_CONTROLLING_LEVEL
CO_REFERENCE Reference Usage CHAR 1 0 IAOM_USAGE_REFERENCE
Copy
A Ignore
B Transfer Additional
C Copy and Create Additional Account Assignment
D Transfer 1 to 1
E Ignore and Create Neighboring Account Assignment
VALID_TO_DATE Enter Valid-To Date DATS 8 0 IAOM_VALID_TO_DATE
VALID_TO_TIME Enter Valid-To Time TIMS 6 0 IAOM_VALID_TO_TIME
ACTUALS Enable Extended Cost Analysis CHAR 1 0 CRM_ACTUALS_CO
COMPLEX Amount Allocation CHAR 1 0 CRM_COMPLEX_CO

IAOM_CRMSRV_CTP foreign key relationships

Table Field Check Table Check Field
0 IAOM_CRMSRV_CTP MANDT T000 Clients MANDT
1 IAOM_CRMSRV_CTP PROCESS_TYPE_CTP CRMC_PR_TYP_CO Business Transaction Type CLIENT
0 IAOM_CRMSRV_CTP SERVICE_ORG_CTP CRMC_SVORG_CO Service Organization CLIENT
1 IAOM_CRMSRV_CTP SRV_ORG_RESP_CTP CRMC_RSVORG_CO Responsible Service Organization CRM CLIENT
0 IAOM_CRMSRV_CTP TOPPROC_TYPE_CTP CRMC_PR_TYP_CO Business Transaction Type CLIENT