SAP Table FMDY

FIFM: Screen Fields

FMDY (FIFM: Screen Fields) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link FMDY to other SAP tables.

FMDY table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
BUTXT Name of Company Code or Company BUTXT CHAR 25 0
FIKRS Financial Management Area FIKRS FM01 CHAR 4 0
FITXT Name of FM area FITXT CHAR 25 0
FICTR Funds Center FM_FICTR CHAR 16 0
FICTR_TXT Name FM_BEZEICH CHAR 20 0
CTR_OBJNR Object number J_OBJNR ONR00 CHAR 22 0
FIPOS Commitment Item FIPOS CHAR 14 0
FICPOS Commitment Item FIPOS CHAR 14 0
POSIT Internal commitment item (8 chars) BP_POSIT CHAR 8 0
POS_BEZ Name FM_BEZEICH CHAR 20 0
FMA_OBJNR Object number J_OBJNR ONR00 CHAR 22 0
POSHIVERS FIFM: Hierarchy Version FM_HIVERS CHAR 10 0
DATBIS FM: Valid to date FM_DATBIS DATS 8 0
DATAB FM: Valid from date FM_DATAB DATS 8 0
KEYDATE Key date FM_KEYDATE DATS 8 0
ERFNAME FIFM: Created by FM_ERFNAME CHAR 12 0
ERFDAT FIFM: Entry Date FM_ERFDAT DATS 8 0
AENNAME FIFM: Name of Last Person to Make a Change FM_AENNAME CHAR 12 0
AENDAT FIFM: Changed on FM_AENDAT DATS 8 0
FIVOR Financial transaction FIVOR NUMC 2 0
05 Funds reservation
10 Purchase requisition
20 Purchase order commitment
30 Post revenue, expenditure, asset, inventory stocks...
40 Post goods receipt, goods issue
50 Company Code Clearing
60 Post rcvbls and pybls from goods + services, down payment
80 Post bank clearing, bill of exchange
90 Post cash holdings
KNZAEPO Commitment Item Category FM_KNZAEPO NUMC 1 0
1 Cash balance item
2 Revenue item
3 Expenditure item
DEAKTIV Deactivation Indicator FM_DEAKTIV CHAR 1 0
X Yes
NULL No
LOEVM Commitment item is flagged for deletion (indicator) FM_LOEVM CHAR 1 0
X Yes
NULL No
BEZEICH Name FM_BEZEICH CHAR 20 0
BESCHR Description FM_BESCHR CHAR 40 0
FINCODE Fund BP_GEBER FMFINCODE CHAR 10 0
FINCODE_TXT Name FM_BEZEICH CHAR 20 0
FINUSE Application of Secondary Source Funds FM_FINUSE FMFUSE CHAR 16 0
SPONSOR Customer account number for fund FM_SPONSOR KNA1 CHAR 10 0
XFELD Checkbox XFELD CHAR 1 0
X Yes
NULL No
TOPFICTR Top Funds Center in a Subtree FM_FICTR_T CHAR 16 0
TOPFIPOS Highest Commitment Item in a Hierarchy FIPOS_TOP CHAR 14 0
APPLC_FM Funds management application indicator FM_APPLC CHAR 1 0
FMERROR Error number FM_ERROR CHAR 3 0
ZMB_FPOS Commitment item for transfer of cash holdings FM_ZMBFPOS FMCI CHAR 24 0
ZMB_YEAR Fiscal year in which cash holdings were transferred FM_ZMBYEAR NUMC 4 0
ZMB_PERI Period of cash holdings transfer FM_ZMBPERI NUMC 3 0
ZMB_UNAME User who transferred the cash holdings FM_ZMBUNAM CHAR 12 0
ZMB_DATE Date on which cash holdings were transferred FM_ZMBDATE DATS 8 0
Z_FPOS_A Commitment item for transfer of cash holdings FM_ZMBFPOS CHAR 24 0
Z_YEAR_A Fiscal year in which cash holdings were transferred FM_ZMBYEAR NUMC 4 0
TESTMODE Test Run ALLGTEST CHAR 1 0
X Yes
NULL No
PERDE Period PERIODE NUMC 3 0
PERIO Period/year JAHRPER NUMC 7 0
KBLKBLTYP Earmarked Funds Document Category KBLTYP NUMC 3 0
002 Funds transfer
020 Funds Block
030 Funds reservation
040 Funds precommitment
050 Funds commitment
060 Forecast of revenue
080 Credit Card Document
CF_ACTVT FYC Activity (fiscal year change) CF_ACTVT CHAR 2 0
GJAHRB1 Fiscal year up to which the FM line items are deleted FM_GJAHRB1 NUMC 4 0
GJAHRB2 Fiscal year up to which the FM totals records are deleted FM_GJAHRB2 NUMC 4 0
FIPEX Commitment Item FM_FIPEX CHAR 24 0
FWAER FM area currency FMWAER TCURC CUKY 5 0
P_FCTRUP Flag: including superior funds centers FM_FCTRUP CHAR 1 0
X Yes
NULL No
P_FCTRDN Flag: including subordinate funds centers FM_FCTRDN CHAR 1 0
X Yes
NULL No
P_FPOSUP Flag: including superior commitment items FM_FPOSUP CHAR 1 0
X Yes
NULL No
P_FPOSDN Including Subordinate Commitment Items FM_FPOSDN CHAR 1 0
X Yes
NULL No
BSTEXT Document status text FM_BSTEXT CHAR 20 0
TTEXT Budgeting technique text FM_TTEXT CHAR 20 0
RTEXT Text for reason for decision FM_RTEXT CHAR 50 0
CF_VALUES Balances carried forward FM_CFVAL CHAR 1 0
X Yes
NULL No
CF_RULES Carryforward rules FM_CFRULES CHAR 1 0
X Yes
NULL No
FIPGR Budget Structure Template FM_FIPGR CHAR 20 0
CFRULE FM carryforward rule (FYC) FM_CFRULE FMCFRULE CHAR 10 0
CAR_BUDCOM Budget object for commitment budget FM_BUDCOM CHAR 1 0
X Yes
NULL No
CAR_BUDPAY Indicator: budget object FM_BUDPAY CHAR 1 0
X Yes
NULL No
CAR_CTRCOM Assignment object in commitment budget FM_CNTRCOM CHAR 1 0
X Yes
NULL No
CAR_CTRPAY Assignment object in payment budget FM_CNTRPAY CHAR 1 0
X Yes
NULL No
RE_WAER1 Currency BP_WAERS CUKY 5 0
RE_WTJHR Financial Result (cannot be used any longer) FM_KOREERG CURR 15 2
BUDPAY Payment budget BP_PBO CHAR 1 0
X Yes
NULL No
BUDCOM Commitment budget BP_CBO CHAR 1 0
X Yes
NULL No
CHGDOC Write change documents FM_CHGDOC CHAR 1 0
X Yes
NULL No
BLCDOC Block source documents FM_BLCDOC CHAR 1 0
X Yes
NULL No
XONLYERR List to contain only documents with no complete acct asst FM_ONLYERR CHAR 1 0
X Yes
NULL No
XONLYFI Financial Accounting documents FM_ONLYFI CHAR 1 0
X Yes
NULL No
XONLYMM Select purchase orders and purchase requisitions FM_ONLYMM CHAR 1 0
X Yes
NULL No
XONLYNOF Select only documents with no funds center account assgt FM_ONLYNOF CHAR 1 0
X Yes
NULL No
XONLYBEG Document must be start of a document chain FM_ONLYBEG CHAR 1 0
X Yes
NULL No
XONLYAVC Execute availability control only FM_ONLYAVC CHAR 1 0
X Yes
NULL No
XONLYMRES Select earmarked funds FM_XONLYMR CHAR 1 0
X Yes
NULL No
XACOVERW Overwrite old account assignment in the documents FM_ACOVERW CHAR 1 0
X Yes
NULL No
XACPERM Acct assignment change allowed FM_ACPERM CHAR 1 0
X Yes
NULL No
XACIGNR Ignore external reassignment FM_ACIGNR CHAR 1 0
X Yes
NULL No
XACASSB Adjust assigned values FM_ACASSB CHAR 1 0
X Yes
NULL No
P_STAMM Only master data posted to FM_STAMM CHAR 1 0
X Yes
NULL No
GOPOS Position on line number FM_GOTOPOS NUMC 10 0
ISPOS Current item number FM_ISPOS NUMC 10 0
MAXPOS Number of lines in an internal table FM_MAXPOS NUMC 10 0
REFBN Number of the reference request FM_REFBN CHAR 10 0
RFBPV From item when editing reference for payment request FM_RFBPV NUMC 10 0
RFBPB To item when editing reference for payment request FM_RFBPB NUMC 10 0
PSOSU Total amount of a payment request FM_PSOSU CURR 15 2
GJAHR Fiscal Year GJAHR NUMC 4 0
VARNT Commitment Item Hierarchy Variant FM_VARNT FMCIVARNT CHAR 3 0
XCPDD Copy payer data FM_XCPDD CHAR 1 0
X Yes
NULL No
XSAKN Copy number of general ledger account FM_XSAKN CHAR 1 0
X Yes
NULL No
XPOSTOPEN Post open items FM_POSTOPEN CHAR 1 0
X Yes
NULL No
XPOSTCLEARED Post cleared items FM_POSTCLEARED CHAR 1 0
X Yes
NULL No
XPOSTCC Post cross-company code items FM_POSTCC CHAR 1 0
X Yes
NULL No
XDELEOPEN Reset open items FM_DELEOPEN CHAR 1 0
X Yes
NULL No
XDELECLEARED Reset cleared items FM_DELECLEARED CHAR 1 0
X Yes
NULL No
XDELECC Reset cross-company code items FM_DELECC CHAR 1 0
X Yes
NULL No
FM_EXTPROT Display detailed log FM_EXTPROT CHAR 1 0
X Yes
NULL No
FM_ERRONLY Display errors only FM_ERRONLY CHAR 1 0
X Yes
NULL No
BSP_CPY_BUDYEAR Create Budget Structure for Years with Budget Only FM_BSP_CPY_BY CHAR 1 0
X Yes
NULL No
P_C_CURR Report currency FM_WAERS_R TCURC CUKY 5 0
P_C_DATE Conversion Date FM_DATE_R DATS 8 0
TOPFIPEX Highest Commitment Item in Subtree FM_FIPEX_T CHAR 24 0
P_FCTHIE Hierarchical sequence FM_FCTHIE CHAR 1 0
X Yes
NULL No
P_FPOHIE Hierarchical sequence FM_FPOHIE CHAR 1 0
X Yes
NULL No
P_CF_AB Indicator: Display update run FM_PCFAB CHAR 1 0
X Yes
NULL No
P_CF_ABS Indicator: Display preselected budget FM_PCFABS CHAR 1 0
X Yes
NULL No
P_CF_ABT Indicator: Commitment display, test mode FM_PCFABT CHAR 1 0
X Yes
NULL No
BSP_GRP_TO_SINGL Budget Structure Template - copy individual objects FM_BSP_GPR_SINGL CHAR 1 0
X Yes
NULL No
P_FMAADN Indicator: Inclusive Subordinate FM Account Assignments FM_FMAADN CHAR 1 0
X Yes
NULL No
P_FMAHIE Hierarchical Order of FM Account Assignments FM_FMAHIE CHAR 1 0
X Yes
NULL No
P_FMAAUP Indicator: Include Superior FM Account Assignments FM_FMAAUP CHAR 1 0
X Yes
NULL No
BSP_GRP_TO_GRP Budget structure template: copy funds center assignments FM_BSP_GRP_GRP CHAR 1 0
X Yes
NULL No
XDELETETOTALS_CO Totals Records FM_TOTALTAB CHAR 1 0
X Yes
NULL No
XDELETEITEMS_CO Line Items FM_LINEITEMTAB CHAR 1 0
X Yes
NULL No
RC_UNASSIGNED Documents Without Reason Codes FM_WITHOUT_RC CHAR 1 0
X Yes
NULL No
RC_ASSIGNED Documents with Reason Codes FM_WITH_RC CHAR 1 0
X Yes
NULL No
SUBVO_BEZ Budget Subtype Name (M) BP_SUBVOT20 CHAR 20 0
SUBVO Budget Subtype BP_SUBVO CHAR 4 0
FAREA Functional Area FM_FAREA TFKB CHAR 16 0
FAREA_TXT Name of the functional area FKBTX CHAR 25 0
VERSN Planning/budgeting version BP_VERSION CHAR 3 0
VERSN_TXT Version Text VSTXT CHAR 30 0
CVARNT Hierarchy Variant of Funds Center FM_HIVARNT FMHIVARNT CHAR 4 0
CO_GRP Indicator : Without CO groups FM_COGRP CHAR 1 0
X Yes
NULL No
XDATA Copy Posting Date and Document Date FM_XDATA CHAR 1 0
X Yes
NULL No
PSOSUFW Total Request Amount FM_PSOSUFW CURR 15 2
RE_WAER2 Currency BP_WAERS CUKY 5 0
P_ENTRY_HEADER Indicator: Including Fields from Entry Documents FM_EHEAD CHAR 1 0
X Yes
NULL No
ADD_TEXT Display addit.text FM_ADD_TEXT CHAR 1 0
X Yes
NULL No
P_KUM_C Calculate values, including subordinate funds centers FM_KUM_C CHAR 1 0
X Yes
NULL No
P_KUM_IT Summarized line items FM_KUM_IT CHAR 1 0
X Yes
NULL No
P_KUM_TIME Cumulative display FM_KUM_TIME CHAR 1 0
X Yes
NULL No
P_XOPIT Including reduced commitment FM_XOPIT CHAR 1 0
X Yes
NULL No
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0

