FCLM_BAM_AMD
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA