SAP ABAP Table CRMT_BILLPLAN_D_LEAS (Billing Plan Communication Leasing)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BTX-BF-FIN (Application Component) Financing
⤷ CRM_FINANCE_UI (Package) Interface for Payment Schedule
⤷ CRM-BTX-BF-FIN (Application Component) Financing
⤷ CRM_FINANCE_UI (Package) Interface for Payment Schedule
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMT_BILLPLAN_D_LEAS | Table Relationship Diagram |
Short Description | Billing Plan Communication Leasing |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Management of Interface Structures | |||||
2 | GUID | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
3 | HANDLE | CRMT_HANDLE | NUMC | 10 | 0 | Handle | |||
4 | .INCLUDE | 0 | 0 | Billing Plan Deadline: External Fields | |||||
5 | BILLPLAN_GUID | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
6 | .INCLUDE | 0 | 0 | Date Fields at Deadline Level: External Part | |||||
7 | PERIOD_DATE | CRMT_PERIOD_DATE | BCOS_TSTMP | DEC | 15 | 0 | Period Date | ||
8 | RULE_PERIOD_DATE | CRMT_RULE_PERIOD_DATE | TIMERULEID | RAW | 16 | 0 | Rule for Determining the Period Date | * | |
9 | SETTL_FROM | CRMT_SETTL_FROM | BCOS_TSTMP | DEC | 15 | 0 | Start of Settlement for Period | ||
10 | RULE_SETTL_FROM | CRMT_RULE_SETTL_FROM | TIMERULEID | RAW | 16 | 0 | Rule for Determining Start of Settlement Period | * | |
11 | SETTL_TO | CRMT_SETTL_TO | BCOS_TSTMP | DEC | 15 | 0 | End of Settlement for Period | ||
12 | RULE_SETTL_TO | CRMT_RULE_SETTL_TO | TIMERULEID | RAW | 16 | 0 | Rule for Determining End of Settlement Period | * | |
13 | BILL_DATE | CRMT_BILL_DATE | BCOS_TSTMP | DEC | 15 | 0 | Billing Date for Billing Index and Printout | ||
14 | RULE_BILL_DATE | CRMT_RULE_BILL_DATE | TIMERULEID | RAW | 16 | 0 | Rule for Determining the Next Billing Date | * | |
15 | INVCR_DATE | CRMT_INVCR_DATE | BCOS_TSTMP | DEC | 15 | 0 | Billing Document Creation Date | ||
16 | RULE_INVCR_DATE | CRMT_RULE_INVCR_DATE | TIMERULEID | RAW | 16 | 0 | Rule for Determining Next Billing Document Creation Date | * | |
17 | VALUE_DATE | CRMT_VALUE_DATE | BCOS_TSTMP | DEC | 15 | 0 | Fixed Value Date | ||
18 | RULE_VALUE_DATE | CRMT_RULE_VALUE_DATE | TIMERULEID | RAW | 16 | 0 | Rule for Origin of Next Fixed Value Date | * | |
19 | BILLING_TIMEZONE | CRMT_BILLING_TIMEZONE | TZNZONE | CHAR | 6 | 0 | Time Zone of Billing Plan Set | * | |
20 | PERCENTAGE | CRMT_BILL_PERCENTAGE | DEC3_2 | DEC | 5 | 2 | Percentage of Value to be Billed | ||
21 | BILL_VALUE | CRMT_BILL_VALUE | CRM_COND_VALUE | CURR | 19 | 2 | Value to be Billed on Date Specified in Billing Plan | ||
22 | CURRENCY | CRMT_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | TCURC | |
23 | NO_OF_PERIODS | CRMT_NO_OF_PERIODS | NUMC | 5 | 0 | Number of Periods in Billing Plan | |||
24 | NUMBER_INT | CRMT_BILL_NUMBER_INT | NUMC | 10 | 0 | Billing Plan: Internal Sort Order | |||
25 | CASHFLOW_TYPE | CRMT_CASHFLOW_TYPE | CRMT_CASHFLOW_TYPE | CHAR | 4 | 0 | Flow Category | ||
26 | QUANTITY | CRMT_SCHEDLIN_QUAN | MENG13 | QUAN | 13 | 3 | CRM Schedule Line Quantity | ||
27 | QTY_UNIT | CRMT_PROCESS_QTY_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure in Which the Product Is Sold | * | |
28 | NO_BILLITEMS | CRMT_NO_BILLITEMS | XFELD | CHAR | 1 | 0 | Generate Flag for No Billing Request Items | ||
29 | BP_USAGE | CRMT_BP_USAGE | CRMT_BP_USAGE | CHAR | 1 | 0 | Billing Plan Usage | ||
30 | BILLPLAN_LINE_ID | CRMT_BILLPLAN_LINE_ID | CRMT_BILLPLAN_LINE_ID | CHAR | 2 | 0 | ID of Billing Plan Line | ||
31 | START_DATE | CRMT_START_DATE | BCOS_TSTMP | DEC | 15 | 0 | Start Date of Billing Plan | ||
32 | RULE_START_DATE | CRMT_RULE_START_DATE | TIMERULEID | RAW | 16 | 0 | Rule for Determining Billing Plan Start Date | * | |
33 | END_DATE | CRMT_END_DATE | BCOS_TSTMP | DEC | 15 | 0 | End Date of Billing Plan | ||
34 | RULE_END_DATE | CRMT_RULE_END_DATE | TIMERULEID | RAW | 16 | 0 | Rule for Determining Billing Plan End Date | * | |
35 | DATE_FROM | CRMT_DATE_FROM | BCOS_TSTMP | DEC | 15 | 0 | Dates From | ||
36 | RULE_DATE_FROM | CRMT_RULE_DATE_FROM | TIMERULEID | RAW | 16 | 0 | Rule for Determining Dates from | * | |
37 | DATE_TO | CRMT_DATE_TO | BCOS_TSTMP | DEC | 15 | 0 | Dates To | ||
38 | RULE_DATE_TO | CRMT_RULE_DATE_TO | TIMERULEID | RAW | 16 | 0 | Rule for Determining Dates To | * | |
39 | RULE_STA_DATE_T | CRMT_RULE_START_DATE_T | TIMENAME | CHAR | 12 | 0 | Rule for Determining Billing Plan Start Date | ||
40 | RULE_END_DATE_T | CRMT_RULE_END_DATE_T | TIMENAME | CHAR | 12 | 0 | Rule for Determining Billing Plan End Date | ||
41 | RULE_DATE_FROM_T | CRMT_RULE_DATE_FROM_T | TIMENAME | CHAR | 12 | 0 | Rule for determining dates from | ||
42 | RULE_DATE_TO_T | CRMT_RULE_DATE_TO_T | TIMENAME | CHAR | 12 | 0 | Rule for Determining Dates to | ||
43 | BP_SUBTYPE | CRMT_BP_SUBTYPE | CRMT_BP_SUBTYPE | CHAR | 1 | 0 | Billing Plan Subtype | * | |
44 | .INCLUDE | 0 | 0 | External UBB Fields for a Billing Plan Date | |||||
45 | BPLAN_DATE_TYPE | CRMT_BILLPLAN_DATE_TYPE | CRM_BILLPLAN_DATE_TYPE | NUMC | 2 | 0 | UBB Billing Plan Date Type | ||
46 | NO_OF_BLOCK | CRMT_NO_OF_BLOCK | NUMC | 3 | 0 | UBB Pool Assignment | |||
47 | PROC_EVENT_TYPE | CRMT_PROCESS_EVENT_TYPE | CRM_PROCESS_EVENT_TYPE | CHAR | 4 | 0 | UBB Process Event Type | CRMC_PE_TYPE | |
48 | PROC_EVENT_TYPE2 | CRMT_PROCESS_EVENT_TYPE | CRM_PROCESS_EVENT_TYPE | CHAR | 4 | 0 | UBB Process Event Type | CRMC_PE_TYPE | |
49 | RULE_PER_ORIG_T | CRMT_RULE_PERIOD_DATE_T | TIMENAME | CHAR | 12 | 0 | Rule for Determining the Period Date | ||
50 | PERIOD_DURA | TIMEDURA | TIMEDURA | DEC | 13 | 0 | Numerical Value of Duration | ||
51 | PERIOD_UNIT | TIMEUNITDU | TIMEUNITNA | CHAR | 12 | 0 | Default Value for Time Unit | * | |
52 | .INCLUDE | 0 | 0 | External FIMA Fields for a Billing Plan Date | |||||
53 | .INCLUDE | 0 | 0 | External FIMA Field FIN_VIEW for a Billing Plan Date | |||||
54 | FIN_VIEW | CRMT_FINANCING_VIEW | CRMT_FINANCING_VIEW | NUMC | 2 | 0 | Financing View | * | |
55 | SCHED_IND | CRMT_SCHED_INDICATOR | CRM_SCHED_INDICATOR | CHAR | 1 | 0 | Schedule Line Indicator for Billing Plan | ||
56 | .INCLUDE | 0 | 0 | External FIMA Fields for a Billing Plan Date | |||||
57 | PER_PAYMENTFORM | CRMT_PER_PAYMENTFORM | CRMT_PAYMENTFORM | NUMC | 1 | 0 | When Due in Period | * | |
58 | UNIT_PERIODS | CRMT_UNIT_PERIODS | TFMSINSTALLMENT | NUMC | 2 | 0 | Time Unit for Periods | ||
59 | MAN_FIRSTDUEDATE | CRMT_MAN_FIRSTDUEDATE | BCOS_TSTMP | DEC | 15 | 0 | Individual Due Date | ||
60 | NOMINAL_INT_RATE | CRMT_NOMINAL_INT_RATE | DECV3_7 | DEC | 10 | 7 | Nominal Interest Rate | ||
61 | NOMINAL_IRAT_INT | CRMT_NOMINAL_INT_RATE_INT | DECV3_7 | DEC | 10 | 7 | Nominal Interest Rate (Internal Plan) | ||
62 | DEFAULT_AMOUNT | CRMT_DEFAULT_AMOUNT | CRMT_COND_VALUE | CURR | 19 | 2 | Default Amount | ||
63 | DEFAULT_PERCENT | CRMT_DEFAULT_PERCENTAGE | DECV3_7 | DEC | 10 | 7 | Default Percentage | ||
64 | DEF_RATEPERX | CRMT_DEFAULT_RATEPERK | CRMT_DECV7_10 | DEC | 17 | 10 | Default Rate per x | ||
65 | FREQ_CONVERSION | CRMT_FREQ_CONVERSION | TFM_PPAYMENT_INTERN | DEC | 6 | 0 | Payment Frequency Factor | ||
66 | CALCULATION_DATE | CRMT_CALCULATION_DATE | BCOS_TSTMP | DEC | 15 | 0 | Calculation date | ||
67 | FLAG_ULTIMO | CRMT_FLAG_ULTIMO | XFELD | CHAR | 1 | 0 | Do Not Draw Standard Values from Conditions | ||
68 | FLAG_BLOCKED | CRMT_FLAG_BLOCKED | XFELD | CHAR | 1 | 0 | Calculation Locked | ||
69 | STEP_KIND | CRMT_STEP_KIND | CRMT_STEP_KIND | NUMC | 2 | 0 | Payment Structure/Change to Principal Indicator | ||
70 | FIXING | CRMT_STEP_FIXING | CRMT_FINPROD_FIX01 | NUMC | 2 | 0 | Field Control Billplan_d Rows (Fixed/Changeable) | ||
71 | SETTL_FROM_VIRTU | CRMT_SETTL_FROM_FIMA | BCOS_TSTMP | DEC | 15 | 0 | Virtual Start of Settlement of Period | ||
72 | DATEUPD_SUPPRESS | CRMT_DATEUPD_SUPPRESS | CRMT_DATEUPD_SUPPRESS | CHAR | 1 | 0 | No Date Update (FIMA) | ||
73 | OFFSET_VAL | CRMT_FINPROD_OFFS01 | DEC5 | DEC | 5 | 0 | Offset | ||
74 | OFFSET_UNIT | CRMT_FINPROD_OFFSU01 | TIMEUNITNA | CHAR | 12 | 0 | Offset Unit | * | |
75 | SETTLED | CRMT_FIMAN_SETTLED | CRMT_FIMAN_SETTLED | CHAR | 1 | 0 | Settled Payment Step | ||
76 | FACTOR1 | CRMT_FIMAN_FACTOR | DECV5_10 | DEC | 15 | 10 | Factor | ||
77 | FACTOR2 | CRMT_FIMAN_FACTOR | DECV5_10 | DEC | 15 | 10 | Factor | ||
78 | FACTOR3 | CRMT_FIMAN_FACTOR | DECV5_10 | DEC | 15 | 10 | Factor | ||
79 | .INCLUDE | 0 | 0 | External FIMA Result Fields of Date in Reference | |||||
80 | RESULT_AMOUNT | CRMT_RESULT_AMOUNT | CRMT_COND_VALUE | CURR | 19 | 2 | Resulting Amount | ||
81 | RESULT_AMOUNT_PR | CRMT_AMOUNT_PRECISE | CRMT_COND_VALUE | CURR | 19 | 2 | Unrounded Result Amount | ||
82 | RPX_DIVISOR | CRMT_RPXDIV | CRMT_COND_VALUE | CURR | 19 | 2 | Divisor for Rate per x Determination | ||
83 | RESULT_RATEPERK | CRMT_RESULT_RATEPERK | CRMT_DECV7_10 | DEC | 17 | 10 | Rate per x | ||
84 | RESULT_RATE_K_G | CRMT_RESULT_RATEPERK_G | CRMT_DECV7_10 | DEC | 17 | 10 | Gross Rate per X | ||
85 | BILLPLAN_MODE | CRMT_MODE | CRM_MODE | CHAR | 1 | 0 | Processing Mode of Transaction |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_BILLPLAN_D_LEAS | CURRENCY | TCURC | WAERS | |||
2 | CRMT_BILLPLAN_D_LEAS | PROC_EVENT_TYPE | CRMC_PE_TYPE | PROC_EVENT_TYPE | KEY | 1 | CN |
3 | CRMT_BILLPLAN_D_LEAS | PROC_EVENT_TYPE2 | CRMC_PE_TYPE | PROC_EVENT_TYPE | KEY | 1 | CN |
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in | 301 |