I_SSPWorkPersonDetails

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_SSPWorkPersonDetails.
-- 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: ISSP_PERSONDET

CREATE VIEW I_SSPWorkPersonDetails AS
SELECT
  WorkForcePerson.BusinessPartnerUUID AS BusinessPartnerUUID,
  _personWorkAgreement_1.PersonWorkAgreement AS PersonWorkAgreement,
  WorkForcePerson.Person AS Person,
  WorkForcePerson.FirstName AS FirstName,
  WorkForcePerson.LastName AS LastName,
  WorkForcePerson.PersonFullName AS PersonFullName,
  WorkForcePerson.PersonExternalID AS PersonExternalID,
  WorkForcePerson.AuthorizationGroup AS AuthorizationGroup,
  WorkForcePerson.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  cast(substring( cast(tstmp_current_utctimestamp() as abap.char( 17 ) ), 1, 8 ) as abap.dats ) AS ValidityEndDate,
  _PersonWorkAgrmtOrglDetails.CompanyCode AS CompanyCode,
  _PersonWorkAgrmtOrglDetails.StartDate AS StartDate,
  _PersonWorkAgrmtOrglDetails.EndDate AS EndDate,
  WorkForcePerson._BusinessPartner AS _BusinessPartner,
  _PersonWorkAgrmtStatus.WorkAgreementStatus AS WorkAgreementStatus,
  _PersonWorkAgrmtStatus.PersonWorkAgrmtAuthznGrpg AS PersonWorkAgrmtAuthznGrpg
INNER JOIN I_PersonWorkAgreement_1 AS _personWorkAgreement_1 ON /* join condition not captured in parsed metadata */
INNER JOIN I_PersonWorkAgrmtStatus AS _PersonWorkAgrmtStatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PersonWorkAgrmtOrglDetails AS _PersonWorkAgrmtOrglDetails ON _PersonWorkAgrmtOrglDetails.PersonWorkAgreement = _personWorkAgreement_1.PersonWorkAgreement AND _PersonWorkAgrmtOrglDetails.StartDate <= $session.system_date AND _PersonWorkAgrmtOrglDetails.EndDate >= $session.system_date  -- association [0..1]
;