C_ServiceContractIssueQry

DDL: C_SERVICECONTRACTISSUEQRY Type: view CONSUMPTION
42 Fields 1 Data Sources 1 Fiori Apps

Analytical Query For Service Contract Issues

C_ServiceContractIssueQry is a Consumption CDS View that provides data about "Analytical Query For Service Contract Issues" in SAP S/4HANA. It reads from 1 data source (I_ServiceContractIssueCube) and exposes 42 fields with key fields ServiceObjectType, ServiceContract, ServiceContractItem, CustMgmtIssue, BillingRequestItem. It is used in 1 Fiori application: Service Contract Issues.

Data Sources (1)

SourceAliasJoin Type
I_ServiceContractIssueCube I_ServiceContractIssueCube from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CSRVCCONTRISSQRY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Analytics.query true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Analytical Query For Service Contract Issues view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
OData.publish true view
VDM.viewType #CONSUMPTION view

Fiori Apps (1)

App IDApp NameTypeDescription
F4032 Service Contract Issues Transactional, Analytical With this app, you can monitor and display issues that impede the fulfillment of service contracts. You can display results by issue, country and region, and sales organization. Using various filters, you can focus, for instance, on a particular distribution channel, sales organization or service transaction.

Service Contract Issues

Business Role: Others

With this app, you can monitor and display issues that impede the fulfillment of service contracts. The cockpit highlights issues and provides supporting information. It also enables you to collaborate with internal and external contacts.

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Object Type
KEY ServiceContract ServiceContract Transaction ID
KEY ServiceContractItem ServiceContractItem Item Number in Doc.
KEY CustMgmtIssue CustMgmtIssue
KEY BillingRequestItem BillingRequestItem
TransactionCurrency TransactionCurrency Transaction Currency
ServiceContractType ServiceContractType
ServiceContractItemStartDate
ServiceContractItemEndDate
ServiceContractItemNetAmount ServiceContractItemNetAmount
ServiceContractItemGrossAmount ServiceContractItemGrossAmount
SrvcContrItemRnwlDuration SrvcContrItemRnwlDuration
SrvcContrItemRnwlDurationUnit SrvcContrItemRnwlDurationUnit
SrvcContrItemExtensionDuration SrvcContrItemExtensionDuration
SrvcContrItemExtnDurationUnit SrvcContrItemExtnDurationUnit
ResponseProfile ResponseProfile Response Prof.
ServiceProfile ServiceProfile Service Profile
ServiceContractItemCategory ServiceContractItemCategory
ServiceOrganization ServiceOrganization
SalesOrganization SalesOrganization Sales Organization
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SoldToPartyCountry
SoldToPartyRegion
SoldToParty SoldToParty Sold-to Party
ResponsibleEmployee ResponsibleEmployee Employee Resp.
ContactPerson ContactPerson Contact Person Key
ServiceContractItmCanclnReason ServiceContractItmCanclnReason
ServiceContractItemStatus ServiceContractItemStatus
ServiceContractItemHasError ServiceContractItemHasError
ServiceContractItemIsReleased ServiceContractItemIsReleased
ServiceContractItemIsCanceled ServiceContractItemIsCanceled
BillingBlockReason BillingBlockReason
ServiceDocItemBillingStatus ServiceDocItemBillingStatus
SrvcDocItmIsReleasedForBilling SrvcDocItmIsReleasedForBilling
BillgReqItemBillingStatus BillgReqItemBillingStatus
BillgReqItemBillingDate BillgReqItemBillingDate
RefBusinessSolutionOrder RefBusinessSolutionOrder
RefBusinessSolutionOrderItem RefBusinessSolutionOrderItem
TotalNumberOfIssues TotalNumberOfIssues

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_ServiceContractIssueQry.
-- 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_ServiceContractIssueQry AS
SELECT
  ServiceObjectType,
  ServiceContract,
  ServiceContractItem,
  CustMgmtIssue,
  BillingRequestItem,
  TransactionCurrency,
  ServiceContractType,
  cast(ServiceContractItemStartDate as crms4_srvccon_itm_start_date) AS ServiceContractItemStartDate,
  cast(ServiceContractItemEndDate as crms4_srvccon_itm_end_date) AS ServiceContractItemEndDate,
  ServiceContractItemNetAmount,
  ServiceContractItemGrossAmount,
  SrvcContrItemRnwlDuration,
  SrvcContrItemRnwlDurationUnit,
  SrvcContrItemExtensionDuration,
  SrvcContrItemExtnDurationUnit,
  ResponseProfile,
  ServiceProfile,
  ServiceContractItemCategory,
  ServiceOrganization,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  DistributionChannel,
  Division,
  cast(SoldToPartyCountry as countrysoldtoparty) AS SoldToPartyCountry,
  cast(SoldToPartyRegion as crms4_region_soldtoparty) AS SoldToPartyRegion,
  SoldToParty,
  ResponsibleEmployee,
  ContactPerson,
  ServiceContractItmCanclnReason,
  ServiceContractItemStatus,
  ServiceContractItemHasError,
  ServiceContractItemIsReleased,
  ServiceContractItemIsCanceled,
  BillingBlockReason,
  ServiceDocItemBillingStatus,
  SrvcDocItmIsReleasedForBilling,
  BillgReqItemBillingStatus,
  BillgReqItemBillingDate,
  RefBusinessSolutionOrder,
  RefBusinessSolutionOrderItem,
  TotalNumberOfIssues
FROM I_ServiceContractIssueCube
;

Learn More