I_ServiceDocument

Service Transaction | view: ISERVDOC | ATTR | Extraction: Not supported | Component: S4CRM: Reporting

🔑 Keys (2)
💰 Amounts (3)
∑ Quantities
📅 Dates (2)
☰ Categorical (20)
Other (36)
🔗 Relations (31)

Column Name	Description
ServiceObjectType FK	Business Trans. Cat.
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
CustomerPurchaseOrderDate	Reference Document Date

Column Name	Description
ServiceDocumentTemplateType	Template Type of CRM Transaction	Show values
SrvcDocIsMaintServiceOrder	Logical Variable	Show values
ServiceDocumentStatus	Life Cycle Status	Show values
ServiceDocumentIsReleased	Release Status	Show values
ServiceDocumentHasError	Error Status	Show values
ServiceDocBillingStatus	Billing Status	Show values
ServiceDocIsReleasedForBilling	Release Status for Cumulated Billing	Show values
ServiceDocumentIsRejected	Cancellation Status	Show values
ServiceDocumentIsOpen	Status "Open"	Show values
SrvcDocTransferStatus	Transfer Status	Show values
ServiceDocumentIsQuotation	Quotation Status	Show values
ServiceConfirmationIsFinal	Final service confirmation for the related service order	Show values
ServiceContractCanclnSts	Contract Cancellation Status	Show values
MaintSrvcOrdExecutionStatus	Maintenance Status	Show values
SrvcDocDeliveryStatus	Delivery Status	Show values
SrvcDocGoodsIssueStatus	Goods Issue Status	Show values
SrvcDocRejectionStatus	Rejection Status	Show values
ServiceEscalationLevel	Escalation	Show values
RefInHouseRepairIsExisting	Reference to In-House Repair Exists	Show values
SrvcDocCreditStatus	Credit Status of Header	Show values

Column Name	Description	Domain name
ServiceDocumentUUID	GUID of a CRM Order Object	SYSUUID
ServiceDocumentCharUUID	32 Character CRM Object GUID (Converted)
ServiceDocumentDescription	Transaction Description	CRM_PROCESS_DESCRIPTION
ServiceDocCreationDateTime	Created At	TZNTSTMPS
ServiceDocChangedDateTime	Changed At	TZNTSTMPS
ServiceDocumentCreatedByUser	User that Created the Transaction	UNAME
ServiceDocumentChangedByUser	Transaction Last Changed By	UNAME
RefBusinessSolutionOrder	Reference Solution Order ID	CRM_OBJECT_ID
SrvcDocTmplValdtyStartDateTime	Template Start Date	TZNTSTMPS
SrvcDocTmplValdtyEndDateTime	Template End Date	TZNTSTMPS
RequestedServiceStartDateTime	Service Request Start Date	TZNTSTMPS
RequestedServiceEndDateTime	Service Request Due Date	TZNTSTMPS
ServiceContractStartDateTime	Contract Start date	DEC15
ServiceContractEndDateTime	Contract End Date	DEC15
SrvcQtanValidityStartDateTime	Contract Start date	DEC15
SrvcQtanValidityEndDateTime	Contract End Date	DEC15
PurchaseOrderByCustomer	Sold-To Party's External Reference Number	TEXT35
SalesOrganizationOrgUnitID	Sales Organization ID	HROBJEC_14
SalesOfficeOrgUnitID	Sales Office	HROBJEC_14
SalesGroupOrgUnitID	Sales Group	HROBJEC_14
ServiceOrganization	Service Organization	HROBJEC_14
ResponsibleServiceOrganization	Organizational Unit (Service)	HROBJEC_14
SalesOrganization	Sales Organization	VKORG
SalesOffice	Sales office	VKBUR
SalesGroup	Sales group	VKGRP
RespyMgmtServiceTeam	Service Team (Responsibility Management)	HROBJID
EnterpriseServiceOrganization	Enterprise Service Organization	CRMS4_ENTERPRISE_SERVICE_ORG
ServiceReasonSchema	Coherent Cat. - Aspect ID	CRMS4_ERMS_CAT_AS_ID_DO
ServiceReasonCategory	Coherent Cat. - Category ID	CRMS4_ERMS_CAT_CA_ID_DO
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
ReferenceInHouseRepair	Reference In-House Repair	CRM_OBJECT_ID
ReferenceInHouseRepairItem	Reference In-House Repair Item	CRMS4_NUMBER_INT
SrvcDocTemplateSearchTermText	Template Search Term	CRM_TSRV_SERVICE_ID