FMDY foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FMDY BUKRS FMDY BUKRS T001 Company Codes BUKRS
FMDY BUKRS FMDY MANDT T001 Company Codes MANDT
FMDY CFRULE FMDY CFRULE FMCFRULE FM - Carryforward Parameters (FYC) CFRULE
FMDY CFRULE FMDY MANDT FMCFRULE FM - Carryforward Parameters (FYC) MANDT
FMDY CFRULE FMDY FIKRS FMCFRULE FM - Carryforward Parameters (FYC) FIKRS
FMDY CTR_OBJNR FMDY CTR_OBJNR ONR00 General Object Number OBJNR
FMDY CTR_OBJNR FMDY MANDT ONR00 General Object Number MANDT
FMDY CVARNT FMDY FIKRS FMHIVARNT Funds Center Hierarchy Variant: Entities FIKRS
FMDY CVARNT FMDY CVARNT FMHIVARNT Funds Center Hierarchy Variant: Entities HIVARNT
FMDY CVARNT * FMHIVARNT Funds Center Hierarchy Variant: Entities MANDT
FMDY FAREA FMDY FAREA TFKB Functional areas FKBER
FMDY FAREA FMDY MANDT TFKB Functional areas MANDT
FMDY FIKRS FMDY MANDT FM01 Financial Management Areas MANDT
FMDY FIKRS FMDY FIKRS FM01 Financial Management Areas FIKRS
FMDY FINCODE FMDY FIKRS FMFINCODE FIFM: Financing code FIKRS
FMDY FINCODE FMDY FINCODE FMFINCODE FIFM: Financing code FINCODE
FMDY FINCODE FMDY MANDT FMFINCODE FIFM: Financing code MANDT
FMDY FINUSE FMDY MANDT FMFUSE FIFM: Application of Funds from Secondary Sources MANDT
FMDY FINUSE FMDY FIKRS FMFUSE FIFM: Application of Funds from Secondary Sources FIKRS
FMDY FINUSE FMDY FINUSE FMFUSE FIFM: Application of Funds from Secondary Sources FINUSE
FMDY FMA_OBJNR FMDY MANDT ONR00 General Object Number MANDT
FMDY FMA_OBJNR FMDY FMA_OBJNR ONR00 General Object Number OBJNR
FMDY FWAER FMDY MANDT TCURC Currency Codes MANDT
FMDY FWAER FMDY FWAER TCURC Currency Codes WAERS
FMDY MANDT FMDY MANDT T000 Clients MANDT
FMDY P_C_CURR FMDY MANDT TCURC Currency Codes MANDT
FMDY P_C_CURR FMDY P_C_CURR TCURC Currency Codes WAERS
FMDY SPONSOR FMDY MANDT KNA1 General Data in Customer Master MANDT
FMDY SPONSOR FMDY SPONSOR KNA1 General Data in Customer Master KUNNR
FMDY VARNT FMDY MANDT FMCIVARNT Variant for commitment item hierarchy: Entities texts MANDT
FMDY VARNT FMDY FIKRS FMCIVARNT Variant for commitment item hierarchy: Entities texts FIKRS
FMDY VARNT * FMCIVARNT Variant for commitment item hierarchy: Entities texts GJAHR
FMDY VARNT FMDY VARNT FMCIVARNT Variant for commitment item hierarchy: Entities texts VARNT
FMDY ZMB_FPOS FMDY MANDT FMCI Commitment items master data .INCLUDE
FMDY ZMB_FPOS FMDY FIKRS FMCI Commitment items master data MANDT
FMDY ZMB_FPOS * FMCI Commitment items master data FIKRS
FMDY ZMB_FPOS FMDY ZMB_FPOS FMCI Commitment items master data GJAHR