C_SrvcContrFinQuery_2

DDL: C_SRVCCONTRFINQUERY_2 Type: view CONSUMPTION
53 Fields 1 Data Sources 2 Associations 1 Fiori Apps

Finance Data in Service Contract – Query

C_SrvcContrFinQuery_2 is a Consumption CDS View that provides data about "Finance Data in Service Contract – Query" in SAP S/4HANA. It reads from 1 data source (I_SrvcContrFinancialCube_2) and exposes 53 fields with key fields ServiceObjectType, ServiceContract, ServiceContractItem, SemanticTag, AccountingDocument. It has 2 associations to related views. It is used in 1 Fiori application: Service Contracts Analysis.

Data Sources (1)

SourceAliasJoin Type
I_SrvcContrFinancialCube_2 I_SrvcContrFinancialCube_2 from

Parameters (1)

NameTypeDefault
P_DisplayCurrency vdm_v_display_currency

Associations (2)

CardinalityTargetAliasCondition
[1] I_ServiceDocumentItem _SrvcContrItem $projection.ServiceContract = _SrvcContrItem.ServiceDocument and $projection.ServiceContractItem = _SrvcContrItem.ServiceDocumentItem and _SrvcContrItem.ServiceObjectType = 'BUS2000112'
[1] I_ServiceDocument _SrvcContr $projection.ServiceContract = _SrvcContr.ServiceDocument and _SrvcContr.ServiceObjectType = 'BUS2000112'

Annotations (17)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Finance Data in Service Contract – Query view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AbapCatalog.sqlViewName CSRVCCONTRFINQY2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey LedgerGLLineItem view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
Analytics.query true view
OData.publish true view
Analytics.settings.olapPushdown #OFF view

Fiori Apps (1)

App IDApp NameTypeDescription
F3942 Service Contracts Analysis Analytical With this app, you can display service contracts by contract value as well as various other key performance indicators. The app enables you to see at a glance whether your profit margin is low for a particular service contract, service organization, or region. You access this app through the Service Management Overview app.

Service Contracts Analysis

Business Role: Customer Service Manager (Customer Management)

With this app, you as a customer service manager can obtain a graphical overview of key service process data and gain insights into the current service situation. You can display detail information that helps you examine and analyze data across various dimensions.

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Transaction Category
KEY ServiceContract ServiceContract Service Contract ID
KEY ServiceContractItem ServiceContractItem Item No.
KEY SemanticTag SemanticTag Semantic Tag
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
CalendarYear CalendarYear Year
CalendarWeek CalendarWeek Calendar Week
CreationDate CreationDate Time Stamp
ServiceDocumentItemCanclnParty ServiceDocumentItemCanclnParty Cancelling Party
ServiceDocumentItmCanclnReason ServiceDocumentItmCanclnReason Cancellation Reason
ServiceDocumentIsOpen ServiceDocumentIsOpen Open Contract
ServiceContractType ServiceContractType Service Contract Type
SoldToPartyCountry SoldToPartyCountry
SoldToPartyRegion SoldToPartyRegion
RegionName Region Name
ShipToParty ShipToParty Ship-To Party
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel Distribution Channel
Division Division Division
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID Sales Organization in Service
SalesOfficeOrgUnitID SalesOfficeOrgUnitID Sales Office in Service
SalesGroupOrgUnitID SalesGroupOrgUnitID Sales Group in Service
SoldToPartyFullName SoldToPartyFullName Sold-To Party Name
RefBusinessSolutionOrder RefBusinessSolutionOrder Solution Order
SoldToParty SoldToParty Sold-To Party
ContactPersonBusinessPartnerId ContactPersonBusinessPartnerId Contact Person
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId Responsible Employee
Currency DisplayCurrency Display Currency
DisplayCurrency
TransactionCurrency TransactionCurrency Transaction Currency
CalendarQuarter CalendarQuarter Calendar Quarter
CalendarQuarterName Calendar Quarter Name
CalendarMonth CalendarMonth Calendar Month
CalendarMonthName Calendar Month Name
_CalendarMonth _CalendarMonth
_CalendarQuarter _CalendarQuarter
_SoldToPartyRegion _SoldToPartyRegion
_ServiceObjectType _ServiceObjectType
_ServiceContractTypeVH _ServiceContractTypeVH
_SrvcContrItem _SrvcContrItem
_SrvcContr _SrvcContr
_SemanticTag _SemanticTag
_JournalEntry _JournalEntry
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_DistributionChannel _DistributionChannel
_SoldToPartyCountry _SoldToPartyCountry
_SalesOrganization _SalesOrganization

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_SrvcContrFinQuery_2.
-- 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 C_SrvcContrFinQuery_2 AS
SELECT
  ServiceObjectType,
  ServiceContract,
  ServiceContractItem,
  SemanticTag,
  AccountingDocument,
  LedgerGLLineItem,
  CompanyCode,
  FiscalYear,
  CalendarYear,
  CalendarWeek,
  CreationDate,
  ServiceDocumentItemCanclnParty,
  ServiceDocumentItmCanclnReason,
  ServiceDocumentIsOpen,
  ServiceContractType,
  SoldToPartyCountry,
  SoldToPartyRegion,
  _SoldToPartyRegion._RegionText [1: Language=$session.system_language].RegionName AS RegionName,
  ShipToParty,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  SoldToPartyFullName,
  RefBusinessSolutionOrder,
  SoldToParty,
  ContactPersonBusinessPartnerId,
  RespEmployeeBusinessPartnerId,
  DisplayCurrency AS Currency,
  cast(:P_DisplayCurrency as currency) AS DisplayCurrency,
  TransactionCurrency,
  CalendarQuarter,
  _CalendarQuarter._Text [1: Language=$session.system_language].CalendarQuarterName AS CalendarQuarterName,
  CalendarMonth,
  _CalendarMonth._Text [1: Language=$session.system_language].CalendarMonthName AS CalendarMonthName
FROM I_SrvcContrFinancialCube_2
LEFT OUTER JOIN I_ServiceDocumentItem AS _SrvcContrItem ON ServiceContract = _SrvcContrItem.ServiceDocument AND ServiceContractItem = _SrvcContrItem.ServiceDocumentItem AND _SrvcContrItem.ServiceObjectType = 'BUS2000112'  -- association [1]
LEFT OUTER JOIN I_ServiceDocument AS _SrvcContr ON ServiceContract = _SrvcContr.ServiceDocument AND _SrvcContr.ServiceObjectType = 'BUS2000112'  -- association [1]
;

Learn More