SAP ABAP Table CRMS_MKTPL_FUSG_EXT (External Attributes for Fund Usage Association)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-MPL-TPM-CFI (Application Component) Claims and Funds Integration for TPM
     ⤷ CRM_MKTPL_ASSIGN_FUND (Package) CRM Marketing Planning - Assignments: TPM Fund Integration

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_MKTPL_FUSG_EXT	Table Relationship Diagram
Short Description	External Attributes for Fund Usage Association

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	.INCLUDE	☐				0	0	TFM-fund usage: Header attributes
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☐	CRM_FM_FU_HEADER_GUID	SYSUUID	RAW	16	0	Trade Promotion: Fund Usage Header GUID
4	.INCLUDE	☐				0	0	TFM-Fund Usage: FU header db table includes
5	.INCLUDE	☐				0	0	Funds Management Reference Object
6	REF_OBJKEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
7	REF_OBJTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
8	REF_LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
9	EXPENSE_TYPE	☐	CRM_FM_FU_EXPENSE_TYPE	CRM_FM_FU_EXPENSE_TYPE	CHAR	4	0	Expense Type
10	EXTERNAL_ID	☐	CRM_FM_FU_HEADER_ID	CHAR24	CHAR	24	0	Trade Promotion: Fund Usage ID
11	FUND_PLAN_GUID	☐	CRM_FM_FND_FUNDPLAN_GUID	SYSUUID	RAW	16	0	Funds Plan GUID
12	ACCRUAL_PROFILE	☐	CRM_FM_ACL_PROFILE_ID	CRM_FM_ACL_PROFILE_ID	CHAR	8	0	Accrual Profile ID	*
13	ACCRUAL_START_DT	☐	CRM_FM_FU_DATE	BCOS_TSTMP	DEC	15	0	Funds Management: Date (UTC Timestamp in Short Format)
14	ACCRUAL_END_DT	☐	CRM_FM_FU_DATE	BCOS_TSTMP	DEC	15	0	Funds Management: Date (UTC Timestamp in Short Format)
15	TIME_ZONE	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	*
16	.INCLUDE	☐				0	0	TFM-Fund usage: Administrative information
17	CREATED_ON	☐	CRM_FM_FU_DATE	BCOS_TSTMP	DEC	15	0	Funds Management: Date (UTC Timestamp in Short Format)
18	CHANGED_ON	☐	CRM_FM_FU_DATE	BCOS_TSTMP	DEC	15	0	Funds Management: Date (UTC Timestamp in Short Format)
19	CREATED_BY	☐	CRM_FM_FU_USER	USNAM	CHAR	12	0	FM Fund Usage: User Name
20	CHANGED_BY	☐	CRM_FM_FU_USER	USNAM	CHAR	12	0	FM Fund Usage: User Name
21	.INCLUDE	☐				0	0	Extensibility for Fund usage header
22	FU_H_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
23	STSMA	☐	CRM_J_STSMA	CRM_J_STSMA	CHAR	8	0	Status Profile	*
24	STAT	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
25	DESCRIPTION	☐	CRM_FM_FU_TEXT	TEXT40	CHAR	40	0	Funds Management: Fund Usage Description
26	.INCLUDE	☐				0	0	Fund key Attributes Structure
27	PROD_CATEG_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
28	PROD_GROUP_ID	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
29	PROD_GROUP_NO	☐	CRM_FM_FND_FUND_ATTR_PGRP_NO	NUMC1	NUMC	1	0	Fund Attributes Product Group Number
30	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
31	BP_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
32	BPH_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
33	TERRITORY_GUID	☐	CRMT_TERRITORY_GUID	SYSUUID	RAW	16	0	Territory GUID
34	PROJECT_KEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
35	PROJECT_TYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
36	MKT_ORG	☐	CRM_MKTPL_MORG	HROBJEC_14	CHAR	14	0	Marketing Organization
37	.INCLUDE	☐				0	0	TFM-Fund usage: Sales Area Data for Fund Usage Header
38	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
39	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
40	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
41	SERVICES_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization

History

Last changed by/on	SAP	20130604
SAP Release Created in	700