I_PersonWorkAgrmtToExternalID

DDL: I_PERSONWORKAGRMTTOEXTERNALID SQL: IPERWKAGREXT Type: view COMPOSITE
4 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 Composite 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 (I_PersonWorkAgreementOrgAss) and exposes 4 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
I_PersonWorkAgreementOrgAss pa0001_ForAuthorization inner

Associations (1)

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

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IPERWKAGREXT view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B 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 (4)

KeyFieldSource TableSource FieldDescription
KEY PersonWorkAgreement pa0001 HCMPersonnelNumber Personnel Number
KEY CompanyCode pa0001 CompanyCode Receiver Company Code
PersonWorkAgrmtAuthznGrpg I_PersonWorkAgreementOrgAss HCMOrganizationalKey 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
  pa0001.HCMPersonnelNumber AS PersonWorkAgreement,
  pa0001.CompanyCode AS CompanyCode,
  pa0001_ForAuthorization.HCMOrganizationalKey AS PersonWorkAgrmtAuthznGrpg
INNER JOIN I_PersonWorkAgreementOrgAss AS pa0001_ForAuthorization ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON pa0001.CompanyCode = _CompanyCode.CompanyCode  -- association [1]
;

Learn More