I_WorkPermitIssueHistory

DDL: I_WORKPERMITISSUEHISTORY SQL: IWRKPMTISSHIST Type: view BASIC Package: VDM_EAM_WCM_PERMIT_TO_WORK

Hand Out Work Permit history

I_WorkPermitIssueHistory is a Basic CDS View that provides data about "Hand Out Work Permit history" in SAP S/4HANA. It reads from 2 data sources (wrkpmtisshist, I_WorkPermitBasic) and exposes 14 fields with key fields WorkPermitInternalID, NumberOfWorkPermitIssued. It has 3 associations to related views. Part of development package VDM_EAM_WCM_PERMIT_TO_WORK.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
wrkpmtisshist _isshist from
I_WorkPermitBasic _WorkPermit inner

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_User _IssuedByUser _IssuedByUser.UserID = $projection.WorkPermitIssuedBy
[0..1] I_User _ReturnToUser _ReturnToUser.UserID = $projection.WorkPermitReturnedTo
[1..1] I_PersonWorkAgreement_1 _PersonWorkAgreement _PersonWorkAgreement.PersonWorkAgreement = _isshist.issued_to

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IWRKPMTISSHIST view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Hand Out Work Permit history view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY WorkPermitInternalID wrkpmtisshist objnr
KEY NumberOfWorkPermitIssued wrkpmtisshist counter
WorkPermit I_WorkPermitBasic WorkPermit
WorkPermitType I_WorkPermitBasic WorkPermitType
MaintenancePlanningPlant I_WorkPermitBasic MaintenancePlanningPlant
WorkPermitIssuedBy wrkpmtisshist issued_by
WorkPermitIssuedTo wrkpmtisshist issued_to
UserCommentsText wrkpmtisshist comments
WorkPermitIssueDateTime wrkpmtisshist issued_on
WorkPermitReturnedTo wrkpmtisshist return_to
WorkPermitReturnedDateTime wrkpmtisshist returned_on
_IssuedByUser _IssuedByUser
_ReturnToUser _ReturnToUser
_PersonWorkAgreement _PersonWorkAgreement 
@AbapCatalog.sqlViewName: 'IWRKPMTISSHIST'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory:#L , dataClass:#TRANSACTIONAL }
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Hand Out Work Permit history'
define view I_WorkPermitIssueHistory
  as select from wrkpmtisshist     as _isshist
    inner join   I_WorkPermitBasic as _WorkPermit on _isshist.objnr = _WorkPermit.WorkPermitInternalID
  association [0..1] to I_User                  as _IssuedByUser        on _IssuedByUser.UserID = $projection.WorkPermitIssuedBy
  association [0..1] to I_User                  as _ReturnToUser        on _ReturnToUser.UserID = $projection.WorkPermitReturnedTo
  association [1..1] to I_PersonWorkAgreement_1 as _PersonWorkAgreement on _PersonWorkAgreement.PersonWorkAgreement = _isshist.issued_to
{
  key _isshist.objnr                       as WorkPermitInternalID,
  key _isshist.counter                     as NumberOfWorkPermitIssued,
      _WorkPermit.WorkPermit               as WorkPermit,
      _WorkPermit.WorkPermitType           as WorkPermitType,
      _WorkPermit.MaintenancePlanningPlant as MaintenancePlanningPlant,
      _isshist.issued_by                   as WorkPermitIssuedBy,
      _isshist.issued_to                   as WorkPermitIssuedTo,
      _isshist.comments                    as UserCommentsText,
      _isshist.issued_on                   as WorkPermitIssueDateTime,
      _isshist.return_to                   as WorkPermitReturnedTo,
      _isshist.returned_on                 as WorkPermitReturnedDateTime,
      _IssuedByUser,
      _ReturnToUser,
      _PersonWorkAgreement
}

Learn More