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 |