So we all know that S/4Hana is the latest version and the future of SAP but what about the tables we are familiar with, are they still available and what do tables like CRMD_UBB_NOTIF_H look like in an S4Hana SAP system. If you havent seen or logged into an S/4Hana system you might be surprise how similar it looks to the previous ERP/ECC version. Infact when using using the gui it is difficult to tell the difference, and for many of database tables the same is true.
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 | |||||
GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | |||||||
CREATED_AT | COMT_CREATED_AT_USR | DEC | 15(0) | Created At (Output in User Time Zone) | COM_TSTMP | |||||||
CREATED_BY | CRMT_CREATED_BY | CHAR | 12(0) | User that Created the Transaction | UNAME | USER_ADDR | BNAME | |||||
CHANGED_AT | COMT_CHANGED_AT_USR | DEC | 15(0) | Changed At (Output in User Time Zone) | COM_TSTMP | |||||||
CHANGED_BY | CRMT_CHANGED_BY | CHAR | 12(0) | Transaction Last Changed By | UNAME | |||||||
HEADER | CRMT_ITEM_GUID | RAW | 16(0) | Item GUID for a CRM Document | SYSUUID | |||||||
ITEM | CRMT_ITEM_GUID | RAW | 16(0) | Item GUID for a CRM Document | SYSUUID | |||||||
PARTNER_GUID | CRMT_PARTNER_GUID | RAW | 16(0) | GUID for an Individual Partner | SYSUUID | |||||||
REF_PARTNER_NO | CRMT_PARTNER_NUMBER | CHAR | 20(0) | Partner Number for Use Outside Partner Processing | CRM_PARTNER_NUMBER | |||||||
ADDR_NR | AD_ADDRNUM | CHAR | 10(0) | * | Address Number | AD_ADDRNUM | ADR | |||||
ADDR_NP | AD_PERSNUM | CHAR | 10(0) | Person number | AD_PERSNUM | CDT | ADDRESS | PERSNUMBER | ||||
ADDR_TYPE | AD_ADRTYPE | CHAR | 1(0) | Address type (1=Organization, 2=Person, 3=Contact person) | AD_ADRTYPE | |||||||
ADDR_ORIGIN | CRMT_ADDR_ORIGIN_MD | CHAR | 1(0) | Origin of a Partner Address | CRM_ADDR_ORIGIN_MD | |||||||
STD_BP_ADDRESS | CRMT_PARTNER_STD_BP_ADDRESS | CHAR | 1(0) | Standard Business Partner Address (Depending on Addr.Type) | XFELD | |||||||
ADDR_OPERATION | BU_OPERATION | CHAR | 6(0) | * | Transaction for BP Address Determination | BU_OPERATION | ||||||
ADDR_NR_SEND | AD_ADDRNUM | CHAR | 10(0) | * | Address Number | AD_ADDRNUM | ADR | |||||
ADDR_NP_SEND | AD_PERSNUM | CHAR | 10(0) | Person number | AD_PERSNUM | CDT | ADDRESS | PERSNUMBER | ||||
PRODUCT | COMT_PRODUCT_GUID | RAW | 16(0) | Internal Unique ID of Product | SYSUUID | |||||||
ORDERED_PROD | CRMT_ORDERED_PROD | CHAR | 54(0) | Product Name Entered | CRM_ORDERED_PROD | CRM_ORDERED_PRODUCT | PRODUCT_ID | |||||
PARTNER_PROD | CRMT_ITEM_DESCR_PARTNER | CHAR | 40(0) | Product Number of Business Partner | PRSHTEXT40 | |||||||
DATE_FROM | SC_DATEFRO | DATS | 8(0) | Start Date | DATUM | |||||||
TIMESTAMP_FROM | CRMT_DATE_TIMESTAMP_FROM | DEC | 15(0) | Time Stamp (Date and Time) of a Date/Duration | BCOS_TSTMP | |||||||
TIMEZONE_FROM | CRMT_TIMEZONE_FROM | CHAR | 6(0) | * | Time Zone for a Start Time | TZNZONE | ||||||
IBIB_GUID | SMO_GUID | CHAR | 32(0) | Global Unique Identifier | SMO_GUID | |||||||
IBASE | IB_IBASE | NUMC | 18(0) | IBase: Number of the Installed Base/IBase | IB_INSTANCE | IIB | IBIBM | IBASE | ||||
IB_COMP_REF_GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | |||||||
IB_INSTANCE | IB_INSTANCE | NUMC | 18(0) | IB: Component (instance) | IB_INSTANCE | IBC | ||||||
IOBJECT_ID | COMT_PRODUCT_OBJECT_ID | CHAR | 40(0) | Object ID | COM_PRODUCT_ID | COM_IND_OBJECT_COLLECTION | OBJECT_ID | |||||
IOBJECT_GUID | COMT_PRODUCT_GUID | RAW | 16(0) | Internal Unique ID of Product | SYSUUID | |||||||
SETTL_FROM | CRMT_SETTL_FROM | DEC | 15(0) | Start of Settlement for Period | BCOS_TSTMP | |||||||
SETTL_TO | CRMT_SETTL_TO | DEC | 15(0) | End of Settlement for Period | BCOS_TSTMP | |||||||
CHANNEL | CRMT_UBB_CHANNEL | CHAR | 8(0) | CRMC_UBB_OUT_CHA | Reading Reminder Output Channel | CRM_UBB_CHANNEL | ||||||
OUT_MEDIA | CRMT_UBB_OUT_MEDIA | CHAR | 8(0) | Reading Reminder Messaging Medium | CRM_UBB_OUT_MEDIA | |||||||
PARTNER_FCT | COMT_PARTNER_FCT | CHAR | 8(0) | Partner Function | COM_PARTNER_FCT | |||||||
FORMNAME | TDSFNAME | CHAR | 30(0) | * | Smart Forms: Form Name | TDSFNAME | SSFNAME | |||||
PROCESSED | CRMT_UBB_RR_PROCESSED | CHAR | 1(0) | Reading Reminder Created | CRMT_UBB_RR_PROCESSED | |||||||
PRO_ERROR | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | |||||||
SEQUENCE | CRMT_UBB_SEQUENCE | CHAR | 4(0) | * | Message Sequence for Reading Reminder | CRM_UBB_SEQUENCE | ||||||
SEQ_ORDER | CRMT_UBB_SEQ_ORDER | NUMC | 3(0) | Sequence for Reading Reminder | CRM_UBB_SEQ_ORDER | |||||||
CONTRACT_ID | CRMT_OBJECT_ID | CHAR | 10(0) | Transaction ID | CRM_OBJECT_ID | CRM_OBJECT_ID | CRM_ORDER_OBJECT_ID | OBJECT_ID | ||||
CONTRACT_ITEM | CRMT_ITEM_NO | NUMC | 10(0) | Item Number in Document | CRM_ITEM_NO | |||||||
POOL_CONTRACT_ID | CRMT_OBJECT_ID | CHAR | 10(0) | Transaction ID | CRM_OBJECT_ID | CRM_OBJECT_ID | CRM_ORDER_OBJECT_ID | OBJECT_ID | ||||
POOL_CONTRACT_IT | CRMT_ITEM_NO | NUMC | 10(0) | Item Number in Document | CRM_ITEM_NO |