FCLM_BAM_ACLINK2

Transparent Table Application Table
41 Fields 25 CDS Views

Linkages Between Bank Account and House Bank Accounts

FCLM_BAM_ACLINK2 is an SAP database table in S/4HANA. Linkages Between Bank Account and House Bank Accounts. It contains 41 fields. 25 CDS views read from this table.

CDS Views using this table (25)

ViewTypeJoinVDMDescription
ESH_N_HOUSEBANKACCT_BAM_CLINK2 view from Links of Bank Acct and House Bank Accts
FAC_AUDIT_Z3_BANK_REC_MASTER view left_outer Bank Account Master Data
FAR_DP_MERCHANT view from Merchant Account for SAP Digital Payments add-on
FCLM_ACCOUNT_BALANCE_MONITOR view inner Bank account with balance upload detail
Fclm_Bam_Acc_Cashpool view from Accounts in Cash Pool
FCLM_BAM_BSMCUST view inner Bank Statement Monitor Configuration
FCLM_BAM_DDL_AMD_BASE view left_outer Base View for AMD
FCLM_BAM_DISTINCT_HBA view from distinct house bank accounts for T012K
FCLM_BAM_HBA_ENHANCED view from house bank accounts for T012K_ENHANCED
fclm_bam_shlp_acctid view left_outer Search help for ACC ID
FCLM_BAM_T012K_BASE view inner Base view for V_T012K_BAM_DDL
FCLM_BAM_T012K_E_BASE view inner Base View for T012K with Opened at Bank
I_BankAccCashPoolTP view from TRANSACTIONAL Bank Account Cash Pool
I_BankAccountMultipleLinkage view from BASIC Bank Account Multi Linkages
I_BankAccountValidLinkage view from BASIC Bank Account Valid Linkages
I_BkAcctAndHsBkAcctLinkage view from COMPOSITE Linkages Between BkAcc and HouseBkAcc
I_BkAcctLinkageWthRevision view from BASIC Bk Acct Connectivity Path with Revision
P_BANKACCOUNTLINKAGE view from BASIC Bank Account Valid Linkages
P_HouseBankAccount view inner BASIC
P_HouseBankAccountDesc view from BASIC
P_HouseBankAccountText view inner BASIC
V_T012k_Bam_Sh_Ddl view inner DDL Source for Value Help on T012K
VFCLM_BAM_DDL_ACCLINK view left_outer
VFCLM_BAM_DDL_HIERNODECORE view left_outer Hierarchy Node Core Attributes
VFCLM_BAM_DDL_HOUSEBANKACCOUNT view inner

Fields (41)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY acc_id FCLM_BAM_ACC_ID Technical ID
KEY guid FCLM_BAM_GUID GUID 16
KEY revision FCLM_REVISION Revision Number
valid_from FCLM_BAM_ACLINK_VALIDFROM Valid From
valid_to FCLM_BAM_ACLINK_VALIDTO Valid To
herku FCLM_BAM_ACLINK_HERKU Remote System
bukrs FCLM_BAM_BUKRS Company Code
hbkid FCLM_BAM_ACLINK_HBKID House Bank
hktid FCLM_BAM_ACLINK_HKTID House Bank Account
remoteaccount FCLM_BAM_REMOTEACCOUNT Additional ID
bankn BANKN Bank Account
bkont BKONT Control Key
refzl FCLM_BAM_REFZL Reference info.
dtaai FCLM_BAM_DTAAI DME identifictn
bnkn2 BNKN2 Altern.Acct No.
is_reused FCLM_BAM_HBA_REUSED_FLAG Is Reused
fdgrp FDGRP Planning group
abwae ABWAE Settlement cur.
hkont HKONT G/L Acct
wekon WEKON Discount Acct
mindt MINDT Minimum Days
hbid1 HBID1_012K House bank 1
hkid1 HKID1_012K Account ID 1
hbid2 HBID2_012K House bank 2
hkid2 HKID2_012K Account ID 2
wkkon WKKON_012K Returned BoE Py
wikon WIKON_012K Collection Acct
new_bacl_flag FCLM_BAM_NEW_BACL_FLAG Use New G/L Account
old_hkont HKONT G/L Acct
migration_status FCLM_BAM_BACL_MIGRATION_STATUS Migration Status
cash_pooling_flag FCLM_BAM_CASH_POOLING_FLAG Use in Cash Pooling
bank_account_auth_group BANK_ACCOUNT_AUTH_GROUP Authorization Group
netting_group FCLM_BAM_NETTING_GROUP Netting Group
togru TOGRU_S Tolerance Group
xspeb XSPEB Posting Block
posting_block_date FCLM_BAM_POSTING_BLOCK_DATE Opening Date
target_hkont HKONT G/L Acct
balance_transfer_date FCLM_BAM_BALANCE_TRANSFER_DATE Transfer Date
bs_post_cat FCLM_BS_POST_CAT Post. Category (EoD)
bs2fqm_mode FCLM_BS2FQM_MODE Transfer Mode (EoD)

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.

