FEBKO_TRANSFER

Transferred Bank Statements | #transactional | Component: Electronic Bank Statement

🔑 Keys (2)
💰 Amounts (2)
∑ Quantities
📅 Dates (2)
☰ Categorical
Other (8)
🔗 Relations (6)

Column Name	Description
MANDT FK	Client
GUID	UUID in character form

Column Name	Description
💲 Currency Key (FEBKO.WAERS):
SSBTR	Opening Balance Amount
ESBTR	Ending Balance Amount

Column Name	Description

Column Name	Description
STATEMENT_DATE	Statement Date
DATE_TRANS	Date

Column Name	Description

Column Name	Description	Domain name
PATH_TRANS	Logical Path Name for Transfer	CHAR60
FILENAME	Physical File Name	TEXT_512
BNKACCOUNT_EXT	External Bank Account Number or IBAN	CHAR35
BUKRS	Company Code	BUKRS
STATEMENT_ID	Bank Statement Identification	CHAR20
TIME_TRANS	Time in CHAR Format	CHAR6
SSVOZ	Starting Balance +/- Sign	CHAR1
ESVOZ	Closing Balance +/- Sign	CHAR1

Master Data Relations	Join Conditions
Country/Region Key of Bank Country/Region Key of Bank Client	`FEBKO_TRANSFER.BANKS == T005.LAND1` `FEBKO_TRANSFER.MANDT == T005.MANDT`
Bank Keys Bank Keys Country/Region Key of Bank	`FEBKO_TRANSFER.MANDT == BNKA.MANDT` `FEBKO_TRANSFER.BANKY == BNKA.BANKL` `FEBKO_TRANSFER.BANKS == BNKA.BANKS`
Short Key for a House Bank Short Key for a House Bank Company Code	`FEBKO_TRANSFER.MANDT == T012.MANDT` `FEBKO_TRANSFER.HBKID == T012.HBKID` `FEBKO_TRANSFER.BUKRS == T012.BUKRS`
ID for Account Details Company Code ID for Account Details Client Short Key for a House Bank	`FEBKO_TRANSFER.BUKRS == T012K.BUKRS` `FEBKO_TRANSFER.HKTID == T012K.HKTID` `FEBKO_TRANSFER.MANDT == T012K.MANDT` `FEBKO_TRANSFER.HBKID == T012K.HBKID`
Client	`FEBKO_TRANSFER.MANDT == T000.MANDT`
Currency Key	`FEBKO_TRANSFER.MANDT == TCURC.MANDT` `FEBKO_TRANSFER.WAERS == TCURC.WAERS`