SAP ABAP Table CRMS_MKTPL_FUSGI (Fund usage item)

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_FUSGI	Table Relationship Diagram
Short Description	Fund usage item

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	Link between the Fund Usage Header and Fund Usage items
2	FUND_UI_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
3	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
4	PRODUCT_GROUP	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
5	.INCLUDE	☐				0	0	MKTGS OL: Generic Assignment CGPL Key Include
6	PROJECT_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
7	TASK_GUID	☐	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
8	GUID	☐	SYSUUID_X	SYSUUID	RAW	16	0	UUID in X form (binary)
9	.INCLUDE	☐				0	0	MKTGS OL: Key include for sub-assignments
10	ASSIGN_GUID	☐	CRM_MKTGS_GUID		RAW	16	0	MKTGS OL: Generic Marketing Guid
11	.INCLUDE	☐				0	0	TFM-Fund Usage: Fund Usage Item include for db table
12	HEADER_GUID	☐	CRM_FM_FU_HEADER_GUID	SYSUUID	RAW	16	0	Trade Promotion: Fund Usage Header GUID	CRMD_FM_FU_HEAD
13	FUND_GUID	☐	CRM_FM_FND_FUND_GUID	SYSUUID	RAW	16	0	GUID of Fund Business Object
14	EXTERNAL_ID	☐	CRM_FM_FU_ITEM_ID		NUMC	4	0	TFM Fund Usage: ITEM External ID
15	LOGICAL_DELETE	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
16	CREATED_EXTERNAL	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
17	.INCLUDE	☐				0	0	TFM-Fund usage: Administrative information
18	CREATED_ON	☐	CRM_FM_FU_DATE	BCOS_TSTMP	DEC	15	0	Funds Management: Date (UTC Timestamp in Short Format)
19	CHANGED_ON	☐	CRM_FM_FU_DATE	BCOS_TSTMP	DEC	15	0	Funds Management: Date (UTC Timestamp in Short Format)
20	CREATED_BY	☐	CRM_FM_FU_USER	USNAM	CHAR	12	0	FM Fund Usage: User Name
21	CHANGED_BY	☐	CRM_FM_FU_USER	USNAM	CHAR	12	0	FM Fund Usage: User Name
22	.INCLUDE	☐				0	0	Extensibility for Fund usage item
23	FU_I_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
24	.INCLUDE	☐				0	0	Fund key Attributes Structure
25	PROD_CATEG_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
26	PROD_GROUP_ID	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
27	PROD_GROUP_NO	☐	CRM_FM_FND_FUND_ATTR_PGRP_NO	NUMC1	NUMC	1	0	Fund Attributes Product Group Number
28	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
29	BP_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
30	BPH_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
31	TERRITORY_GUID	☐	CRMT_TERRITORY_GUID	SYSUUID	RAW	16	0	Territory GUID
32	PROJECT_KEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
33	PROJECT_TYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
34	MKT_ORG	☐	CRM_MKTPL_MORG	HROBJEC_14	CHAR	14	0	Marketing Organization
35	.INCLUDE	☐				0	0	TFM-Fund usage: Sales Area Data for Fund Usage Header
36	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
37	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
38	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
39	SERVICES_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_MKTPL_FUSGI	HEADER_GUID	CRMD_FM_FU_HEAD	GUID

History

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