What is C_BusSolnOrdItmSitnReltdInfo in SAP S/4HANA?

C_BusSolnOrdItmSitnReltdInfo is a consumption CDS view in SAP S/4HANA. Solution Order Situation Related Information It contains 35 fields.

Which tables does C_BusSolnOrdItmSitnReltdInfo read from?

C_BusSolnOrdItmSitnReltdInfo reads data from: I_ServiceDocumentItemEnhcd.

What VDM layer is C_BusSolnOrdItmSitnReltdInfo?

C_BusSolnOrdItmSitnReltdInfo is classified as a Consumption view optimized for specific business scenarios and reporting.

C_BusSolnOrdItmSitnReltdInfo

DDL: C_BUSSOLNORDITMSITNRELTDINFO Type: view CONSUMPTION

35 Fields 1 Data Sources 4 Associations

Solution Order Situation Related Information

C_BusSolnOrdItmSitnReltdInfo is a Consumption CDS View that provides data about "Solution Order Situation Related Information" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 35 fields with key fields BusinessSolutionOrder, BusinessSolutionOrderItem. It has 4 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_ServiceDocumentItemEnhcd	ServiceDocumentItemEnhcd	from

Associations (4)

Cardinality	Target	Alias	Condition
[0..1]	I_BusSolnOrdItmFUPEntProject	_BusSolnOrdEntProject	`$projection.BusinessSolutionOrder = _BusSolnOrdEntProject.BusinessSolutionOrder and $projection.BusinessSolutionOrderItem = _BusSolnOrdEntProject.BusinessSolutionOrderItem`
[0..1]	I_CustMgmtPartner	_ProjectManager	`$projection.BusinessSolutionOrder = _ProjectManager.CustMgmtDocument and $projection.BusinessSolutionOrderItem = _ProjectManager.CustMgmtDocumentItem and _ProjectManager.CustMgmtPartnerFunction = 'PROJM001' and _ProjectManager.CustMgmtPartFunctionCategory = '0093' and _ProjectManager.CustMgmtObjectType = 'BUS2000172'`
[0..1]	I_PPM_ProjProcessingStsTxt	_ProcessingStsTxt	`_ProcessingStsTxt.ProcessingStatus = $projection.ProcessingStatus and _ProcessingStsTxt.LanguageCode = $session.system_language`
[0..1]	I_SrvcMgmtObjectStatus	_BusSolnOrdItemStatus	`$projection.BusinessSolutionOrderItemUUID = _BusSolnOrdItemStatus.SrvcMgmtObjectUUID and ( _BusSolnOrdItemStatus.SrvcMgmtObjectStatus = 'I1002' or _BusSolnOrdItemStatus.SrvcMgmtObjectStatus = 'I1003' or _BusSolnOrdItemStatus.SrvcMgmtObjectStatus = 'I1004' or _BusSolnOrdItemStatus.SrvcMgmtObjectStatus = 'I1005' ) and _BusSolnOrdItemStatus.SrvcMgmtObjectStatusIsInactive = ''`

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	CBSOISITNRELINFO	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
EndUserText.label	Solution Order Situation Related Information	view

Fields (35)

