SAP ABAP View VDB_FM_DOC (Database View for Reading FM_POS/FM_DOC)

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_FM_DOC
Short Description	Database View for Reading FM_POS/FM_DOC
Root table	HRFPM_FM_POS	HRFPM: FM Documents - Items

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	HRFPM_FM_POS	HRFPM_FM_POS
2	HRFPM_FM_DOC

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	HRFPM_FM_POS	MANDT	JL	EQ				0	0
2	HRFPM_FM_DOC	MANDT	JR	EQ			AND	0	0
3	HRFPM_FM_POS	ENC_TYPE	JL	EQ				0	0
4	HRFPM_FM_DOC	ENC_TYPE	JR	EQ			AND	0	0
5	HRFPM_FM_POS	BELNR	JL	EQ				0	0
6	HRFPM_FM_DOC	BELNR	JR	EQ			AND	0	0
7	HRFPM_FM_POS	ERLKZ	JL	EQ				0	0
8	HRFPM_FM_DOC	ERLKZ	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	HRFPM_FM_POS	MANDT		☐	MANDT	☐	Client
2	ENC_TYPE	HRFPM_FM_POS	ENC_TYPE		☐	HRFPM_ENC_TYPE	☐	Earmarked Funds Category
3	BELNR	HRFPM_FM_POS	BELNR		☐	HRFPM_FPM_DOCNR	☐	Document Number of PBC Document
4	FPM_POSNR	HRFPM_FM_POS	FPM_POSNR		☐	HRFPM_FPM_POSNR	☐	Item Number in PBC Document
5	ENC_TYPE_DP	HRFPM_FM_POS	ENC_TYPE_DP		☐	HRFPM_ENC_TYPE	☐	Earmarked Funds Category
6	BELNR_DP	HRFPM_FM_POS	BELNR_DP		☐	HRFPM_FPM_DOCNR	☐	Document Number of PBC Document
7	FPM_POSNR_DP	HRFPM_FM_POS	FPM_POSNR_DP		☐	HRFPM_FPM_POSNR	☐	Item Number in PBC Document
8	BETRG	HRFPM_FM_POS	BETRG		☐	BPREP_REQ_AMOUNT	☐	Requirements
9	WAERS	HRFPM_FM_POS	WAERS		☐	WAERS	☐	Currency Key
10	ERLKZ	HRFPM_FM_POS	ERLKZ		☐	KBLERLKZ	☐	Completion indicator for line item
11	DUE_DATE	HRFPM_FM_POS	DUE_DATE		☐	HRFPM_DUE_DATE	☐	Due Date
12	SAKNR	HRFPM_FM_POS	SAKNR		☐	SAKNR	☐	G/L Account Number
13	BUKRS	HRFPM_FM_POS	BUKRS		☐	BUKRS	☐	Company Code
14	KOKRS	HRFPM_FM_POS	KOKRS		☐	KOKRS	☐	Controlling Area
15	KOSTL	HRFPM_FM_POS	KOSTL		☐	KOSTL	☐	Cost Center
16	AUFNR	HRFPM_FM_POS	AUFNR		☐	AUFNR	☐	Order Number
17	POSNR	HRFPM_FM_POS	POSNR		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
18	NPLNR	HRFPM_FM_POS	NPLNR		☐	NPLNR	☐	Network Number for Account Assignment
19	VORNR	HRFPM_FM_POS	VORNR		☐	VORNR	☐	Operation/Activity Number
20	GRANT_NBR	HRFPM_FM_POS	GRANT_NBR		☐	GM_GRANT_NBR	☐	Grant
21	GEBER	HRFPM_FM_POS	GEBER		☐	BP_GEBER	☐	Fund
22	FKBER	HRFPM_FM_POS	FKBER		☐	FKBER	☐	Functional Area
23	FISTL	HRFPM_FM_POS	FISTL		☐	FISTL	☐	Funds Center
24	FIPEX	HRFPM_FM_POS	FIPEX		☐	FM_FIPEX	☐	Commitment item
25	STATUS	HRFPM_FM_POS	STATUS		☐	HRFPM_FPM_STATUS	☐	Posting Status
26	DATBI	HRFPM_FM_DOC	DATBI		☐	ENDDA	☐	End Date
27	AEDTM	HRFPM_FM_DOC	AEDTM		☐	AEDTM	☐	Changed on
28	COST_DUE_DATE	HRFPM_FM_DOC	COST_DUE_DATE		☐	KBLFLDAT	☐	Costs due on
29	PLVAR	HRFPM_FM_DOC	PLVAR		☐	PLVAR	☐	Plan Version
30	OTYPE	HRFPM_FM_DOC	OTYPE		☐	OTYPE	☐	Object Type
31	OBJID	HRFPM_FM_DOC	OBJID		☐	OBJEKTID	☐	Object ID
32	DELTA_AMOUNT	HRFPM_FM_POS	DELTA_AMOUNT		☐	BPREP_REQUIRED_AMOUNT	☐	Currently Parked Requirement Change for Financing
33	CURRENCY	HRFPM_FM_POS	CURRENCY		☐	WAERS	☐	Currency Key
34	NEGATIVE_CMMTNT	HRFPM_FM_POS	NEGATIVE_CMMTNT		☐	HRFPM_FM_POS_NEGATIVE	☐	Indicator: Negative Commitment
35	CLOSED	HRFPM_FM_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