SAP FMTC_SCHNO Treasury Confirmation Schedule No status Table data and field list

FMTC_SCHNO is a standard SAP Table which is used to store Treasury Confirmation Schedule No status data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMTC_SCHNO table consists of various fields, each holding specific information or linking keys about Treasury Confirmation Schedule No status data available in SAP. These include SCHEDULENO (Payment Schedule Number), LAUFD (Date on Which the Program Is to Be Run), LAUFI (Additional Identification), RZAWE (Payment Method for This Payment)... 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. .

FMTC_SCHNO 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 FMTC_SCHNO 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 FMTC_SCHNO 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	Assigned to domain		MANDT
SCHEDULENO	Payment Schedule Number	FMFG_SCHEDNO	CHAR	11			CHAR11		FMFG_SCHEDULENO
LAUFD	Date on Which the Program Is to Be Run	LAUFD	DATS	8			DATUM
LAUFI	Additional Identification	LAUFI	CHAR	6			LAUFI
RZAWE	Payment Method for This Payment	RZAWE	CHAR	1	Assigned to domain		ZLSCH
ALC	Agency Location Code	FMFG_ALC	CHAR	8	FMFGT_ALC		FMFG_ALC	FMFG_ALC
PMT_OFFICE	Payment Office	FMFG_PMT_OFF	CHAR	5	FMFGT_PO		FMFG_PMT_OFF	FMFG_PMT_OFFICE
FILE_NBR	Key for multiple files from single Payment Program Print	FMFG_FILE_NO	NUMC	6
CONFD	Confirmation Date	FMFG_CONFD	DATS	8
POSTD	Posting Date in the Document	BUDAT	DATS	8			DATUM
AZNUM	Statement number	AZNUM_EB	NUMC	5			NUM5
CHKRG	Multiple Check Ranges Indication of US Federla TC	CHKRG	CHAR	1			CHKRG
CHECF	Check Number From	CHECF	CHAR	13			CHCKN	CHK
CHECT	Check number	CHECT	CHAR	13			CHCKN	CHK
AMOUNT	Amount in Local Currency	RBETR	CURR	13(2)			WRTV7
STATUS	Payment Schedule Status	FMFG_SCH_STATUS	CHAR	1			FMFG_SCH_STATUS
CONTROLNO	SPS Control Number rec'd from Treasury	FMFG_CONTROLNO	CHAR	7			CHAR7

Key field

Non-key field

< FMTC_RFC - Table for Treasury Regional Financial Center FMTC_SCHTOT - Limit Treasury Schedules >

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

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

SELECT SINGLE *
FROM FMTC_SCHNO
INTO CORRESPONDING FIELDS OF WA_FMTC_SCHNO
WHERE...

How to access SAP table FMTC_SCHNO

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

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