SAP ABAP Table CRMS_BOL_FM_FU_ITEM_ATTR (Attributes of Fund Usages item object)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-FM-FU (Application Component) Fund Usages
     ⤷ CRM_FM_BOL_FU (Package) BOL/GENIL Implementation of FU

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_BOL_FM_FU_ITEM_ATTR	Table Relationship Diagram
Short Description	Attributes of Fund Usages item object

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 Usages: Fund Usages items
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☐	CRM_FM_FU_ITEM_GUID	SYSUUID	RAW	16	0	TFM Fund Usage: Fund Usage Item Guid
4	.INCLUDE	☐				0	0	TFM-Fund Usage: Fund Usage Item include for db table
5	HEADER_GUID	☐	CRM_FM_FU_HEADER_GUID	SYSUUID	RAW	16	0	Trade Promotion: Fund Usage Header GUID	CRMD_FM_FU_HEAD
6	FUND_GUID	☐	CRM_FM_FND_FUND_GUID	SYSUUID	RAW	16	0	GUID of Fund Business Object
7	EXTERNAL_ID	☐	CRM_FM_FU_ITEM_ID		NUMC	4	0	TFM Fund Usage: ITEM External ID
8	LOGICAL_DELETE	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
9	CREATED_EXTERNAL	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
10	.INCLUDE	☐				0	0	TFM-Fund usage: Administrative information
11	CREATED_ON	☐	CRM_FM_FU_DATE	BCOS_TSTMP	DEC	15	0	Funds Management: Date (UTC Timestamp in Short Format)
12	CHANGED_ON	☐	CRM_FM_FU_DATE	BCOS_TSTMP	DEC	15	0	Funds Management: Date (UTC Timestamp in Short Format)
13	CREATED_BY	☐	CRM_FM_FU_USER	USNAM	CHAR	12	0	FM Fund Usage: User Name
14	CHANGED_BY	☐	CRM_FM_FU_USER	USNAM	CHAR	12	0	FM Fund Usage: User Name
15	.INCLUDE	☐				0	0	Extensibility for Fund usage item
16	FU_I_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
17	.INCLUDE	☐				0	0	Fund key Attributes Structure
18	PROD_CATEG_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
19	PROD_GROUP_ID	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
20	PROD_GROUP_NO	☐	CRM_FM_FND_FUND_ATTR_PGRP_NO	NUMC1	NUMC	1	0	Fund Attributes Product Group Number
21	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
22	BP_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
23	BPH_GUID	☐	BU_NODE_GUID	SYSUUID	RAW	16	0	GUID of Hierarchy Node
24	TERRITORY_GUID	☐	CRMT_TERRITORY_GUID	SYSUUID	RAW	16	0	Territory GUID
25	PROJECT_KEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
26	PROJECT_TYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
27	MKT_ORG	☐	CRM_MKTPL_MORG	HROBJEC_14	CHAR	14	0	Marketing Organization
28	.INCLUDE	☐				0	0	TFM-Fund usage: Sales Area Data for Fund Usage Header
29	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
30	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
31	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
32	SERVICES_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
33	FUND_DESC	☐	CRM_FM_FND_FUND_DESC	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Description of Funds Plan Business Object
34	FUND_TYPE	☐	CRM_FM_FND_FUNDPLAN_TYPE	CHAR4	CHAR	4	0	Funds Plan Type
35	FUNDPLAN_ID	☐	CRM_FM_FND_FUNDPLAN_ID	CRM_OBJECT_ID	CHAR	10	0	Funds Plan ID
36	FUNDPLAN_DESC	☐	CRM_FM_FND_FUNDPLAN_DESC	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Description of Funds Plan Business Object
37	FUND_ID	☐	CRM_FM_FND_FUND_ID	CRM_OBJECT_ID	CHAR	10	0	Fund ID
38	PROD_CAT_DESC	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
39	PROD_GROUP_DESC	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
40	BP_DESC	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
41	BPH_DESC	☐	BU_NODE_DESCRIPTION	BU_TEXT40	CHAR	40	0	Description of a Hierarchy Node
42	PRODUCT_DESC	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
43	MPL_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
44	MPL_DESC	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
45	MKT_ORG_DESC	☐	CRM_MKTPL_MORG_DESC	CRM_MKTPL_MORG_DESC	CHAR	40	0	Marketing Organization Description
46	.INCLUDE	☐				0	0	FM Fund Posting Aggregates All Key Figures
47	.INCLUDE	☐				0	0	FM Fund Postings Aggregates Standard Key Figures
48	.INCLUDE	☐				0	0	Aggregated Key Figures generated by value flows
49	FM_CURRENCY	☐	CRM_FM_FPO_CURRENCY	WAERS	CUKY	5	0	Currency Key	*
50	BUDGET	☐	CRM_FM_FPO_AGR_BUDGET	WERTV8	CURR	15	2	Budget
51	PRERESERVED	☐	CRM_FM_FPO_AGR_PRERESERVED	WERTV8	CURR	15	2	Prereserved
52	RESERVED	☐	CRM_FM_FPO_AGR_RESERVED	WERTV8	CURR	15	2	Reserved
53	UNCONSUMEDBUDGET	☐	CRM_FM_FPO_AGR_UNCONSUMED_BDGT	WERTV8	CURR	15	2	Unconsumed Budget
54	PENDING_CLAIM	☐	CRM_FM_FPO_AGR_PENDING_CLAIM	WERTV8	CURR	15	2	Pending Claim
55	APPROVED_CLAIM	☐	CRM_FM_FPO_AGR_APPROVED_CLAIM	WERTV8	CURR	15	2	Approved Claim
56	EXP_APPROVED_CLA	☐	CRM_FM_FPO_AGR_EXP_APPRO_CLAIM	WERTV8	CURR	15	2	Expired Approved Claim
57	RELEASED_SETTLE	☐	CRM_FM_FPO_AGR_RELEASED_SETTLE	WERTV8	CURR	15	2	Released-to-Settle
58	SETTLED	☐	CRM_FM_FPO_AGR_SETTLED	WERTV8	CURR	15	2	Settled
59	EXT_SETTLED	☐	CRM_FM_FPO_AGR_EXT_SETTLED	WERTV8	CURR	15	2	Externally Settled
60	EXPENSED	☐	CRM_FM_FPO_AGR_EXPENSED	WERTV8	CURR	15	2	Expensed
61	WRITTEN_OFF	☐	CRM_FM_FPO_AGR_WRITTEN_OFF	WERTV8	CURR	15	2	Written Off
62	CHARGEBACK_BAL	☐	CRM_FM_FPO_AGR_CHARGEBACK_BAL	WERTV8	CURR	15	2	Chargeback Balance
63	ACCRUAL_BALANCE	☐	CRM_FM_FPO_AGR_ACCRUAL_BALANCE	WERTV8	CURR	15	2	Accrual Balance
64	PREPAID_BALANCE	☐	CRM_FM_FPO_AGR_PREPAID_BALANCE	WERTV8	CURR	15	2	Prepaid Balance
65	COMMITMENT	☐	CRM_FM_FPO_AGR_COMMITTED	WERTV8	CURR	15	2	Committed
66	EXPIRED	☐	CRM_FM_FPO_AGR_EXPIRED	WERTV8	CURR	15	2	Expired
67	PEND_BUDG_REDUCT	☐	CRM_FM_FPO_AGR_PEND_BUDG_REDUC	WERTV8	CURR	15	2	Pending Budget Reduction
68	PEND_PREPAYMENT	☐	CRM_FM_FPO_AGR_PEND_PREPAYMENT	WERTV8	CURR	15	2	Pending Prepayment
69	PREPAID	☐	CRM_FM_FPO_AGR_PREPAID	WERTV8	CURR	15	2	Prepaid
70	PEND_CHARGEBACK	☐	CRM_FM_FPO_AGR_PEND_CHARGEBACK	WERTV8	CURR	15	2	Pending Chargeback
71	PEND_WRITEOFF	☐	CRM_FM_FPO_AGR_PEND_WRITEOFF	WERTV8	CURR	15	2	Pending Write-Off
72	PEND_PPAY_REDUCT	☐	CRM_FM_FPO_AGR_PEND_PPAY_REDUC	WERTV8	CURR	15	2	Pending Prepayment Reduction
73	TO_BE_DISTRIB	☐	CRM_FM_FPO_AGR_TOBEDISTRIBUTED	WERTV8	CURR	15	2	To be Distributed
74	BUDGET_PERF	☐	CRM_FM_FPO_AGR_BUDGET_PERF	WERTV8	CURR	15	2	Performance Budget Key figure
75	BUDGET_PERF_MAN	☐	CRM_FM_FPO_AGR_BUDGET_PERF_MAN	WERTV8	CURR	15	2	Performance Budget Manual Update Key figure
76	.INCLUDE	☐				0	0	Aggregated KF for Variances
77	VAR_REQUESTED	☐	CRM_FM_FPO_AGR_VAR_REQUESTED	WERTV8	CURR	15	2	Requested Overconsumption
78	VAR_APPROVED	☐	CRM_FM_FPO_AGR_VAR_APPROVED	WERTV8	CURR	15	2	Approved Overconsumption
79	VAR_NEGATIVE	☐	CRM_FM_FPO_AGR_VAR_NEGATIVE	WERTV8	CURR	15	2	Unconsumed Budget
80	AVAILABLE_TO_PLAN	☐	CRM_FM_FPO_AGR_AVAILABLE_PLAN	WERTV8	CURR	15	2	Available-to-Reserve
81	AVAILABLE_TO_SPEND	☐	CRM_FM_FPO_AGR_AVAILABLE_SPEND	WERTV8	CURR	15	2	Available-to-Spend
82	REMAINING_CASH	☐	CRM_FM_FPO_AGR_REMAIN_CASH	WERTV8	CURR	15	2	Remaining Cash
83	REMAINING_RESERVED	☐	CRM_FM_FPO_AGR_REMAIN_RESERVED	WERTV8	CURR	15	2	Remaining Reserved
84	AVAILABLE_TO_DISTR	☐	CRM_FM_FPO_AGR_AVAILABLE_DISTR	WERTV8	CURR	15	2	Available-to-Distribute
85	BUDGET_PERF_TOTAL	☐	CRM_FM_FPO_AGR_BUDGET_PERF_TOT	WERTV8	CURR	15	2	Total Performance Budget
86	BUDGET_FIXED	☐	CRM_FM_FPO_AGR_BUDGET_FIXED	WERTV8	CURR	15	2	Fixed Budget
87	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
88	PROD_CAT_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
89	BPH_NODE	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID

Foreign Keys

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

History

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