I_MAINTMBLTRANSACTIONHISTORY

CDS View

Maintenance Mobile Transaction History

I_MAINTMBLTRANSACTIONHISTORY is a CDS View in S/4HANA. Maintenance Mobile Transaction History. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_MaintMblTransactionHistory view_entity from CONSUMPTION Maintenance Mobile Transaction History
I_MaintMblTransHistoryCube view_entity from COMPOSITE Mobile Transaction History - Cube 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@Analytics: {
  dataCategory: #FACT,
  internalName: #LOCAL
}

@EndUserText.label: 'Maintenance Mobile Transaction History'

@ObjectModel.usageType: {
  dataClass: #TRANSACTIONAL,
  serviceQuality: #A,
  sizeCategory: #L
}

@VDM.viewType: #BASIC

define view entity I_MaintMblTransactionHistory
  as select from /syclo/mbl02

  association [0..*] to I_MntMblAppInbTransReqTypeText as _InbTransReqTypeText         on _InbTransReqTypeText.MaintMblApplInbTransReqType = $projection.MaintMblApplInbTransReqType
  association [0..*] to I_MblDtaObjHdlrMethodTypeText  as _MblDtaObjHdlrMethodTypeText on _MblDtaObjHdlrMethodTypeText.MblDtaObjectHandlerMethodType = $projection.MblDtaObjectHandlerMethodType
{
  key registry_guid    as MaintMblTransHistoryRecordUUID,

      record_no        as MaintMblTransHistRecordNumber,
      mobile_app       as MobileUserApplication,
      bor_objtyp       as BusinessObjectType,
      objkey           as MaintMblTransBusinessObjectKey,
      do_id            as MobileDataObject,
      @ObjectModel.text.association: '_MblDtaObjHdlrMethodTypeText'
      mthd_type        as MblDtaObjectHandlerMethodType,
      @ObjectModel.text.association: '_InbTransReqTypeText'
      req_type         as MaintMblApplInbTransReqType,
      resv_expire_ts   as MaintMblTransHistExprtnDteTme,
      ext_trans_id     as MaintMobileExternalTransaction,
      omdo_id          as ODataMobileDataObject,
      tech_entity_type as OMDOTechnicalEntityType,
      omdo_operation   as OMDOOperation,
      create_user_guid as MaintMblTransCreatedByUserUUID,
      change_user_guid as MaintMblTransChangedByUserUUID,
      created_by       as CreatedByUser,
      created_ts       as CreationDateTime,
      changed_by       as LastChangedByUser,
      changed_ts       as LastChangeDateTime,

      tstmp_to_dats(
        changed_ts,
        abap_system_timezone( $session.client, 'NULL' ),
        $session.client,
        'NULL' )       as LastChangeDate,

      _InbTransReqTypeText,
      _MblDtaObjHdlrMethodTypeText
}

Learn More