SAP ABAP Table FMED_S_DRILLDOWN (Structure to search entry documents based on line data)

Hierarchy

☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FM-BCS-BU (Application Component) Budgeting
     ⤷ FMBPA_E (Package) New budgeting: FM application part

Basic Data

Table Category	INTTAB	Structure
Structure	FMED_S_DRILLDOWN	Table Relationship Diagram
Short Description	Structure to search entry documents based on line data

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	.INCLUDE	☐				0	0	Funds management budget header (entry documents)
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	FM_AREA	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
4	DOCYEAR	☐	BUKU_DOCYEAR	GJAHR	NUMC	4	0	Document Year
5	DOCNR	☐	BUED_DOCNR	BELNR	CHAR	10	0	Budget entry document number
6	DOCFAM	☐	BUED_DOCFAM	BELNR	CHAR	10	0	Document Family Number
7	TECHORG	☐	BUKU_TECHORG	BUKU_TECHORG	CHAR	10	0	Original Application	BUTECHORG
8	PROCESS_UI	☐	BUKU_PROCESS_UI	BUKU_PROCESS_UI	CHAR	4	0	Budgeting Process	BUPROCESS_UI
9	VERSION	☐	BUKU_VERSION	COVERSI	CHAR	3	0	Budget version	*
10	CRTUSER	☐	BUKU_CRTUSER	USERNAME	CHAR	12	0	User who created the object
11	CRTDATE	☐	BUKU_CRTDATE	DATE	DATS	8	0	Date on which the object was created
12	CRTTIME	☐	BUKU_CRTTIME	TIME	TIMS	6	0	Time at which the object was created
13	DOCDATE	☐	BP_BLDAT	DATUM	DATS	8	0	Document Date
14	POSTDATE	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
15	RESPPERS	☐	BP_VERANT	VERAB	CHAR	20	0	Person Responsible for Planning/Budgeting
16	TEXT50	☐	BUED_HDTEXT	TEXT50	CHAR	50	0	Header Text for Budget Entry Document
17	TEXTNAME	☐	BP_TDNAM	CHAR32	CHAR	32	0	Text Name
18	LTXT_IND	☐	BP_LTEXT	XFELD	CHAR	1	0	Long Text Exists
19	DOCSTATE	☐	BUED_DOCSTATE	BUED_DOCSTATE	CHAR	1	0	Status of a budget entry document
20	REVSTATE	☐	BP_RSTAT	BP_RSTAT	CHAR	1	0	Reversal status
21	REV_REFNR	☐	BUED_REV_REFNR	BELNR	CHAR	10	0	Reversal Reference Document Number
22	DOCTYPE	☐	BUED_DOCTYPE	BUED_DOCTYPE	CHAR	4	0	Budget entry document type	FMEDDOCTYPE
23	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
24	COHORT	☐	FM_COHORT	FM_COHORT	CHAR	4	0	Reporting Year for Cohort
25	PUBLAW	☐	FM_PUBLAW	FM_PUBLAW	CHAR	20	0	Public Law Cited
26	LEGIS	☐	FM_LEGIS	FM_LEGIS	CHAR	1	0	Type of Legislation
27	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
28	AWREF	☐	AWREF	AWREF	CHAR	10	0	Reference document number
29	AWSYS	☐	AWSYS	LOGSYS	CHAR	10	0	Logical system of source document	*
30	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
31	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
32	LAYOUTVAR	☐	FMLA_LAYOUTVAR	FMLA_LAYOUTVAR	CHAR	6	0	Layout variant - Layout management in budgeting	FMLA
33	.INCLUDE	☐				0	0
34	.INCLU--AP	☐				0	0	F15 Append FMBH
35	/SAPF15/STATUS	☐	/SAPF15/STATUS	/SAPF15/STATUS	CHAR	1	0	Document Status
36	DOCLN	☐	BUED_DOCLN	DOCLN6	CHAR	6	0	Budget entry document line
37	CTEM_CATEGORY	☐	FM_POTYP	FM_POTYP	NUMC	1	0	Commitment Item Category
38	FISCYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
39	CEFFYEAR	☐	GNJHR	GJAHR	NUMC	4	0	Year of Cash Effectivity
40	FUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
41	FUNDSCTR	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
42	CMMTITEM	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
43	FUNCAREA	☐	FM_FAREA	FKBER	CHAR	16	0	Functional Area	*
44	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
45	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
46	USERDIM	☐	FM_USERDIM	CHAR10	CHAR	10	0	Customer Field for FM Actual and Commitment Data
47	BUDCAT	☐	BUKU_BUDCAT	RLDNR	CHAR	2	0	Budget Category	*
48	VALTYPE	☐	BUKU_VALTYPE	BUKU_VALTYPE	CHAR	2	0	BCS Value Type	*
49	PROCESS	☐	BUKU_PROCESS	BUKU_PROCESS	CHAR	4	0	Internal Budgeting Process	*
50	BUDTYPE	☐	BUKU_BUDTYPE	CHAR4	CHAR	4	0	Budget Type
51	TCURR	☐	TWAER	WAERS	CUKY	5	0	Transaction Currency	*
52	DISTKEY	☐	SPRED	SPRED	CHAR	4	0	Distribution Key	*
53	LINE_TEXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
54	LVALUE	☐	LVALXX9	WERTV9	CURR	17	2	Budget amount in local currency
55	BUDCATT	☐	TEXT15	TEXT15	CHAR	15	0	Text (15 characters)
56	DOCSTATE_TXT	☐	TEXT17	TEXT17	CHAR	17	0	Text (length 17)
57	REVSTATE_TXT	☐	TEXT15	TEXT15	CHAR	15	0	Text (15 characters)
58	PROCESS_TXT	☐	TEXT15	TEXT15	CHAR	15	0	Text (15 characters)
59	BUDTYPE_TXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FMED_S_DRILLDOWN	DOCTYPE	FMEDDOCTYPE	DOCTYPE
2	FMED_S_DRILLDOWN	LAYOUTVAR	FMLA	LAYOUTVAR
3	FMED_S_DRILLDOWN	PROCESS_UI	BUPROCESS_UI	PROCESS_UI
4	FMED_S_DRILLDOWN	TECHORG	BUTECHORG	TECHORG

History

Last changed by/on	SAP	20130529
SAP Release Created in	200