1. Home
  2. Resources
  3. SAP Tables
  4. IFMBLIN - Budgetary Ledger Interface

SAP Table IFMBLIN

Budgetary Ledger Interface

IFMBLIN (Budgetary Ledger Interface) 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 IFMBLIN to other SAP tables.

IFMBLIN table fields

Field Data element Checktable Datatype Length Decimals
COMP_CODE Company Code BUKRS CHAR 4 0
GL_ACCOUNT General Ledger Account HKONT CHAR 10 0
OBJ_TYPE Reference Transaction AWTYP CHAR 5 0
VALUE_TYPE Value Type FM_WRTTP CHAR 2 0
50 Purchase Requisitions
51 Purchase Orders
52 Business Trip Commitments
54 Invoices
57 Payments
58 Down Payment Requests
60 Parked Documents
6B Clarification Worklist FI-CA
61 Down Payments
64 Funds Transfers
65 Funds Commitment
66 Transfer Postings
80 Funds Block
81 Funds Reservation
82 Funds Precommitment
83 Forecast of Revenue
84 Payment Reservation (Not for General Use)
95 Secondary Cost Postings (CO)
TRANSAC CO Business Transaction CO_VORGANG CHAR 4 0
AMT_TYPE Amount type FM_BTART CHAR 4 0
0100 Original
0110 Approved in Workflow (Workflow ledger 9D only)
0120 Not approved in Workflow (Workflow ledger 9D only)
0150 Change
0200 Reduction
0210 Reduction Cheque Clearing
0220 Change by Revaluation
0250 Paid
0260 Paid Cheque Clearing
0300 Previous Year Carryforward (Commitments)
0350 Following year carryforward (commitments)
0351 Commitment Carryforward: Carryforward Consumed Amount
0352 Commitment Carryforward: Reduction of Consumed Amount
0360 Balance from Previous Years
0400 Block Entry
0500 Adjustment by Follow-on Document
0600 Reassignment Sender
0650 Reassignment Receiver
0700 Settlement of Retirements
0750 Settlement of Acquisitions
LEDGER Ledger RLDNR CHAR 2 0
FM_AREA Financial Management Area FIKRS CHAR 4 0
REFDOCNR Reference document number of an accounting document REFBELNR CHAR 10 0
CARRYFWD_LEVEL Carryforward level FM_CFLEV CHAR 1 0
NULL Document and Predecessor not Carried Forward
X X Document or Predecessor Carried Forward
U U Customer Flag: Document or Predecessor Carried Forward
0 Customer Specification: Number of Carryforwards
CFSTAT FM Commitment Carryforward: Status FM_CFST NUMC 2 0
00
31 Carried forward to following year
32 Carried forward from previous year
41 Selected for carryforward (Workflow)
42 Carryforward Approved (Workflow)
51 Carryforward reversed
99 No commitment cfwd
BL_DOC_TYPE FM budgetary ledger document type FM_BL_DOC_TYPE CHAR 4 0
LOCAL_AMT 9(17)-character value field with 2 decimal places WERTV9 CURR 17 2
TRANS_AMT 9(17)-character value field with 2 decimal places WERTV9 CURR 17 2
CURR_KEY Currency Key RTCUR CUKY 5 0
BDGT_SUBTYPE Budget Subtype BP_SUBVO CHAR 4 0
LINE_TYPE Single-Character Indicator CHAR1 CHAR 1 0
DP_WITH_PO FM Down payment with reference to purchase order for BL FM_DP_WITH_PO CHAR 1 0
NULL Down payment without reference to a purchase order
X Down payment with reference to a purchase order
VBUND_FLG Company ID of trading partner flag for BL FM_VBUND_FLG CHAR 1 0
0 Irrelevant status of trading partner ID
1 1 Federal government trading partner ID
2 2 Non-federal government trading partner ID
* * Generic value (any entry 1, 2, 3)
TRADE_ID Company ID of trading partner RASSC CHAR 6 0
FISC_YEAR Fiscal Year GJAHR NUMC 4 0
PSTNG_PERIOD Posting period POPER NUMC 3 0
PSTNG_DATE Posting Date in the Document BUDAT DATS 8 0
DOC_DATE Document Date in Document BLDAT DATS 8 0
CMMT_ITEM Commitment Item FM_FIPEX CHAR 24 0
FUNDS_CTR Funds Center FISTL CHAR 16 0
FUND Fund BP_GEBER CHAR 10 0
FUNC_AREA Functional Area FM_FAREA CHAR 16 0
MEASURE Funded Program FM_MEASURE CHAR 24 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
TRANSAC_REFRESH CO Business Transaction CO_VORGANG CHAR 4 0
NO_REFRESH_FLAG Single-Character Indicator CHAR1 CHAR 1 0
DB_CR_IND Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
USER_DIM Customer Field for FM Actual and Commitment Data FM_USERDIM CHAR 10 0
LDGR_AREA Ledger area FM_LDAREA CHAR 1 0
0 0 Budgetary
1 1 Proprietary
FUNDS_CTR_TOP Funds Center FISTL CHAR 16 0
FUNDS_CTR_ORI Funds Center FISTL CHAR 16 0
OBJECT_NO Object number J_OBJNR CHAR 22 0
COST_CTR Cost Center KOSTL CHAR 10 0
ORDER_NUM Order Number AUFNR CHAR 12 0
WBS_ELEMENT WBS Element PS_POSNR NUMC 8 0
ENTRY_USER User name USNAM CHAR 12 0
ENTRY_DATE Day On Which Accounting Document Was Entered CPUDT DATS 8 0
ENTRY_TIME Time of Entry CPUTM TIMS 6 0
COHORT Reporting Year for Cohort FM_COHORT CHAR 4 0
PUBLAW Public Law Cited FM_PUBLAW CHAR 20 0
LEGIS Type of Legislation FM_LEGIS CHAR 1 0
BUS_AREA Business Area GSBER CHAR 4 0
PROFIT_CTR Profit Center PRCTR CHAR 10 0
PO_NUMBER Purchasing Document Number EBELN CHAR 10 0
PO_ITEM Item Number of Purchasing Document EBELP NUMC 5 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
OBJ_POS Reference line item AWPOS CHAR 10 0
OBJ_ID Reference document: Current identification AWID CHAR 10 0
OBJ_SYS Logical system of source document AWSYS CHAR 10 0
REF_ORG_UN Reference Organizational Units AWORG CHAR 10 0
VREFBT Predecessor document category FM_VREFBT NUMC 3 0
010 Purchase requisitions
020 Purchase orders
110 Earmarked Funds
910 FI documents
900 Parked documents
040 Trips
920 CO documents
050 Sales Order Predecessor Document
060 Sales Orders
VREFBN Predecessor document number FM_VREFBN CHAR 10 0
VRFPOS Predecessor document item FM_VRFPOS NUMC 5 0
VRFKNT Predecessor account assignment FM_VRFKNT NUMC 5 0
VRFTYP Reference Transaction AWTYP CHAR 5 0
VRFSYS Logical System LOGSYSTEM CHAR 10 0
VRFORG Predecessor document organization FM_VRFORG CHAR 10 0
REFBT Reference document category FM_REFBTYP NUMC 3 0
010 Purchase requisitions
020 Purchase orders
110 Earmarked Funds
910 FI documents
900 Parked documents
040 Trips
920 CO documents
050 Sales Order Predecessor Document
060 Sales Orders
FMVOR Classification of Document Lines FMVOR CHAR 4 0
ADUP Commitment Increase
ADDN Commitment Decrease
PAMG Purchase Account Processing
PD01 Price Difference, General
PD02 Price Difference, Relevant with Quantity
SC01 Subcontracting, Clearing
SC02 Subcontracting, Material Offsetting Posting
STAT_IND Funds Management Statistical Indicator FM_STATS CHAR 1 0
NULL Real (Budget Relevant)
X Statistical (not budget-relevant, no FYC)
Y Statistical (not budget relevant, relevant for FYC)
VENDOR_NO Account Number of Vendor or Creditor LIFNR CHAR 10 0
CUSTOMER Customer Number KUNNR CHAR 10 0
CASH_YEAR Year of Cash Effectivity GNJHR NUMC 4 0
TRANSFER_AGENCY Transfer Agency FMFG_TRANSFER_AGCY CHAR 2 0
TRANSFER_ACCOUNT Transfer Account FMFG_TRANSFER_ACCT CHAR 4 0
RCOMP Trading Partner FMFG_TP_TO CHAR 6 0
ASSSETTRTYP Asset Transaction Type ANBWA CHAR 3 0
BUD_PROCESS Budgeting Process BUKU_PROCESS_UI CHAR 4 0