I_ServiceDocumentFixedPrice

DDL: I_SERVICEDOCUMENTFIXEDPRICE Type: view BASIC
13 Fields 1 Data Sources 2 Associations

Service Document Fixed Price

I_ServiceDocumentFixedPrice is a Basic CDS View that provides data about "Service Document Fixed Price" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocument) and exposes 13 fields with key fields ServiceObjectType, ServiceDocument, PricingDocument. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocument I_ServiceDocument from

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_ServiceDocumentFixedPrice _PricingElement $projection.PricingDocument = _PricingElement.PricingDocument
[0..1] I_Currency _ConditionCurrency $projection.conditioncurrency = _ConditionCurrency.Currency

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
EndUserText.label Service Document Fixed Price view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISERVDOCFXDPRICE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey PricingDocument view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Object Type
KEY ServiceDocument ServiceDocument Transaction ID
KEY PricingDocument PricingDocument Document Condition
PricingDocumentItem _PricingElement PricingDocumentItem Item
PricingProcedureStep _PricingElement PricingProcedureStep Step Number
PricingProcedureCounter _PricingElement PricingProcedureCounter Pricing Procedure Counter
ConditionType _PricingElement ConditionType Condition type
ConditionCalculationType _PricingElement ConditionCalculationType Calculat.Type
ConditionInactiveReason _PricingElement ConditionInactiveReason Inactive
ConditionCurrency _PricingElement ConditionCurrency Currency
ConditionAmount _PricingElement ConditionAmount Condition Value
_ServiceObjType _ServiceObjType
_ConditionCurrency _ConditionCurrency

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_ServiceDocumentFixedPrice.
-- 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_ServiceDocumentFixedPrice AS
SELECT
  ServiceObjectType,
  ServiceDocument,
  PricingDocument,
  _PricingElement.PricingDocumentItem AS PricingDocumentItem,
  _PricingElement.PricingProcedureStep AS PricingProcedureStep,
  _PricingElement.PricingProcedureCounter AS PricingProcedureCounter,
  _PricingElement.ConditionType AS ConditionType,
  _PricingElement.ConditionCalculationType AS ConditionCalculationType,
  _PricingElement.ConditionInactiveReason AS ConditionInactiveReason,
  _PricingElement.ConditionCurrency AS ConditionCurrency,
  _PricingElement.ConditionAmount AS ConditionAmount
FROM I_ServiceDocument
LEFT OUTER JOIN P_ServiceDocumentFixedPrice AS _PricingElement ON PricingDocument = _PricingElement.PricingDocument  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ConditionCurrency ON conditioncurrency = _ConditionCurrency.Currency  -- association [0..1]
;

Learn More