C_PPS_PurContrCmtmtPlanItmTP_2

DDL: C_PPS_PURCONTRCMTMTPLANITMTP_2 Type: view_entity CONSUMPTION
24 Fields 1 Data Sources

PPS Purchase contract CP item

C_PPS_PurContrCmtmtPlanItmTP_2 is a Consumption CDS View that provides data about "PPS Purchase contract CP item" in SAP S/4HANA. It reads from 1 data source (R_PPS_PurContrCmtmtPlanItemTP) and exposes 24 fields with key fields PurchaseContract, PurchaseContractItem, CommitmentPlanItemNumber.

Data Sources (1)

SourceAliasJoin Type
R_PPS_PurContrCmtmtPlanItemTP R_PPS_PurContrCmtmtPlanItemTP projection

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label PPS Purchase contract CP item view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey CommitmentPlanItemNumber view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view
VDM.viewType #CONSUMPTION view
AbapCatalog.extensibility.extensible true view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract Purchasing Doc.
KEY PurchaseContractItem PurchaseContractItem Item
KEY CommitmentPlanItemNumber CommitmentPlanItemNumber Comm. Plan Item
CommitmentPlanItemValidityDate CommitmentPlanItemValidityDate Valid
DocumentCurrency DocumentCurrency Document Currency
CommitmentPlanItemAmount CommitmentPlanItemAmount Comm. Amount
GenerateEarmarkedFundIsSet GenerateEarmarkedFundIsSet Generate
CommitmentPlanItemIsClosed CommitmentPlanItemIsClosed Closed
EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
LastChangeDateTime LastChangeDateTime Timestamp
virtualUICT_HideAcctAssnmntFieldsboolean
virtualUICT_HideCostCenterboolean
virtualUICT_HideContractIDboolean
virtualUICT_HideNetworkboolean
virtualUICT_HideBusinessAreaboolean
virtualUICT_HideGLAccountboolean
virtualUICT_HideControllingAreaboolean
virtualUICT_HideFundboolean
virtualUICT_HideFundsCenterboolean
virtualUICT_HideCommitmentItemboolean
virtualUICT_HideFunctionalAreaboolean
virtualUICT_HideGrantIDboolean
virtualUICT_HideBudgetPeriodboolean
virtualUICT_HideQuantityboolean

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 C_PPS_PurContrCmtmtPlanItmTP_2.
-- 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 C_PPS_PurContrCmtmtPlanItmTP_2 AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  CommitmentPlanItemNumber,
  CommitmentPlanItemValidityDate,
  DocumentCurrency,
  CommitmentPlanItemAmount,
  GenerateEarmarkedFundIsSet,
  CommitmentPlanItemIsClosed,
  EarmarkedFundsDocument,
  LastChangeDateTime,
  virtual UICT_HideAcctAssnmntFields : boolean AS virtualUICT_HideAcctAssnmntFieldsboolean,
  virtual UICT_HideCostCenter : boolean AS virtualUICT_HideCostCenterboolean,
  virtual UICT_HideContractID : boolean AS virtualUICT_HideContractIDboolean,
  virtual UICT_HideNetwork : boolean AS virtualUICT_HideNetworkboolean,
  virtual UICT_HideBusinessArea : boolean AS virtualUICT_HideBusinessAreaboolean,
  virtual UICT_HideGLAccount : boolean AS virtualUICT_HideGLAccountboolean,
  virtual UICT_HideControllingArea : boolean AS virtualUICT_HideControllingAreaboolean,
  virtual UICT_HideFund : boolean AS virtualUICT_HideFundboolean,
  virtual UICT_HideFundsCenter : boolean AS virtualUICT_HideFundsCenterboolean,
  virtual UICT_HideCommitmentItem : boolean AS virtualUICT_HideCommitmentItemboolean,
  virtual UICT_HideFunctionalArea : boolean AS virtualUICT_HideFunctionalAreaboolean,
  virtual UICT_HideGrantID : boolean AS virtualUICT_HideGrantIDboolean,
  virtual UICT_HideBudgetPeriod : boolean AS virtualUICT_HideBudgetPeriodboolean,
  virtual UICT_HideQuantity : boolean AS virtualUICT_HideQuantityboolean
FROM R_PPS_PurContrCmtmtPlanItemTP
;

Learn More