I_SrvcDocItemByDocumentType

DDL: I_SRVCDOCITEMBYDOCUMENTTYPE Type: view BASIC Package: CRMS4_REPORT
125 Fields 1 Data Sources 2 Associations

Srvc Transaction Item by Transac Type

I_SrvcDocItemByDocumentType (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Sales

I_SrvcDocItemByDocumentType is a Basic CDS View (Dimension) that provides data about "Srvc Transaction Item by Transac Type" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItem) and exposes 125 fields with key fields ServiceDocumentType, ServiceDocument, ServiceDocumentItem. It has 2 associations to related views. Part of development package CRMS4_REPORT.

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?

Structure
Object types This view relates to the following SAP object types: ServiceContract ServiceOrder ServiceConfirmation

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessSales
Application ComponentCRM-S4-REP-RFW
CapabilitiesAnalytical Dimension,Association Target for Defining CDS Entities,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)Yes
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSales for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li> <p>How much revenue do service transactions generate?</p> </li> <li> <p>What is the cost contribution of service transactions to my total costs?</p> </li> <li> <p>What is the contribution of service transactions to my profit margin?</p> </li> <li> <p>How much revenue does a certain sales organization contribute to my service business?</p> </li> <li><p>Which service orders and service contracts are related to a specific solution order?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItem I_ServiceDocumentItem from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_SrvcDocByDocumentType _ServiceDocument $projection.ServiceDocumentType = _ServiceDocument.ServiceDocumentType and $projection.ServiceDocument = _ServiceDocument.ServiceDocument
[0..1] E_ServiceDocumentItem _ServiceDocItemExt $projection.ServiceObjectType = _ServiceDocItemExt.ServiceCategory and $projection.ServiceDocument = _ServiceDocItemExt.ServiceOrderItem and $projection.ServiceDocumentItem = _ServiceDocItemExt.ServiceLineExternalID

Annotations (16)

