The CRMC_PT_DET table in SAP ERP or S/4HANA stores UBB: Define Billing Document Period Type data. There are total 5 fields in CRMC_PT_DET table. The UBB: Define Billing Document Period Type table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRMC_PT_DET table. It is in UBB Billing Plan Enhancement (CRM_BILLPLAN_UBB) ABAP package and is part of the Billing Plan (CRM-BTX-BF-BPL) module.
SAP CRMC_PT_DET Table Fields
Following is the list of fields that are available in SAP CRMC_PT_DET table. The primary key fields of the table are PERIODCAT (Period Type (First, Last, First and Last, etc.)), BPLAN_DATE_TYPE (UBB Billing Plan Date Type), PROC_EVENT_TYPE (UBB Process Event Type), PROC_EVENT_TYPE2 (UBB Process Event Type).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| PERIODCAT | Period Type (First, Last, First and Last, etc.) | CRMT_PERIOD_TYPE | CRMC_PER_TYPE | CHAR (2) |
| BPLAN_DATE_TYPE | UBB Billing Plan Date Type | CRMT_BILLPLAN_DATE_TYPE | NUMC (2) | |
| PROC_EVENT_TYPE | UBB Process Event Type | CRMT_PROCESS_EVENT_TYPE | CRMC_PE_TYPE | CHAR (4) |
| PROC_EVENT_TYPE2 | UBB Process Event Type | CRMT_PROCESS_EVENT_TYPE | CRMC_PE_TYPE | CHAR (4) |
| PERIODTYPE | Period Type (First, Last, First and Last, etc.) | CRMT_PERIOD_TYPE | CRMC_PER_TYPE | CHAR (2) |
