I_WORKPERMITAPPROVALBASIC

CDS View

Maintain Approvals for Work Permit

I_WORKPERMITAPPROVALBASIC is a CDS View in S/4HANA. Maintain Approvals for Work Permit. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_WorkPermitApprovalValueHelp view from CONSUMPTION Approvals for permit type 
@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';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PTWWRKPMTAPPRVL",
"T357G",
"T357G_T"
],
"ASSOCIATED":
[
"T357G",
"T357G_T"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More