SAP ABAP Table CRMD_FS_PFS_EXP (Personal Financial Statement Relevant Expense Details)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IFS-FST (Application Component) Financial Statement
     ⤷ CRM_FS_PFS_IMPLEMENTATION (Package) FS : Personal Financial Statement Implementation

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMD_FS_PFS_EXP	Table Relationship Diagram
Short Description	Personal Financial Statement Relevant Expense Details

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	Object Key for Personal Financial Statement
2	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☑	CRM_FS_PFS_OBJECT_GUID	CRM_FS_PFS_OBJECT_GUID	RAW	16	0	Personal Financial Statement Object GUID
4	.INCLUDE	☐				0	0	PFS:Expense Fields
5	PFS_GUID	☐	CRM_FS_PFS_OBJECT_GUID	CRM_FS_PFS_OBJECT_GUID	RAW	16	0	Personal Financial Statement Object GUID	CRMD_FS_PFS_HEAD
6	EXPENSE_ID	☐	CRM_FS_PFS_EXP_ID	CRM_FS_PFS_ITEM_NO	NUMC	10	0	PFS: Expense ID
7	TYPE_CODE	☐	CRM_FS_PFS_EXP_TYPE_CODE	CRM_FS_PFS_EXP_TYPE_CODE	CHAR	3	0	Code of the Expense Type
8	DESCRIPTION	☐	CRM_FS_PFS_DESC	CRM_FS_PFS_DESC	CHAR	80	0	PFS Description
9	AMOUNT	☐	CRM_FS_AMOUNT	TFM_WRTV12	CURR	23	2	Amount
10	CURR	☐	CRM_FS_AMOUNT_C	WAERS	CUKY	5	0	Currency	TCURC
11	FREQUENCY	☐	CRM_FS_FREQUENCY	CRM_FS_FREQUENCY	CHAR	3	0	Frequency	*
12	ASST_GUID	☐	CRM_FS_PFS_OBJECT_GUID	CRM_FS_PFS_OBJECT_GUID	RAW	16	0	Personal Financial Statement Object GUID	CRMD_FS_PFS_ASST
13	LBTY_GUID	☐	CRM_FS_PFS_OBJECT_GUID	CRM_FS_PFS_OBJECT_GUID	RAW	16	0	Personal Financial Statement Object GUID	CRMD_FS_PFS_LBTY
14	ASSET_ID	☐	CRM_FS_PFS_ASST_ID	CRM_FS_PFS_ITEM_NO	NUMC	10	0	PFS: Asset ID
15	LIABILITY_ID	☐	CRM_FS_PFS_LBTY_ID	CRM_FS_PFS_ITEM_NO	NUMC	10	0	PFS: Liability ID
16	.INCLUDE	☐				0	0	PFS: Expense extensibility include
17	CRM_FS_PFS_EXP_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMD_FS_PFS_EXP	ASST_GUID	CRMD_FS_PFS_ASST	CLIENT	REF	1	CN
2	CRMD_FS_PFS_EXP	CURR	TCURC	WAERS	REF	1	CN
3	CRMD_FS_PFS_EXP	LBTY_GUID	CRMD_FS_PFS_LBTY	CLIENT	REF	1	CN
4	CRMD_FS_PFS_EXP	PFS_GUID	CRMD_FS_PFS_HEAD	CLIENT	REF	1	CN

History

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