In this post, I will try and describe everything you need to know about the SAP crmd_brel_plnk_i table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_BREL_PLNK_I what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_BREL_PLNK_I....Right lets get started!
Object Name: CRMD_BREL_PLNK_I
Dictionary Type: Transparent table
Description: Time-Dependent Document Link: Item Attributes
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | T000 | Client | MANDT | TEST | CRM | ||||
| RELATIONID | BINRELID | CHAR | 22(0) | Object Relationship Service : GUID binary link | SYSUUID_22 | CRM | ||||||
| POSNO | CRMT_POSNO | NUMC | 6(0) | Item Number in Document Flow | NUMC6 | CRM | ||||||
| BRELTYP | BINRELTYP | CHAR | 4(0) | ORBRELTYP | Relationship type | BINRELTYP | CRM | |||||
| ATTRIBUT | RELATTRIB | CHAR | 10(0) | Object Relationship Service : attribute of a link | CHAR10 | CRM | ||||||
| .INCLU-_A | 0(0) | CRM | ||||||||||
| OBJKEY_A | CRMT_DOC_FLOW_ID | CHAR | 32(0) | Identification of a Reference Object for Items | CHAR32 | CRM | ||||||
| OBJTYPE_A | SWO_OBJTYP | CHAR | 10(0) | TOJTB | Object Type | OJ_NAME | OBJ | CRM | ||||
| LOGSYS_A | CRMT_LOGSYS | CHAR | 10(0) | TBDLS | Logical System | LOGSYS | CRM | |||||
| .INCLU-_B | 0(0) | CRM | ||||||||||
| OBJKEY_B | CRMT_DOC_FLOW_ID | CHAR | 32(0) | Identification of a Reference Object for Items | CHAR32 | CRM | ||||||
| OBJTYPE_B | SWO_OBJTYP | CHAR | 10(0) | TOJTB | Object Type | OJ_NAME | OBJ | CRM | ||||
| LOGSYS_B | CRMT_LOGSYS | CHAR | 10(0) | TBDLS | Logical System | LOGSYS | CRM | |||||
| PLNK_KIND | CRMT_PLNK_KIND | CHAR | 2(0) | * | Type of Binary Relationships: Pool Linkage Types | CRM_PLNK_KIND | CRM | |||||
| DATE_FROM | CRMT_TIMESTAMP | DEC | 15(0) | Time Stamp (Date and Time) | BCOS_TSTMP | CRM | ||||||
| DATE_TO | CRMT_TIMESTAMP | DEC | 15(0) | Time Stamp (Date and Time) | BCOS_TSTMP | CRM | ||||||
| STAT | CRMT_STATUS_DOC_FLOW | CHAR | 2(0) | * | Status of Time-Dependent Document Linkage | CRM_STATUS_DOC_FLOW | CRM | |||||
| CREATED_BY | CRMT_CREATED_BY | CHAR | 12(0) | User that Created the Transaction | UNAME | USER_ADDR | BNAME | CRM | ||||
| CHANGED_BY | CRMT_CHANGED_BY | CHAR | 12(0) | Transaction Last Changed By | UNAME | CRM | ||||||
| CREATED_AT | CRMT_TIMESTAMP | DEC | 15(0) | Time Stamp (Date and Time) | BCOS_TSTMP | CRM | ||||||
| CHANGED_AT | CRMT_TIMESTAMP | DEC | 15(0) | Time Stamp (Date and Time) | BCOS_TSTMP | CRM |