P_QuantityContractPrediction1

DDL: P_QUANTITYCONTRACTPREDICTION1 SQL: PQTYCONPREDICT1 Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
26 Fields 1 Data Sources

Quantity Contract Prediction 1

P_QuantityContractPrediction1 is a Consumption CDS View that provides data about "Quantity Contract Prediction 1" in SAP S/4HANA. It reads from 1 data source (I_QuantityContractPrediction) and exposes 26 fields with key fields PurchaseContract, PurchaseContractItem, AccountAssignmentNumber, ReleaseOrder, ReleaseOrderItem. Part of development package ODATA_MM_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
I_QuantityContractPrediction ContractPrediction from

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate vdm_validitystart
P_EndDate vdm_validitystart

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName PQTYCONPREDICT1 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.preserveKey true view
EndUserText.label Quantity Contract Prediction 1 view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_QuantityContractPrediction PurchaseContract Purchasing Doc.
KEY PurchaseContractItem I_QuantityContractPrediction PurchaseContractItem Item
KEY AccountAssignmentNumber AccountAssignmentNumber Account Assgmt No.
KEY ReleaseOrder ReleaseOrder Purchasing Doc.
KEY ReleaseOrderItem ReleaseOrderItem Item
Supplier Supplier Supplier
PurchasingGroup I_QuantityContractPrediction PurchasingGroup Purchasing Group
PurchasingOrganization I_QuantityContractPrediction PurchasingOrganization Purchasing Organization
CompanyCode I_QuantityContractPrediction CompanyCode Receiver Company Code
Material I_QuantityContractPrediction Material Vehicle Model
MaterialGroup I_QuantityContractPrediction MaterialGroup Product Group
Plant I_QuantityContractPrediction Plant Valuation Area
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchaseContractType I_QuantityContractPrediction PurchaseContractType Order Type
PurchasingDocumentItemCategory PurchasingDocumentItemCategory Item Category
CostCenter AccountAssignment CostCenter Cost Center
CreatedByUser CreatedByUser User Name
ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
DisplayCurrency
OrderQuantityUnit I_QuantityContractPrediction OrderQuantityUnit Sales Unit
TargetQuantity TargetQuantity Target Quantity
ReleaseOrderItemOrderQuantity ReleaseOrderItemOrderQuantity PO Quantity
CreationDateasContractNetPriceAmount
ContractExpiryPredictedDate ContractExpiryPredictedDate Predicted Expry Date
PredictedDaysToContrExpiry PredictedDaysToContrExpiry

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

CREATE VIEW P_QuantityContractPrediction1 AS
SELECT
  ContractPrediction.PurchaseContract AS PurchaseContract,
  ContractPrediction.PurchaseContractItem AS PurchaseContractItem,
  AccountAssignmentNumber,
  ReleaseOrder,
  ReleaseOrderItem,
  Supplier,
  ContractPrediction.PurchasingGroup AS PurchasingGroup,
  ContractPrediction.PurchasingOrganization AS PurchasingOrganization,
  ContractPrediction.CompanyCode AS CompanyCode,
  ContractPrediction.Material AS Material,
  ContractPrediction.MaterialGroup AS MaterialGroup,
  ContractPrediction.Plant AS Plant,
  PurchasingDocumentCategory,
  ContractPrediction.PurchaseContractType AS PurchaseContractType,
  PurchasingDocumentItemCategory,
  AccountAssignment.CostCenter AS CostCenter,
  CreatedByUser,
  ValidityEndDate,
  ValidityStartDate,
  cast( $parameters.P_DisplayCurrency as displaycurrency ) AS DisplayCurrency,
  ContractPrediction.OrderQuantityUnit AS OrderQuantityUnit,
  TargetQuantity,
  ReleaseOrderItemOrderQuantity,
  currency_conversion( amount => ContractNetPriceAmount, source_currency => ContractPrediction.DocumentCurrency, target_currency => $parameters.P_DisplayCurrency, exchange_rate_date => ContractPrediction.CreationDate ) as ContractNetPriceAmount AS CreationDateasContractNetPriceAmount,
  ContractExpiryPredictedDate,
  PredictedDaysToContrExpiry
FROM I_QuantityContractPrediction AS ContractPrediction
;

Learn More