P_CndnContrConditionHeader

DDL: P_CNDNCONTRCONDITIONHEADER Type: view BASIC
8 Fields 1 Data Sources

P_CndnContrConditionHeader is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (konh) and exposes 8 fields with key fields ConditionContract, ConditionRecord.

Data Sources (1)

SourceAliasJoin Type
konh konh from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PWCBCCKONH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ConditionContract ccnum Condition Contract
KEY ConditionRecord knumh NoCondRec.Batch
ConditionTable Table Number
ConditionApplication kappl Application
ConditionValidityStartDate datab Validity period
ConditionValidityEndDate datbi Validity period
CreatedByUser ernam User Name
CreationDate erdat Entered On

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_CndnContrConditionHeader.
-- 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 P_CndnContrConditionHeader AS
SELECT
  ccnum AS ConditionContract,
  knumh AS ConditionRecord,
  cast(kotabnr as kotabnr_char) AS ConditionTable,
  kappl AS ConditionApplication,
  datab AS ConditionValidityStartDate,
  datbi AS ConditionValidityEndDate,
  ernam AS CreatedByUser,
  erdat AS CreationDate
FROM konh
;

Learn More