I_PersonWorkAgrmtToExternalID

DDL: I_PERSONWORKAGRMTTOEXTERNALID SQL: IPERWKAGREXT Type: view BASIC Package: VDM_SHCM_EMPLOYEE_V2
4 Fields 1 Associations

Mapping between Work agrrement internal and External IDs

I_PersonWorkAgrmtToExternalID (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_PersonWorkAgrmtToExternalID is a Basic CDS View (Dimension) that provides data about "Mapping between Work agrrement internal and External IDs" in SAP S/4HANA. 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 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)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 the external work agreement ID of the work agreement?</p> </li> </ul>

Documentation

Associations (1)

CardinalityTargetAliasCondition
[1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IPERWKAGREXT view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Analytics.dataCategory #DIMENSION view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey PersonWorkAgreement view
EndUserText.label Mapping between Work agrrement internal and External IDs view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY PersonWorkAgreement Personnel Number
KEY CompanyCode dets company_code Company Code
PersonWorkAgrmtAuthznGrpg Organizational Key
_CompanyCode _CompanyCode

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_PersonWorkAgrmtToExternalID.
-- 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: IPERWKAGREXT

CREATE VIEW I_PersonWorkAgrmtToExternalID AS
SELECT
  cast(dets.workforce_assgmt_id as persno preserving type ) AS PersonWorkAgreement,
  dets.company_code AS CompanyCode,
  cast ('' as vdsk1 ) AS PersonWorkAgrmtAuthznGrpg
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1]
;

Learn More