SAP ABAP Table CRMC_MCAL_TS (Customizing table for Trade Spends)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MKT-MPL-CAL (Application Component) Marketing Calendar
⤷ CRM_MCAL_CUSTOMIZING (Package) Marketing Calendar Customizing
⤷ CRM-MKT-MPL-CAL (Application Component) Marketing Calendar
⤷ CRM_MCAL_CUSTOMIZING (Package) Marketing Calendar Customizing
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | CRMC_MCAL_TS | Table Relationship Diagram |
Short Description | Customizing table for Trade Spends |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | G | Customizing table, protected against SAP Upd., only INS all. |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | TRADE_SPEND_ID | CRM_MCAL_TS_ID | CRM_MCAL_TS_ID | CHAR | 8 | 0 | Trade Spend ID for Trade Spend Customizing Table | ||
3 | SPEND_TYPE | CRM_MKTPL_COST_TYPE | CRM_MKTPL_COST_TYPE | CHAR | 4 | 0 | Spend Type | CRMC_MKTPL_COST | |
4 | SPEND_CATEGORY | CRM_MKTPL_COST_CAT | CRM_MKTPL_COST_CAT | CHAR | 30 | 0 | Spend Category | CRMC_MKTPL_COS0 | |
5 | SPEND_METHOD | CRM_MKTPL_SPEND_METHOD | CRM_MKTPL_SPEND_METHOD | CHAR | 10 | 0 | Spend Method for Key Figure Planning | CRMC_MKTPL_COS1 | |
6 | COLOR_ID | CRM_MCAL_COLOR_ID | CRM_MCAL_COLOR_ID | CHAR | 10 | 0 | Color ID | CRMC_MCAL_COLOR | |
7 | REPORT_ID | CRM_MCAL_REPORT_ID | CHAR42 | CHAR | 42 | 0 | BW Report | ||
8 | REPORT_ID_IMP | CRM_MCAL_REPORT_ID | CHAR42 | CHAR | 42 | 0 | BW Report |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMC_MCAL_TS | COLOR_ID | CRMC_MCAL_COLOR | COLOR_ID | REF | ||
2 | CRMC_MCAL_TS | SPEND_CATEGORY | CRMC_MKTPL_COS0 | COST_CATEGORY | KEY | ||
3 | CRMC_MCAL_TS | SPEND_METHOD | CRMC_MKTPL_COS1 | SPEND_METHOD | KEY | ||
4 | CRMC_MCAL_TS | SPEND_TYPE | CRMC_MKTPL_COST | COST_TYPE | KEY |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 701 |