C_SrvcContrItmSettlmtPerdQ

DDL: C_SRVCCONTRITMSETTLMTPERDQ SQL: CSRVCCONTRSETL Type: view CONSUMPTION
35 Fields 1 Data Sources

Service Contracts - Flexible Analysis

C_SrvcContrItmSettlmtPerdQ is a Consumption CDS View that provides data about "Service Contracts - Flexible Analysis" in SAP S/4HANA. It reads from 1 data source (I_SrvcContrItmSettlmtPerdCube) and exposes 35 fields with key fields ServiceContract, ServiceContractItem, BillingRequestItem.

Data Sources (1)

SourceAliasJoin Type
I_SrvcContrItmSettlmtPerdCube I_SrvcContrItmSettlmtPerdCube from

Parameters (3)

NameTypeDefault
P_DisplayCurrency vdm_v_display_currency
P_ContractStartDate dats
P_ContractEndDate dats

Annotations (13)

NameValueLevelField
EndUserText.label Service Contracts - Flexible Analysis view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CSRVCCONTRSETL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.modelingPattern #ANALYTICAL_QUERY view
Analytics.query true view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY ServiceContract ServiceContract Transaction ID
KEY ServiceContractItem ServiceContractItem Item Number in Doc.
KEY BillingRequestItem BillingRequestItem
ServiceDocumentItemDescription ServiceDocumentItemDescription
DisplayCurrency
SrvcContrItmHasInvoiceDue SrvcContrItmHasInvoiceDue
ServiceContractItemProduct ServiceContractItemProduct
ServiceContractItemIsCanceled ServiceContractItemIsCanceled
ServiceContrItemBillingStatus ServiceContrItemBillingStatus
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId
RefBusinessSolutionOrder RefBusinessSolutionOrder
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
ServiceContractItemStatus ServiceContractItemStatus
SoldToParty SoldToParty Sold-to Party
SalesOrganization SalesOrganization Sales Organization
NrOfBillgReqItmsWithInvoiceDue NrOfBillgReqItmsWithInvoiceDue
BillingDocumentRequest BillingDocumentRequest
BillingDocumentRequestItem BillingDocumentRequestItem
BillgDocReqBillgSts BillgDocReqBillgSts
BillingDocument BillingDocument SD Document
BillingDocumentItem BillingDocumentItem Item
OverallBillingStatus OverallBillingStatus
BillingDocumentDate BillingDocumentDate Billing Date
SettlementStartDate SettlementStartDate
SettlementEndDate SettlementEndDate
SrvcContrItemBillgBlockReason SrvcContrItemBillgBlockReason
SrvcContrItemHasBillingBlock SrvcContrItemHasBillingBlock
BillgReqItemBillingStatus BillgReqItemBillingStatus
ProfitCenter ProfitCenter Profit Center
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
ControllingArea ControllingArea Controlling Area
ServiceContractType ServiceContractType

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_SrvcContrItmSettlmtPerdQ.
-- 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: CSRVCCONTRSETL
-- Parameters: P_DisplayCurrency : vdm_v_display_currency, P_ContractStartDate : dats, P_ContractEndDate : dats

CREATE VIEW C_SrvcContrItmSettlmtPerdQ AS
SELECT
  ServiceContract,
  ServiceContractItem,
  BillingRequestItem,
  ServiceDocumentItemDescription,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  SrvcContrItmHasInvoiceDue,
  ServiceContractItemProduct,
  ServiceContractItemIsCanceled,
  ServiceContrItemBillingStatus,
  RespEmployeeBusinessPartnerId,
  RefBusinessSolutionOrder,
  SalesOffice,
  SalesGroup,
  DistributionChannel,
  Division,
  ServiceContractItemStatus,
  SoldToParty,
  SalesOrganization,
  NrOfBillgReqItmsWithInvoiceDue,
  BillingDocumentRequest,
  BillingDocumentRequestItem,
  BillgDocReqBillgSts,
  BillingDocument,
  BillingDocumentItem,
  OverallBillingStatus,
  BillingDocumentDate,
  SettlementStartDate,
  SettlementEndDate,
  SrvcContrItemBillgBlockReason,
  SrvcContrItemHasBillingBlock,
  BillgReqItemBillingStatus,
  ProfitCenter,
  PurchaseOrderByCustomer,
  ControllingArea,
  ServiceContractType
FROM I_SrvcContrItmSettlmtPerdCube
;

Learn More