FCLM_BAM_ACLINK2

Transparent Table Application Table
30 Fields 27 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 30 fields. 27 CDS views read from this table.

CDS Views using this table (27)

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_entity 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_BankAccountAllLinkage view_entity from BASIC Bank Account Linkage for Expired HBAccts
I_BankAccountMultipleLinkage view from BASIC Bank Account Multi Linkages
I_BankAccountValidLinkage view from BASIC Bank Account Valid Linkages
I_BkAcctAndHsBkAcctLinkage view_entity from COMPOSITE Linkages Between BkAcc and HouseBkAcc
I_BkAcctLinkageWthRevision view from BASIC Bk Acct Connectivity Path with Revision
I_MaxValdHsBkAcctsInBkAcct view_entity from COMPOSITE Max Valid House Bank Account
P_BANKACCOUNTLINKAGE view_entity from BASIC Bank Account Valid Linkages
P_HouseBankAccount view inner BASIC House Bank Account
P_HouseBankAccountDesc view_entity from BASIC Description of House Bank Account
P_HouseBankAccountText view inner BASIC House Bank Account Name
V_T012k_Bam_Sh_Ddl view inner DDL Source for Value Help on T012K
VFCLM_BAM_DDL_ACCLINK view left_outer Basic DDL for Account Linakgae
VFCLM_BAM_DDL_HIERNODECORE view left_outer Hierarchy Node Core Attributes
VFCLM_BAM_DDL_HOUSEBANKACCOUNT view inner House Bank Account

Fields (30)

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
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 fclm_bam_xspeb
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]
    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,                    -- fclm_bam_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