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   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