C_BusSolnPrtfloSrvcOrderVH

DDL: C_BUSSOLNPRTFLOSRVCORDERVH SQL: CBSPSRVOVH Type: view CONSUMPTION
20 Fields 1 Data Sources 2 Associations 1 OData Services

Value Help: Service Order

C_BusSolnPrtfloSrvcOrderVH is a Consumption CDS View that provides data about "Value Help: Service Order" in SAP S/4HANA. It reads from 1 data source (I_ServiceOrderStdVH) and exposes 20 fields with key fields ServiceDocumentType, ServiceDocument. It has 2 associations to related views. It is exposed through 1 OData service (C_BUSSOLUTIONPORTFOLIO_SRV).

Data Sources (1)

SourceAliasJoin Type
I_ServiceOrderStdVH _ServiceOrder from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ServiceDocument _ServiceDocument $projection.ServiceDocument = _ServiceDocument.ServiceDocument and $projection.ServiceDocumentType = _ServiceDocument.ServiceDocumentType
[0..1] I_BusinessPartner _SoldToParty $projection.SoldToParty = _SoldToParty.BusinessPartner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CBSPSRVOVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
EndUserText.label Value Help: Service Order view

OData Services (1)

ServiceBindingVersionContractRelease
C_BUSSOLUTIONPORTFOLIO_SRV C_BUSSOLUTIONPORTFOLIO V2 C1 NOT_RELEASED

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentType ServiceDocumentType Transaction Type
KEY ServiceDocument ServiceDocument Service Order ID
ServiceObjectType ServiceObjectType Transaction Category
ServiceDocumentDescription ServiceDocumentDescription Service Order Description
SoldToParty SoldToParty Sold-To Party
BusinessPartnerName _SoldToParty BusinessPartnerName Extracted Customer Name
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId Employee Resp.
clientNULLasRequestedServiceStartDate Requested Start Date
clientNULLasRequestedServiceEndDate Requested End Date
_ServiceDocumentType _ServiceDocumentType
_SoldToParty _SoldToParty

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_BusSolnPrtfloSrvcOrderVH.
-- 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.
-- SQL view name: CBSPSRVOVH

CREATE VIEW C_BusSolnPrtfloSrvcOrderVH AS
SELECT
  ServiceDocumentType,
  ServiceDocument,
  ServiceObjectType,
  ServiceDocumentDescription,
  SoldToParty,
  _SoldToParty.BusinessPartnerName AS BusinessPartnerName,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  RespEmployeeBusinessPartnerId,
  tstmp_to_dats( _ServiceDocument.RequestedServiceStartDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as RequestedServiceStartDate AS clientNULLasRequestedServiceStartDate,
  tstmp_to_dats( _ServiceDocument.RequestedServiceEndDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as RequestedServiceEndDate AS clientNULLasRequestedServiceEndDate
FROM I_ServiceOrderStdVH AS _ServiceOrder
LEFT OUTER JOIN I_ServiceDocument AS _ServiceDocument ON ServiceDocument = _ServiceDocument.ServiceDocument AND ServiceDocumentType = _ServiceDocument.ServiceDocumentType  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartner AS _SoldToParty ON SoldToParty = _SoldToParty.BusinessPartner  -- association [0..1]
;

Learn More