I_PersonWorkAgrmtStatusText

DDL: I_PERSONWORKAGRMTSTATUSTEXT SQL: IPERWKAGRSTTXT Type: view BASIC Package: VDM_SHCM_EMPLOYEE_V2

Person Work Agreement Status with Text

I_PersonWorkAgrmtStatusText is a Basic CDS View that provides data about "Person Work Agreement Status with Text" in SAP S/4HANA. It reads from 1 data source (P_PersonWorkAgrmtStatusText) and exposes 4 fields with key fields Language, WorkAgreementStatus. It has 1 association to related views. Part of development package VDM_SHCM_EMPLOYEE_V2.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
P_PersonWorkAgrmtStatusText dd07t from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language dd07t.Language = _Language.Language

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IPERWKAGRSTTXT view
EndUserText.label Person Work Agreement Status with Text view
VDM.viewType #BASIC view
ObjectModel.dataCategory #TEXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey WorkAgreementStatus view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Language Language
KEY WorkAgreementStatus WorkAgreementStatus
WorkAgreementStatusName
_Language _Language 
@AbapCatalog.sqlViewName: 'IPERWKAGRSTTXT'
@EndUserText.label: 'Person Work Agreement Status with Text'
@VDM.viewType: #BASIC
@ObjectModel.dataCategory: #TEXT
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ObjectModel.representativeKey: 'WorkAgreementStatus'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities: [#LANGUAGE_DEPENDENT_TEXT,
                                     #SQL_DATA_SOURCE,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #CDS_MODELING_ASSOCIATION_TARGET]

define view I_PersonWorkAgrmtStatusText
  as select from P_PersonWorkAgrmtStatusText as dd07t
  association [0..1] to I_Language as _Language on dd07t.Language = _Language.Language
{
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key Language as Language,
  key WorkAgreementStatus,
      @Semantics.text
      cast( WorkAgreementStatusName as val_text preserving type ) as WorkAgreementStatusName,
      _Language
}


/*
//    as select from P_PersonWorkAgrmtStatusText

  as select from WFD_TF_PersonWorkStatusText( p_client:$session.client ) as dd07t
  association [0..1] to I_Language as _Language on dd07t.Language = _Language.Language
{
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key Language,
  key WorkAgreementStatus,
      @Semantics.text
      WorkAgreementStatusName,
      _Language
}
*/


////define view I_PersonWorkAgrmtStatusText

//  as select from P_PersonWorkAgrmtStatusText

//  association [0..1] to I_Language as _Language on P_PersonWorkAgrmtStatusText.Language = _Language.Language

//{

//      @Semantics.language: true

//      @ObjectModel.foreignKey.association: '_Language'

//  key Language,

//  key WorkAgreementStatus,

//      @Semantics.text

//    WorkAgreementStatusName,

//      _Language

//}


// as select from dd07t

//  association [0..1] to I_Language as _Language on dd07t.ddlanguage = _Language.Language

//{

//      @Semantics.language: true

//      @ObjectModel.foreignKey.association: '_Language'

//  key ddlanguage                                     as Language,

//  key cast (domvalue_l as /shcm/employment_status )  as WorkAgreementStatus,

//      @Semantics.text

//      ddtext                                         as WorkAgreementStatusName,

//      _Language

//}

//where

//      domname  = '/SHCM/EMPLOYMENT_STATUS'

//  and as4local = 'A'

Learn More