FQM_FLOW - FQM Flows

FQM Flows information is stored in SAP table FQM_FLOW.
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_FLOW

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
FLOW_ID	Flow ID	X	FQM_FLOW_ID	NUMC	32
VALID_FROM	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	X	TIMESTAMPL	DEC	11
VALID_TO	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)		TIMESTAMPL	DEC	11
SOFTWARE_VERSION	Software Version		FQM_SOFTWARE_VERSION	INT4	4
FLG_ACTUAL	General Flag		FLAG	CHAR	2
TRANSACTION_ID	Transaction ID		FQM_TRANSACTION_ID	NUMC	32
PARENT_TRANSACTION_ID	Parent Transaction ID		FQM_PARENT_TRANSACTION_ID	NUMC	32
PARENT_FLOW_ID	Parent Flow ID		FQM_PARENT_FLOW_ID	NUMC	32
ROOT_ID	Flow ID		FQM_FLOW_ID	NUMC	32
DELETED	Deleted		FQM_DELETED	CHAR	2
PROCESS_STATUS	Status of a Business Transaction		FQM_PROCESS_STATUS	CHAR	2
CLEARED	Cleared		FQM_CLEARED	CHAR	2
CLEARING_FLOW_ID	Flow ID		FQM_FLOW_ID	NUMC	32
.INCLUDE	USER			FQM_USER_ATTRIBUTE	0
CREATE_USER	User Name		UNAME	CHAR	24
LAST_UPDATE_USER	User Name		UNAME	CHAR	24
CREATE_TIMESTAMP	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)		TIMESTAMPL	DEC	11
LAST_UPDATE_TIMESTAMP	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)		TIMESTAMPL	DEC	11
.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
.INCLUDE	ORIGIN_REL			FQM_ORIGIN_REL	0
.INCLU-_RL	ORIGIN_TRANS_REL			FQM_ORIGIN	0
.INCLUDE	ORIGIN_TRANS_RL			FQM_ORIGIN_TRANSACTION	0
ORIGIN_SYSTEM_RL	Logical system		LOGSYS	CHAR	20	*
ORIGIN_APPLICATION_RL	Source Application		FQM_ORIGIN_APPLICATION	CHAR	10
ORIGIN_DOCUMENT_ID_RL	Source Document ID		FQM_ORIGIN_DOC_ID	CHAR	64
ORIGIN_TRANSACTION_ID_RL	Source Transaction ID		FQM_ORIGIN_TRANS_ID	CHAR	64
ORIGIN_TRANS_QUALIFIER_RL	Source Transaction Qualifier		FQM_ORIGIN_TRANS_QUALIFIER	CHAR	6
ORIGIN_FLOW_ID_RL	Line Item in Source Document		FQM_ORIGIN_FLOW_ID	CHAR	64
CERTAINTY_LEVEL	Certainty Level		FQM_CERTAINTY_LEVEL	CHAR	12
OWNER	Owner of a Business Transaction		FQM_OWNER	CHAR	6
TRANSACTION_DATE	Transaction Date		FQM_TRANSACTION_DATE	DATS	16
TRANSACTION_CATEGORY	Transaction Category		FQM_TRANSACTION_CATEGORY	CHAR	8
FLOW_CATEGORY	Flow Category		FQM_FLOW_CAT	NUMC	12
FLOW_TYPE	Flow Type		FQM_FLOW_TYPE	CHAR	12
REL_STATUS	Release Status		FQM_RELEASE_STATUS	CHAR	2
PAYMENT_DATE	Payment Date		FQM_PAYMENT_DATE	DATS	16
PAYMENT_CURRENCY	Currency		FQM_CURRENCY	CUKY	10
DOCUMENT_DATE	Document Date		FQM_DOCUMENT_DATE	DATS	16
BASELINE_DATE	Baseline Date for Due Date Calculation		FQM_BASELINE_DATE	DATS	16
DAYS_DUE	Number of Days until Due Date		FQM_DAYS_DUE	DEC	2
CASH_DISCOUNT_DAYS1	Number of Days for Cash Discount Term 1		FQM_CASH_DISCOUNT_DAYS1	DEC	2
CASH_DISCOUNT_PERCENT1	Cash Discount (Percentage) for 1st Term		FQM_CASH_DISCOUNT_PERCENT1	DEC	3
CASH_DISCOUNT_DAYS2	Number of Days for Cash Discount Term 2		FQM_CASH_DISCOUNT_DAYS2	DEC	2
CASH_DISCOUNT_PERCENT2	Cash Discount (Percentage) for 2nd Term		FQM_CASH_DISCOUNT_PERCENT2	DEC	3
PAYMENT_METHOD	Payment Method		FQM_PAYMENT_METHOD	CHAR	2
PAYMENT_BLOCK	Payment Block		FQM_PAYMENT_BLOCK	CHAR	2
PAYMENT_MODE	Payment Mode		FQM_PAYMENT_MODE	CHAR	2
FUND	Fund		BP_GEBER	CHAR	20
GRANT_NBR	Grant		GM_GRANT_NBR	CHAR	40
.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	MM			FQM_MM_ATTRIBUTE	0
MM_ORDER_TYPE	Order Type (Purchasing)		BSART	CHAR	8	*
MM_DOCUMENT_CATEGORY	Purchasing Document Category		BSTYP	CHAR	2
MM_DOCUMENT_ITEM_CATEGORY	Item category in purchasing document		PSTYP	CHAR	2	*
MM_FINAL_INV_INDICATOR	Final Invoice Indicator		EREKZ	CHAR	2
MM_INVOICE_AMOUNT	Real Invoice Value (Purchase Order Currency = TC)		REWTW_CS	CURR	7
MM_INVOICE_BASE_AMOUNT	Real Invoice Value (Local Currency = LC)		REWHW_CS	CURR	7
.INCLUDE	LP			FQM_LP_ATTRIBUTE	0
LP_DISC_AMOUNT1	Cash Discount Amount 1		FQM_DISC_AMNT1	CURR	12
LP_DISC_AMOUNT2	Cash Discount Amount 2		FQM_DISC_AMNT2	CURR	12
LP_PLANED_PAYMENT_DATE1	Planned Payment Date1		FQM_PLAN_DATE1	DATS	16
LP_PLANED_PAYMENT_DATE2	Planned Payment Date2		FQM_PLAN_DATE2	DATS	16
.INCLUDE	QUANT			FQM_QUANTITY	0
BASE_AMOUNT	Amount		FQM_AMOUNT	CURR	12
BASE_CURRENCY	Currency		FQM_CURRENCY	CUKY	10	*
AMOUNT	Amount		FQM_AMOUNT	CURR	12
CURRENCY	Currency		FQM_CURRENCY	CUKY	10	*
QUANTITY	Quantity		FQM_QUANT	QUAN	12
UNIT_OF_MEASURE	Unit		FQM_UNIT	UNIT	6	*
.INCLUDE	ACNTAGN			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
.INCLUDE	CMM			FQM_CMM_ATTRIBUTE	0
CMM_INTEREST_RATE	Interest rate		DZINSS	DEC	4
CMM_CALENDAR_TYPE	Calendar Type		KLART_VZ	CHAR	2
CMM_STATE	State for cash memo record		FQM_CMR_STATE	CHAR	2
CMM_EXCHANGE_RATE_TYPE	Exchange Rate Type		KURST_CURR	CHAR	8	*
CMM_INVERTED_RATE_TYPE	Indicator: inverted rate entry		XKURSINV	CHAR	2
CMM_OFFSET_ACCOUNT	Offsetting account		GGRUP	CHAR	20
CMM_OFFSET_ACCID	Offsetting Bank Account Technical ID		FCLM_GACCID	NUMC	20
CMM_TRANSACTION_TYPE	Transaction type		VOART	CHAR	20
CMM_STATISTICS_INDICATOR	Statistics Indicator		STKNZ	CHAR	2
CMM_PAYMENT_GROUP	ID number for payment advice group in cash mgt and forecast		KLIDR	NUMC	20
CMM_REASON	Reason for pairing payment advices in cash mgt and forecast		KLGND	CHAR	2
CMM_AUTH_REL	Authorization and Release Flag		AUTH_REL	CHAR	16
CMM_BS_NUM_EB	Memo Record Number (Line Item Number in Bank Statement)		ESNUM_EB	NUMC	10
CMM_OFFSET_BANK_ACCOUNT_NUMBER	Bank Account Number		FCLM_BAM_ACC_NUM	CHAR	80
CMM_OFFSET_HOUSEBANK	Short Key for a House Bank		HBKID	CHAR	10	*
CMM_OFFSET_HOUSEBANKACCOUNT	ID for Account Details		HKTID	CHAR	10	*
CMM_FDES_IDENR	ID number for cash management and forecast		IDENR	NUMC	20
CMM_SDM_STATUS	Status of SDM		FCLM_SDM_STATUS	CHAR	4
CMM_ASSIGNMENT_NUMBER	Assignment Number		FDZUO	CHAR	36
CMM_PLANNING_TYPE	Planning type		DSART	CHAR	4	*
.INCLUDE	CASHREQ			FQM_CASHREQ_ATTRIBUTE	0
CASHREQUEST_ID	Cash Request ID		FQM_CASHREQ_ID	CHAR	20
CASHREQUEST_STATUS	Cash Request Status		FQM_CASHREQ_STATUS	CHAR	2
INSTRUMENT_CATEGORY	Trade Request Instrument Category		TPI_INSTRUMENT_CATEGORY	CHAR	8
FOLLOWING_CURRENCY	Following Currency		TRBA_WFWAERS	CUKY	10	*
AMOUNT_IN_FOLCUR	Amount		FQM_AMOUNT	CURR	12
BUY_SELL_INDICATOR	Buy/Sell Indicator		TPI_FX_BUY_SELL	CHAR	2
FOLLOWING_ACCOUNT	Bank Account Technical ID		FCLM_BAM_ACC_ID	NUMC	20
FLAG_DOCUMENT	Checkbox		XFELD	CHAR	2
CQ_ASSIGNMENT	Assignment		TB_ZUOND	CHAR	36
CQ_INTERNAL_REFERENCE	Internal Reference		TB_REFER	CHAR	32
CQ_CHARACTERISTICS	Characteristics		TB_MERKM	CHAR	50
FOLLOWING_COMPANYCODE	Company Code		BUKRS	CHAR	8
FOLLOWING_BANKDETAIL	Bank Details ID		BU_BKVID	CHAR	8
FOLLOWING_HOUSEBANK	Short Key for a House Bank		HBKID	CHAR	10	*
FOLLOWING_HOUSEBANKACCOUNT	ID for Account Details		HKTID	CHAR	10	*
MMK_TERM_FROM_DATE	Value date		VALUT	DATS	16
MMK_TERM_TO_DATE	Value date		VALUT	DATS	16
MMK_INVEST_BORROW	Invest or Borrow		FCLM_MMR_INVEST_BORROW	CHAR	12
MMK_MAX_TERM_FROM_DATE	Value date		VALUT	DATS	16
MMK_MAX_TERM_TO_DATE	Value date		VALUT	DATS	16
MMK_OFFSET_FLAG	Offsetting Flag		FCLM_MMR_OFFSET	CHAR	2
CASHREQUEST_SUBIMITTED_BY	Submitted By		FCLM_SUBMITTED_BY	CHAR	24
.INCLUDE	MMR			FQM_MMKTREQ_ATTRIBUTE	0
TERM_FROM_DATE	Value date		VALUT	DATS	16
TERM_TO_DATE	Value date		VALUT	DATS	16
AMOUNT_REQUESTED	Amount		FQM_AMOUNT	CURR	12
CURRENCY_REQUESTED	Currency		FQM_CURRENCY	CUKY	10	*
INVEST_BORROW	Invest or Borrow		FCLM_MMR_INVEST_BORROW	CHAR	12
MAX_TERM_FROM_DATE	Value date		VALUT	DATS	16
MAX_TERM_TO_DATE	Value date		VALUT	DATS	16
.INCLUDE	FCA			FQM_FICA_ATTRIBUTE	0
FCA_BP	Business Partner Number		GPART_KK	CHAR	20	BUT000
FCA_ACCOUNT_NUMBER	Contract Account Number		VKONT_KK	CHAR	24	FKKVKP
FCA_DOC_NUMBER	Number of a FI-CA Document		OPBEL_KK	CHAR	24	DFKKKO
FCA_DOCITEM_NUMBER	Item Number in FI-CA Document		OPUPK_KK	NUMC	8
FCA_CLEARING_REASON	Clearing Reason		AUGRD_KK	CHAR	4	TFK001A
FCA_ORIGIN_KEY	Document Origin Key		HERKF_KK	CHAR	4	TFK001
FCA_BT_CATEGORY	Business Transaction Category		FINS_BTTYPE	CHAR	8	*
FCA_TAX_AMT	Tax Amount in Document Currency		FWSTE	CURR	12
LTYPE	Link Type		FQM_LINKTYPE	CHAR	4
LNKID	Link ID		FQM_LINKID	CHAR	64