TISU_METERINF_BR
IS-U-BR Dwnld.Upld: Tracking MReading Information BR
TISU_METERINF_BR is an SAP database table in S/4HANA. IS-U-BR Dwnld.Upld: Tracking MReading Information BR. It contains 28 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_ISU_DU_DOWNLOAD_OBJECT_VH_BR | view | from | BASIC | |
| P_ISU_DU_MATERIAL_BR | view | from | BASIC | |
| P_ISU_DU_MR_DOCMT_VH_BR | view | from | BASIC | |
| P_ISU_DU_MR_UNIT_VH_BR | view | from | BASIC | |
| P_UtilitiesDownload | view | from | BASIC |
Fields (28)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | object_id | DEISU_DOWNLOAD_ID_BR | Download ID | |||
| KEY | meter_reader_unit | ABLEINHEIT | MR Unit | |||
| KEY | scheduled_meter_reading_date | ADATSOLL | Scheduled MRD | |||
| KEY | meter_reading_document | ABLBELNR | Int. MR doc. ID | |||
| contract | VERTRAG | Contract | ||||
| material_number | MATNR | Material | ||||
| object_status | DEISU_DOWNLOAD_STATUS_BR | Object Status | ||||
| download_date | DEISU_DOWNLOAD_DATE | Download Date | ||||
| download_execution_date | DEISU_DOWNLD_EXECUTION_DATE_BR | Download Date | ||||
| download_user | UNAME | User Name | ||||
| download_execution_hour | DEISU_DOWNLD_EXECUTION_HOUR_BR | Download Hour | ||||
| target_system_id | DEISU_TARGET_SYSTEM_ID_BR | ID Target Group | ||||
| meter_reading_reason | ABLESGR | MR reason | ||||
| installation | ANLAGE | Installation | ||||
| industry_system | BU_ISTYPE | Industry System | ||||
| meter_reading_center | ABL_Z | MR center | ||||
| meter_reading_date_relevant_to | ADAT | MR date | ||||
| equipment_number | EQUNR | Equipment | ||||
| register | E_ZWNUMMER | Register | ||||
| meter_reading_type | ISTABLART | MR type | ||||
| target_system_timestamp | DEISU_TRGT_SYS_TIMESTAMP_BR | Trgt Sys Timestamp | ||||
| upload_date | DEISU_UPLOAD_DATE_BR | Upload Date | ||||
| upload_hour | DEISU_UPLOAD_HOUR_BR | Upload Hour | ||||
| upload_user | DEISU_UPLOAD_USER_BR | Upload User | ||||
| reverse_date | DEISU_REVERSE_DATE_BR | Reverse Date | ||||
| reverse_hour | DEISU_REVERSE_HOUR_BR | Reverse Hour | ||||
| reverse_user | DEISU_REVERSE_USER_BR | Reverse User |
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 Dwnld.Upld: Tracking MReading Information BR
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TISU_METERINF_BR (
MANDT, -- Client [MANDT]
OBJECT_ID, -- Download ID [DEISU_DOWNLOAD_ID_BR]
METER_READER_UNIT, -- MR Unit [ABLEINHEIT]
SCHEDULED_METER_READING_DATE, -- Scheduled MRD [ADATSOLL]
METER_READING_DOCUMENT, -- Int. MR doc. ID [ABLBELNR]
CONTRACT, -- Contract [VERTRAG]
MATERIAL_NUMBER, -- Material [MATNR]
OBJECT_STATUS, -- Object Status [DEISU_DOWNLOAD_STATUS_BR]
DOWNLOAD_DATE, -- Download Date [DEISU_DOWNLOAD_DATE]
DOWNLOAD_EXECUTION_DATE, -- Download Date [DEISU_DOWNLD_EXECUTION_DATE_BR]
DOWNLOAD_USER, -- User Name [UNAME]
DOWNLOAD_EXECUTION_HOUR, -- Download Hour [DEISU_DOWNLD_EXECUTION_HOUR_BR]
TARGET_SYSTEM_ID, -- ID Target Group [DEISU_TARGET_SYSTEM_ID_BR]
METER_READING_REASON, -- MR reason [ABLESGR]
INSTALLATION, -- Installation [ANLAGE]
INDUSTRY_SYSTEM, -- Industry System [BU_ISTYPE]
METER_READING_CENTER, -- MR center [ABL_Z]
METER_READING_DATE_RELEVANT_TO, -- MR date [ADAT]
EQUIPMENT_NUMBER, -- Equipment [EQUNR]
REGISTER, -- Register [E_ZWNUMMER]
METER_READING_TYPE, -- MR type [ISTABLART]
TARGET_SYSTEM_TIMESTAMP, -- Trgt Sys Timestamp [DEISU_TRGT_SYS_TIMESTAMP_BR]
UPLOAD_DATE, -- Upload Date [DEISU_UPLOAD_DATE_BR]
UPLOAD_HOUR, -- Upload Hour [DEISU_UPLOAD_HOUR_BR]
UPLOAD_USER, -- Upload User [DEISU_UPLOAD_USER_BR]
REVERSE_DATE, -- Reverse Date [DEISU_REVERSE_DATE_BR]
REVERSE_HOUR, -- Reverse Hour [DEISU_REVERSE_HOUR_BR]
REVERSE_USER, -- Reverse User [DEISU_REVERSE_USER_BR]
PRIMARY KEY (MANDT, OBJECT_ID, METER_READER_UNIT, SCHEDULED_METER_READING_DATE, METER_READING_DOCUMENT)
);
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