CRMS4_SERV_SEARCH

Service | view: CRMS4_SERVSEARCH | 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
💲 Currency (currency):
NET_VALUE Total Net Value of Document in Document Currency
Column Name Description
Column Name Description
po_date_sold Reference Document Date
valid_from null
valid_to null
posting_date Posting Date for a Business Transaction
Column Name Description
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
stat_archivable Archivable Show values
stat_archived Archived Show values
template_type Template Type of CRM Transaction Show values
stat_lifecycle_i Life Cycle Status Show values
stat_released_i Release Status Show values
stat_quotation_i Quotation Status Show values
stat_error_i Error Status Show values
stat_delivery_i Delivery Status Show values
stat_goods_issue_i Goods Issue Status Show values
stat_billing_i Billing Status Show values
stat_for_billing_i Billing Release Status Show values
stat_cancelled_i Cancellation Status Show values
stat_chklst_exec_i Execution Status of Checklist Item Show values
stat_activation_i Activation Status of Subscription Order/Contract Show values
stat_cont_ts_i Status of Contract Time Slice Show values
Column Name Description Domain name
GUID GUID of a CRM Order Object SYSUUID
header_guid GUID of a CRM Order Object SYSUUID
process_type_txt Description (20 Characters) TEXT20
SOLD_TO_PARTY_LIST null
contact_person_list null
priority_txt Description TEXT40
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
stat_archivable_desc Short Text for Fixed Values DDTEXT
stat_archived_desc Short Text for Fixed Values DDTEXT
category_txt Description (20 Characters) TEXT20
service_employee_list null
service_org Service Organization HROBJEC_14
person_resp_list null
CREATED_BY User that Created the Transaction UNAME
CREATED_AT Created At TZNTSTMPS
item_guid GUID of a CRM Order Object SYSUUID
number_int Shortened Item Number in Document CRMS4_NUMBER_INT
refobj_product_id Product Name Entered CRM_ORDERED_PROD
REFOBJ_PRODUCT_NAME Product Description CRM_PRSHTEXT40_DB
sold_to_party_list_i null
ship_to_party_list_i null
bill_to_party_list_i null
payer_list_i null
person_resp_list_i null
contact_person_list_i null
resp_group_list_i null
service_team_list_i null
service_employee_list_i null
stat_lifecycle_desc_i Short Text for Fixed Values DDTEXT
stat_released_desc_i Short Text for Fixed Values DDTEXT
stat_quotation_desc_i Short Text for Fixed Values DDTEXT
stat_error_desc_i Short Text for Fixed Values DDTEXT
stat_delivery_desc_i Short Text for Fixed Values DDTEXT
stat_goods_issue_desc_i Short Text for Fixed Values DDTEXT
stat_billing_desc_i Short Text for Fixed Values DDTEXT
stat_for_billing_desc_i Short Text for Fixed Values DDTEXT
stat_cancelled_desc_i Short Text for Fixed Values DDTEXT
stat_chklst_exec_desc_i Short Text for Fixed Values DDTEXT
stat_activation_desc_i Short Text for Fixed Values DDTEXT
stat_cont_ts_desc_i Short Text for Fixed Values DDTEXT
Master Data Relations Join Conditions
Bill-To Party
  • Bill-To Party
  • Client
  • CRMS4_SERV_SEARCH.BILL_TO_PARTY_I == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.MANDT == BUT000.CLIENT
Activity Category (Communication Type)
  • Activity Category (Communication Type)
  • Client
Customer Contact Person
  • Customer Contact Person
  • Customer Contact Person
  • Client
  • CRMS4_SERV_SEARCH.CONTACT_PERSON == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.CONTACT_PERSON_I == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.MANDT == BUT000.CLIENT
Customer Contact Person
  • Customer Contact Person
  • Customer Contact Person
  • Client
  • CRMS4_SERV_SEARCH.CONTACT_PERSON == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.CONTACT_PERSON_I == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.MANDT == BUT000.CLIENT
Currency
  • Client
  • Currency
  • CRMS4_SERV_SEARCH.MANDT == TCURC.MANDT
  • CRMS4_SERV_SEARCH.CURRENCY == TCURC.WAERS
Impact
  • Client
  • Impact
Status of Agent Inbox Item
  • Client
  • Status of Agent Inbox Item
Item Category
  • Client
  • Item Category
Business Trans. Cat. CRMS4_SERV_SEARCH.OBJECT_TYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Payer
  • Client
  • Payer
  • Payer
  • CRMS4_SERV_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_SEARCH.PAYER_I == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.PAYER == BUT000.PARTNER
Payer
  • Client
  • Payer
  • Payer
  • CRMS4_SERV_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_SEARCH.PAYER_I == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.PAYER == BUT000.PARTNER
Employee Responsible
  • Client
  • Employee Responsible
  • Employee Responsible
  • CRMS4_SERV_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_SEARCH.PERSON_RESP_I == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.PERSON_RESP == BUT000.PARTNER
Employee Responsible
  • Client
  • Employee Responsible
  • Employee Responsible
  • CRMS4_SERV_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_SEARCH.PERSON_RESP_I == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.PERSON_RESP == BUT000.PARTNER
Activity Priority
  • Client
  • Activity Priority
  • CRMS4_SERV_SEARCH.MANDT == SCPRIO.CLIENT
  • CRMS4_SERV_SEARCH.PRIORITY == SCPRIO.PRIORITY
Business Transaction Type
  • Client
  • Business Transaction Type
Responsible Group
  • Client
  • Responsible Group
  • Responsible Group
  • CRMS4_SERV_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_SEARCH.RESP_GROUP_I == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.RESP_GROUP == BUT000.PARTNER
Responsible Group
  • Client
  • Responsible Group
  • Responsible Group
  • CRMS4_SERV_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_SEARCH.RESP_GROUP_I == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.RESP_GROUP == BUT000.PARTNER
Executing Service Employee
  • Executing Service Employee
  • Executing Service Employee
  • Client
  • CRMS4_SERV_SEARCH.SERVICE_EMPLOYEE_I == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.SERVICE_EMPLOYEE == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.MANDT == BUT000.CLIENT
Executing Service Employee
  • Executing Service Employee
  • Executing Service Employee
  • Client
  • CRMS4_SERV_SEARCH.SERVICE_EMPLOYEE_I == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.SERVICE_EMPLOYEE == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.MANDT == BUT000.CLIENT
Service Team
  • Client
  • Service Team
  • Service Team
  • CRMS4_SERV_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_SEARCH.SERVICE_TEAM_I == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.SERVICE_TEAM == BUT000.PARTNER
Service Team
  • Client
  • Service Team
  • Service Team
  • CRMS4_SERV_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_SEARCH.SERVICE_TEAM_I == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.SERVICE_TEAM == BUT000.PARTNER
Ship-To Party
  • Client
  • Ship-To Party
  • Ship-To Party
  • CRMS4_SERV_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_SEARCH.SHIP_TO_PARTY_I == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.SHIP_TO_PARTY == BUT000.PARTNER
Ship-To Party
  • Client
  • Ship-To Party
  • Ship-To Party
  • CRMS4_SERV_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_SEARCH.SHIP_TO_PARTY_I == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.SHIP_TO_PARTY == BUT000.PARTNER
Country/Region
  • Client
  • Country/Region
  • CRMS4_SERV_SEARCH.MANDT == T005.MANDT
  • CRMS4_SERV_SEARCH.SOLD_TO_COUNTRY_I == T005.LAND1
Sold-To Party
  • Client
  • Sold-To Party
  • Sold-To Party
  • CRMS4_SERV_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_SEARCH.SOLD_TO_PARTY_I == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.SOLD_TO_PARTY == BUT000.PARTNER
Sold-To Party
  • Client
  • Sold-To Party
  • Sold-To Party
  • CRMS4_SERV_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_SEARCH.SOLD_TO_PARTY_I == BUT000.PARTNER
  • CRMS4_SERV_SEARCH.SOLD_TO_PARTY == BUT000.PARTNER
Region (State, Province, County)
  • Client
  • Country/Region
  • Region (State, Province, County)
  • CRMS4_SERV_SEARCH.MANDT == T005S.MANDT
  • CRMS4_SERV_SEARCH.SOLD_TO_COUNTRY_I == T005S.LAND1
  • CRMS4_SERV_SEARCH.SOLD_TO_REGION_I == T005S.BLAND
Urgency
  • Urgency
  • Client