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 PiqCds_StudentData.
-- 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: PIQCDSSTUDDATA
-- Parameters: p_lang : abap.lang, p_date : abap.dats
CREATE VIEW PiqCds_StudentData AS
SELECT
h1702.objid AS StudentObjectId,
studentbp.student12 AS StudentNumber,
h1705.matrikel AS StudentAdditionalIdNumber,
h1702.nachn AS StudentLastName,
h1702.vorna AS StudentFirstname,
h1702.midnm AS StudentMiddleName,
h1702.inits AS StudentInitials,
h1702.birthname AS StudentBirthName,
h1702.titel AS StudentTitle,
h1702.vorsw AS StudentNamePrefix,
h1702.namzu AS StudentOtherTitle,
h1702.rufnm AS StudentKnownAs,
h1702.gbdat AS StudentDateOfBirth,
h1702.gblnd AS StudentCountryOfBirth,
t005t1.landx AS StudentCountryOfBirthName,
h1702.gbdep AS StudentRegionOfBirth,
t005u1.bezei AS StudentRegionOfBirthName,
h1702.gbort AS StudentBirthPlaceName,
h1702.gbnat AS StudentNationalityAtBirth,
t005t2.natio AS StudentNationalityAtBirthName,
h1702.natio AS StudentNationality,
t005t3.natio AS StudentNationalityName,
h1702.nati2 AS StudentSecondNationality,
t005t4.natio AS StudentSecondNationalityName,
h1702.nati3 AS StudentThirdNationality,
t005t5.natio AS StudentThirdNationalityName,
h1702.langu AS StudentLanguageOfCommunication,
t002t.sptxt AS StudentLanguageOfCommName,
h1702.anred AS StudentFormOfAddressKey,
t522t.anrlt AS StudentFormOfAddressKeyName,
h1702.gesch AS StudentGenderKey,
domtable.ddtext AS StudentGenderKeyName,
h1702.famst AS StudentMaritalStatus,
t502t.ftext AS StudentMaritalStatusName,
h1702.prdni AS StudentIdentificationNumber,
h1001.sobid AS StudentCampus,
h1000.short AS StudentCampusShortName,
h1000.stext AS StudentCampusName,
storg.sobid AS StudentAssignedOrg,
orgname.short AS StudentAssignedOrgShortName,
orgname.stext AS StudentAssignedOrgName,
h1702.deathdate AS StudentDateOfDeath,
h1702.dregdate AS StudentRecordedDateOfDeath,
h1711.resid_status AS StudentResidentStatus,
t505v.ltext AS StudentResidentStatusName,
h1711.resid_country AS StudentResidentCountry,
t005t6.landx AS StudentResidentCountryName,
h1711.resid_regio AS StudentResidentState,
t005u2.bezei AS StudentResidentStateName,
h1711.resid_counc AS StudentResidentCounty,
t005f.bezei AS StudentResidentCountyName,
h1711.passn AS StudentPassportNumber,
h1711.origin AS StudentOrigin,
_StudentOrigin._StudentOriginText[ 1: Language = $parameters.p_lang ].StudentOriginText AS StudentOriginName,
h1711.pass_issuedate AS StudentPassportIssueDate,
h1711.pass_issueplace AS StudentPassportPlaceOfIssue,
h1711.pass_expirydate AS StudentPassportExpiryDate,
h1705.stgrp AS StudentGroup,
_StudentGroup._StudentGroupText[ 1: Language = $parameters.p_lang ].StudentGroupText AS StudentGroupName,
h1705.regwindow AS StudentModuleBookingTimeWindow,
h1701.confid AS StudentDataPrivacyLevel,
_StudentData._StudentDataText[ 1: Language = $parameters.p_lang ].StudentDataText AS StudentDataPrivacyLevelName,
h1706.stfeecat AS StudentFeeCategory,
_StudentFeeCategory._FeeCategoryText[ 1: Language = $parameters.p_lang ].StudentFeeCategoryName AS StudentFeeCategoryName
LEFT OUTER JOIN hrp1702 AS h1702 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrp1706 AS h1706 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrp1711 AS h1711 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrp1705 AS h1705 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrp1001 AS h1001 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrp1000 AS h1000 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrp1001 AS storg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrp1000 AS orgname ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrp1701 AS h1701 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t005t AS t005t1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t005t AS t005t2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t005t AS t005t3 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t005t AS t005t4 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t005t AS t005t5 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t005u AS t005u1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t002t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t522t ON /* join condition not captured in parsed metadata */
INNER JOIN dd07t AS domtable ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t502t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t500l ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t505v ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t005t AS t005t6 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t005u AS t005u2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t005f ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN PiqCdsStudentOrigin AS _StudentOrigin ON _StudentOrigin.StudentOrigin = h1711.origin -- association [0..*]
LEFT OUTER JOIN PiqCdsStudentGroup AS _StudentGroup ON _StudentGroup.StudentGroup = h1705.stgrp -- association [0..*]
LEFT OUTER JOIN PiqCdsStudentData AS _StudentData ON _StudentData.StudentData = h1701.confid -- association [0..*]
LEFT OUTER JOIN PiqCdsStudentFeeCategory AS _StudentFeeCategory ON _StudentFeeCategory.StudentFeeCategory = h1706.stfeecat -- association [0..*]
;