C_POSuplrConfQuantityDeficit

DDL: C_POSUPLRCONFQUANTITYDEFICIT SQL: CPOCONFQTYDEF Type: view CONSUMPTION Package: ODATA_MM_PUR_PO_MAINTAIN_V2
24 Fields 1 Data Sources 1 Associations

Supplier Confirmation Quantity Deficit

C_POSuplrConfQuantityDeficit is a Consumption CDS View that provides data about "Supplier Confirmation Quantity Deficit" in SAP S/4HANA. It reads from 1 data source (P_POSuplrConfQuantityDeficit) and exposes 24 fields with key fields PurchasingDocument, PurchasingDocumentItem, SupplierConfirmationCategory. It has 1 association to related views. Part of development package ODATA_MM_PUR_PO_MAINTAIN_V2.

Data Sources (1)

SourceAliasJoin Type
P_POSuplrConfQuantityDeficit P_POSuplrConfQuantityDeficit from

Parameters (3)

NameTypeDefault
P_PurchasingDocument ebeln
P_PurchasingDocumentItem ebelp
P_SupplierConfirmationCategory ebtyp

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PurgInfoRecordWithOrgData _inforecdata _inforecdata.Material = $projection.Material and _inforecdata.Plant = $projection.Plant and _inforecdata.PurchasingInfoRecordCategory = $projection.PurchaseOrderItemCategory and _inforecdata.PurchasingOrganization = $projection.PurchasingOrganization and _inforecdata.Supplier = $projection.Supplier and _inforecdata.Material != '' and _inforecdata.Material is not null

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CPOCONFQTYDEF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Supplier Confirmation Quantity Deficit view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
KEY SupplierConfirmationCategory SupplierConfirmationCategory Confirm. Cat.
PurOrdHdrItmConfCatCnctntdID PurOrdHdrItmConfCatCnctntdID Purchase Order Item Confirmation Category
PurchaseOrderItemCategory PurchaseOrderItemCategory Item Category
Material Material Vehicle Model
Supplier Supplier Supplier
TotalNoOfDays TotalNoOfDays Days Left Until Requested Delivery
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
DifferenceOfQuantity DifferenceOfQuantity Deficit Quantity
ConfirmedQuantity ConfirmedQuantity Confirmed Quantity
OrderedQuantity OrderedQuantity Requested Quantity
ConfirmedDate ConfirmedDate Confirmed Delivery Date
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Requested Delivery Date
MaterialPlannedDeliveryDurn _inforecdata MaterialPlannedDeliveryDurn Delivery Time in Days
PurchasingInfoRecord _inforecdata PurchasingInfoRecord Info Record
NetPriceAmount NetPriceAmount Net Order Price
DocumentCurrency DocumentCurrency Document Currency
NetPriceQuantity NetPriceQuantity Price Unit
OrderPriceUnit OrderPriceUnit Order Price Un.
PurchaseOrderType PurchaseOrderType PO Type
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
Plant Plant Valuation Area

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_POSuplrConfQuantityDeficit.
-- 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: CPOCONFQTYDEF
-- Parameters: P_PurchasingDocument : ebeln, P_PurchasingDocumentItem : ebelp, P_SupplierConfirmationCategory : ebtyp

CREATE VIEW C_POSuplrConfQuantityDeficit AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  SupplierConfirmationCategory,
  PurOrdHdrItmConfCatCnctntdID,
  PurchaseOrderItemCategory,
  Material,
  Supplier,
  TotalNoOfDays,
  PurchaseOrderQuantityUnit,
  DifferenceOfQuantity,
  ConfirmedQuantity,
  OrderedQuantity,
  ConfirmedDate,
  ScheduleLineDeliveryDate,
  _inforecdata.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  _inforecdata.PurchasingInfoRecord AS PurchasingInfoRecord,
  NetPriceAmount,
  DocumentCurrency,
  NetPriceQuantity,
  OrderPriceUnit,
  PurchaseOrderType,
  PurchasingOrganization,
  PurchasingGroup,
  Plant
FROM P_POSuplrConfQuantityDeficit
LEFT OUTER JOIN I_PurgInfoRecordWithOrgData AS _inforecdata ON _inforecdata.Material = Material AND _inforecdata.Plant = Plant AND _inforecdata.PurchasingInfoRecordCategory = PurchaseOrderItemCategory AND _inforecdata.PurchasingOrganization = PurchasingOrganization AND _inforecdata.Supplier = Supplier AND _inforecdata.Material != '' AND _inforecdata.Material is not null  -- association [1..1]
;

Learn More