I_SolutionProposal

DDL: I_SOLUTIONPROPOSAL SQL: ISOLPROP Type: view COMPOSITE
24 Fields

Solution Proposal

I_SolutionProposal is a Composite CDS View that provides data about "Solution Proposal" in SAP S/4HANA.

Parameters (7)

NameTypeDefault
P_Material matnr
P_Plant werks_d
P_IssueType char3
P_IssueDate datum
P_StartDate datum
P_EndDate datum
P_IssueQuantity basmn

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISOLPROP view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Solution Proposal view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY Material solutions Material Vehicle Model
KEY Plant solutions Plant Valuation Area
KEY SolutionType solutions SolutionType Solution Type
FixType
KEY Customer solutions Customer Sold-to Party
KEY SalesOrder solutions SalesOrder SD Document
KEY SalesOrderItem solutions SalesOrderItem Sales Order Item
KEY ReferenceDocumentScheduleLine solutions ReferenceDocumentScheduleLine Schedule Line
KEY Batch solutions Batch Lot No.
OriginalDeliveryQuantity
DeliveryQuantityInBaseUnit solutions DeliveryQuantityInBaseUnit Base quantity
QuantityUnit solutions QuantityUnit Unit of measure
SolutionCoverage solutions Coverage Coverage No.
Revenue solutions Revenue Net Price
SolutionMargin solutions SolutionMargin Average value
Profit solutions Profit Net Price
CompanyCodeCurrency solutions CompanyCodeCurrency Local Currency
IssueQuantity solutions bubblequantity
SolutionRank
ActualDeliveryQuantity solutions ActualDeliveryQuantity Base quantity
DeliveryQuantity solutions DeliveryQuantity Delivery unit
ActualDeliveryDate solutions ActualDeliveryDate Delivery Date
DeliveryDate solutions DeliveryDate Delivery Date
DifferenceInDeliveryDates

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_SolutionProposal.
-- 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: ISOLPROP
-- Parameters: P_Material : matnr, P_Plant : werks_d, P_IssueType : char3, P_IssueDate : datum, P_StartDate : datum, P_EndDate : datum, P_IssueQuantity : basmn

CREATE VIEW I_SolutionProposal AS
SELECT
  solutions.Material AS Material,
  solutions.Plant AS Plant,
  solutions.SolutionType AS SolutionType,
  solutions.Customer AS Customer,
  solutions.SalesOrder AS SalesOrder,
  solutions.SalesOrderItem AS SalesOrderItem,
  solutions.ReferenceDocumentScheduleLine AS ReferenceDocumentScheduleLine,
  solutions.Batch AS Batch,
  solutions.DeliveryQuantityInBaseUnit AS DeliveryQuantityInBaseUnit,
  solutions.QuantityUnit AS QuantityUnit,
  solutions.Coverage AS SolutionCoverage,
  solutions.Revenue AS Revenue,
  solutions.SolutionMargin AS SolutionMargin,
  solutions.Profit AS Profit,
  solutions.CompanyCodeCurrency AS CompanyCodeCurrency,
  solutions.bubblequantity AS IssueQuantity,
  cast ( solutions.SolutionRank as stck_average_values ) AS SolutionRank,
  solutions.ActualDeliveryQuantity AS ActualDeliveryQuantity,
  solutions.DeliveryQuantity AS DeliveryQuantity,
  solutions.ActualDeliveryDate AS ActualDeliveryDate,
  solutions.DeliveryDate AS DeliveryDate,
  DATS_DAYS_BETWEEN(ActualDeliveryDate,DeliveryDate) AS DifferenceInDeliveryDates
;

Learn More