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,                            -- Condition [BKK_CON]
    VALIDFROM,                       -- From Date [FCLM_BRM_FROM_DATE]
    PRIMARY KEY (MANDT, BSB_UUID)
);