I_PersonWorkAgrmtStatus

DDL: I_PERSONWORKAGRMTSTATUS SQL: IPERWKAGRSTATUS Type: view BASIC Package: VDM_SHCM_EMPLOYEE_V2
5 Fields 1 Data Sources 1 Associations

Work Agreement Status

I_PersonWorkAgrmtStatus (Basic)

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

WorkAssignmentDetails · Human Resources

I_PersonWorkAgrmtStatus is a Basic CDS View (Dimension) that provides data about "Work Agreement Status" in SAP S/4HANA. It reads from 1 data source (wfd_d_assgmtdets) and exposes 5 fields with key fields PersonWorkAgreement, StartDate, EndDate. 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
CapabilitiesData Source for Data Extraction,Data Source in SQL Select,Analytical Dimension,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>When is the workagreement active or inactive?</p> </li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
wfd_d_assgmtdets dets from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_PersonWorkAgrmtStatusText _PersonWorkAgrmtStatusText _PersonWorkAgrmtStatusText.WorkAgreementStatus = $projection.WorkAgreementStatus

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IPERWKAGRSTATUS view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
Analytics.dataExtraction.enabled true view
Analytics.dataCategory #DIMENSION view
EndUserText.label Work Agreement Status view
ObjectModel.representativeKey PersonWorkAgreement view
ObjectModel.sapObjectNodeType.name WorkAssignmentDetails view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.preserveKey true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PersonWorkAgreement Personnel Number
KEY StartDate Start Date
KEY EndDate End Date
PersonWorkAgrmtAuthznGrpg Organizational Key
_PersonWorkAgrmtStatusText _PersonWorkAgrmtStatusText

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_PersonWorkAgrmtStatus.
-- 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: IPERWKAGRSTATUS

CREATE VIEW I_PersonWorkAgrmtStatus AS
SELECT
  cast(dets.workforce_assgmt_id as persno preserving type ) AS PersonWorkAgreement,
  cast(dets.start_date as begda preserving type ) AS StartDate,
  cast(dets.end_date as endda preserving type ) AS EndDate,
  cast('' as vdsk1 ) AS PersonWorkAgrmtAuthznGrpg
FROM wfd_d_assgmtdets AS dets
LEFT OUTER JOIN I_PersonWorkAgrmtStatusText AS _PersonWorkAgrmtStatusText ON _PersonWorkAgrmtStatusText.WorkAgreementStatus = WorkAgreementStatus  -- association [0..*]
;

Learn More