R_CONCURDOCUMENTPROTOCOL

CDS View

Concur Document Protocol

R_CONCURDOCUMENTPROTOCOL is a CDS View in S/4HANA. Concur Document Protocol. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ConcurDocumentProtocol_2 view_entity projection CONSUMPTION Concur Document Protocol 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Concur Document Protocol'
@Metadata.ignorePropagatedAnnotations: true
//@ObjectModel.sapObjectNodeType.name: 'ConcurTrvlAndExpnMgmtDoc'

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@VDM.viewType: #COMPOSITE

@AccessControl: {
  privilegedAssociations: [ '_Contact' ]
}

define root view entity R_ConcurDocumentProtocol
  as select from I_ConcurDocumentProtocolUnion as ConcurProtocol
  association [1..1] to I_ConcurDocumentsAllUnion as _ConcurDocument on  $projection.ConcurSystemKey              = _ConcurDocument.ConcurSystemKey
                                                                     and $projection.ConcurDocumentType           = _ConcurDocument.ConcurDocumentType
                                                                     and $projection.ConcurDocumentID             = _ConcurDocument.ConcurDocumentID
                                                                     and $projection.ConcurDocumentRevisionNumber = _ConcurDocument.ConcurDocumentRevisionNumber
  association [0..1] to I_UserContactCard         as _Contact        on  $projection.ConcurCreatedByUser = _Contact.ContactCardID

{
  key ConcurSystemKey,
  key ConcurDocumentType,
  key ConcurDocumentID,
  key ConcurDocumentRevisionNumber,
  key ConcurDocumentStoreUUID,
  key ConcurProtocolSequentialNumber,
      ConcurActionCode,
      ConcurMessageType,
      ConcurCreatedByUser,
      ConcurCreatedAtDateTime,
      LogNumber,
      //      ConcurConfirmationNumber,

      //        HighNumberInd,

      ConcurAddInformationText,
      ConcurInstructionCode,
      case ConcurMessageType
        when 'E' then 1
        when 'S' then 3
        when 'W' then 2
        when 'I' then 2
      end as CriticalityCode,

      _ConcurDocument,
      _Contact
}

Learn More