C_ServiceOrderProductVH

DDL: C_SERVICEORDERPRODUCTVH SQL: CSRVORDERPRODVH Type: view CONSUMPTION
33 Fields 1 Data Sources

Value Help for Items in Confirmation

C_ServiceOrderProductVH is a Consumption CDS View that provides data about "Value Help for Items in Confirmation" in SAP S/4HANA. It reads from 1 data source (P_SrvcConfProduct) and exposes 33 fields with key fields ServiceDocument, ServiceDocumentItem.

Data Sources (1)

SourceAliasJoin Type
P_SrvcConfProduct P_SrvcConfProduct from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSRVORDERPRODVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Value Help for Items in Confirmation view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
Search.searchable true view
Consumption.ranked true view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocument ServiceDocument Transaction ID
KEY ServiceDocumentItem ServiceDocumentItem Service Document
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceDocItemCategory ServiceDocItemCategory
ServiceDocItemCategoryName ServiceDocItemCategoryName
OriginallyRequestedProduct OriginallyRequestedProduct
ServiceDocumentItemDescription ServiceDocumentItemDescription
ServiceDocumentItemQuantity ServiceDocumentItemQuantity
ServiceDocItemQuantityUnit ServiceDocItemQuantityUnit
SrvcOrdItemIsUnplanned SrvcDocItemIsUnplanned
ActualServiceDuration ActualServiceDuration
ActualServiceDurationUnit ActualServiceDurationUnit
ServiceDuration ServiceDuration Work Duration
ServiceDurationUnit ServiceDurationUnit Unit
ResponsibleEmployee ResponsibleEmployee Employee Resp.
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
BillableControl BillableControl Billable Control
ParentServiceDocumentItemUUID ParentServiceDocumentItemUUID
ServiceObjectType ServiceObjectType Object Type
ItemCategoryGroup ItemCategoryGroup Item Cat. Group
ParentServiceDocumentItem ParentServiceDocumentItem Service Document
ParSrvcDocItemQuantity ParSrvcDocItemQuantity
SrvcProductListProduct SrvcProductListProduct
SrvcProductListProductName SrvcProductListProductName
SrvcDocItemIsBundle _ParentItemDetails ItemCategoryGroup Item Cat. Group

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_ServiceOrderProductVH.
-- 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: CSRVORDERPRODVH

CREATE VIEW C_ServiceOrderProductVH AS
SELECT
  ServiceDocument,
  ServiceDocumentItem,
  ServiceDocumentType,
  ServiceDocItemCategory,
  ServiceDocItemCategoryName,
  OriginallyRequestedProduct,
  ServiceDocumentItemDescription,
  ServiceDocumentItemQuantity,
  ServiceDocItemQuantityUnit,
  SrvcDocItemIsUnplanned AS SrvcOrdItemIsUnplanned,
  ActualServiceDuration,
  ActualServiceDurationUnit,
  ServiceDuration,
  ServiceDurationUnit,
  ResponsibleEmployee,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  BillableControl,
  ParentServiceDocumentItemUUID,
  ServiceObjectType,
  ItemCategoryGroup,
  ParentServiceDocumentItem,
  ParSrvcDocItemQuantity,
  SrvcProductListProduct,
  SrvcProductListProductName,
  _ParentItemDetails.ItemCategoryGroup AS SrvcDocItemIsBundle
FROM P_SrvcConfProduct
;

Learn More