In this post, I will try and describe everything you need to know about the SAP crmd_ubb_vol_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_UBB_VOL_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_UBB_VOL_I....Right lets get started!
Object Name: CRMD_UBB_VOL_I
Dictionary Type: Transparent table
Description: UBB Vol_i DB Objects
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 | ||||||
ERROR_FLAG | CRMT_BOOLEAN | CHAR | 1(0) | Logical Variable | CRM_BOOLEAN | CRM | ||||||
ITEM_GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | 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 | ||||||
BILLING_TIMEZONE | CRMT_BILLING_TIMEZONE | CHAR | 6(0) | * | Time Zone of Billing Plan Set | TZNZONE | CRM | |||||
IDENTIFIER | CRMT_VOL_DOC_NO | NUMC | 10(0) | Number of Extension Entry | CRM_ITEM_NO | CRM | ||||||
USAGEFCT | CRMT_UBB_USAGEFCT | CHAR | 4(0) | CRMC_UBB_USG_FCT | Usage Function | CRM_UBB_USAGEFCT | CRM | |||||
MEAS_POINT_GUID | CRMT_MPK_OBJECT_GUID | RAW | 16(0) | GUID of a Kernel Object | SYSUUID | CRM | ||||||
MEAS_POINT_ID | CRMT_MPK_OBJECT_ID_MPOINT | CHAR | 20(0) | Counter Identifier | CRM_MPK_OBJECT_ID_MPOINT | CRM_MPK_MP_ID | CRMH_MPK_MPOINT | OBJECT_ID | CRM | |||
READING_GUID | CRMT_MPK_OBJECT_GUID | RAW | 16(0) | GUID of a Kernel Object | SYSUUID | CRM | ||||||
READING_ID | CRMT_MPK_OBJECT_ID_READING | CHAR | 20(0) | Reading Number | CRM_MPK_OBJECT_ID_READING | CRM_MPK_RD_ID | CRMH_MPK_READING | OBJECT_ID | CRM | |||
READING_DATE | CRMT_UBB_VOL_I_END_TIMESTAMPD | DEC | 15(0) | Reading Date | BCOS_TSTMP | CRM | ||||||
READING_TMZN | CRMT_UBB_VOL_I_END_TIMEZONE | CHAR | 6(0) | * | Time Zone of Ending Value | TZNZONE | CRM | |||||
READING_VAL | CRMT_UBB_VOL_I_END_VALUE_FLTP | FLTP | 16(16) | Value at End of Time Interval in Database Format | CRM_MPK_FLTPS | CRM | ||||||
READING_ORIG | CRMT_UBB_VOL_I_END_ORIGIN | CHAR | 1(0) | Origin of Ending Value | CRM_UBB_READING_ORIGIN | CRM | ||||||
PRI_READING_GUID | CRMT_MPK_OBJECT_GUID | RAW | 16(0) | GUID of a Kernel Object | SYSUUID | CRM | ||||||
PRI_READING_ID | CRMT_UBB_VOL_ID_READING_PRI | CHAR | 20(0) | Number of Previous Reading | CRM_MPK_OBJECT_ID_READING | CRM | ||||||
PRI_READING_DATE | CRMT_UBB_VOL_I_START_TIMESTAMP | DEC | 15(0) | Date for Initial Value | BCOS_TSTMP | CRM | ||||||
PRI_READING_TMZN | CRMT_UBB_VOL_I_START_TIMEZONE | CHAR | 6(0) | * | Time Zone of Starting Value | TZNZONE | CRM | |||||
PRI_READING_VAL | CRMT_UBB_VOL_I_START_VALUE_FLT | FLTP | 16(16) | Value at Start of Period Interval in Database Format | CRM_MPK_FLTPS | CRM | ||||||
PRI_READING_ORIG | CRMT_UBB_VOL_I_START_ORIGIN | CHAR | 1(0) | Origin of Starting Value | CRM_UBB_READING_ORIGIN | CRM | ||||||
UNIT | CRMT_UBB_VOL_I_UNIT | UNIT | 3(0) | * | Unit of Measurement for Volumes | MEINS | H_T006_USAGE | MSEHI | CRM | |||
QUANTITY | CRMT_CUM_QUAN | QUAN | 15(3) | CRM Quantity for Cumulated I | CRM_MENGV15 | CRM | ||||||
DECIMALS | CRMT_MPK_DECIMALS | INT2 | 5(0) | Number of Decimal Places in a Counter | CRM_MPK_DECIMALS | CRM | ||||||
STATUS_PROCESS | CRMT_UBB_VOL_I_STATUS_PROCESS | CHAR | 1(0) | Status of Usage Volume Document | CRMT_UBB_VOL_I_STATUS_PROCESS | CRM | ||||||
STATUS_POOL | CRMT_UBB_VOL_I_STATUS_POOL | CHAR | 1(0) | Prebilling Status of Pool Contracts | CRM_BOOLEAN | CRM | ||||||
MERGED | CRMT_UBB_MERGED | CHAR | 1(0) | Several Periods Merged | CRM_BOOLEAN | CRM | ||||||
PERIOD_TYPE | CRMT_PERIOD_TYPE | CHAR | 2(0) | * | Period Type (First, Last, First and Last, etc.) | CRM_PERIOD_TYPE | CRM |