NameValueLevelField
EndUserText.label Srvc Transaction Item by Transac Type view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISRVCDOCITMSRCH 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 ServiceDocumentItem view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Analytics.dataCategory #DIMENSION view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (125)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentType ServiceDocumentType Business Transaction Type
KEY ServiceDocument ServiceDocument Transaction ID
KEY ServiceDocumentItem ServiceDocumentItem Shortened Item Number in Document
ServiceObjectType ServiceObjectType Business Trans. Cat.
ServiceDocumentUUID ServiceDocumentUUID GUID of a CRM Order Object
ServiceDocumentDescription ServiceDocumentDescription Transaction Description
ServiceDocumentItemUUID ServiceDocumentItemUUID GUID of a CRM Order Object
ServiceDocumentItemObjectType ServiceDocumentItemObjectType CRM Item Object Type
ParentServiceDocumentItemUUID ParentServiceDocumentItemUUID GUID of a CRM Order Object
ServiceDocumentItemDescription ServiceDocumentItemDescription Product Description
RefBusinessSolutionOrder RefBusinessSolutionOrder Reference Solution Order ID
RefBusinessSolutionOrderItem RefBusinessSolutionOrderItem Item Number in Referenced Solution Order
BillingDateTime BillingDateTime Billing Date for Billing Index and Printout
BillingDocCreationDateTime BillingDocCreationDateTime Billing Document Creation Date
PurchaseOrderByCustomer PurchaseOrderByCustomer Sold-To Party's External Reference Number
ServiceDocumentItemPriority ServiceDocumentItemPriority Workflow priority
PostingDate PostingDate Posting Date for a Business Transaction
TransactionCurrency TransactionCurrency Transaction Currency
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID Sales Organization ID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID Sales Office
SalesGroupOrgUnitID SalesGroupOrgUnitID Sales Group
SoldToPartyCountry SoldToPartyCountry Country/Region
SoldToPartyRegion SoldToPartyRegion Region (State, Province, County)
SoldToParty SoldToParty Sold-to Party
ServiceTeam ServiceTeam Service Team
ResponsibleEmployee ResponsibleEmployee Employee Responsible
ServiceEmployee ServiceEmployee Executing Service Employee
ContactPerson ContactPerson Customer Contact Person
PayerParty PayerParty Payer
BillToParty BillToParty Inv. Recipient
PaymentTerms PaymentTerms Terms of Payment
ServiceDocumentItemStatus ServiceDocumentItemStatus Unique Custom Status
ServiceDocumentItemHasError ServiceDocumentItemHasError Error Status
SrvcDocItmIsReleasedForBilling SrvcDocItmIsReleasedForBilling Billing Release Status
ServiceDocItemBillingStatus ServiceDocItemBillingStatus Billing Status
ServiceDocumentItemIsOpen ServiceDocumentItemIsOpen Status "Open"
ServiceOrganization ServiceOrganization Service Organization
ResponsibleServiceOrganization ResponsibleServiceOrganization Organizational Unit (Service)
ServiceDocItemCreationDateTime ServiceDocItemCreationDateTime Created On
ServiceDocItemChangedDateTime ServiceDocItemChangedDateTime Changed On
ServiceDocItemCreatedByUser ServiceDocItemCreatedByUser User that Created the Transaction
ServiceDocItemChangedByUser ServiceDocItemChangedByUser Transaction Last Changed By
OriginallyRequestedProduct OriginallyRequestedProduct Product Name Entered
ServiceDocumentItemQuantity ServiceDocumentItemQuantity CRM: Order Quantity
ServiceDocItemQuantityUnit ServiceDocItemQuantityUnit Unit of Measure in Which the Product Is Sold
SrvcDocItemBaseQuantityUnit SrvcDocItemBaseQuantityUnit Base Unit of Measure of Product
ServiceDocItemCategory ServiceDocItemCategory Item Category
ServiceDocumentItemNetAmount ServiceDocumentItemNetAmount Net Value
BillableControl BillableControl Accounting Indicator
BillingBlockReason BillingBlockReason Business Partner: Billing Block Reason
RequestedServiceStartDateTime RequestedServiceStartDateTime Service Request Start Date
RequestedServiceEndDateTime RequestedServiceEndDateTime Service Request Due Date
ServiceContrItemStartDateTime ServiceContrItemStartDateTime Contract Start Date
ServiceContrItemEndDateTime ServiceContrItemEndDateTime Contract End Date
ServiceDocItemGrossAmount ServiceDocItemGrossAmount Gross Order Value in PO Currency
SettlementPeriodRuleUUID SettlementPeriodRuleUUID Rule for Determining the Period Date
BillingPlanBillingDateRuleUUID BillingPlanBillingDateRuleUUID Rule for Determining the Next Billing Date
SalesOrganization SalesOrganization Sales Organization
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
DistributionChannel DistributionChannel Distribution Channel
Division Division Internal Division ID
ServiceDuration ServiceDuration Work Duration
ServiceDocItemRejectionReason ServiceDocItemRejectionReason Cancellation Reason Code
ShipToParty ShipToParty Ship-To Party (obsolete)
ServiceDocumentItemIsReleased ServiceDocumentItemIsReleased Release Status
ServiceDocumentItemIsRejected ServiceDocumentItemIsRejected Cancellation Status
ResponseProfile ResponseProfile Response Profile
ServiceProfile ServiceProfile Service Profile
Language Language Short Text Language for an Item
ActualServiceDuration ActualServiceDuration Confirmed Duration
ActualServiceDurationUnit ActualServiceDurationUnit Time Unit for Confirmed Duration
ServiceDurationUnit ServiceDurationUnit Unit for Duration of Work
TimeSheetOvertimeCategory TimeSheetOvertimeCategory Overtime Category
Industry Industry Industry Sector
SrvcContrItemRnwlDuration SrvcContrItemRnwlDuration Unit for Auto Renewal Period
SrvcContrItemRnwlDurationUnit SrvcContrItemRnwlDurationUnit UOM for Auto Renewal Period
SrvcContrItemExtensionDuration SrvcContrItemExtensionDuration Unit for Contract Extension
SrvcContrItemExtnDurationUnit SrvcContrItemExtnDurationUnit UOM for Contract Extension
_BillingBlockReason _BillingBlockReason
_BillingRequestItem _BillingRequestItem
_BillToParty _BillToParty
_ContactPerson _ContactPerson
_PayerParty _PayerParty
_RespEmployee _RespEmployee
_ServiceDocItemBillingStatus _ServiceDocItemBillingStatus
_ServiceDocItemCategory _ServiceDocItemCategory
_ServiceDocItemHasError _ServiceDocItemHasError
_ServiceDocItemPriority _ServiceDocItemPriority
_ServiceDocItemStatus _ServiceDocItemStatus
_SrvcDocItmLifecycleStatus _SrvcDocItmLifecycleStatus
_ServiceDocumentType _ServiceDocumentType
_ServiceEmployee _ServiceEmployee
_ServiceDocument _ServiceDocument
_ServiceObjType _ServiceObjType
_BaseUnit _BaseUnit
_BaseUnit_2 _BaseUnit_2
_SalesUnit _SalesUnit
_TransactionCurrency _TransactionCurrency
_PaymentTerms _PaymentTerms
_ServiceProductList _ServiceProductList
_ServiceTeam _ServiceTeam
_SoldToParty _SoldToParty
_SrvcDocItemIsRelForBillgSts _SrvcDocItemIsRelForBillgSts
_ServiceDocumentIsOpen _ServiceDocumentIsOpen
_FixedPrice _FixedPrice
_StatusObjItemStatus _StatusObjItemStatus
_SalesOrganization _SalesOrganization
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_ActualServiceDurationUnit _ActualServiceDurationUnit
_ServiceDurationUnit _ServiceDurationUnit
_SrvcContrItemRnwlDurationUnit _SrvcContrItemRnwlDurationUnit
_SrvcContrItemExtnDurationUnit _SrvcContrItemExtnDurationUnit
_ServiceDocOvertimeCat _ServiceDocOvertimeCat
_Industry _Industry
_ServiceDocItemRejectionReason _ServiceDocItemRejectionReason
_SoldToPartyCountry _SoldToPartyCountry
_SoldToPartyRegion _SoldToPartyRegion
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit
_SalesOfficeOrgUnit _SalesOfficeOrgUnit
_SalesGroupOrgUnit _SalesGroupOrgUnit
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_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 I_SrvcDocItemByDocumentType.
-- 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_SrvcDocItemByDocumentType AS
SELECT
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceObjectType,
  ServiceDocumentUUID,
  ServiceDocumentDescription,
  ServiceDocumentItemUUID,
  ServiceDocumentItemObjectType,
  ParentServiceDocumentItemUUID,
  ServiceDocumentItemDescription,
  RefBusinessSolutionOrder,
  RefBusinessSolutionOrderItem,
  BillingDateTime,
  BillingDocCreationDateTime,
  PurchaseOrderByCustomer,
  ServiceDocumentItemPriority,
  PostingDate,
  TransactionCurrency,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  SoldToPartyCountry,
  SoldToPartyRegion,
  SoldToParty,
  ServiceTeam,
  ResponsibleEmployee,
  ServiceEmployee,
  ContactPerson,
  PayerParty,
  BillToParty,
  PaymentTerms,
  ServiceDocumentItemStatus,
  ServiceDocumentItemHasError,
  SrvcDocItmIsReleasedForBilling,
  ServiceDocItemBillingStatus,
  ServiceDocumentItemIsOpen,
  ServiceOrganization,
  ResponsibleServiceOrganization,
  ServiceDocItemCreationDateTime,
  ServiceDocItemChangedDateTime,
  ServiceDocItemCreatedByUser,
  ServiceDocItemChangedByUser,
  OriginallyRequestedProduct,
  ServiceDocumentItemQuantity,
  ServiceDocItemQuantityUnit,
  SrvcDocItemBaseQuantityUnit,
  ServiceDocItemCategory,
  ServiceDocumentItemNetAmount,
  BillableControl,
  BillingBlockReason,
  RequestedServiceStartDateTime,
  RequestedServiceEndDateTime,
  ServiceContrItemStartDateTime,
  ServiceContrItemEndDateTime,
  ServiceDocItemGrossAmount,
  SettlementPeriodRuleUUID,
  BillingPlanBillingDateRuleUUID,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  DistributionChannel,
  Division,
  ServiceDuration,
  ServiceDocItemRejectionReason,
  ShipToParty,
  ServiceDocumentItemIsReleased,
  ServiceDocumentItemIsRejected,
  ResponseProfile,
  ServiceProfile,
  Language,
  ActualServiceDuration,
  ActualServiceDurationUnit,
  ServiceDurationUnit,
  TimeSheetOvertimeCategory,
  Industry,
  SrvcContrItemRnwlDuration,
  SrvcContrItemRnwlDurationUnit,
  SrvcContrItemExtensionDuration,
  SrvcContrItemExtnDurationUnit
FROM I_ServiceDocumentItem
LEFT OUTER JOIN I_SrvcDocByDocumentType AS _ServiceDocument ON ServiceDocumentType = _ServiceDocument.ServiceDocumentType AND ServiceDocument = _ServiceDocument.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocumentItem AS _ServiceDocItemExt ON ServiceObjectType = _ServiceDocItemExt.ServiceCategory AND ServiceDocument = _ServiceDocItemExt.ServiceOrderItem AND ServiceDocumentItem = _ServiceDocItemExt.ServiceLineExternalID  -- association [0..1]
;

Learn More