SAP ABAP Table ACT_PRDS_MV (Default Fieds for Prefilled Products)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM-MD-PPR (Application Component) Partner/Product Range
⤷
CRM_PRP_ACT_OBJECT_EXTENSION (Package) PPR Object Extensions for Activities
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | ACT_PRDS_MV |
|
| Short Description | Default Fieds for Prefilled Products |
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 | |
ACT_BREIT | ACT_BREIT | QUAN | 13 | 0 | Width of the Product or of the Packaging | ||
| 2 | |
ACT_BREIT_U | MEINS | UNIT | 3 | 0 | Width of the Product or of the Packaging | T006 | |
| 3 | |
ACT_BRGEW | ACT_BRGEW | QUAN | 15 | 3 | Gross Weight | ||
| 4 | |
ACT_BRGEW_U | MEINS | UNIT | 3 | 0 | Gross Weight | T006 | |
| 5 | |
ACT_NTGEW | ACT_NTGEW | QUAN | 15 | 3 | Net Weight | ||
| 6 | |
ACT_NTGEW_U | MEINS | UNIT | 3 | 0 | Net Weight | T006 | |
| 7 | |
ACT_GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | T006 | |
| 8 | |
ACT_VOLUM | ACT_VOLUM | QUAN | 15 | 0 | Volume | ||
| 9 | |
ACT_VOLUM_U | MEINS | UNIT | 3 | 0 | Volume | T006 | |
| 10 | |
ACT_VOLEH | MEINS | UNIT | 3 | 0 | Unit for the Volume | T006 | |
| 11 | |
ACT_NROFSAM | ACT_NROFSAM | QUAN | 4 | 0 | Number of samples | ||
| 12 | |
ACT_NROFSAM_U | MEINS | UNIT | 3 | 0 | Number of samples | T006 | |
| 13 | |
ACT_PRDS_STATUS | ACT_PRDS_STATUS | CHAR | 3 | 0 | Status of documented product | ||
| 14 | |
ACT_SAMTOBESENT | ACT_SAMTOBESENT | CHAR | 1 | 0 | Product Request | ||
| 15 | |
ACT_SAMRETURN | ACT_SAMRETURN | CHAR | 1 | 0 | Flag for Returns | ||
| 16 | |
ACT_DISCUSS | ACT_DISCUSS | CHAR | 1 | 0 | Discussed | ||
| 17 | |
ACT_PRPRIO | ACT_PRPRIO | CHAR | 3 | 0 | Product Priority | ||
| 18 | |
ACT_QTY_UNIT | MEINS | UNIT | 3 | 0 | Sales Unit | T006 | |
| 19 | |
ACT_LAENG | ACT_LAENG | QUAN | 13 | 0 | Length of the Product or of the Packagin | ||
| 20 | |
ACT_LAENG_U | MEINS | UNIT | 3 | 0 | Length of the Product or of the Packagin | T006 | |
| 21 | |
ACT_HOEHE | ACT_HOEHE | QUAN | 13 | 0 | Height of the Product or of the Packaging | ||
| 22 | |
ACT_HOEHE_U | MEINS | UNIT | 3 | 0 | Height of the Product or of the Packagin | T006 | |
| 23 | |
ACT_MEABM | MEINS | UNIT | 3 | 0 | Unit in Which Length/Width/Height Is Mea | T006 | |
| 24 | |
ACT_PRAVA | CRM_ACT_PROD_AVAILABLE_AFTER | CHAR | 3 | 0 | Product available after visit at checkou | * | |
| 25 | |
ACT_PRAVB | CRM_ACT_PROD_AVAILABLE_BEFORE | CHAR | 3 | 0 | Product available before Visit at check | * | |
| 26 | |
ACT_SUBJECTA | CRM_ACT_SUBJECTA | CHAR | 10 | 0 | Free Text: Subject A | * | |
| 27 | |
ACT_PRDS_EXPLOSION | ACT_PRDS_EXPLOSION | CHAR | 1 | 0 | Product Category/Heirarcy Explosion | ||
| 28 | |
ACT_SUBJECTB | CRM_ACT_SUBJECTB | CHAR | 10 | 0 | Free Text: Subject B | * | |
| 29 | |
ACT_RESREAS | CRM_ACT_KVRESF | CHAR | 1 | 0 | Result Reason | * | |
| 30 | |
ACT_DEKOTP | CRM_ACT_DECO_TYPE | CHAR | 3 | 0 | Decoration Type | * | |
| 31 | |
ACT_KV_STOCK | ACT_KV_STOCK | DEC | 6 | 0 | Number of Products in stocks | ||
| 32 | |
ACT_KV_RESULT | CRM_ACT_KVRESF | CHAR | 1 | 0 | Result | * | |
| 33 | |
ACT_KV_DEKO | CRM_ACT_DECO_MATERIAL | CHAR | 3 | 0 | Deko-Material | * | |
| 34 | |
ACT_POSLOC | CRM_ACT_MAIN_LOCATION | CHAR | 3 | 0 | main location of placement, eg. pallet, | * | |
| 35 | |
ACT_KV_ZPANZ | ACT_KV_ZPANZ | DEC | 3 | 0 | Number of Second placements | ||
| 36 | |
ACT_KV_ZPAVA | CRM_ACT_SDPMT | CHAR | 1 | 0 | Second Placement Available | * | |
| 37 | |
ACT_NRMSHF | ACT_NRMSHF | DEC | 6 | 0 | Number of produts in main shelf | ||
| 38 | |
ACT_NRPSHF | ACT_NRPSHF | DEC | 6 | 0 | Number of Products on Promotion Shelf | ||
| 39 | |
ACT_POSVER | CRM_ACT_VERTICAL_POS_IN_SHELF | CHAR | 3 | 0 | vertical position in shelf | * | |
| 40 | |
ACT_POSHOR | CRM_ACT_HORIZONT_POS_IN_SHELF | CHAR | 3 | 0 | horizontal position in shelf | * | |
| 41 | |
ACT_POSQLI | CRMT_ACT_QUALI_OF_SHELF_POS | CHAR | 3 | 0 | Qualification of the shelf position | * | |
| 42 | |
ACT_ECROPT | CRM_ACT_SHELF_OPTIMIZATION | CHAR | 3 | 0 | Optimization of the Shelf | * | |
| 43 | |
ACT_NROFFAC | ACT_NROFFAC | DEC | 4 | 0 | Number of facings | ||
| 44 | |
ACT_FACLEN | ACT_FACLEN | DEC | 6 | 0 | Length of Facing | ||
| 45 | |
ACT_FACWID | ACT_FACWID | DEC | 6 | 0 | Width of Facing | ||
| 46 | |
ACT_FACDEP | ACT_FACDEP | DEC | 6 | 2 | Depth of Facing | ||
| 47 | |
ACT_FACUNIT | MEINS | UNIT | 3 | 0 | Units of Measure for the Product | T006 | |
| 48 | |
ACT_SPRICE | ACT_SPRICE | CURR | 23 | 2 | Sales Price in store | ||
| 49 | |
ACT_SPRICE_C | WAERS | CUKY | 5 | 0 | Sales Price in store | TCURC | |
| 50 | |
ACT_OPRICE | ACT_OPRICE | CURR | 23 | 2 | Order Price in store | ||
| 51 | |
ACT_OPRICE_C | WAERS | CUKY | 5 | 0 | Order Price in store | TCURC | |
| 52 | |
ACT_APRICE | ACT_APRICE | CURR | 23 | 2 | Promotion Price in Store | ||
| 53 | |
ACT_APRICE_C | WAERS | CUKY | 5 | 0 | Promotion Price in Store | TCURC | |
| 54 | |
ACT_KVCURR1 | WAERS | CUKY | 5 | 0 | Currency | TCURC | |
| 55 | |
ACT_STORNO | ACT_STORNO | CHAR | 1 | 0 | Indicator: Data to Be Canceled | ||
| 56 | |
ACT_LBVAL | ACT_LBVAL | DEC | 15 | 2 | Value of Samples | ||
| 57 | |
ACT_PHREFNR | ACT_PHREFNR | CHAR | 10 | 0 | Pharmaceutical Reference Number | ||
| 58 | |
ACT_EDAY_LOW_PRICE | ACT_EDAY_LOW_PRICE | CURR | 12 | 2 | Everyday Low Price | ||
| 59 | |
ACT_EDAY_LOW_PRICE_C | WAERS | CUKY | 5 | 0 | Everyday Low Price | TCURC | |
| 60 | |
LISTING_FEE | LISTING_FEE | CURR | 12 | 2 | Listing Fee | ||
| 61 | |
LISTING_FEE_C | WAERS | CUKY | 5 | 0 | Listing Fee | TCURC | |
| 62 | |
ACT_BATCH_ID | ACT_BATCH_ID | CHAR | 10 | 0 | Batch ID | ||
| 63 | |
ACT_ENTERED_PRODCUT | ACT_ENTERED_PRODCUT | CHAR | 54 | 0 | Entered Product ID | ||
| 64 | |
ACT_ALTID_TYPE | ACT_ALTID_TYPE | CHAR | 16 | 0 | Alternative ID Type |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | ACT_PRDS_MV | APRICE_C | |
|
|||
| 2 | ACT_PRDS_MV | BREIT_U | |
|
|||
| 3 | ACT_PRDS_MV | BRGEW_U | |
|
|||
| 4 | ACT_PRDS_MV | EDAY_LOW_PRICE_C | |
|
|||
| 5 | ACT_PRDS_MV | FACUNIT | |
|
|||
| 6 | ACT_PRDS_MV | GEWEI | |
|
|||
| 7 | ACT_PRDS_MV | HOEHE_U | |
|
|||
| 8 | ACT_PRDS_MV | KVCURR1 | |
|
|||
| 9 | ACT_PRDS_MV | LAENG_U | |
|
|||
| 10 | ACT_PRDS_MV | LISTING_FEE_C | |
|
|||
| 11 | ACT_PRDS_MV | MEABM | |
|
|||
| 12 | ACT_PRDS_MV | NROFSAM_U | |
|
|||
| 13 | ACT_PRDS_MV | NTGEW_U | |
|
|||
| 14 | ACT_PRDS_MV | OPRICE_C | |
|
|||
| 15 | ACT_PRDS_MV | QTY_UNIT | |
|
|||
| 16 | ACT_PRDS_MV | SPRICE_C | |
|
|||
| 17 | ACT_PRDS_MV | VOLEH | |
|
|||
| 18 | ACT_PRDS_MV | VOLUM_U | |
|
History
| Last changed by/on | SAP | 20050315 |
| SAP Release Created in | 400 |