SAP FMFG_PP_CLEAR_OPEN_ITEMS Open items for clearing program Table data and field list

FMFG_PP_CLEAR_OPEN_ITEMS 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 "Open items for clearing program" 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_PP_CLEAR_OPEN_ITEMS TYPE FMFG_PP_CLEAR_OPEN_ITEMS.

The FMFG_PP_CLEAR_OPEN_ITEMS table consists of various fields, each holding specific information or linking keys about Open items for clearing program data available in SAP. These include UMSKZ (Special G/L Indicator), NET_DUE_DATE (Baseline Date for Due Date Calculation), RCLNT (Client), GL_SIRID (Record number of the line item record)... 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_PP_CLEAR_OPEN_ITEMS structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)

SAP FMFG_PP_CLEAR_OPEN_ITEMS 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_PP_CLEAR_OPEN_ITEMS 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
ACCOUNT	Account Number of Vendor or Creditor	LIFNR	CHAR	10	Assigned to domain	ALPHA	LIFNR	LIF	KRED_C
UMSKZ	Special G/L Indicator	UMSKZ	CHAR	1	Assigned to domain		UMSKZ
NET_DUE_DATE	Baseline Date for Due Date Calculation	DZFBDT	DATS	8			DATUM
RCLNT	Client	MANDT	CLNT	3	T000		MANDT
GL_SIRID	Record number of the line item record	GU_RECID	CHAR	18			OBJNR	OBN
RLDNR	Ledger	RLDNR	CHAR	2	T881	ALPHA	RLDNR	GLN	H_T881
RRCTY	Record Type	RRCTY	CHAR	1			RRCTY
RVERS	Version	RVERS	CHAR	3	T894	ALPHA	RVERS	GVS
RYEAR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
RTCUR	Currency Key	RTCUR	CUKY	5	TCURC		WAERS	FWS
DRCRK	Debit/Credit Indicator	SHKZG	CHAR	1			SHKZG
POPER	Posting period	POPER	NUMC	3			POPER	POPR
DOCCT	Document Type	DOCCT	CHAR	1			DOCCT	GCT
DOCNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
DOCLN	Six-Character Posting Item for Ledger	DOCLN6	CHAR	6			DOCLN6
RBUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
RACCT	Account Number	RACCT	CHAR	10	Assigned to domain	ALPHA	SAKNR	ACC
RBUSA	Business Area	GSBER	CHAR	4	TGSB		GSBER	GSB
RPRCTR	Profit Center	PRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PRC	PRCTR_EMPTY
RCNTR	Cost Center	KOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
RPROJK	Work Breakdown Structure Element (WBS Element)	PS_PSP_PNR	NUMC	8	PRPS	KONPR	PS_POSNR
RFAREA	Functional Area	FKBER	CHAR	16	TFKB		FKBER	FBE
RFUND	Fund	BP_GEBER	CHAR	10	Assigned to domain		BP_GEBER	FIC
RFIPEX	Commitment Item	FM_FIPEX	CHAR	24	Assigned to domain		FM_FIPEX	FPS
RFISTL	Funds Center	FISTL	CHAR	16	Assigned to domain		FISTL	FIS
RORDNR	Order Number	AUFNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	ANR
RVBUND	Company ID of trading partner	RASSC	CHAR	6	Assigned to domain	ALPHA	RCOMP	PGS
RAGNCY_LCTN_CODE	Agency Location Code	FMFG_ALC	CHAR	8	Assigned to domain		FMFG_ALC	FMFG_ALC
RFINUSE	Application of Secondary Source Funds	FM_FINUSE	CHAR	16	Assigned to domain		FM_FINUSE	FIU
LOGSYS	Logical system	LOGSYS	CHAR	10	TBDLS	ALPHA	LOGSYS
FMFG_SUBKEY_9	Subkey for FMUSFGT	FMFG_SUBKEY	CHAR	10			CHAR10
BLSTATUS_9	Budgetary ledger status	FMFG_BLSTATUS	CHAR	5			FMFG_BLSTATUS		FMFG_BLSTATUS
TSL	Value in Transaction Currency	VTCUR9	CURR	17(2)			WERTV9
HSL	Value in local currency	VLCUR9	CURR	17(2)			WERTV9
SGTXT	Item Text	SGTXT	CHAR	50			TEXT50
DOCTY	FI-SL Document Type	DOCTY	CHAR	2	T889		DOCTY	BAR
ACTIV	Business Transaction	GLVOR	CHAR	4			CHAR4
BUDAT	Posting Date in the Document	BUDAT	DATS	8			DATUM
WSDAT	Value Date for Currency Translation	WSDAT	DATS	8			DATUM	WSD
BLDAT	Document Date in Document	BLDAT	DATS	8			DATUM
REFDOCNR	Reference document number of an accounting document	REFBELNR	CHAR	10		ALPHA	BELNR	BLN
REFRYEAR	Reference fiscal year	REFGJAHR	NUMC	4		GJAHR	GJAHR	GJR
REFDOCLN	Six-digit number of the reference posting line	REFBUZEI6	NUMC	6			BUZEI6	BUZ
REFDOCCT	Reference document category	REFDOCCT	CHAR	1			DOCCT	GCT
REFACTIV	FI-SL Business Reference Transaction	REFGLVOR	CHAR	4			CHAR4
CPUDT	Day On Which Accounting Document Was Entered	CPUDT	DATS	8			DATUM
CPUTM	Time of Entry	CPUTM	TIMS	6			UZEIT
USNAM	User name	USNAM	CHAR	12	Assigned to domain		XUBNAME	USR
AWTYP	Reference Transaction	AWTYP	CHAR	5	TTYP		AWTYP
AWORG	Reference Organizational Units	AWORG	CHAR	10			AWORG
PMT_OFFICE	Payment Office	FMFG_PMT_OFF	CHAR	5	Assigned to domain		FMFG_PMT_OFF	FMFG_PMT_OFFICE
COHORT	Reporting Year for Cohort	FM_COHORT	CHAR	4			FM_COHORT
PUBLAW	Public Law Cited	FM_PUBLAW	CHAR	20			FM_PUBLAW
LEGIS	Type of Legislation	FM_LEGIS	CHAR	1			FM_LEGIS
FLG_COVERED	Covered Indicator	FM_FLG_COVERED	CHAR	1			FM_FLG_COVERED
FLG_CUSTODIAL	Custodial Indicator	FM_FLG_CUSTODIAL	CHAR	1			FM_FLG_CUSTODIAL
FLG_ENTITY	Entity Indicator	FM_FLG_ENTITY	CHAR	1			FM_FLG_ENTITY
FLG_EXCHANGE	Exchange Indicator	FM_FLG_EXCHANGE	CHAR	1			FM_FLG_EXCHANGE
FLG_FEDERAL	Federal/Nonfederal Code	FM_FLG_FEDERAL	CHAR	1			FM_FLG_FEDERAL
FLG_APPORT	Apportionment Category	FM_FLG_APPORT	CHAR	1			FM_FLG_APPORT
FLG_AVAIL	Availability Time	FM_FLG_AVAIL	CHAR	1			FM_FLG_AVAIL
FLG_BORROW	Borrowing Source	FM_FLG_BORROW	CHAR	1			FM_FLG_BORROW
FLG_DEFINITE	Definite/Indef indicator	FM_FLG_DEFINITE	CHAR	1			FM_FLG_DEFINITE
FLG_PARTNER	Transaction Partner	FM_FLG_PARTNER	CHAR	1			FM_FLG_PARTNER
FLG_REIMBUR	Reimbursable	FM_FLG_REIMBUR	CHAR	1			FM_FLG_REIMBUR
FLG_AUTHOR	Authority Type	FM_FLG_AUTHOR	CHAR	1			FM_FLG_AUTHOR
FLG_BEA	Budget Enforcement Act Category	FM_FLG_BEA	CHAR	1			FM_FLG_BEA
BUREAU	Federal Bureau	FM_BUREAU	CHAR	2			FM_BUREAU
BUSINESS_LINE	Business Line	FM_BUSINESS_LINE	CHAR	2			FM_BUSINESS_LINE
FGDPRTMNT	Federal Department	FM_DEPARTMENT	CHAR	2			FM_DEPARTMENT
FGDPRTMNT_PART	Federal Department Partner	FM_DEPARTMENT_PARTNER	CHAR	2			FM_DEPARTMENT
FUND_ACC_SYMBL	Treasury Account Symbol - Main Account	FM_MAIN_ACCT	CHAR	4			FM_MAIN_ACCT
WSL	Value in Original Transaction Currency (Document Currency)	VWCUR12	CURR	23(2)			WERTV12
RWCUR	Currency key of the original transaction currency	RWCUR	CUKY	5	Assigned to domain		WAERS	FWS
AWID	Reference document: Current identification	AWID	CHAR	10			AWID
BELNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
BUZEI	Number of Line Item Within Accounting Document	BUZEI	NUMC	3			BUZEI	BUZ
LINETYPE	Item category	LINETYPE	CHAR	5	Assigned to domain		LINETYPE
XSPLITMOD	Item changed by document splitting	XSPLITMOD	CHAR	1			XFELD
FUND_TYPE	FM Fund Type	FM_FUNDTYPE	CHAR	6	Assigned to domain		FM_FUNDTYPE
FM_AREA	Financial Management Area	FIKRS	CHAR	4	Assigned to domain		FIKRS	FIK
MWSKZ	Tax on sales/purchases code	MWSKZ	CHAR	2	Assigned to domain		MWSKZ
XSKRL	Indicator: Line item not liable to cash discount?	XSKRL	CHAR	1			XFELD
CO_AREA	Controlling Area	KOKRS	CHAR	4	Assigned to domain		CACCD	CAC
SGL_ACCOUNT	Standard General Ledger Account for US Federal Government	FM_SGL_ACCOUNT	CHAR	6			FM_SGL_ACCOUNT	SGL_ACCOUNT	FMFG_SGL_ACCOUNT
BDGT_FUNC_CLSS	Classification of Data According to Major Purpose	FM_BDGT_FUNC_CLSS	CHAR	3			CHAR3
FMCMMTSTR_9	FM Commitment String For Budgetary Ledger	FMCMMTSTR	CHAR	62			FMCMMTSTR
TRANSFER_AGCY_9	Transfer Agency	FMFG_TRANSFER_AGCY	CHAR	2	Assigned to domain		FMFG_TRANSFER
TRANSFER_ACCT_9	Transfer Account	FMFG_TRANSFER_ACCT	CHAR	4	Assigned to domain		FMFG_TRAN_ACCT
YEAR_BDGT_AUTH_9	Year of Budget Authority	FMFG_YR_BUD_AUTH	CHAR	4			FMFG_YR_BUD_AUTH
FLG_ADVANCE_9	Advanced Flag	FM_FLG_ADVANCE	CHAR	1			FMFG_FLG_ADVANCE
DEFENSE_INDIC_9	Defense Indicator	FMFG_DEFENSE_INDICATOR	CHAR	3			FMFG_DEFENSE_INDICATOR
MEASURE	Funded Program	FM_MEASURE	CHAR	24	FMMEASURE		FM_MEASURE	FM_MEASURE
XBLNR	Reference Document Number	XBLNR1	CHAR	16			XBLNR1
LIFNR	Account Number of Vendor or Creditor	LIFNR	CHAR	10	Assigned to domain	ALPHA	LIFNR	LIF	KRED_C
KUNNR	Customer Numbers	KUNNR	CHAR	10	Assigned to domain	ALPHA	KUNNR	KUN	C_KUNNR
PROG_REPT_CAT_9	Program Reporting Category	FMFG_PROGRAM_REPORT_CATEGORY	CHAR	3			FMFG_PROGRAM_REPORT_CATEGORY
BUDGET_PD_9	FM: Budget Period	FM_BUDGET_PERIOD	CHAR	10	Assigned to domain		FM_BUDGET_PERIOD	BUDPER
ASSETMAINO_9	Main Asset Number	BF_ANLN1	CHAR	12		ALPHA	BF_ANLN1	AN1
ASSETSUBNO_9	Asset Subnumber	BF_ANLN2	CHAR	4		ALPHA	BF_ANLN2	AN2
MOVEMENTTYPE_9	Asset Transaction Type	ANBWA	CHAR	3	Assigned to domain		BWASL
ASSET_ACQDATE_9	Asset value date	BZDAT	DATS	8			DATUM
NPLNR_9	Network Number for Account Assignment	NPLNR	CHAR	12	Assigned to domain	ALPHA	AUFNR	NET
APLZL_9	Internal counter	CIM_COUNT	NUMC	8			CIM_COUNT
AUFPL_9	Routing number of operations in the order	CO_AUFPL	NUMC	10			AUFPL
PRZNR_9	Business Process	CO_PRZNR	CHAR	12	Assigned to domain	ALPHA	CO_PRZNR	KWP
IMKEY_9	Internal Key for Real Estate Object	IMKEY	CHAR	8			IMKEY
INTRENO_9	Internal Real Estate Master Data Code	VVINTRENO	CHAR	13			VVINTRENO
APPOR_CATB_DTL_9	Apportionment Category B Program Code	FMFG_APPORTDTL	CHAR	4
BDGT_IMPACT_9	Budgetary Impact	FMFG_BDGT_IMPACT	CHAR	1			FMFG_BDGT_IMPACT
FLG_PYA_9	Prior Year Adjustment Code	FMFG_FLG_PYA	CHAR	1			FMFG_FLG_PYA
PROGRAM_IND_9	Program	FMFG_PROGRAM_IND	CHAR	1			FMFG_PROGRAM_IND
TP_SUBLEVL_9	Sublevel Prefix (SP) for Trading Partner	FMFG_TP_SUBLEVL	CHAR	2			FMFG_SUBLEVL
TP_AGENCID_9	Agency Identifier (AID) for Trading Partner	FMFG_TP_AGENCID	CHAR	3			FMFG_AGENCID
TP_ALTRAID_9	Allocation Transfer Agency Identifier (ATA) Trading Partner	FMFG_TP_ALTRAID	CHAR	3			FMFG_ALTRAID
TP_BEGPER_9	Beginning Period of Availability (BPOA) for Trading Partner	FMFG_TP_BEGPER	NUMC	4		GJAHR	FMFG_BEGPER
TP_ENDPER_9	Ending Period of Availability (EPOA) for Trading Partner	FMFG_TP_ENDPER	NUMC	4		GJAHR	FMFG_ENDPER
TP_AVTYPE_9	Availability Type Code (A) for Trading Partner	FMFG_TP_AVTYPE	CHAR	1			FMFG_AVTYPE
TP_MAIN_ACCT_9	Main Account for Trading Partner	FMFG_TP_MAIN_ACCT	CHAR	4
TP_SUB_ACCT_9	Subaccount for Trading Partner	FMFG_TP_SUB_ACCT	CHAR	3
BETC_9	Business Event Type Code	FMFG_BETC	CHAR	10			CHAR10
TP_BETC_9	Business Event Type Code for Trading Partner	FMFG_TP_BETC	CHAR	10
TREASURY_OFFS_9	Treasury Offset Program Eligibility	FMFG_TREASURY_OFFSET	CHAR	1
GARNISHMENT_9	Garnishment	FMFG_GARNISHMENT	CHAR	1
SUBLEVL_9	Sublevel Prefix (SP)	FMFG_SUBLEVL	CHAR	2			FMFG_SUBLEVL
AGENCID_9	Agency Identifier (AID)	FMFG_AGENCID	CHAR	3			FMFG_AGENCID
ALTRAID_9	Allocation Transfer Agency Identifier (ATA)	FMFG_ALTRAID	CHAR	3			FMFG_ALTRAID
BEGPER_9	Beginning Period of Availability (BPOA)	FMFG_BEGPER	NUMC	4		GJAHR	FMFG_BEGPER
ENDPER_9	Ending Period of Availability (EPOA)	FMFG_ENDPER	NUMC	4		GJAHR	FMFG_ENDPER
AVTYPE_9	Availability Type Code (A)	FMFG_AVTYPE	CHAR	1			FMFG_AVTYPE
SUB_ACCT_9	Treasury Account Symbol - Subaccount	FM_SUB_ACCT	CHAR	3			FM_SUB_ACCT
ZFBDT	Baseline Date for Due Date Calculation	DZFBDT	DATS	8			DATUM
ZBD1T	Cash discount days 1	DZBD1T	DEC	3			ZBDXT
ZBD2T	Cash discount days 2	DZBD2T	DEC	3			ZBDXT
ZBD3T	Net Payment Terms Period	DZBD3T	DEC	3			ZBDXT
CHECKED	Single-Character Indicator	CHAR1	CHAR	1			CHAR1
OBJECT				0
REBZG	Number of the Invoice the Transaction Belongs to	REBZG	CHAR	10		ALPHA	BELNR
REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	REBZJ	NUMC	4		GJAHR	GJAHR
REBZZ	Line Item in the Relevant Invoice	REBZZ	NUMC	3			BUZEI
GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
VLDPTL	Offset/Clear Vendor LI with Down Payment Transfer LI	FMFG_CLR_VLI_DPTLI_IND	CHAR	1			XFELD

Key field

Non-key field

< FMFG_PPA_LOG_ATT - Activate U.S. Federal PPA message log FMFG_PP_OUTPUT_DOCUMENTS - Documents to be created >

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

As FMFG_PP_CLEAR_OPEN_ITEMS 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_PP_CLEAR_OPEN_ITEMS as there is no data to select.

How to access SAP table FMFG_PP_CLEAR_OPEN_ITEMS

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

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