FCLM_BAM_AMD

CDS View

FCLM_BAM_AMD is a CDS View in S/4HANA. It contains 80 fields. 52 CDS views read from this table.

CDS Views using this table (52)

ViewTypeJoinVDMDescription
E_BankAccount view from EXTENSION
ESH_N_HOUSEBANKACCT_BAM_AM_AMD view from Bank Account Master Data
FAC_AUDIT_Z3_BANK_REC_MASTER view from Bank Account Master Data
FAR_DP_MERCHANT view inner Merchant Account for SAP Digital Payments add-on
FCLM_BAH_ACCOUNT_VH view from Value help for bank account in hierarchy
FCLM_BALANCE_ACCOUNT view from Account with manual balance
FCLM_BAM_ACCOUNT_VH view from Bank Account Value Help
FCLM_BAM_AMD_FOR_DPP view from BAM AMD view for DPP
FCLM_BAM_AMD_STS_CHANGE_HIST view inner Bank Account Status Change History
fclm_bam_balance_acct_vh view left_outer Value help for all account linkages
FCLM_BAM_DDL_AMD_DB view from Base View for AMD
FCLM_BAM_DISTINCT_HBA view inner distinct house bank accounts for T012K
FCLM_BAM_HBA_ENHANCED view inner house bank accounts for T012K_ENHANCED
Fclm_Bam_Revision view from BAM revision list
fclm_bam_shlp_acctid view from 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_BankAccountBasicData view from BASIC Basic Data of Bank Account Master Data
I_BankAccountBasicDataEnhanced view from BASIC Basic Data of Bank Account Master Data with Opened at Bank
I_BankAccountCurrency view from BASIC Bank Account Currency
I_BankAccountCurrencyRev view from BASIC Bank Account Currency with Revisions
I_BankAccountMultipleLinkage view inner BASIC Bank Account Multi Linkages
I_BankAccountOverdraftLimit view inner BASIC Bank Account Overdraft Limit
I_BankAccountTP view from TRANSACTIONAL Bank Account BO active and draft
I_BankAccountValidLinkage view inner BASIC Bank Account Valid Linkages
I_BankAccountWithRevision view left_outer BASIC Bank Account With Revision
I_BankAccRevision view left_outer BASIC Bank Account Revision Status
I_BankAcctApplAccountVH view from BASIC Application Created Bank Accounts
I_BankAcctIdVH view from BASIC Bank Account ID value help
I_BankAcctNumberVH view from BASIC Account Number
I_BankAcctTwoPersonAllReq view inner BASIC Bank Account Change Requests of Two Person Verification Mode
I_BankAcctWithDesc view from BASIC Bank Account with description
I_BankAccTwoPersonReq view inner BASIC Bank Account Two Person mode request
I_BkAcctIntIDVH view from BASIC Technical ID
I_BkAcctRevisionEmlTmpl view from BASIC Email Template for Bank Account Revision
I_BkRelshpDocBkAcctBasic view_entity from BASIC Basic data of bank accounts in bank doc
I_BPHierarchyCore view from BASIC Business Person based Hierarchy Core
I_RequestWithBankAccount view inner BASIC Bank Accounts in Change Request
I_ValidBankAccountWithRevision view from BASIC Non-deleted Bank Accts With revision
P_BankAccount_All view from BASIC
P_BANKACCOUNTLINKAGE view inner BASIC Bank Account Valid Linkages
P_BankaccountWithBGN view from BASIC
P_HouseBankAccount view inner BASIC
P_HouseBankAccountDesc view inner BASIC
P_HouseBankAccountText view inner BASIC
R_BankAccount view_entity from BASIC Bank Accounts
SHSM_FCLM_BAM_EXPORT_ACCOUNT view from Bank Account Value Help
V_T012k_Bam_Sh_Ddl view inner DDL Source for Value Help on T012K
VFCLM_BAM_AMD_CUR_REV view from
VFCLM_BAM_DDL_AMD_CUR view from
VFCLM_BAM_DDL_AMD_CUR_F view from
VFCLM_BAM_DDL_HOUSEBANKACCOUNT view inner

Fields (80)

