SAP ABAP Table CRMD_MKTPL_AL01 (Allocation Data: Product Assignments)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM-MKT-MPL (Application Component) Marketing Planner
⤷
CRM_MKTPL_ALLOC (Package) Marketing Planning: Allocation
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | CRMD_MKTPL_AL01 |
|
| Short Description | Allocation Data: Product Assignments |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
SYSUUID_X | SYSUUID | RAW | 16 | 0 | UUID in X form (binary) | CRMD_MKTPL_AL00 | |
| 3 | |
COMT_PRODUCT_GUID | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | COMM_PRODUCT | |
| 4 | |
SYSUUID_X | SYSUUID | RAW | 16 | 0 | UUID in X form (binary) | ||
| 5 | |
CRM_MKTPL_ALRULE | CRM_MKTPL_ALRULE | CHAR | 10 | 0 | Allocation Rule | CRMC_MKTPL_AL02 | |
| 6 | |
CRM_MKTPL_RLIMIT | DEC | 2 | 1 | Allocation: Rounding Limit | |||
| 7 | |
CRM_MKTPL_ALMINQUAN | QUAN | 17 | 3 | Allocation: Minimum Quantity to be Allocated to a BP | |||
| 8 | |
CRM_MKTPL_ALMAXQUAN | QUAN | 17 | 3 | Allocation: Maximum Quantity to be Allocated | |||
| 9 | |
CRM_MKTPL_ALLIFT | CRM_MKTPL_ALLIFT | DEC | 5 | 2 | Allocation: Lift Percentage | ||
| 10 | |
CRM_MKTPL_ALREF | CRM_MKTPL_ALREF | CHAR | 40 | 0 | Allocation: Reference at Product Level | ||
| 11 | |
CRM_MKTPL_VALUATION | CURR | 17 | 2 | Allocation: Value Used to Valuate Quantities | |||
| 12 | |
CRM_MKTPL_ALQUANTITY | QUAN | 17 | 3 | Allocation Quantity | |||
| 13 | |
CRM_MKTPL_ALUOM | MEINS | UNIT | 3 | 0 | Allocation: Unit of Measure | * | |
| 14 | |
CRM_MKTPL_ALBUDGET | CURR | 17 | 2 | Allocation: Budget | |||
| 15 | |
CRM_MKTPL_ALVALID | CRM_MKTPL_ALVALID | CHAR | 1 | 0 | Allocation: Validity of Allocation Data |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | CRMD_MKTPL_AL01 | ALLOCGUID | |
|
KEY | 1 | CN |
| 2 | CRMD_MKTPL_AL01 | ALRULE | |
|
REF | 1 | CN |
| 3 | CRMD_MKTPL_AL01 | MANDT | |
|
KEY | 1 | CN |
| 4 | CRMD_MKTPL_AL01 | PRODUCT_GUID | |
|
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20060411 |
| SAP Release Created in | 30A |