I_SalesPerfPrediction

DDL: I_SALESPERFPREDICTION SQL: ISDSLSPERFPRDT Type: view COMPOSITE Package: VDM_SD_PREDICTED_SALES
31 Fields 1 Data Sources 9 Associations

Sales Performance Prediction

I_SalesPerfPrediction is a Composite CDS View that provides data about "Sales Performance Prediction" in SAP S/4HANA. It reads from 1 data source (P_SalesPerfPrediction) and exposes 31 fields with key fields BillingDocumentDateYear, BillingDocDateYearQuarter, BillingDocDateYearMonth, BillingDocumentType, SalesOrganization. It has 9 associations to related views. Part of development package VDM_SD_PREDICTED_SALES.

Data Sources (1)

SourceAliasJoin Type
P_SalesPerfPrediction P_SalesPerfPrediction from

Parameters (2)

NameTypeDefault
P_ExchangeRateType kurst
P_DisplayCurrency vdm_v_display_currency

Associations (9)

CardinalityTargetAliasCondition
[0..1] I_BillingDocumentType _BillingDocumentType $projection.BillingDocumentType = _BillingDocumentType.BillingDocumentType
[0..1] I_SalesOrganization _SalesOrganization $projection.SalesOrganization = _SalesOrganization.SalesOrganization
[0..1] I_DistributionChannel _DistributionChannel $projection.DistributionChannel = _DistributionChannel.DistributionChannel
[0..1] I_Division _Division $projection.Division = _Division.Division
[0..1] I_CustomerGroup _CustomerGroup $projection.CustomerGroup = _CustomerGroup.CustomerGroup
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[0..1] I_Material _Material $projection.Material = _Material.Material
[0..1] I_MaterialGroup _MaterialGroup $projection.MaterialGroup = _MaterialGroup.MaterialGroup
[0..1] I_SalesPlanPurpose _SalesPlanPurpose $projection.SalesPlanPurpose = _SalesPlanPurpose.SalesPlanPurpose

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISDSLSPERFPRDT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Sales Performance Prediction view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY BillingDocumentDateYear BillingDocumentDateYear
KEY BillingDocDateYearQuarter BillingDocDateYearQuarter Year Quarter
KEY BillingDocDateYearMonth Year Month
KEY BillingDocumentType BillingDocumentType Billing Type
KEY SalesOrganization SalesOrganization Sales Organization
KEY DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
KEY Division Division Internal Division ID
KEY CustomerGroup CustomerGroup Customer Group
KEY Customer Customer Sold-to Party
KEY MaterialGroup MaterialGroup Product Group
KEY Material Material Vehicle Model
KEY IsCurrentYearTransaction IsCurrentYearTransaction
KEY SalesPlan SalesPlan Sales Plan
KEY SalesPlanVersion SalesPlanVersion Version
KEY CreatedByUser CreatedByUser User Name
KEY SalesPlanPurpose SalesPlanPurpose Planned For
KEY DisplayCurrency DisplayCurrency Display Currency
SlsVolumeNetAmtInDspCrcy SlsVolumeNetAmtInDspCrcy
SlsVolumeYOYNetAmtInDspCrcy SlsVolumeYOYNetAmtInDspCrcy
SalesPlanAmountInDspCrcy SalesPlanAmountInDspCrcy
PrdtvSlsVolumeNetAmtInDspCrcy PrdtvSlsVolumeNetAmtInDspCrcy
NetSlsVolumeNetAmtInDC NetSlsVolumeNetAmtInDC
_BillingDocumentType _BillingDocumentType
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_CustomerGroup _CustomerGroup
_Customer _Customer
_MaterialGroup _MaterialGroup
_Material _Material
_SalesPlanPurpose _SalesPlanPurpose

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_SalesPerfPrediction.
-- 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: ISDSLSPERFPRDT
-- Parameters: P_ExchangeRateType : kurst, P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW I_SalesPerfPrediction AS
SELECT
  BillingDocumentDateYear,
  BillingDocDateYearQuarter,
  cast( BillingDocDateYearMonth as sd_yearmonth ) AS BillingDocDateYearMonth,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  Division,
  CustomerGroup,
  Customer,
  MaterialGroup,
  Material,
  IsCurrentYearTransaction,
  SalesPlan,
  SalesPlanVersion,
  CreatedByUser,
  SalesPlanPurpose,
  DisplayCurrency,
  SlsVolumeNetAmtInDspCrcy,
  SlsVolumeYOYNetAmtInDspCrcy,
  SalesPlanAmountInDspCrcy,
  PrdtvSlsVolumeNetAmtInDspCrcy,
  NetSlsVolumeNetAmtInDC
FROM P_SalesPerfPrediction
LEFT OUTER JOIN I_BillingDocumentType AS _BillingDocumentType ON BillingDocumentType = _BillingDocumentType.BillingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesPlanPurpose AS _SalesPlanPurpose ON SalesPlanPurpose = _SalesPlanPurpose.SalesPlanPurpose  -- association [0..1]
;

Learn More