CRMD_UBB_NOTIF_H SAP (Notifications) Table details
Dictionary Type: Table
Description: Notifications
Description: Notifications
ABAP Code to SELECT data from CRMD_UBB_NOTIF_H
Related tables to CRMD_UBB_NOTIF_H
Access table CRMD_UBB_NOTIF_H
Related tables to CRMD_UBB_NOTIF_H
Access table CRMD_UBB_NOTIF_H
Table field list including key, data, relationships and ABAP select examples
CRMD_UBB_NOTIF_H is a standard SAP Table which is used to store Notifications data and is available within R/3 SAP systems depending on the version and release level.
The CRMD_UBB_NOTIF_H table consists of various fields, each holding specific information or linking keys about Notifications data available in SAP. These include CLIENT (Client), GUID (GUID of a CRM Order Object), CREATED_AT (Created At (Output in User Time Zone)), CREATED_BY (User that Created the Transaction).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP CRMD_UBB_NOTIF_H table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
CLIENT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW | 16 | SYSUUID | ||||
CREATED_AT | Created At (Output in User Time Zone) | COMT_CREATED_AT_USR | DEC | 15 | TSTLC | COM_TSTMP | |||
CREATED_BY | User that Created the Transaction | CRMT_CREATED_BY | CHAR | 12 | UNAME | USER_ADDR | |||
CHANGED_AT | Changed At (Output in User Time Zone) | COMT_CHANGED_AT_USR | DEC | 15 | TSTLC | COM_TSTMP | |||
CHANGED_BY | Transaction Last Changed By | CRMT_CHANGED_BY | CHAR | 12 | UNAME | ||||
HEADER | Item GUID for a CRM Document | CRMT_ITEM_GUID | RAW | 16 | SYSUUID | ||||
ITEM | Item GUID for a CRM Document | CRMT_ITEM_GUID | RAW | 16 | SYSUUID | ||||
PARTNER_GUID | GUID for an Individual Partner | CRMT_PARTNER_GUID | RAW | 16 | SYSUUID | ||||
REF_PARTNER_NO | Partner Number for Use Outside Partner Processing | CRMT_PARTNER_NUMBER | CHAR | 16 | ALPHA | CRM_PARTNER_NUMBER | |||
ADDR_NR | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
ADDR_NP | Person number | AD_PERSNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_PERSNUM | CDT | ADDRESS |
ADDR_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | AD_ADRTYPE | CHAR | 1 | AD_ADRTYPE | ||||
ADDR_ORIGIN | Origin of a Partner Address | CRMT_ADDR_ORIGIN_MD | CHAR | 1 | CRM_ADDR_ORIGIN_MD | ||||
STD_BP_ADDRESS | Standard Business Partner Address (Depending on Addr.Type) | CRMT_PARTNER_STD_BP_ADDRESS | CHAR | 1 | XFELD | ||||
ADDR_OPERATION | Transaction for BP Address Determination | BU_OPERATION | CHAR | 6 | Assigned to domain | BU_OPERATION | |||
ADDR_NR_SEND | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
ADDR_NP_SEND | Person number | AD_PERSNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_PERSNUM | CDT | ADDRESS |
PRODUCT | Internal Unique ID of Product | COMT_PRODUCT_GUID | RAW | 16 | SYSUUID | ||||
ORDERED_PROD | Product Name Entered | CRMT_ORDERED_PROD | CHAR | 54 | CRM_ORDERED_PROD | CRM_ORDERED_PRODUCT | |||
PARTNER_PROD | Product Number of Business Partner | CRMT_ITEM_DESCR_PARTNER | CHAR | 40 | PRSHTEXT40 | ||||
DATE_FROM | Start Date | SC_DATEFRO | DATS | 8 | DATUM | ||||
TIMESTAMP_FROM | Time Stamp (Date and Time) of a Date/Duration | CRMT_DATE_TIMESTAMP_FROM | DEC | 15 | TSTPS | BCOS_TSTMP | |||
TIMEZONE_FROM | Time Zone for a Start Time | CRMT_TIMEZONE_FROM | CHAR | 6 | Assigned to domain | TZNZONE | |||
IBIB_GUID | Global Unique Identifier | SMO_GUID | CHAR | 32 | SMO_GUID | ||||
IBASE | IBase: Number of the Installed Base/IBase | IB_IBASE | NUMC | 18 | ALPHA | IB_INSTANCE | IIB | IBIBM | |
IB_COMP_REF_GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW | 16 | SYSUUID | ||||
IB_INSTANCE | IB: Component (instance) | IB_INSTANCE | NUMC | 18 | ALPHA | IB_INSTANCE | IBC | ||
IOBJECT_ID | Object ID | COMT_PRODUCT_OBJECT_ID | CHAR | 40 | PRID1 | COM_PRODUCT_ID | COM_IND_OBJECT_COLLECTION | ||
SETTL_FROM | Start of Settlement for Period | CRMT_SETTL_FROM | DEC | 15 | TSTPS | BCOS_TSTMP | |||
SETTL_TO | End of Settlement for Period | CRMT_SETTL_TO | DEC | 15 | TSTPS | BCOS_TSTMP | |||
CHANNEL | Reading Reminder Output Channel | CRMT_UBB_CHANNEL | CHAR | 8 | CRMC_UBB_OUT_CHA | CRM_UBB_CHANNEL | |||
OUT_MEDIA | Reading Reminder Messaging Medium | CRMT_UBB_OUT_MEDIA | CHAR | 8 | CRM_UBB_OUT_MEDIA | ||||
PARTNER_FCT | Partner Function | COMT_PARTNER_FCT | CHAR | 8 | COM_PARTNER_FCT | ||||
FORMNAME | Smart Forms: Form Name | TDSFNAME | CHAR | 30 | Assigned to domain | TDSFNAME | SSFNAME | ||
PROCESSED | Reading Reminder Created | CRMT_UBB_RR_PROCESSED | CHAR | 1 | CRMT_UBB_RR_PROCESSED | ||||
PRO_ERROR | Logical Variable | CRMT_BOOLEAN | CHAR | 1 | CRM_BOOLEAN | ||||
SEQUENCE | Message Sequence for Reading Reminder | CRMT_UBB_SEQUENCE | CHAR | 4 | Assigned to domain | CRM_UBB_SEQUENCE | |||
SEQ_ORDER | Sequence for Reading Reminder | CRMT_UBB_SEQ_ORDER | NUMC | 3 | CRM_UBB_SEQ_ORDER | ||||
CONTRACT_ID | Transaction ID | CRMT_OBJECT_ID | CHAR | 10 | ALPHA | CRM_OBJECT_ID | CRM_OBJECT_ID | CRM_ORDER_OBJECT_ID | |
CONTRACT_ITEM | Item Number in Document | CRMT_ITEM_NO | NUMC | 10 | CRM_ITEM_NO | ||||
POOL_CONTRACT_ID | Transaction ID | CRMT_OBJECT_ID | CHAR | 10 | ALPHA | CRM_OBJECT_ID | CRM_OBJECT_ID | CRM_ORDER_OBJECT_ID | |
POOL_CONTRACT_IT | Item Number in Document | CRMT_ITEM_NO | NUMC | 10 | CRM_ITEM_NO |
Key field | Non-key field |
How do I retrieve data from SAP table CRMD_UBB_NOTIF_H using ABAP code
The following ABAP code Example will allow you to do a basic selection on CRMD_UBB_NOTIF_H to SELECT all data from the tableDATA: WA_CRMD_UBB_NOTIF_H TYPE CRMD_UBB_NOTIF_H.
SELECT SINGLE *
FROM CRMD_UBB_NOTIF_H
INTO CORRESPONDING FIELDS OF WA_CRMD_UBB_NOTIF_H
WHERE...
How to access SAP table CRMD_UBB_NOTIF_H
Within an ECC or HANA version of SAP you can also view further information about CRMD_UBB_NOTIF_H and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects