Deprecated
This CDS view is deprecated in S/4HANA. Use C_ServiceOrderAnalyticsQry instead. View all deprecated CDS views →

C_ServiceConfirmationCard

DDL: C_SERVICECONFIRMATIONCARD SQL: CSRVCCONFCARD Type: view CONSUMPTION

Service confirmation Card

C_ServiceConfirmationCard is a Consumption CDS View that provides data about "Service confirmation Card" in SAP S/4HANA. It reads from 1 data source (I_NumberOfServiceDocuments) and exposes 30 fields with key fields ServiceObjectType, ServiceDocument, ServiceDocumentHasError.

Data Sources (1)

SourceAliasJoin Type
I_NumberOfServiceDocuments I_NumberOfServiceDocuments from

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CSRVCCONFCARD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Service confirmation Card view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey ServiceDocumentHasError view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
UI.headerInfo.typeName Service Order Overview view
UI.headerInfo.typeNamePlural Service Orders Overview view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value Service Order Overview view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value Service Order Overview view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor C_ServiceOrderAnalyticsQry view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Object Type
KEY ServiceDocument ServiceDocument Transaction ID
KEY ServiceDocumentHasError ServiceDocument ServiceDocumentHasError Has Errors
NmbrOfErroneousSrvcConf ServiceDocument NumberOfErroneousServiceDocs Count
ServiceDocumentType ServiceDocumentType Transaction Type
SalesOrganization SalesOrganization Sales Organization
_SalesOrganization _SalesOrganization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
_DistributionChannel _DistributionChannel
Division Division Internal Division ID
_Division _Division
SalesOffice SalesOffice Sales Office
_SalesOffice _SalesOffice
SalesGroup SalesGroup Sales Group
_SalesGroup _SalesGroup
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
_SalesOfficeOrgUnit _SalesOfficeOrgUnit
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
ResponsibleEmployee ResponsibleEmployee Employee Resp.
_SalesGroupOrgUnit _SalesGroupOrgUnit
_ServiceDocHasError _ServiceDocHasError
_ServiceOrganizationOrgUnit _ServiceOrganizationOrgUnit
_RespEmployee _RespEmployee
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2
_ServiceOrganizationOrgUnit_2 _ServiceOrganizationOrgUnit_2

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_ServiceConfirmationCard.
-- 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: CSRVCCONFCARD

CREATE VIEW C_ServiceConfirmationCard AS
SELECT
  ServiceObjectType,
  ServiceDocument,
  ServiceDocument.ServiceDocumentHasError AS ServiceDocumentHasError,
  ServiceDocument.NumberOfErroneousServiceDocs AS NmbrOfErroneousSrvcConf,
  ServiceDocumentType,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  ResponsibleEmployee
FROM I_NumberOfServiceDocuments
;