SAP ABAP Table CRMD_MKTPL_COSTA (Trade Spend Assignments table)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MKT-MPL-ST-KFP (Application Component) Key Figure Planning
⤷ CRM_MKTPL_KPI_INTEGRATION (Package) CRM Marketing Planner: KPI Integration
⤷ CRM-MKT-MPL-ST-KFP (Application Component) Key Figure Planning
⤷ CRM_MKTPL_KPI_INTEGRATION (Package) CRM Marketing Planner: KPI Integration
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | CRMD_MKTPL_COSTA | Table Relationship Diagram |
Short Description | Trade Spend Assignments table |
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 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | GUID | SYSUUID_X | SYSUUID | RAW | 16 | 0 | UUID in X form (binary) | ||
3 | PROJECT_GUID | CGPL_GUID16 | CGPL_PROJECT_GUID | RAW | 16 | 0 | Project Planning: 16-Character GUID for Projects and Activts | CGPL_PROJECT | |
4 | TASK_GUID | CGPL_GUID16 | CGPL_PROJECT_GUID | RAW | 16 | 0 | Project Planning: 16-Character GUID for Projects and Activts | CGPL_TASK | |
5 | .INCLUDE | 0 | 0 | CRM Marketing Planning: Include Structure Trade Spend | |||||
6 | COST_TYPE | CRM_MKTPL_COST_TYPE | CRM_MKTPL_COST_TYPE | CHAR | 4 | 0 | Spend Type | * | |
7 | COST_CATEGORY | CRM_MKTPL_COST_CAT | CRM_MKTPL_COST_CAT | CHAR | 30 | 0 | Spend Category | * | |
8 | SPEND_METHOD | CRM_MKTPL_SPEND_METHOD | CRM_MKTPL_SPEND_METHOD | CHAR | 10 | 0 | Spend Method for Key Figure Planning | * | |
9 | PMNT_TYPE | CRMT_BUAG_PAYMETH | CRM_BUAG_PAYMETH | CHAR | 1 | 0 | Payment Method | * | |
10 | DISC_METHOD | CRM_MKTPL_DISC_METH | CRM_MKTPL_DISC_METH | CHAR | 4 | 0 | Discount Method | * | |
11 | VOLUME | CRM_MKTPL_VOLUME | CRM_MKTPL_VOLUME | CHAR | 4 | 0 | Related Volume | * | |
12 | PARTICIP_RATE | CRM_MKTPL_PARTICIP_RATE | CRM_MKTPL_PARTICIP_RATE | CHAR | 3 | 0 | Participation Rate (0-100%) | ||
13 | START_DATE | CRM_MKTPL_TSPEND_STARTDATE | BCOS_TSTMP | DEC | 15 | 0 | Trade Spend Start Date | ||
14 | END_DATE | CRM_MKTPL_TSPEND_ENDDATE | BCOS_TSTMP | DEC | 15 | 0 | Trade Spend End Date | ||
15 | COND_GENERATED | CRM_MKTPL_COND_GENERATED | CRM_MKTPL_COND_GENERATED | CHAR | 1 | 0 | Condition Generated (Indicator) | ||
16 | REBATE_STAT | CRM_MKTPL_REBATE_STAT | CRM_MKTPL_REBATE_STAT | CHAR | 1 | 0 | Rebate Status | ||
17 | DATES_MODIFIED | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
18 | TAKE_RATE | CRM_MKTGS_TAKE_RATE | CRM_MKTGS_TAKE_RATE | NUMC | 3 | 0 | Take Rate | ||
19 | SPEND_VALUE | CRM_MKTGS_SPEND_VALUE | CRM_MKTGS_SPEND_VALUE | CURR | 20 | 2 | Spend Value | ||
20 | OI_CAP | CRM_MKTGS_OI_CAP | CRM_MKTGS_OI_CAP | CURR | 20 | 2 | Off Invoice Cap | ||
21 | CURRENCY | CRM_MKTPL_CUKY | WAERS | CUKY | 5 | 0 | MKTPL: Currency Object | * | |
22 | OI_CAP_CURRENCY | CRM_MKTPL_CUKY | WAERS | CUKY | 5 | 0 | MKTPL: Currency Object | * | |
23 | DATE_RANGE_TYPE | CRM_MKTGS_IB_DATE_TYPE | CHAR | 10 | 0 | Date type for the IBOM layer | |||
24 | DATE_RANGE_ID | CRM_MKTPL_DATE_ID | CRM_MKTPL_DATE_ID | NUMC | 2 | 0 | Unique Identifier for Additional Date Ranges | ||
25 | .INCLUDE | 0 | 0 | Extensibility Include - Trade Spend | |||||
26 | MKTPL_TRADESPEND | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
27 | .INCLUDE | 0 | 0 | Include structure for Claims related data | |||||
28 | SETTL_CALENDAR | WFCID | WFCID | CHAR | 2 | 0 | Factory Calendar | * | |
29 | .INCLUDE | 0 | 0 | Extensibility table for QE Trade Spend Overview | |||||
30 | MKTPL_QE_TSPEND | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMD_MKTPL_COSTA | CLIENT | T000 | MANDT | |||
2 | CRMD_MKTPL_COSTA | PROJECT_GUID | CGPL_PROJECT | GUID | |||
3 | CRMD_MKTPL_COSTA | TASK_GUID | CGPL_TASK | GUID |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 400 |