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(5)

Rules & Considerations(146)

validation

constraint

Sample Load Data(4)

Example values from field definitions

BUKRSR
1000
HBKIDR
HBGB1
AMOUNTR
125000.00
HOUSE_BANK_IDR
HBGB1
HOUSE_BANK_ACCOUNT_IDR
MAIN
FUND
FM001
HKTID
MAIN
MANDT
100
OWNER
CASH_MGMT
CLEARED
SAMPLE
DELETED
SAMPLE
FLOW_ID
000000000000001
RBLBETR
125000.00
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.FLOW_TYPE
OB
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
FQM_FLOW.CERTAINTY_LEVEL
C
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.PAYMENT_CURRENCY
EUR
FQM_FLOW.SOFTWARE_VERSION
1
FQM_FLOW.TRANSACTION_DATE
20240101
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

Closed historical record with successor reference

BUKRSR
2000
HBKIDR
HBG02
AMOUNTR
125000.01
HOUSE_BANK_IDR
HBG02
HOUSE_BANK_ACCOUNT_IDR
NAIN
FUND
FM001
HKTID
NAIN
MANDT
100
OWNER
C02
CLEARED
TAMPLE
DELETED
S
FLOW_ID
0000000000000002
RBLBETR
125000.01
ROOT_ID
0000000000000001
DAYS_DUE
0
VALID_TO
20231231
FLOW_TYPE
PB
GRANT_NBR
G000000000000001
FLG_ACTUAL
X
REL_STATUS
R
VALID_FROM
20221231
CREATE_USER
MIGUSER02
PAYMENT_DATE
20240208
PAYMENT_MODE
B
BASELINE_DATE
20240207
DOCUMENT_DATE
20240206
FLOW_CATEGORY
000011
FQM_FLOW.FUND
ORIGIN_SYSTEM
LEGACYER02
PAYMENT_BLOCK
A
FI_FISCAL_YEAR
0001
FQM_FLOW.OWNER
ORIGIN_FLOW_ID
ITEM00102
PARENT_FLOW_ID
0000000000000001
PAYMENT_METHOD
C
PROCESS_STATUS
A
TRANSACTION_ID
0000000000000002
CERTAINTY_LEVEL
D
CLEARING_FLOW_ID
0000000000000001
CREATE_TIMESTAMP
202401011030000000000000000.0000001
FI_CLEARING_ITEM
100
FI_FISCAL_PERIOD
01
FQM_FLOW.CLEARED
FQM_FLOW.DELETED
FQM_FLOW.FLOW_ID
FQM_FLOW.ROOT_ID
LAST_UPDATE_USER
MIGUSER02
ORIGIN_SYSTEM_RL
LEGACYA02
PAYMENT_CURRENCY
USD
SOFTWARE_VERSION
1
TRANSACTION_DATE
20240207
FQM_FLOW.DAYS_DUE
FQM_FLOW.VALID_TO
ORIGIN_FLOW_ID_RL
RLFLOW88102
FI_DOCUMENT_NUMBER
1900004502
FQM_FLOW.FLOW_TYPE
FQM_FLOW.GRANT_NBR
ORIGIN_APPLICATION
GI
ORIGIN_DOCUMENT_ID
LEGACYBAL20240101GBP02
CASH_DISCOUNT_DAYS1
0
CASH_DISCOUNT_DAYS2
0
FI_INVOICE_ITEM_REF
001
FQM_FLOW.FLG_ACTUAL
FQM_FLOW.REL_STATUS
FQM_FLOW.VALID_FROM
FI_CLEARING_DOCUMENT
TAMPLE
FI_INVOICE_REFERENCE
INV9987202
FQM_FLOW.CREATE_USER
TRANSACTION_CATEGORY
PBAL
FI_DOCUMENT_LINE_ITEM
001
FQM_FLOW.PAYMENT_DATE
FQM_FLOW.PAYMENT_MODE
LAST_UPDATE_TIMESTAMP
202401011030000000000000000.0000001
ORIGIN_APPLICATION_RL
GI
ORIGIN_DOCUMENT_ID_RL
LEGACYDOC99902
ORIGIN_TRANSACTION_ID
OPENBALMAINACC02
PARENT_TRANSACTION_ID
0000000000000001
CASH_DISCOUNT_PERCENT1
0.001
CASH_DISCOUNT_PERCENT2
0.001
FQM_FLOW.BASELINE_DATE
FQM_FLOW.DOCUMENT_DATE
FQM_FLOW.FLOW_CATEGORY
FQM_FLOW.ORIGIN_SYSTEM
FQM_FLOW.PAYMENT_BLOCK
ORIGIN_TRANS_QUALIFIER
C
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
FQM_FLOW.CERTAINTY_LEVEL
ORIGIN_TRANSACTION_ID_RL
RLTXN55202
FI_CREDIT_DEBIT_INDICATOR
S
FQM_FLOW.CLEARING_FLOW_ID
FQM_FLOW.CREATE_TIMESTAMP
FQM_FLOW.FI_CLEARING_ITEM
100
FQM_FLOW.FI_FISCAL_PERIOD
FQM_FLOW.LAST_UPDATE_USER
FQM_FLOW.ORIGIN_SYSTEM_RL
FQM_FLOW.PAYMENT_CURRENCY
FQM_FLOW.SOFTWARE_VERSION
FQM_FLOW.TRANSACTION_DATE
ORIGIN_TRANS_QUALIFIER_RL
TAMPLE
FI_INVOICE_FISCAL_YEAR_REF
0001
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

New record with minimal optional data

BUKRSR
3000
HBKIDR
HBG03
AMOUNTR
125000.02
HOUSE_BANK_IDR
HBG03
HOUSE_BANK_ACCOUNT_IDR
MCIN
FUND
HKTID
MCIN
MANDT
OWNER
CLEARED
DELETED
FLOW_ID
0000000000000003
RBLBETR
125000.02
ROOT_ID
0000000000000002
DAYS_DUE
VALID_TO
99991231
FLOW_TYPE
OD
GRANT_NBR
FLG_ACTUAL
REL_STATUS
VALID_FROM
20250101
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
ITEM00103
PARENT_FLOW_ID
0000000000000002
PAYMENT_METHOD
PROCESS_STATUS
TRANSACTION_ID
0000000000000003
CERTAINTY_LEVEL
E
CLEARING_FLOW_ID
0000000000000002
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
EUR
SOFTWARE_VERSION
TRANSACTION_DATE
20240315
FQM_FLOW.DAYS_DUE
FQM_FLOW.VALID_TO
ORIGIN_FLOW_ID_RL
RLFLOW88103
FI_DOCUMENT_NUMBER
1900004503
FQM_FLOW.FLOW_TYPE
FQM_FLOW.GRANT_NBR
ORIGIN_APPLICATION
ORIGIN_DOCUMENT_ID
LEGACYBAL20240101GBP03
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
LEGACYDOC99903
ORIGIN_TRANSACTION_ID
OPENBALMAINACC03
PARENT_TRANSACTION_ID
0000000000000002
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
FQM_FLOW.CERTAINTY_LEVEL
ORIGIN_TRANSACTION_ID_RL
RLTXN55203
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.PAYMENT_CURRENCY
FQM_FLOW.SOFTWARE_VERSION
FQM_FLOW.TRANSACTION_DATE
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

Rule Validation Summary

Source Rule Count
146
Governed Rule Count
146