I_SrvcDocItemFuturePrice

DDL: I_SRVCDOCITEMFUTUREPRICE Type: view_entity BASIC
14 Fields 1 Data Sources

Future Prices of Service Trans Item

I_SrvcDocItemFuturePrice is a Basic CDS View that provides data about "Future Prices of Service Trans Item" in SAP S/4HANA. It reads from 1 data source (crms4d_futr_prc) and exposes 14 fields with key fields ServiceObjectType, ServiceDocument, ServiceDocumentItem, SrvcDocItemFuturePriceRecord.

Data Sources (1)

SourceAliasJoin Type
crms4d_futr_prc crms4d_futr_prc from

Annotations (7)

NameValueLevelField
VDM.viewType #BASIC view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Future Prices of Service Trans Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType objtype_h Trans. Cat.
KEY ServiceDocument object_id Transaction ID
KEY ServiceDocumentItem number_int Item Number in Doc.
KEY SrvcDocItemFuturePriceRecord record_id UUID
SrvcDocItmFutrPrcStartDateTime future_price_start Start Date
SrvcDocItmFutrPrcEndDateTime future_price_end End Date
ConditionType condition_type RAI Condition Type
SrvcDocItmFutrPriceBaseAmount base_price Base Price
SrvcDocItmFutrPriceCndnCrcy condition_currency Currency
SrvcDocItmFutrPriceCndnQty condition_quantity Pricing Unit
SrvcDocItmFutrPriceCndnQtyUnit condition_quantity_unit UoM
SrvcDocItmFutrPriceChangeRatio price_change_ratio Price Change Ratio
SrvcDocItmFutureTargetPrice target_price Target Price
SrvcDocItmRnwlNotifDateTime notification_date Notification Date

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_SrvcDocItemFuturePrice.
-- 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.

CREATE VIEW I_SrvcDocItemFuturePrice AS
SELECT
  objtype_h AS ServiceObjectType,
  object_id AS ServiceDocument,
  number_int AS ServiceDocumentItem,
  record_id AS SrvcDocItemFuturePriceRecord,
  future_price_start AS SrvcDocItmFutrPrcStartDateTime,
  future_price_end AS SrvcDocItmFutrPrcEndDateTime,
  condition_type AS ConditionType,
  base_price AS SrvcDocItmFutrPriceBaseAmount,
  condition_currency AS SrvcDocItmFutrPriceCndnCrcy,
  condition_quantity AS SrvcDocItmFutrPriceCndnQty,
  condition_quantity_unit AS SrvcDocItmFutrPriceCndnQtyUnit,
  price_change_ratio AS SrvcDocItmFutrPriceChangeRatio,
  target_price AS SrvcDocItmFutureTargetPrice,
  notification_date AS SrvcDocItmRnwlNotifDateTime
FROM crms4d_futr_prc
;

Learn More