I_POSitnConfQtyDeficit

DDL: I_POSITNCONFQTYDEFICIT SQL: IPOSITNDEFICIT Type: view COMPOSITE Package: APPL_MM_PUR_PO_AI
26 Fields 1 Data Sources 1 Associations

Trigger CDS for Deficit Quantity

I_POSitnConfQtyDeficit is a Composite CDS View that provides data about "Trigger CDS for Deficit Quantity" in SAP S/4HANA. It reads from 1 data source (P_POSitnConfQtyDeficitTabFunc) and exposes 26 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_POSitnConfQtyDeficitTabFunc P_POSitnConfQtyDeficitTabFunc from

Associations (1)

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

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IPOSITNDEFICIT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Trigger CDS for Deficit Quantity view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (26)

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
ScheduleLine ScheduleLine Schedule Line
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
MaterialName
Supplier Supplier
SupplierName
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 I_POSitnConfQtyDeficit.
-- 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: IPOSITNDEFICIT

CREATE VIEW I_POSitnConfQtyDeficit AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  SupplierConfirmationCategory,
  cast(concat(concat(concat(concat(PurchasingDocument, '/'), PurchasingDocumentItem),'/'),SupplierConfirmationCategory) as vdm_purordhdritmconfcatcnctntd ) AS PurOrdHdrItmConfCatCnctntdID,
  _PurchaseOrderItem.PurchaseOrderItemUniqueID AS PurchaseOrderItemUniqueID,
  ScheduleLine,
  ScheduleLineDeliveryDate,
  OrderedQuantity,
  ConfirmedQuantity,
  DifferenceOfQuantity,
  _PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  ConfirmedDate,
  TotalNoOfDays,
  _PurchaseOrderItem.Material AS Material,
  _PurchaseOrderItem._Material._Text[1: Language = $session.system_language].MaterialName AS MaterialName,
  _PurchaseOrderItem._PurchaseOrder.Supplier AS Supplier,
  _PurchaseOrderItem._PurchaseOrder._Supplier.SupplierName AS SupplierName,
  _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_POSitnConfQtyDeficitTabFunc
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON _PurchaseOrderItem.PurchaseOrder = PurchasingDocument AND _PurchaseOrderItem.PurchaseOrderItem = PurchasingDocumentItem  -- association [1..1]
;

Learn More