P_QuantityContractWithPOCount

DDL: P_QUANTITYCONTRACTWITHPOCOUNT SQL: PQTYCONTPOC Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
25 Fields 3 Data Sources

Quantity Contract With PO Count

P_QuantityContractWithPOCount is a Consumption CDS View that provides data about "Quantity Contract With PO Count" in SAP S/4HANA. It reads from 3 data sources (I_PurContractClassification, I_PurchaseContract, I_PurchaseContractItem) and exposes 25 fields with key fields PurchaseContract, PurchaseContractItem, ReleaseOrder, ReleaseOrderItem. Part of development package ODATA_MM_ANALYTICS.

Data Sources (3)

SourceAliasJoin Type
I_PurContractClassification ContractClassification inner
I_PurchaseContract PurchaseContract inner
I_PurchaseContractItem PurchaseContractItem from

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate vdm_validitystart
P_EndDate vdm_validitystart

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PQTYCONTPOC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.compiler.compareFilter true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
VDM.private true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Quantity Contract With PO Count view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurchaseContractItem PurchaseContract Purchasing Doc.
KEY PurchaseContractItem I_PurchaseContractItem PurchaseContractItem Item
KEY ReleaseOrder ReleaseOrder Purchasing Doc.
KEY ReleaseOrderItem ReleaseOrderItem Item
Supplier I_PurchaseContract Supplier Supplier
PurchasingGroup I_PurchaseContract PurchasingGroup Purchasing Group
PurchasingOrganization I_PurchaseContract PurchasingOrganization Purchasing Organization
CompanyCode I_PurchaseContract CompanyCode Receiver Company Code
PurchasingDocumentCategory I_PurchaseContract PurchasingDocumentCategory Doc. Category
PurchaseContractType I_PurchaseContract PurchaseContractType Order Type
PurchasingDocumentItemCategory PurchasingDocumentItemCategory Item Category
Material I_PurchaseContractItem Material Vehicle Model
MaterialGroup I_PurchaseContractItem MaterialGroup Product Group
Plant I_PurchaseContractItem Plant Valuation Area
DocumentCurrency I_PurchaseContractItem DocumentCurrency Document Currency
CreatedByUser I_PurchaseContract CreatedByUser User Name
ValidityEndDate ValidityEndDate ValidTo
ReleaseOrderDate ReleaseOrderDate PO Date
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution Distribution
ReleaseOrderItemOrderQuantity ReleaseOrderItemOrderQuantity PO Quantity
ReleaseOrderItemNetAmount ReleaseOrderItemNetAmount Net Value
DisplayCurrency
curr212else0endasContractNetPriceAmount
OrderQuantityUnit I_PurchaseContractItem OrderQuantityUnit Sales Unit
TargetQuantity TargetQuantity Target Quantity

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_QuantityContractWithPOCount.
-- 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: PQTYCONTPOC
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : vdm_validitystart, P_EndDate : vdm_validitystart

CREATE VIEW P_QuantityContractWithPOCount AS
SELECT
  PurchaseContractItem.PurchaseContract AS PurchaseContract,
  PurchaseContractItem.PurchaseContractItem AS PurchaseContractItem,
  ReleaseOrder,
  ReleaseOrderItem,
  PurchaseContract.Supplier AS Supplier,
  PurchaseContract.PurchasingGroup AS PurchasingGroup,
  PurchaseContract.PurchasingOrganization AS PurchasingOrganization,
  PurchaseContract.CompanyCode AS CompanyCode,
  PurchaseContract.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  PurchaseContract.PurchaseContractType AS PurchaseContractType,
  PurchasingDocumentItemCategory,
  PurchaseContractItem.Material AS Material,
  PurchaseContractItem.MaterialGroup AS MaterialGroup,
  PurchaseContractItem.Plant AS Plant,
  PurchaseContractItem.DocumentCurrency AS DocumentCurrency,
  PurchaseContract.CreatedByUser AS CreatedByUser,
  ValidityEndDate,
  ReleaseOrderDate,
  MultipleAcctAssgmtDistribution,
  ReleaseOrderItemOrderQuantity,
  ReleaseOrderItemNetAmount,
  cast( $parameters.P_DisplayCurrency as displaycurrency ) AS DisplayCurrency,
  case when NetPriceQuantity > 0 then cast(division (currency_conversion( amount => PurchaseContractItem.ContractNetPriceAmount, source_currency => PurchaseContractItem.DocumentCurrency, target_currency => $parameters.P_DisplayCurrency, exchange_rate_date => PurchaseContract.CreationDate ) , NetPriceQuantity,5) as abap.curr( 21, 2 ) ) else 0 end as ContractNetPriceAmount AS curr212else0endasContractNetPriceAmount,
  PurchaseContractItem.OrderQuantityUnit AS OrderQuantityUnit,
  TargetQuantity
FROM I_PurchaseContractItem AS PurchaseContractItem
INNER JOIN I_PurchaseContract AS PurchaseContract ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurContractClassification AS ContractClassification ON /* join condition not captured in parsed metadata */
;

Learn More