SAP ABAP Table CRMS_MKTPL_ALLOC_DATA (Allocation: Structure for 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	INTTAB	Structure
Structure	CRMS_MKTPL_ALLOC_DATA	Table Relationship Diagram
Short Description	Allocation: Structure for allocation data

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	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
2	BP_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
3	ALQSTAT_DESCR	☐	CRM_MKTPL_ALQSTATUS_DESCR		CHAR	20	0	Allocation: Status Description for Allocated Quantity
4	.INCLUDE	☐				0	0	Allocation Data
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
6	ALLOCDATAGUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
7	ALLOCGUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)	CRMD_MKTPL_AL00
8	TARGETGRP_GUID	☐	CRMT_TARGETGRP_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID of Target Group	CRMD_MKTTG_TG_H
9	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
10	BP_GUID	☐	CRMT_TG_BP_GUID	SYSUUID	RAW	16	0	CRM Marketing: Target Group Business Partner GUID
11	PLAN_QUAN	☐	CRM_MKTPL_PLAN_QUAN		QUAN	17	3	Allocation: Planned Quantity
12	ACT_QUAN	☐	CRM_MKTPL_ACT_QUAN		QUAN	17	3	Allocation: Actual Quantity
13	STATUS	☐	CRM_MKTPL_ALACTSTAT		CHAR	1	0	Allocation: Status of Actual Quantities	CRMC_MKTPL_AL04
14	ALPRIO	☐	CRM_MKTPL_ALPRIO	CRM_MKTPL_ALPRIO	CHAR	1	0	Allocation: Priority	CRMC_MKTPL_AL03
15	DATE_FROM	☐	CRM_MKTPL_ALFROM		DATS	8	0	Allocation: "Valid From" Date
16	DATE_TO	☐	CRM_MKTPL_ALTO		DATS	8	0	Allocation: "Valid To" Date
17	ALUOM	☐	CRM_MKTPL_ALUOM	MEINS	UNIT	3	0	Allocation: Unit of Measure	*
18	.INCLUDE	☐				0	0	Allocation: Statistics Info
19	UNAME	☐	UNAME	UNAME	CHAR	12	0	User Name
20	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
21	ATIME	☐	AS4TIME	AS4TIME	TIMS	6	0	Last changed at

Foreign Keys

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

History

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