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
⤷ 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 | Table Relationship Diagram |
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 | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | ALLOCGUID | SYSUUID_X | SYSUUID | RAW | 16 | 0 | UUID in X form (binary) | CRMD_MKTPL_AL00 | |
3 | PRODUCT_GUID | COMT_PRODUCT_GUID | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | COMM_PRODUCT | |
4 | GUID | SYSUUID_X | SYSUUID | RAW | 16 | 0 | UUID in X form (binary) | ||
5 | ALRULE | CRM_MKTPL_ALRULE | CRM_MKTPL_ALRULE | CHAR | 10 | 0 | Allocation Rule | CRMC_MKTPL_AL02 | |
6 | RLIMIT | CRM_MKTPL_RLIMIT | DEC | 2 | 1 | Allocation: Rounding Limit | |||
7 | MINQUAN | CRM_MKTPL_ALMINQUAN | QUAN | 17 | 3 | Allocation: Minimum Quantity to be Allocated to a BP | |||
8 | MAXQUAN | CRM_MKTPL_ALMAXQUAN | QUAN | 17 | 3 | Allocation: Maximum Quantity to be Allocated | |||
9 | LIFT | CRM_MKTPL_ALLIFT | CRM_MKTPL_ALLIFT | DEC | 5 | 2 | Allocation: Lift Percentage | ||
10 | REFERENCE | CRM_MKTPL_ALREF | CRM_MKTPL_ALREF | CHAR | 40 | 0 | Allocation: Reference at Product Level | ||
11 | VALUATION | CRM_MKTPL_VALUATION | CURR | 17 | 2 | Allocation: Value Used to Valuate Quantities | |||
12 | ALQUANTITY | CRM_MKTPL_ALQUANTITY | QUAN | 17 | 3 | Allocation Quantity | |||
13 | ALUOM | CRM_MKTPL_ALUOM | MEINS | UNIT | 3 | 0 | Allocation: Unit of Measure | * | |
14 | ALBUDGET | CRM_MKTPL_ALBUDGET | CURR | 17 | 2 | Allocation: Budget | |||
15 | VALIDITY | 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 | CRMD_MKTPL_AL00 | ALLOCGUID | KEY | 1 | CN |
2 | CRMD_MKTPL_AL01 | ALRULE | CRMC_MKTPL_AL02 | ALRULE | REF | 1 | CN |
3 | CRMD_MKTPL_AL01 | MANDT | T000 | MANDT | KEY | 1 | CN |
4 | CRMD_MKTPL_AL01 | PRODUCT_GUID | COMM_PRODUCT | CLIENT | KEY | 1 | CN |
History
Last changed by/on | SAP | 20060411 |
SAP Release Created in | 30A |