P_WorkViewAssgmtPrptyRootType

DDL: P_WORKVIEWASSGMTPRPTYROOTTYPE Type: view CONSUMPTION

Work perspective assignment property root type

P_WorkViewAssgmtPrptyRootType is a Consumption CDS View that provides data about "Work perspective assignment property root type" in SAP S/4HANA. It reads from 1 data source (I_WorkViewAssgmt) and exposes 9 fields with key fields WorkView, WorkViewAssgmtUUID.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkViewAssgmt I_WorkViewAssgmt from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PWVASSGMTPRPTY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label Work perspective assignment property root type view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY WorkView WorkView
KEY WorkViewAssgmtUUID WorkViewAssgmtUUID
WorkViewUUID WorkViewUUID
ComplianceRequirement ComplianceRequirement
WorkViewComposition WorkViewComposition
WorkViewDataType WorkViewDataType
WorkViewGroupUUID WorkViewGroupUUID
_WorkView _WorkView
_WorkViewGroup _WorkViewGroup 
@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'
        else WorkViewProperty
      end as ehfnd_prop_property_root ) as WorkViewProperty,

      WorkViewDataType,
      WorkViewGroupUUID,

      /* Associations */
      _WorkView,
      _WorkViewGroup
}


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKVIEWASSGMT"
],
"ASSOCIATED":
[
"I_WORKVIEW",
"I_WORKVIEWGROUP"
],
"BASE":
[
"I_WORKVIEWASSGMT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More