I_WorkPermitPartner

DDL: I_WORKPERMITPARTNER Type: view_entity BASIC Package: VDM_EAM_WCM_PERMIT_TO_WORK

Work Permit Partner

I_WorkPermitPartner is a Basic CDS View that provides data about "Work Permit Partner" in SAP S/4HANA. It reads from 2 data sources (ihpa, wcaap) and exposes 19 fields with key fields MaintObjectInternalID, PartnerFunction, MaintenancePartnerObjectNumber. It has 4 associations to related views. Part of development package VDM_EAM_WCM_PERMIT_TO_WORK.

2 data source(s) 19 fields

Data Sources (2)

SourceAliasJoin Type
ihpa _Partner from
wcaap _WorkPermit inner

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Customer _Customer _Customer.Customer = $projection.Partner or _Customer.Customer = $projection.MaintenancePartner
[1..1] I_PartnerFunction _PartnerFunction _PartnerFunction.PartnerFunction = $projection.PartnerFunction
[1..1] I_BusinessPartner _BusinessPartner _BusinessPartner.BusinessPartner = $projection.Partner
[0..1] I_Supplier _Supplier _Supplier.Supplier = $projection.MaintenancePartner or _Supplier.Supplier = $projection.Partner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Work Permit Partner view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #META view
VDM.viewType #BASIC view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY MaintObjectInternalID ihpa objnr
KEY PartnerFunction
KEY MaintenancePartnerObjectNumber ihpa counter
MaintObjectCategory ihpa obtyp
MaintenancePartner ihpa parnr
WorkPermit wcaap wapinr
MaintenancePlanningPlant wcaap iwerk
WorkPermitType wcaap wapiuse
CreatedByUser ihpa ernam
CreationDate ihpa erdat
CreationTime ihpa erzeit
LastChangedByUser ihpa aenam
LastChangeTime ihpa aezeit
LastChangeDate ihpa aedat
Partner
_PartnerFunction _PartnerFunction
_Customer _Customer
_BusinessPartner _BusinessPartner
_Supplier _Supplier 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Work Permit Partner'
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #S, dataClass: #META}
@VDM.viewType: #BASIC
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_WorkPermitPartner
  as select from ihpa  as _Partner
    inner join   wcaap as _WorkPermit on _Partner.objnr = _WorkPermit.objnr
  association [0..1] to I_Customer        as _Customer        on _Customer.Customer = $projection.Partner or
                                                                 _Customer.Customer = $projection.MaintenancePartner
  association [1..1] to I_PartnerFunction as _PartnerFunction on _PartnerFunction.PartnerFunction = $projection.PartnerFunction
  association [1..1] to I_BusinessPartner as _BusinessPartner on _BusinessPartner.BusinessPartner = $projection.Partner
  association [0..1] to I_Supplier        as _Supplier        on _Supplier.Supplier = $projection.MaintenancePartner or 
                                                                 _Supplier.Supplier = $projection.Partner
{
  key _Partner.objnr                         as MaintObjectInternalID,
      @ObjectModel.foreignKey.association: '_PartnerFunction'
  key cast(_Partner.parvw as parvw_unv)      as PartnerFunction,
  key _Partner.counter                       as MaintenancePartnerObjectNumber,
      _Partner.obtyp                         as MaintObjectCategory,
//      @API.element.successor: 'MaintenancePartner'

//      @API.element.releaseState: #DEPRECATED

//      cast(_Partner.parnr  as abap.char( 10 ) )  as MaintenancePartner,

      _Partner.parnr                         as MaintenancePartner,
      _WorkPermit.wapinr                     as WorkPermit,
      _WorkPermit.iwerk                      as MaintenancePlanningPlant,
      _WorkPermit.wapiuse                    as WorkPermitType,
      _Partner.ernam                         as CreatedByUser,
      _Partner.erdat                         as CreationDate,
      _Partner.erzeit                        as CreationTime,
      _Partner.aenam                         as LastChangedByUser,
      _Partner.aezeit                        as LastChangeTime,
      _Partner.aedat                         as LastChangeDate,
      lpad(ltrim(_Partner.parnr,'0'),10,'0') as Partner,
      _PartnerFunction,
      _Customer,
      _BusinessPartner,
      _Supplier
}
where
      _Partner.kzloesch = ' '
  and _Partner.objnr != ''

Learn More