Bank account balance - Cockpit

In Scope

Technical: FQM_FLOW | ID: SAP-FI-FQM_FLOW-BANK_ACCOUNT_BALANCE

Opening bank account balances are loaded into SAP Cash Management (FQM) to provide an accurate starting liquidity position on the go-live date. Without this object, cash management reports and bank…

See how this object fits into Finance

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Unknown
Typical Sources: Legacy SAP ERPTreasury Management SystemBank Statement Extract

Classification

Information Type: Transaction
Object Type: cockpit

Target Structure

Load Approach: Excel
Target Objects: FQM_FLOW

Field Definitions(68)

Rules & Considerations(146)

validation

constraint

Sample Load Data(4)

_scenario	BUKRSR	HBKIDR	HKTIDR	AMOUNTR	RBLBETRR	HOUSE_BANK_IDR	FQM_FLOW.FLOW_TYPER	HOUSE_BANK_ACCOUNT_IDR	FQM_FLOW.CERTAINTY_LEVELR	FQM_FLOW.PAYMENT_CURRENCYR	FQM_FLOW.TRANSACTION_DATER	FUND	MANDT	OWNER	CLEARED	DELETED	FLOW_ID	ROOT_ID	DAYS_DUE	VALID_TO	FLOW_TYPE	GRANT_NBR	FLG_ACTUAL	REL_STATUS	VALID_FROM	CREATE_USER	PAYMENT_DATE	PAYMENT_MODE	BASELINE_DATE	DOCUMENT_DATE	FLOW_CATEGORY	FQM_FLOW.FUND	ORIGIN_SYSTEM	PAYMENT_BLOCK	FI_FISCAL_YEAR	FQM_FLOW.OWNER	ORIGIN_FLOW_ID	PARENT_FLOW_ID	PAYMENT_METHOD	PROCESS_STATUS	TRANSACTION_ID	CERTAINTY_LEVEL	CLEARING_FLOW_ID	CREATE_TIMESTAMP	FI_CLEARING_ITEM	FI_FISCAL_PERIOD	FQM_FLOW.CLEARED	FQM_FLOW.DELETED	FQM_FLOW.FLOW_ID	FQM_FLOW.ROOT_ID	LAST_UPDATE_USER	ORIGIN_SYSTEM_RL	PAYMENT_CURRENCY	SOFTWARE_VERSION	TRANSACTION_DATE	FQM_FLOW.DAYS_DUE	FQM_FLOW.VALID_TO	ORIGIN_FLOW_ID_RL	FI_DOCUMENT_NUMBER	FQM_FLOW.GRANT_NBR	ORIGIN_APPLICATION	ORIGIN_DOCUMENT_ID	CASH_DISCOUNT_DAYS1	CASH_DISCOUNT_DAYS2	FI_INVOICE_ITEM_REF	FQM_FLOW.FLG_ACTUAL	FQM_FLOW.REL_STATUS	FQM_FLOW.VALID_FROM	FI_CLEARING_DOCUMENT	FI_INVOICE_REFERENCE	FQM_FLOW.CREATE_USER	TRANSACTION_CATEGORY	FI_DOCUMENT_LINE_ITEM	FQM_FLOW.PAYMENT_DATE	FQM_FLOW.PAYMENT_MODE	LAST_UPDATE_TIMESTAMP	ORIGIN_APPLICATION_RL	ORIGIN_DOCUMENT_ID_RL	ORIGIN_TRANSACTION_ID	PARENT_TRANSACTION_ID	CASH_DISCOUNT_PERCENT1	CASH_DISCOUNT_PERCENT2	FQM_FLOW.BASELINE_DATE	FQM_FLOW.DOCUMENT_DATE	FQM_FLOW.FLOW_CATEGORY	FQM_FLOW.ORIGIN_SYSTEM	FQM_FLOW.PAYMENT_BLOCK	ORIGIN_TRANS_QUALIFIER	FQM_FLOW.FI_FISCAL_YEAR	FQM_FLOW.ORIGIN_FLOW_ID	FQM_FLOW.PARENT_FLOW_ID	FQM_FLOW.PAYMENT_METHOD	FQM_FLOW.PROCESS_STATUS	FQM_FLOW.TRANSACTION_ID	ORIGIN_TRANSACTION_ID_RL	FI_CREDIT_DEBIT_INDICATOR	FQM_FLOW.CLEARING_FLOW_ID	FQM_FLOW.CREATE_TIMESTAMP	FQM_FLOW.FI_CLEARING_ITEM	FQM_FLOW.FI_FISCAL_PERIOD	FQM_FLOW.LAST_UPDATE_USER	FQM_FLOW.ORIGIN_SYSTEM_RL	FQM_FLOW.SOFTWARE_VERSION	ORIGIN_TRANS_QUALIFIER_RL	FI_INVOICE_FISCAL_YEAR_REF	FQM_FLOW.ORIGIN_FLOW_ID_RL	FQM_FLOW.FI_DOCUMENT_NUMBER	FQM_FLOW.ORIGIN_APPLICATION	FQM_FLOW.ORIGIN_DOCUMENT_ID	FQM_FLOW.CASH_DISCOUNT_DAYS1	FQM_FLOW.CASH_DISCOUNT_DAYS2	FQM_FLOW.FI_INVOICE_ITEM_REF	FQM_FLOW.FI_CLEARING_DOCUMENT	FQM_FLOW.FI_INVOICE_REFERENCE	FQM_FLOW.TRANSACTION_CATEGORY	FQM_FLOW.FI_DOCUMENT_LINE_ITEM	FQM_FLOW.LAST_UPDATE_TIMESTAMP	FQM_FLOW.ORIGIN_APPLICATION_RL	FQM_FLOW.ORIGIN_DOCUMENT_ID_RL	FQM_FLOW.ORIGIN_TRANSACTION_ID	FQM_FLOW.PARENT_TRANSACTION_ID	FQM_FLOW.CASH_DISCOUNT_PERCENT1	FQM_FLOW.CASH_DISCOUNT_PERCENT2	FQM_FLOW.ORIGIN_TRANS_QUALIFIER	FQM_FLOW.ORIGIN_TRANSACTION_ID_RL	FQM_FLOW.FI_CREDIT_DEBIT_INDICATOR	FQM_FLOW.ORIGIN_TRANS_QUALIFIER_RL	FQM_FLOW.FI_INVOICE_FISCAL_YEAR_REF
Example values from field definitions	1000	HBGB1	MAIN	125000.00	125000.00	HBGB1	OB	MAIN	C	EUR	20240101	FM001	100	CASH_MGMT	SAMPLE	SAMPLE	000000000000001	000000000000000	0	999912312359599999999999999	OB	G000000000000001	X	R	202401010000000000000000000	MIG_USER	20240101	A	20240101	20231231	10	FM001	LEGACY_ERP	A	0000	SAMPLE	ITEM_001	000000000000000	B	A	001	C	000000000000000	202401011030000000000000000	00100	003	S	S	0001	0001	MIG_USER	LEGACY_A	EUR	0	20240101	100.00	100.00	RL_FLOW_881	1900004521	SAMPLE	FI	LEGACY_BAL_20240101_GBP	0	0	000000	X	R	100.00	SAMPLE	INV-99872	MIG_USER	OBAL	000000	20240101	SAMPLE	202401011030000000000000000	FI	LEGACY_DOC_999	OPEN_BAL_MAIN_ACC	000000000000000	0.0	0.0	20240101	20231231	0001	LEGACY_ERP	A	B	0000	SAMPLE	0001	SAMPL	SA	0001	RL_TXN_552	S	0001	100.00	100.00	003	MIG_USER	LEGACY_A	1	SAMPLE	0000	SAMPLE	1900004521	SAMP	SAMPLE	0	0	0001	SAMPLE	INV-99872	SAMPLE	0001	100.00	SAMP	SAMPLE	SAMPLE	0001	100.00	100.00	SAMP	SAMPLE	S	SAMP	0000

