I_PersonWorkAgrmtToExternalID

DDL: I_PERSONWORKAGRMTTOEXTERNALID SQL: IPERWKAGREXT Type: view BASIC
5 Fields 1 Data Sources 1 Associations

Mapping between Work agrrement internal and External IDs

I_PersonWorkAgrmtToExternalID (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private 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 reads from 1 data source (WFD_TF_PersonWorkToExternalID) and exposes 5 fields with key fields PersonWorkAgreement, CompanyCode. It has 1 association to related views.

SAP API Hub

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
PackageHuman Resources for SAP S/4HANA Cloud Private 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

Data Sources (1)

SourceAliasJoin Type
WFD_TF_PersonWorkToExternalID WFD_TF_PersonWorkToExternalID from

Associations (1)

CardinalityTargetAliasCondition
[1] I_CompanyCode _CompanyCode external.CompanyCode = _CompanyCode.CompanyCode

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IPERWKAGREXT 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.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 (5)

KeyFieldSource TableSource FieldDescription
KEY PersonWorkAgreement PersonWorkAgreement Personnel Number
KEY CompanyCode CompanyCode Receiver Company Code
PersonWorkAgreementExternalID PersonWorkAgreementExternalID Work Agreement External ID
PersonWorkAgrmtAuthznGrpg 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
  PersonWorkAgreement,
  CompanyCode,
  PersonWorkAgreementExternalID,
  PersonWorkAgrmtAuthznGrpg
FROM WFD_TF_PersonWorkToExternalID
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON external.CompanyCode = _CompanyCode.CompanyCode  -- association [1]
;

Learn More