FMIFIHD
FI Header Table in Funds Management
FMIFIHD is an SAP database table in S/4HANA. FI Header Table in Funds Management. It contains 20 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_FundsManagementDocument | view | from | BASIC | FM Document |
Fields (20)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | fmbelnr | FM_BELNR | FM Doc. No. | |||
| KEY | fikrs | FIKRS | FM Area | |||
| budat | BUDAT | Posting Date | ||||
| bldat | BLDAT | Document Date | ||||
| bukrs | BUKRS | Company Code | ||||
| blart | BLART | Document Type | ||||
| vorgn | CO_VORGANG | Bus.Transaction | ||||
| bktxt | BKTXT | Doc.Header Text | ||||
| lifnr | LIFNR | Supplier | ||||
| kunnr | KUNNR | Customer | ||||
| awtyp | AWTYP | Ref. procedure | ||||
| awref | AWREF | Reference Doc. | ||||
| aworg | AWORG | Refer. Org.Unit | ||||
| awsys | LOGSYSTEM | Logical System | ||||
| xrevs | STNKZ | Cancel. ID | ||||
| refbn | CO_REFBN | Ref.document no | ||||
| refbk | CO_REFBK | RefCompanyCode | ||||
| refgj | CO_REFGJ | RefFiscalYear | ||||
| loekz | KBLLOEKZ | Del. Ind. |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- FI Header Table in Funds Management
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FMIFIHD (
MANDT, -- Client [MANDT]
FMBELNR, -- FM Doc. No. [FM_BELNR]
FIKRS, -- FM Area [FIKRS]
BUDAT, -- Posting Date [BUDAT]
BLDAT, -- Document Date [BLDAT]
BUKRS, -- Company Code [BUKRS]
BLART, -- Document Type [BLART]
VORGN, -- Bus.Transaction [CO_VORGANG]
BKTXT, -- Doc.Header Text [BKTXT]
LIFNR, -- Supplier [LIFNR]
KUNNR, -- Customer [KUNNR]
AWTYP, -- Ref. procedure [AWTYP]
AWREF, -- Reference Doc. [AWREF]
AWORG, -- Refer. Org.Unit [AWORG]
AWSYS, -- Logical System [LOGSYSTEM]
XREVS, -- Cancel. ID [STNKZ]
REFBN, -- Ref.document no [CO_REFBN]
REFBK, -- RefCompanyCode [CO_REFBK]
REFGJ, -- RefFiscalYear [CO_REFGJ]
LOEKZ, -- Del. Ind. [KBLLOEKZ]
PRIMARY KEY (MANDT, FMBELNR, FIKRS)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA