I_PurContrHdrCndnValdty

DDL: I_PURCONTRHDRCNDNVALDTY SQL: IPCTRHDRCNDVAL Type: view COMPOSITE Package: VDM_MM_PUR_CON
9 Fields 1 Data Sources 2 Associations

Contract Header Condition Validity

I_PurContrHdrCndnValdty is a Composite CDS View that provides data about "Contract Header Condition Validity" in SAP S/4HANA. It reads from 1 data source (P_PurContrHdrCndnValdty) and exposes 9 fields with key fields ConditionRecord, ConditionValidityEndDate. It has 2 associations to related views. Part of development package VDM_MM_PUR_CON.

Data Sources (1)

SourceAliasJoin Type
P_PurContrHdrCndnValdty PurContrHdrCndValdty from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_PurContrHdrCndnAmount _PurContrHdrCndnAmount PurContrHdrCndValdty.ConditionRecord = _PurContrHdrCndnAmount.ConditionRecord
[1..1] I_PurchaseContract _PurchaseContract _PurchaseContract.PurchaseContract = $projection.PurchaseContract

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPCTRHDRCNDVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Contract Header Condition Validity view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ConditionRecord P_PurContrHdrCndnValdty ConditionRecord Cond.Record No.
KEY ConditionValidityEndDate P_PurContrHdrCndnValdty ConditionValidityEndDate Valid To
ConditionApplication P_PurContrHdrCndnValdty ConditionApplication Application
ConditionType P_PurContrHdrCndnValdty ConditionType Condition type
PurchaseContract P_PurContrHdrCndnValdty PurchaseContract Purchasing Doc.
ConditionValidityStartDate P_PurContrHdrCndnValdty ConditionValidityStartDate Valid From
ConditionIsDeleted P_PurContrHdrCndnValdty ConditionIsDeleted Deletion Indic.
_PurContrHdrCndnAmount _PurContrHdrCndnAmount
_PurchaseContract _PurchaseContract

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_PurContrHdrCndnValdty.
-- 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: IPCTRHDRCNDVAL

CREATE VIEW I_PurContrHdrCndnValdty AS
SELECT
  PurContrHdrCndValdty.ConditionRecord AS ConditionRecord,
  PurContrHdrCndValdty.ConditionValidityEndDate AS ConditionValidityEndDate,
  PurContrHdrCndValdty.ConditionApplication AS ConditionApplication,
  PurContrHdrCndValdty.ConditionType AS ConditionType,
  PurContrHdrCndValdty.PurchaseContract AS PurchaseContract,
  PurContrHdrCndValdty.ConditionValidityStartDate AS ConditionValidityStartDate,
  PurContrHdrCndValdty.ConditionIsDeleted AS ConditionIsDeleted
FROM P_PurContrHdrCndnValdty AS PurContrHdrCndValdty
LEFT OUTER JOIN I_PurContrHdrCndnAmount AS _PurContrHdrCndnAmount ON PurContrHdrCndValdty.ConditionRecord = _PurContrHdrCndnAmount.ConditionRecord  -- association [1..*]
LEFT OUTER JOIN I_PurchaseContract AS _PurchaseContract ON _PurchaseContract.PurchaseContract = PurchaseContract  -- association [1..1]
;

Learn More