SAP ABAP Table CRMS_BOL_FM_FU_QUERY_ARCH_ATTR (Dynamic Search Structure For Archived Fund Usages)

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_QUERY_ARCH_ATTR	Table Relationship Diagram
Short Description	Dynamic Search Structure For Archived Fund Usages

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	OBJTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
2	EXPENSE_TYPE	☐	CRM_FM_FU_EXPENSE_TYPE	CRM_FM_FU_EXPENSE_TYPE	CHAR	4	0	Expense Type
3	EXTERNAL_ID	☐	CRM_FM_FU_HEADER_ID	CHAR24	CHAR	24	0	Trade Promotion: Fund Usage ID
4	ACCRUAL_START_DT	☐	ACCRUAL_START_DT		DATS	8	0	Accrual Start Date (For Query)
5	ACCRUAL_END_DT	☐	ACCRUAL_END_DT		DATS	8	0	Accrual End Date (For Query )
6	ACCRUAL_METHOD	☐	CRM_FM_ACL_METHOD_ID	CRM_FM_ACL_METHOD_ID	CHAR	8	0	Accrual Calculation Method ID	*
7	DESCRIPTION	☐	CRM_FM_FU_TEXT	TEXT40	CHAR	40	0	Funds Management: Fund Usage Description
8	CREATED_ON	☐	FU_CREATED_DT		DATS	8	0	Fund Usage Created On (For Query)
9	CREATED_BY	☐	CRM_FM_FU_USER	USNAM	CHAR	12	0	FM Fund Usage: User Name
10	FUND_PLAN_DESC	☐	CRM_FM_FND_FUNDPLAN_DESC	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Description of Funds Plan Business Object
11	FUND_PLAN_ID	☐	CRM_FM_FND_FUNDPLAN_ID	CRM_OBJECT_ID	CHAR	10	0	Funds Plan ID
12	FUND_ID	☐	CRM_FM_FND_FUND_ID	CRM_OBJECT_ID	CHAR	10	0	Fund ID
13	FUND_DESC	☐	CRM_FM_FND_FUND_DESC	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Description of Funds Plan Business Object
14	TPM_ID	☐	CRM_FM_TRADEPROMOTION_ID	CGPL_EXTID	CHAR	24	0	Trade Promotion ID in Funds Management
15	TPM_DESC	☐	CRM_FM_TRADEPROMOTION_DESC	TEXT40	CHAR	40	0	Trade Promotion Description in FM
16	CAMPAIGN_ID	☐	CRM_MKTPL_EXTERNAL_ID	CGPL_EXTID	CHAR	24	0	External Identification
17	CAMPAIGN_DESC	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
18	ACC_PL_ID	☐	CRM_FM_ACCOUNTPLAN_ID	CGPL_EXTID	CHAR	24	0	Account Plan ID in Fund Management
19	ACC_PL_DESC	☐	CRM_FM_ACCOUNTPLAN_DESC	TEXT40	CHAR	40	0	Account Plan Description in FM
20	MDF_INITIATIVE_ID	☐	CRM_FM_MDFINITIATIVE_ID	CGPL_EXTID	CHAR	24	0	MDF Initiative ID in Funds Management
21	MDF_INITIATIVE_DESC	☐	CRM_FM_MDFINITIATIVE_DESC	TEXT40	CHAR	40	0	MDF Initiative Description in FM
22	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
23	ACCOUNT_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
24	ACCOUNT_HIERARCHY_NODE	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID
25	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
26	PRODUCT_GROUP_ID	☐	CRMT_PRC_GROUP1	CRM_PRC_GROUP1	CHAR	3	0	Product Group 1	*
27	PRODUCT_CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
28	.INCLUDE	☐				0	0	FM Fund Postings Aggregates Standard Key Figures
29	.INCLUDE	☐				0	0	Aggregated Key Figures generated by value flows
30	FM_CURRENCY	☐	CRM_FM_FPO_CURRENCY	WAERS	CUKY	5	0	Currency Key	*
31	BUDGET	☐	CRM_FM_FPO_AGR_BUDGET	WERTV8	CURR	15	2	Budget
32	PRERESERVED	☐	CRM_FM_FPO_AGR_PRERESERVED	WERTV8	CURR	15	2	Prereserved
33	RESERVED	☐	CRM_FM_FPO_AGR_RESERVED	WERTV8	CURR	15	2	Reserved
34	UNCONSUMEDBUDGET	☐	CRM_FM_FPO_AGR_UNCONSUMED_BDGT	WERTV8	CURR	15	2	Unconsumed Budget
35	PENDING_CLAIM	☐	CRM_FM_FPO_AGR_PENDING_CLAIM	WERTV8	CURR	15	2	Pending Claim
36	APPROVED_CLAIM	☐	CRM_FM_FPO_AGR_APPROVED_CLAIM	WERTV8	CURR	15	2	Approved Claim
37	EXP_APPROVED_CLA	☐	CRM_FM_FPO_AGR_EXP_APPRO_CLAIM	WERTV8	CURR	15	2	Expired Approved Claim
38	RELEASED_SETTLE	☐	CRM_FM_FPO_AGR_RELEASED_SETTLE	WERTV8	CURR	15	2	Released-to-Settle
39	SETTLED	☐	CRM_FM_FPO_AGR_SETTLED	WERTV8	CURR	15	2	Settled
40	EXT_SETTLED	☐	CRM_FM_FPO_AGR_EXT_SETTLED	WERTV8	CURR	15	2	Externally Settled
41	EXPENSED	☐	CRM_FM_FPO_AGR_EXPENSED	WERTV8	CURR	15	2	Expensed
42	WRITTEN_OFF	☐	CRM_FM_FPO_AGR_WRITTEN_OFF	WERTV8	CURR	15	2	Written Off
43	CHARGEBACK_BAL	☐	CRM_FM_FPO_AGR_CHARGEBACK_BAL	WERTV8	CURR	15	2	Chargeback Balance
44	ACCRUAL_BALANCE	☐	CRM_FM_FPO_AGR_ACCRUAL_BALANCE	WERTV8	CURR	15	2	Accrual Balance
45	PREPAID_BALANCE	☐	CRM_FM_FPO_AGR_PREPAID_BALANCE	WERTV8	CURR	15	2	Prepaid Balance
46	COMMITMENT	☐	CRM_FM_FPO_AGR_COMMITTED	WERTV8	CURR	15	2	Committed
47	EXPIRED	☐	CRM_FM_FPO_AGR_EXPIRED	WERTV8	CURR	15	2	Expired
48	PEND_BUDG_REDUCT	☐	CRM_FM_FPO_AGR_PEND_BUDG_REDUC	WERTV8	CURR	15	2	Pending Budget Reduction
49	PEND_PREPAYMENT	☐	CRM_FM_FPO_AGR_PEND_PREPAYMENT	WERTV8	CURR	15	2	Pending Prepayment
50	PREPAID	☐	CRM_FM_FPO_AGR_PREPAID	WERTV8	CURR	15	2	Prepaid
51	PEND_CHARGEBACK	☐	CRM_FM_FPO_AGR_PEND_CHARGEBACK	WERTV8	CURR	15	2	Pending Chargeback
52	PEND_WRITEOFF	☐	CRM_FM_FPO_AGR_PEND_WRITEOFF	WERTV8	CURR	15	2	Pending Write-Off
53	PEND_PPAY_REDUCT	☐	CRM_FM_FPO_AGR_PEND_PPAY_REDUC	WERTV8	CURR	15	2	Pending Prepayment Reduction
54	TO_BE_DISTRIB	☐	CRM_FM_FPO_AGR_TOBEDISTRIBUTED	WERTV8	CURR	15	2	To be Distributed
55	BUDGET_PERF	☐	CRM_FM_FPO_AGR_BUDGET_PERF	WERTV8	CURR	15	2	Performance Budget Key figure
56	BUDGET_PERF_MAN	☐	CRM_FM_FPO_AGR_BUDGET_PERF_MAN	WERTV8	CURR	15	2	Performance Budget Manual Update Key figure
57	.INCLUDE	☐				0	0	Aggregated KF for Variances
58	VAR_REQUESTED	☐	CRM_FM_FPO_AGR_VAR_REQUESTED	WERTV8	CURR	15	2	Requested Overconsumption
59	VAR_APPROVED	☐	CRM_FM_FPO_AGR_VAR_APPROVED	WERTV8	CURR	15	2	Approved Overconsumption
60	VAR_NEGATIVE	☐	CRM_FM_FPO_AGR_VAR_NEGATIVE	WERTV8	CURR	15	2	Unconsumed Budget

History

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