Example values from field definitions

BUKRSR: 1000
HBKIDR: HBGB1
HKTIDR: MAIN
AMOUNTR: 125000.00
RBLBETRR: 125000.00
HOUSE_BANK_IDR: HBGB1
FQM_FLOW.FLOW_TYPER: OB
HOUSE_BANK_ACCOUNT_IDR: MAIN
FQM_FLOW.CERTAINTY_LEVELR: C
FQM_FLOW.PAYMENT_CURRENCYR: EUR
FQM_FLOW.TRANSACTION_DATER: 20240101
FUND: FM001
MANDT: 100
OWNER: CASH_MGMT
CLEARED: SAMPLE
DELETED: SAMPLE
FLOW_ID: 000000000000001
ROOT_ID: 000000000000000
DAYS_DUE: 0
VALID_TO: 999912312359599999999999999
FLOW_TYPE: OB
GRANT_NBR: G000000000000001
FLG_ACTUAL: X
REL_STATUS: R
VALID_FROM: 202401010000000000000000000
CREATE_USER: MIG_USER
PAYMENT_DATE: 20240101
PAYMENT_MODE: A
BASELINE_DATE: 20240101
DOCUMENT_DATE: 20231231
FLOW_CATEGORY: 10
FQM_FLOW.FUND: FM001
ORIGIN_SYSTEM: LEGACY_ERP
PAYMENT_BLOCK: A
FI_FISCAL_YEAR: 0000
FQM_FLOW.OWNER: SAMPLE
ORIGIN_FLOW_ID: ITEM_001
PARENT_FLOW_ID: 000000000000000
PAYMENT_METHOD: B
PROCESS_STATUS: A
TRANSACTION_ID: 001
CERTAINTY_LEVEL: C
CLEARING_FLOW_ID: 000000000000000
CREATE_TIMESTAMP: 202401011030000000000000000
FI_CLEARING_ITEM: 00100
FI_FISCAL_PERIOD: 003
FQM_FLOW.CLEARED: S
FQM_FLOW.DELETED: S
FQM_FLOW.FLOW_ID: 0001
FQM_FLOW.ROOT_ID: 0001
LAST_UPDATE_USER: MIG_USER
ORIGIN_SYSTEM_RL: LEGACY_A
PAYMENT_CURRENCY: EUR
SOFTWARE_VERSION: 0
TRANSACTION_DATE: 20240101
FQM_FLOW.DAYS_DUE: 100.00
FQM_FLOW.VALID_TO: 100.00
ORIGIN_FLOW_ID_RL: RL_FLOW_881
FI_DOCUMENT_NUMBER: 1900004521
FQM_FLOW.GRANT_NBR: SAMPLE
ORIGIN_APPLICATION: FI
ORIGIN_DOCUMENT_ID: LEGACY_BAL_20240101_GBP
CASH_DISCOUNT_DAYS1: 0
CASH_DISCOUNT_DAYS2: 0
FI_INVOICE_ITEM_REF: 000000
FQM_FLOW.FLG_ACTUAL: X
FQM_FLOW.REL_STATUS: R
FQM_FLOW.VALID_FROM: 100.00
FI_CLEARING_DOCUMENT: SAMPLE
FI_INVOICE_REFERENCE: INV-99872
FQM_FLOW.CREATE_USER: MIG_USER
TRANSACTION_CATEGORY: OBAL
FI_DOCUMENT_LINE_ITEM: 000000
FQM_FLOW.PAYMENT_DATE: 20240101
FQM_FLOW.PAYMENT_MODE: SAMPLE
LAST_UPDATE_TIMESTAMP: 202401011030000000000000000
ORIGIN_APPLICATION_RL: FI
ORIGIN_DOCUMENT_ID_RL: LEGACY_DOC_999
ORIGIN_TRANSACTION_ID: OPEN_BAL_MAIN_ACC
PARENT_TRANSACTION_ID: 000000000000000
CASH_DISCOUNT_PERCENT1: 0.0
CASH_DISCOUNT_PERCENT2: 0.0
FQM_FLOW.BASELINE_DATE: 20240101
FQM_FLOW.DOCUMENT_DATE: 20231231
FQM_FLOW.FLOW_CATEGORY: 0001
FQM_FLOW.ORIGIN_SYSTEM: LEGACY_ERP
FQM_FLOW.PAYMENT_BLOCK: A
ORIGIN_TRANS_QUALIFIER: B
FQM_FLOW.FI_FISCAL_YEAR: 0000
FQM_FLOW.ORIGIN_FLOW_ID: SAMPLE
FQM_FLOW.PARENT_FLOW_ID: 0001
FQM_FLOW.PAYMENT_METHOD: SAMPL
FQM_FLOW.PROCESS_STATUS: SA
FQM_FLOW.TRANSACTION_ID: 0001
ORIGIN_TRANSACTION_ID_RL: RL_TXN_552
FI_CREDIT_DEBIT_INDICATOR: S
FQM_FLOW.CLEARING_FLOW_ID: 0001
FQM_FLOW.CREATE_TIMESTAMP: 100.00
FQM_FLOW.FI_CLEARING_ITEM: 100.00
FQM_FLOW.FI_FISCAL_PERIOD: 003
FQM_FLOW.LAST_UPDATE_USER: MIG_USER
FQM_FLOW.ORIGIN_SYSTEM_RL: LEGACY_A
FQM_FLOW.SOFTWARE_VERSION: 1
ORIGIN_TRANS_QUALIFIER_RL: SAMPLE
FI_INVOICE_FISCAL_YEAR_REF: 0000
FQM_FLOW.ORIGIN_FLOW_ID_RL: SAMPLE
FQM_FLOW.FI_DOCUMENT_NUMBER: 1900004521
FQM_FLOW.ORIGIN_APPLICATION: SAMP
FQM_FLOW.ORIGIN_DOCUMENT_ID: SAMPLE
FQM_FLOW.CASH_DISCOUNT_DAYS1: 0
FQM_FLOW.CASH_DISCOUNT_DAYS2: 0
FQM_FLOW.FI_INVOICE_ITEM_REF: 0001
FQM_FLOW.FI_CLEARING_DOCUMENT: SAMPLE
FQM_FLOW.FI_INVOICE_REFERENCE: INV-99872
FQM_FLOW.TRANSACTION_CATEGORY: SAMPLE
FQM_FLOW.FI_DOCUMENT_LINE_ITEM: 0001
FQM_FLOW.LAST_UPDATE_TIMESTAMP: 100.00
FQM_FLOW.ORIGIN_APPLICATION_RL: SAMP
FQM_FLOW.ORIGIN_DOCUMENT_ID_RL: SAMPLE
FQM_FLOW.ORIGIN_TRANSACTION_ID: SAMPLE
FQM_FLOW.PARENT_TRANSACTION_ID: 0001
FQM_FLOW.CASH_DISCOUNT_PERCENT1: 100.00
FQM_FLOW.CASH_DISCOUNT_PERCENT2: 100.00
FQM_FLOW.ORIGIN_TRANS_QUALIFIER: SAMP
FQM_FLOW.ORIGIN_TRANSACTION_ID_RL: SAMPLE
FQM_FLOW.FI_CREDIT_DEBIT_INDICATOR: S
FQM_FLOW.ORIGIN_TRANS_QUALIFIER_RL: SAMP
FQM_FLOW.FI_INVOICE_FISCAL_YEAR_REF: 0000

Rule Validation Summary

Source Rule Count: 146
Governed Rule Count: 146

All objects