I_MAINTMBLTRANSACTIONHISTORY

CDS View

Maintenance Mobile Transaction History

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

Used by 1 CDS view(s)

CDS Views using this table (1)

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

@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
{
  key registry_guid    as MaintMblTransHistoryRecordUUID,

      @EndUserText.label: 'Record Number'
      record_no        as MaintMblTransHistRecordNumber,
      mobile_app       as MobileUserApplication,
      @EndUserText.label: 'Object Key'
      objkey           as MaintMblTransBusinessObjectKey,
      @EndUserText.label: 'Expire On'
      resv_expire_ts   as MaintMblTransHistExprtnDteTme,
      @EndUserText.label: 'External Transaction'
      ext_trans_id     as MaintMobileExternalTransaction,
      @EndUserText.label: 'OData Mobile Data Object'
      omdo_id          as ODataMobileDataObject,
      @EndUserText.label: 'Technical Entity Type'
      tech_entity_type as OMDOTechnicalEntityType,
      @EndUserText.label: 'OMDO Operation'
      omdo_operation   as OMDOOperation,
      @EndUserText.label: 'Created By User GUID'
      create_user_guid as MaintMblTransCreatedByUserUUID,
      @EndUserText.label: 'Last Changed By User GUID'
      change_user_guid as MaintMblTransChangedByUserUUID,
      created_by       as CreatedByUser,
      @EndUserText.label: 'Created On'
      created_ts       as CreationDateTime,
      changed_by       as LastChangedByUser,
      @EndUserText.label: 'Last Changed On'
      changed_ts       as LastChangeDateTime
}
where
  req_type = 'O' // In cloud, we support only oMDO transactions

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/SYCLO/MBL02"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More