I_ChgRecHdrExtension

DDL: I_CHGRECHDREXTENSION Type: view_entity BASIC Package: VDM_PLMB_CR
13 Fields 1 Data Sources

Change Record Header Ext for DEX

I_ChgRecHdrExtension is a Basic CDS View that provides data about "Change Record Header Ext for DEX" in SAP S/4HANA. It reads from 1 data source (/plmi/cr_hdr_ext) and exposes 13 fields with key fields ChgRecdHdrExtnUUID, ChangeRecordUUID. Part of development package VDM_PLMB_CR.

Data Sources (1)

SourceAliasJoin Type
/plmi/cr_hdr_ext crhdrext from

Annotations (8)

NameValueLevelField
EndUserText.label Change Record Header Ext for DEX view
VDM.viewType #BASIC view
ObjectModel.sapObjectNodeType.name ChangeRecord view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ChgRecdHdrExtnUUID /plmi/cr_hdr_ext db_key UUID
KEY ChangeRecordUUID /plmi/cr_hdr_ext db_key UUID
ParentChangeRecordUUID /plmi/cr_hdr_ext parent_key UUID
ChgRecdReasonForChange /plmi/cr_hdr_ext reasonforchange Reason for Chge
ChgRecdChangeStatus /plmi/cr_hdr_ext chgstatus Status
ChgRecdExpectedCompletionDate /plmi/cr_hdr_ext expected_comp_dat Exp Completion Date
ChgRecdPrflIdn /plmi/cr_hdr_ext profile WBS sched. prof
ChangeRecordDetailDescription /plmi/cr_hdr_ext rich_text Detailed Description
ChgRecdEngEffectiveDate /plmi/cr_hdr_ext eng_effective_date Eng Effective Date
ChgRecdMfgEffectiveDate /plmi/cr_hdr_ext mfg_effective_date Mfg Effective Date
ChgRecdInitiatedStatusAction /plmi/cr_hdr_ext digsign_user_act Pndg Status Chg
ChangeRecordItemEditMode /plmi/cr_hdr_ext item_change_allowed Item Edit Mode
ChgRecdSilentDataMigrtnStatus /plmi/cr_hdr_ext sdm_status status value done

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_ChgRecHdrExtension.
-- 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_ChgRecHdrExtension AS
SELECT
  crhdrext.db_key AS ChgRecdHdrExtnUUID,
  crhdrext.db_key AS ChangeRecordUUID,
  crhdrext.parent_key AS ParentChangeRecordUUID,
  crhdrext.reasonforchange AS ChgRecdReasonForChange,
  crhdrext.chgstatus AS ChgRecdChangeStatus,
  crhdrext.expected_comp_dat AS ChgRecdExpectedCompletionDate,
  crhdrext.profile AS ChgRecdPrflIdn,
  crhdrext.rich_text AS ChangeRecordDetailDescription,
  crhdrext.eng_effective_date AS ChgRecdEngEffectiveDate,
  crhdrext.mfg_effective_date AS ChgRecdMfgEffectiveDate,
  crhdrext.digsign_user_act AS ChgRecdInitiatedStatusAction,
  crhdrext.item_change_allowed AS ChangeRecordItemEditMode,
  crhdrext.sdm_status AS ChgRecdSilentDataMigrtnStatus
FROM /plmi/cr_hdr_ext AS crhdrext
;

Learn More