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

P_PendingQuantityandValue

DDL: P_PENDINGQUANTITYANDVALUE SQL: PPENDQTYVAL Type: view CONSUMPTION
7 Fields 1 Data Sources

Private view for Pending Quantity

P_PendingQuantityandValue is a Consumption CDS View that provides data about "Private view for Pending Quantity" in SAP S/4HANA. It reads from 1 data source (P_CalcCommittedQuantity) and exposes 7 fields with key fields PurchasingDocument, PurchasingDocumentItem, SupplierConfirmationCategory, ScheduleLine.

Data Sources (1)

SourceAliasJoin Type
P_CalcCommittedQuantity P_CalcCommittedQuantity from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPENDQTYVAL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Private view for Pending Quantity view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor P_purgdocconf view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
KEY SupplierConfirmationCategory SupplierConfirmationCategory Confirm. Cat.
KEY ScheduleLine ScheduleLine Schedule Line
quan13endasScheduleLinePndgQtyInStkUnit
CommittedQuantity CommittedQuantity
ScheduleLineCommittedAmount ScheduleLineCommittedAmount

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_PendingQuantityandValue.
-- 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: PPENDQTYVAL

CREATE VIEW P_PendingQuantityandValue AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  SupplierConfirmationCategory,
  ScheduleLine,
  case when CommittedQuantity is null then ScheduledQuantity else cast( ScheduledQuantity - CommittedQuantity as abap.quan(13) ) end as ScheduleLinePndgQtyInStkUnit AS quan13endasScheduleLinePndgQtyInStkUnit,
  CommittedQuantity,
  ScheduleLineCommittedAmount
FROM P_CalcCommittedQuantity
;

Learn More