Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

P_PurchaseContractHistCastAmt

DDL: P_PURCHASECONTRACTHISTCASTAMT SQL: PPURCONHISCSTAMT Type: view CONSUMPTION
7 Fields 1 Data Sources

Purchase Contract History Cast Amount

P_PurchaseContractHistCastAmt is a Consumption CDS View that provides data about "Purchase Contract History Cast Amount" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContractHistory) and exposes 7 fields with key fields PurchaseContract, PurchaseContractItem, ReleaseOrder, ReleaseOrderItem.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContractHistory I_PurchaseContractHistory from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPURCONHISCSTAMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.private true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.status #DEPRECATED view
EndUserText.label Purchase Contract History Cast Amount view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract Purchasing Doc.
KEY PurchaseContractItem PurchaseContractItem Item
KEY ReleaseOrder ReleaseOrder Purchasing Doc.
KEY ReleaseOrderItem ReleaseOrderItem Item
ReleaseOrderItemNetAmount Net Value
ReleaseOrderCurrency ReleaseOrderCurrency Currency
ReleaseOrderItemLastChgDate ReleaseOrderItemLastChgDate Changed On

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_PurchaseContractHistCastAmt.
-- 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: PPURCONHISCSTAMT

CREATE VIEW P_PurchaseContractHistCastAmt AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  ReleaseOrder,
  ReleaseOrderItem,
  cast(ReleaseOrderItemNetAmount as abap.curr(21,5)) AS ReleaseOrderItemNetAmount,
  ReleaseOrderCurrency,
  ReleaseOrderItemLastChgDate
FROM I_PurchaseContractHistory
;

Learn More