I_SrvcDocByDocumentType

Service Transaction by Transaction Type | view: ISRVCDOCSRCH | ATTR | Extraction: Not supported | Component: S4CRM: Reporting
Tables used: CRMS4D_SERV_H
Column Name Description
ServiceDocumentType FK Business Transaction Type
ServiceDocument Transaction ID
Column Name Description
💲 Currency (TransactionCurrency):
ServiceDocNetAmount Total Net Value of Document in Document Currency
ServiceDocGrossAmount Total Gross Value of Document in Document Currency
ServiceDocTaxAmount Total Tax Amount in Document Currency
Column Name Description
Column Name Description
PostingDate Posting Date for a Business Transaction
ServiceDocumentCreationDate Created On
ServiceDocumentChangedDate Changed On
ServiceContractStartDate Created On
ServiceContractEndDate Created On
RequestedServiceStartDate Created On
RequestedServiceEndDate Changed On
CustomerPurchaseOrderDate Reference Document Date
Column Name Description
ServiceDocumentStatus Life Cycle Status Show values
ServiceDocumentHasError Error Status Show values
ServiceDocBillingStatus Billing Status Show values
ServiceDocIsReleasedForBilling Release Status for Cumulated Billing Show values
ServiceDocumentIsOpen Status "Open" Show values
ServiceDocumentIsReleased Release Status Show values
ServiceDocumentIsRejected Cancellation Status Show values
ServiceConfirmationIsFinal Final service confirmation for the related service order Show values
Column Name Description Domain name
ServiceDocumentUUID GUID of a CRM Order Object SYSUUID
ServiceDocumentDescription Transaction Description CRM_PROCESS_DESCRIPTION
RefBusinessSolutionOrder Reference Solution Order ID CRM_OBJECT_ID
PurchaseOrderByCustomer Sold-To Party's External Reference Number TEXT35
ServiceOrganization Service Organization HROBJEC_14
ResponsibleServiceOrganization Organizational Unit (Service) HROBJEC_14
ServiceDocCreationDateTime Created At TZNTSTMPS
ServiceDocChangedDateTime Changed At TZNTSTMPS
ServiceDocumentCreatedByUser User that Created the Transaction UNAME
ServiceDocumentChangedByUser Transaction Last Changed By UNAME
ServiceContractStartDateTime Contract Start date DEC15
ServiceContractEndDateTime Contract End Date DEC15
RequestedServiceStartDateTime Service Request Start Date TZNTSTMPS
RequestedServiceEndDateTime Service Request Due Date TZNTSTMPS
SalesOrganization Sales Organization VKORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesGroupOrgUnitID Sales Group HROBJEC_14
ServiceDefectSchema Coherent Cat. - Aspect ID CRMS4_ERMS_CAT_AS_ID_DO
ServiceDefectCategory Coherent Cat. - Category ID CRMS4_ERMS_CAT_CA_ID_DO
ServiceFirstResponseByDateTime First Response By TZNTSTMPS
ServiceDueByDateTime Date Transaction is Due TZNTSTMPS
ServiceReasonSchema Coherent Cat. - Aspect ID CRMS4_ERMS_CAT_AS_ID_DO
ServiceReasonCategory Coherent Cat. - Category ID CRMS4_ERMS_CAT_CA_ID_DO
Master Data Relations Join Conditions
Business Partner: Billing Block Reason
  • Business Partner: Billing Block Reason
  • Client
  • I_SRVCDOCBYDOCUMENTTYPE.BILLINGBLOCKREASON == TVFS.FAKSP
  • I_SRVCDOCBYDOCUMENTTYPE.MANDT == TVFS.MANDT
Bill-To Party
  • Bill-To Party
  • Client
  • I_SRVCDOCBYDOCUMENTTYPE.BILLTOPARTY == BUT000.PARTNER
  • I_SRVCDOCBYDOCUMENTTYPE.MANDT == BUT000.CLIENT
Activity Category (Communication Type)
  • Activity Category (Communication Type)
  • Client
Customer Contact Person
  • Customer Contact Person
  • Client
  • I_SRVCDOCBYDOCUMENTTYPE.CONTACTPERSON == BUT000.PARTNER
  • I_SRVCDOCBYDOCUMENTTYPE.MANDT == BUT000.CLIENT
Distribution Channel
  • Distribution Channel
  • Client
  • I_SRVCDOCBYDOCUMENTTYPE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_SRVCDOCBYDOCUMENTTYPE.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • I_SRVCDOCBYDOCUMENTTYPE.MANDT == TSPA.MANDT
  • I_SRVCDOCBYDOCUMENTTYPE.DIVISION == TSPA.SPART
Language Key of Description I_SRVCDOCBYDOCUMENTTYPE.LANGUAGE == T002.SPRAS
Payer
  • Client
  • Payer
  • I_SRVCDOCBYDOCUMENTTYPE.MANDT == BUT000.CLIENT
  • I_SRVCDOCBYDOCUMENTTYPE.PAYERPARTY == BUT000.PARTNER
