I_PersonWorkAgreementComm

DDL: I_PERSONWORKAGREEMENTCOMM Type: view_entity BASIC
26 Fields 2 Data Sources

Plain Infotype PA0105

I_PersonWorkAgreementComm is a Basic CDS View that provides data about "Plain Infotype PA0105" in SAP S/4HANA. It reads from 2 data sources (pa0105, pa0001) and exposes 26 fields with key fields HCMPersonnelNumber, HCMSubtype, HCMObjectIdentification, HCMRecordIsLocked, EndDate.

Data Sources (2)

SourceAliasJoin Type
pa0105 Communication from
pa0001 pa0001 inner

Annotations (7)

NameValueLevelField
EndUserText.label Plain Infotype PA0105 view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
VDM.viewType #BASIC view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY HCMPersonnelNumber pa0105 pernr Personnel no.
KEY HCMSubtype pa0105 subty Subtype
KEY HCMObjectIdentification pa0105 objps Object ID
KEY HCMRecordIsLocked pa0105 sprps Single-Character Flag
KEY EndDate pa0105 endda Valid To
KEY StartDate pa0105 begda Valid From
KEY HCMSequentialNumber pa0105 seqnr Tank ID
LastChangedDate pa0105 aedtm Changed On
LastChangedByUser pa0105 uname User Name
HCMInfoTypeRecordIsHistorical pa0105 histo Historical rec.
HCMInfoTypeRecordHasText pa0105 itxex Text exists
HCMInfoTypeRecordHasRefField pa0105 refex Single-Character Flag
HCMInfoTypeRecordHasConfField pa0105 ordex Single-Character Flag
HCMInfoTypeRecordScreenCtrl pa0105 itbld Screen control
HCMMasterDataChangeReason pa0105 preas Change Reason
HCMInfoTypeRecordRsrvdFld1 pa0105 flag1 Text field length 1
HCMInfoTypeRecordRsrvdFld2 pa0105 flag2 Tr. Evaluation
HCMInfoTypeRecordRsrvdFld3 pa0105 flag3 Text field length 1
HCMInfoTypeRecordRsrvdFld4 pa0105 flag4 Usage in the OWN Authorization Context
HCMInfoTypeRecordRsrvdFld1Len2 pa0105 rese1 Reserved Field/Unused Field of Length 2
HCMInfoTypeRecordRsrvdFld2Len2 pa0105 rese2 Reserved Field/Unused Field of Length 2
HCMGrpgValForPersAssignments pa0105 grpvl Grouping Value
HCMCommunicationType pa0105 usrty Type
HCMCommunicationID pa0105 usrid System ID
HCMCommunicationLongID pa0105 usrid_long Long ID/Number
PersonWorkAgrmtAuthznGrpg pa0001 vdsk1 Org.key

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_PersonWorkAgreementComm.
-- 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.

CREATE VIEW I_PersonWorkAgreementComm AS
SELECT
  Communication.pernr AS HCMPersonnelNumber,
  Communication.subty AS HCMSubtype,
  Communication.objps AS HCMObjectIdentification,
  Communication.sprps AS HCMRecordIsLocked,
  Communication.endda AS EndDate,
  Communication.begda AS StartDate,
  Communication.seqnr AS HCMSequentialNumber,
  Communication.aedtm AS LastChangedDate,
  Communication.uname AS LastChangedByUser,
  Communication.histo AS HCMInfoTypeRecordIsHistorical,
  Communication.itxex AS HCMInfoTypeRecordHasText,
  Communication.refex AS HCMInfoTypeRecordHasRefField,
  Communication.ordex AS HCMInfoTypeRecordHasConfField,
  Communication.itbld AS HCMInfoTypeRecordScreenCtrl,
  Communication.preas AS HCMMasterDataChangeReason,
  Communication.flag1 AS HCMInfoTypeRecordRsrvdFld1,
  Communication.flag2 AS HCMInfoTypeRecordRsrvdFld2,
  Communication.flag3 AS HCMInfoTypeRecordRsrvdFld3,
  Communication.flag4 AS HCMInfoTypeRecordRsrvdFld4,
  Communication.rese1 AS HCMInfoTypeRecordRsrvdFld1Len2,
  Communication.rese2 AS HCMInfoTypeRecordRsrvdFld2Len2,
  Communication.grpvl AS HCMGrpgValForPersAssignments,
  Communication.usrty AS HCMCommunicationType,
  Communication.usrid AS HCMCommunicationID,
  Communication.usrid_long AS HCMCommunicationLongID,
  pa0001.vdsk1 AS PersonWorkAgrmtAuthznGrpg
FROM pa0105 AS Communication
INNER JOIN pa0001 ON /* join condition not captured in parsed metadata */
;

Learn More