SAP ABAP Table CRMS_MKTPPG_HDR (MKTPPG: Header Attribute Database Structure)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MKT-MPL-TPM-PPG (Application Component) Promotion Guidelines
⤷ CRM_MKTPPG (Package) CRM Marketing: Pricing and Promotion Guidelines
⤷ CRM-MKT-MPL-TPM-PPG (Application Component) Promotion Guidelines
⤷ CRM_MKTPPG (Package) CRM Marketing: Pricing and Promotion Guidelines
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMS_MKTPPG_HDR | Table Relationship Diagram |
Short Description | MKTPPG: Header Attribute Database Structure |
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 | MKTPPG OL: Pricing and Promotion Guidelines Attributes | |||||
2 | GUID | CGPL_GUID16 | CGPL_PROJECT_GUID | RAW | 16 | 0 | Project Planning: 16-Character GUID for Projects and Activts | ||
3 | .INCLUDE | 0 | 0 | Project Planning: Projects and Activities Include Structure | |||||
4 | PROJECT_GUID | CGPL_PROJECT_GUID | CGPL_PROJECT_GUID | RAW | 16 | 0 | Project Planning: 16 Character GUID for Projects | ||
5 | OBJECT_TYPE | CGPL_OBJECT_TYPE | CHAR3 | CHAR | 3 | 0 | Object Type in Project Planning | ||
6 | PRIORITY | CGPL_PRIORITY | NUMC3 | NUMC | 3 | 0 | Priority | CGPL_PRIO | |
7 | ACTUALSTART | CGPL_ACTUALSTART | BCOS_TSTMP | DEC | 15 | 0 | Actual Start Date | ||
8 | ACTUALFINISH | CGPL_ACTUALFINISH | BCOS_TSTMP | DEC | 15 | 0 | Actual Finish Date | ||
9 | PLANSTART | CGPL_PLANSTART | BCOS_TSTMP | DEC | 15 | 0 | Planned start date | ||
10 | PLANFINISH | CGPL_PLANFINISH | BCOS_TSTMP | DEC | 15 | 0 | Planned Finish Date | ||
11 | COMPLETION | CGPL_COMPLETION | CGPL_COMPLETION | NUMC | 3 | 0 | Percentage of Completion | ||
12 | MILESTONE | CGPL_MILESTONE | CHAR1 | CHAR | 1 | 0 | Milestone indicator | ||
13 | CONSTRAINT_TYPE | CGPL_CONSTRAINT | CGPL_CONSTRAINT | CHAR | 1 | 0 | Type of Scheduling Constraint | ||
14 | CONSTRAINT_TIME | CGPL_CONSTRAINT_TIME | BCOS_TSTMP | DEC | 15 | 0 | Constraint Date | ||
15 | CREATED_BY | CGPL_CREATED_BY | USNAM | CHAR | 12 | 0 | Name of Person Who Created Object | ||
16 | CREATED_ON | CGPL_CREATED_ON | DATUM | DATS | 8 | 0 | Date on Which the Object was Created | ||
17 | CREATED_IN_BW | CGPL_CREATED_BW | CHAR1 | CHAR | 1 | 0 | Transfer Object to BW | ||
18 | CHANGED_BY | CGPL_CHANGED_BY | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
19 | CHANGED_ON | CGPL_CHANGED_ON | DATUM | DATS | 8 | 0 | Date on Which Object Was Last Changed | ||
20 | UPDATED_IN_BW | CGPL_UPDATED_BW | CHAR1 | CHAR | 1 | 0 | Current Object in BW | ||
21 | BWIDENTIFIER | CGPL_BWIDENTIFIER | CGPL_BWIDENTIFIER | NUMC | 8 | 0 | Project Planning - BW Identification | ||
22 | PLANGROUP | CGPL_SEM_PLGRP | CHAR | 4 | 0 | Planning Profile Group | |||
23 | LATEST_START | CGPL_LATEST_START | BCOS_TSTMP | DEC | 15 | 0 | Latest start | ||
24 | LATEST_FINISH | CGPL_LATEST_FINISH | BCOS_TSTMP | DEC | 15 | 0 | Latest finish date | ||
25 | TOTAL_FLOAT | CGPL_TOTAL_FLOAT | CGPL_FLOAT | DEC | 8 | 2 | Total Float | ||
26 | DURATION | CGPL_DURATION | CGPL_DURATION | DEC | 8 | 2 | Duration of Execution | ||
27 | DURATION_UNIT | CGPL_DURATION_UNIT | MEINS | UNIT | 3 | 0 | Time Unit for Execution Duration | * | |
28 | CALENDAR_ID | WFCID | WFCID | CHAR | 2 | 0 | Factory Calendar | * | |
29 | CONSTR_TYPE_FIN | CGPL_CONSTRAINT | CGPL_CONSTRAINT | CHAR | 1 | 0 | Type of Scheduling Constraint | ||
30 | CONSTR_TIME_FIN | CGPL_CONSTRAINT_TIME | BCOS_TSTMP | DEC | 15 | 0 | Constraint Date | ||
31 | APPLICATION | CGPL_APPLICATION_TYPE | CGPL_APPLICATION_TYPE | CHAR | 3 | 0 | Application in Project Planning | * | |
32 | FORECAST_START | CGPL_FORECAST_START | BCOS_TSTMP | DEC | 15 | 0 | Forecast Start | ||
33 | FORECAST_FINISH | CGPL_FORECAST_FINISH | BCOS_TSTMP | DEC | 15 | 0 | Forecast Finish | ||
34 | EXTERNAL_ID | CRM_MKTPPG_EXTERNAL_ID | CGPL_EXTID | CHAR | 24 | 0 | Pricing and Promotion Guidelines External ID | ||
35 | AUTH_GROUP | CRM_MKTPPG_AUTH_GROUP | CRM_MKTPPG_AUTH_GROUP | CHAR | 4 | 0 | Authorization Group | ||
36 | SALES_ORG | CRMT_SALES_ORG | HROBJEC_14 | CHAR | 14 | 0 | Sales Organization ID | ||
37 | DIS_CHANNEL | CRMT_DISTRIBUTION_CHANNEL | CRM_DISTRIBUTION_CHANNEL | CHAR | 2 | 0 | Distribution Channel | * | |
38 | DIVISION | CRMT_DIVISION | CRM_DIVISION | CHAR | 2 | 0 | Division | * | |
39 | TERR_PATH_GUID | CRMT_TERRITORY_PATH_GUID | SYSUUID | RAW | 16 | 0 | Territory Path GUID | ||
40 | TERR_PATH_ID | CRMT_TERRITORY_PATH_ID | CRM_TERRITORY_PATH_ID | CHAR | 30 | 0 | Territory Hierarchy ID | ||
41 | CURRENCY | CRM_MKTPL_CUKY | WAERS | CUKY | 5 | 0 | MKTPL: Currency Object | * | |
42 | TIMEZONE_CREATED | TIMEZONE | TZNZONE | CHAR | 6 | 0 | Time Zone | * | |
43 | .INCLUDE | 0 | 0 | Extension Include - Promotion Guidelines Header | |||||
44 | MKTPPG_HEADER | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
45 | TASK_GUID | CGPL_GUID16 | CGPL_PROJECT_GUID | RAW | 16 | 0 | Project Planning: 16-Character GUID for Projects and Activts |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMS_MKTPPG_HDR | PRIORITY | CGPL_PRIO | PRIORITY | KEY |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 700 |