SAP table CRMRFCPAR (Definitions for RFC Connections)

SAP table CRMRFCPAR has 5 primary key fields being MANDT,CONSUMER,OBJNAME,RFCDEST,DOWNLOAD.

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
CONSUMER User of R/3 Adaptor Functions CHAR 10 0 CRMCONSUM CONSUMER
OBJNAME Object/Mobile Sales Table Name CHAR 15 0 CRM_OBJNAM
RFCDEST Logical destination (specified in function call) CHAR 32 0 * RFCDEST
DOWNLOAD Download Types for CRMRFCPAR CHAR 1 0 DWNLDTYP
* All Load Types
C Comparison/Request
D Delta Download
E Error Information for an Upload
H DIMa Header Comparison
I Initial Download
O Error Information, Not Belonging to an Upload
R Request
T DIMa Detail Comparison
RFC_QUEUE Name of tRFC Queue CHAR 24 0 CRMQNAM
RFC_IN_QUE Name of tRFC Queue CHAR 24 0 CRMQNAM
BAPINAME Name of Recipient BAPI to Be Called CHAR 30 0 * BAPINAME
INFO Information/Comments CHAR 30 0 CRMINFO
INACTIVE Data Record Inactive CHAR 1 0 CRMACTIVE
DISCARDDAT Indicator: Discard Data CHAR 1 0 DISCARDDAT
USE_IN_Q Indicator, for Whether Inqueue Was Used CHAR 1 0 CRMINQUSED
SEND_XML Send data in XML format? CHAR 1 0 CRMSENDXML
No XML
M Mixed Mode (Optimized)
X Send XML
HOLD_DATA Indicator: Record Data in Sender System? CHAR 1 0 HOLD_DATA
Data Is Not Being Recorded
X Data Is Being Recorded
CRM_REL SAP Release CHAR 10 0 SAPRELEASE
LAST_UPD System Date DATS 8 0 SYDATUM
USERNAME Last Changed by User CHAR 12 0 CHANGNAME
CHANGEDATE Last Changed On DATS 8 0 CHANGDATE
CHANGETIME Last Changed At TIMS 6 0 CHANGTIME
REM_LOGSYS Logical system CHAR 10 0 * LOGSYS

CRMRFCPAR foreign key relationships

Table Field Check Table Check Field
0 CRMRFCPAR CONSUMER CRMCONSUM Possible Users of R/3 Adapter Functionality MANDT
0 CRMRFCPAR CONSUMER CRMCONSUM Possible Users of R/3 Adapter Functionality CONSUMER