Show TOC

Measurement Documents Locate this document in the navigation structure

DataSource Transactional Data DataSource Transactional Data: 0DF_IS_DFS_48

 

This DataSource allows you to access measurement document data from the source system.

Technical Data

Application Component

ISDFPS BW Business Content (IS-DFS-BW)

Available as of Release

SAP Defense Forces & Public Security 6.10

Shipment

NW 2004s BI Content Add-On 3

Content Versions

There are no content versions.

RemoteCube-Capable

No

Delta-Capable

Yes

Extraction from Archives

No

Verifiable

No

Data Modeling

Fields of Origin for the Extract Structure

Fields in the Extract Structure

Description of the Field in the Extract Structure

Table of Origin

Field in the Table of Origin

MDOCM

Measurement Document

IMRG

MDOCM

POINT

Measuring Point

IMRG

POINT

EQUNR

Equipment Number

IMPTT

aus MPOBJ abgeleitet

TPLNR

Functional Location

IMPTT

aus MPOBJ abgeleitet

MPOBJ

Object Number for the Measuring Point Object

IMPTT

MPOBJ

PRUEFLOS

Inspection Lot Number

IMRG

PRUEFLOS

IDATE

Date of the Measurement

IMRG

IDATE

ITIME

Time of the Measurement

IMRG

ITIME

INVTS

Inverted Time Stamp: 99.999.999.999 - Seconds AD

IMRG

INVTS

CNTRG

Indicator: Counter Reading Document

IMRG

READR

Person who Took the Measurement Reading

IMRG

READR

VORGLFNR

Current Node Number from Order Counter APLZL

IMRG

VORGLFNR

MERKNR

Inspection Characteristic Number

IMRG

MERKNR

DOCAF

Indicator: MeasDoc. Created After Associated Tasks

IMRG

DOCAF

RECDV

Measurement Reading in Unit of Entry

IMRG

RECDV

RECDU

Unit of Measurement for Document Entry

IMRG

RECDU

SIUNIT

Unit

IMRG

SIUNIT

IDIFF

Indicator: Counter Reading Entered as Difference

IMRG

IDIFF

EXCHG

Indicator: Counter Replaced

IMRG

EXCHG

TOTEX

Indicator: Total Counter Reading Set Externally

IMRG

TOTEX

CNTRR

Counter Reading in SI Unit

IMRG

CNTRR

READG

Measurement Reading/Total Counter Reading in SI Unit

IMRG

READG

ROOTD

Source Document for Measurement Reading Transfer

IMRG

ROOTD

WOOBJ

Object Number of Order

IMRG

WOOBJ

CODCT

Catalog Type - Measurement Reading Valuation Code

IMRG

CODCT

CODGR

Code Group - Measurement Reading Valuation Code

IMRG

CODGR

VLCOD

Valuation Code

IMRG

VLCOD

CVERS

Version Number

IMRG

CVERS

PREST

Processing Status

IMRG

PREST

CANCL

Reversal Indicator

IMRG

CANCL

GENER

Origin Indicator

IMRG

GENER

CDIFF

Counter Reading Difference in SI Unit

IMRG

CDIFF

WOOB1

Object Number of Order Operation/Confirmation Counter etc.

IMRG

WOOB1

PROBENR

Number of the Partial Sample

IMRG

PROBENR

MBEWERTG

Inspection Result Valuation

IMRG

MBEWERTG

INTVL

Indicator that Document Refers to Time Interval

IMRG

INTVL

IDAT1

Date of Interval Start

IMRG

IDAT1

ITIM1

Time of Interval Start

IMRG

ITIM1

ERDAT

Date on Which the Object Was Created

IMRG

ERDAT

AEDAT

Date on Which the Object Was Last Changed

IMRG

AEDAT

DELTADATE

Field of DATS Type

-

Extractor Logic

Description of the Key Figures:

The extractor provides the following key figures:

  • READG: Measurement Reading/Total Counter Reading in SI Unit

  • CNTRR: Counter Reading in SI Unit

  • CDIFF: Counter Reading Difference in SI Unit

  • RECDV: Measurement Reading in Unit of Entry

Extraction Logic:

First, measurement documents are selected from the IMRG table along with fields for the corresponding measuring point. The OBJNR of the IMPTT table (measuring point), which creates the reference to the measuring point object, is then resolved. If the object for the measuring point is an item of equipment, the OBJNR is written to the EQUNR field of the extraction structure; if it is a functional location, the OBJNR is written to the TPLNR field. Since all of the data records from the extracted data package are processed in this step, a delta date is determined simultaneously from the ERDAT and AEDAT fields, which is necessary for the extractor's delta capacity. Finally, the SI unit is determined from the unit of entry of the measurement document, since all measurement readings are also stored as SI values in SAP NetWeaver Business Intelligence. The extractor supports a delta mechanism, which is based on a time stamp. A time stamp is derived from the creation date and change date of a data record. If there is no change date for a data record, the time stamp is derived from the creation date. Otherwise, it is always derived from the change date. This ensures that both new records and changed records are extracted with the next delta.