Master Data Relations	Join Conditions
Business Partner: Billing Block Reason Client Business Partner: Billing Block Reason	`I_SERVICEDOCUMENT.MANDT == TVFS.MANDT` `I_SERVICEDOCUMENT.BILLINGBLOCKREASON == TVFS.FAKSP`
Bill-To Party Client Bill-To Party	`I_SERVICEDOCUMENT.MANDT == BUT000.CLIENT` `I_SERVICEDOCUMENT.BILLTOPARTY == BUT000.PARTNER`
Activity Category (Communication Type) Client Activity Category (Communication Type)	`I_SERVICEDOCUMENT.MANDT == CRMC_ACT_CATEGOR.CLIENT` `I_SERVICEDOCUMENT.BUSINESSACTIVITYCATEGORY == CRMC_ACT_CATEGOR.CATEGORY`
Customer Contact Person Client Customer Contact Person	`I_SERVICEDOCUMENT.MANDT == BUT000.CLIENT` `I_SERVICEDOCUMENT.CONTACTPERSON == BUT000.PARTNER`
Distribution Channel Client Distribution Channel	`I_SERVICEDOCUMENT.MANDT == TVTW.MANDT` `I_SERVICEDOCUMENT.DISTRIBUTIONCHANNEL == TVTW.VTWEG`
Division Client Division	`I_SERVICEDOCUMENT.MANDT == TSPA.MANDT` `I_SERVICEDOCUMENT.DIVISION == TSPA.SPART`
Language Key of Description	`I_SERVICEDOCUMENT.LANGUAGE == T002.SPRAS`
Payer Client Payer	`I_SERVICEDOCUMENT.MANDT == BUT000.CLIENT` `I_SERVICEDOCUMENT.PAYERPARTY == BUT000.PARTNER`
Terms of Payment ? Client Terms of Payment	`I_SERVICEDOCUMENT.[column in domain "DZTAGG_052"] == T052.ZTAGG` `I_SERVICEDOCUMENT.MANDT == T052.MANDT` `I_SERVICEDOCUMENT.PAYMENTTERMS == T052.ZTERM`
Procedure (Pricing, Output Control, Acct. Det., Costing,...) ? ? Client Procedure (Pricing, Output Control, Acct. Det., Costing,...)	`I_SERVICEDOCUMENT.[column in domain "KVEWE"] == T683.KVEWE` `I_SERVICEDOCUMENT.[column in domain "KAPPL"] == T683.KAPPL` `I_SERVICEDOCUMENT.MANDT == T683.MANDT` `I_SERVICEDOCUMENT.PRICINGPROCEDURE == T683.KALSM`
Recommended Priority Client Recommended Priority	`I_SERVICEDOCUMENT.MANDT == SCPRIO.CLIENT` `I_SERVICEDOCUMENT.RECOMMENDEDSERVICEPRIORITY == SCPRIO.PRIORITY`
Region (State, Province, County) ? Client Region (State, Province, County)	`I_SERVICEDOCUMENT.[column in domain "LAND1"] == T005S.LAND1` `I_SERVICEDOCUMENT.MANDT == T005S.MANDT` `I_SERVICEDOCUMENT.REGION == T005S.BLAND`
Employee Responsible Client Employee Responsible	`I_SERVICEDOCUMENT.MANDT == BUT000.CLIENT` `I_SERVICEDOCUMENT.RESPONSIBLEEMPLOYEE == BUT000.PARTNER`
Cancelling Party Client Cancelling Party	`I_SERVICEDOCUMENT.MANDT == CRMC_PARTY.CLIENT` `I_SERVICEDOCUMENT.SERVICEDOCUMENTCANCLNPARTY == CRMC_PARTY.CANC_PARTY`
CRM Service : Reason for Cancellation Client CRM Service : Reason for Cancellation	`I_SERVICEDOCUMENT.MANDT == CRMC_CANCREASON.CLIENT` `I_SERVICEDOCUMENT.SERVICEDOCUMENTCANCLNREASON == CRMC_CANCREASON.CANC_REASON`
Impact Client Impact	`I_SERVICEDOCUMENT.MANDT == CRMC_SRQM_IMPACT.CLIENT` `I_SERVICEDOCUMENT.SERVICEDOCUMENTIMPACT == CRMC_SRQM_IMPACT.IMPACT`
Activity Priority Client Activity Priority	`I_SERVICEDOCUMENT.MANDT == SCPRIO.CLIENT` `I_SERVICEDOCUMENT.SERVICEDOCUMENTPRIORITY == SCPRIO.PRIORITY`
Problem Category Client Problem Category	`I_SERVICEDOCUMENT.MANDT == CRMC_SRQM_PRBCAT.CLIENT` `I_SERVICEDOCUMENT.SERVICEDOCUMENTPROBLEMCATEGORY == CRMC_SRQM_PRBCAT.PROBLEM_CATEGORY`
Cancellation Reason Code Client Cancellation Reason Code	`I_SERVICEDOCUMENT.MANDT == TVAG.MANDT` `I_SERVICEDOCUMENT.SERVICEDOCUMENTREJECTIONREASON == TVAG.ABGRU`
Business Transaction Type Client Business Transaction Type	`I_SERVICEDOCUMENT.MANDT == CRMC_PROC_TYPE.CLIENT` `I_SERVICEDOCUMENT.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE`
Urgency Client Urgency	`I_SERVICEDOCUMENT.MANDT == CRMC_SRQM_URGENC.CLIENT` `I_SERVICEDOCUMENT.SERVICEDOCUMENTURGENCY == CRMC_SRQM_URGENC.URGENCY`
Executing Service Employee Client Executing Service Employee	`I_SERVICEDOCUMENT.MANDT == BUT000.CLIENT` `I_SERVICEDOCUMENT.SERVICEEMPLOYEE == BUT000.PARTNER`
Business Trans. Cat.	`I_SERVICEDOCUMENT.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY`
Risk Client Risk	`I_SERVICEDOCUMENT.MANDT == CRMC_SRQM_RISK.CLIENT` `I_SERVICEDOCUMENT.SERVICERISK == CRMC_SRQM_RISK.RISK`
Service Team Client Service Team	`I_SERVICEDOCUMENT.MANDT == BUT000.CLIENT` `I_SERVICEDOCUMENT.SERVICETEAM == BUT000.PARTNER`
Ship-To Party Client Ship-To Party	`I_SERVICEDOCUMENT.MANDT == BUT000.CLIENT` `I_SERVICEDOCUMENT.SHIPTOPARTY == BUT000.PARTNER`
Sold-To Party Client Sold-To Party	`I_SERVICEDOCUMENT.MANDT == BUT000.CLIENT` `I_SERVICEDOCUMENT.SOLDTOPARTY == BUT000.PARTNER`
Country/Region Client Country/Region	`I_SERVICEDOCUMENT.MANDT == T005.MANDT` `I_SERVICEDOCUMENT.SOLDTOPARTYCOUNTRY == T005.LAND1`
Region (State, Province, County) Client Country/Region Region (State, Province, County)	`I_SERVICEDOCUMENT.MANDT == T005S.MANDT` `I_SERVICEDOCUMENT.SOLDTOPARTYCOUNTRY == T005S.LAND1` `I_SERVICEDOCUMENT.SOLDTOPARTYREGION == T005S.BLAND`
Currency Client Currency	`I_SERVICEDOCUMENT.MANDT == TCURC.MANDT` `I_SERVICEDOCUMENT.TRANSACTIONCURRENCY == TCURC.WAERS`