CRMA_BILLPLAN_D SAP (Billing Plan - Dates) Structure details
Description: Billing Plan - Dates
Related tables to CRMA_BILLPLAN_D
Access table CRMA_BILLPLAN_D
Structure field list including key, data, relationships and ABAP select examples
CRMA_BILLPLAN_D is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Billing Plan - Dates" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_CRMA_BILLPLAN_D TYPE CRMA_BILLPLAN_D.
The CRMA_BILLPLAN_D table consists of various fields, each holding specific information or linking keys about Billing Plan - Dates data available in SAP. These include CLIENT (Client), GUID (32 Character CRM Object GUID (Converted)), NUMBER_INT (Billing Plan: Internal Sort Order), FIN_VIEW (Financing View).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP CRMA_BILLPLAN_D structure 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 | 32 Character CRM Object GUID (Converted) | CRMT_OBJECT_GUID32 | CHAR | 32 | |||||
NUMBER_INT | Billing Plan: Internal Sort Order | CRMT_BILL_NUMBER_INT | NUMC | 10 | |||||
FIN_VIEW | Financing View | CRMT_FINANCING_VIEW | NUMC | 2 | Assigned to domain | CRMT_FINANCING_VIEW | |||
SCHED_IND | Schedule Line Indicator for Billing Plan | CRMT_SCHED_INDICATOR | CHAR | 1 | CRM_SCHED_INDICATOR | ||||
BILLPLAN_GUID | 32 Character CRM Object GUID (Converted) | CRMT_OBJECT_GUID32 | CHAR | 32 | |||||
PERIOD_DATE | Period Date | CRMT_PERIOD_DATE | DEC | 15 | TSTPS | BCOS_TSTMP | |||
RULE_PERIOD_DATE | Rule for Determining the Period Date | CRMT_RULE_PERIOD_DATE | RAW | 16 | Assigned to domain | TIMERULEID | |||
SETTL_FROM | Start of Settlement for Period | CRMT_SETTL_FROM | DEC | 15 | TSTPS | BCOS_TSTMP | |||
RULE_SETTL_FROM | Rule for Determining Start of Settlement Period | CRMT_RULE_SETTL_FROM | RAW | 16 | Assigned to domain | TIMERULEID | |||
SETTL_TO | End of Settlement for Period | CRMT_SETTL_TO | DEC | 15 | TSTPS | BCOS_TSTMP | |||
RULE_SETTL_TO | Rule for Determining End of Settlement Period | CRMT_RULE_SETTL_TO | RAW | 16 | Assigned to domain | TIMERULEID | |||
BILL_DATE | Billing Date for Billing Index and Printout | CRMT_BILL_DATE | DEC | 15 | TSTPS | BCOS_TSTMP | |||
RULE_BILL_DATE | Rule for Determining the Next Billing Date | CRMT_RULE_BILL_DATE | RAW | 16 | Assigned to domain | TIMERULEID | |||
INVCR_DATE | Billing Document Creation Date | CRMT_INVCR_DATE | DEC | 15 | TSTPS | BCOS_TSTMP | |||
RULE_INVCR_DATE | Rule for Determining Next Billing Document Creation Date | CRMT_RULE_INVCR_DATE | RAW | 16 | Assigned to domain | TIMERULEID | |||
VALUE_DATE | Fixed Value Date | CRMT_VALUE_DATE | DEC | 15 | TSTPS | BCOS_TSTMP | |||
RULE_VALUE_DATE | Rule for Origin of Next Fixed Value Date | CRMT_RULE_VALUE_DATE | RAW | 16 | Assigned to domain | TIMERULEID | |||
BILLING_TIMEZONE | Time Zone of Billing Plan Set | CRMT_BILLING_TIMEZONE | CHAR | 6 | TTZZ | TZNZONE | |||
PERCENTAGE | Percentage of Value to be Billed | CRMT_BILL_PERCENTAGE | DEC | 5(2) | DEC3_2 | ||||
BILL_VALUE | Value to be Billed on Date Specified in Billing Plan | CRMT_BILL_VALUE | CURR | 19(2) | PRC_COND_VALUE | ||||
CURRENCY | Currency | CRMT_CURRENCY | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
NO_OF_PERIODS | Number of Periods in Billing Plan | CRMT_NO_OF_PERIODS | NUMC | 5 | |||||
CASHFLOW_TYPE | Flow Category | CRMT_CASHFLOW_TYPE | CHAR | 4 | CRMT_CASHFLOW_TYPE | ||||
KIND_PERIOD_DATE | Date type | TIMENAEVEN | CHAR | 12 | Assigned to domain | SC_APPTTYP | TIMENAEV | ||
KIND_SETTL_FROM | Date type | TIMENAEVEN | CHAR | 12 | Assigned to domain | SC_APPTTYP | TIMENAEV | ||
KIND_SETTL_TO | Date type | TIMENAEVEN | CHAR | 12 | Assigned to domain | SC_APPTTYP | TIMENAEV | ||
KIND_BILL_DATE | Date type | TIMENAEVEN | CHAR | 12 | Assigned to domain | SC_APPTTYP | TIMENAEV | ||
KIND_INVCR_DATE | Date type | TIMENAEVEN | CHAR | 12 | Assigned to domain | SC_APPTTYP | TIMENAEV | ||
KIND_VALUE_DATE | Date type | TIMENAEVEN | CHAR | 12 | Assigned to domain | SC_APPTTYP | TIMENAEV | ||
KIND_START_DATE | Date type | TIMENAEVEN | CHAR | 12 | Assigned to domain | SC_APPTTYP | TIMENAEV | ||
KIND_END_DATE | Date type | TIMENAEVEN | CHAR | 12 | Assigned to domain | SC_APPTTYP | TIMENAEV | ||
KIND_DATE_FROM | Date type | TIMENAEVEN | CHAR | 12 | Assigned to domain | SC_APPTTYP | TIMENAEV | ||
KIND_DATE_TO | Date type | TIMENAEVEN | CHAR | 12 | Assigned to domain | SC_APPTTYP | TIMENAEV | ||
PER_PAYMENTFORM | When Due in Period | CRMT_PER_PAYMENTFORM | NUMC | 1 | Assigned to domain | CRMT_PAYMENTFORM | |||
UNIT_PERIODS | Time Unit for Periods | CRMT_UNIT_PERIODS | NUMC | 2 | TFMSINSTALLMENT | ||||
MAN_FIRSTDUEDATE | Individual Due Date | CRMT_MAN_FIRSTDUEDATE | DEC | 15 | TSTPS | BCOS_TSTMP | |||
NOMINAL_INT_RATE | Nominal Interest Rate | CRMT_NOMINAL_INT_RATE | DEC | 10(7) | DECV3_7 | ||||
NOMINAL_IRAT_INT | Nominal Interest Rate (Internal Plan) | CRMT_NOMINAL_INT_RATE_INT | DEC | 10(7) | DECV3_7 | ||||
DEFAULT_AMOUNT | Default Amount | CRMT_DEFAULT_AMOUNT | CURR | 19(2) | CRMT_COND_VALUE | ||||
DEFAULT_PERCENT | Default Percentage | CRMT_DEFAULT_PERCENTAGE | DEC | 10(7) | DECV3_7 | ||||
DEF_RATEPERX | Default Rate per x | CRMT_DEFAULT_RATEPERK | DEC | 17(10) | CRMT_DECV7_10 | ||||
FREQ_CONVERSION | Payment Frequency Factor | CRMT_FREQ_CONVERSION | DEC | 6 | TFM_PPAYMENT_INTERN | ||||
CALCULATION_DATE | Calculation date | CRMT_CALCULATION_DATE | DEC | 15 | TSTPS | BCOS_TSTMP | |||
FLAG_ULTIMO | Do Not Draw Standard Values from Conditions | CRMT_FLAG_ULTIMO | CHAR | 1 | XFELD | ||||
FLAG_BLOCKED | Calculation Locked | CRMT_FLAG_BLOCKED | CHAR | 1 | XFELD | ||||
STEP_KIND | Payment Structure/Change to Principal Indicator | CRMT_STEP_KIND | NUMC | 2 | CRMT_STEP_KIND | ||||
FIXING | Field Control Billplan_d Rows (Fixed/Changeable) | CRMT_STEP_FIXING | NUMC | 2 | CRMT_FINPROD_FIX01 | ||||
SETTL_FROM_VIRTU | Virtual Start of Settlement of Period | CRMT_SETTL_FROM_FIMA | DEC | 15 | TSTPS | BCOS_TSTMP | |||
DATEUPD_SUPPRESS | No Date Update (FIMA) | CRMT_DATEUPD_SUPPRESS | CHAR | 1 | CRMT_DATEUPD_SUPPRESS | ||||
OFFSET_VAL | Offset | CRMT_FINPROD_OFFS01 | DEC | 5 | DEC5 | ||||
OFFSET_UNIT | Offset Unit | CRMT_FINPROD_OFFSU01 | CHAR | 12 | Assigned to domain | TIMEUNITNA | |||
SETTLED | Settled Payment Step | CRMT_FIMAN_SETTLED | CHAR | 1 | CRMT_FIMAN_SETTLED | ||||
FACTOR1 | Factor | CRMT_FIMAN_FACTOR | DEC | 15(10) | DECV5_10 | ||||
FACTOR2 | Factor | CRMT_FIMAN_FACTOR | DEC | 15(10) | DECV5_10 | ||||
FACTOR3 | Factor | CRMT_FIMAN_FACTOR | DEC | 15(10) | DECV5_10 | ||||
RESULT_AMOUNT | Resulting Amount | CRMT_RESULT_AMOUNT | CURR | 19(2) | CRMT_COND_VALUE | ||||
RESULT_AMOUNT_PR | Unrounded Result Amount | CRMT_AMOUNT_PRECISE | CURR | 19(2) | CRMT_COND_VALUE | ||||
RPX_DIVISOR | Divisor for Rate per x Determination | CRMT_RPXDIV | CURR | 19(2) | CRMT_COND_VALUE | ||||
RESULT_RATEPERK | Rate per x | CRMT_RESULT_RATEPERK | DEC | 17(10) | CRMT_DECV7_10 | ||||
RESULT_RATE_K_G | Gross Rate per X | CRMT_RESULT_RATEPERK_G | DEC | 17(10) | CRMT_DECV7_10 |
Key field | Non-key field |
How do I retrieve data from SAP structure CRMA_BILLPLAN_D using ABAP code?
As CRMA_BILLPLAN_D is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CRMA_BILLPLAN_D as there is no data to select.How to access SAP table CRMA_BILLPLAN_D
Within an ECC or HANA version of SAP you can also view further information about CRMA_BILLPLAN_D 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