CRMS4_SERV_U_SEARCH

Union of Items with Service Header | view: CRMS4_SERVUSRCH | Extraction: Not supported | Component: S4CRM: Reporting
Tables used: CRMS4D_MAGR_I, CRMS4D_REFOBJ, CRMS4D_EXT_REF, CRMS4D_SERV_H, CRMS4D_SERV_I, CRMS4D_TECH_RES, SIT_INST, SIT_INST_QUEUE, SIT_INST_QUEUE, CRMD_BRELVONAE, CRMD_BRELVONAE, CRMS4C_STAT_LC_T, CRMC_PROC_TYPE, CRMC_PROC_TYPE_T, CRMC_ACT_CAT_T, SCPRIOT, SCPRIOT, TFK_VT_TRTT, BUT000, TVTWT, TSPAT, CRMS4C_SRVC_ORGT, TVGRT, TVKBT, TVKOT, SIT_DEF, SIT_T_DEF, MPOS, MPLA
Column Name Description
object_type FK Business Trans. Cat.
object_id Transaction ID
Column Name Description
Column Name Description
Column Name Description
posting_date Posting Date for a Business Transaction
Column Name Description
template_type Template Type of CRM Transaction Show values
stat_lifecycle Life Cycle Status Show values
stat_released Release Status Show values
stat_quotation Quotation Status Show values
stat_error Error Status Show values
stat_delivery Delivery Status Show values
stat_goods_issue Goods Issue Status Show values
stat_billing Billing Status Show values
stat_for_billing Release Status for Cumulated Billing Show values
stat_cancelled Cancellation Status Show values
Column Name Description Domain name
GUID GUID of a CRM Order Object SYSUUID
header_guid GUID of a CRM Order Object SYSUUID
SOLD_TO_PARTY_LIST null
contact_person_list null
service_team_list null
po_number_sold Sold-To Party's External Reference Number TEXT35
po_number_sold_uc null
description Transaction Description CRM_PROCESS_DESCRIPTION
DESCRIPTION_UC null
stat_lifecycle_desc Short Text for Fixed Values DDTEXT
stat_released_desc Short Text for Fixed Values DDTEXT
stat_quotation_desc Short Text for Fixed Values DDTEXT
stat_error_desc Short Text for Fixed Values DDTEXT
stat_delivery_desc Short Text for Fixed Values DDTEXT
stat_goods_issue_desc Short Text for Fixed Values DDTEXT
stat_billing_desc Short Text for Fixed Values DDTEXT
stat_for_billing_desc Short Text for Fixed Values DDTEXT
stat_cancelled_desc Short Text for Fixed Values DDTEXT
service_employee_list null
service_org Service Organization HROBJEC_14
person_resp_list null
ship_to_party_list null
payer_list null
resp_group_list null
Master Data Relations Join Conditions
Customer Contact Person
  • Customer Contact Person
  • Client
  • CRMS4_SERV_U_SEARCH.CONTACT_PERSON == BUT000.PARTNER
  • CRMS4_SERV_U_SEARCH.MANDT == BUT000.CLIENT
Business Trans. Cat. CRMS4_SERV_U_SEARCH.OBJECT_TYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Payer
  • Payer
  • Client
  • CRMS4_SERV_U_SEARCH.PAYER == BUT000.PARTNER
  • CRMS4_SERV_U_SEARCH.MANDT == BUT000.CLIENT
Employee Responsible
  • Employee Responsible
  • Client
  • CRMS4_SERV_U_SEARCH.PERSON_RESP == BUT000.PARTNER
  • CRMS4_SERV_U_SEARCH.MANDT == BUT000.CLIENT
Responsible Group
  • Responsible Group
  • Client
  • CRMS4_SERV_U_SEARCH.RESP_GROUP == BUT000.PARTNER
  • CRMS4_SERV_U_SEARCH.MANDT == BUT000.CLIENT
Executing Service Employee
  • Executing Service Employee
  • Client
  • CRMS4_SERV_U_SEARCH.SERVICE_EMPLOYEE == BUT000.PARTNER
  • CRMS4_SERV_U_SEARCH.MANDT == BUT000.CLIENT
Service Team
  • Client
  • Service Team
  • CRMS4_SERV_U_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_U_SEARCH.SERVICE_TEAM == BUT000.PARTNER
Ship-To Party
  • Ship-To Party
  • Client
  • CRMS4_SERV_U_SEARCH.SHIP_TO_PARTY == BUT000.PARTNER
  • CRMS4_SERV_U_SEARCH.MANDT == BUT000.CLIENT
Sold-To Party
  • Client
  • Sold-To Party
  • CRMS4_SERV_U_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_U_SEARCH.SOLD_TO_PARTY == BUT000.PARTNER