P_PurContractCommitmentPlan

DDL: P_PURCONTRACTCOMMITMENTPLAN Type: view_entity BASIC
9 Fields 1 Data Sources 2 Associations

P_PurContractCommitmentPlan is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (ekcph) and exposes 9 fields with key fields PurchaseContract, PurchaseContractItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
ekcph ekcph from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurchaseContractItem _PurchaseContractItem _PurchaseContractItem.PurchaseContract = $projection.PurchaseContract and _PurchaseContractItem.PurchaseContractItem = $projection.PurchaseContractItem
[1..1] I_PurchaseContract _PurchaseContract _PurchaseContract.PurchaseContract = $projection.PurchaseContract

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey PurchaseContractItem view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
VDM.private true view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract ebeln Source PurchDoc
KEY PurchaseContractItem ebelp Item pur. doc.
DocumentCurrency waers Transaction Currency
OutlineAgreementTargetAmount Target Value
CommitmentPlanCategory cptype CP Category
CompanyCode bukrs Value
AccountAssignmentCategory AcctAssgnCat:CC
_PurchaseContract _PurchaseContract
_PurchaseContractItem _PurchaseContractItem

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_PurContractCommitmentPlan.
-- 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_PurContractCommitmentPlan AS
SELECT
  ebeln AS PurchaseContract,
  ebelp AS PurchaseContractItem,
  waers AS DocumentCurrency,
  cast(cpvalue_header as dzwert preserving type) AS OutlineAgreementTargetAmount,
  cptype AS CommitmentPlanCategory,
  bukrs AS CompanyCode,
  cast(knttp as knttp preserving type) AS AccountAssignmentCategory
FROM ekcph
LEFT OUTER JOIN I_PurchaseContractItem AS _PurchaseContractItem ON _PurchaseContractItem.PurchaseContract = PurchaseContract AND _PurchaseContractItem.PurchaseContractItem = PurchaseContractItem  -- association [1..1]
LEFT OUTER JOIN I_PurchaseContract AS _PurchaseContract ON _PurchaseContract.PurchaseContract = PurchaseContract  -- association [1..1]
;

Learn More