I_BusSolnOrdItmRefObjectTP

DDL: I_BUSSOLNORDITMREFOBJECTTP Type: view_entity TRANSACTIONAL Package: CRMS4_SOLUTION_ORDER_RAP

Business Solution Order Item Reference Object - TP

I_BusSolnOrdItmRefObjectTP is a Transactional CDS View that provides data about "Business Solution Order Item Reference Object - TP" in SAP S/4HANA. It reads from 1 data source (R_BusSolnOrdItmRefObjectTP) and exposes 11 fields with key fields BusinessSolutionOrder, BusinessSolutionOrderItem, ServiceRefObjectSequenceNumber. Part of development package CRMS4_SOLUTION_ORDER_RAP.

Data Sources (1)

SourceAliasJoin Type
R_BusSolnOrdItmRefObjectTP R_BusSolnOrdItmRefObjectTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Business Solution Order Item Reference Object - TP view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY BusinessSolutionOrder BusinessSolutionOrder Solution Order
KEY BusinessSolutionOrderItem BusinessSolutionOrderItem Solution Order Item
KEY ServiceRefObjectSequenceNumber ServiceRefObjectSequenceNumber
SerialNumber SerialNumber Serial Number
ServiceReferenceEquipment ServiceReferenceEquipment Equipment check
ServiceRefFunctionalLocation ServiceRefFunctionalLocation
ServiceReferenceProduct ServiceReferenceProduct Product ID
SrvcRefObjIsMainObject SrvcRefObjIsMainObject
_EquipmentText _EquipmentText
_FunctionalLocationText _FunctionalLocationText
_ProductText _ProductText

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_BusSolnOrdItmRefObjectTP.
-- 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_BusSolnOrdItmRefObjectTP AS
SELECT
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  ServiceRefObjectSequenceNumber,
  SerialNumber,
  ServiceReferenceEquipment,
  ServiceRefFunctionalLocation,
  ServiceReferenceProduct,
  SrvcRefObjIsMainObject
FROM R_BusSolnOrdItmRefObjectTP
;