FCLM_BAM_DDL_AMD_BASE

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_BAM_DDL_AMD_BASE (
    ACC_ID,
    REVISION,
    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,
    CASH_POOL_ID,
    CASH_POOL_ID_PARTICIPANT,
    CHANGED_AT,
    CHANGED_AT_DAT,
    CHANGED_AT_TIM,
    CHANGED_BY,
    CLOSED_AT,
    CLOSED_AT_DAT,
    CLOSED_AT_TIM,
    CLOSED_BY,
    COMPANY_CONTACT,
    COMPANYCODEDESP,
    CONTROL_KEY,
    CREATED_AT,
    CREATED_AT_DAT,
    CREATED_AT_TIM,
    CREATED_BY,
    CURRENCY,
    CUTOFF_TIME_C,
    CUTOFF_TIME_D,
    DELETED_FLAG,
    DTAAI,
    DUMMY_FCLM_BAM_AMD_INCL_EEW_PS,
    EDBSUM,
    EXP_NUMBER,
    EXP_RHYTH,
    FDGRP,
    GSBER,
    HBID1,
    HBID2,
    HBKID,
    HKID1,
    HKID2,
    HKONT,
    HKTID,
    HOUSEBANKCOMPANYCODE,
    HOUSEBANKCOMPANYCODEDESP,
    IBAN,
    IBAN_VALID_FROM,
    IDBSUM,
    IMPORTING_CHANNEL,
    MANDT,
    MINDT,
    OPENED_AT,
    OPENED_AT_DAT,
    OPENED_AT_TIM,
    OPENED_BY,
    PLANNED_CLOSING_DATE,
    PRCTR,
    PROCSTAT_ACT,
    RECONCILE_INTRADAY,
    RECONSTAT_ACT,
    REFZL,
    REL_MANAGER,
    REVIEWED_AT,
    REVIEWED_BY,
    SEGMENT,
    SERSTAT_ACT,
    SORT_IDX,
    STATUS,
    TOLERANCE_GROUP,
    UPLOAD_BS_FLAG,
    VALID_FROM,
    VALID_TO,
    VGTYP,
    WEKON,
    WIKON,
    WKKON,
    PRIMARY KEY (ACC_ID, REVISION)
);