FCLM_BRM_BSB

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.

-- Total of Bank Service Billing Statement
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCLM_BRM_BSB (
    MANDT,                           -- Client [mandt]
    BSB_UUID,                        -- UUID [fclm_brm_uuid]
    REPORT_ID,                       -- Report ID [fclm_brm_rptid]
    PAGE_NUMBER,                     -- Page Number [fclm_brm_page_number]
    LAST_PAGE_INDICATOR,             -- TRUE [boole_d]
    STATUS,                          -- Import Status [fclm_brm_import_status]
    GROUP_ID,                        -- Group ID [fclm_brm_grpid]
    SENDER_ID,                       -- Statement Sender ID [fclm_brm_sender_id]
    SENDER_OTHER_ID,                 -- Statement Sender ID [fclm_brm_sender_id]
    SENDER_NAME,                     -- Sender Name [fclm_brm_sender_name]
    SENDER_COUNTRY,                  -- Country/Reg. [land1]
    BANK_COUNTRY,                    -- Bank Ctry/Reg. [banks]
    BANK_KEY,                        -- Bank Key [bankk]
    RECEIVER_ID,                     -- Receiver ID [fclm_brm_receiver_id]
    RECEIVER_NAME,                   -- Receiver Name [fclm_brm_receiver_name]
    RECEIVER_COUNTRY,                -- Country/Reg. [land1]
    COMPANY_CODE,                    -- Company Code [bukrs]
    STATEMENT_ID,                    -- Statement ID [fclm_brm_stmtid]
    FROM_DATE,                       -- From Date [fclm_brm_from_date]
    TO_DATE,                         -- To Date [fclm_brm_to_date]
    CREATION_DATE_TIME,              -- Timestamp [fclm_brm_timestamp]
    CREATION_DATE,                   -- Created On [fclm_bam_created_on]
    CREATION_TIME,                   -- Created At [fclm_bam_created_at]
    STATEMENT_STATUS,                -- Status [fclm_brm_stmt_status]
    ACCOUNT_LEVEL,                   -- Account Level [fclm_brm_acct_lvl]
    ACCOUNT_ID_TYPE,                 -- Account ID Type [fclm_brm_acct_id_type]
    ACCOUNT_ID,                      -- Account Number [fclm_bam_acc_num]
    ACCOUNT_BAM_ID,                  -- Technical ID [fclm_bam_acc_id]
    ACCOUNT_TYPE,                    -- Account Type [fclm_brm_acct_type]
    ACCOUNT_CURRENCY,                -- Currency [waers]
    ACCOUNT_NAME,                    -- Account Name [fclm_brm_acct_name]
    ACCOUNT_SERVICER_ID,             -- Account Servicer ID [fclm_brm_account_servicer_id]
    ACCOUNT_SERVICER_NAME,           -- Servicer Name [fclm_brm_account_servicer_name]
    ACCOUNT_SERVICER_BRANCH_ID,      -- Servicer Branch ID [fclm_brm_acct_branch_id]
    ACCOUNT_SERVICER_BRANCH_NAME,    -- Servicer Branch Name [fclm_brm_acct_branch_name]
    PARENT_ACCOUNT_LEVEL,            -- Account Level [fclm_brm_acct_lvl]
    PARENT_ACCOUNT_ID_TYPE,          -- Account ID Type [fclm_brm_acct_id_type]
    PARENT_ACCOUNT_ID,               -- Account Number [fclm_bam_acc_num]
    PARENT_ACCOUNT_BAM_ID,           -- Technical ID [fclm_bam_acc_id]
    PARENT_ACCOUNT_TYPE,             -- Account Type [fclm_brm_acct_type]
    PARENT_ACCOUNT_CURRENCY,         -- Currency [waers]
    PARENT_ACCOUNT_NAME,             -- Account Name [fclm_brm_acct_name]
    PARENT_ACCOUNT_SERVICER_ID,      -- Account Servicer ID [fclm_brm_account_servicer_id]
    PARENT_ACCOUNT_SERVICER_NAME,    -- Servicer Name [fclm_brm_account_servicer_name]
    PARENT_ACCT_SERVICER_BRANCH_ID,  -- Servicer Branch ID [fclm_brm_acct_branch_id]
    PARENT_ACCT_SVCR_BRANCH_NAME,    -- Servicer Branch Name [fclm_brm_acct_branch_name]
    COMPENSATION_METHOD,             -- Compensation Method [fclm_brm_compstn_mtd]
    DEBIT_ACCOUNT_ID_TYPE,           -- Account ID Type [fclm_brm_acct_id_type]
    DEBIT_ACCOUNT_ID,                -- Account Number [fclm_bam_acc_num]
    DEBIT_ACCOUNT_BAM_ID,            -- Technical ID [fclm_bam_acc_id]
    DELAYED_DEBIT_DATE,              -- Delayed Debit Date [fclm_brm_delayed_debit_date]
    SETTLEMENT_ADVICE,               -- Description [fclm_brm_text120]
    ACCOUNT_BALANCE_CURRENCY,        -- Currency [waers]
    SETTLEMENT_CURRENCY,             -- Currency [waers]
    HOST_CURRENCY,                   -- Currency [waers]
    TAX_CALCULATION_METHOD,          -- Calculation Method [fclm_brm_tax_clctn_mtd]
    TAX_REGION,                      -- Region Number [fclm_brm_tax_region_number]
    TAX_AREA,                        -- Tax Area [fclm_brm_tax_area]
    RATE_ID,                         -- Rate ID [fclm_brm_rate_id]
    RATE_VALUE,                      -- Percentage [fclm_brm_percentage]
    DAYS_IN_PERIOD,                  -- INT2 [int2]
    DAYS_IN_YEARS,                   -- INT2 [int2]
    EXCHANGE_SOURCE_CCY,             -- Currency [waers]
    EXCHANGE_TARGET_CCY,             -- Currency [waers]
    EXCHANGE_RATE,                   -- Exchange Rate [fclm_brm_xchgrate]
    EXCHANGE_DESCRIPTION,            -- Description [fclm_brm_text40]
    EXCHANGE_UNIT_CURRENCY,          -- Currency [waers]
    EXCHANGE_COMMENT,                -- Description [fclm_brm_text70]
    EXCHANGE_QUOTATION_DATETIME,     -- Timestamp [fclm_brm_timestamp]
    EXCHANGE_QUOTATION_DATE,         -- Date [datum]
    EXCHANGE_QUOTATION_TIME,         -- Field of type TIMS [tims]
    BALANCE_TYPE,                    -- Balance Type [fclm_brm_bal_type]
    BALANCE_AMOUNT,                  -- Billing Amount [fclm_brm_amount]
    BALANCE_CURRENCY,                -- Currency [waers]
    BALANCE_CURRENCY_TYPE,           -- Currency Type [fclm_brm_ccy_type]
    COMPENSATION_TYPE,               -- Compensation Type [fclm_brm_compstn_type]
    COMPENSATION_AMOUNT,             -- Billing Amount [fclm_brm_amount]
    COMPENSATION_CURRENCY,           -- Currency [waers]
    COMPENSATION_CURRENCY_TYPE,      -- Currency Type [fclm_brm_ccy_type]
    SERVICE_ID,                      -- Billing Service ID [fclm_brm_svc_id]
    SERVICE_DESCRIPTION,             -- Description [fclm_brm_text70]
    SUB_SERVICE_ISSUER,              -- SubService Issuer ID [fclm_brm_sub_svc_issuer_id]
    SUB_SERVICE_ID,                  -- Sub Service ID [fclm_brm_sub_svc_id]
    SERVICE_COMMON_CODE_ISSUER,      -- Common Code Issuer [fclm_brm_svc_common_cd_issuer]
    SERVICE_COMMON_CODE,             -- Service Common Code [fclm_brm_svc_common_code]
    SERVICE_TYPE,                    -- Service Type [fclm_brm_svc_type]
    SERVICE_VOLUME,                  -- Volume [fclm_brm_volume]
    SERVICE_UNIT_PRICE,              -- Billing Amount [fclm_brm_amount]
    SERVICE_UNIT_PRICE_CURRENCY,     -- Currency [waers]
    BILLING_CHARGE_METHOD,           -- Charge Method [fclm_brm_charge_method]
    SERVICE_PRICING_RULE,            -- Price Rule [fclm_brm_svc_price_rule]
    PAYMENT_METHOD,                  -- Payment Method [fclm_brm_payment_method]
    ORIGINAL_CHARGE_PRICE,           -- Billing Amount [fclm_brm_amount]
    ORIGINAL_CHANGE_PRICE_CURRENCY,  -- Currency [waers]
    ORIGINAL_CHARGE_SETTLEMENT_AMT,  -- Billing Amount [fclm_brm_amount]
    ORIGINAL_CHARGE_SETTLEMENT_CCY,  -- Currency [waers]
    BALANCE_REQUIRED_ACCOUNT_AMT,    -- Billing Amount [fclm_brm_amount]
    BALANCE_REQUIRED_ACCOUNT_CCY,    -- Currency [waers]
    TAX_DESIGNATION_CODE,            -- Designation Code [fclm_brm_tax_dsgnt_code]
    TAX_DESIGNATION_REGION,          -- Region Number [fclm_brm_tax_region_number]
    TAX_REASON_CODE,                 -- Tax Reason Code [fclm_brm_tax_reason_code]
    TAX_REASON_EXPLANATION,          -- Description [fclm_brm_text120]
    TAX_SERVICE_CHARGE_HOST_AMOUNT,  -- Billing Amount [fclm_brm_amount]
    TAX_SERVICE_CHARGE_HOST_CCY,     -- Currency [waers]
    TAX_SERVICE_TAX_HOST_AMOUNT,     -- Billing Amount [fclm_brm_amount]
    TAX_SERVICE_TAX_HOST_CURRENCY,   -- Currency [waers]
    TAX_SERVICE_TAX_PRICING_AMT,     -- Billing Amount [fclm_brm_amount]
    TAX_SERVICE_TAX_PRICING_CCY,     -- Currency [waers]
    TAX_TOTAL_CHARGE_HOST_AMOUNT,    -- Billing Amount [fclm_brm_amount]
    TAX_TOTAL_CHARGE_HOST_CURRENCY,  -- Currency [waers]
    TAX_TOTAL_CHARGE_STTLM_AMT,      -- Billing Amount [fclm_brm_amount]
    TAX_TOTAL_CHARGE_STTLM_CCY,      -- Currency [waers]
    TAX_TOTAL_CHARGE_PRICG_AMT,      -- Billing Amount [fclm_brm_amount]
    TAX_TOTAL_CHARGE_PRICG_CCY,      -- Currency [waers]
    TAX_REGION_NUMBER,               -- Region Number [fclm_brm_tax_region_number]
    TAX_REGION_NAME,                 -- Region Name [fclm_brm_tax_region_name]
    TAX_REGION_CUSTOMER_TAX_ID,      -- Customer Tax ID [fclm_brm_customer_tax_id]
    TAX_REGION_POINT_DATE,           -- Point Date [fclm_brm_point_date]
    TAX_REGION_SENDING_FI_VAT_NB,    -- VAT Number [fclm_brm_vat_reg_number]
    TAX_REGION_SENDING_FI_TAX_NB,    -- Tax Number [fclm_brm_tax_reg_number]
    TAX_REGION_INVOICE_NUMBER,       -- Invoice Number [fclm_brm_invoice_number]
    TAX_CALCULATION_HOST_CURRENCY,   -- Currency [waers]
    TOTAL_TAXABLE_SVC_CHRG_HST_AMT,  -- Billing Amount [fclm_brm_amount]
    TOTAL_TAXABLE_SVC_CHRG_HST_CCY,  -- Currency [waers]
    TAX_ID_TOTAL_TAX_AMOUNT,         -- Billing Amount [fclm_brm_amount]
    TAX_ID_TOTAL_TAX_CURRENCY,       -- Currency [waers]
    TAX_REGION_SETTLEMENT_AMOUNT,    -- Billing Amount [fclm_brm_amount]
    TAX_REGION_SETTLEMENT_CURRENCY,  -- Currency [waers]
    TAX_DUE_TO_REGION_AMOUNT,        -- Billing Amount [fclm_brm_amount]
    TAX_DUE_TO_REGION_CURRENCY,      -- Currency [waers]
    BALANCE_ADJUSTMENT_TYPE,         -- Adjustment Type [fclm_brm_bal_adjustment_type]
    BALANCE_ADJUSTMENT_DESCRIPTION,  -- Description [fclm_brm_text120]
    BALANCE_ADJUSTMENT_BALANCE_AMT,  -- Billing Amount [fclm_brm_amount]
    BALANCE_ADJUSTMENT_BALANCE_CCY,  -- Currency [waers]
    BALANCE_ADJUSTMENT_AVERAGE_AMT,  -- Billing Amount [fclm_brm_amount]
    BALANCE_ADJUSTMENT_AVERAGE_CCY,  -- Currency [waers]
    BALANCE_ADJUSTMENT_ERROR_DATE,   -- Error Date [fclm_brm_error_date]
    BALANCE_ADJUSTMENT_POSTING_DT,   -- Posting Date [fclm_brm_posting_date]
    BALANCE_ADJUSTMENT_DAYS,         -- INT2 [int2]
    BALANCE_EARNINGS_ADJSTMNT_AMT,   -- Billing Amount [fclm_brm_amount]
    BALANCE_EARNINGS_ADJSTMNT_CCY,   -- Currency [waers]
    SERVICE_ADJUSTMENT_TYPE,         -- Adjustment Type [fclm_brm_svc_adjustment_type]
    SERVICE_ADJUSTMENT_DESCRIPTION,  -- Description [fclm_brm_text120]
    SERVICE_ADJUSTMENT_AMOUNT,       -- Billing Amount [fclm_brm_amount]
    SERVICE_ADJUSTMENT_CURRENCY,     -- Currency [waers]
    SVC_ADJSTMNT_BALANCE_REQRD_AMT,  -- Billing Amount [fclm_brm_amount]
    SVC_ADJSTMNT_BALANCE_REQRD_CCY,  -- Currency [waers]
    SERVICE_ADJUSTMENT_ERROR_DATE,   -- Error Date [fclm_brm_error_date]
    SVC_ADJUSTMENT_SERVICE_ID,       -- Billing Service ID [fclm_brm_svc_id]
    SVC_ADJUSTMENT_SUB_SVC_ISSUER,   -- SubService Issuer ID [fclm_brm_sub_svc_issuer_id]
    SVC_ADJUSTMENT_SUB_SERVICE_ID,   -- Sub Service ID [fclm_brm_sub_svc_id]
    SVC_ADJSTMNT_PRICE_CHANGE_AMT,   -- Billing Amount [fclm_brm_amount]
    SVC_ADJSTMNT_PRICE_CHANGE_CCY,   -- Currency [waers]
    SVC_ADJSTMNT_ORGNL_PRICE_AMT,    -- Billing Amount [fclm_brm_amount]
    SVC_ADJSTMNT_ORGNL_PRICE_CCY,    -- Currency [waers]
    SVC_ADJSTMNT_NEW_PRICE_AMT,      -- Billing Amount [fclm_brm_amount]
    SVC_ADJSTMNT_NEW_PRICE_CCY,      -- Currency [waers]
    SVC_ADJSTMNT_VOLUME_CHANGE,      -- Volume [fclm_brm_volume]
    SVC_ADJSTMNT_ORIGINAL_VOLUME,    -- Volume [fclm_brm_volume]
    SVC_ADJSTMNT_NEW_VOLUME,         -- Volume [fclm_brm_volume]
    SVC_ADJSTMNT_ORGNL_CHRG_AMT,     -- Billing Amount [fclm_brm_amount]
    SVC_ADJSTMNT_ORGNL_CHRG_CCY,     -- Currency [waers]
    SVC_ADJSTMNT_NEW_CHRG_AMT,       -- Billing Amount [fclm_brm_amount]
    SVC_ADJSTMNT_NEW_CHRG_CCY,       -- Currency [waers]
    VALIDATION_STATUS,               -- Service pricing status [fclm_brm_service_pricing_sts]
    CALCD_PRICE,                     -- Billing Amount [fclm_brm_amount]
    CONDAREA,                        -- Condition Area [bkk_condar]
    COND,                            -- fclm_fee_cond_id
    VALIDFROM,                       -- From Date [fclm_brm_from_date]
    PRIMARY KEY (MANDT, BSB_UUID)
);