FCLM_BAM_DDL_AMD_BASE_NO_HBA

CDS View
44 Fields 12 CDS Views

Base view for AMD without multiple HBA

FCLM_BAM_DDL_AMD_BASE_NO_HBA is a CDS View in S/4HANA. Base view for AMD without multiple HBA. It contains 44 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
Fclm_Bam_Amdwithau view from Bank account data with authorization
FCLM_BAM_DOC_DM_BK_ATTR view from Active Company Code List of FI
Fclm_Bm_Company_Used view inner Bank data of company used
VFCLM_BAM_DDL_ACCLINK view from Basic DDL for Account Linakgae
VFCLM_BAM_DDL_ACCLINK view union_all Basic DDL for Account Linakgae
VFCLM_BAM_DDL_ACCOUNTINAPPROC view inner Bank Accounts in Approval Process
VFCLM_BAM_DDL_ACCOUNTINBANK view from Account List in Bank
VFCLM_BAM_DDL_ACCOUNTPREQUEST view from Bank Account With Change Request Information
VFCLM_BAM_DDL_AMD_WTTHDESP view from Bank Account Master Data With Description
VFCLM_BAM_DDL_FBAR06A view inner Additional view for sixth view of FBAR
VFCLM_BAM_DDL_HIERNODECORE view from Hierarchy Node Core Attributes
VFCLM_BAM_DDL_REQHIST view inner Change Request History

Fields (44)

KeyField CDS FieldsUsed in Views
KEY acc_id acc_id,AccountID 5
KEY bankl BankInternalId,BankKey,bankl 8
KEY banks BankCountry,banks 8
KEY bukrs bukrs,CompanyCode 8
acc_num acc_num,AccountNumber 7
acc_type_id acc_type_id,AccountType 6
account_supervisor account_supervisor,AccountSupervisor 4
bank_contact bank_contact,BankContact 5
beneficial AccountHolder,beneficial 5
bs_upload_time BankStatementUpload,bs_upload_time 2
changed_at_dat ChangedAtDate 1
changed_at_tim ChangedAtTime 1
changed_by changed_by,ChangedBy 2
closed_at_dat ClosedAtDate 1
closed_at_tim ClosedAtTime 1
closed_by closed_by,ClosedBy 2
company_contact company_contact,CompanyContact 4
CompanyCodeDesp CompanyCodeDesp 2
control_key control_key 2
created_at_dat CreatedAtDate 1
created_at_tim CreatedAtTime 1
created_by created_by,CreatedBy 2
Currency Currency,waers 5
cutoff_time_c cutoff_time_c,CutOffCrossBorder 2
cutoff_time_d cutoff_time_d,CutOffDomestic 2
deleted_flag deleted_flag 1
edbsum edbsum,EoDImort 3
gsber BusinessArea,gsber 5
iban iban 5
iban_valid_from iban_valid_from 2
idbsum idbsum,IntradayImport 2
importing_channel importing_channel,ImportingChannel 4
mandt mandt 1
opened_at_dat OpenedAtDate 1
opened_at_tim OpenedAtTime 1
opened_by opened_by,OpenedBy 2
planned_closing_date planned_closing_date,PlannedClosingDate 3
prctr prctr,ProfitCenter 5
rel_manager rel_manager,RelationshipManager 4
segment segment 3
status status 5
upload_bs_flag upload_bs_flag,UploadBSFlag 2
valid_from valid_from,ValidFrom 5
valid_to valid_to,ValidTo 5

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.

-- Base view for AMD without multiple HBA
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_BAM_DDL_AMD_BASE_NO_HBA (
    ACC_ID,
    BANKL,
    BANKS,
    BUKRS,
    ACC_NUM,
    ACC_TYPE_ID,
    ACCOUNT_SUPERVISOR,
    BANK_CONTACT,
    BENEFICIAL,
    BS_UPLOAD_TIME,
    CHANGED_AT_DAT,
    CHANGED_AT_TIM,
    CHANGED_BY,
    CLOSED_AT_DAT,
    CLOSED_AT_TIM,
    CLOSED_BY,
    COMPANY_CONTACT,
    COMPANYCODEDESP,
    CONTROL_KEY,
    CREATED_AT_DAT,
    CREATED_AT_TIM,
    CREATED_BY,
    CURRENCY,
    CUTOFF_TIME_C,
    CUTOFF_TIME_D,
    DELETED_FLAG,
    EDBSUM,
    GSBER,
    IBAN,
    IBAN_VALID_FROM,
    IDBSUM,
    IMPORTING_CHANNEL,
    MANDT,
    OPENED_AT_DAT,
    OPENED_AT_TIM,
    OPENED_BY,
    PLANNED_CLOSING_DATE,
    PRCTR,
    REL_MANAGER,
    SEGMENT,
    STATUS,
    UPLOAD_BS_FLAG,
    VALID_FROM,
    VALID_TO,
    PRIMARY KEY (ACC_ID, BANKL, BANKS, BUKRS)
);

Learn More