SAP ABAP Table CRMD_BILLPLAN_D (Billing Plan Date)
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 | TRANSP | Transparent table |
Transparent table | CRMD_BILLPLAN_D | Table Relationship Diagram |
Short Description | Billing Plan Date |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | One Order: Key Fields | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | GUID | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
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 | TTZZ | |
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 | Billing Plan Deadline: Internal Fields | |||||
53 | .INCLUDE | 0 | 0 | Date Fields at Deadline Level: Internal Part | |||||
54 | KIND_PERIOD_DATE | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
55 | KIND_SETTL_FROM | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
56 | KIND_SETTL_TO | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
57 | KIND_BILL_DATE | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
58 | KIND_INVCR_DATE | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
59 | KIND_VALUE_DATE | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
60 | KIND_START_DATE | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
61 | KIND_END_DATE | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
62 | KIND_DATE_FROM | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
63 | KIND_DATE_TO | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
64 | .INCLUDE | 0 | 0 | Milestone Billing Plan: Internal Fields | |||||
65 | NUMBER_EXT | CRMT_ITEM_NO_EXT | NUMC | 10 | 0 | External Item Number |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMD_BILLPLAN_D | BILLING_TIMEZONE | TTZZ | TZONE | KEY | 1 | CN |
2 | CRMD_BILLPLAN_D | CURRENCY | TCURC | WAERS | |||
3 | CRMD_BILLPLAN_D | PROC_EVENT_TYPE | CRMC_PE_TYPE | PROC_EVENT_TYPE | KEY | 1 | CN |
4 | CRMD_BILLPLAN_D | PROC_EVENT_TYPE2 | CRMC_PE_TYPE | PROC_EVENT_TYPE | KEY | 1 | CN |
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in | 12A |