P_IHBConditionChgDocHeader

DDL: P_IHBCONDITIONCHGDOCHEADER SQL: PIHBCONDCDHDR Type: view COMPOSITE
7 Fields 1 Data Sources

P_IHBConditionChgDocHeader is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ChangeDocument) and exposes 7 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocument.

Data Sources (1)

SourceAliasJoin Type
I_ChangeDocument _ChangeDocument from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PIHBCONDCDHDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject I_ChangeDocument ChangeDocObject Object Value
KEY ChangeDocObjectClass I_ChangeDocument ChangeDocObjectClass Change Doc. Object
KEY ChangeDocument I_ChangeDocument ChangeDocument Document Number
CreatedByUser I_ChangeDocument CreatedByUser User Name
CreationDate I_ChangeDocument CreationDate Time Stamp
CreationTime I_ChangeDocument CreationTime Time of Change
IHBObjectUUID

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 P_IHBConditionChgDocHeader.
-- 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: PIHBCONDCDHDR

CREATE VIEW P_IHBConditionChgDocHeader AS
SELECT
  _ChangeDocument.ChangeDocObject AS ChangeDocObject,
  _ChangeDocument.ChangeDocObjectClass AS ChangeDocObjectClass,
  _ChangeDocument.ChangeDocument AS ChangeDocument,
  _ChangeDocument.CreatedByUser AS CreatedByUser,
  _ChangeDocument.CreationDate AS CreationDate,
  _ChangeDocument.CreationTime AS CreationTime,
  cast(left(ChangeDocObject,16) as char16 preserving type) AS IHBObjectUUID
FROM I_ChangeDocument AS _ChangeDocument
;

Learn More