FQM_FLOW

FQM Flows | #transactional | Component: One Exposure
Column Name Description
MANDT Client
FLOW_ID Flow ID
VALID_FROM UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
Column Name Description
💲 Currency (CURRENCY):
MM_INVOICE_AMOUNT Real Invoice Value (Purchase Order Currency = TC)
LP_DISC_AMOUNT1 Cash Discount Amount 1
LP_DISC_AMOUNT2 Cash Discount Amount 2
AMOUNT Amount
FCA_TAX_AMT Tax Amount in Document Currency
💲 Currency (BASE_CURRENCY):
MM_INVOICE_BASE_AMOUNT Real Invoice Value (Local Currency = LC)
BASE_AMOUNT Amount
💲 Following Currency (FOLLOWING_CURRENCY):
AMOUNT_IN_FOLCUR Amount
💲 Currency (CURRENCY_REQUESTED):
AMOUNT_REQUESTED Amount
Column Name Description
📏 Unit (UNIT_OF_MEASURE):
QUANTITY Quantity
Column Name Description
TRANSACTION_DATE Transaction Date
PAYMENT_DATE Payment Date
DOCUMENT_DATE Document Date
BASELINE_DATE Baseline Date for Due Date Calculation
FI_POST_DATE Posting Date in the Document
FI_BASELINE_DATE Baseline Date for Due Date Calculation
FI_VALUE_DATE Value date
FI_DUE_DATE Net Due Date
FI_CLEARING_DATE Clearing Date
FI_ENTRY_DATE Day On Which Accounting Document Was Entered
FI_ENTRY_TIME Time of Entry
LP_PLANED_PAYMENT_DATE1 Planned Payment Date1
LP_PLANED_PAYMENT_DATE2 Planned Payment Date2
MMK_TERM_FROM_DATE Value date
MMK_TERM_TO_DATE Value date
MMK_MAX_TERM_FROM_DATE Value date
MMK_MAX_TERM_TO_DATE Value date
TERM_FROM_DATE Value date
TERM_TO_DATE Value date
MAX_TERM_FROM_DATE Value date
MAX_TERM_TO_DATE Value date
Column Name Description
SOFTWARE_VERSION Software Version Show values
FLG_ACTUAL General Flag Show values
DELETED Deleted Show values
PROCESS_STATUS Status of a Business Transaction Show values
CLEARED Cleared Show values
ORIGIN_APPLICATION Source Application Show values
ORIGIN_APPLICATION_RL Source Application Show values
CERTAINTY_LEVEL Certainty Level Show values
TRANSACTION_CATEGORY Transaction Category Show values
REL_STATUS Release Status Show values
PAYMENT_MODE Payment Mode Show values
FI_CREDIT_DEBIT_INDICATOR Debit/Credit Indicator Show values
FI_CLEARING_TYPE Type of Clearing in Table AUSZ_CLR Show values
FI_ACCOUNT_TYPE Account type Show values
MM_DOCUMENT_CATEGORY Purchasing Document Category Show values
MM_FINAL_INV_INDICATOR Final Invoice Indicator Show values
CONTRACT_TYPE Contract Type Show values
CMM_CALENDAR_TYPE Calendar Type Show values
CMM_STATE State for cash memo record Show values
CMM_INVERTED_RATE_TYPE Indicator: inverted rate entry Show values
CMM_STATISTICS_INDICATOR Statistics Indicator Show values
CMM_REASON Reason for pairing payment advices in cash mgt and forecast Show values
CMM_SDM_STATUS Status of SDM Show values
CASHREQUEST_STATUS Cash Request Status Show values
INSTRUMENT_CATEGORY Trade Request Instrument Category Show values
BUY_SELL_INDICATOR Buy/Sell Indicator Show values
FLAG_DOCUMENT Checkbox Show values
MMK_INVEST_BORROW Invest or Borrow Show values
INVEST_BORROW Invest or Borrow Show values
LTYPE Link Type Show values
Column Name Description Domain name
VALID_TO UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
TRANSACTION_ID Transaction ID FQM_ID
PARENT_TRANSACTION_ID Parent Transaction ID FQM_ID
PARENT_FLOW_ID Parent Flow ID FQM_ID
ROOT_ID Flow ID FQM_ID
CLEARING_FLOW_ID Flow ID FQM_ID
CREATE_USER User Name UNAME
LAST_UPDATE_USER User Name UNAME
CREATE_TIMESTAMP UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
LAST_UPDATE_TIMESTAMP UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
ORIGIN_SYSTEM Logical system LOGSYS
ORIGIN_DOCUMENT_ID Source Document ID FQM_ORIGIN_DOC_ID
ORIGIN_TRANSACTION_ID Source Transaction ID FQM_ORIGIN_TRANS_ID
ORIGIN_TRANS_QUALIFIER Source Transaction Qualifier FQM_ORIGIN_TRANS_QUALIFIER
ORIGIN_FLOW_ID Line Item in Source Document FQM_ORIGIN_FLOW_ID
ORIGIN_SYSTEM_RL Logical system LOGSYS
ORIGIN_DOCUMENT_ID_RL Source Document ID FQM_ORIGIN_DOC_ID
ORIGIN_TRANSACTION_ID_RL Source Transaction ID FQM_ORIGIN_TRANS_ID
ORIGIN_TRANS_QUALIFIER_RL Source Transaction Qualifier FQM_ORIGIN_TRANS_QUALIFIER
ORIGIN_FLOW_ID_RL Line Item in Source Document FQM_ORIGIN_FLOW_ID
OWNER Owner of a Business Transaction FQM_OWNER
FLOW_CATEGORY Flow Category FQM_FLOW_CATEGORY
FLOW_TYPE Flow Type FQM_FLOW_TYPE
DAYS_DUE Number of Days until Due Date ZBDXT
CASH_DISCOUNT_DAYS1 Number of Days for Cash Discount Term 1 ZBDXT
CASH_DISCOUNT_PERCENT1 Cash Discount (Percentage) for 1st Term PRZ23
CASH_DISCOUNT_DAYS2 Number of Days for Cash Discount Term 2 ZBDXT
CASH_DISCOUNT_PERCENT2 Cash Discount (Percentage) for 2nd Term PRZ23
PAYMENT_METHOD Payment Method ZLSCH
PAYMENT_BLOCK Payment Block ZLSPR
FUND Fund BP_GEBER
GRANT_NBR Grant GM_GRANT_NBR
FI_DOCUMENT_NUMBER Document Number of an Accounting Document BELNR
FI_DOCUMENT_LINE_ITEM Number of Line Item Within Accounting Document BUZEI
FI_FISCAL_YEAR Fiscal Year GJAHR
FI_FISCAL_PERIOD Fiscal period MONAT
FI_INVOICE_REFERENCE Document No. of the Invoice to Which the Transaction Belongs BELNR
FI_INVOICE_FISCAL_YEAR_REF Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR
FI_INVOICE_ITEM_REF Line Item in the Relevant Invoice BUZEI
FI_CLEARING_DOCUMENT Document Number of the Clearing Document BELNR
FI_CLEARING_ITEM Clearing Item AGZEI
FI_DOCUMENT_TYPE Document Type BLART
FI_ACCOUNT General Ledger Account SAKNR
FI_PURCHSE_DOCUMENT_NUMBER Purchasing Document Number EBELN
FI_PURCHSE_LINE_ITEM Item Number of Purchasing Document EBELP
FI_SEQUENTIAL_NUMBER Sequential Number of Account Assignment NUM02
FI_REVERSE_DOCUMENT_NUMBER Reverse Document Number BELNR
FI_ITEM_TEXT Item Text TEXT50
FI_PAYMENT_TERM Net Payment Terms Period ZBDXT
MM_ORDER_TYPE Order Type (Purchasing) BSART
MM_DOCUMENT_ITEM_CATEGORY Item category in purchasing document PSTYP
TRM_PRODUCT_TYPE Product Type VVSART
TRM_TRANSACTION_TYPE Financial Transaction Type T_SFHAART
TRM_ACTIVITY_CATEGORY Transaction Activity Category T_SFGZUTY
TRM_SECURITY_ID Security Class ID Number WP_RANL
TRM_SECURITY_ACCOUNT Securities Account RLDEPO
TRM_PORTFOLIO Portfolio RPORTB
HOUSE_BANK Short Key for a House Bank HBKID
HOUSE_BANK_ACCOUNT ID for Account Details HKTID
BANK_ACCOUNT_ID Bank Account Technical ID NUM10
COMPANY_CODE Company Code BUKRS
CUSTOMER_NUMBER Customer Number KUNNR
VENDOR_NUMBER Account Number of Supplier LIFNR
PARTNER Business Partner Number BU_PARTNER
MATERIAL Material Number MATNR
BUSINESS_AREA Business Area GSBER
PROFIT_CENTER Profit Center PRCTR
PROJECT Work Breakdown Structure Element (WBS Element) PS_POSNR
COST_CENTER Cost Center KOSTL
TRADING_PARTNER Company ID of Trading Partner RCOMP
LIQUIDITY_ITEM Liquidity Item FLQPOS
SEGMENT Segment for Segmental Reporting FB_SEGMENT
PLANNING_LEVEL Planning Level FDLEV
PLANNING_GROUP Planning Group FDGRP
CONTRACT_NUMBER Contract Number CHAR13
ASSIGNED_COMPANY_CODE Company Code BUKRS
INTERNAL_REFERENCE Internal Reference CHAR16
CHARACTERISTICS Characteristics CHAR25
ASSIGNMENT Assignment TEXT18
CMM_INTEREST_RATE Interest rate PRZ43
CMM_EXCHANGE_RATE_TYPE Exchange Rate Type KURST
CMM_OFFSET_ACCOUNT Offsetting account GRUPP
CMM_OFFSET_ACCID Offsetting Bank Account Technical ID NUM10
CMM_TRANSACTION_TYPE Transaction type VOART
CMM_PAYMENT_GROUP ID number for payment advice group in cash mgt and forecast IDENR
CMM_AUTH_REL Authorization and Release Flag CHAR8
CMM_BS_NUM_EB Memo Record Number (Line Item Number in Bank Statement) NUM5
CMM_OFFSET_BANK_ACCOUNT_NUMBER Bank Account Number FCLM_BAM_ACC_NUM
CMM_OFFSET_HOUSEBANK Short Key for a House Bank HBKID
CMM_OFFSET_HOUSEBANKACCOUNT ID for Account Details HKTID
CMM_FDES_IDENR ID number for cash management and forecast IDENR
CMM_ASSIGNMENT_NUMBER Assignment Number ZUONR
CMM_PLANNING_TYPE Planning type DSART
CASHREQUEST_ID Cash Request ID FQM_CASHREQ_ID
FOLLOWING_ACCOUNT Bank Account Technical ID NUM10
CQ_ASSIGNMENT Assignment TEXT18
CQ_INTERNAL_REFERENCE Internal Reference CHAR16
CQ_CHARACTERISTICS Characteristics CHAR25
FOLLOWING_COMPANYCODE Company Code BUKRS
FOLLOWING_BANKDETAIL Bank Details ID CHAR4
FOLLOWING_HOUSEBANK Short Key for a House Bank HBKID
FOLLOWING_HOUSEBANKACCOUNT ID for Account Details HKTID
MMK_OFFSET_FLAG Offsetting Flag
CASHREQUEST_SUBIMITTED_BY Submitted By UNAME
FCA_DOCITEM_NUMBER Item Number in FI-CA Document OPUPK_KK
FCA_BT_CATEGORY Business Transaction Category FINS_BTTYPE
LNKID Link ID CHAR32
Master Data Relations Join Conditions
Contract Account Number
  • Contract Account Number
  • Business Partner Number
  • Client
  • FQM_FLOW.FCA_ACCOUNT_NUMBER == FKKVKP.VKONT
  • FQM_FLOW.FCA_BP == FKKVKP.GPART
  • FQM_FLOW.MANDT == FKKVKP.MANDT
Business Partner Number
  • Business Partner Number
  • Client
  • FQM_FLOW.FCA_BP == BUT000.PARTNER
  • FQM_FLOW.MANDT == BUT000.CLIENT
Clearing Reason FQM_FLOW.FCA_CLEARING_REASON == TFK001A.AUGRD
Document Origin Key FQM_FLOW.FCA_ORIGIN_KEY == TFK001.HERKF