SAP ABAP View CRM_FM_FPO_XTR_V (CRM Funds Management Funds Posting - BI Extraction View)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-FM-FPO (Application Component) Fund Posting
     ⤷ CRM_FM_FPO_BI (Package) CRM Funds Management: Funds Posting BI integration

Basic Data

View Type	D	Database View
Database View	CRM_FM_FPO_XTR_V
Short Description	CRM Funds Management Funds Posting - BI Extraction View
Root table	CRMD_FM_FPO_HEAD	Fund documents posting # Header Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMD_FM_FPO_HEAD	CRMD_FM_FPO_HEAD
2	CRMD_FM_FPO_ITEM

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CRMD_FM_FPO_ITEM	CLIENT	JL	EQ				0	0
2	CRMD_FM_FPO_HEAD	CLIENT	JR	EQ			AND	0	0
3	CRMD_FM_FPO_HEAD	GUID	JL	EQ				0	0
4	CRMD_FM_FPO_ITEM	HEADER_GUID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CRMD_FM_FPO_ITEM	CLIENT		☐	MANDT	☐	Client
2	GUID	CRMD_FM_FPO_HEAD	GUID		☐	CRM_FM_FPO_GUID	☐	Fund Posting Key
3	HEADER_GUID	CRMD_FM_FPO_ITEM	HEADER_GUID		☐	CRM_FM_FPO_GUID	☐	Fund Posting Key
4	DOCUMENT_NUMBER	CRMD_FM_FPO_HEAD	DOCUMENT_NUMBER		☐	CRM_FM_FPO_ID	☐	Fund Posting Identifier
5	POSTING_TRANS	CRMD_FM_FPO_HEAD	POSTING_TRANS		☐	CRM_FM_FPO_POSTING_TYPE	☐	Fund Posting - Posting Type
6	POSTING_DATE	CRMD_FM_FPO_HEAD	POSTING_DATE		☐	CRM_FM_FPO_POSTING_DATE	☐	Fund Posting - Posting Date
7	LOCAL_TIMEZONE	CRMD_FM_FPO_HEAD	LOCAL_TIMEZONE		☐	CRM_FM_FPO_TIMEZONE	☐	Fund Posting - Time Zone
8	CREATED_ON	CRMD_FM_FPO_HEAD	CREATED_ON		☐	CRM_FM_FPO_CREATED_ON	☐	Fund Posting - Created On Date
9	CREATED_BY	CRMD_FM_FPO_HEAD	CREATED_BY		☐	CRM_FM_FPO_CREATED_BY	☐	Fund Posting - User Creator
10	REF_OBJKEY	CRMD_FM_FPO_HEAD	REF_OBJKEY		☐	SWO_TYPEID	☐	Object key
11	REF_OBJTYPE	CRMD_FM_FPO_HEAD	REF_OBJTYPE		☐	SWO_OBJTYP	☐	Object Type
12	REF_LOGSYS	CRMD_FM_FPO_HEAD	REF_LOGSYS		☐	LOGSYS	☐	Logical system
13	FISCAL_YEAR	CRMD_FM_FPO_HEAD	FISCAL_YEAR		☐	GJAHR	☐	Fiscal Year
14	ITEM_GUID	CRMD_FM_FPO_ITEM	ITEM_GUID		☐	CRM_FM_FPO_ITEM_GUID	☐	Fund Posting Item Key
15	ITEM_NUMBER	CRMD_FM_FPO_ITEM	ITEM_NUMBER		☐	CRM_FM_FPO_ITEM_ID	☐	Fund Posting Item Identifier
16	POSTING_PERIOD	CRMD_FM_FPO_HEAD	POSTING_PERIOD		☐	POPER	☐	Posting period
17	FUND_PLAN_ID	CRMD_FM_FPO_HEAD	FUND_PLAN_ID		☐	CRM_FM_FND_FUNDPLAN_ID	☐	Funds Plan ID
18	FUND_PLAN_GUID	CRMD_FM_FPO_HEAD	FUND_PLAN_GUID		☐	CRM_FM_FND_FUNDPLAN_GUID	☐	Funds Plan GUID
19	FUND_ID	CRMD_FM_FPO_ITEM	FUND_ID		☐	CRM_FM_FND_FUND_ID	☐	Fund ID
20	FUND_GUID	CRMD_FM_FPO_ITEM	FUND_GUID		☐	CRM_FM_FND_FUND_GUID	☐	GUID of Fund Business Object
21	FU_ID	CRMD_FM_FPO_ITEM	FU_ID		☐	CRM_FM_FU_HEADER_ID	☐	Trade Promotion: Fund Usage ID
22	FU_GUID	CRMD_FM_FPO_ITEM	FU_GUID		☐	CRM_FM_FU_HEADER_GUID	☐	Trade Promotion: Fund Usage Header GUID
23	FU_ITEM_ID	CRMD_FM_FPO_ITEM	FU_ITEM_ID		☐	CRM_FM_FU_ITEM_ID	☐	TFM Fund Usage: ITEM External ID
24	FU_ITEM_GUID	CRMD_FM_FPO_ITEM	FU_ITEM_GUID		☐	CRM_FM_FU_ITEM_GUID	☐	TFM Fund Usage: Fund Usage Item Guid
25	VALUE_CATEGORY	CRMD_FM_FPO_ITEM	VALUE_CATEGORY		☐	CRM_FM_FPO_VALUE_CAT	☐	Value Category
26	TRANS_AMOUNT	CRMD_FM_FPO_ITEM	TRANS_AMOUNT		☐	CRM_FM_FPO_VALUE	☐	Fund Posting Amount
27	TRANS_CURRENCY	CRMD_FM_FPO_ITEM	TRANS_CURRENCY		☐	CRM_FM_FPO_CURRENCY	☐	Currency Key
28	FM_AMOUNT	CRMD_FM_FPO_ITEM	FM_AMOUNT		☐	CRM_FM_FPO_VALUE	☐	Fund Posting Amount
29	FM_CURRENCY	CRMD_FM_FPO_HEAD	FM_CURRENCY		☐	CRM_FM_FPO_CURRENCY	☐	Currency Key
30	PROD_CATEG_GUID	CRMD_FM_FPO_ITEM	PROD_CATEG_GUID		☐	COMT_CATEGORY_GUID	☐	Category GUID
31	PROD_GROUP_ID	CRMD_FM_FPO_ITEM	PROD_GROUP_ID		☐	CRMT_PRC_GROUP1	☐	Product Group 1
32	PRODUCT_GUID	CRMD_FM_FPO_ITEM	PRODUCT_GUID		☐	COMT_PRODUCT_GUID	☐	Internal Unique ID of Product
33	BP_GUID	CRMD_FM_FPO_ITEM	BP_GUID		☐	BU_PARTNER_GUID	☐	Business Partner GUID
34	BPH_GUID	CRMD_FM_FPO_ITEM	BPH_GUID		☐	BU_NODE_GUID	☐	GUID of Hierarchy Node
35	TERRITORY_GUID	CRMD_FM_FPO_ITEM	TERRITORY_GUID		☐	CRMT_TERRITORY_GUID	☐	Territory GUID
36	FUND_EXP_DATE	CRMD_FM_FPO_ITEM	FUND_EXP_DATE		☐	CRM_FM_FPO_EXPIRATION_DATE	☐	Fund Expiration Date
37	SALES_ORG	CRMD_FM_FPO_ITEM	SALES_ORG		☐	CRMT_SALES_ORG	☐	Sales Organization ID
38	DIS_CHANNEL	CRMD_FM_FPO_ITEM	DIS_CHANNEL		☐	CRMT_DISTRIBUTION_CHANNEL	☐	Distribution Channel
39	DIVISION	CRMD_FM_FPO_ITEM	DIVISION		☐	CRMT_DIVISION	☐	Division
40	SERVICES_ORG	CRMD_FM_FPO_ITEM	SERVICES_ORG		☐	CRMT_SERVICE_ORG	☐	Service Organization
41	PROJECT_KEY	CRMD_FM_FPO_ITEM	PROJECT_KEY		☐	SWO_TYPEID	☐	Object key
42	PROJECT_TYPE	CRMD_FM_FPO_ITEM	PROJECT_TYPE		☐	SWO_OBJTYP	☐	Object Type
43	MKT_ORG	CRMD_FM_FPO_ITEM	MKT_ORG		☐	CRM_MKTPL_MORG	☐	Marketing Organization

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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