I_WorkPermitApprovalBasic

DDL: I_WORKPERMITAPPROVALBASIC SQL: IWPMAPPROVALBSC Type: view BASIC Package: VDM_EAM_WCM_PERMIT_TO_WORK

Maintain Approvals for Work Permit

I_WorkPermitApprovalBasic is a Basic CDS View that provides data about "Maintain Approvals for Work Permit" in SAP S/4HANA. It reads from 1 data source (ptwwrkpmtapprvl) and exposes 9 fields with key fields MaintenancePlanningPlant, WorkPermitType, WorkPermitApproval, WorkPermitApprovalScenario. It has 2 associations to related views. Part of development package VDM_EAM_WCM_PERMIT_TO_WORK.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
ptwwrkpmtapprvl Approval from

Associations (2)

CardinalityTargetAliasCondition
[0..1] t357g _Permit $projection.WorkPermitApproval = _Permit.sogen
[0..1] t357g_t _PermitTxt $projection.WorkPermitApproval = _PermitTxt.pmsog and _PermitTxt.spras = $session.system_language

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IWPMAPPROVALBSC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Maintain Approvals for Work Permit view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #META view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlanningPlant iwerk
KEY WorkPermitType workpermittype
KEY WorkPermitApproval sogen
KEY WorkPermitApprovalScenario scenario
WrkPmtApprovalHierarchyLevel hierarchylevel
WrkPmtApprovalCopyIsAutomatic wrkpmtapprovalcopyisautomatic
WrkPmtApprovalIsMandatory wrkpmtapprovalismandatory
WorkPermitApprovalDescription _PermitTxt gntxt
char10asWrkPmtApprvlMandText 
@AbapCatalog.sqlViewName: 'IWPMAPPROVALBSC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Maintain Approvals for Work Permit'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #S, dataClass: #META}
@VDM.viewType: #BASIC

define view I_WorkPermitApprovalBasic
  as select from ptwwrkpmtapprvl as Approval
  association [0..1] to t357g   as _Permit    on  $projection.WorkPermitApproval = _Permit.sogen
  association [0..1] to t357g_t as _PermitTxt on  $projection.WorkPermitApproval = _PermitTxt.pmsog
                                              and _PermitTxt.spras               = $session.system_language
{
  key iwerk                                                     as MaintenancePlanningPlant,
  key workpermittype                                            as WorkPermitType,
  key sogen                                                     as WorkPermitApproval,
  key scenario                                                  as WorkPermitApprovalScenario,
      hierarchylevel                                            as WrkPmtApprovalHierarchyLevel,
      wrkpmtapprovalcopyisautomatic                             as WrkPmtApprovalCopyIsAutomatic,
      wrkpmtapprovalismandatory                                 as WrkPmtApprovalIsMandatory,
      _PermitTxt.gntxt                                          as WorkPermitApprovalDescription,
      cast( case when  wrkpmtapprovalismandatory != '' then 'Mandatory '
      else            'Optional'   end as  abap.char(10)      ) as WrkPmtApprvlMandText
}
where
  _Permit.k_sperr != 'X';

Learn More