Key	Field	Source Table	Source Field	Description
KEY	BusinessSolutionOrder	I_ServiceDocumentItemEnhcd	ServiceDocument	Transaction ID
KEY	BusinessSolutionOrderItem	I_ServiceDocumentItemEnhcd	ServiceDocumentItem	Service Document
	BusinessSolutionOrderItemUUID	I_ServiceDocumentItemEnhcd	ServiceDocumentItemUUID
	BusSolnOrderItemCharUUID	I_ServiceDocumentItemEnhcd	ServiceDocumentItemCharUUID
	BusSolnOrdItmCategory	I_ServiceDocumentItemEnhcd	ServiceDocItemCategory
	ServiceDocItemCategoryName
	SystemStatus	_BusSolnOrdItemStatus	SrvcMgmtObjectStatus
	SrvcDocItmDeliveryStatus	I_ServiceDocumentItemEnhcd	SrvcDocItmDeliveryStatus
	ServiceContractItemStartDate	I_ServiceDocumentItemEnhcd	ServiceContractItemStartDate
	ServiceContractItemEndDate	I_ServiceDocumentItemEnhcd	ServiceContractItemEndDate
	LtstConfirmedDeliveryDateTime	I_ServiceDocumentItemEnhcd	LtstConfirmedDeliveryDateTime
	PlannedServiceStartDateTime	I_ServiceDocumentItemEnhcd	PlannedServiceStartDateTime
	PlannedServiceEndDateTime	I_ServiceDocumentItemEnhcd	PlannedServiceEndDateTime
	RequestedServiceStartDateTime	I_ServiceDocumentItemEnhcd	RequestedServiceStartDateTime
	RequestedServiceEndDateTime	I_ServiceDocumentItemEnhcd	RequestedServiceEndDateTime
	ProjectStartDate
	ProjectEndDate
	ProcessingStatus
	SalesOfficeOrgUnitID	I_ServiceDocumentItemEnhcd	SalesOfficeOrgUnitID
	SalesOrganizationOrgUnitID	I_ServiceDocumentItemEnhcd	SalesOrganizationOrgUnitID
	SalesGroupOrgUnitID	I_ServiceDocumentItemEnhcd	SalesGroupOrgUnitID
	ServiceOrganization	I_ServiceDocumentItemEnhcd	ServiceOrganization
	SoldToParty	I_ServiceDocumentItemEnhcd	SoldToParty	Sold-to Party
	RespEmployeeBusinessPartnerId	I_ServiceDocumentItemEnhcd	ResponsibleEmployee	Employee Resp.
	BusSolnOrdType	I_ServiceDocumentItemEnhcd	ServiceDocumentType	Transaction Type
	ServiceObjectType	I_ServiceDocumentItemEnhcd	ServiceObjectType	Object Type
	SalesOrganization	I_ServiceDocumentItemEnhcd	SalesOrganization	Sales Organization
	SalesOffice	I_ServiceDocumentItemEnhcd	SalesOffice	Sales Office
	SalesGroup	I_ServiceDocumentItemEnhcd	SalesGroup	Sales Group
	DistributionChannel	I_ServiceDocumentItemEnhcd	DistributionChannel	RefDistCh-Cust/Mat.
	Division	I_ServiceDocumentItemEnhcd	Division	Internal Division ID
	_ServiceDocument	I_ServiceDocumentItemEnhcd	_ServiceDocument
	_RespEmployee	I_ServiceDocumentItemEnhcd	_RespEmployee
	_ProjectManager		_ProjectManager
	_ProcessingStsTxt		_ProcessingStsTxt

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_BusSolnOrdItmSitnReltdInfo.
-- 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_BusSolnOrdItmSitnReltdInfo AS
SELECT
  ServiceDocumentItemEnhcd.ServiceDocument AS BusinessSolutionOrder,
  ServiceDocumentItemEnhcd.ServiceDocumentItem AS BusinessSolutionOrderItem,
  ServiceDocumentItemEnhcd.ServiceDocumentItemUUID AS BusinessSolutionOrderItemUUID,
  ServiceDocumentItemEnhcd.ServiceDocumentItemCharUUID AS BusSolnOrderItemCharUUID,
  ServiceDocumentItemEnhcd.ServiceDocItemCategory AS BusSolnOrdItmCategory,
  _ServiceDocItemCategory._ServiceDocItemCategoryText[ Language = $session.system_language ].ServiceDocItemCategoryName AS ServiceDocItemCategoryName,
  _BusSolnOrdItemStatus.SrvcMgmtObjectStatus AS SystemStatus,
  ServiceDocumentItemEnhcd.SrvcDocItmDeliveryStatus AS SrvcDocItmDeliveryStatus,
  ServiceDocumentItemEnhcd.ServiceContractItemStartDate AS ServiceContractItemStartDate,
  ServiceDocumentItemEnhcd.ServiceContractItemEndDate AS ServiceContractItemEndDate,
  ServiceDocumentItemEnhcd.LtstConfirmedDeliveryDateTime AS LtstConfirmedDeliveryDateTime,
  ServiceDocumentItemEnhcd.PlannedServiceStartDateTime AS PlannedServiceStartDateTime,
  ServiceDocumentItemEnhcd.PlannedServiceEndDateTime AS PlannedServiceEndDateTime,
  ServiceDocumentItemEnhcd.RequestedServiceStartDateTime AS RequestedServiceStartDateTime,
  ServiceDocumentItemEnhcd.RequestedServiceEndDateTime AS RequestedServiceEndDateTime,
  _BusSolnOrdEntProject._EnterpriseProject.ProjectStartDate AS ProjectStartDate,
  _BusSolnOrdEntProject._EnterpriseProject.ProjectEndDate AS ProjectEndDate,
  _BusSolnOrdEntProject._EnterpriseProject.ProcessingStatus AS ProcessingStatus,
  ServiceDocumentItemEnhcd.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  ServiceDocumentItemEnhcd.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  ServiceDocumentItemEnhcd.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  ServiceDocumentItemEnhcd.ServiceOrganization AS ServiceOrganization,
  ServiceDocumentItemEnhcd.SoldToParty AS SoldToParty,
  ServiceDocumentItemEnhcd.ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  ServiceDocumentItemEnhcd.ServiceDocumentType AS BusSolnOrdType,
  ServiceDocumentItemEnhcd.ServiceObjectType AS ServiceObjectType,
  ServiceDocumentItemEnhcd.SalesOrganization AS SalesOrganization,
  ServiceDocumentItemEnhcd.SalesOffice AS SalesOffice,
  ServiceDocumentItemEnhcd.SalesGroup AS SalesGroup,
  ServiceDocumentItemEnhcd.DistributionChannel AS DistributionChannel,
  ServiceDocumentItemEnhcd.Division AS Division,
  ServiceDocumentItemEnhcd._ServiceDocument AS _ServiceDocument,
  ServiceDocumentItemEnhcd._RespEmployee AS _RespEmployee