Terms of Payment
  • ?
  • Terms of Payment
  • Client
  • I_SRVCDOCBYDOCUMENTTYPE.[column in domain "DZTAGG_052"] == T052.ZTAGG
  • I_SRVCDOCBYDOCUMENTTYPE.PAYMENTTERMS == T052.ZTERM
  • I_SRVCDOCBYDOCUMENTTYPE.MANDT == T052.MANDT
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • I_SRVCDOCBYDOCUMENTTYPE.[column in domain "KVEWE"] == T683.KVEWE
  • I_SRVCDOCBYDOCUMENTTYPE.[column in domain "KAPPL"] == T683.KAPPL
  • I_SRVCDOCBYDOCUMENTTYPE.MANDT == T683.MANDT
  • I_SRVCDOCBYDOCUMENTTYPE.PRICINGPROCEDURE == T683.KALSM
Recommended Priority
  • Recommended Priority
  • Client
  • I_SRVCDOCBYDOCUMENTTYPE.RECOMMENDEDSERVICEPRIORITY == SCPRIO.PRIORITY
  • I_SRVCDOCBYDOCUMENTTYPE.MANDT == SCPRIO.CLIENT
Region (State, Province, County)
  • ?
  • Region (State, Province, County)
  • Client
  • I_SRVCDOCBYDOCUMENTTYPE.[column in domain "LAND1"] == T005S.LAND1
  • I_SRVCDOCBYDOCUMENTTYPE.REGION == T005S.BLAND
  • I_SRVCDOCBYDOCUMENTTYPE.MANDT == T005S.MANDT
Employee Responsible
  • Client
  • Employee Responsible
  • I_SRVCDOCBYDOCUMENTTYPE.MANDT == BUT000.CLIENT
  • I_SRVCDOCBYDOCUMENTTYPE.RESPONSIBLEEMPLOYEE == BUT000.PARTNER
Impact
  • Impact
  • Client
Activity Priority
  • Activity Priority
  • Client
  • I_SRVCDOCBYDOCUMENTTYPE.SERVICEDOCUMENTPRIORITY == SCPRIO.PRIORITY
  • I_SRVCDOCBYDOCUMENTTYPE.MANDT == SCPRIO.CLIENT
Problem Category
  • Problem Category
  • Client
Cancellation Reason Code
  • Cancellation Reason Code
  • Client
  • I_SRVCDOCBYDOCUMENTTYPE.SERVICEDOCUMENTREJECTIONREASON == TVAG.ABGRU
  • I_SRVCDOCBYDOCUMENTTYPE.MANDT == TVAG.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
Urgency
  • Client
  • Urgency
Executing Service Employee
  • Executing Service Employee
  • Client
  • I_SRVCDOCBYDOCUMENTTYPE.SERVICEEMPLOYEE == BUT000.PARTNER
  • I_SRVCDOCBYDOCUMENTTYPE.MANDT == BUT000.CLIENT
Business Trans. Cat. I_SRVCDOCBYDOCUMENTTYPE.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Risk
  • Risk
  • Client
Service Team
  • Service Team
  • Client
  • I_SRVCDOCBYDOCUMENTTYPE.SERVICETEAM == BUT000.PARTNER
  • I_SRVCDOCBYDOCUMENTTYPE.MANDT == BUT000.CLIENT
Ship-To Party
  • Ship-To Party
  • Client
  • I_SRVCDOCBYDOCUMENTTYPE.SHIPTOPARTY == BUT000.PARTNER
  • I_SRVCDOCBYDOCUMENTTYPE.MANDT == BUT000.CLIENT
Sold-To Party
  • Sold-To Party
  • Client
  • I_SRVCDOCBYDOCUMENTTYPE.SOLDTOPARTY == BUT000.PARTNER
  • I_SRVCDOCBYDOCUMENTTYPE.MANDT == BUT000.CLIENT
Country/Region
  • Client
  • Country/Region
  • I_SRVCDOCBYDOCUMENTTYPE.MANDT == T005.MANDT
  • I_SRVCDOCBYDOCUMENTTYPE.SOLDTOPARTYCOUNTRY == T005.LAND1
Region (State, Province, County)
  • Region (State, Province, County)
  • Client
  • Country/Region
  • I_SRVCDOCBYDOCUMENTTYPE.SOLDTOPARTYREGION == T005S.BLAND
  • I_SRVCDOCBYDOCUMENTTYPE.MANDT == T005S.MANDT
  • I_SRVCDOCBYDOCUMENTTYPE.SOLDTOPARTYCOUNTRY == T005S.LAND1
Currency
  • Currency
  • Client
  • I_SRVCDOCBYDOCUMENTTYPE.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_SRVCDOCBYDOCUMENTTYPE.MANDT == TCURC.MANDT