SAP FMFG_EXCLUDE_INVOICE_FIELDS Data Collection fields for Improper Reason Code Table data and field list

FMFG_EXCLUDE_INVOICE_FIELDS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Data Collection fields for Improper Reason Code" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FMFG_EXCLUDE_INVOICE_FIELDS TYPE FMFG_EXCLUDE_INVOICE_FIELDS.

The FMFG_EXCLUDE_INVOICE_FIELDS table consists of various fields, each holding specific information or linking keys about Data Collection fields for Improper Reason Code data available in SAP. These include GJAHR (Fiscal Year), BELNR (Accounting Document Number), BUDAT (Posting Date in the Document), BLDAT (Document Date in 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. .

FMFG_EXCLUDE_INVOICE_FIELDS structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP FMFG_EXCLUDE_INVOICE_FIELDS structure 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 FMFG_EXCLUDE_INVOICE_FIELDS 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
BUKRS	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
BELNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
BUDAT	Posting Date in the Document	BUDAT	DATS	8			DATUM
BLDAT	Document Date in Document	BLDAT	DATS	8			DATUM
CPUDT	Day On Which Accounting Document Was Entered	CPUDT	DATS	8			DATUM
XBLNR	Reference Document Number	XBLNR1	CHAR	16			XBLNR1
BLART	Document Type	BLART	CHAR	2	Assigned to domain		BLART	BAR
EXCLUDE_FLAG	PPA Exclude Indicator	EXCLUDE_FLG	CHAR	1			XFELD
AWTYP	Reference Transaction	AWTYP	CHAR	5	Assigned to domain		AWTYP
AWKEY	Reference Key	AWKEY	CHAR	20			AWKEY
AWSYS	Logical system	LOGSYS	CHAR	10	Assigned to domain	ALPHA	LOGSYS
WAERS	Currency Key	WAERS	CUKY	5	Assigned to domain		WAERS	FWS
KOART	Account Type	KOART	CHAR	1			KOART
LIFNR	Account Number of Vendor or Creditor	LIFNR	CHAR	10	Assigned to domain	ALPHA	LIFNR	LIF	KRED_C
BUZEI	Number of Line Item Within Accounting Document	BUZEI	NUMC	3			BUZEI	BUZ
EBELN	Purchasing Document Number	EBELN	CHAR	10	Assigned to domain	ALPHA	EBELN	BES	MEKK_C
EBELP	Item Number of Purchasing Document	EBELP	NUMC	5	Assigned to domain		EBELP	BSP
MATNR	Material Number	MATNR	CHAR	18	Assigned to domain	MATN1	MATNR	MAT	S_MAT1
FIPOS	Commitment Item	FIPOS	CHAR	14	Assigned to domain		FIPOS	FIP
HKONT	General Ledger Account	HKONT	CHAR	10	Assigned to domain	ALPHA	SAKNR
FIPEX	Commitment item (No longer in use -> FM_FIPEX)	FIPEX	CHAR	24		FIPEX	FIPEX	FPS
WRBTR	Amount in document currency	WRBTR	CURR	13(2)			WERT7
SHKZG	Debit/Credit Indicator	SHKZG	CHAR	1			SHKZG
VENDOR_BUZEI	Reference line item (CCN)	FM_BUZEIC	NUMC	3			BUZEI
NEW_EXCLUDE_LINE_IND	PPA Exclude Indicator	EXCLUDE_FLG	CHAR	1			XFELD

Key field

Non-key field

< FMFG_EKPODATA - Add on for Public Sector FMFG_EXCPE2 - PPA: Acceptance Period >

How do I retrieve data from SAP structure FMFG_EXCLUDE_INVOICE_FIELDS using ABAP code?

As FMFG_EXCLUDE_INVOICE_FIELDS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FMFG_EXCLUDE_INVOICE_FIELDS as there is no data to select.

How to access SAP table FMFG_EXCLUDE_INVOICE_FIELDS

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

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