FROM I_ServiceDocumentItemEnhcd AS ServiceDocumentItemEnhcd
LEFT OUTER JOIN I_BusSolnOrdItmFUPEntProject AS _BusSolnOrdEntProject ON BusinessSolutionOrder = _BusSolnOrdEntProject.BusinessSolutionOrder AND BusinessSolutionOrderItem = _BusSolnOrdEntProject.BusinessSolutionOrderItem  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtPartner AS _ProjectManager ON BusinessSolutionOrder = _ProjectManager.CustMgmtDocument AND BusinessSolutionOrderItem = _ProjectManager.CustMgmtDocumentItem AND _ProjectManager.CustMgmtPartnerFunction = 'PROJM001' AND _ProjectManager.CustMgmtPartFunctionCategory = '0093' AND _ProjectManager.CustMgmtObjectType = 'BUS2000172'  -- association [0..1]
LEFT OUTER JOIN I_PPM_ProjProcessingStsTxt AS _ProcessingStsTxt ON _ProcessingStsTxt.ProcessingStatus = ProcessingStatus AND _ProcessingStsTxt.LanguageCode = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtObjectStatus AS _BusSolnOrdItemStatus ON BusinessSolutionOrderItemUUID = _BusSolnOrdItemStatus.SrvcMgmtObjectUUID AND ( _BusSolnOrdItemStatus.SrvcMgmtObjectStatus = 'I1002' OR _BusSolnOrdItemStatus.SrvcMgmtObjectStatus = 'I1003' OR _BusSolnOrdItemStatus.SrvcMgmtObjectStatus = 'I1004' OR _BusSolnOrdItemStatus.SrvcMgmtObjectStatus = 'I1005' ) AND _BusSolnOrdItemStatus.SrvcMgmtObjectStatusIsInactive = ''  -- association [0..1]
;

Depth:

C_BusSolnOrdItmSitnReltdInfo view

I_ServiceDocumentItemEnhcd view