I_PersonWorkAgrmtStatusText

DDL: I_PERSONWORKAGRMTSTATUSTEXT SQL: IPERWKAGRSTTXT Type: view BASIC Package: VDM_SHCM_EMPLOYEE_V2
4 Fields 1 Data Sources 1 Associations

Person Work Agreement Status with Text

I_PersonWorkAgrmtStatusText (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Human Resources

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.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessHuman Resources
Application ComponentCA-WFD
CapabilitiesLanguage-Dependent Text,Data Source in SQL Select,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageHuman Resources for SAP S/4HANA Cloud Public Edition
Description <p>This view provides the prerequisites for answering the following business questions:</p> <ul> <li> <p>What is text for the work agreement status code 0 and 1?</p> </li> </ul>

Documentation

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 Report Text Language
KEY WorkAgreementStatus WorkAgreementStatus Model S: Employment Status
WorkAgreementStatusName Short Text for Fixed Values
_Language _Language

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_PersonWorkAgrmtStatusText.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IPERWKAGRSTTXT

CREATE VIEW I_PersonWorkAgrmtStatusText AS
SELECT
  Language,
  WorkAgreementStatus,
  cast( WorkAgreementStatusName as val_text preserving type ) AS WorkAgreementStatusName
FROM P_PersonWorkAgrmtStatusText AS dd07t
LEFT OUTER JOIN I_Language AS _Language ON dd07t.Language = _Language.Language  -- association [0..1]
;

Learn More