P_ContrRelvtCnsmdAmt

DDL: P_CONTRRELVTCNSMDAMT SQL: PCTRRLVCMAT Type: view COMPOSITE Package: VDM_MM_PUR_CON
25 Fields 2 Data Sources

Purchase Contract Relevant Consumed Amount

P_ContrRelvtCnsmdAmt is a Composite CDS View that provides data about "Purchase Contract Relevant Consumed Amount" in SAP S/4HANA. It reads from 2 data sources (P_ContrWithRelevantValidity, I_PurchaseOrderStatus) and exposes 25 fields with key fields PurchaseContract, PurchaseContractItem, ReleaseOrder, ReleaseOrderItem. Part of development package VDM_MM_PUR_CON.

Data Sources (2)

SourceAliasJoin Type
P_ContrWithRelevantValidity ContrWithRelevantValidity from
I_PurchaseOrderStatus PurchaseOrderStatus inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCTRRLVCMAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract Purchasing Doc.
KEY PurchaseContractItem PurchaseContractItem Item
KEY ReleaseOrder ReleaseOrder Purchasing Doc.
KEY ReleaseOrderItem ReleaseOrderItem Item
Purchasingdocumentcategory Purchasingdocumentcategory Doc. Category
PurchaseContractType PurchaseContractType Order Type
DocumentCurrency DocumentCurrency Document Currency
PurchaseContractTargetAmount PurchaseContractTargetAmount Target Value
ReleaseOrderItemOrderQuantity ReleaseOrderItemOrderQuantity PO Quantity
PurchaseContractClassification PurchaseContractClassification
ConsumedValueForQuantity ConsumedValueForQuantity
TargetAmount TargetAmount Target Value
ReleaseOrderCurrency ReleaseOrderCurrency Currency
ReleaseOrderItemNetAmount ReleaseOrderItemNetAmount Net Value
ReleaseOrderItemIsDeleted ReleaseOrderItemIsDeleted Del. Indicator
ReleaseOrderItemLastChgDate ReleaseOrderItemLastChgDate Changed On
ReleaseOrderItemQuantityUnit ReleaseOrderItemQuantityUnit Order Unit
CreatedByUser CreatedByUser User Name
ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
TimeVarianceInDays TimeVarianceInDays Overdue Days
Max_notexpired Max_notexpired
Min_expired Min_expired
PurchasingGroup P_ContrWithRelevantValidity PurchasingGroup Purchasing Group
PurchasingDocumentStatus PurchasingDocumentStatus Short Description

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_ContrRelvtCnsmdAmt.
-- 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: PCTRRLVCMAT

CREATE VIEW P_ContrRelvtCnsmdAmt AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  ReleaseOrder,
  ReleaseOrderItem,
  Purchasingdocumentcategory,
  PurchaseContractType,
  DocumentCurrency,
  PurchaseContractTargetAmount,
  ReleaseOrderItemOrderQuantity,
  PurchaseContractClassification,
  ConsumedValueForQuantity,
  TargetAmount,
  ReleaseOrderCurrency,
  ReleaseOrderItemNetAmount,
  ReleaseOrderItemIsDeleted,
  ReleaseOrderItemLastChgDate,
  ReleaseOrderItemQuantityUnit,
  CreatedByUser,
  ValidityEndDate,
  ValidityStartDate,
  TimeVarianceInDays,
  Max_notexpired,
  Min_expired,
  ContrWithRelevantValidity.PurchasingGroup AS PurchasingGroup,
  PurchasingDocumentStatus
FROM P_ContrWithRelevantValidity AS ContrWithRelevantValidity
INNER JOIN I_PurchaseOrderStatus AS PurchaseOrderStatus ON /* join condition not captured in parsed metadata */
;

Learn More