I_SrvcOrdItmWthSrvcContrCube

DDL: I_SRVCORDITMWTHSRVCCONTRCUBE Type: view COMPOSITE
82 Fields 1 Data Sources 1 Associations

SrvcOrd Itm with SrvcContr - Cube

I_SrvcOrdItmWthSrvcContrCube is a Composite CDS View (Cube) that provides data about "SrvcOrd Itm with SrvcContr - Cube" in SAP S/4HANA. It reads from 1 data source (P_SrvcOrdItmWthSrvcContrDets) and exposes 82 fields with key fields ServiceObjectType, ServiceOrder, ServiceDocumentItem, ServiceDocItmSuccssrCharUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_SrvcOrdItmWthSrvcContrDets P_SrvcOrdItmWthSrvcContrDets from

Parameters (1)

NameTypeDefault
P_DisplayCurrency vdm_v_display_currency

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ServiceDocument _ServiceOrder $projection.ServiceOrder = _ServiceOrder.ServiceDocument and _ServiceOrder.ServiceObjectType = 'BUS2000116'

Annotations (17)

NameValueLevelField
EndUserText.label SrvcOrd Itm with SrvcContr - Cube view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISRVORDWTCONTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
Aggregation.allowPrecisionLoss true view

Fields (82)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Transaction Category
KEY ServiceOrder ServiceOrder Service Order
KEY ServiceDocumentItem ServiceDocumentItem Service Order Item
KEY ServiceDocItmSuccssrCharUUID ServiceDocItmSuccssrCharUUID
ServiceOrderDescription ServiceOrderDescription
ServiceOrderType ServiceOrderType Transaction Type
ServiceOrderItemProduct ServiceOrderItemProduct Product in Service Order Item
ServiceOrderItemStatus ServiceOrderItemStatus Life Cycle Status of Service Order Item
ServiceDocumentItemIsOpen ServiceDocumentItemIsOpen
ServiceOrderItemQuantity ServiceOrderItemQuantity Quantity
ServiceOrderItemQuantityUnit ServiceOrderItemQuantityUnit
ServiceDocumentItemIsRejected ServiceDocumentItemIsRejected
ServiceContract ServiceContract Service Contract Assigned
ServiceContractDescription ServiceContractDescription
ServiceContractItem ServiceContractItem Service Contract Item Assigned
ServiceContractItemProduct ServiceContractItemProduct Product in Service Contract Item
ServiceContrItemBillingStatus ServiceContrItemBillingStatus Billing Status of Service Contract Item
TransactionCurrency TransactionCurrency Transaction Currency
ServiceContractItemStartDate ServiceContractItemStartDate Contract Start
ServiceContractItemEndDate ServiceContractItemEndDate Contract End
ServiceDocItemCreationDate ServiceDocItemCreationDate
ProfitCenter ProfitCenter Profit Center
ControllingArea ControllingArea Controlling Area
PurchaseOrderByCustomer PurchaseOrderByCustomer External Reference ID
DisplayCurrency
NmbrOfFUPServiceOrderItems NmbrOfFUPServiceOrderItems No. of Contr.-Based Service Order Items
NrOfSrvcOrdItmsWthoutContrRef NrOfSrvcOrdItmsWthoutContrRef No. of Non-Contract Service Order Items
ServiceContractItemIsActive ServiceContractItemIsActive Contract Active
Equipment Equipment Equipment check
FunctionalLocation FunctionalLocation Object ID
ServiceReferenceObjectType ServiceReferenceObjectType Reference Object Type
EquipmentCategory EquipmentCategory Equipment Category
FunctionalLocationCategory FunctionalLocationCategory Functional Location Category
TechnicalObjectType TechnicalObjectType Equipment Type
Material Material Reference Product
ConstructionMaterial ConstructionMaterial ConstType
SrvcOrdCreationQuarter SrvcOrdCreationQuarter Calendar Quarter
SrvcOrdCreationMonth SrvcOrdCreationMonth Calendar Month
SrvcOrdCreationYear SrvcOrdCreationYear Year
CreationDateYearQuarter CreationDateYearQuarter Year Quarter
CreationDateYearMonth CreationDateYearMonth Year Month
RefBusinessSolutionOrder RefBusinessSolutionOrder Solution Order
SoldToParty SoldToParty Sold-to Party
SoldToPartyCountry SoldToPartyCountry
SoldToPartyRegion SoldToPartyRegion
Industry Industry Industry Sector
SalesOrganization SalesOrganization Sales Organization
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId Employee Resp.
RespyMgmtServiceTeamDesc RespyMgmtServiceTeamDesc Service Team Description
TeamName TeamName Service Team
_ServiceObjType _ServiceObjType
_ServiceOrder _ServiceOrder
_ServiceDocumentType _ServiceDocumentType
_Product _Product
_TransactionCurrency _TransactionCurrency
_ServiceDocItemStatus _ServiceDocItemStatus
_SrvcDocItmLifecycleStatus _SrvcDocItmLifecycleStatus
_ServiceDocumentIsOpen _ServiceDocumentIsOpen
_SalesUnit _SalesUnit
_SrvcReferenceObjectType _SrvcReferenceObjectType
_MainRefObj _MainRefObj
_Equipment _Equipment
_FunctionalLocation _FunctionalLocation
_EquipmentCategory _EquipmentCategory
_Period _Period
_SoldToParty _SoldToParty
_SoldToPartyCountry _SoldToPartyCountry
_SoldToPartyRegion _SoldToPartyRegion
_Industry _Industry
_SalesOrganization _SalesOrganization
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_DistributionChannel _DistributionChannel
_Division _Division
_RespEmployee _RespEmployee
_ServiceContractItemIsActive _ServiceContractItemIsActive
_ServiceContract _ServiceContract
_SolutionOrderVH _SolutionOrderVH

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_SrvcOrdItmWthSrvcContrCube.
-- 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.
-- Parameters: P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW I_SrvcOrdItmWthSrvcContrCube AS
SELECT
  ServiceObjectType,
  ServiceOrder,
  ServiceDocumentItem,
  ServiceDocItmSuccssrCharUUID,
  ServiceOrderDescription,
  ServiceOrderType,
  ServiceOrderItemProduct,
  ServiceOrderItemStatus,
  ServiceDocumentItemIsOpen,
  ServiceOrderItemQuantity,
  ServiceOrderItemQuantityUnit,
  ServiceDocumentItemIsRejected,
  ServiceContract,
  ServiceContractDescription,
  ServiceContractItem,
  ServiceContractItemProduct,
  ServiceContrItemBillingStatus,
  TransactionCurrency,
  ServiceContractItemStartDate,
  ServiceContractItemEndDate,
  ServiceDocItemCreationDate,
  ProfitCenter,
  ControllingArea,
  PurchaseOrderByCustomer,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  NmbrOfFUPServiceOrderItems,
  NrOfSrvcOrdItmsWthoutContrRef,
  ServiceContractItemIsActive,
  Equipment,
  FunctionalLocation,
  ServiceReferenceObjectType,
  EquipmentCategory,
  FunctionalLocationCategory,
  TechnicalObjectType,
  Material,
  ConstructionMaterial,
  SrvcOrdCreationQuarter,
  SrvcOrdCreationMonth,
  SrvcOrdCreationYear,
  CreationDateYearQuarter,
  CreationDateYearMonth,
  RefBusinessSolutionOrder,
  SoldToParty,
  SoldToPartyCountry,
  SoldToPartyRegion,
  Industry,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  DistributionChannel,
  Division,
  RespEmployeeBusinessPartnerId,
  RespyMgmtServiceTeamDesc,
  TeamName
FROM P_SrvcOrdItmWthSrvcContrDets
LEFT OUTER JOIN I_ServiceDocument AS _ServiceOrder ON ServiceOrder = _ServiceOrder.ServiceDocument AND _ServiceOrder.ServiceObjectType = 'BUS2000116'  -- association [0..1]
;

Learn More