C_SrvcContrItmFutrPrcNotif

DDL: C_SRVCCONTRITMFUTRPRCNOTIF Type: view_entity CONSUMPTION
5 Fields 1 Data Sources 1 Associations

SrvcContr Item with Price Check Notif

C_SrvcContrItmFutrPrcNotif is a Consumption CDS View that provides data about "SrvcContr Item with Price Check Notif" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 5 fields with key fields ServiceObjectType, ServiceContract, ServiceContractItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd SrvcContrItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BusinessUserBasic RespEmployeeUser SrvcContrItem.ResponsibleEmployee = RespEmployeeUser.BusinessPartner

Annotations (9)

NameValueLevelField
EndUserText.label SrvcContr Item with Price Check Notif view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.uniqueIdField ServiceContractItemUUID view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType I_ServiceDocumentItemEnhcd ServiceObjectType Object Type
KEY ServiceContract I_ServiceDocumentItemEnhcd ServiceDocument Transaction ID
KEY ServiceContractItem I_ServiceDocumentItemEnhcd ServiceDocumentItem Service Document
ServiceContractItemUUID I_ServiceDocumentItemEnhcd ServiceDocumentItemUUID
ResponsibleEmployeeUserID RespEmployeeUser UserID User Name

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 C_SrvcContrItmFutrPrcNotif.
-- 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 C_SrvcContrItmFutrPrcNotif AS
SELECT
  SrvcContrItem.ServiceObjectType AS ServiceObjectType,
  SrvcContrItem.ServiceDocument AS ServiceContract,
  SrvcContrItem.ServiceDocumentItem AS ServiceContractItem,
  SrvcContrItem.ServiceDocumentItemUUID AS ServiceContractItemUUID,
  RespEmployeeUser.UserID AS ResponsibleEmployeeUserID
FROM I_ServiceDocumentItemEnhcd AS SrvcContrItem
LEFT OUTER JOIN I_BusinessUserBasic AS RespEmployeeUser ON SrvcContrItem.ResponsibleEmployee = RespEmployeeUser.BusinessPartner  -- association [0..1]
;

Learn More