SAP FDFIEP CM: FI Line Items (OP of Deb/Cred for Drilldown) Table data and field list

FDFIEP is a standard SAP Table which is used to store CM: FI Line Items (OP of Deb/Cred for Drilldown) data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FDFIEP table consists of various fields, each holding specific information or linking keys about CM: FI Line Items (OP of Deb/Cred for Drilldown) data available in SAP. These include AUSBK (Source Company Code), BELNR (Accounting Document Number), GJAHR (Fiscal Year), BUZEI (Number of Line Item Within Accounting Document)... 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. .

FDFIEP table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP FDFIEP table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the FDFIEP table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
AUSBKSource Company Code AUSBKCHAR4T001BUKRS
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
DISPWPlanned currency for cash management and forecast DISPWCUKY5TCURCWAERSFDW
FDGRPPlanning Group FDGRPCHAR10T035ALPHAFDGRPFFG
FDLEVPlanning level FDLEVCHAR2T036FDLEVFFE
FDTAGPlanning date FDTAGDATS8DATUMFDT
FDWBTAmount in planned currency WRSHDCURR15(2) WRTV8
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
KOARTAccount Type KOARTCHAR1KOART
KUNNRCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
SEGMENTSegment for Segmental Reporting FB_SEGMENTCHAR10Assigned to domainALPHAFB_SEGMENT
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
GEBERFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC

Key field Non-key field



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

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

SELECT SINGLE *
FROM FDFIEP
INTO CORRESPONDING FIELDS OF WA_FDFIEP
WHERE...

How to access SAP table FDFIEP

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

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