-- Linkages Between Bank Account and House Bank Accounts
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_BAM_ACLINK2 (
    MANDT,                    -- Client [MANDT]
    ACC_ID,                   -- Technical ID [FCLM_BAM_ACC_ID]
    GUID,                     -- GUID 16 [FCLM_BAM_GUID]
    REVISION,                 -- Revision Number [FCLM_REVISION]
    VALID_FROM,               -- Valid From [FCLM_BAM_ACLINK_VALIDFROM]
    VALID_TO,                 -- Valid To [FCLM_BAM_ACLINK_VALIDTO]
    HERKU,                    -- Remote System [FCLM_BAM_ACLINK_HERKU]
    BUKRS,                    -- Company Code [FCLM_BAM_BUKRS]
    HBKID,                    -- House Bank [FCLM_BAM_ACLINK_HBKID]
    HKTID,                    -- House Bank Account [FCLM_BAM_ACLINK_HKTID]
    REMOTEACCOUNT,            -- Additional ID [FCLM_BAM_REMOTEACCOUNT]
    BANKN,                    -- Bank Account [BANKN]
    BKONT,                    -- Control Key [BKONT]
    REFZL,                    -- Reference info. [FCLM_BAM_REFZL]
    DTAAI,                    -- DME identifictn [FCLM_BAM_DTAAI]
    BNKN2,                    -- Altern.Acct No. [BNKN2]
    IS_REUSED,                -- Is Reused [FCLM_BAM_HBA_REUSED_FLAG]
    FDGRP,                    -- Planning group [FDGRP]
    ABWAE,                    -- Settlement cur. [ABWAE]
    HKONT,                    -- G/L Acct [HKONT]
    WEKON,                    -- Discount Acct [WEKON]
    MINDT,                    -- Minimum Days [MINDT]
    HBID1,                    -- House bank 1 [HBID1_012K]
    HKID1,                    -- Account ID 1 [HKID1_012K]
    HBID2,                    -- House bank 2 [HBID2_012K]
    HKID2,                    -- Account ID 2 [HKID2_012K]
    WKKON,                    -- Returned BoE Py [WKKON_012K]
    WIKON,                    -- Collection Acct [WIKON_012K]
    NEW_BACL_FLAG,            -- Use New G/L Account [FCLM_BAM_NEW_BACL_FLAG]
    OLD_HKONT,                -- G/L Acct [HKONT]
    MIGRATION_STATUS,         -- Migration Status [FCLM_BAM_BACL_MIGRATION_STATUS]
    CASH_POOLING_FLAG,        -- Use in Cash Pooling [FCLM_BAM_CASH_POOLING_FLAG]
    BANK_ACCOUNT_AUTH_GROUP,  -- Authorization Group [BANK_ACCOUNT_AUTH_GROUP]
    NETTING_GROUP,            -- Netting Group [FCLM_BAM_NETTING_GROUP]
    TOGRU,                    -- Tolerance Group [TOGRU_S]
    XSPEB,                    -- Posting Block [XSPEB]
    POSTING_BLOCK_DATE,       -- Opening Date [FCLM_BAM_POSTING_BLOCK_DATE]
    TARGET_HKONT,             -- G/L Acct [HKONT]
    BALANCE_TRANSFER_DATE,    -- Transfer Date [FCLM_BAM_BALANCE_TRANSFER_DATE]
    BS_POST_CAT,              -- Post. Category (EoD) [FCLM_BS_POST_CAT]
    BS2FQM_MODE,              -- Transfer Mode (EoD) [FCLM_BS2FQM_MODE]
    PRIMARY KEY (MANDT, ACC_ID, GUID, REVISION)
);

Learn More