I_PurContrHdrCndnValdtyTP

DDL: I_PURCONTRHDRCNDNVALDTYTP SQL: IHPCTRCONDVALTP Type: view TRANSACTIONAL
9 Fields 1 Data Sources 2 Associations

Contract Header Condition Validity - TP

I_PurContrHdrCndnValdtyTP is a Transactional CDS View that provides data about "Contract Header Condition Validity - TP" in SAP S/4HANA. It reads from 1 data source (I_PurContrHdrCndnValdty) and exposes 9 fields with key fields PurchaseContract, ConditionRecord, ConditionValidityEndDate. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurContrHdrCndnValdty I_PurContrHdrCndnValdty from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_PurContrHdrCndnAmountTP _PurContrHdrCndnAmountTP $projection.PurchaseContract = _PurContrHdrCndnAmountTP.PurchaseContract and $projection.ConditionRecord = _PurContrHdrCndnAmountTP.ConditionRecord and $projection.ConditionValidityEndDate = _PurContrHdrCndnAmountTP.ConditionValidityEndDate
[1..1] I_PurchaseContractWD _PurchaseContractTP _PurchaseContractTP.PurchaseContract = $projection.PurchaseContract

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IHPCTRCONDVALTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence HPCTRICNDVAL_D view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Contract Header Condition Validity - TP view

Fields (9)

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

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_PurContrHdrCndnValdtyTP.
-- 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: IHPCTRCONDVALTP

CREATE VIEW I_PurContrHdrCndnValdtyTP AS
SELECT
  PurchaseContract,
  ConditionRecord,
  ConditionValidityEndDate,
  ConditionApplication,
  ConditionType,
  ConditionIsDeleted,
  ConditionValidityStartDate
FROM I_PurContrHdrCndnValdty
LEFT OUTER JOIN I_PurContrHdrCndnAmountTP AS _PurContrHdrCndnAmountTP ON PurchaseContract = _PurContrHdrCndnAmountTP.PurchaseContract AND ConditionRecord = _PurContrHdrCndnAmountTP.ConditionRecord AND ConditionValidityEndDate = _PurContrHdrCndnAmountTP.ConditionValidityEndDate  -- association [1..*]
LEFT OUTER JOIN I_PurchaseContractWD AS _PurchaseContractTP ON _PurchaseContractTP.PurchaseContract = PurchaseContract  -- association [1..1]
;

Learn More