P_POSuplrConfQuantityDeficit

DDL: P_POSUPLRCONFQUANTITYDEFICIT SQL: PPOCONFQTYDEF Type: view CONSUMPTION Package: APPL_MM_PUR_PO_AI
23 Fields 1 Data Sources 1 Associations

Supplier Confirmation Quantity Deficit

P_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_POItemSitnConfQtyDeficit) and exposes 23 fields with key fields PurchasingDocument, PurchasingDocumentItem, SupplierConfirmationCategory. It has 1 association to related views. Part of development package APPL_MM_PUR_PO_AI.

Data Sources (1)

SourceAliasJoin Type
P_POItemSitnConfQtyDeficit P_POItemSitnConfQtyDeficit from

Parameters (3)

NameTypeDefault
P_PurchasingDocument ebeln
P_PurchasingDocumentItem ebelp
P_SupplierConfirmationCategory ebtyp

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrderItem _PurchaseOrderItem _PurchaseOrderItem.PurchaseOrder = $projection.PurchasingDocument and _PurchaseOrderItem.PurchaseOrderItem = $projection.PurchasingDocumentItem

Annotations (12)

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

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument PurchasingDocument Purchase Order
KEY PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
KEY SupplierConfirmationCategory SupplierConfirmationCategory Confirm. Cat.
PurOrdHdrItmConfCatCnctntdID Purchase Order Item Confirmation Category
PurchaseOrderItemUniqueID _PurchaseOrderItem PurchaseOrderItemUniqueID Document Item
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Delivery Date
OrderedQuantity OrderedQuantity Ordered Quantity
ConfirmedQuantity ConfirmedQuantity Confirmed Quantity
DifferenceOfQuantity DifferenceOfQuantity Deficit Quantity
PurchaseOrderQuantityUnit _PurchaseOrderItem PurchaseOrderQuantityUnit Order Unit
ConfirmedDate ConfirmedDate Confirmed Date
TotalNoOfDays TotalNoOfDays Days Left Until Requested Delivery
Material _PurchaseOrderItem Material Vehicle Model
Supplier Supplier
PurchaseOrderItemCategory _PurchaseOrderItem PurchaseOrderItemCategory Item Category
NetPriceAmount _PurchaseOrderItem NetPriceAmount Net Order Price
DocumentCurrency _PurchaseOrderItem DocumentCurrency Document Currency
NetPriceQuantity _PurchaseOrderItem NetPriceQuantity Price Unit
OrderPriceUnit _PurchaseOrderItem OrderPriceUnit Order Price Un.
PurchaseOrderType
PurchasingOrganization
PurchasingGroup
Plant _PurchaseOrderItem 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 P_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: PPOCONFQTYDEF
-- Parameters: P_PurchasingDocument : ebeln, P_PurchasingDocumentItem : ebelp, P_SupplierConfirmationCategory : ebtyp

CREATE VIEW P_POSuplrConfQuantityDeficit AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  SupplierConfirmationCategory,
  cast(concat(concat(concat(concat(PurchasingDocument, '/'), PurchasingDocumentItem),'/'),SupplierConfirmationCategory) as vdm_purordhdritmconfcatcnctntd ) AS PurOrdHdrItmConfCatCnctntdID,
  _PurchaseOrderItem.PurchaseOrderItemUniqueID AS PurchaseOrderItemUniqueID,
  ScheduleLineDeliveryDate,
  OrderedQuantity,
  ConfirmedQuantity,
  DifferenceOfQuantity,
  _PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  ConfirmedDate,
  TotalNoOfDays,
  _PurchaseOrderItem.Material AS Material,
  _PurchaseOrderItem._PurchaseOrder.Supplier AS Supplier,
  _PurchaseOrderItem.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  _PurchaseOrderItem.NetPriceAmount AS NetPriceAmount,
  _PurchaseOrderItem.DocumentCurrency AS DocumentCurrency,
  _PurchaseOrderItem.NetPriceQuantity AS NetPriceQuantity,
  _PurchaseOrderItem.OrderPriceUnit AS OrderPriceUnit,
  _PurchaseOrderItem._PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  _PurchaseOrderItem. _PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrderItem._PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  _PurchaseOrderItem.Plant AS Plant
FROM P_POItemSitnConfQtyDeficit
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON _PurchaseOrderItem.PurchaseOrder = PurchasingDocument AND _PurchaseOrderItem.PurchaseOrderItem = PurchasingDocumentItem  -- association [1..1]
;

Learn More