I_PersonWorkAgrmtToECId

DDL: I_PERSONWORKAGRMTTOECID SQL: IPERWKAGRECID Type: view BASIC
2 Fields 1 Data Sources

Internal view to get the ECUS ID

I_PersonWorkAgrmtToECId is a Basic CDS View that provides data about "Internal view to get the ECUS ID" in SAP S/4HANA. It reads from 1 data source (WFD_TF_PersonWorkAgrmtToECId) and exposes 2 fields with key field PersonWorkAgreement.

Data Sources (1)

SourceAliasJoin Type
WFD_TF_PersonWorkAgrmtToECId WFD_TF_PersonWorkAgrmtToECId from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPERWKAGRECID 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 #NOT_REQUIRED view
EndUserText.label Internal view to get the ECUS ID view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY PersonWorkAgreement PersonWorkAgreement Personnel No.
PersonWorkAgreementExternalID PersonWorkAgreementExternalID

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_PersonWorkAgrmtToECId.
-- 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: IPERWKAGRECID

CREATE VIEW I_PersonWorkAgrmtToECId AS
SELECT
  PersonWorkAgreement,
  PersonWorkAgreementExternalID
FROM WFD_TF_PersonWorkAgrmtToECId
;

Learn More