SAP ABAP Table BAD_BILLPLAN_D (BAD - Billing plan date)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BTX-BF (Application Component) Basic Functions for Business Transactions
⤷ BAD_ORDER (Package) CRM Order: BAD Objects - General Order Processing
⤷ CRM-BTX-BF (Application Component) Basic Functions for Business Transactions
⤷ BAD_ORDER (Package) CRM Order: BAD Objects - General Order Processing
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | BAD_BILLPLAN_D | Table Relationship Diagram |
Short Description | BAD - Billing plan date |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | GUID | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
3 | .INCLUDE | 0 | 0 | Billing Plan Deadline: External Fields | |||||
4 | BILLPLAN_GUID | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
5 | .INCLUDE | 0 | 0 | Date Fields at Deadline Level: External Part | |||||
6 | PERIOD_DATE | CRMT_PERIOD_DATE | BCOS_TSTMP | DEC | 15 | 0 | Period Date | ||
7 | RULE_PERIOD_DATE | CRMT_RULE_PERIOD_DATE | TIMERULEID | RAW | 16 | 0 | Rule for Determining the Period Date | * | |
8 | SETTL_FROM | CRMT_SETTL_FROM | BCOS_TSTMP | DEC | 15 | 0 | Start of Settlement for Period | ||
9 | RULE_SETTL_FROM | CRMT_RULE_SETTL_FROM | TIMERULEID | RAW | 16 | 0 | Rule for Determining Start of Settlement Period | * | |
10 | SETTL_TO | CRMT_SETTL_TO | BCOS_TSTMP | DEC | 15 | 0 | End of Settlement for Period | ||
11 | RULE_SETTL_TO | CRMT_RULE_SETTL_TO | TIMERULEID | RAW | 16 | 0 | Rule for Determining End of Settlement Period | * | |
12 | BILL_DATE | CRMT_BILL_DATE | BCOS_TSTMP | DEC | 15 | 0 | Billing Date for Billing Index and Printout | ||
13 | RULE_BILL_DATE | CRMT_RULE_BILL_DATE | TIMERULEID | RAW | 16 | 0 | Rule for Determining the Next Billing Date | * | |
14 | INVCR_DATE | CRMT_INVCR_DATE | BCOS_TSTMP | DEC | 15 | 0 | Billing Document Creation Date | ||
15 | RULE_INVCR_DATE | CRMT_RULE_INVCR_DATE | TIMERULEID | RAW | 16 | 0 | Rule for Determining Next Billing Document Creation Date | * | |
16 | VALUE_DATE | CRMT_VALUE_DATE | BCOS_TSTMP | DEC | 15 | 0 | Fixed Value Date | ||
17 | RULE_VALUE_DATE | CRMT_RULE_VALUE_DATE | TIMERULEID | RAW | 16 | 0 | Rule for Origin of Next Fixed Value Date | * | |
18 | BILLING_TIMEZONE | CRMT_BILLING_TIMEZONE | TZNZONE | CHAR | 6 | 0 | Time Zone of Billing Plan Set | * | |
19 | PERCENTAGE | CRMT_BILL_PERCENTAGE | DEC3_2 | DEC | 5 | 2 | Percentage of Value to be Billed | ||
20 | BILL_VALUE | CRMT_BILL_VALUE | CRM_COND_VALUE | CURR | 19 | 2 | Value to be Billed on Date Specified in Billing Plan | ||
21 | CURRENCY | CRMT_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | TCURC | |
22 | NO_OF_PERIODS | CRMT_NO_OF_PERIODS | NUMC | 5 | 0 | Number of Periods in Billing Plan | |||
23 | NUMBER_INT | CRMT_BILL_NUMBER_INT | NUMC | 10 | 0 | Billing Plan: Internal Sort Order | |||
24 | CASHFLOW_TYPE | CRMT_CASHFLOW_TYPE | CRMT_CASHFLOW_TYPE | CHAR | 4 | 0 | Flow Category | ||
25 | QUANTITY | CRMT_SCHEDLIN_QUAN | MENG13 | QUAN | 13 | 3 | CRM Schedule Line Quantity | ||
26 | QTY_UNIT | CRMT_PROCESS_QTY_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure in Which the Product Is Sold | * | |
27 | NO_BILLITEMS | CRMT_NO_BILLITEMS | XFELD | CHAR | 1 | 0 | Generate Flag for No Billing Request Items | ||
28 | BP_USAGE | CRMT_BP_USAGE | CRMT_BP_USAGE | CHAR | 1 | 0 | Billing Plan Usage | ||
29 | BILLPLAN_LINE_ID | CRMT_BILLPLAN_LINE_ID | CRMT_BILLPLAN_LINE_ID | CHAR | 2 | 0 | ID of Billing Plan Line | ||
30 | START_DATE | CRMT_START_DATE | BCOS_TSTMP | DEC | 15 | 0 | Start Date of Billing Plan | ||
31 | RULE_START_DATE | CRMT_RULE_START_DATE | TIMERULEID | RAW | 16 | 0 | Rule for Determining Billing Plan Start Date | * | |
32 | END_DATE | CRMT_END_DATE | BCOS_TSTMP | DEC | 15 | 0 | End Date of Billing Plan | ||
33 | RULE_END_DATE | CRMT_RULE_END_DATE | TIMERULEID | RAW | 16 | 0 | Rule for Determining Billing Plan End Date | * | |
34 | DATE_FROM | CRMT_DATE_FROM | BCOS_TSTMP | DEC | 15 | 0 | Dates From | ||
35 | RULE_DATE_FROM | CRMT_RULE_DATE_FROM | TIMERULEID | RAW | 16 | 0 | Rule for Determining Dates from | * | |
36 | DATE_TO | CRMT_DATE_TO | BCOS_TSTMP | DEC | 15 | 0 | Dates To | ||
37 | RULE_DATE_TO | CRMT_RULE_DATE_TO | TIMERULEID | RAW | 16 | 0 | Rule for Determining Dates To | * | |
38 | RULE_STA_DATE_T | CRMT_RULE_START_DATE_T | TIMENAME | CHAR | 12 | 0 | Rule for Determining Billing Plan Start Date | ||
39 | RULE_END_DATE_T | CRMT_RULE_END_DATE_T | TIMENAME | CHAR | 12 | 0 | Rule for Determining Billing Plan End Date | ||
40 | RULE_DATE_FROM_T | CRMT_RULE_DATE_FROM_T | TIMENAME | CHAR | 12 | 0 | Rule for determining dates from | ||
41 | RULE_DATE_TO_T | CRMT_RULE_DATE_TO_T | TIMENAME | CHAR | 12 | 0 | Rule for Determining Dates to | ||
42 | BP_SUBTYPE | CRMT_BP_SUBTYPE | CRMT_BP_SUBTYPE | CHAR | 1 | 0 | Billing Plan Subtype | * | |
43 | .INCLUDE | 0 | 0 | External UBB Fields for a Billing Plan Date | |||||
44 | BPLAN_DATE_TYPE | CRMT_BILLPLAN_DATE_TYPE | CRM_BILLPLAN_DATE_TYPE | NUMC | 2 | 0 | UBB Billing Plan Date Type | ||
45 | NO_OF_BLOCK | CRMT_NO_OF_BLOCK | NUMC | 3 | 0 | UBB Pool Assignment | |||
46 | PROC_EVENT_TYPE | CRMT_PROCESS_EVENT_TYPE | CRM_PROCESS_EVENT_TYPE | CHAR | 4 | 0 | UBB Process Event Type | CRMC_PE_TYPE | |
47 | PROC_EVENT_TYPE2 | CRMT_PROCESS_EVENT_TYPE | CRM_PROCESS_EVENT_TYPE | CHAR | 4 | 0 | UBB Process Event Type | CRMC_PE_TYPE | |
48 | RULE_PER_ORIG_T | CRMT_RULE_PERIOD_DATE_T | TIMENAME | CHAR | 12 | 0 | Rule for Determining the Period Date | ||
49 | PERIOD_DURA | TIMEDURA | TIMEDURA | DEC | 13 | 0 | Numerical Value of Duration | ||
50 | PERIOD_UNIT | TIMEUNITDU | TIMEUNITNA | CHAR | 12 | 0 | Default Value for Time Unit | * | |
51 | .INCLUDE | 0 | 0 | Billing Plan Deadline: Internal Fields | |||||
52 | .INCLUDE | 0 | 0 | Date Fields at Deadline Level: Internal Part | |||||
53 | KIND_PERIOD_DATE | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
54 | KIND_SETTL_FROM | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
55 | KIND_SETTL_TO | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
56 | KIND_BILL_DATE | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
57 | KIND_INVCR_DATE | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
58 | KIND_VALUE_DATE | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
59 | KIND_START_DATE | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
60 | KIND_END_DATE | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
61 | KIND_DATE_FROM | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
62 | KIND_DATE_TO | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
63 | .INCLUDE | 0 | 0 | Billing Plan Deadline: Dynamic Communication Fields | |||||
64 | RULE_PER_DATE_T | CRMT_RULE_PERIOD_DATE_T | TIMENAME | CHAR | 12 | 0 | Rule for Determining the Period Date | ||
65 | RULE_BILL_DATE_T | CRMT_RULE_BILL_DATE_T | TIMENAME | CHAR | 12 | 0 | Rule for Determining the Next Billing Date | ||
66 | RULE_INV_DATE_T | CRMT_RULE_INVCR_DATE_T | TIMENAME | CHAR | 12 | 0 | Rule for Determining Next Billing Document Creation Date | ||
67 | RULE_VAL_DATE_T | CRMT_RULE_VALUE_DATE_T | TIMENAME | CHAR | 12 | 0 | Rule for Origin of Next Fixed Value Date | ||
68 | RULE_SET_FROM_T | CRMT_RULE_SETTL_FROM_T | TIMENAME | CHAR | 12 | 0 | Rule for Determining Start of Settlement Period | ||
69 | RULE_SETTL_TO_T | CRMT_RULE_SETTL_TO_T | TIMENAME | CHAR | 12 | 0 | Rule for Determining End of Settlement Period | ||
70 | SUPPRESS_EVENT | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
71 | .INCLUDE | 0 | 0 | Date in Billing Plan Reference for FIMA Without Key Fields | |||||
72 | .INCLUDE | 0 | 0 | External FIMA Fields for a Billing Plan Date | |||||
73 | .INCLUDE | 0 | 0 | External FIMA Field FIN_VIEW for a Billing Plan Date | |||||
74 | FIN_VIEW | CRMT_FINANCING_VIEW | CRMT_FINANCING_VIEW | NUMC | 2 | 0 | Financing View | * | |
75 | SCHED_IND | CRMT_SCHED_INDICATOR | CRM_SCHED_INDICATOR | CHAR | 1 | 0 | Schedule Line Indicator for Billing Plan | ||
76 | .INCLUDE | 0 | 0 | External FIMA Fields for a Billing Plan Date | |||||
77 | PER_PAYMENTFORM | CRMT_PER_PAYMENTFORM | CRMT_PAYMENTFORM | NUMC | 1 | 0 | When Due in Period | * | |
78 | UNIT_PERIODS | CRMT_UNIT_PERIODS | TFMSINSTALLMENT | NUMC | 2 | 0 | Time Unit for Periods | ||
79 | MAN_FIRSTDUEDATE | CRMT_MAN_FIRSTDUEDATE | BCOS_TSTMP | DEC | 15 | 0 | Individual Due Date | ||
80 | NOMINAL_INT_RATE | CRMT_NOMINAL_INT_RATE | DECV3_7 | DEC | 10 | 7 | Nominal Interest Rate | ||
81 | NOMINAL_IRAT_INT | CRMT_NOMINAL_INT_RATE_INT | DECV3_7 | DEC | 10 | 7 | Nominal Interest Rate (Internal Plan) | ||
82 | DEFAULT_AMOUNT | CRMT_DEFAULT_AMOUNT | CRMT_COND_VALUE | CURR | 19 | 2 | Default Amount | ||
83 | DEFAULT_PERCENT | CRMT_DEFAULT_PERCENTAGE | DECV3_7 | DEC | 10 | 7 | Default Percentage | ||
84 | DEF_RATEPERX | CRMT_DEFAULT_RATEPERK | CRMT_DECV7_10 | DEC | 17 | 10 | Default Rate per x | ||
85 | FREQ_CONVERSION | CRMT_FREQ_CONVERSION | TFM_PPAYMENT_INTERN | DEC | 6 | 0 | Payment Frequency Factor | ||
86 | CALCULATION_DATE | CRMT_CALCULATION_DATE | BCOS_TSTMP | DEC | 15 | 0 | Calculation date | ||
87 | FLAG_ULTIMO | CRMT_FLAG_ULTIMO | XFELD | CHAR | 1 | 0 | Do Not Draw Standard Values from Conditions | ||
88 | FLAG_BLOCKED | CRMT_FLAG_BLOCKED | XFELD | CHAR | 1 | 0 | Calculation Locked | ||
89 | STEP_KIND | CRMT_STEP_KIND | CRMT_STEP_KIND | NUMC | 2 | 0 | Payment Structure/Change to Principal Indicator | ||
90 | FIXING | CRMT_STEP_FIXING | CRMT_FINPROD_FIX01 | NUMC | 2 | 0 | Field Control Billplan_d Rows (Fixed/Changeable) | ||
91 | SETTL_FROM_VIRTU | CRMT_SETTL_FROM_FIMA | BCOS_TSTMP | DEC | 15 | 0 | Virtual Start of Settlement of Period | ||
92 | DATEUPD_SUPPRESS | CRMT_DATEUPD_SUPPRESS | CRMT_DATEUPD_SUPPRESS | CHAR | 1 | 0 | No Date Update (FIMA) | ||
93 | OFFSET_VAL | CRMT_FINPROD_OFFS01 | DEC5 | DEC | 5 | 0 | Offset | ||
94 | OFFSET_UNIT | CRMT_FINPROD_OFFSU01 | TIMEUNITNA | CHAR | 12 | 0 | Offset Unit | * | |
95 | SETTLED | CRMT_FIMAN_SETTLED | CRMT_FIMAN_SETTLED | CHAR | 1 | 0 | Settled Payment Step | ||
96 | FACTOR1 | CRMT_FIMAN_FACTOR | DECV5_10 | DEC | 15 | 10 | Factor | ||
97 | FACTOR2 | CRMT_FIMAN_FACTOR | DECV5_10 | DEC | 15 | 10 | Factor | ||
98 | FACTOR3 | CRMT_FIMAN_FACTOR | DECV5_10 | DEC | 15 | 10 | Factor | ||
99 | .INCLUDE | 0 | 0 | External FIMA Result Fields of Date in Reference | |||||
100 | RESULT_AMOUNT | CRMT_RESULT_AMOUNT | CRMT_COND_VALUE | CURR | 19 | 2 | Resulting Amount | ||
101 | RESULT_AMOUNT_PR | CRMT_AMOUNT_PRECISE | CRMT_COND_VALUE | CURR | 19 | 2 | Unrounded Result Amount | ||
102 | RPX_DIVISOR | CRMT_RPXDIV | CRMT_COND_VALUE | CURR | 19 | 2 | Divisor for Rate per x Determination | ||
103 | RESULT_RATEPERK | CRMT_RESULT_RATEPERK | CRMT_DECV7_10 | DEC | 17 | 10 | Rate per x | ||
104 | RESULT_RATE_K_G | CRMT_RESULT_RATEPERK_G | CRMT_DECV7_10 | DEC | 17 | 10 | Gross Rate per X | ||
105 | .INCLUDE | 0 | 0 | Amount Allocation for Billing Plan: External Fields | |||||
106 | PARTNER1 | CRMT_PARTNER_NO | CRM_PARTNER_NO | CHAR | 32 | 0 | Partner Number | ||
107 | PARTNER1_FCT | CRMT_PARTNER_FCT | COM_PARTNER_FCT | CHAR | 8 | 0 | Partner Function | ||
108 | PARTNER2 | CRMT_PARTNER_NO | CRM_PARTNER_NO | CHAR | 32 | 0 | Partner Number | ||
109 | PARTNER2_FCT | CRMT_PARTNER_FCT | COM_PARTNER_FCT | CHAR | 8 | 0 | Partner Function | ||
110 | AC_INDICATOR | CRMT_AC_INDICATOR | CRMT_AC_INDICATOR | CHAR | 2 | 0 | Accounting Indicator | * | |
111 | AC_OBJECT_TYPE | CRMT_AC_OBJECT_TYPE | CRMT_OBJECT_TYPE | CHAR | 2 | 0 | Object Type for Settlement Account Assignment | * | |
112 | AC_ASSIGNMENT | CRMT_AC_ASSIGN | CRMT_AC_ASSIGN | CHAR | 50 | 0 | Settlement Account Assignment | ||
113 | AC_PERCENTAGE | CRMT_AC_COST_PERCENTAGE | DEC3_2 | DEC | 5 | 2 | Percentage of Costs to Be Distributed | ||
114 | SPLIT_ORIGIN | CRMT_SPLIT_ORIGIN | CRMT_SPLIT_ORIGIN | CHAR | 2 | 0 | Origin Split | ||
115 | KSCHL | PRCT_COND_TYPE | /SAPCND/COND_TYPE | CHAR | 4 | 0 | Pricing - Condition Type | * | |
116 | .INCLUDE | 0 | 0 | External Grouping Fields for Amount Allocation | |||||
117 | GROUP1 | CRMT_GROUP1 | CRMT_GROUP | CHAR | 32 | 0 | Group 1 | ||
118 | GROUP2 | CRMT_GROUP2 | CRMT_GROUP | CHAR | 32 | 0 | Group 2 | ||
119 | GROUP3 | CRMT_GROUP3 | CRMT_GROUP | CHAR | 32 | 0 | Group 3 | ||
120 | GROUP4 | CRMT_GROUP4 | CRMT_GROUP | CHAR | 32 | 0 | Group 4 | ||
121 | GROUP5 | CRMT_GROUP5 | CRMT_GROUP | CHAR | 32 | 0 | Group 5 | ||
122 | GROUP6 | CRMT_GROUP6 | CRMT_GROUP | CHAR | 32 | 0 | Group 6 | ||
123 | GROUP7 | CRMT_GROUP7 | CRMT_GROUP | CHAR | 32 | 0 | Group 7 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | BAD_BILLPLAN_D | CURRENCY | TCURC | WAERS | |||
2 | BAD_BILLPLAN_D | PROC_EVENT_TYPE | CRMC_PE_TYPE | PROC_EVENT_TYPE | KEY | 1 | CN |
3 | BAD_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 | 20C |