SAP ABAP Table ACPCRM_MKTPL_PRD_CD (Change Document Structure; Generated by RSSCD000)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-ACP-APL (Application Component) Account Planner
⤷ CRM_ACCOUNT_PLANNING (Package) CRM account planning
⤷ CRM-ACP-APL (Application Component) Account Planner
⤷ CRM_ACCOUNT_PLANNING (Package) CRM account planning
Basic Data
Table Category | INTTAB | Structure |
Structure | ACPCRM_MKTPL_PRD_CD | Table Relationship Diagram |
Short Description | Change Document Structure; Generated by RSSCD000 |
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 | Marketing Planning: Change Doc. Struct. for CRMD_MKTPL_PROD | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
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 | PRODUCT_GUID | COMT_PRODUCT_GUID | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | COMM_PRODUCT | |
7 | .INCLUDE | 0 | 0 | CRM Marketing Planning: Include Structure Appl. Product | |||||
8 | CATEGORY_GUID | COMT_CATEGORY_GUID | SYSUUID | RAW | 16 | 0 | Category GUID | ||
9 | CATEGORY2_GUID | COMT_CATEGORY_GUID | SYSUUID | RAW | 16 | 0 | Category GUID | ||
10 | PRODUCT_GROUP | CRM_MKTPL_PROD_GROUP | CHAR | 3 | 0 | Product Group | |||
11 | ADD_PRODUCT | CRM_MKTPL_FREE_PROD_GUID | SYSUUID | RAW | 16 | 0 | Free Product GUID | ||
12 | EXCL_INCL_IND | CRM_MKTPL_PROD_INCL | XFELD | CHAR | 1 | 0 | Free Product Inclusion Checkbox | ||
13 | SELECT_FLAG | CRM_MKTPL_PROD_SEL | FLAG | CHAR | 1 | 0 | Product Exclusion Checkbox | ||
14 | QUANTITY | CRM_MKTPL_PROD_QUANTITY | MENG13 | QUAN | 13 | 3 | Product Quantity | ||
15 | SALES_UOM | COMT_UNIT | MEINS | UNIT | 3 | 0 | Units of Measure of Product | * | |
16 | ADD_PRODUCT_UOM | CRM_MKTPL_FREE_PROD_UOM | MEINS | UNIT | 3 | 0 | Unit of Measure for the Free Product | * | |
17 | SEL_CATEGORY_G | COMT_CATEGORY_GUID | SYSUUID | RAW | 16 | 0 | Category GUID | ||
18 | SEL_CATEGORY2_G | COMT_CATEGORY_GUID | SYSUUID | RAW | 16 | 0 | Category GUID | ||
19 | SEL_PRODUCT_GRP | CRM_MKTPL_PROD_GROUP | CHAR | 3 | 0 | Product Group | |||
20 | PROMO_PCAT_GUID | COMT_CATEGORY_GUID | SYSUUID | RAW | 16 | 0 | Category GUID | ||
21 | PROMO_PGRP_ID | CRM_MKTPL_PROD_GROUP | CHAR | 3 | 0 | Product Group | |||
22 | .INCLUDE | 0 | 0 | Quick Entry fields persisted in product dimensions DB tables | |||||
23 | LIST_PRICE | CRM_MKTPL_LIST_PRICE | CRM_MKTPL_LIST_PRICE | DEC | 20 | 2 | List Price | ||
24 | RETAIL_PRICE | CRM_MKTPL_RETAIL_PRICE | CRM_MKTPL_RETAIL_PRICE | DEC | 20 | 2 | Retail Price | ||
25 | PROD_DIM_VOLUME | CRM_MKTPL_PROD_DIM_VOLUME | CRM_MKTPL_PROD_DIM_VOLUME | DEC | 22 | 0 | Volume field | ||
26 | EFFECTIVE_FROM | CRM_MKTPL_START_DATE_RANGES | BCOS_TSTMP | DEC | 15 | 0 | Additional Start Date Range | ||
27 | EFFECTIVE_TO | CRM_MKTPL_END_DATE_RANGES | BCOS_TSTMP | DEC | 15 | 0 | Additional End Date Range | ||
28 | .INCLUDE | 0 | 0 | Structures for generating change document update programs | |||||
29 | KZ | CDCHNGIND | CDCHNGIND | CHAR | 1 | 0 | Change type (U, I, E, D) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ACPCRM_MKTPL_PRD_CD | PRODUCT_GUID | COMM_PRODUCT | CLIENT | |||
2 | ACPCRM_MKTPL_PRD_CD | PROJECT_GUID | CGPL_PROJECT | GUID | |||
3 | ACPCRM_MKTPL_PRD_CD | TASK_GUID | CGPL_TASK | GUID |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |