SAP ABAP Table CRMT_2500_BILLPLAN_UI (CRM: Milestone Billing - Billing Plan)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BTX-BF-BPL (Application Component) Billing Plan
⤷ CRM_BILLPLAN (Package) CRM Billing Plan
⤷ CRM-BTX-BF-BPL (Application Component) Billing Plan
⤷ CRM_BILLPLAN (Package) CRM Billing Plan
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMT_2500_BILLPLAN_UI | Table Relationship Diagram |
Short Description | CRM: Milestone Billing - Billing Plan |
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 | Billing Plan Dates | |||||
2 | .INCLUDE | 0 | 0 | Management of Interface Structures | |||||
3 | GUID | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
4 | HANDLE | CRMT_HANDLE | NUMC | 10 | 0 | Handle | |||
5 | .INCLUDE | 0 | 0 | External Fields for Billing Plan | |||||
6 | BILLPLAN_TYPE | CRMT_BILLPLAN_TYPE | CRM_BILLPLAN_TYPE | CHAR | 2 | 0 | Billing Plan Type | * | |
7 | REFERENCE_NO | CRMT_REFERENCE_NO | CRM_REFERENCE_BILLPLAN | CHAR | 10 | 0 | Reference Billing Plan Number | ||
8 | RULE_HORIZON | CRMT_RULE_HORIZON | TIMERULEID | RAW | 16 | 0 | Rule for Determining Horizon in Billing Plan | * | |
9 | START_DATE | CRMT_START_DATE | BCOS_TSTMP | DEC | 15 | 0 | Start Date of Billing Plan | ||
10 | RULE_START_DATE | CRMT_RULE_START_DATE | TIMERULEID | RAW | 16 | 0 | Rule for Determining Billing Plan Start Date | * | |
11 | END_DATE | CRMT_END_DATE | BCOS_TSTMP | DEC | 15 | 0 | End Date of Billing Plan | ||
12 | RULE_END_DATE | CRMT_RULE_END_DATE | TIMERULEID | RAW | 16 | 0 | Rule for Determining Billing Plan End Date | * | |
13 | DATE_FROM | CRMT_DATE_FROM | BCOS_TSTMP | DEC | 15 | 0 | Dates From | ||
14 | RULE_DATE_FROM | CRMT_RULE_DATE_FROM | TIMERULEID | RAW | 16 | 0 | Rule for Determining Dates from | * | |
15 | DATE_TO | CRMT_DATE_TO | BCOS_TSTMP | DEC | 15 | 0 | Dates To | ||
16 | RULE_DATE_TO | CRMT_RULE_DATE_TO | TIMERULEID | RAW | 16 | 0 | Rule for Determining Dates To | * | |
17 | BILLING_TIMEZONE | CRMT_BILLING_TIMEZONE | TZNZONE | CHAR | 6 | 0 | Time Zone of Billing Plan Set | * | |
18 | BILLPLAN_MODE | CRMT_MODE | CRM_MODE | CHAR | 1 | 0 | Processing Mode of Transaction | ||
19 | DATE_HORIZON | CRMT_DATE_HORIZON | BCOS_TSTMP | DEC | 15 | 0 | Horizon in Billing Plan | ||
20 | DATE_HORIZ_TZTF | CRMT_DATE_HORIZ_TZTF | TZTF_IO_FIELD | CHAR | 26 | 0 | Horizon in Billing Plan | ||
21 | RULE_HORIZON_T | CRMT_RULE_HORIZON_T | TIMENAME | CHAR | 12 | 0 | Rule for Determining Horizon in Billing Plan | TIMERUNA | |
22 | BILLPLAN_TYPE_T | CRMT_DESCRIPTION_40 | TEXT40 | CHAR | 40 | 0 | Description (40 Characters) | ||
23 | START_DATE_TZTF | CRMT_START_DATE_TZTF | TZTF_IO_FIELD | CHAR | 26 | 0 | Start Date of Billing Plan | ||
24 | END_DATE_TZTF | CRMT_END_DATE_TZTF | TZTF_IO_FIELD | CHAR | 26 | 0 | End Date of Billing Plan | ||
25 | DATE_FROM_TZTF | CRMT_DATE_FROM_TZTF | TZTF_IO_FIELD | CHAR | 26 | 0 | Dates From | ||
26 | DATE_TO_TZTF | CRMT_DATE_TO_TZTF | TZTF_IO_FIELD | CHAR | 26 | 0 | Dates To | ||
27 | RULE_STA_DATE_T | CRMT_RULE_START_DATE_T | TIMENAME | CHAR | 12 | 0 | Rule for Determining Billing Plan Start Date | TIMERUNA | |
28 | RULE_END_DATE_T | CRMT_RULE_END_DATE_T | TIMENAME | CHAR | 12 | 0 | Rule for Determining Billing Plan End Date | TIMERUNA | |
29 | RULE_DATE_FROM_T | CRMT_RULE_DATE_FROM_T | TIMENAME | CHAR | 12 | 0 | Rule for determining dates from | TIMERUNA | |
30 | RULE_DATE_TO_T | CRMT_RULE_DATE_TO_T | TIMENAME | CHAR | 12 | 0 | Rule for Determining Dates to | TIMERUNA | |
31 | DESCRIPTION | CRMT_DESCRIPTION | TEXT40 | CHAR | 40 | 0 | Description | ||
32 | NET_VALUE | CRMT_NET_VALUE | WERTV8 | CURR | 15 | 2 | Net Value | ||
33 | BILL_VALUE | CRMT_BILL_VALUE | CRM_COND_VALUE | CURR | 19 | 2 | Value to be Billed on Date Specified in Billing Plan | ||
34 | CURRENCY | CRMT_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
35 | PERCENTAGE | CRMT_BILL_PERCENTAGE | DEC3_2 | DEC | 5 | 2 | Percentage of Value to be Billed |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_2500_BILLPLAN_UI | RULE_DATE_FROM_T | TIMERUNA | RULE_NAME | REF | 1 | CN |
2 | CRMT_2500_BILLPLAN_UI | RULE_DATE_TO_T | TIMERUNA | RULE_NAME | REF | 1 | CN |
3 | CRMT_2500_BILLPLAN_UI | RULE_END_DATE_T | TIMERUNA | RULE_NAME | REF | 1 | CN |
4 | CRMT_2500_BILLPLAN_UI | RULE_HORIZON_T | TIMERUNA | RULE_NAME | REF | 1 | CN |
5 | CRMT_2500_BILLPLAN_UI | RULE_STA_DATE_T | TIMERUNA | RULE_NAME | REF | 1 | CN |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 400 |