SAP ABAP Table CRMT_ACTIVITY_I_ADD_FIELDS (Activity Reporting Attributes IBU-SPECIFIC)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BTX-ACT (Application Component) Activity Management
⤷ CRM_ACTIVITY_I (Package) CRM Activity Item Data
⤷ CRM-BTX-ACT (Application Component) Activity Management
⤷ CRM_ACTIVITY_I (Package) CRM Activity Item Data
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMT_ACTIVITY_I_ADD_FIELDS | Table Relationship Diagram |
Short Description | Activity Reporting Attributes IBU-SPECIFIC |
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 | Activity: Product Measurement Reporting | |||||
2 | LAENG | COMT_LENGTH | MENG13 | QUAN | 13 | 3 | Length of the Product or of the Packaging of the Product | ||
3 | BREIT | COMT_WIDTH | MENG13 | QUAN | 13 | 3 | Width of the Product or of the Packaging of the Product | ||
4 | HOEHE | COMT_HEIGHT | MENG13 | QUAN | 13 | 3 | Height of the Product or of the Packaging of the Product | ||
5 | MEABM | COMT_UNIT_OF_DIMENSION | MEINS | UNIT | 3 | 0 | Unit in Which Length/Width/Height Is Measured | T006 | |
6 | .INCLUDE | 0 | 0 | Activity: Product Availability Reporting | |||||
7 | PRAVA | CRMT_ACT_PROD_AVAILABLE_AFTER | CRM_ACT_PROD_AVAILABLE_AFTER | CHAR | 3 | 0 | Product available after visit at checkout | CRMC_ACT_PRAVA | |
8 | PRAVB | CRMT_ACT_PROD_AVAILABLE_BEFORE | CRM_ACT_PROD_AVAILABLE_BEFORE | CHAR | 3 | 0 | Product available before Visit at check out | CRMC_ACT_PRAVB | |
9 | .INCLUDE | 0 | 0 | Activity: General Reporting | |||||
10 | SUBJECTA | CRMT_ACT_SUBJECTA | CRM_ACT_SUBJECTA | CHAR | 10 | 0 | Free Text: Subject A | CRMC_ACT_SBJTA | |
11 | SUBJECTB | CRMT_ACT_SUBJECTB | CRM_ACT_SUBJECTB | CHAR | 10 | 0 | Free Text: Subject B | CRMC_ACT_SBJTB | |
12 | KV_RESULT | CRMT_ACT_KVRESF | CRM_ACT_KVRESF | CHAR | 1 | 0 | Result | CRMC_ACT_RSLT | |
13 | RESREAS | CRMT_ACT_RESRAS | CRM_ACT_RESRAS | CHAR | 3 | 0 | Result Reason | CRMC_ACT_RESRS | |
14 | .INCLUDE | 0 | 0 | Activity: Decoration Check Reporting | |||||
15 | KV_DEKO | CRMT_ACT_DECO_MATERIAL | CRM_ACT_DECO_MATERIAL | CHAR | 3 | 0 | Decoration Material | CRMC_ACT_DECOM | |
16 | DEKOTP | CRMT_ACT_DECO_TYPE | CRM_ACT_DECO_TYPE | CHAR | 3 | 0 | Decoration Type | CRMC_ACT_DECOT | |
17 | KV_STOCK | CRMT_ACT_DECO_NUMBER_ON_STOCK | DEC6 | DEC | 6 | 0 | Number of Products in stocks | ||
18 | .INCLUDE | 0 | 0 | Activity: Placement Check Reporting | |||||
19 | POSLOC | CRMT_ACT_MAIN_LOCATION | CRM_ACT_MAIN_LOCATION | CHAR | 3 | 0 | main location of placement, eg. pallet, chip etc. | CRMC_ACT_MPLCT | |
20 | KV_ZPANZ | CRMT_ACT_SECOND_PLACEMENT | DEC3 | DEC | 3 | 0 | Number of Second placements | ||
21 | KV_ZPAVA | CRMT_ACT_SEC_PLACEMENT_AVAIL | CRM_ACT_SDPMT | CHAR | 1 | 0 | Second Placement Available | * | |
22 | .INCLUDE | 0 | 0 | Activity: Inventory Check Reporting | |||||
23 | NRMSHF | CRMT_ACT_PROD_IN_MAIN_SHELF | DEC6 | DEC | 6 | 0 | Number of produts in main shelf | ||
24 | NRPSHF | CRMT_ACT_PROD_IN_PROM_SHELF | DEC6 | DEC | 6 | 0 | Number of products in promation shelf | ||
25 | .INCLUDE | 0 | 0 | Activity: Product Position Check Reporting | |||||
26 | POSVER | CRMT_ACT_VERTICAL_POS_IN_SHELF | CRM_ACT_VERTICAL_POS_IN_SHELF | CHAR | 3 | 0 | vertical position in shelf | CRMC_ACT_POSVR | |
27 | POSHOR | CRMT_ACT_HORIZONT_POS_IN_SHELF | CRM_ACT_HORIZONT_POS_IN_SHELF | CHAR | 3 | 0 | horizontal position in shelf | CRMC_ACT_POSHR | |
28 | POSQLI | CRMT_ACT_QUALI_OF_SHEL_POS | CRMT_ACT_QUALI_OF_SHELF_POS | CHAR | 3 | 0 | Qualification of the shelf position | CRMC_ACT_POSQL | |
29 | ECROPT | CRMT_ACT_SHELF_OPTIMIZATION | CRM_ACT_SHELF_OPTIMIZATION | CHAR | 3 | 0 | Shelf Optimization performed within an ECR agreement | CRMC_ACT_CURES | |
30 | .INCLUDE | 0 | 0 | Activity: Facing Check Reporting | |||||
31 | NROFFAC | CRMT_NUMBER_OF_FACING | DEC4 | DEC | 4 | 0 | Number of facings | ||
32 | FACLEN | CRMT_ACT_LENGTH_OF_FACING | DEC6 | DEC | 6 | 0 | Length of facing | ||
33 | FACWID | CRMT_ACT_WIDTH_OF_FACING | DEC6 | DEC | 6 | 0 | Width of facing | ||
34 | FACDEP | CRMT_ACT_DEPTH_OF_FACING | DEC4_2 | DEC | 6 | 2 | Depth of facing | ||
35 | FACUNIT | COMT_UNIT | MEINS | UNIT | 3 | 0 | Units of Measure of Product | T006 | |
36 | .INCLUDE | 0 | 0 | Activity: Price_check_reporting | |||||
37 | SPRICE | CRMT_SALES_PRICE_IN_STORE | CRMT_ACT_CURRENCY | CURR | 28 | 2 | Sales Price in store | ||
38 | OPRICE | CRMT_ACT_ORDER_PRICE_IN_STORE | CRMT_ACT_CURRENCY | CURR | 28 | 2 | Order Price in store | ||
39 | APRICE | CRMT_ACTION_PRICE_IN_STORE | CRMT_ACT_CURRENCY | CURR | 28 | 2 | Promotion price in store | ||
40 | KVCURR1 | CRMT_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
41 | .INCLUDE | 0 | 0 | Activity: Pharama fields Reporting | |||||
42 | PHREFNR | CRMT_ACT_PHARMA_REF_NUMBER | TEXT10 | CHAR | 10 | 0 | Pharmaceutical Reference Number | ||
43 | .INCLUDE | 0 | 0 | Activity: Free Samples Reporting | |||||
44 | STORNO | STORNO | CHAR1_X | CHAR | 1 | 0 | Indicator: Data to Be Canceled | ||
45 | LBVAL | CRMT_ACT_VALUE_LEFT_BEHIND | DEC13_2 | DEC | 15 | 2 | Value of Samples | ||
46 | .INCLUDE | 0 | 0 | Activity Managment: IBU CP fields for Activity Journals | |||||
47 | EDAY_LOW_PRICE | EVERYDAY_LOW_PRICE | EVERYDAY_LOW_PRICE | CURR | 12 | 2 | Everyday-Low-Price | ||
48 | LISTING_FEE | LISTING_FEE | LISTING_FEE | CURR | 12 | 2 | Listing Fee | ||
49 | PRP_RANK | CRMT_PRP_RANK | CRM_PRP_RANK | NUMC | 10 | 0 | Rank Indicator of a PPR | * | |
50 | KVCURR | CRMT_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
51 | .INCLUDE | 0 | 0 | Activity: Structure provided for easy integration of MSA | |||||
52 | PRAVA0 | CRMT_ACT_MSA_PRAVA0 | CRM_ACT_MSA_PLACEHOLDERS | CHAR | 3 | 0 | Placeholder for MSA fields | * | |
53 | PRAVA1 | CRMT_ACT_MSA_PRAVA1 | CRM_ACT_MSA_PLACEHOLDERS | CHAR | 3 | 0 | Placeholder for MSA fields | * | |
54 | PRAVA2 | CRMT_ACT_MSA_PRAVA2 | CRM_ACT_MSA_PLACEHOLDERS | CHAR | 3 | 0 | Placeholder for MSA fields | * | |
55 | PRAVA3 | CRMT_ACT_MSA_PRAVA3 | CRM_ACT_MSA_PLACEHOLDERS | CHAR | 3 | 0 | Placeholder for MSA fields | * | |
56 | PRAVA4 | CRMT_ACT_MSA_PRAVA4 | CRM_ACT_MSA_PLACEHOLDERS | CHAR | 3 | 0 | Placeholder for MSA fields | * | |
57 | PRAVB0 | CRMT_ACT_MSA_PRAVB0 | CRM_ACT_MSA_PLACEHOLDERS | CHAR | 3 | 0 | Placeholder for MSA fields | * | |
58 | PRAVB1 | CRMT_ACT_MSA_PRAVB1 | CRM_ACT_MSA_PLACEHOLDERS | CHAR | 3 | 0 | Placeholder for MSA fields | * | |
59 | PRAVB2 | CRMT_ACT_MSA_PRAVB2 | CRM_ACT_MSA_PLACEHOLDERS | CHAR | 3 | 0 | Placeholder for MSA fields | * | |
60 | PRAVB3 | CRMT_ACT_MSA_PRAVB3 | CRM_ACT_MSA_PLACEHOLDERS | CHAR | 3 | 0 | Placeholder for MSA fields | * | |
61 | PRAVB4 | CRMT_ACT_MSA_PRAVB4 | CRM_ACT_MSA_PLACEHOLDERS | CHAR | 3 | 0 | Placeholder for MSA fields | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_ACTIVITY_I_ADD_FIELDS | DEKOTP | CRMC_ACT_DECOT | DEKOTP | |||
2 | CRMT_ACTIVITY_I_ADD_FIELDS | ECROPT | CRMC_ACT_CURES | ECROPT | |||
3 | CRMT_ACTIVITY_I_ADD_FIELDS | FACUNIT | T006 | MSEHI | |||
4 | CRMT_ACTIVITY_I_ADD_FIELDS | KV_DEKO | CRMC_ACT_DECOM | KV_DEKO | |||
5 | CRMT_ACTIVITY_I_ADD_FIELDS | KV_RESULT | CRMC_ACT_RSLT | KV_RESULT | |||
6 | CRMT_ACTIVITY_I_ADD_FIELDS | MEABM | T006 | MSEHI | |||
7 | CRMT_ACTIVITY_I_ADD_FIELDS | POSHOR | CRMC_ACT_POSHR | POSHOR | |||
8 | CRMT_ACTIVITY_I_ADD_FIELDS | POSLOC | CRMC_ACT_MPLCT | POSLOC | |||
9 | CRMT_ACTIVITY_I_ADD_FIELDS | POSQLI | CRMC_ACT_POSQL | POSQLI | |||
10 | CRMT_ACTIVITY_I_ADD_FIELDS | POSVER | CRMC_ACT_POSVR | POSVER | |||
11 | CRMT_ACTIVITY_I_ADD_FIELDS | PRAVA | CRMC_ACT_PRAVA | PRAVA | |||
12 | CRMT_ACTIVITY_I_ADD_FIELDS | PRAVB | CRMC_ACT_PRAVB | PRAVB | |||
13 | CRMT_ACTIVITY_I_ADD_FIELDS | RESREAS | CRMC_ACT_RESRS | RESREAS | |||
14 | CRMT_ACTIVITY_I_ADD_FIELDS | SUBJECTA | CRMC_ACT_SBJTA | SUBJECTA | |||
15 | CRMT_ACTIVITY_I_ADD_FIELDS | SUBJECTB | CRMC_ACT_SBJTB | SUBJECTB |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 400 |