P_WORKVIEWASSGMTPRPTYROOTTYPE

CDS View

Work perspective assignment property root type

P_WORKVIEWASSGMTPRPTYROOTTYPE is a CDS View in S/4HANA. Work perspective assignment property root type. It contains 2 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 2 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_ChmlCmplncInfoPrptyCmbnd view inner CONSUMPTION CCI Property Combined

Fields (2)

KeyField CDS FieldsUsed in Views
WorkView WorkView 1
WorkViewUUID WorkViewUUID 1 
@AbapCatalog:
{
  sqlViewName: 'PWVASSGMTPRPTY',
  compiler.compareFilter: true,
  preserveKey:true
}

@AccessControl:
{
  authorizationCheck: #NOT_REQUIRED
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #CONSUMPTION
@VDM: {
    private: true
}
@EndUserText.label: 'Work perspective assignment property root type'
define view P_WorkViewAssgmtPrptyRootType
  as select from I_WorkViewAssgmt
{
  key WorkView,
  key WorkViewAssgmtUUID,
      WorkViewUUID,
      ComplianceRequirement,
      WorkViewComposition,
      -- translate shortened fix values to correct ones
      cast( case WorkViewProperty
        when 'EHFNDD_PHY' then 'EHFNDD_PHYSCHEM'
        when 'EHFNDD_ECT' then 'EHFNDD_ECTX'
        when 'EHFNDD_STA' then 'EHFNDD_STAR'
        when 'EHFNDD_ID'  then 'EHFNDD_CCIDFR'
        else WorkViewProperty
      end as ehfnd_prop_property_root ) as WorkViewProperty,

      WorkViewDataType,
      WorkViewGroupUUID,

      /* Associations */
      _WorkView,
      _WorkViewGroup
}

Learn More