In this post, I will try and describe everything you need to know about the SAP crmd_ubb_notif_h 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_UBB_NOTIF_H 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_UBB_NOTIF_H....Right lets get started!
Object Name: CRMD_UBB_NOTIF_H
Dictionary Type: Transparent table
Description: Notifications
| 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) | * | Client | MANDT | TEST | CRM | ||||
| GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| CREATED_AT | COMT_CREATED_AT_USR | DEC | 15(0) | Created At (Output in User Time Zone) | COM_TSTMP | CRM | ||||||
| CREATED_BY | CRMT_CREATED_BY | CHAR | 12(0) | User that Created the Transaction | UNAME | USER_ADDR | BNAME | CRM | ||||
| CHANGED_AT | COMT_CHANGED_AT_USR | DEC | 15(0) | Changed At (Output in User Time Zone) | COM_TSTMP | CRM | ||||||
| CHANGED_BY | CRMT_CHANGED_BY | CHAR | 12(0) | Transaction Last Changed By | UNAME | CRM | ||||||
| HEADER | CRMT_ITEM_GUID | RAW | 16(0) | Item GUID for a CRM Document | SYSUUID | CRM | ||||||
| ITEM | CRMT_ITEM_GUID | RAW | 16(0) | Item GUID for a CRM Document | SYSUUID | CRM | ||||||
| PARTNER_GUID | CRMT_PARTNER_GUID | RAW | 16(0) | GUID for an Individual Partner | SYSUUID | CRM | ||||||
| REF_PARTNER_NO | CRMT_PARTNER_NUMBER | CHAR | 16(0) | Partner Number for Use Outside Partner Processing | CRM_PARTNER_NUMBER | CRM | ||||||
| ADDR_NR | AD_ADDRNUM | CHAR | 10(0) | * | Address number | AD_ADDRNUM | ADR | CRM | ||||
| ADDR_NP | AD_PERSNUM | CHAR | 10(0) | * | Person number | AD_PERSNUM | CDT | ADDRESS | PERSNUMBER | CRM | ||
| ADDR_TYPE | AD_ADRTYPE | CHAR | 1(0) | Address type (1=Organization, 2=Person, 3=Contact person) | AD_ADRTYPE | CRM | ||||||
| ADDR_ORIGIN | CRMT_ADDR_ORIGIN_MD | CHAR | 1(0) | Origin of a Partner Address | CRM_ADDR_ORIGIN_MD | CRM | ||||||
| STD_BP_ADDRESS | CRMT_PARTNER_STD_BP_ADDRESS | CHAR | 1(0) | Standard Business Partner Address (Depending on Addr.Type) | XFELD | CRM | ||||||
| ADDR_OPERATION | BU_OPERATION | CHAR | 6(0) | * | Transaction for BP Address Determination | BU_OPERATION | CRM | |||||
| ADDR_NR_SEND | AD_ADDRNUM | CHAR | 10(0) | * | Address number | AD_ADDRNUM | ADR | CRM | ||||
| ADDR_NP_SEND | AD_PERSNUM | CHAR | 10(0) | * | Person number | AD_PERSNUM | CDT | ADDRESS | PERSNUMBER | CRM | ||
| PRODUCT | COMT_PRODUCT_GUID | RAW | 16(0) | Internal Unique ID of Product | SYSUUID | CRM | ||||||
| ORDERED_PROD | CRMT_ORDERED_PROD | CHAR | 54(0) | Product Name Entered | CRM_ORDERED_PROD | CRM_ORDERED_PRODUCT | PRODUCT_ID | CRM | ||||
| PARTNER_PROD | CRMT_ITEM_DESCR_PARTNER | CHAR | 40(0) | Product Number of Business Partner | PRSHTEXT40 | CRM | ||||||
| DATE_FROM | SC_DATEFRO | DATS | 8(0) | Start Date | DATUM | CRM | ||||||
| TIMESTAMP_FROM | CRMT_DATE_TIMESTAMP_FROM | DEC | 15(0) | Time Stamp (Date and Time) of a Date/Duration | BCOS_TSTMP | CRM | ||||||
| TIMEZONE_FROM | CRMT_TIMEZONE_FROM | CHAR | 6(0) | * | Time Zone for a Start Time | TZNZONE | CRM | |||||
| IBIB_GUID | SMO_GUID | CHAR | 32(0) | Global Unique Identifier | SMO_GUID | CRM | ||||||
| IBASE | IB_IBASE | NUMC | 18(0) | IBase: Number of the Installed Base/IBase | IB_INSTANCE | IIB | IBIBM | IBASE | CRM | |||
| IB_COMP_REF_GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| IB_INSTANCE | IB_INSTANCE | NUMC | 18(0) | IB: Component (instance) | IB_INSTANCE | IBC | CRM | |||||
| IOBJECT_ID | COMT_PRODUCT_OBJECT_ID | CHAR | 40(0) | Object ID | COM_PRODUCT_ID | COM_IND_OBJECT_COLLECTION | OBJECT_ID | CRM | ||||
| SETTL_FROM | CRMT_SETTL_FROM | DEC | 15(0) | Start of Settlement for Period | BCOS_TSTMP | CRM | ||||||
| SETTL_TO | CRMT_SETTL_TO | DEC | 15(0) | End of Settlement for Period | BCOS_TSTMP | CRM | ||||||
| CHANNEL | CRMT_UBB_CHANNEL | CHAR | 8(0) | CRMC_UBB_OUT_CHA | Reading Reminder Output Channel | CRM_UBB_CHANNEL | CRM | |||||
| OUT_MEDIA | CRMT_UBB_OUT_MEDIA | CHAR | 8(0) | Reading Reminder Messaging Medium | CRM_UBB_OUT_MEDIA | CRM | ||||||
| PARTNER_FCT | COMT_PARTNER_FCT | CHAR | 8(0) | Partner Function | COM_PARTNER_FCT | CRM | ||||||
| FORMNAME | TDSFNAME | CHAR | 30(0) | * | Smart Forms: Form Name | TDSFNAME | SSFNAME | CRM | ||||
| PROCESSED | CRMT_UBB_RR_PROCESSED | CHAR | 1(0) | Reading Reminder Created | CRMT_UBB_RR_PROCESSED | CRM | ||||||
| PRO_ERROR | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
| SEQUENCE | CRMT_UBB_SEQUENCE | CHAR | 4(0) | * | Message Sequence for Reading Reminder | CRM_UBB_SEQUENCE | CRM | |||||
| SEQ_ORDER | CRMT_UBB_SEQ_ORDER | NUMC | 3(0) | Sequence for Reading Reminder | CRM_UBB_SEQ_ORDER | CRM | ||||||
| CONTRACT_ID | CRMT_OBJECT_ID | CHAR | 10(0) | Transaction ID | CRM_OBJECT_ID | CRM_OBJECT_ID | CRM_ORDER_OBJECT_ID | OBJECT_ID | CRM | |||
| CONTRACT_ITEM | CRMT_ITEM_NO | NUMC | 10(0) | Item Number in Document | CRM_ITEM_NO | CRM | ||||||
| POOL_CONTRACT_ID | CRMT_OBJECT_ID | CHAR | 10(0) | Transaction ID | CRM_OBJECT_ID | CRM_OBJECT_ID | CRM_ORDER_OBJECT_ID | OBJECT_ID | CRM | |||
| POOL_CONTRACT_IT | CRMT_ITEM_NO | NUMC | 10(0) | Item Number in Document | CRM_ITEM_NO | CRM |