I_CntrlPurContrHdrCndnValdty

DDL: I_CNTRLPURCONTRHDRCNDNVALDTY SQL: ICCTRHDRCNDVAL Type: view COMPOSITE Package: VDM_MM_PUR_CCTR
9 Fields 1 Data Sources 2 Associations

Central Contract Hdr Condition Validity

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

Data Sources (1)

SourceAliasJoin Type
P_CntrlPurContrHdrCndnValdty CntrlPurContrHdrCndValdty from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_CntrlPurContrHdrCndnAmount _CntrlPurContrHdrCndnAmount CntrlPurContrHdrCndValdty.ConditionRecord = _CntrlPurContrHdrCndnAmount.ConditionRecord
[1..1] I_CentralPurchaseContract _CentralPurchaseContract _CentralPurchaseContract.CentralPurchaseContract = $projection.CentralPurchaseContract

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICCTRHDRCNDVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Central Contract Hdr 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_CntrlPurContrHdrCndnValdty ConditionRecord Cond.Record No.
KEY ConditionValidityEndDate P_CntrlPurContrHdrCndnValdty ConditionValidityEndDate Valid To
ConditionApplication P_CntrlPurContrHdrCndnValdty ConditionApplication Application
ConditionType P_CntrlPurContrHdrCndnValdty ConditionType Condition type
CentralPurchaseContract P_CntrlPurContrHdrCndnValdty CentralPurchaseContract Purchasing Doc.
ConditionValidityStartDate P_CntrlPurContrHdrCndnValdty ConditionValidityStartDate Valid From
ConditionIsDeleted P_CntrlPurContrHdrCndnValdty ConditionIsDeleted Deletion Indic.
_CntrlPurContrHdrCndnAmount _CntrlPurContrHdrCndnAmount
_CentralPurchaseContract _CentralPurchaseContract

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_CntrlPurContrHdrCndnValdty.
-- 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: ICCTRHDRCNDVAL

CREATE VIEW I_CntrlPurContrHdrCndnValdty AS
SELECT
  CntrlPurContrHdrCndValdty.ConditionRecord AS ConditionRecord,
  CntrlPurContrHdrCndValdty.ConditionValidityEndDate AS ConditionValidityEndDate,
  CntrlPurContrHdrCndValdty.ConditionApplication AS ConditionApplication,
  CntrlPurContrHdrCndValdty.ConditionType AS ConditionType,
  CntrlPurContrHdrCndValdty.CentralPurchaseContract AS CentralPurchaseContract,
  CntrlPurContrHdrCndValdty.ConditionValidityStartDate AS ConditionValidityStartDate,
  CntrlPurContrHdrCndValdty.ConditionIsDeleted AS ConditionIsDeleted
FROM P_CntrlPurContrHdrCndnValdty AS CntrlPurContrHdrCndValdty
LEFT OUTER JOIN I_CntrlPurContrHdrCndnAmount AS _CntrlPurContrHdrCndnAmount ON CntrlPurContrHdrCndValdty.ConditionRecord = _CntrlPurContrHdrCndnAmount.ConditionRecord  -- association [1..*]
LEFT OUTER JOIN I_CentralPurchaseContract AS _CentralPurchaseContract ON _CentralPurchaseContract.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
;

Learn More