SAP ABAP Table CRMT_BILLING_DB_WRK (Billing Request Item: Database Work Area)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BTX (Application Component) Business Transactions
⤷ CRM_BILLING (Package) CRM billing data
⤷ CRM-BTX (Application Component) Business Transactions
⤷ CRM_BILLING (Package) CRM billing data
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMT_BILLING_DB_WRK | Table Relationship Diagram |
Short Description | Billing Request Item: Database Work Area |
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 | Business Transaction - Billing Set | |||||
2 | .INCLUDE | 0 | 0 | One Order: Key Fields | |||||
3 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
4 | GUID | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
5 | .INCLUDE | 0 | 0 | Billing Data: External Fields | |||||
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 | .INCLUDE | 0 | 0 | Billing Data: External Fields | |||||
21 | SETTL_FIMA | CRMT_SETTL_FIMA | BCOS_TSTMP | DEC | 15 | 0 | Internal Billing Date for Financial Mathematics | ||
22 | FIMA_KONDIND | CRMT_FIMA_KONDIND | NUMC | 10 | 0 | Reference FIMA Condition Item | |||
23 | FIMA_BEWEIND | CRMT_FIMA_BEWEIND | NUMC | 10 | 0 | Reference FIMA Flow Record | |||
24 | BILLING_BLOCK | CRMT_BUS_BILL_BLOCK_REASON | CRM_BILLING_BLOCK | CHAR | 2 | 0 | Business Partner (CRM): Billing Block Reason | * | |
25 | BUAG_GUID | CRMT_BUAG_GUID | SYSUUID | RAW | 16 | 0 | GUID of the Business Agreement | ||
26 | BP_SUBTYPE | CRMT_BP_SUBTYPE | CRMT_BP_SUBTYPE | CHAR | 1 | 0 | Billing Plan Subtype | * | |
27 | .INCLUDE | 0 | 0 | External UBB Fields for a Billing Plan Date | |||||
28 | PERIOD_TYPE | CRMT_PERIOD_TYPE | CRM_PERIOD_TYPE | CHAR | 2 | 0 | Period Type (First, Last, First and Last, etc.) | * | |
29 | LOC_GUID | CRMT_LOC_GUID | SYSUUID_C | CHAR | 32 | 0 | Letter of Credit GUID from SAP Global Trade Services | ||
30 | LOC_REQUIRED | CRMT_LOC_REQUIRED | CRM_BOOLEAN | CHAR | 1 | 0 | Letter of Credit required | ||
31 | LOC_EXT_NUMBER | CRMT_LOC_EXTERNAL_NUMBER | CHAR | 40 | 0 | External Number Letter of Credit | |||
32 | .INCLUDE | 0 | 0 | EEW Include | |||||
33 | BILLING_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
34 | .INCLUDE | 0 | 0 | ||||||
35 | SEPA_ON | CRMT_SEPA_ON | CRM_SEPA_ON | CHAR | 1 | 0 | Indicator for SEPA-Relevant Transactions | ||
36 | MANDATE_ID | CRMT_MANDATE_ID | CRM_MANDATE_ID | CHAR | 35 | 0 | Unique Reference to Mandate per Payment Recipient | ||
37 | .INCLUDE | 0 | 0 | Billing Data: Internal Fields | |||||
38 | .INCLUDE | 0 | 0 | Date Fields at Deadline Level: Internal Part | |||||
39 | KIND_PERIOD_DATE | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
40 | KIND_SETTL_FROM | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
41 | KIND_SETTL_TO | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
42 | KIND_BILL_DATE | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
43 | KIND_INVCR_DATE | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
44 | KIND_VALUE_DATE | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
45 | KIND_START_DATE | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
46 | KIND_END_DATE | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
47 | KIND_DATE_FROM | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
48 | KIND_DATE_TO | TIMENAEVEN | SC_APPTTYP | CHAR | 12 | 0 | Date type | * | |
49 | .INCLUDE | 0 | 0 | Billing Request Item: Dynamic Fields of the Database Buffer | |||||
50 | NOREC_FLAG | CRMT_NOREC | CRM_BOOLEAN | CHAR | 1 | 0 | Entry does not Exist in Database |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_BILLING_DB_WRK | BILLING_TIMEZONE | TTZZ | TZONE | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 12A |