SAP FMCJ IS-PS: Documents in Cash Desk Subsidiary Ledger Table data and field list

FMCJ is a standard SAP Table which is used to store IS-PS: Documents in Cash Desk Subsidiary Ledger data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMCJ table consists of various fields, each holding specific information or linking keys about IS-PS: Documents in Cash Desk Subsidiary Ledger data available in SAP. These include BUKRS (Company code), BELNR (IS-PS: Document number for cash desk subsidiary ledger), GJAHR (Fiscal year), ERNAM (Name of Person who Created the Object)... 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. .

FMCJ 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: Cannot Be Enhanced

SAP FMCJ 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 FMCJ 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
MANDT	Client	MANDT	CLNT	3	T000		MANDT
BUKRS	Company code	FM_BUKRS	CHAR	4	T001		BUKRS	BUK	H_T001
BELNR	IS-PS: Document number for cash desk subsidiary ledger	BELNR_FM	CHAR	10		ALPHA	BELNR	BLN
GJAHR	Fiscal year	FM_GJAHR	NUMC	4		GJAHR	GJAHR	GJR
ERNAM	Name of Person who Created the Object	ERNAM	CHAR	12			USNAM
CPUDT	Day On Which Accounting Document Was Entered	CPUDT	DATS	8			DATUM
CPUTM	Time of Entry	CPUTM	TIMS	6			UZEIT
BUDAT	Posting Date in the Document	BUDAT	DATS	8			DATUM
BUVRG	Payment Transaction in Cash Desk Subledger	FM_BUVRG	CHAR	10	FMPY		FM_BUVRG
BUSOH	In/out Payment Ind. for Cash Desk Subledger	FM_BUSOH	CHAR	1			FM_SHKZG
DMBTR	Amount in Local Currency	FM_DMBTR	CURR	15(2)			WERTV8
WRBTR	Amount in Document Currency	WRBTR_FM	CURR	15(2)			WERTV8
WAERS	Currency Key	WAERS	CUKY	5	TCURC		WAERS	FWS
HWAER	Local Currency	HWAER	CUKY	5	Assigned to domain		WAERS
KUNNR	Customer Numbers	KUNNR	CHAR	10	KNB1	ALPHA	KUNNR	KUN	C_KUNNR
LIFNR	Account Number of Vendor or Creditor	LIFNR	CHAR	10	LFB1	ALPHA	LIFNR	LIF	KRED_C
SAKNR	G/L Account Number	SAKNR	CHAR	10	SKB1	ALPHA	SAKNR	SAK	C_SAKNR
FIPEX	Commitment Item	FM_FIPEX	CHAR	24	Assigned to domain		FM_FIPEX	FPS
FICTR	Funds Center	FISTL	CHAR	16	Assigned to domain		FISTL	FIS
FUND	Fund	BP_GEBER	CHAR	10	FMFINCODE		BP_GEBER	FIC
BUDGET_PD	FM: Budget Period	FM_BUDGET_PERIOD	CHAR	10	Assigned to domain		FM_BUDGET_PERIOD	BUDPER
PSOEA	Revnue Type	PSOEA	CHAR	8	PSO04		PSOEA
KBLNR	Document Number for Earmarked Funds	KBLNR_FI	CHAR	10	KBLK	ALPHA	KBLNR	KBL
KBLPOS	Earmarked Funds: Document Item	KBLPOS	NUMC	3	KBLP		KBLPOS	KBP
XBLNR	Reference Document Number	XBLNR1	CHAR	16			XBLNR1
SGTXT	Item Text	SGTXT	CHAR	50			TEXT50
KVERM	Account Memo	FM_KVERM	CHAR	50			TEXT50
STBLG	Reverse Document Number	STBLG	CHAR	10		ALPHA	BELNR
XSTBLG	Indicator for Reverse Document	XSTBLG	CHAR	1			XFELD
BELST	IS-PS: Document status in cash desk subsidiary ledger	FM_BELST	CHAR	1			FM_BELST
KABLG	Cash Desk Closing in Cash Desk Subledger	FM_KABLG	CHAR	1			FM_KABLG
ERZPT		FM_ERZPT	CHAR	20			CHAR20
FI_BELNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
FI_BUZEI	Number of Line Item Within Accounting Document	BUZEI	NUMC	3			BUZEI	BUZ
FI_BUKRS	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
FI_GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
FI_UMSKZ	Special G/L Indicator	UMSKZ	CHAR	1	Assigned to domain		UMSKZ
FI_REBZG	Number of the Invoice the Transaction Belongs to	REBZG	CHAR	10		ALPHA	BELNR
FI_REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	REBZJ	NUMC	4		GJAHR	GJAHR
FI_REBZZ	Line Item in the Relevant Invoice	REBZZ	NUMC	3			BUZEI

Key field

Non-key field

< FMCI_EXT - Country-Specific Enhancement for Commitment Item FMCJD - Screen Fields for FMCABK >

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

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

SELECT SINGLE *
FROM FMCJ
INTO CORRESPONDING FIELDS OF WA_FMCJ
WHERE...

How to access SAP table FMCJ

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

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