I_ServiceDocumentItemCube

DDL: I_SERVICEDOCUMENTITEMCUBE Type: view COMPOSITE Package: CRMS4_ANALYTICS_COMMON
34 Fields 1 Data Sources

Service Transaction Item Cube

I_ServiceDocumentItemCube is a Composite CDS View (Cube) that provides data about "Service Transaction Item Cube" in SAP S/4HANA. It reads from 1 data source (P_ServiceDocItemAvgDuraTime) and exposes 34 fields with key fields ServiceObjectType, SalesOrganization, DistributionChannel, Division, SalesOffice. Part of development package CRMS4_ANALYTICS_COMMON.

Data Sources (1)

SourceAliasJoin Type
P_ServiceDocItemAvgDuraTime P_ServiceDocItemAvgDuraTime from

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Service Transaction Item Cube view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISERVDOCITEMCUBE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
Analytics.dataCategory #CUBE view
Metadata.allowExtensions true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Object Type
KEY SalesOrganization SalesOrganization Sales Organization
KEY DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
KEY Division Division Internal Division ID
KEY SalesOffice SalesOffice Sales Office
KEY SalesGroup SalesGroup Sales Group
KEY ProductExternalID ProductExternalID Material
ProductName ProductName Description
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceOrderType ServiceOrderType
FunctionalLocation FunctionalLocation Object ID
Material Material Vehicle Model
ProductID ProductID Product ID
Equipment Equipment Equipment check
NmbrOfServiceConfItems NmbrOfServiceConfItems
ServiceOrderAvgLeadTimeInHours
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit _SalesOfficeOrgUnit
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit _SalesGroupOrgUnit
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2
_ServiceObjType _ServiceObjType
_ServiceDocumentType _ServiceDocumentType
_ServiceOrderType _ServiceOrderType

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_ServiceDocumentItemCube.
-- 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_ServiceDocumentItemCube AS
SELECT
  ServiceObjectType,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  ProductExternalID,
  ProductName,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  ServiceDocumentType,
  ServiceOrderType,
  FunctionalLocation,
  Material,
  ProductID,
  Equipment,
  NmbrOfServiceConfItems,
  division(TotalOfActualSrvcDurnInHours, NmbrOfServiceConfItems, 2) AS ServiceOrderAvgLeadTimeInHours
FROM P_ServiceDocItemAvgDuraTime
;

Learn More