TISU_CSMLDOCI_BR
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_ISU_CSML_SIMULATEDDOCVH_BR | view | inner | BASIC | |
| P_ISU_CSMLDOCIB_BR | view | from | BASIC |
Fields (31)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA