I_SrvcDocByDocumentType

DDL: I_SRVCDOCBYDOCUMENTTYPE Type: view BASIC
103 Fields 1 Data Sources 1 Associations

Service Transaction by Transaction Type

I_SrvcDocByDocumentType is a Basic CDS View (Dimension) that provides data about "Service Transaction by Transaction Type" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocument) and exposes 103 fields with key fields ServiceDocumentType, ServiceDocument. It has 1 association to related views.

SAP Help Documentation

CategoryCommon CDS Views for Service
Data CategoryDimension
StatusReleased
Purpose
This CDS view provides the prerequisites for answering the following business questions: How much revenue do service transactions generate? What is the cost contribution of service transactions to my total costs? What is the contribution of service transactions to my profit margin? How much revenue does a certain sales organization contribute to my service business? Which service orders and service contracts are related to a specific solution order? Note The answers to these business questions are derived through a combination of this CDS view and CDS views from Finance .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: Authorization Object Description CRM_ORD_OP Authorization Object CRM Order – Own Documents CRM_SEO Authorization Object CRM Order – Business Object Service Order CRM_CON_SE Authorization Object CRM Order – Bus.Ob.Service Confirmation CRM_CO_SE Authorization Object CRM Order – Bus. Ob. Service Contract CRM_INCDNT Authorization Object CRM Order: Incident Management CRMS4_SOLO Authorization Object for Solution Order CRM_ORD_PR Authorization Object CRM Order – Business Transaction Type CRMS4_SLSO Sales Organizational Units of Service Transactions CRM_ORD_OE Authorization Object CRM Order – Allowed Organ. Units

Structure
Object Types This view relates to the following SAP object types: ServiceContract ServiceOrder ServiceConfirmation Attributes Some important attributes are: Attribute Element Type Description ServiceDocumentType Key Transaction type ServiceDocument Key Transaction ID ServiceObjectType Field Transaction category PricingDocument Field Document condition number SoldToParty Field Sold-to party ServiceTeam Field Service team TransactionCurrency Field Currency ServiceOrganization Field Service organization RefBusinessSolutionOrder Field Reference to a solution order ID

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocument I_ServiceDocument from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_ServiceDocument _ServiceDocumentExt $projection.ServiceObjectType = _ServiceDocumentExt.ServiceCategory and $projection.ServiceDocument = _ServiceDocumentExt.ServiceOrder

Annotations (16)

NameValueLevelField
EndUserText.label Service Transaction by Transaction Type view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISRVCDOCSRCH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey ServiceDocument view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
Analytics.dataCategory #DIMENSION view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (103)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentType ServiceDocumentType Transaction Type
KEY ServiceDocument ServiceDocument Transaction ID
ServiceObjectType ServiceObjectType Object Type
ServiceDocumentUUID ServiceDocumentUUID Object GUID
ServiceDocumentDescription ServiceDocumentDescription Description
PricingDocument PricingDocument Document Condition
PricingProcedure PricingProcedure Procedure
RefBusinessSolutionOrder RefBusinessSolutionOrder Ref. Soltn Order ID
SoldToParty SoldToParty Sold-to Party
ServiceTeam ServiceTeam Service Team
ResponsibleEmployee ResponsibleEmployee Employee Resp.
ServiceEmployee ServiceEmployee Exec.Service Emp.
ContactPerson ContactPerson Contact Person Key
ServiceDocumentPriority ServiceDocumentPriority Workflow priority
PostingDate PostingDate Posting Date for GR
PaymentTerms PaymentTerms Pyt Terms
TransactionCurrency TransactionCurrency Transaction Currency
ServiceDocNetAmount ServiceDocNetAmount Net Value
ServiceDocGrossAmount ServiceDocGrossAmount Gross Value
SoldToPartyCountry SoldToPartyCountry Country/Region
SoldToPartyRegion SoldToPartyRegion Region
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
ServiceDocumentStatus ServiceDocumentStatus Unique Custom Status
ServiceDocumentHasError ServiceDocumentHasError Error Status
ServiceDocBillingStatus ServiceDocBillingStatus Billing Status
ServiceDocIsReleasedForBilling ServiceDocIsReleasedForBilling Rlsd f Bllg
ServiceDocumentIsOpen ServiceDocumentIsOpen Open
ServiceOrganization ServiceOrganization Service Organization
ResponsibleServiceOrganization ResponsibleServiceOrganization Resp. Org. Unit
ServiceDocCreationDateTime ServiceDocCreationDateTime Created On
ServiceDocChangedDateTime ServiceDocChangedDateTime Changed On
ServiceDocumentCreatedByUser ServiceDocumentCreatedByUser Created By
ServiceDocumentChangedByUser ServiceDocumentChangedByUser Changed By
ServiceContractStartDateTime ServiceContractStartDateTime Contract Start Date
ServiceContractEndDateTime ServiceContractEndDateTime Contract End Date
RequestedServiceStartDateTime RequestedServiceStartDateTime Start Date/Time
RequestedServiceEndDateTime RequestedServiceEndDateTime Service Request Due
BillingBlockReason BillingBlockReason Blocking Reason
BusinessActivityCategory BusinessActivityCategory Violation Category
SalesOrganization SalesOrganization Sales Organization
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID Sales Organization
SalesOfficeOrgUnitID SalesOfficeOrgUnitID Sales Office
SalesGroupOrgUnitID SalesGroupOrgUnitID Sales Group
Language Language Report Text Language
ServiceDocumentRejectionReason ServiceDocumentRejectionReason Rejection Reason
CustomerPurchaseOrderDate CustomerPurchaseOrderDate Purchase Order Date
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
ServiceDocumentIsReleased ServiceDocumentIsReleased Release Status
ServiceDocumentIsRejected ServiceDocumentIsRejected Cancellation Status
ShipToParty ShipToParty Ship-To Party (obsolete)
BillToParty BillToParty Inv. Recipient
PayerParty PayerParty Payer
ServiceDocTaxAmount ServiceDocTaxAmount Tax Amount
ServiceDefectSchema ServiceDefectSchema Schema ID
ServiceDefectCategory ServiceDefectCategory Category ID
ServiceFirstResponseByDateTime ServiceFirstResponseByDateTime First Response By
ServiceDueByDateTime ServiceDueByDateTime Due Date
RecommendedServicePriority RecommendedServicePriority Recommended Priority
ServiceDocumentUrgency ServiceDocumentUrgency Urgency
ServiceDocumentImpact ServiceDocumentImpact Impact
ServiceDocumentProblemCategory ServiceDocumentProblemCategory Problem Category
ServiceReasonSchema ServiceReasonSchema Schema ID
ServiceReasonCategory ServiceReasonCategory Schema ID
ServiceConfirmationIsFinal ServiceConfirmationIsFinal Final Confirmation
Region Region Venue Region
ServiceRisk ServiceRisk Risk
_ActivityCategory _ActivityCategory
_BillingBlockReason _BillingBlockReason
_ContactPerson _ContactPerson
_RespEmployee _RespEmployee
_ServiceDocBillingStatus _ServiceDocBillingStatus
_ServiceDocHasError _ServiceDocHasError
_ServiceDocumentPriority _ServiceDocumentPriority
_ServiceDocumentStatus _ServiceDocumentStatus
_SrvcDocLifecycleStatus _SrvcDocLifecycleStatus
_ServiceDocumentType _ServiceDocumentType
_ServiceEmployee _ServiceEmployee
_ServiceObjType _ServiceObjType
_ServiceTeam _ServiceTeam
_SoldToParty _SoldToParty
_SrvcDocIsRelForBillgSts _SrvcDocIsRelForBillgSts
_TransactionCurrency _TransactionCurrency
_ServiceDocumentIsOpen _ServiceDocumentIsOpen
_PaymentTerms _PaymentTerms
_FixedPrice _FixedPrice
_SalesOrganization _SalesOrganization
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit _SalesOfficeOrgUnit
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit _SalesGroupOrgUnit
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2
_SoldToPartyCountry _SoldToPartyCountry
_SoldToPartyRegion _SoldToPartyRegion
_Region _Region
_ServiceRisk _ServiceRisk
_SrvcDocumentRejectionReason _SrvcDocumentRejectionReason
_ServiceDocProblemCategory _ServiceDocProblemCategory

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 I_SrvcDocByDocumentType.
-- 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 I_SrvcDocByDocumentType AS
SELECT
  ServiceDocumentType,
  ServiceDocument,
  ServiceObjectType,
  ServiceDocumentUUID,
  ServiceDocumentDescription,
  PricingDocument,
  PricingProcedure,
  RefBusinessSolutionOrder,
  SoldToParty,
  ServiceTeam,
  ResponsibleEmployee,
  ServiceEmployee,
  ContactPerson,
  ServiceDocumentPriority,
  PostingDate,
  PaymentTerms,
  TransactionCurrency,
  ServiceDocNetAmount,
  ServiceDocGrossAmount,
  SoldToPartyCountry,
  SoldToPartyRegion,
  PurchaseOrderByCustomer,
  ServiceDocumentStatus,
  ServiceDocumentHasError,
  ServiceDocBillingStatus,
  ServiceDocIsReleasedForBilling,
  ServiceDocumentIsOpen,
  ServiceOrganization,
  ResponsibleServiceOrganization,
  ServiceDocCreationDateTime,
  ServiceDocChangedDateTime,
  ServiceDocumentCreatedByUser,
  ServiceDocumentChangedByUser,
  ServiceContractStartDateTime,
  ServiceContractEndDateTime,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  BillingBlockReason,
  BusinessActivityCategory,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  Language,
  ServiceDocumentRejectionReason,
  CustomerPurchaseOrderDate,
  DistributionChannel,
  Division,
  ServiceDocumentIsReleased,
  ServiceDocumentIsRejected,
  ShipToParty,
  BillToParty,
  PayerParty,
  ServiceDocTaxAmount,
  ServiceDefectSchema,
  ServiceDefectCategory,
  ServiceFirstResponseByDateTime,
  ServiceDueByDateTime,
  RecommendedServicePriority,
  ServiceDocumentUrgency,
  ServiceDocumentImpact,
  ServiceDocumentProblemCategory,
  ServiceReasonSchema,
  ServiceReasonCategory,
  ServiceConfirmationIsFinal,
  Region,
  ServiceRisk
FROM I_ServiceDocument
LEFT OUTER JOIN E_ServiceDocument AS _ServiceDocumentExt ON ServiceObjectType = _ServiceDocumentExt.ServiceCategory AND ServiceDocument = _ServiceDocumentExt.ServiceOrder  -- association [0..1]
;

Learn More