KeyField CDS FieldsUsed in Views
KEY acc_id acc_id,BankAccountInternalID 21
KEY bukrs AccountCompanyCode,bukrs,CompanyCode 22
KEY revision BankAccountRevision,revision 11
KEY waers BankAccountCurrency,CashPoolCurrency,Currency,waers 22
acc_num acc_num,BankAccount,BankAccountNumber 24
acc_type_id acc_type_id,AccountType,BankAccountType 21
account_supervisor account_supervisor,BankAccountSupervisor 4
amt_diff amt_diff,DifferenceAmount 2
balstat_act balstat_act,DifferenceStatus 2
bank_contact bank_contact,BankContactPerson 5
bankl Bank,BankKey,bankl 18
banks BankCountry,banks 18
beneficial BankAccountHolderName,beneficial 5
bs_upload_time BankStatementCheckTime,bs_upload_time 4
bsr_group BankStmntReconciliationGrp 1
calendar calendar,FactoryCalendar 2
cash_pool cash_pool 2
cash_pool_id cash_pool_id,LeadingCashPoolID 5
cash_pool_id_participant cash_pool_id_participant,ParticipantCashPoolID 4
cash_pool_target_amt_max MaxTargetAmount 3
cash_pool_target_amt_min MinTargetAmount 2
cash_pool_transfer_amt_max MaxTransferAmount 1
cash_pool_transfer_amt_min MinTransferAmount 2
changed_at changed_at 2
changed_at_dat changed_at_dat,LastChangeDate 6
changed_at_tim changed_at_tim,LastChangeTime 5
changed_by changed_by,LastChangedByUser 5
closed_at closed_at 2
closed_at_dat closed_at_dat,ClosedDate 4
closed_at_tim closed_at_tim,ClosedTime 4
closed_by closed_by,ClosedByUser 4
company_contact company_contact,CompanyContactPerson 4
control_key BankControlKey,bkont,control_key 9
created_at created_at 2
created_at_dat created_at_dat,CreationDate 5
created_at_tim created_at_tim,CreationTime 5
created_by created_by,CreatedByUser 5
cutoff_time_c CrossBorderCutOffTime,cutoff_time_c 4
cutoff_time_d cutoff_time_d,DomesticCutOffTime 4
deleted_flag deleted_flag,IsMarkedForDeletion 4
dummy_fclm_bam_amd_incl_eew_ps dummy_fclm_bam_amd_incl_eew_ps 1
edbsum BankStatementImportMethod,edbsum 4
exp_number exp_number,ExpectedInterval 2
exp_rhyth ControlFrequency,exp_rhyth 2
ext_rule_id IntraBkStaRuleExternalID 1
gsber BusinessArea,gsber 8
iban IBAN 15
iban_valid_from iban_valid_from,IBANValidityStartDate 4
idbsum idbsum,IntraDayBankStateImportMethod 4
ihb_servicer IHBAccountHolder 1
importing_channel BankStatementImportChannel,importing_channel 4
mandt mandt 2
objnr ArchObjectNumber,objnr 3
opened_at opened_at 2
opened_at_dat opened_at_dat,OpenedDate 4
opened_at_tim opened_at_tim,OpenedTime 3
opened_by opened_by,OpenedByUser 4
payment_method_l LeadingPaymentMethod 3
payment_method_p ParticipantPaymentMethod 3
payment_service_provider payment_service_provider,PaymentServiceProvider 2
planned_closing_date planned_closing_date,PlannedClosingDate 4
planning_level PlanningLevel 1
prctr prctr,ProfitCenter 9
procstat_act ProcessingStatus,procstat_act 2
reconcile_endofday EndOfDayIsReconciled 1
reconcile_intraday IntradayIsReconciled,reconcile_intraday 3
reconstat_act ReconciliationStatus,reconstat_act 2
rel_manager BankRelationshipManager,rel_manager 5
reviewed_at reviewed_at 2
reviewed_by reviewed_by,ReviewedByUser 4
segment segment 9
serstat_act SerialNumberStatus,serstat_act 2
sgtxt Note 1
sort_idx DisplayItem,sort_idx 2
status BankAccountStatus,status 17
tolerance_group CashToleranceGroup,tolerance_group 3
upload_bs_flag IsUploadOfIntraDayStatement,upload_bs_flag 4
valid_from valid_from,ValidityStartDate 6
valid_to valid_to,ValidityEndDate 6
vgtyp PaymentTransactionTypeGroup,vgtyp 3

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_BAM_AMD (
    ACC_ID,
    BUKRS,
    REVISION,
    WAERS,
    ACC_NUM,
    ACC_TYPE_ID,
    ACCOUNT_SUPERVISOR,
    AMT_DIFF,
    BALSTAT_ACT,
    BANK_CONTACT,
    BANKL,
    BANKS,
    BENEFICIAL,
    BS_UPLOAD_TIME,
    BSR_GROUP,
    CALENDAR,
    CASH_POOL,
    CASH_POOL_ID,
    CASH_POOL_ID_PARTICIPANT,
    CASH_POOL_TARGET_AMT_MAX,
    CASH_POOL_TARGET_AMT_MIN,
    CASH_POOL_TRANSFER_AMT_MAX,
    CASH_POOL_TRANSFER_AMT_MIN,
    CHANGED_AT,
    CHANGED_AT_DAT,
    CHANGED_AT_TIM,
    CHANGED_BY,
    CLOSED_AT,
    CLOSED_AT_DAT,
    CLOSED_AT_TIM,
    CLOSED_BY,
    COMPANY_CONTACT,
    CONTROL_KEY,
    CREATED_AT,
    CREATED_AT_DAT,
    CREATED_AT_TIM,
    CREATED_BY,
    CUTOFF_TIME_C,
    CUTOFF_TIME_D,
    DELETED_FLAG,
    DUMMY_FCLM_BAM_AMD_INCL_EEW_PS,
    EDBSUM,
    EXP_NUMBER,
    EXP_RHYTH,
    EXT_RULE_ID,
    GSBER,
    IBAN,
    IBAN_VALID_FROM,
    IDBSUM,
    IHB_SERVICER,
    IMPORTING_CHANNEL,
    MANDT,
    OBJNR,
    OPENED_AT,
    OPENED_AT_DAT,
    OPENED_AT_TIM,
    OPENED_BY,
    PAYMENT_METHOD_L,
    PAYMENT_METHOD_P,
    PAYMENT_SERVICE_PROVIDER,
    PLANNED_CLOSING_DATE,
    PLANNING_LEVEL,
    PRCTR,
    PROCSTAT_ACT,
    RECONCILE_ENDOFDAY,
    RECONCILE_INTRADAY,
    RECONSTAT_ACT,
    REL_MANAGER,
    REVIEWED_AT,
    REVIEWED_BY,
    SEGMENT,
    SERSTAT_ACT,
    SGTXT,
    SORT_IDX,
    STATUS,
    TOLERANCE_GROUP,
    UPLOAD_BS_FLAG,
    VALID_FROM,
    VALID_TO,
    VGTYP,
    PRIMARY KEY (ACC_ID, BUKRS, REVISION, WAERS)
);