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