FQM_FLOW
FQM Flows
FQM_FLOW is an SAP database table in S/4HANA. FQM Flows. It contains 199 fields. 21 CDS views read from this table.
CDS Views using this table (21)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_CashFlow | view_entity | from | EXTENSION | Cash Flow - Extension |
| FQM_FLOW_KEYFIGURE_CDS | view | from | ||
| I_CashFlowDeltaData | view | from | BASIC | Delta Extraction Cash FLow |
| I_MemoRecord | view | from | BASIC | Basic View for Memo Record |
| I_MemoRecordBase | view | from | BASIC | the basic view for Memo Record |
| P_Fa_Flowitem | view | from | BASIC | |
| P_Fqmflow | view | from | BASIC | |
| P_Fqmflow_CSH | view | from | BASIC | |
| P_FQMFLOWACTUALCASH | view | from | BASIC | |
| P_FqmflowCASH | view | from | BASIC | |
| P_FQMFLOWCASHPOS | view | from | BASIC | |
| P_FqmflowDetails | view | from | BASIC | |
| P_FqmflowP | view | from | BASIC | |
| P_FqmFlowScope | view | from | BASIC | Cash Flow with Scope |
| P_FqmflowTRMMM | view | from | BASIC | |
| P_RECNCLN_ACCID | view | inner | BASIC | |
| P_RecnclnRsltComprn | view | from | BASIC | |
| V_CMMRD | view | from | Memo Record with Versioning | |
| VFCP_DDL_FQM_FLOW | view | from | ||
| VFCP_DDL_TRM | view | from | ||
| VFCP_DDL_TRM_BASE | view | from |
Fields (199)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | flow_id | FQM_FLOW_ID | Flow ID | |||
| KEY | valid_from | FQM_VALID_FROM | FQM Flow Valid From | |||
| valid_to | FQM_VALID_TO | FQM Flow Valid To | ||||
| software_version | FQM_SOFTWARE_VERSION | Software Version | ||||
| flg_actual | FQM_FLG_ACTUAL | FQM Flag Actual | ||||
| transaction_id | FQM_TRANSACTION_ID | Transaction ID | ||||
| parent_transaction_id | FQM_PARENT_TRANSACTION_ID | Par. Trans. ID | ||||
| parent_flow_id | FQM_PARENT_FLOW_ID | Par. Flow ID | ||||
| root_id | FQM_FLOW_ID | Flow ID | ||||
| deleted | FQM_DELETED | Deleted | ||||
| process_status | FQM_PROCESS_STATUS | Status | ||||
| cleared | FQM_CLEARED | Cleared | ||||
| clearing_flow_id | FQM_FLOW_ID | Flow ID | ||||
| create_user | FQM_CREATE_USER | Fqm Create User | ||||
| last_update_user | FQM_UPDATE_USER | Fqm Last Update User | ||||
| create_timestamp | FQM_CREATE_TIMESTAMP | FQM Flow Created At | ||||
| last_update_timestamp | FQM_UPDATE_TIMESTAMP | FQM Flow Update Time | ||||
| origin_system | LOGSYS | Logical system | ||||
| origin_application | FQM_ORIGIN_APPLICATION | Source Application | ||||
| origin_document_id | FQM_ORIGIN_DOC_ID | Source Doc. ID | ||||
| origin_transaction_id | FQM_ORIGIN_TRANS_ID | Source Trans. ID | ||||
| origin_trans_qualifier | FQM_ORIGIN_TRANS_QUALIFIER | Trans. Qualifier | ||||
| origin_flow_id | FQM_ORIGIN_FLOW_ID | Source Flow ID | ||||
| origin_system_rl | LOGSYS | Logical system | ||||
| origin_application_rl | FQM_ORIGIN_APPLICATION | Source Application | ||||
| origin_document_id_rl | FQM_ORIGIN_DOC_ID | Source Doc. ID | ||||
| origin_transaction_id_rl | FQM_ORIGIN_TRANS_ID | Source Trans. ID | ||||
| origin_trans_qualifier_rl | FQM_ORIGIN_TRANS_QUALIFIER | Trans. Qualifier | ||||
| origin_flow_id_rl | FQM_ORIGIN_FLOW_ID | Source Flow ID | ||||
| certainty_level | FQM_CERTAINTY_LEVEL | Certainty Level | ||||
| owner | FQM_OWNER | Trans. Owner | ||||
| transaction_date | FQM_TRANSACTION_DATE | Transaction Date | ||||
| transaction_category | FQM_TRANSACTION_CATEGORY | Transaction Category | ||||
| flow_category | FQM_FLOW_CAT | Flow Category | ||||
| flow_type | FQM_FLOW_TYPE | Flow Type | ||||
| rel_status | FQM_RELEASE_STATUS | Release Status | ||||
| payment_date | FQM_PAYMENT_DATE | Payment Date | ||||
| payment_currency | FQM_CURRENCY | Currency | ||||
| document_date | FQM_DOCUMENT_DATE | Document Date | ||||
| baseline_date | FQM_BASELINE_DATE | Baseline Date | ||||
| days_due | FQM_DAYS_DUE | Days until Due | ||||
| cash_discount_days1 | FQM_CASH_DISCOUNT_DAYS1 | Days Term 1 | ||||
| cash_discount_percent1 | FQM_CASH_DISCOUNT_PERCENT1 | Percent 1st Term | ||||
| cash_discount_days2 | FQM_CASH_DISCOUNT_DAYS2 | Days Term 2 | ||||
| cash_discount_percent2 | FQM_CASH_DISCOUNT_PERCENT2 | Percent 2nd Term | ||||
| payment_method | FQM_PAYMENT_METHOD | Payment Method | ||||
| payment_block | FQM_PAYMENT_BLOCK | Payment Block | ||||
| payment_mode | FQM_PAYMENT_MODE | Payment Mode | ||||
| fund | BP_GEBER | Fund | ||||
| grant_nbr | GM_GRANT_NBR | Grant | ||||
| fi_document_number | BELNR_D | Document Number | ||||
| fi_document_line_item | BUZEI | Item | ||||
| fi_fiscal_year | GJAHR | Fiscal Year | ||||
| fi_fiscal_period | MONAT | Period | ||||
| fi_credit_debit_indicator | SHKZG | Debit/Credit | ||||
| fi_invoice_reference | REBZG | Invoice Ref. | ||||
| fi_invoice_fiscal_year_ref | REBZJ | Fiscal Year | ||||
| fi_invoice_item_ref | REBZZ | Item | ||||
| fi_clearing_document | AUGBL | Clrng doc. | ||||
| fi_clearing_item | AGZEI | Clearing Item | ||||
| fi_clearing_type | CLRINF | Type of Clearing in Table AUSZ_CLR | ||||
| fi_post_date | BUDAT | Posting Date | ||||
| fi_baseline_date | DZFBDT | Baseline Date | ||||
| fi_document_type | BLART | Document Type | ||||
| fi_account_type | KOART | Account type | ||||
| fi_account | HKONT | G/L Acct | ||||
| fi_value_date | VALUT | Value date | ||||
| fi_due_date | FQM_DUE_DATE | Due Date | ||||
| fi_clearing_date | AUGDT | Clearing | ||||
| fi_purchse_document_number | EBELN | Purchasing Doc. | ||||
| fi_purchse_line_item | EBELP | Item | ||||
| fi_sequential_number | DZEKKN | Account Assgmt No. | ||||
| fi_reverse_document_number | STBLG | Reversed With | ||||
| fi_item_text | SGTXT | Text | ||||
| fi_entry_date | CPUDT | Entered On | ||||
| fi_entry_time | CPUTM | Entered at | ||||
| fi_payment_term | DZBD3T | Days Net | ||||
| mm_order_type | BSART | Order Type | ||||
| mm_document_category | BSTYP | Doc. Category | ||||
| mm_document_item_category | PSTYP | Item Category | ||||
| mm_final_inv_indicator | EREKZ | Final Invoice | ||||
| mm_invoice_amount | REWTW_CS | InvoiceValue/TC | ||||
| mm_invoice_base_amount | REWHW_CS | Invoice Valu/LC | ||||
| lp_disc_amount1 | FQM_DISC_AMNT1 | Discount Amnt1 | ||||
| lp_disc_amount2 | FQM_DISC_AMNT2 | Discount Amnt2 | ||||
| lp_planed_payment_date1 | FQM_PLAN_DATE1 | Plan. Pymt Date1 | ||||
| lp_planed_payment_date2 | FQM_PLAN_DATE2 | Plan. Pymt Date2 | ||||
| base_amount | FQM_AMOUNT | Amount | ||||
| base_currency | FQM_CURRENCY | Currency | ||||
| amount | FQM_AMOUNT | Amount | ||||
| currency | FQM_CURRENCY | Currency | ||||
| quantity | FQM_QUANT | Quantity | ||||
| unit_of_measure | FQM_UNIT | Unit | ||||
| trm_product_type | VVSART | Product Type | ||||
| trm_transaction_type | TB_SFHAART | Transactn Type | ||||
| trm_activity_category | TB_SFGZUTY | Activity Cat. | ||||
| trm_security_id | VVRANLW | Security Class | ||||
| trm_security_account | RLDEPO | Securities Acct | ||||
| trm_portfolio | RPORTB | Portfolio | ||||
| house_bank | HBKID | House Bank | ||||
| house_bank_account | HKTID | Account ID | ||||
| bank_account_id | FCLM_BAM_ACC_ID | Technical ID | ||||
| company_code | BUKRS | Company Code | ||||
| customer_number | KUNNR | Customer | ||||
| vendor_number | LIFNR | Supplier | ||||
| partner | BU_PARTNER | Busn. Partner | ||||
| material | MATNR | Material | ||||
| business_area | GSBER | Business Area | ||||
| profit_center | PRCTR | Profit Center | ||||
| project | PS_PSP_PNR | WBS Element | ||||
| cost_center | KOSTL | Cost Center | ||||
| trading_partner | RASSC | Trading Partner | ||||
| liquidity_item | FLQPOS | Liquidity Item | ||||
| segment | FB_SEGMENT | Segment | ||||
| planning_level | FDLEV | Planning Level | ||||
| planning_group | FDGRP | Planning group | ||||
| contract_number | VERTNR | Contract Number | ||||
| contract_type | RANTYP | Contract Type | ||||
| assigned_company_code | BUKRS | Company Code | ||||
| internal_reference | TB_REFER | Internal Ref. | ||||
| characteristics | TB_MERKM | Characteristics | ||||
| assignment | TB_ZUOND | Assignment | ||||
| cmm_interest_rate | DZINSS | Interest rate | ||||
| cmm_calendar_type | KLART_VZ | Calendar Type | ||||
| cmm_state | FQM_CMR_STATE | State | ||||
| cmm_exchange_rate_type | KURST_CURR | Exch. Rate Type | ||||
| cmm_inverted_rate_type | XKURSINV | Inv.rate | ||||
| cmm_offset_account | GGRUP | Offsetting acct | ||||
| cmm_offset_accid | FCLM_GACCID | Offset.Bank Acc | ||||
| cmm_transaction_type | VOART | Trans. type | ||||
| cmm_statistics_indicator | STKNZ | Statistics Ind. | ||||
| cmm_payment_group | KLIDR | ID number (grp) | ||||
| cmm_reason | KLGND | CM pairing | ||||
| cmm_auth_rel | AUTH_REL | Auth. and Release | ||||
| cmm_bs_num_eb | ESNUM_EB | Memo Record No. | ||||
| cmm_offset_bank_account_number | FCLM_BAM_ACC_NUM | Account Number | ||||
| cmm_offset_housebank | HBKID | House Bank | ||||
| cmm_offset_housebankaccount | HKTID | Account ID | ||||
| cmm_fdes_idenr | IDENR | ID number | ||||
| cmm_sdm_status | FCLM_SDM_STATUS | SDM Status | ||||
| cmm_assignment_number | FDZUO | Assignment | ||||
| cmm_planning_type | DSART | Memo Recd Type | ||||
| cashrequest_id | FQM_CASHREQ_ID | Cash Request ID | ||||
| cashrequest_status | FQM_CASHREQ_STATUS | Request Status | ||||
| instrument_category | TPI_INSTRUMENT_CATEGORY | Instrument Cat. | ||||
| following_currency | TRBA_WFWAERS | Following Crcy | ||||
| amount_in_folcur | FQM_AMOUNT | Amount | ||||
| buy_sell_indicator | TPI_FX_BUY_SELL | Buy/Sell | ||||
| following_account | FCLM_BAM_ACC_ID | Technical ID | ||||
| flag_document | XFELD | Checkbox | ||||
| cq_assignment | TB_ZUOND | Assignment | ||||
| cq_internal_reference | TB_REFER | Internal Ref. | ||||
| cq_characteristics | TB_MERKM | Characteristics | ||||
| following_companycode | BUKRS | Company Code | ||||
| following_bankdetail | BU_BKVID | Bank Details | ||||
| following_housebank | HBKID | House Bank | ||||
| following_housebankaccount | HKTID | Account ID | ||||
| mmk_term_from_date | VALUT | Value date | ||||
| mmk_term_to_date | VALUT | Value date | ||||
| mmk_invest_borrow | FCLM_MMR_INVEST_BORROW | Invest/Borrow | ||||
| mmk_max_term_from_date | VALUT | Value date | ||||
| mmk_max_term_to_date | VALUT | Value date | ||||
| mmk_offset_flag | FCLM_MMR_OFFSET | Flag | ||||
| cashrequest_subimitted_by | FCLM_SUBMITTED_BY | Submitted By | ||||
| fxsw_value_date_leg_1 | FCLM_CSHRQ_VALUE_DATE | Value Date | ||||
| fxsw_open_traded_amount_leg_1 | FCLM_CSHRQ_OPEN_TRADED_AMOUNT | Open Amount | ||||
| fxsw_requested_amount_leg_1 | FCLM_CSHRQ_REQUESTED_AMOUNT | Requested Amount | ||||
| fxsw_traded_currency_leg_1 | FCLM_CSHRQ_TRADED_CURRENCY | Requested Currency | ||||
| fxsw_opposite_amount_leg_1 | FCLM_CSHRQ_OPPOSITE_AMOUNT | Requested Opposite Amount (Forecasted) | ||||
| fxsw_opposite_currency_leg_1 | FCLM_CSHRQ_OPPOSITE_CURRENCY | Requested Opposite Currency | ||||
| fxsw_sending_acc_id_leg_1 | FCLM_CSHRQ_SENDING_ACC_ID | Sending Bank Account ID | ||||
| fxsw_receiving_acc_id_leg_1 | FCLM_CSHRQ_RECEIVING_ACC_ID | Receiving Bank Account ID | ||||
| fxsw_value_date_leg_2 | FCLM_CSHRQ_VALUE_DATE_LEG2 | Value Date (Leg 2) | ||||
| fxsw_sending_acc_id_leg_2 | FCLM_CSHRQ_SENDING_ACC_ID_LEG2 | Sending Bank Account ID (Leg 2) | ||||
| fxsw_receiving_acc_id_leg_2 | FCLM_CSHRQ_RCVG_ACC_ID_LEG2 | Receiving Bank Account ID (Leg 2) | ||||
| fxsw_open_traded_amount_leg_2 | FCLM_CSHRQ_OPEN_TRDD_AMT_LEG2 | Open Amount (Leg 2) | ||||
| fxsw_requested_amount_leg_2 | FCLM_CSHRQ_REQUESTED_AMT_LEG2 | Requested Amount (Leg 2) | ||||
| fxsw_traded_currency_leg_2 | FCLM_CSHRQ_TRADED_CURRENCY | Requested Currency | ||||
| fxsw_opposite_amount_leg_2 | FCLM_CSHRQ_OPPOSITE_AMT_LEG2 | Requested Opp. Amt (Forecasted, Leg 2) | ||||
| fxsw_opposite_currency_leg_2 | FCLM_CSHRQ_OPPOSITE_CURRENCY | Requested Opposite Currency | ||||
| term_from_date | VALUT | Value date | ||||
| term_to_date | VALUT | Value date | ||||
| amount_requested | FQM_AMOUNT | Amount | ||||
| currency_requested | FQM_CURRENCY | Currency | ||||
| invest_borrow | FCLM_MMR_INVEST_BORROW | Invest/Borrow | ||||
| max_term_from_date | VALUT | Value date | ||||
| max_term_to_date | VALUT | Value date | ||||
| fca_bp | GPART_KK | Bus. Partner | ||||
| fca_account_number | VKONT_KK | Contract Acct | ||||
| fca_doc_number | OPBEL_KK | Document Number | ||||
| fca_docitem_number | OPUPK_KK | Item | ||||
| fca_clearing_reason | AUGRD_KK | Clearing Reason | ||||
| fca_origin_key | HERKF_KK | Document Origin | ||||
| fca_bt_category | FINS_BTTYPE | Bus. Trans. Category | ||||
| fca_tax_amt | FWSTE | Amount | ||||
| ltype | FQM_LINKTYPE | Link Type | ||||
| lnkid | FQM_LINKID | Link ID | ||||
| dummy_fclm_fb2_incl_eew_ps | CFD_DUMMY | Dummy |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- FQM Flows
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FQM_FLOW (
MANDT, -- Client [MANDT]
FLOW_ID, -- Flow ID [FQM_FLOW_ID]
VALID_FROM, -- FQM Flow Valid From [FQM_VALID_FROM]
VALID_TO, -- FQM Flow Valid To [FQM_VALID_TO]
SOFTWARE_VERSION, -- Software Version [FQM_SOFTWARE_VERSION]
FLG_ACTUAL, -- FQM Flag Actual [FQM_FLG_ACTUAL]
TRANSACTION_ID, -- Transaction ID [FQM_TRANSACTION_ID]
PARENT_TRANSACTION_ID, -- Par. Trans. ID [FQM_PARENT_TRANSACTION_ID]
PARENT_FLOW_ID, -- Par. Flow ID [FQM_PARENT_FLOW_ID]
ROOT_ID, -- Flow ID [FQM_FLOW_ID]
DELETED, -- Deleted [FQM_DELETED]
PROCESS_STATUS, -- Status [FQM_PROCESS_STATUS]
CLEARED, -- Cleared [FQM_CLEARED]
CLEARING_FLOW_ID, -- Flow ID [FQM_FLOW_ID]
CREATE_USER, -- Fqm Create User [FQM_CREATE_USER]
LAST_UPDATE_USER, -- Fqm Last Update User [FQM_UPDATE_USER]
CREATE_TIMESTAMP, -- FQM Flow Created At [FQM_CREATE_TIMESTAMP]
LAST_UPDATE_TIMESTAMP, -- FQM Flow Update Time [FQM_UPDATE_TIMESTAMP]
ORIGIN_SYSTEM, -- Logical system [LOGSYS]
ORIGIN_APPLICATION, -- Source Application [FQM_ORIGIN_APPLICATION]
ORIGIN_DOCUMENT_ID, -- Source Doc. ID [FQM_ORIGIN_DOC_ID]
ORIGIN_TRANSACTION_ID, -- Source Trans. ID [FQM_ORIGIN_TRANS_ID]
ORIGIN_TRANS_QUALIFIER, -- Trans. Qualifier [FQM_ORIGIN_TRANS_QUALIFIER]
ORIGIN_FLOW_ID, -- Source Flow ID [FQM_ORIGIN_FLOW_ID]
ORIGIN_SYSTEM_RL, -- Logical system [LOGSYS]
ORIGIN_APPLICATION_RL, -- Source Application [FQM_ORIGIN_APPLICATION]
ORIGIN_DOCUMENT_ID_RL, -- Source Doc. ID [FQM_ORIGIN_DOC_ID]
ORIGIN_TRANSACTION_ID_RL, -- Source Trans. ID [FQM_ORIGIN_TRANS_ID]
ORIGIN_TRANS_QUALIFIER_RL, -- Trans. Qualifier [FQM_ORIGIN_TRANS_QUALIFIER]
ORIGIN_FLOW_ID_RL, -- Source Flow ID [FQM_ORIGIN_FLOW_ID]
CERTAINTY_LEVEL, -- Certainty Level [FQM_CERTAINTY_LEVEL]
OWNER, -- Trans. Owner [FQM_OWNER]
TRANSACTION_DATE, -- Transaction Date [FQM_TRANSACTION_DATE]
TRANSACTION_CATEGORY, -- Transaction Category [FQM_TRANSACTION_CATEGORY]
FLOW_CATEGORY, -- Flow Category [FQM_FLOW_CAT]
FLOW_TYPE, -- Flow Type [FQM_FLOW_TYPE]
REL_STATUS, -- Release Status [FQM_RELEASE_STATUS]
PAYMENT_DATE, -- Payment Date [FQM_PAYMENT_DATE]
PAYMENT_CURRENCY, -- Currency [FQM_CURRENCY]
DOCUMENT_DATE, -- Document Date [FQM_DOCUMENT_DATE]
BASELINE_DATE, -- Baseline Date [FQM_BASELINE_DATE]
DAYS_DUE, -- Days until Due [FQM_DAYS_DUE]
CASH_DISCOUNT_DAYS1, -- Days Term 1 [FQM_CASH_DISCOUNT_DAYS1]
CASH_DISCOUNT_PERCENT1, -- Percent 1st Term [FQM_CASH_DISCOUNT_PERCENT1]
CASH_DISCOUNT_DAYS2, -- Days Term 2 [FQM_CASH_DISCOUNT_DAYS2]
CASH_DISCOUNT_PERCENT2, -- Percent 2nd Term [FQM_CASH_DISCOUNT_PERCENT2]
PAYMENT_METHOD, -- Payment Method [FQM_PAYMENT_METHOD]
PAYMENT_BLOCK, -- Payment Block [FQM_PAYMENT_BLOCK]
PAYMENT_MODE, -- Payment Mode [FQM_PAYMENT_MODE]
FUND, -- Fund [BP_GEBER]
GRANT_NBR, -- Grant [GM_GRANT_NBR]
FI_DOCUMENT_NUMBER, -- Document Number [BELNR_D]
FI_DOCUMENT_LINE_ITEM, -- Item [BUZEI]
FI_FISCAL_YEAR, -- Fiscal Year [GJAHR]
FI_FISCAL_PERIOD, -- Period [MONAT]
FI_CREDIT_DEBIT_INDICATOR, -- Debit/Credit [SHKZG]
FI_INVOICE_REFERENCE, -- Invoice Ref. [REBZG]
FI_INVOICE_FISCAL_YEAR_REF, -- Fiscal Year [REBZJ]
FI_INVOICE_ITEM_REF, -- Item [REBZZ]
FI_CLEARING_DOCUMENT, -- Clrng doc. [AUGBL]
FI_CLEARING_ITEM, -- Clearing Item [AGZEI]
FI_CLEARING_TYPE, -- Type of Clearing in Table AUSZ_CLR [CLRINF]
FI_POST_DATE, -- Posting Date [BUDAT]
FI_BASELINE_DATE, -- Baseline Date [DZFBDT]
FI_DOCUMENT_TYPE, -- Document Type [BLART]
FI_ACCOUNT_TYPE, -- Account type [KOART]
FI_ACCOUNT, -- G/L Acct [HKONT]
FI_VALUE_DATE, -- Value date [VALUT]
FI_DUE_DATE, -- Due Date [FQM_DUE_DATE]
FI_CLEARING_DATE, -- Clearing [AUGDT]
FI_PURCHSE_DOCUMENT_NUMBER, -- Purchasing Doc. [EBELN]
FI_PURCHSE_LINE_ITEM, -- Item [EBELP]
FI_SEQUENTIAL_NUMBER, -- Account Assgmt No. [DZEKKN]
FI_REVERSE_DOCUMENT_NUMBER, -- Reversed With [STBLG]
FI_ITEM_TEXT, -- Text [SGTXT]
FI_ENTRY_DATE, -- Entered On [CPUDT]
FI_ENTRY_TIME, -- Entered at [CPUTM]
FI_PAYMENT_TERM, -- Days Net [DZBD3T]
MM_ORDER_TYPE, -- Order Type [BSART]
MM_DOCUMENT_CATEGORY, -- Doc. Category [BSTYP]
MM_DOCUMENT_ITEM_CATEGORY, -- Item Category [PSTYP]
MM_FINAL_INV_INDICATOR, -- Final Invoice [EREKZ]
MM_INVOICE_AMOUNT, -- InvoiceValue/TC [REWTW_CS]
MM_INVOICE_BASE_AMOUNT, -- Invoice Valu/LC [REWHW_CS]
LP_DISC_AMOUNT1, -- Discount Amnt1 [FQM_DISC_AMNT1]
LP_DISC_AMOUNT2, -- Discount Amnt2 [FQM_DISC_AMNT2]
LP_PLANED_PAYMENT_DATE1, -- Plan. Pymt Date1 [FQM_PLAN_DATE1]
LP_PLANED_PAYMENT_DATE2, -- Plan. Pymt Date2 [FQM_PLAN_DATE2]
BASE_AMOUNT, -- Amount [FQM_AMOUNT]
BASE_CURRENCY, -- Currency [FQM_CURRENCY]
AMOUNT, -- Amount [FQM_AMOUNT]
CURRENCY, -- Currency [FQM_CURRENCY]
QUANTITY, -- Quantity [FQM_QUANT]
UNIT_OF_MEASURE, -- Unit [FQM_UNIT]
TRM_PRODUCT_TYPE, -- Product Type [VVSART]
TRM_TRANSACTION_TYPE, -- Transactn Type [TB_SFHAART]
TRM_ACTIVITY_CATEGORY, -- Activity Cat. [TB_SFGZUTY]
TRM_SECURITY_ID, -- Security Class [VVRANLW]
TRM_SECURITY_ACCOUNT, -- Securities Acct [RLDEPO]
TRM_PORTFOLIO, -- Portfolio [RPORTB]
HOUSE_BANK, -- House Bank [HBKID]
HOUSE_BANK_ACCOUNT, -- Account ID [HKTID]
BANK_ACCOUNT_ID, -- Technical ID [FCLM_BAM_ACC_ID]
COMPANY_CODE, -- Company Code [BUKRS]
CUSTOMER_NUMBER, -- Customer [KUNNR]
VENDOR_NUMBER, -- Supplier [LIFNR]
PARTNER, -- Busn. Partner [BU_PARTNER]
MATERIAL, -- Material [MATNR]
BUSINESS_AREA, -- Business Area [GSBER]
PROFIT_CENTER, -- Profit Center [PRCTR]
PROJECT, -- WBS Element [PS_PSP_PNR]
COST_CENTER, -- Cost Center [KOSTL]
TRADING_PARTNER, -- Trading Partner [RASSC]
LIQUIDITY_ITEM, -- Liquidity Item [FLQPOS]
SEGMENT, -- Segment [FB_SEGMENT]
PLANNING_LEVEL, -- Planning Level [FDLEV]
PLANNING_GROUP, -- Planning group [FDGRP]
CONTRACT_NUMBER, -- Contract Number [VERTNR]
CONTRACT_TYPE, -- Contract Type [RANTYP]
ASSIGNED_COMPANY_CODE, -- Company Code [BUKRS]
INTERNAL_REFERENCE, -- Internal Ref. [TB_REFER]
CHARACTERISTICS, -- Characteristics [TB_MERKM]
ASSIGNMENT, -- Assignment [TB_ZUOND]
CMM_INTEREST_RATE, -- Interest rate [DZINSS]
CMM_CALENDAR_TYPE, -- Calendar Type [KLART_VZ]
CMM_STATE, -- State [FQM_CMR_STATE]
CMM_EXCHANGE_RATE_TYPE, -- Exch. Rate Type [KURST_CURR]
CMM_INVERTED_RATE_TYPE, -- Inv.rate [XKURSINV]
CMM_OFFSET_ACCOUNT, -- Offsetting acct [GGRUP]
CMM_OFFSET_ACCID, -- Offset.Bank Acc [FCLM_GACCID]
CMM_TRANSACTION_TYPE, -- Trans. type [VOART]
CMM_STATISTICS_INDICATOR, -- Statistics Ind. [STKNZ]
CMM_PAYMENT_GROUP, -- ID number (grp) [KLIDR]
CMM_REASON, -- CM pairing [KLGND]
CMM_AUTH_REL, -- Auth. and Release [AUTH_REL]
CMM_BS_NUM_EB, -- Memo Record No. [ESNUM_EB]
CMM_OFFSET_BANK_ACCOUNT_NUMBER, -- Account Number [FCLM_BAM_ACC_NUM]
CMM_OFFSET_HOUSEBANK, -- House Bank [HBKID]
CMM_OFFSET_HOUSEBANKACCOUNT, -- Account ID [HKTID]
CMM_FDES_IDENR, -- ID number [IDENR]
CMM_SDM_STATUS, -- SDM Status [FCLM_SDM_STATUS]
CMM_ASSIGNMENT_NUMBER, -- Assignment [FDZUO]
CMM_PLANNING_TYPE, -- Memo Recd Type [DSART]
CASHREQUEST_ID, -- Cash Request ID [FQM_CASHREQ_ID]
CASHREQUEST_STATUS, -- Request Status [FQM_CASHREQ_STATUS]
INSTRUMENT_CATEGORY, -- Instrument Cat. [TPI_INSTRUMENT_CATEGORY]
FOLLOWING_CURRENCY, -- Following Crcy [TRBA_WFWAERS]
AMOUNT_IN_FOLCUR, -- Amount [FQM_AMOUNT]
BUY_SELL_INDICATOR, -- Buy/Sell [TPI_FX_BUY_SELL]
FOLLOWING_ACCOUNT, -- Technical ID [FCLM_BAM_ACC_ID]
FLAG_DOCUMENT, -- Checkbox [XFELD]
CQ_ASSIGNMENT, -- Assignment [TB_ZUOND]
CQ_INTERNAL_REFERENCE, -- Internal Ref. [TB_REFER]
CQ_CHARACTERISTICS, -- Characteristics [TB_MERKM]
FOLLOWING_COMPANYCODE, -- Company Code [BUKRS]
FOLLOWING_BANKDETAIL, -- Bank Details [BU_BKVID]
FOLLOWING_HOUSEBANK, -- House Bank [HBKID]
FOLLOWING_HOUSEBANKACCOUNT, -- Account ID [HKTID]
MMK_TERM_FROM_DATE, -- Value date [VALUT]
MMK_TERM_TO_DATE, -- Value date [VALUT]
MMK_INVEST_BORROW, -- Invest/Borrow [FCLM_MMR_INVEST_BORROW]
MMK_MAX_TERM_FROM_DATE, -- Value date [VALUT]
MMK_MAX_TERM_TO_DATE, -- Value date [VALUT]
MMK_OFFSET_FLAG, -- Flag [FCLM_MMR_OFFSET]
CASHREQUEST_SUBIMITTED_BY, -- Submitted By [FCLM_SUBMITTED_BY]
FXSW_VALUE_DATE_LEG_1, -- Value Date [FCLM_CSHRQ_VALUE_DATE]
FXSW_OPEN_TRADED_AMOUNT_LEG_1, -- Open Amount [FCLM_CSHRQ_OPEN_TRADED_AMOUNT]
FXSW_REQUESTED_AMOUNT_LEG_1, -- Requested Amount [FCLM_CSHRQ_REQUESTED_AMOUNT]
FXSW_TRADED_CURRENCY_LEG_1, -- Requested Currency [FCLM_CSHRQ_TRADED_CURRENCY]
FXSW_OPPOSITE_AMOUNT_LEG_1, -- Requested Opposite Amount (Forecasted) [FCLM_CSHRQ_OPPOSITE_AMOUNT]
FXSW_OPPOSITE_CURRENCY_LEG_1, -- Requested Opposite Currency [FCLM_CSHRQ_OPPOSITE_CURRENCY]
FXSW_SENDING_ACC_ID_LEG_1, -- Sending Bank Account ID [FCLM_CSHRQ_SENDING_ACC_ID]
FXSW_RECEIVING_ACC_ID_LEG_1, -- Receiving Bank Account ID [FCLM_CSHRQ_RECEIVING_ACC_ID]
FXSW_VALUE_DATE_LEG_2, -- Value Date (Leg 2) [FCLM_CSHRQ_VALUE_DATE_LEG2]
FXSW_SENDING_ACC_ID_LEG_2, -- Sending Bank Account ID (Leg 2) [FCLM_CSHRQ_SENDING_ACC_ID_LEG2]
FXSW_RECEIVING_ACC_ID_LEG_2, -- Receiving Bank Account ID (Leg 2) [FCLM_CSHRQ_RCVG_ACC_ID_LEG2]
FXSW_OPEN_TRADED_AMOUNT_LEG_2, -- Open Amount (Leg 2) [FCLM_CSHRQ_OPEN_TRDD_AMT_LEG2]
FXSW_REQUESTED_AMOUNT_LEG_2, -- Requested Amount (Leg 2) [FCLM_CSHRQ_REQUESTED_AMT_LEG2]
FXSW_TRADED_CURRENCY_LEG_2, -- Requested Currency [FCLM_CSHRQ_TRADED_CURRENCY]
FXSW_OPPOSITE_AMOUNT_LEG_2, -- Requested Opp. Amt (Forecasted, Leg 2) [FCLM_CSHRQ_OPPOSITE_AMT_LEG2]
FXSW_OPPOSITE_CURRENCY_LEG_2, -- Requested Opposite Currency [FCLM_CSHRQ_OPPOSITE_CURRENCY]
TERM_FROM_DATE, -- Value date [VALUT]
TERM_TO_DATE, -- Value date [VALUT]
AMOUNT_REQUESTED, -- Amount [FQM_AMOUNT]
CURRENCY_REQUESTED, -- Currency [FQM_CURRENCY]
INVEST_BORROW, -- Invest/Borrow [FCLM_MMR_INVEST_BORROW]
MAX_TERM_FROM_DATE, -- Value date [VALUT]
MAX_TERM_TO_DATE, -- Value date [VALUT]
FCA_BP, -- Bus. Partner [GPART_KK]
FCA_ACCOUNT_NUMBER, -- Contract Acct [VKONT_KK]
FCA_DOC_NUMBER, -- Document Number [OPBEL_KK]
FCA_DOCITEM_NUMBER, -- Item [OPUPK_KK]
FCA_CLEARING_REASON, -- Clearing Reason [AUGRD_KK]
FCA_ORIGIN_KEY, -- Document Origin [HERKF_KK]
FCA_BT_CATEGORY, -- Bus. Trans. Category [FINS_BTTYPE]
FCA_TAX_AMT, -- Amount [FWSTE]
LTYPE, -- Link Type [FQM_LINKTYPE]
LNKID, -- Link ID [FQM_LINKID]
DUMMY_FCLM_FB2_INCL_EEW_PS, -- Dummy [CFD_DUMMY]
PRIMARY KEY (MANDT, FLOW_ID, VALID_FROM)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA