R_WORKPERMITPARTNERTP

CDS View

Work Permit Partner

R_WORKPERMITPARTNERTP is a CDS View in S/4HANA. Work Permit Partner. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_WorkPermitPartner view_entity projection CONSUMPTION WorkPermit Partner
C_WorkPermitPartnerTP view_entity projection CONSUMPTION Work Permit Partner 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Work Permit Partner'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #TRANSACTIONAL
@VDM.usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Search.searchable: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #META
}
define view entity R_WorkPermitPartnerTP
  as select from I_WorkPermitPartner    
  association  to parent R_WorkPermitTP as _WorkPermit              on $projection.WorkPermit = _WorkPermit.WorkPermit
{
  key MaintObjectInternalID,
  key cast(  PartnerFunction as parvw_unv preserving type ) as PartnerFunction,
  key MaintenancePartnerObjectNumber,   
      @Search.defaultSearchElement: true                  
      MaintenancePartner,
      WorkPermit,
      MaintenancePlanningPlant,
      WorkPermitType,      
      
      _PartnerFunction._Text[ 1: Language = $session.system_language ].PartnerFunctionName,     

      MaintObjectCategory,
      
//      case PartnerFunction

//       when 'VW' then _BusinessPartner.PersonFullName

//       when 'LF' then _Supplier.BPSupplierName

//       else _Customer.CustomerFullName 

//       end as CustomerFullName,


      case
      when _BusinessPartner.PersonFullName is not initial then
            _BusinessPartner.PersonFullName
            when _Customer.CustomerFullName is not initial then
               _Customer.CustomerFullName
               else
            _Supplier.BusinessPartnerName1
            end                                             as CustomerFullName,
            
//       _Customer.CustomerFullName,      


      _Customer.Country,

      CreatedByUser,
      CreationDate,      
      CreationTime,            
      LastChangedByUser,     
      LastChangeDate                                        as LastChangedDate,
      LastChangeTime,
      _WorkPermit,
      _PartnerFunction

}

Learn More