SAP ABAP Table CRMD_MKTPL_AL03 (Allocation Data)

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_AL03	Table Relationship Diagram
Short Description	Allocation Data

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	*
2	ALLOCDATAGUID	☑	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
3	ALLOCGUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)	CRMD_MKTPL_AL00
4	TARGETGRP_GUID	☐	CRMT_TARGETGRP_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID of Target Group	CRMD_MKTTG_TG_H
5	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
6	BP_GUID	☐	CRMT_TG_BP_GUID	SYSUUID	RAW	16	0	CRM Marketing: Target Group Business Partner GUID
7	PLAN_QUAN	☐	CRM_MKTPL_PLAN_QUAN		QUAN	17	3	Allocation: Planned Quantity
8	ACT_QUAN	☐	CRM_MKTPL_ACT_QUAN		QUAN	17	3	Allocation: Actual Quantity
9	STATUS	☐	CRM_MKTPL_ALACTSTAT		CHAR	1	0	Allocation: Status of Actual Quantities	CRMC_MKTPL_AL04
10	ALPRIO	☐	CRM_MKTPL_ALPRIO	CRM_MKTPL_ALPRIO	CHAR	1	0	Allocation: Priority	CRMC_MKTPL_AL03
11	DATE_FROM	☐	CRM_MKTPL_ALFROM		DATS	8	0	Allocation: "Valid From" Date
12	DATE_TO	☐	CRM_MKTPL_ALTO		DATS	8	0	Allocation: "Valid To" Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMD_MKTPL_AL03	ALLOCGUID	CRMD_MKTPL_AL00	ALLOCGUID	KEY	1	CN
2	CRMD_MKTPL_AL03	ALPRIO	CRMC_MKTPL_AL03	ALPRIO
3	CRMD_MKTPL_AL03	STATUS	CRMC_MKTPL_AL04	STATUS
4	CRMD_MKTPL_AL03	TARGETGRP_GUID	CRMD_MKTTG_TG_H	CLIENT	KEY	1	CN

History

Last changed by/on	SAP	20040219
SAP Release Created in	30A