A_ServiceOrderTemplate

Service Order Template | view: ASRVORDTMPL | TRAN | Extraction: Not supported | Component: S4CRM: Service Order Template
Tables used: CRMS4D_SERV_H
Column Name Description
ServiceOrderTemplate Transaction ID
Column Name Description
Column Name Description
Column Name Description
Column Name Description
ServiceDocumentTemplateType Template Type of CRM Transaction Show values
SrvcOrdTmplIsReleased Release Status Show values
Column Name Description Domain name
ServiceOrderTemplateUUID GUID of a CRM Order Object SYSUUID
SrvcOrdTmplDescription Transaction Description CRM_PROCESS_DESCRIPTION
SrvcDocTemplateSearchTermText Template Search Term CRM_TSRV_SERVICE_ID
SrvcDocTmplValdtyStartDateTime Template Start Date TZNTSTMPS
SrvcDocTmplValdtyEndDateTime Template End Date TZNTSTMPS
SrvcOrdTmplIsCompleted null
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
SalesOrganization Sales Organization VKORG
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesGroupOrgUnitID Sales Group HROBJEC_14
EnterpriseServiceOrganization Enterprise Service Organization CRMS4_ENTERPRISE_SERVICE_ORG
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
Master Data Relations Join Conditions
Distribution Channel
  • Distribution Channel
  • Client
  • A_SERVICEORDERTEMPLATE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • A_SERVICEORDERTEMPLATE.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • A_SERVICEORDERTEMPLATE.MANDT == TSPA.MANDT
  • A_SERVICEORDERTEMPLATE.DIVISION == TSPA.SPART
Language Key of Description A_SERVICEORDERTEMPLATE.LANGUAGE == T002.SPRAS
Activity Priority
  • Client
  • Activity Priority
  • A_SERVICEORDERTEMPLATE.MANDT == SCPRIO.CLIENT
  • A_SERVICEORDERTEMPLATE.SERVICEDOCUMENTPRIORITY == SCPRIO.PRIORITY
Business Transaction Type
  • Client
  • Business Transaction Type
  • Business Transaction Type
Business Trans. Cat.
  • Business Trans. Cat.
  • Business Trans. Cat.
  • A_SERVICEORDERTEMPLATE.SERVICEORDERTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
  • A_SERVICEORDERTEMPLATE.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Business Transaction Type
  • Client
  • Business Transaction Type
  • Business Transaction Type
Business Trans. Cat.
  • Business Trans. Cat.
  • Business Trans. Cat.
  • A_SERVICEORDERTEMPLATE.SERVICEORDERTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
  • A_SERVICEORDERTEMPLATE.SERVICEOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY