SAP ABAP View VDB_FPM_DOC (Join Using HRFPM_FPM_DOC/HRFPM_FPM_POS)

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ PA-PM-PB (Application Component) Position Budgeting and Control
     ⤷ PAOC_FPM_COM_ENGINE (Package) Position Management: Commitment Creation

Basic Data

View Type	D	Database View
Database View	VDB_FPM_DOC
Short Description	Join Using HRFPM_FPM_DOC/HRFPM_FPM_POS
Root table	HRFPM_FPM_DOC	HRFPM: FPM Document Headers for Commitment

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	HRFPM_FPM_DOC	HRFPM_FPM_DOC
2	HRFPM_FPM_POS

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	HRFPM_FPM_DOC	MANDT	JL	EQ				0	0
2	HRFPM_FPM_POS	MANDT	JR	EQ			AND	0	0
3	HRFPM_FPM_DOC	ENC_TYPE	JL	EQ				0	0
4	HRFPM_FPM_POS	ENC_TYPE	JR	EQ			AND	0	0
5	HRFPM_FPM_DOC	PLVAR	JL	EQ				0	0
6	HRFPM_FPM_POS	PLVAR	JR	EQ			AND	0	0
7	HRFPM_FPM_DOC	OTYPE	JL	EQ				0	0
8	HRFPM_FPM_POS	OTYPE	JR	EQ			AND	0	0
9	HRFPM_FPM_DOC	OBJID	JL	EQ				0	0
10	HRFPM_FPM_POS	OBJID	JR	EQ			AND	0	0
11	HRFPM_FPM_DOC	ENDDA_KEY	JL	EQ				0	0
12	HRFPM_FPM_POS	ENDDA_KEY	JR	EQ			AND	0	0
13	HRFPM_FPM_DOC	DATBI	JL	EQ				0	0
14	HRFPM_FPM_POS	DATBI	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	HRFPM_FPM_DOC	MANDT		☐	MANDT	☐	Client
2	PLVAR	HRFPM_FPM_DOC	PLVAR		☐	PLVAR	☐	Plan Version
3	OTYPE	HRFPM_FPM_DOC	OTYPE		☐	OTYPE	☐	Object Type
4	OBJID	HRFPM_FPM_DOC	OBJID		☐	OBJEKTID	☐	Object ID
5	ENC_TYPE	HRFPM_FPM_DOC	ENC_TYPE		☐	HRFPM_ENC_TYPE	☐	Earmarked Funds Category
6	DATBI	HRFPM_FPM_DOC	DATBI		☐	ENDDA	☐	End Date
7	ENDDA_KEY	HRFPM_FPM_DOC	ENDDA_KEY		☐	ENDDA	☐	End Date
8	AEDTM	HRFPM_FPM_DOC	AEDTM		☐	AEDTM	☐	Changed on
9	ERLKZ_DOC	HRFPM_FPM_DOC	ERLKZ		☐	KBLERLKZ	☐	Completion indicator for line item
10	FPM_POSNR	HRFPM_FPM_POS	FPM_POSNR		☐	HRFPM_FPM_POSNR	☐	Item Number in PBC Document
11	PLVAR_DP	HRFPM_FPM_POS	PLVAR_DP		☐	PLVAR	☐	Plan Version
12	OTYPE_DP	HRFPM_FPM_POS	OTYPE_DP		☐	OTYPE	☐	Object Type
13	OBJID_DP	HRFPM_FPM_POS	OBJID_DP		☐	OBJEKTID	☐	Object ID
14	ENC_TYPE_DP	HRFPM_FPM_POS	ENC_TYPE_DP		☐	HRFPM_ENC_TYPE	☐	Earmarked Funds Category
15	DATBI_DP	HRFPM_FPM_POS	DATBI_DP		☐	ENDDA	☐	End Date
16	ENDDA_KEY_DP	HRFPM_FPM_POS	ENDDA_KEY_DP		☐	ENDDA	☐	End Date
17	FPM_POSNR_DP	HRFPM_FPM_POS	FPM_POSNR_DP		☐	HRFPM_FPM_POSNR	☐	Item Number in PBC Document
18	ENC_TYPE_MP	HRFPM_FPM_POS	ENC_TYPE_MP		☐	HRFPM_ENC_TYPE	☐	Earmarked Funds Category
19	BELNR_MP	HRFPM_FPM_POS	BELNR_MP		☐	HRFPM_FPM_DOCNR	☐	Document Number of PBC Document
20	FPM_POSNR_MP	HRFPM_FPM_POS	FPM_POSNR_MP		☐	HRFPM_FPM_POSNR	☐	Item Number in PBC Document
21	BEGDA	HRFPM_FPM_POS	BEGDA		☐	BEGDA	☐	Start Date
22	ENDDA	HRFPM_FPM_POS	ENDDA		☐	ENDDA	☐	End Date
23	BETRG	HRFPM_FPM_POS	BETRG		☐	BPREP_REQ_AMOUNT	☐	Requirements
24	WAERS	HRFPM_FPM_POS	WAERS		☐	WAERS	☐	Currency Key
25	DUE_DATE	HRFPM_FPM_POS	DUE_DATE		☐	HRFPM_DUE_DATE	☐	Due Date
26	PERIO	HRFPM_FPM_POS	PERIO		☐	PFREQ	☐	Payroll time units
27	SAKNR	HRFPM_FPM_POS	SAKNR		☐	SAKNR	☐	G/L Account Number
28	BUKRS	HRFPM_FPM_POS	BUKRS		☐	BUKRS	☐	Company Code
29	KOKRS	HRFPM_FPM_POS	KOKRS		☐	KOKRS	☐	Controlling Area
30	KOSTL	HRFPM_FPM_POS	KOSTL		☐	KOSTL	☐	Cost Center
31	AUFNR	HRFPM_FPM_POS	AUFNR		☐	AUFNR	☐	Order Number
32	POSNR	HRFPM_FPM_POS	POSNR		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
33	NPLNR	HRFPM_FPM_POS	NPLNR		☐	NPLNR	☐	Network Number for Account Assignment
34	VORNR	HRFPM_FPM_POS	VORNR		☐	VORNR	☐	Operation/Activity Number
35	GRANT_NBR	HRFPM_FPM_POS	GRANT_NBR		☐	GM_GRANT_NBR	☐	Grant
36	GEBER	HRFPM_FPM_POS	GEBER		☐	BP_GEBER	☐	Fund
37	FKBER	HRFPM_FPM_POS	FKBER		☐	FKBER	☐	Functional Area
38	FISTL	HRFPM_FPM_POS	FISTL		☐	FISTL	☐	Funds Center
39	FIPEX	HRFPM_FPM_POS	FIPEX		☐	FM_FIPEX	☐	Commitment item
40	STATUS	HRFPM_FPM_POS	STATUS		☐	HRFPM_FPM_STATUS	☐	Posting Status
41	ERLKZ_POS	HRFPM_FPM_POS	ERLKZ		☐	KBLERLKZ	☐	Completion indicator for line item
42	DELTA_AMOUNT	HRFPM_FPM_POS	DELTA_AMOUNT		☐	BPREP_REQUIRED_AMOUNT	☐	Currently Parked Requirement Change for Financing
43	CURRENCY	HRFPM_FPM_POS	CURRENCY		☐	WAERS	☐	Currency Key
44	DB_ACTION	HRFPM_FPM_POS	DB_ACTION		☐	HRFPM_FPM_POS_DB_ACTION	☐	Action to Be Performed with Cmmt
45	NEGATIVE_CMMTNT	HRFPM_FPM_POS	NEGATIVE_CMMTNT		☐	HRFPM_FM_POS_NEGATIVE	☐	Indicator: Negative Commitment
46	REQUEST_ID	HRFPM_FPM_POS	REQUEST_ID		☐	HRFPM_CHANGE_REQUEST_ID	☐	Identification of Change
47	CLOSED	HRFPM_FPM_POS	CLOSED		☐	HRFPM_CLOSED_INDICATOR	☐	HRFPM: Doc. (Item) is Closed

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	20110901
SAP Release Created in	700