TISU_CSMLDOCI_BR

Transparent Table Application Table

IS-U-BR Bill.Sim: Item Table for Comparison

TISU_CSMLDOCI_BR is an SAP database table in S/4HANA. IS-U-BR Bill.Sim: Item Table for Comparison. It contains 31 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_ISU_CSML_SIMULATEDDOCVH_BR view inner BASIC
P_ISU_CSMLDOCIB_BR view from BASIC

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY scenario_id deisu_scenario_id_br Scenario ID
KEY billing_document e_belnr Billing Doc.No.
KEY print_document deisu_orig_printdoc_br Print Orig. Doc.
KEY simulated_print_document deisu_s_printdoc_br Sim. Print Doc.
KEY sequential_item deisu_seq_item_number_br Sequential Item
posting_date budat Posting Date
installation anlage Installation
contract vertrag Contract
business_partner bu_partner Busn. Partner
begin_bill_period deisu_start_period_calc_br Start Period Calc.
end_bill_period deisu_end_period_calc_br End Period Calc.
billing_line_item_from deisu_presort_billline_from_br Presort. Bill Itm Fr
line_item_type_from deisu_line_item_from_br Line Item From
transaction_key_from deisu_transaction_key_from_br Transaction Key From
presort_billing_line_from deisu_presort_billline_from_br Presort. Bill Itm Fr
subtransaction_from deisu_subtransaction_br Bill. Subtrans.
main_transacion_from deisu_maintransaction_br Main Trans.
original_net_amount deisu_net_amount_siml_br Net Amount Sim From
billing_line_item_to deisu_presort_bill_line_to_br Presort. Bill Itm To
line_item_type_to deisu_line_item_to_br Line Item To
transaction_key_to deisu_transaction_key_to_br Transaction Key To
presort_billing_line_to deisu_presort_bill_line_to_br Presort. Bill Itm To
subtransaction_to deisu_subtransaction_br Bill. Subtrans.
main_transacion_to deisu_maintransaction_br Main Trans.
simulated_net_amount deisu_net_amount_siml_to_br Net Amount Sim To
rejection_status deisu_rejection_status_br Status
fica_posting_document opbel_kk Document Number
fica_posting_status deisu_fica_posting_status_br FI-CA Post Status
currency deisu_currency_br Currency
document_type blart_kk Document Type

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.

-- IS-U-BR Bill.Sim: Item Table for Comparison
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TISU_CSMLDOCI_BR (
    MANDT,                      -- Client [mandt]
    SCENARIO_ID,                -- Scenario ID [deisu_scenario_id_br]
    BILLING_DOCUMENT,           -- Billing Doc.No. [e_belnr]
    PRINT_DOCUMENT,             -- Print Orig. Doc. [deisu_orig_printdoc_br]
    SIMULATED_PRINT_DOCUMENT,   -- Sim. Print Doc. [deisu_s_printdoc_br]
    SEQUENTIAL_ITEM,            -- Sequential Item [deisu_seq_item_number_br]
    POSTING_DATE,               -- Posting Date [budat]
    INSTALLATION,               -- Installation [anlage]
    CONTRACT,                   -- Contract [vertrag]
    BUSINESS_PARTNER,           -- Busn. Partner [bu_partner]
    BEGIN_BILL_PERIOD,          -- Start Period Calc. [deisu_start_period_calc_br]
    END_BILL_PERIOD,            -- End Period Calc. [deisu_end_period_calc_br]
    BILLING_LINE_ITEM_FROM,     -- Presort. Bill Itm Fr [deisu_presort_billline_from_br]
    LINE_ITEM_TYPE_FROM,        -- Line Item From [deisu_line_item_from_br]
    TRANSACTION_KEY_FROM,       -- Transaction Key From [deisu_transaction_key_from_br]
    PRESORT_BILLING_LINE_FROM,  -- Presort. Bill Itm Fr [deisu_presort_billline_from_br]
    SUBTRANSACTION_FROM,        -- Bill. Subtrans. [deisu_subtransaction_br]
    MAIN_TRANSACION_FROM,       -- Main Trans. [deisu_maintransaction_br]
    ORIGINAL_NET_AMOUNT,        -- Net Amount Sim From [deisu_net_amount_siml_br]
    BILLING_LINE_ITEM_TO,       -- Presort. Bill Itm To [deisu_presort_bill_line_to_br]
    LINE_ITEM_TYPE_TO,          -- Line Item To [deisu_line_item_to_br]
    TRANSACTION_KEY_TO,         -- Transaction Key To [deisu_transaction_key_to_br]
    PRESORT_BILLING_LINE_TO,    -- Presort. Bill Itm To [deisu_presort_bill_line_to_br]
    SUBTRANSACTION_TO,          -- Bill. Subtrans. [deisu_subtransaction_br]
    MAIN_TRANSACION_TO,         -- Main Trans. [deisu_maintransaction_br]
    SIMULATED_NET_AMOUNT,       -- Net Amount Sim To [deisu_net_amount_siml_to_br]
    REJECTION_STATUS,           -- Status [deisu_rejection_status_br]
    FICA_POSTING_DOCUMENT,      -- Document Number [opbel_kk]
    FICA_POSTING_STATUS,        -- FI-CA Post Status [deisu_fica_posting_status_br]
    CURRENCY,                   -- Currency [deisu_currency_br]
    DOCUMENT_TYPE,              -- Document Type [blart_kk]
    PRIMARY KEY (MANDT, SCENARIO_ID, BILLING_DOCUMENT, PRINT_DOCUMENT, SIMULATED_PRINT_DOCUMENT, SEQUENTIAL_ITEM)
);