R_MEMORECORDIMPORTTP

CDS View

Cash Management: Import Memo Record

R_MEMORECORDIMPORTTP is a CDS View in S/4HANA. Cash Management: Import Memo Record. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_MemoRecordImportTP view_entity projection CONSUMPTION Import Memo Record Transaction 
@AccessControl.authorizationCheck:  #MANDATORY
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: { usageType: { serviceQuality: #B,
                             sizeCategory:   #M,
                             dataClass:      #TRANSACTIONAL },
                             sapObjectNodeType.name: 'MemoRecordImport'}

@VDM:         { usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ],
                viewType:  #TRANSACTIONAL,
                lifecycle: { contract: { type: #SAP_INTERNAL_API } } }
@EndUserText.label: 'Cash Management: Import Memo Record'
@AccessControl.privilegedAssociations:  [ '_CreatedBy']
define root view entity R_MemoRecordImportTP
  as select from I_MemoRecordImport
  association [0..1] to I_UserContactCard         as _CreatedBy               on  $projection.CreatedByUser = _CreatedBy.ContactCardID
  association [0..*] to I_MemoRecordTypeText      as _MemoRecordTypeText       on  $projection.MemoRecordType= _MemoRecordTypeText.MemoRecordType


{
  key MemoRecordImport,
      @Semantics.largeObject: { mimeType: 'MemoRecordImportFileMimeType',
                                   fileName: 'MemoRecordImportFileName',
                                   contentDispositionPreference: #INLINE }
      MemoRecordImportContentBinary,
      @Semantics.mimeType: true
      MemoRecordImportFileMimeType,
      MemoRecordImportFileName,
      MemoRecordImportStatus,
//      CreationDate,

//      LastChangeDate,

      @Semantics.systemDateTime.lastChangedAt:true
      LastChangeDateTime,
      @Semantics.user.createdBy: true
      @Semantics.contact.type: #PERSON
      @ObjectModel.foreignKey.association: '_CreatedBy'
      CreatedByUser,
      @Semantics.systemDateTime.createdAt: true
      CreationDateTime,
      @Semantics.user.lastChangedBy: true
      LastChangeByUser,
      ApplicationLogHandle,
//      LogHandle,

      cast ( case when ( MemoRecordImportStatus = '10' )  then '2' //Critical

      when( MemoRecordImportStatus = '20' )  then '1' //Negative

      when( MemoRecordImportStatus = '30' )  then '3' //Positive      

      else  '0' end as int1 )                      as MemoRecordImprtStsCritlty, //Neutral

      MemoRecordImportApplJobName,
      MemoRecordImportApplJobID,
      MemoRecordType,
      
      
      _MemoRecordImportStatusText,
      _CreatedBy,
      _MemoRecordTypeText
//      _ChangedBy

      

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MEMORECORDIMPORT"
],
"ASSOCIATED":
[
"I_MEMORECORDIMPORTSTATUSTEXT",
"I_MEMORECORDTYPETEXT",
"I_USERCONTACTCARD"
],
"BASE":
[
"I_MEMORECORDIMPORT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More