FCLM_BAM_DDL_AMD_REV0

CDS View
79 Fields 1 CDS Views

Rev 0 of FCLM_BAM_AMD_BASE

FCLM_BAM_DDL_AMD_REV0 is a CDS View in S/4HANA. Rev 0 of FCLM_BAM_AMD_BASE. It contains 79 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
VFCLM_BAM_DDL_AMD view from

Fields (79)

KeyField CDS FieldsUsed in Views
KEY acc_id AccountID 1
abwae abwae 1
acc_num AccountNumber 1
acc_type_id AccountType 1
account_cdhdr ChangeHistory 1
account_lims OverdraftLimits 1
account_sigs Signatories 1
account_supervisor AccountSupervisor 1
amt_diff DifferenceAmount 1
balstat_act DifferenceStatus 1
bank_contact BankContact 1
bankl BankKey 1
bankn bankn 1
banks BankCountry 1
beneficial AccountHolder 1
bnkn2 bnkn2 1
bs_upload_time BankStatementUpload 1
bukrs CompanyCode 1
calendar FactoryCalendar 1
cash_pool_id LeadingCashPoolID 1
cash_pool_id_participant ParticipantCashPoolID 1
changed_at_dat ChangedAtDate 1
changed_at_tim ChangedAtTime 1
changed_by ChangedBy 1
closed_at_dat ClosedAtDate 1
closed_at_tim ClosedAtTime 1
closed_by ClosedBy 1
company_contact CompanyContact 1
CompanyCodeDesp CompanyCodeDesp 1
control_key control_key 1
created_at_dat CreatedAtDate 1
created_at_tim CreatedAtTime 1
created_by CreatedBy 1
Currency Currency 1
cutoff_time_c CutOffCrossBorder 1
cutoff_time_d CutOffDomestic 1
deleted_flag deleted_flag 1
dtaai dtaai 1
edbsum edbsum,EoDImort 1
exp_number ExpectedInterval 1
exp_rhyth ControlFrequency 1
fdgrp fdgrp 1
gsber BusinessArea 1
hbid1 hbid1 1
hbid2 hbid2 1
hbkid hbkid 1
hkid1 hkid1 1
hkid2 hkid2 1
hkont hkont 1
hktid hktid 1
HouseBankCompanyCode HouseBankCompanyCode 1
HouseBankCompanyCodeDesp HouseBankCompanyCodeDesp 1
iban IBAN 1
iban_valid_from iban_valid_from 1
idbsum IntradayImport 1
importing_channel ImportingChannel 1
mindt mindt 1
opened_at_dat OpenedAtDate 1
opened_at_tim OpenedAtTime 1
opened_by OpenedBy 1
planned_closing_date PlannedClosingDate 1
prctr ProfitCenter 1
procstat_act ProcessingStatus 1
reconcile_intraday IntradayIsReconciled 1
reconstat_act ReconciliationStatus 1
refzl refzl 1
rel_manager RelationshipManager 1
segment Segment 1
serstat_act SerialNumberStatus 1
sort_idx DisplayItem 1
status Status 1
tolerance_group CashToleranceGroup 1
upload_bs_flag UploadBSFlag 1
valid_from ValidFrom 1
valid_to ValidTo 1
vgtyp TransactionCode 1
wekon wekon 1
wikon wikon 1
wkkon wkkon 1

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.

-- Rev 0 of FCLM_BAM_AMD_BASE
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_BAM_DDL_AMD_REV0 (
    ACC_ID,
    ABWAE,
    ACC_NUM,
    ACC_TYPE_ID,
    ACCOUNT_CDHDR,
    ACCOUNT_LIMS,
    ACCOUNT_SIGS,
    ACCOUNT_SUPERVISOR,
    AMT_DIFF,
    BALSTAT_ACT,
    BANK_CONTACT,
    BANKL,
    BANKN,
    BANKS,
    BENEFICIAL,
    BNKN2,
    BS_UPLOAD_TIME,
    BUKRS,
    CALENDAR,
    CASH_POOL_ID,
    CASH_POOL_ID_PARTICIPANT,
    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,
    DTAAI,
    EDBSUM,
    EXP_NUMBER,
    EXP_RHYTH,
    FDGRP,
    GSBER,
    HBID1,
    HBID2,
    HBKID,
    HKID1,
    HKID2,
    HKONT,
    HKTID,
    HOUSEBANKCOMPANYCODE,
    HOUSEBANKCOMPANYCODEDESP,
    IBAN,
    IBAN_VALID_FROM,
    IDBSUM,
    IMPORTING_CHANNEL,
    MINDT,
    OPENED_AT_DAT,
    OPENED_AT_TIM,
    OPENED_BY,
    PLANNED_CLOSING_DATE,
    PRCTR,
    PROCSTAT_ACT,
    RECONCILE_INTRADAY,
    RECONSTAT_ACT,
    REFZL,
    REL_MANAGER,
    SEGMENT,
    SERSTAT_ACT,
    SORT_IDX,
    STATUS,
    TOLERANCE_GROUP,
    UPLOAD_BS_FLAG,
    VALID_FROM,
    VALID_TO,
    VGTYP,
    WEKON,
    WIKON,
    WKKON,
    PRIMARY KEY (ACC_ID)
);

Learn More