I_CN_HCMFamilyMemberSupplement

DDL: I_CN_HCMFAMILYMEMBERSUPPLEMENT Type: view_entity BASIC
58 Fields 1 Data Sources

HCM Family Member Supplement CN

I_CN_HCMFamilyMemberSupplement is a Basic CDS View that provides data about "HCM Family Member Supplement CN" in SAP S/4HANA. It reads from 1 data source (pa0528) and exposes 58 fields with key fields HCMPersonnelNumber, HCMSubtype, HCMObjectIdentification, HCMRecordIsLocked, EndDate.

Data Sources (1)

SourceAliasJoin Type
pa0528 pa0528 from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label HCM Family Member Supplement CN view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY HCMPersonnelNumber pernr Personnel no.
KEY HCMSubtype subty Subtype
KEY HCMObjectIdentification objps Object ID
KEY HCMRecordIsLocked sprps Single-Character Flag
KEY EndDate endda Valid To
KEY StartDate begda Valid From
KEY HCMSequentialNumber seqnr Tank ID
LastChangedDate aedtm Changed On
LastChangedByUser uname User Name
HCMInfoTypeRecordIsHistorical histo Historical rec.
HCMInfoTypeRecordHasText itxex Text exists
HCMInfoTypeRecordHasRefField refex Single-Character Flag
HCMInfoTypeRecordHasConfField ordex Single-Character Flag
HCMInfoTypeRecordScreenCtrl itbld Screen control
HCMMasterDataChangeReason preas Change Reason
HCMInfoTypeRecordRsrvdFld1 flag1 Text field length 1
HCMInfoTypeRecordRsrvdFld2 flag2 Tr. Evaluation
HCMInfoTypeRecordRsrvdFld3 flag3 Text field length 1
HCMInfoTypeRecordRsrvdFld4 flag4 Usage in the OWN Authorization Context
HCMInfoTypeRecordRsrvdFld1Len2 rese1 Reserved Field/Unused Field of Length 2
HCMInfoTypeRecordRsrvdFld2Len2 rese2 Reserved Field/Unused Field of Length 2
HCMGrpgValForPersAssignments grpvl Grouping Value
HCMFamMbrIdTypeCode1 icty1 ID Type
HCMFamMbrIdNumber1 idnm1 Id. number
HCMFamMbrIdTypeCode2 icty2 ID Type
HCMFamMbrIdNumber2 idnm2 Id. number
HCMFamMbrIdTypeCode3 icty3 ID Type
HCMFamMbrIdNumber3 idnm3 Id. number
HCMFamMbrIdTypeCode4 icty4 ID Type
HCMFamMbrIdNumber4 idnm4 Id. number
HCMFamMbrIdTypeCode5 icty5 ID Type
HCMFamMbrIdNumber5 idnm5 Id. number
HCMFamMbrTelephoneNumber telnr Telephone number
HCMFamMbrIsSameCompany samer same company
HCMFamMbrMaritalStatusCode famst Marital stat.
HCMFamMbrMaritalStatusDate famdt Since
HCMFamMbrPoliticalStatusCode pstat Processing Status
HCMFamMbrOccupationText occup Occupations
HCMFamMbrJobStatusCode statu Vehicle Status
HCMFamMbrFormOfAddressCode anred Title
HCMFamMbrCommTypeCode1 com01 Type
HCMFamMbrCommNumber1 num01 Number
HCMFamMbrCommTypeCode2 com02 Type
HCMFamMbrCommNumber2 num02 Number
HCMFamMbrCommTypeCode3 com03 Type
HCMFamMbrCommNumber3 num03 Number
HCMFamMbrCommTypeCode4 com04 Type
HCMFamMbrCommNumber4 num04 Number
HCMFamMbrPostalCode pstlz Postal Code
HCMFamMbrCountryCode land1 Trip Ctry/Reg
HCMFamMbrRegionCode state Vehicle Region
HCMFamMbrCityText city1 City
HCMFamMbrDistrictText distr Spec. Distribution
HCMFamMbrStreetText stras Street/House
HCMFamMbrChineseName cnnam Chinese name
HCMFamMbrIsOnlyChild olchd Only Child
HCMFamMbrOnlyChildId olnum Certificate ID
HCMFamMbrOnlyChildCertDate olcdt Certificate Dte

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_CN_HCMFamilyMemberSupplement.
-- 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_CN_HCMFamilyMemberSupplement AS
SELECT
  pernr AS HCMPersonnelNumber,
  subty AS HCMSubtype,
  objps AS HCMObjectIdentification,
  sprps AS HCMRecordIsLocked,
  endda AS EndDate,
  begda AS StartDate,
  seqnr AS HCMSequentialNumber,
  aedtm AS LastChangedDate,
  uname AS LastChangedByUser,
  histo AS HCMInfoTypeRecordIsHistorical,
  itxex AS HCMInfoTypeRecordHasText,
  refex AS HCMInfoTypeRecordHasRefField,
  ordex AS HCMInfoTypeRecordHasConfField,
  itbld AS HCMInfoTypeRecordScreenCtrl,
  preas AS HCMMasterDataChangeReason,
  flag1 AS HCMInfoTypeRecordRsrvdFld1,
  flag2 AS HCMInfoTypeRecordRsrvdFld2,
  flag3 AS HCMInfoTypeRecordRsrvdFld3,
  flag4 AS HCMInfoTypeRecordRsrvdFld4,
  rese1 AS HCMInfoTypeRecordRsrvdFld1Len2,
  rese2 AS HCMInfoTypeRecordRsrvdFld2Len2,
  grpvl AS HCMGrpgValForPersAssignments,
  icty1 AS HCMFamMbrIdTypeCode1,
  idnm1 AS HCMFamMbrIdNumber1,
  icty2 AS HCMFamMbrIdTypeCode2,
  idnm2 AS HCMFamMbrIdNumber2,
  icty3 AS HCMFamMbrIdTypeCode3,
  idnm3 AS HCMFamMbrIdNumber3,
  icty4 AS HCMFamMbrIdTypeCode4,
  idnm4 AS HCMFamMbrIdNumber4,
  icty5 AS HCMFamMbrIdTypeCode5,
  idnm5 AS HCMFamMbrIdNumber5,
  telnr AS HCMFamMbrTelephoneNumber,
  samer AS HCMFamMbrIsSameCompany,
  famst AS HCMFamMbrMaritalStatusCode,
  famdt AS HCMFamMbrMaritalStatusDate,
  pstat AS HCMFamMbrPoliticalStatusCode,
  occup AS HCMFamMbrOccupationText,
  statu AS HCMFamMbrJobStatusCode,
  anred AS HCMFamMbrFormOfAddressCode,
  com01 AS HCMFamMbrCommTypeCode1,
  num01 AS HCMFamMbrCommNumber1,
  com02 AS HCMFamMbrCommTypeCode2,
  num02 AS HCMFamMbrCommNumber2,
  com03 AS HCMFamMbrCommTypeCode3,
  num03 AS HCMFamMbrCommNumber3,
  com04 AS HCMFamMbrCommTypeCode4,
  num04 AS HCMFamMbrCommNumber4,
  pstlz AS HCMFamMbrPostalCode,
  land1 AS HCMFamMbrCountryCode,
  state AS HCMFamMbrRegionCode,
  city1 AS HCMFamMbrCityText,
  distr AS HCMFamMbrDistrictText,
  stras AS HCMFamMbrStreetText,
  cnnam AS HCMFamMbrChineseName,
  olchd AS HCMFamMbrIsOnlyChild,
  olnum AS HCMFamMbrOnlyChildId,
  olcdt AS HCMFamMbrOnlyChildCertDate
FROM pa0528
;

Learn More