FQM_MNE_BAL - FQM Flows

FQM Flows information is stored in SAP table FQM_MNE_BAL.
It is part of development package FQM in software component FIN-FSCM-FQM. This development package consists of objects that can be grouped under "Financial Quantity Management".

Fields for table FQM_MNE_BAL

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
TRANSACTION_ID	Transaction ID	X	FQM_TRANSACTION_ID	NUMC	32
.INCLUDE	ORIGIN			FQM_ORIGIN	0
.INCLUDE	ORIGIN_TRANS			FQM_ORIGIN_TRANSACTION	0
ORIGIN_SYSTEM	Logical system		LOGSYS	CHAR	20	*
ORIGIN_APPLICATION	Source Application		FQM_ORIGIN_APPLICATION	CHAR	10
ORIGIN_DOCUMENT_ID	Source Document ID		FQM_ORIGIN_DOC_ID	CHAR	64
ORIGIN_TRANSACTION_ID	Source Transaction ID		FQM_ORIGIN_TRANS_ID	CHAR	64
ORIGIN_TRANS_QUALIFIER	Source Transaction Qualifier		FQM_ORIGIN_TRANS_QUALIFIER	CHAR	6
ORIGIN_FLOW_ID	Line Item in Source Document		FQM_ORIGIN_FLOW_ID	CHAR	64
TRANSACTION_DATE	Transaction Date		FQM_TRANSACTION_DATE	DATS	16
.INCLUDE	FI			FQM_FI_ATTRIBUTE	0
FI_DOCUMENT_NUMBER	Document Number of an Accounting Document		BELNR_D	CHAR	20
FI_DOCUMENT_LINE_ITEM	Number of Line Item Within Accounting Document		BUZEI	NUMC	6
FI_FISCAL_YEAR	Fiscal Year		GJAHR	NUMC	8
FI_FISCAL_PERIOD	Fiscal period		MONAT	NUMC	4
FI_CREDIT_DEBIT_INDICATOR	Debit/Credit Indicator		SHKZG	CHAR	2
FI_INVOICE_REFERENCE	Document No. of the Invoice to Which the Transaction Belongs		REBZG	CHAR	20
FI_INVOICE_FISCAL_YEAR_REF	Fiscal Year of the Relevant Invoice (for Credit Memo)		REBZJ	NUMC	8
FI_INVOICE_ITEM_REF	Line Item in the Relevant Invoice		REBZZ	NUMC	6
FI_CLEARING_DOCUMENT	Document Number of the Clearing Document		AUGBL	CHAR	20
FI_CLEARING_ITEM	Clearing Item		AGZEI	DEC	3
FI_CLEARING_TYPE	Type of Clearing in Table AUSZ_CLR		CLRINF	CHAR	2
FI_POST_DATE	Posting Date in the Document		BUDAT	DATS	16
FI_BASELINE_DATE	Baseline Date for Due Date Calculation		DZFBDT	DATS	16
FI_DOCUMENT_TYPE	Document Type		BLART	CHAR	4	*
FI_ACCOUNT_TYPE	Account type		KOART	CHAR	2
FI_ACCOUNT	General Ledger Account		HKONT	CHAR	20	*
FI_VALUE_DATE	Value date		VALUT	DATS	16
FI_DUE_DATE	Net Due Date		FQM_DUE_DATE	DATS	16
FI_CLEARING_DATE	Clearing Date		AUGDT	DATS	16
FI_PURCHSE_DOCUMENT_NUMBER	Purchasing Document Number		EBELN	CHAR	20
FI_PURCHSE_LINE_ITEM	Item Number of Purchasing Document		EBELP	NUMC	10	*
FI_SEQUENTIAL_NUMBER	Sequential Number of Account Assignment		DZEKKN	NUMC	4
FI_REVERSE_DOCUMENT_NUMBER	Reverse Document Number		STBLG	CHAR	20
FI_ITEM_TEXT	Item Text		SGTXT	CHAR	100
FI_ENTRY_DATE	Day On Which Accounting Document Was Entered		CPUDT	DATS	16
FI_ENTRY_TIME	Time of Entry		CPUTM	TIMS	12
FI_PAYMENT_TERM	Net Payment Terms Period		DZBD3T	DEC	2
.INCLUDE				FQM_ACCOUNT_ASSIGNMENT	0
.INCLUDE	TRM			FQM_TRM_ACCOUNT_ASSIGNMENT	0
TRM_PRODUCT_TYPE	Product Type		VVSART	CHAR	6
TRM_TRANSACTION_TYPE	Financial Transaction Type		TB_SFHAART	CHAR	6
TRM_ACTIVITY_CATEGORY	Transaction Activity Category		TB_SFGZUTY	NUMC	4
TRM_SECURITY_ID	Security Class ID Number		VVRANLW	CHAR	26
TRM_SECURITY_ACCOUNT	Securities Account		RLDEPO	CHAR	20
TRM_PORTFOLIO	Portfolio		RPORTB	CHAR	20
.INCLUDE	CASH			FQM_CASH_ACCOUNT_ASSIGNMENT	0
HOUSE_BANK	Short Key for a House Bank		HBKID	CHAR	10	*
HOUSE_BANK_ACCOUNT	ID for Account Details		HKTID	CHAR	10	*
BANK_ACCOUNT_ID	Bank Account Technical ID		FCLM_BAM_ACC_ID	NUMC	20
COMPANY_CODE	Company Code		BUKRS	CHAR	8
CUSTOMER_NUMBER	Customer Number		KUNNR	CHAR	20
VENDOR_NUMBER	Account Number of Supplier		LIFNR	CHAR	20
PARTNER	Business Partner Number		BU_PARTNER	CHAR	20
MATERIAL	Material Number		MATNR	CHAR	80
BUSINESS_AREA	Business Area		GSBER	CHAR	8	*
PROFIT_CENTER	Profit Center		PRCTR	CHAR	20	*
PROJECT	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16	*
COST_CENTER	Cost Center		KOSTL	CHAR	20	*
TRADING_PARTNER	Company ID of Trading Partner		RASSC	CHAR	12	*
LIQUIDITY_ITEM	Liquidity Item		FLQPOS	CHAR	32	*
SEGMENT	Segment for Segmental Reporting		FB_SEGMENT	CHAR	20	*
PLANNING_LEVEL	Planning Level		FDLEV	CHAR	4	*
PLANNING_GROUP	Planning Group		FDGRP	CHAR	20	*
CONTRACT_NUMBER	Contract Number		VERTNR	CHAR	26
CONTRACT_TYPE	Contract Type		RANTYP	CHAR	2
ASSIGNED_COMPANY_CODE	Company Code		BUKRS	CHAR	8
INTERNAL_REFERENCE	Internal Reference		TB_REFER	CHAR	32
CHARACTERISTICS	Characteristics		TB_MERKM	CHAR	50
ASSIGNMENT	Assignment		TB_ZUOND	CHAR	36