The CRMD_ALLOC_REL table in SAP ERP or S/4HANA stores Links: Transaction Item – Assignment Number data. There are total 15 fields in CRMD_ALLOC_REL table. The Links: Transaction Item – Assignment Number table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRMD_ALLOC_REL table. It is in Document flow (CRM_DOC_FLOW) ABAP package and is part of the Basic Functions for Business Transactions (CRM-BTX-BF) module.
SAP CRMD_ALLOC_REL Table Fields
Following is the list of fields that are available in SAP CRMD_ALLOC_REL table. The primary key fields of the table are CLIENT (Client), BRELGUID (Globally Unique Identifier).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| BRELGUID | Globally Unique Identifier | OS_GUID | RAW (16) | |
| RELTYPE | Relationship type | OBLRELTYPE | MDOBLREL | CHAR (10) |
| INSTID_A | Instance Ident. in BOR Compat. Persistent Object References | SIBFBORIID | CHAR (70) | |
| TYPEID_A | Type of Objects in Persistent Object References | SIBFTYPEID | CHAR (32) | |
| CATID_A | Category of Objects in Persistent Object References | SIBFCATID | CHAR (2) | |
| INSTID_B | Instance Ident. in BOR Compat. Persistent Object References | SIBFBORIID | CHAR (70) | |
| TYPEID_B | Type of Objects in Persistent Object References | SIBFTYPEID | CHAR (32) | |
| CATID_B | Category of Objects in Persistent Object References | SIBFCATID | CHAR (2) | |
| LOGSYS_A | Logical system | LOGSYS | CHAR (10) | |
| ARCH_A | Archiving Flag for Object Relationships | OBLARCH | CHAR (1) | |
| LOGSYS_B | Logical system | LOGSYS | CHAR (10) | |
| ARCH_B | Archiving Flag for Object Relationships | OBLARCH | CHAR (1) | |
| UTCTIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC (15) | |
| HOMESYS | Logical system | LOGSYS | CHAR (10) |
