V_FMED SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




ABAP Code to SELECT data from V_FMED
Related tables to V_FMED
Access table V_FMED




Table View field list including key, data, relationships and ABAP select examples

V_FMED is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The V_FMED table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include FM_AREA (Financial Management Area), DOCYEAR (Document Year), DOCNR (Budget entry document number), DOCFAM (Document Family Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP V_FMED table view fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3MANDT
FM_AREAFinancial Management Area FIKRSCHAR4FIKRSFIK
DOCYEARDocument Year BUKU_DOCYEARNUMC4GJAHRGJAHRBUKU_DOCYEAR
DOCNRBudget entry document number BUED_DOCNRCHAR10ALPHABELNRBUED_DOCNR
DOCFAMDocument Family Number BUED_DOCFAMCHAR10ALPHABELNR
TECHORGOriginal Application BUKU_TECHORGCHAR10BUTECHORGBUKU_TECHORG
PROCESS_UIBudgeting Process BUKU_PROCESS_UICHAR4BUPROCESS_UIBUKU_PROCESS_UI
VERSIONBudget version BUKU_VERSIONCHAR3ALPHACOVERSIBP2
CRTUSERUser Who Created or Updated the Object BUKU_CRTUSERCHAR12USERNAME
CRTDATEDate on which the object was created or updated BUKU_CRTDATEDATS8DATE
CRTTIMETime at which the object was created or updated BUKU_CRTTIMETIMS6TIME
DOCDATEDocument Date BP_BLDATDATS8DATUM
POSTDATEPosting Date in the Document BUDATDATS8DATUM
RESPPERSPerson Responsible for Planning/Budgeting BP_VERANTCHAR20VERABBPV
TEXT50Header Text for Budget Entry Document BUED_HDTEXTCHAR50TEXT50
TEXTNAMEText Name BP_TDNAMCHAR32CHAR32
LTXT_INDLong Text Exists BP_LTEXTCHAR1XFELD
DOCSTATEStatus of a budget entry document BUED_DOCSTATECHAR1BUED_DOCSTATE
REVSTATEReversal status BP_RSTATCHAR1BP_RSTAT
REV_REFNRReversal Reference Document Number BUED_REV_REFNRCHAR10ALPHABELNR
DOCTYPEBudget entry document type BUED_DOCTYPECHAR4FMEDDOCTYPEBUED_DOCTYPEDOTY
LOGSYSLogical system LOGSYSCHAR10ALPHALOGSYS
COHORTReporting Year for Cohort FM_COHORTCHAR4FM_COHORT
PUBLAWPublic Law Cited FM_PUBLAWCHAR20FM_PUBLAW
LEGISType of Legislation FM_LEGISCHAR1FM_LEGIS
AWORGReference Organizational Units AWORGCHAR10AWORG
AWREFReference Document Number AWREFCHAR10ALPHAAWREF
AWSYSLogical system of source document AWSYSCHAR10ALPHALOGSYS
AWTYPReference Transaction AWTYPCHAR5AWTYP
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
LAYOUTVARLayout variant - Layout management in budgeting FMLA_LAYOUTVARCHAR6FMLAFMLA_LAYOUTVARLAY
TRANSFER_AGENCYTransfer Agency FMFG_TRANSFER_AGCYCHAR2FMFG_TRANSFER
TRANSFER_ACCOUNTTransfer Account FMFG_TRANSFER_ACCTCHAR4FMFG_TRAN_ACCT
RCOMPCompany ID of trading partner RASSCCHAR6ALPHARCOMPPGS
CHGUSERLast user to change object BUKU_CHGUSERCHAR12USERNAME
CHGDATEDate on which the object was changed BUKU_CHGDATEDATS8DATE
CHGTIMETime at which the object was changed BUKU_CHGTIMETIMS6TIME
/SAPF15/STATUS /SAPF15/STATUSCHAR1/SAPF15/STATUS
DOCLNBudget entry document line BUED_DOCLNCHAR6DOCLN6
RPMAXPeriod RPMAXNUMC3RPMAX
FLG_ADDEDIndicator for Additional Line BUED_FLG_ADDEDCHAR1BUED_FLG_ADDED
CTEM_CATEGORYCommitment Item Category FM_POTYPNUMC1FM_POTYP
FISCYEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
CEFFYEARYear of Cash Effectivity GNJHRNUMC4GJAHRGJAHRGNJHR
FUNDFund BP_GEBERCHAR10BP_GEBERFIC
FUNDSCTRFunds Center FISTLCHAR16FISTLFIS
CMMTITEMCommitment Item FM_FIPEXCHAR24FM_FIPEXFPS
FUNCAREAFunctional Area FM_FAREACHAR16FKBERFBE
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
MEASUREFunded Program FM_MEASURECHAR24FM_MEASUREFM_MEASURE
USERDIMCustomer Field for FM Actual and Commitment Data FM_USERDIMCHAR10CHAR10
BUDCATBudget Category BUKU_BUDCATCHAR2ALPHARLDNRBUDCAT
VALTYPEBCS Value Type BUKU_VALTYPECHAR2BUVALTYPEBUKU_VALTYPE
PROCESSInternal Budgeting Process BUKU_PROCESSCHAR4BUKU_PROCESS
BUDTYPEBudget Type BUKU_BUDTYPECHAR4CHAR4BUTY
TCURRTransaction Currency TWAERCUKY5WAERSFWS
TVAL01Budget amount in transaction currency TVALXX9CURR17(2) WERTV9
TVAL02Budget amount in transaction currency TVALXX9CURR17(2) WERTV9
TVAL03Budget amount in transaction currency TVALXX9CURR17(2) WERTV9
TVAL04Budget amount in transaction currency TVALXX9CURR17(2) WERTV9
TVAL05Budget amount in transaction currency TVALXX9CURR17(2) WERTV9
TVAL06Budget amount in transaction currency TVALXX9CURR17(2) WERTV9
TVAL07Budget amount in transaction currency TVALXX9CURR17(2) WERTV9
TVAL08Budget amount in transaction currency TVALXX9CURR17(2) WERTV9
TVAL09Budget amount in transaction currency TVALXX9CURR17(2) WERTV9
TVAL10Budget amount in transaction currency TVALXX9CURR17(2) WERTV9
TVAL11Budget amount in transaction currency TVALXX9CURR17(2) WERTV9
TVAL12Budget amount in transaction currency TVALXX9CURR17(2) WERTV9
TVAL13Budget amount in transaction currency TVALXX9CURR17(2) WERTV9
TVAL14Budget amount in transaction currency TVALXX9CURR17(2) WERTV9
TVAL15Budget amount in transaction currency TVALXX9CURR17(2) WERTV9
TVAL16Budget amount in transaction currency TVALXX9CURR17(2) WERTV9
LVAL01Budget amount in local currency LVALXX9CURR17(2) WERTV9
LVAL02Budget amount in local currency LVALXX9CURR17(2) WERTV9
LVAL03Budget amount in local currency LVALXX9CURR17(2) WERTV9
LVAL04Budget amount in local currency LVALXX9CURR17(2) WERTV9
LVAL05Budget amount in local currency LVALXX9CURR17(2) WERTV9
LVAL06Budget amount in local currency LVALXX9CURR17(2) WERTV9
LVAL07Budget amount in local currency LVALXX9CURR17(2) WERTV9
LVAL08Budget amount in local currency LVALXX9CURR17(2) WERTV9
LVAL09Budget amount in local currency LVALXX9CURR17(2) WERTV9
LVAL10Budget amount in local currency LVALXX9CURR17(2) WERTV9
LVAL11Budget amount in local currency LVALXX9CURR17(2) WERTV9
LVAL12Budget amount in local currency LVALXX9CURR17(2) WERTV9
LVAL13Budget amount in local currency LVALXX9CURR17(2) WERTV9
LVAL14Budget amount in local currency LVALXX9CURR17(2) WERTV9
LVAL15Budget amount in local currency LVALXX9CURR17(2) WERTV9
LVAL16Budget amount in local currency LVALXX9CURR17(2) WERTV9
DISTKEYDistribution Key SPREDCHAR4SPREDGSP
LINE_TEXTItem Text SGTXTCHAR50TEXT50
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10FM_BUDGET_PERIODBUDPER
REASON_REVReason for Reversal of Budget Document FMREV_STGRDCHAR2STGRDFSG

Key field Non-key field



How do I retrieve data from SAP table V_FMED using ABAP code

The following ABAP code Example will allow you to do a basic selection on V_FMED to SELECT all data from the table
DATA: WA_V_FMED TYPE V_FMED.

SELECT SINGLE *
FROM V_FMED
INTO CORRESPONDING FIELDS OF WA_V_FMED
WHERE...

How to access SAP table V_FMED

Within an ECC or HANA version of SAP you can also view further information about V_FMED and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!