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

C_ServiceOrderCard

DDL: C_SERVICEORDERCARD SQL: CSRVCORDCARD Type: view CONSUMPTION

Card for Service Order

C_ServiceOrderCard is a Consumption CDS View that provides data about "Card for Service Order" 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 CSRVCORDCARD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Card for Service Order 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
NumberOfErroneousServiceOrders 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
_SalesGroupOrgUnit _SalesGroupOrgUnit
ServiceOrganization ServiceOrganization
ResponsibleEmployee ResponsibleEmployee Employee Resp.
_ServiceDocHasError _ServiceDocHasError
_ServiceOrganizationOrgUnit _ServiceOrganizationOrgUnit
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2
_ServiceOrganizationOrgUnit_2 _ServiceOrganizationOrgUnit_2
_RespEmployee _RespEmployee

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_ServiceOrderCard.
-- 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: CSRVCORDCARD

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