SAP table FMBH (Funds management budget header (entry documents))

SAP table FMBH has 4 primary key fields being CLIENT,FM_AREA,DOCYEAR,DOCNR.

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 MANDT
FM_AREA Financial Management Area CHAR 4 0 FIKRS
DOCYEAR Document Year NUMC 4 0 BUKU_DOCYEAR
DOCNR Budget entry document number CHAR 10 0 BUED_DOCNR
DOCFAM Document Family Number CHAR 10 0 BUED_DOCFAM
TECHORG Original Application CHAR 10 0 BUTECHORG BUKU_TECHORG
PROCESS_UI Budgeting Process CHAR 4 0 BUPROCESS_UI BUKU_PROCESS_UI
VERSION Budget Version CHAR 3 0 BUKU_VERSION
CRTUSER User Who Created or Updated the Object CHAR 12 0 BUKU_CRTUSER
CRTDATE Date on which the object was created or updated DATS 8 0 BUKU_CRTDATE
CRTTIME Time at which the object was created or updated TIMS 6 0 BUKU_CRTTIME
DOCDATE Document Date DATS 8 0 BP_BLDAT
POSTDATE Posting Date in the Document DATS 8 0 BUDAT
REASON_REV Reason for Reversal of Budget Document CHAR 2 0 FMREV_STGRD
RESPPERS Person Responsible for Planning/Budgeting CHAR 20 0 BP_VERANT
TEXT50 Header Text for Budget Entry Document CHAR 50 0 BUED_HDTEXT
TEXTNAME Text Name CHAR 32 0 BP_TDNAM
LTXT_IND Long Text Exists CHAR 1 0 BP_LTEXT
DOCSTATE Status of a budget entry document CHAR 1 0 BUED_DOCSTATE
1 Posted
2 Preposted
3 Preposted Posted
4 Undone
REVSTATE Reversal Status CHAR 1 0 BP_RSTAT
Normal
1 Reversal
2 Reversed
3 To be reversed
REV_REFNR Reversal Reference Document Number CHAR 10 0 BUED_REV_REFNR
DOCTYPE Budget entry document type CHAR 4 0 FMEDDOCTYPE BUED_DOCTYPE
LOGSYS Logical system CHAR 10 0 LOGSYS
COHORT Reporting Year for Cohort CHAR 4 0 FM_COHORT
PUBLAW Public Law Cited CHAR 20 0 FM_PUBLAW
LEGIS Type of Legislation CHAR 1 0 FM_LEGIS
AWORG Reference Organizational Units CHAR 10 0 AWORG
AWREF Reference document number CHAR 10 0 AWREF
AWSYS Logical system of source document CHAR 10 0 AWSYS
AWTYP Reference procedure CHAR 5 0 AWTYP
XBLNR Reference Document Number CHAR 16 0 XBLNR1
LAYOUTVAR Layout variant - Layout management in budgeting CHAR 6 0 FMLA FMLA_LAYOUTVAR
TRANSFER_AGENCY Transfer Agency CHAR 2 0 FMFG_TRANSFER_AGCY
TRANSFER_ACCOUNT Transfer Account CHAR 4 0 FMFG_TRANSFER_ACCT
RCOMP Company ID of Trading Partner CHAR 6 0 RASSC
CHGUSER Last user to change object CHAR 12 0 BUKU_CHGUSER
CHGDATE Date on which the object was changed DATS 8 0 BUKU_CHGDATE
CHGTIME Time at which the object was changed TIMS 6 0 BUKU_CHGTIME
FMFGUS_KEY United States Federal Government Fields CHAR 22 0 FMFGUSKONTKEY FMFG_US_KEY
AWKEY Reference Key CHAR 20 0 AWKEY
DUMMY_FMBH_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
DUMMY_BCS_DOC_EXT General Flag CHAR 1 0 FLAG
Flag is not set
X Flag set (event raised)
PFM_FOA Form of Amendment Code CHAR 2 0 PFM_TFOA PFM_FOA
PFM_SPEC Specification Code CHAR 2 0 PFM_TSPEC PFM_SPEC
/SAPF15/STATUS Document Status CHAR 1 0 /SAPF15/STATUS

FMBH foreign key relationships

Table Field Check Table Check Field
0 FMBH DOCTYPE FMEDDOCTYPE FM budget entry document type DOCTYPE
1 FMBH FMFGUS_KEY FMFGUSKONTKEY Key for US Account Assignments MANDT
0 FMBH LAYOUTVAR FMLA Layout Variant LAYOUTVAR
1 FMBH PFM_FOA PFM_TFOA Forms of Amendment MANDT
1 FMBH PFM_FOA PFM_TFOA Forms of Amendment PFM_FOA
0 FMBH PFM_SPEC PFM_TSPEC Specifications MANDT
0 FMBH PFM_SPEC PFM_TSPEC Specifications PFM_SPEC
1 FMBH TECHORG BUTECHORG Table of original Transactions (Technical) CLIENT
1 FMBH TECHORG BUTECHORG Table of original Transactions (Technical) TECHORG