CRMS4_SERV_H_SEARCH

Service Header | view: CRMS4_SERVHSRCH | Extraction: Not supported | Component: S4CRM: Reporting
Tables used: CRMS4D_EXT_REF, CRMS4D_SERV_H, 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, 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):
gross_value_h Total Gross Value of Document in Document Currency
NET_VALUE Total Net Value of Document in Document Currency
net_value_man_h Expected Total Net Value of Products in Document Currency
tax_amount_h Total Tax Amount in Document Currency
freight_h Shipment Costs for Document in Total Document Currency
net_wo_freight_h Header sums: Net value without freight
Column Name Description
gross_weight_h Gross Weight for Total Document
net_weight_h Net Weight of Total Document
volume_h Total Volume of Document
Column Name Description
valid_from null
valid_to null
quot_start_date null
quot_end_date null
date_start null
date_end null
posting_date Posting Date for a Business Transaction
CREATED_AT_DATE null
CREATED_ON null
CHANGED_AT_DATE null
CHANGED_ON null
exchg_date Exchange Rate Date
price_date Pricing Date
po_date_sold Reference Document Date
po_date_ship Ship-To Party's Reference Document Date
Column Name Description
aprv_activated Logical Variable Show values
change_allowed Logical Variable Show values
sepa_on Indicator for SEPA-Relevant Transactions Show values
template_type Template Type of CRM Transaction Show values
archiving_flag Indicator Whether the Business Transaction Can Be Archived Show values
object_id_ok Indicator That Transaction ID Is Correct Show values
is_maintenance_order Logical Variable Show values
service_org_ori Origin Indicator: Service Organization Show values
service_orgr_ori Origin Indicator: Service Scenario Organizational Unit Show values
sales_org_ori Origin Indicator: Sales Organization Show values
dis_channel_ori Origin Indicator: Distribution Channel Show values
sales_off_ori Origin Indicator: Sales Office Show values
sales_group_ori Origin Indicator: Sales Group Show values
sales_orgr_ori Origin Indicator: Sales Scenario Organizational Unit Show values
division_ori Origin Flag: Division Show values
probability Order Probability Show values
date_qty_fixed Fixed Date and Quantity Show values
deli_unlim_tol Indicator: Unlimited Overdelivery Allowed Show values
ordercombind Indicator: Order Combination Show values
part_dlv Delivery Control Show values
part_dlv_itm Delivery Control (Item) Show values
escalation Escalation Show values
is_updated Logical Variable 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
stat_archivable Archivable Show values
stat_archived Archived Show values
stat_open Status "Open" Show values
Column Name Description Domain name
category_txt Description (20 Characters) TEXT20
priority_txt Description TEXT40
ac_assignment Settlement Account Assignment CRMT_AC_ASSIGN
ac_percentage Percentage of Costs to Be Distributed DEC3_2
period_date Period Date BCOS_TSTMP
settl_from Start of Settlement for Period BCOS_TSTMP
settl_to End of Settlement for Period BCOS_TSTMP
bill_date Billing Date for Billing Index and Printout TZNTSTMPS
invcr_date Billing Document Creation Date TZNTSTMPS
value_date Fixed Value Date BCOS_TSTMP
mandate_id Unique Reference to Mandate per Payment Recipient CRM_MANDATE_ID
contract_account_list null
number_items Number of items in an order
valid_from_tstmp Time Dependency: Validity Start Date BCOS_TSTMP
valid_to_tstmp Time Dependency: Validity End Date BCOS_TSTMP
quot_start Quotation: Valid from Date BCOS_TSTMP
quot_end Quotation: Valid to Date BCOS_TSTMP
srv_cust_beg Service Request Start Date TZNTSTMPS
srv_cust_end Service Request Due Date TZNTSTMPS
srq_work_dura_2 Work Duration 2 of Service Transaction CRMS4_SRQ_WORK_DURA_2
srq_work_unit Work Duration Unit of Service Transaction CRMS4_SRQ_WORK_UNIT
srq_tot_dura_2 Total Duration 2 of Service Transaction CRMS4_SRQ_TOT_DURA_2
srq_tot_unit Total Duration Unit of Service Transaction CRMS4_SRQ_TOT_UNIT
srv_rfirst First Response By TZNTSTMPS
srv_rready Due By TZNTSTMPS
srv_close Closing Date TZNTSTMPS
contstart Contract Start date DEC15
contend Contract End Date DEC15
due_on Date Transaction is Due TZNTSTMPS
header_guid GUID of a CRM Order Object SYSUUID
GUID GUID of a CRM Order Object SYSUUID
header_guid_char 32 Character CRM Object GUID (Converted)
SIT_NUM_HDR Number of Situations INT4
SIT_NUM_TOT Number of Situations INT4
process_type_txt Description (20 Characters) TEXT20
description Transaction Description CRM_PROCESS_DESCRIPTION
DESCRIPTION_UC null
created_at_h Created At TZNTSTMPS
CREATED_AT Created At TZNTSTMPS
changed_at_h Changed At TZNTSTMPS
CHANGED_AT Changed At TZNTSTMPS
created_by_h User that Created the Transaction UNAME
CREATED_BY User that Created the Transaction UNAME
changed_by_h Transaction Last Changed By UNAME
changed_by Transaction Last Changed By UNAME
head_changed_at Time of Last Change to the Transaction BCOS_TSTMP
verify_date Time Period of Last Archiving Attempt BCOS_TSTMP
sales_org Sales Organization ID HROBJEC_14
sales_office Sales Office HROBJEC_14
sales_group Sales Group HROBJEC_14
sales_org_resp Organizational Unit (Sales) HROBJEC_14
service_org Service Organization HROBJEC_14
service_org_resp Organizational Unit (Service) HROBJEC_14
sales_org_sd Sales Organization VKORG
sales_office_sd Sales office VKBUR
sales_group_sd Sales group VKGRP
sales_org_sd_desc Sales Organization Description TEXT20
dis_channel_desc Distribution Channel Description TEXT20
division_desc Division Description TEXT20
sales_office_sd_desc Sales Office Description TEXT20
sales_group_sd_desc Sales Group Description TEXT20
enterprise_service_org Enterprise Service Organization CRMS4_ENTERPRISE_SERVICE_ORG
enterprise_service_org_name Enterprise Service Organization Name CRMS4_ENT_SERVICE_ORG_NAME
SOLD_TO_PARTY_LIST null
ship_to_party_list null
bill_to_party_list null
payer_list null
person_resp_list null
contact_person_list null
resp_group_list null
service_team_list null
service_employee_list null
INBOX_ASSIGNED_TO_list null
INBOX_GROUP_ASSIGNED_list null
INBOX_ACCOUNT_list null
INBOX_CONTACT_PERSON_list null
exchg_rate Exchange Rate CRM_EXCHG_RATE
vat_reg_no Sales tax registration number
po_number_sold Sold-To Party's External Reference Number TEXT35
po_number_sold_uc null
your_ref_sold Sold-to Party Reference TEXT12
po_number_ship Ship-To Party's External Reference Number TEXT35
your_ref_ship Ship-To Party Reference TEXT12
submission Collective Number for Quotations TEXT10
req_dlv_date_h Requested Delivery Date Header BCOS_TSTMP
templ_searchterm Template Search Term CRM_TSRV_SERVICE_ID
incoterms2 Incoterms (Part 2) CRM_INCOTERMS2
over_dlv_tol Overdelivery Tolerance Limit PRZ21
under_dlv_tol Underdelivery Tolerance Limit PRZ21
dlv_group Delivery Group (Items are Delivered Together) CRMT_DLV_GROUP
last_updated_at Last Updated On COM_TSTMP
chklst_id Checklist ID CRM_SRQM_CHKLST_ID
wp_fixval Fix value for Transaction Ranking determination CRM_SRQM_WP_FIXVAL
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
stat_open_desc Short Text for Fixed Values DDTEXT
catlvlguid01_01 Category GUID 1- schema 1 SYSUUID
catlvlguid02_01 Category GUID 2- schema 1 SYSUUID
catlvlguid03_01 Category GUID 3- schema 1 SYSUUID
catlvlguid04_01 Category GUID 4- schema 1 SYSUUID
catlvlguid05_01 Category GUID 5- schema 1 SYSUUID
catlvlguid06_01 Category GUID 6- schema 1 SYSUUID
catlvlguid07_01 Category GUID 7- schema 1 SYSUUID
catlvlguid08_01 Category GUID 8- schema 1 SYSUUID
catlvlguid09_01 Category GUID 9- schema 1 SYSUUID
catlvlguid10_01 Category GUID 10- schema 1 SYSUUID
asp_id_01 Coherent Cat. - Aspect ID CRMS4_ERMS_CAT_AS_ID_DO
cat_id_01 Coherent Cat. - Category ID CRMS4_ERMS_CAT_CA_ID_DO
catlvlguid01_02 Category GUID 1- schema 2 SYSUUID
catlvlguid02_02 Category GUID 2- schema 2 SYSUUID
catlvlguid03_02 Category GUID 3- schema 2 SYSUUID
catlvlguid04_02 Category GUID 4- schema 2 SYSUUID
catlvlguid05_02 Category GUID 5- schema 2 SYSUUID
catlvlguid06_02 Category GUID 6- schema 2 SYSUUID
catlvlguid07_02 Category GUID 7- schema 2 SYSUUID
catlvlguid08_02 Category GUID 8- schema 2 SYSUUID
catlvlguid09_02 Category GUID 9- schema 2 SYSUUID
catlvlguid10_02 Category GUID 10- schema 2 SYSUUID
asp_id_02 Coherent Cat. - Aspect ID CRMS4_ERMS_CAT_AS_ID_DO
cat_id_02 Coherent Cat. - Category ID CRMS4_ERMS_CAT_CA_ID_DO
billplan_start_date Start Date of Billing Plan BCOS_TSTMP
billplan_end_date End Date of Billing Plan BCOS_TSTMP
billplan_date_from Dates From BCOS_TSTMP
billplan_date_to Dates To BCOS_TSTMP
cashflow_type Flow Category CRMT_CASHFLOW_TYPE
maintenance_plan Maintenance Plan WARPL
maintenance_plan_desc Maintenance Plan Text TEXT40
maintenance_item Maintenance item POSNU
maintenance_item_desc Item Short Text TEXT40
reference_number External Reference Number CRMS4_EXT_REF_NUM
reference_type Type of External Reference CRM_EXT_REF_TYPE
Master Data Relations | to Other Relations ↓ Join Conditions
Accounting Indicator
  • Accounting Indicator
  • Client
  • CRMS4_SERV_H_SEARCH.AC_INDICATOR == TBMOT.BEMOT
  • CRMS4_SERV_H_SEARCH.MANDT == TBMOT.MANDT
Object Type for Settlement Account Assignment
  • Object Type for Settlement Account Assignment
  • Client
Approval Procedure
  • Client
  • Approval Procedure
Authorization Scope
  • Client
  • Authorization Scope
  • ?
Business Partner: Billing Block Reason
  • Client
  • Business Partner: Billing Block Reason
  • CRMS4_SERV_H_SEARCH.MANDT == TVFS.MANDT
  • CRMS4_SERV_H_SEARCH.BILLING_BLOCK == TVFS.FAKSP
Time Zone of Billing Plan Set
  • Time Zone of Billing Plan Set
  • Client
  • CRMS4_SERV_H_SEARCH.BILLING_TIMEZONE == TTZZ.TZONE
  • CRMS4_SERV_H_SEARCH.MANDT == TTZZ.CLIENT
Time Zone of Billing Plan Set
  • Time Zone of Billing Plan Set
  • Client
  • CRMS4_SERV_H_SEARCH.BILLPLAN_D_TIMEZONE == TTZZ.TZONE
  • CRMS4_SERV_H_SEARCH.MANDT == TTZZ.CLIENT
ID of Billing Plan Line
  • ID of Billing Plan Line
  • Billing Plan Type
  • Client
Time Zone of Billing Plan Set
  • Client
  • Time Zone of Billing Plan Set
  • CRMS4_SERV_H_SEARCH.MANDT == TTZZ.CLIENT
  • CRMS4_SERV_H_SEARCH.BILLPLAN_TIMEZONE == TTZZ.TZONE
Billing Plan Type
  • Billing Plan Type
  • Client
Bill-To Party
  • Bill-To Party
  • Client
  • CRMS4_SERV_H_SEARCH.BILL_TO_PARTY == BUT000.PARTNER
  • CRMS4_SERV_H_SEARCH.MANDT == BUT000.CLIENT
CRM Business Transaction Classification
  • CRM Business Transaction Classification
  • ?
Cancelling Party
  • Cancelling Party
  • Client
  • CRMS4_SERV_H_SEARCH.CANCPARTY == CRMC_PARTY.CANC_PARTY
  • CRMS4_SERV_H_SEARCH.MANDT == CRMC_PARTY.CLIENT
Cancellation Procedure
  • Client
  • Cancellation Procedure
CRM Service : Reason for Cancellation
  • Client
  • CRM Service : Reason for Cancellation
Activity Category (Communication Type)
  • Activity Category (Communication Type)
  • Client
Change Category
  • Client
  • Change Category
Customer Contact Person
  • Customer Contact Person
  • Client
  • CRMS4_SERV_H_SEARCH.CONTACT_PERSON == BUT000.PARTNER
  • CRMS4_SERV_H_SEARCH.MANDT == BUT000.CLIENT
Contract Account Number
  • Contract Account Number
  • Client
  • CRMS4_SERV_H_SEARCH.CONTRACT_ACCOUNT == FKKVK.VKONT
  • CRMS4_SERV_H_SEARCH.MANDT == FKKVK.MANDT
Currency
  • Client
  • Currency
  • CRMS4_SERV_H_SEARCH.MANDT == TCURC.MANDT
  • CRMS4_SERV_H_SEARCH.CURRENCY == TCURC.WAERS
Business Partner Type
  • Client
  • Business Partner Type
  • CRMS4_SERV_H_SEARCH.MANDT == TB004.CLIENT
  • CRMS4_SERV_H_SEARCH.CUSTOMER_TYPE == TB004.BPKIND
Customer Group
  • Client
  • Customer Group
  • CRMS4_SERV_H_SEARCH.MANDT == T151.MANDT
  • CRMS4_SERV_H_SEARCH.CUST_GROUP == T151.KDGRP
Customer Group 1
  • Customer Group 1
  • Client
  • CRMS4_SERV_H_SEARCH.CUST_GROUP1 == TVV1.KVGR1
  • CRMS4_SERV_H_SEARCH.MANDT == TVV1.MANDT
Customer Group 2
  • Client
  • Customer Group 2
  • CRMS4_SERV_H_SEARCH.MANDT == TVV2.MANDT
  • CRMS4_SERV_H_SEARCH.CUST_GROUP2 == TVV2.KVGR2
Customer Group 3
  • Customer Group 3
  • Client
  • CRMS4_SERV_H_SEARCH.CUST_GROUP3 == TVV3.KVGR3
  • CRMS4_SERV_H_SEARCH.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • CRMS4_SERV_H_SEARCH.CUST_GROUP4 == TVV4.KVGR4
  • CRMS4_SERV_H_SEARCH.MANDT == TVV4.MANDT
Customer Group 5
  • Client
  • Customer Group 5
  • CRMS4_SERV_H_SEARCH.MANDT == TVV5.MANDT
  • CRMS4_SERV_H_SEARCH.CUST_GROUP5 == TVV5.KVGR5
Customer Pricing Procedure
  • Client
  • Customer Pricing Procedure
  • CRMS4_SERV_H_SEARCH.MANDT == TVKD.MANDT
  • CRMS4_SERV_H_SEARCH.CUST_PRIC_PROC == TVKD.KALKS
Business Partner: Delivery Block Reason
  • Business Partner: Delivery Block Reason
  • Client
  • CRMS4_SERV_H_SEARCH.DELIVERY_BLOCK == TVLS.LIFSP
  • CRMS4_SERV_H_SEARCH.MANDT == TVLS.MANDT
Language Key of Description CRMS4_SERV_H_SEARCH.DESCR_LANGUAGE == T002.SPRAS
Distribution Channel
  • Distribution Channel
  • Client
  • CRMS4_SERV_H_SEARCH.DIS_CHANNEL == TVTW.VTWEG
  • CRMS4_SERV_H_SEARCH.MANDT == TVTW.MANDT
Division
  • Division
  • Client
  • CRMS4_SERV_H_SEARCH.DIVISION == TSPA.SPART
  • CRMS4_SERV_H_SEARCH.MANDT == TSPA.MANDT
Delivery Priority
  • Client
  • Delivery Priority
  • CRMS4_SERV_H_SEARCH.MANDT == TPRIO.MANDT
  • CRMS4_SERV_H_SEARCH.DLV_PRIO == TPRIO.LPRIO
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • CRMS4_SERV_H_SEARCH.EXCHG_TYPE == TCURV.KURST
  • CRMS4_SERV_H_SEARCH.MANDT == TCURV.MANDT
Impact
  • Client
  • Impact
Sales Partners
  • Client
  • Sales Partners
  • CRMS4_SERV_H_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_H_SEARCH.INBOX_ACCOUNT == BUT000.PARTNER
Employee Responsible
  • Employee Responsible
  • Client
  • CRMS4_SERV_H_SEARCH.INBOX_ASSIGNED_TO == BUT000.PARTNER
  • CRMS4_SERV_H_SEARCH.MANDT == BUT000.CLIENT
Customer Contact Person
  • Client
  • Customer Contact Person
  • CRMS4_SERV_H_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_H_SEARCH.INBOX_CONTACT_PERSON == BUT000.PARTNER
Responsible Group
  • Client
  • Responsible Group
  • CRMS4_SERV_H_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_H_SEARCH.INBOX_GROUP_ASSIGNED == BUT000.PARTNER
Status of Agent Inbox Item
  • Client
  • Status of Agent Inbox Item
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • CRMS4_SERV_H_SEARCH.MANDT == TINC.MANDT
  • CRMS4_SERV_H_SEARCH.INCOTERMS1 == TINC.INCO1
Industry Sector
  • Industry Sector
  • Client
  • CRMS4_SERV_H_SEARCH.INDUSTRY == T016.BRSCH
  • CRMS4_SERV_H_SEARCH.MANDT == T016.MANDT
Date type
  • Date type
  • Client
  • CRMS4_SERV_H_SEARCH.KIND_BILL_DATE == SCAPPTTYPE.APPT_TYPE
  • CRMS4_SERV_H_SEARCH.MANDT == SCAPPTTYPE.CLIENT
Date type
  • Date type
  • Client
  • CRMS4_SERV_H_SEARCH.KIND_DATE_FROM == SCAPPTTYPE.APPT_TYPE
  • CRMS4_SERV_H_SEARCH.MANDT == SCAPPTTYPE.CLIENT
Date type
  • Client
  • Date type
  • CRMS4_SERV_H_SEARCH.MANDT == SCAPPTTYPE.CLIENT
  • CRMS4_SERV_H_SEARCH.KIND_DATE_TO == SCAPPTTYPE.APPT_TYPE
Date type
  • Date type
  • Client
  • CRMS4_SERV_H_SEARCH.KIND_END_DATE == SCAPPTTYPE.APPT_TYPE
  • CRMS4_SERV_H_SEARCH.MANDT == SCAPPTTYPE.CLIENT
Date type
  • Client
  • Date type
  • CRMS4_SERV_H_SEARCH.MANDT == SCAPPTTYPE.CLIENT
  • CRMS4_SERV_H_SEARCH.KIND_INVCR_DATE == SCAPPTTYPE.APPT_TYPE
Date type
  • Date type
  • Client
  • CRMS4_SERV_H_SEARCH.KIND_PERIOD_DATE == SCAPPTTYPE.APPT_TYPE
  • CRMS4_SERV_H_SEARCH.MANDT == SCAPPTTYPE.CLIENT
Date type
  • Client
  • Date type
  • CRMS4_SERV_H_SEARCH.MANDT == SCAPPTTYPE.CLIENT
  • CRMS4_SERV_H_SEARCH.KIND_SETTL_FROM == SCAPPTTYPE.APPT_TYPE
Date type
  • Client
  • Date type
  • CRMS4_SERV_H_SEARCH.MANDT == SCAPPTTYPE.CLIENT
  • CRMS4_SERV_H_SEARCH.KIND_SETTL_TO == SCAPPTTYPE.APPT_TYPE
Date type
  • Client
  • Date type
  • CRMS4_SERV_H_SEARCH.MANDT == SCAPPTTYPE.CLIENT
  • CRMS4_SERV_H_SEARCH.KIND_START_DATE == SCAPPTTYPE.APPT_TYPE
Date type
  • Client
  • Date type
  • CRMS4_SERV_H_SEARCH.MANDT == SCAPPTTYPE.CLIENT
  • CRMS4_SERV_H_SEARCH.KIND_VALUE_DATE == SCAPPTTYPE.APPT_TYPE
Business Trans. Cat. CRMS4_SERV_H_SEARCH.OBJECT_TYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Payer
  • Payer
  • Client
  • CRMS4_SERV_H_SEARCH.PAYER == BUT000.PARTNER
  • CRMS4_SERV_H_SEARCH.MANDT == BUT000.CLIENT
Payment Plan Type
  • Payment Plan Type
  • Client
  • CRMS4_SERV_H_SEARCH.PAYPLAN_TYPE == COMC_PAYPL.PAYPLAN_TYPE
  • CRMS4_SERV_H_SEARCH.MANDT == COMC_PAYPL.CLIENT
Employee Responsible
  • Client
  • Employee Responsible
  • CRMS4_SERV_H_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_H_SEARCH.PERSON_RESP == BUT000.PARTNER
Terms of Payment
  • Client
  • ?
  • Terms of Payment
  • CRMS4_SERV_H_SEARCH.MANDT == T052.MANDT
  • CRMS4_SERV_H_SEARCH.[column in domain "DZTAGG_052"] == T052.ZTAGG
  • CRMS4_SERV_H_SEARCH.PMNTTRMS == T052.ZTERM
Customer Price Group
  • Client
  • Customer Price Group
  • CRMS4_SERV_H_SEARCH.MANDT == T188.MANDT
  • CRMS4_SERV_H_SEARCH.PRICE_GRP == T188.KONDA
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • ?
  • ?
  • CRMS4_SERV_H_SEARCH.PRICING_PROCEDURE == T683.KALSM
  • CRMS4_SERV_H_SEARCH.MANDT == T683.MANDT
  • CRMS4_SERV_H_SEARCH.[column in domain "KVEWE"] == T683.KVEWE
  • CRMS4_SERV_H_SEARCH.[column in domain "KAPPL"] == T683.KAPPL
Activity Priority
  • Client
  • Activity Priority
  • CRMS4_SERV_H_SEARCH.MANDT == SCPRIO.CLIENT
  • CRMS4_SERV_H_SEARCH.PRIORITY == SCPRIO.PRIORITY
Problem Category
  • Client
  • Problem Category
Business Transaction Type
  • Business Transaction Type
  • Client
Recommended Priority
  • Recommended Priority
  • Client
  • CRMS4_SERV_H_SEARCH.REC_PRIORITY == SCPRIO.PRIORITY
  • CRMS4_SERV_H_SEARCH.MANDT == SCPRIO.CLIENT
Reference Currency
  • Reference Currency
  • Client
  • CRMS4_SERV_H_SEARCH.REF_CURRENCY == TCURC.WAERS
  • CRMS4_SERV_H_SEARCH.MANDT == TCURC.MANDT
Region (State, Province, County)
  • Client
  • ?
  • Region (State, Province, County)
  • CRMS4_SERV_H_SEARCH.MANDT == T005S.MANDT
  • CRMS4_SERV_H_SEARCH.[column in domain "LAND1"] == T005S.LAND1
  • CRMS4_SERV_H_SEARCH.REGION == T005S.BLAND
Cancellation Reason Code
  • Client
  • Cancellation Reason Code
  • CRMS4_SERV_H_SEARCH.MANDT == TVAG.MANDT
  • CRMS4_SERV_H_SEARCH.REJECTION == TVAG.ABGRU
Time Zone Requested Delivery Date Header
  • Time Zone Requested Delivery Date Header
  • Client
  • CRMS4_SERV_H_SEARCH.REQ_TIMEZONE_H == TTZZ.TZONE
  • CRMS4_SERV_H_SEARCH.MANDT == TTZZ.CLIENT
Responsible Group
  • Client
  • Responsible Group
  • CRMS4_SERV_H_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_H_SEARCH.RESP_GROUP == BUT000.PARTNER
Risk
  • Client
  • Risk
Executing Service Employee
  • Client
  • Executing Service Employee
  • CRMS4_SERV_H_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_H_SEARCH.SERVICE_EMPLOYEE == BUT000.PARTNER
Service Team
  • Client
  • Service Team
  • CRMS4_SERV_H_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_H_SEARCH.SERVICE_TEAM == BUT000.PARTNER
Shipping Conditions
  • Client
  • Shipping Conditions
  • CRMS4_SERV_H_SEARCH.MANDT == TVSB.MANDT
  • CRMS4_SERV_H_SEARCH.SHIP_COND == TVSB.VSBED
Ship-To Party
  • Ship-To Party
  • Client
  • CRMS4_SERV_H_SEARCH.SHIP_TO_PARTY == BUT000.PARTNER
  • CRMS4_SERV_H_SEARCH.MANDT == BUT000.CLIENT
Country/Region
  • Client
  • Country/Region
  • CRMS4_SERV_H_SEARCH.MANDT == T005.MANDT
  • CRMS4_SERV_H_SEARCH.SOLD_TO_COUNTRY == T005.LAND1
Sold-To Party
  • Client
  • Sold-To Party
  • CRMS4_SERV_H_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_H_SEARCH.SOLD_TO_PARTY == BUT000.PARTNER
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Country/Region
  • CRMS4_SERV_H_SEARCH.MANDT == T005S.MANDT
  • CRMS4_SERV_H_SEARCH.SOLD_TO_REGION == T005S.BLAND
  • CRMS4_SERV_H_SEARCH.SOLD_TO_COUNTRY == T005S.LAND1
Tax Jurisdiction Code (Structure for tax calculation)
  • Client
  • ?
  • Tax Jurisdiction Code (Structure for tax calculation)
  • CRMS4_SERV_H_SEARCH.MANDT == TTXJ.MANDT
  • CRMS4_SERV_H_SEARCH.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • CRMS4_SERV_H_SEARCH.TAXJURCODE == TTXJ.TXJCD
Tax Destination Country/Region
  • Client
  • Tax Destination Country/Region
  • CRMS4_SERV_H_SEARCH.MANDT == T005.MANDT
  • CRMS4_SERV_H_SEARCH.TAX_DEST_CTY == T005.LAND1
Region (State, Province, County)
  • Region (State, Province, County)
  • Client
  • Tax Destination Country/Region
  • CRMS4_SERV_H_SEARCH.TAX_DEST_REG == T005S.BLAND
  • CRMS4_SERV_H_SEARCH.MANDT == T005S.MANDT
  • CRMS4_SERV_H_SEARCH.TAX_DEST_CTY == T005S.LAND1
Urgency
  • Client
  • Urgency
Usage Indicator
  • Client
  • Usage Indicator
  • CRMS4_SERV_H_SEARCH.MANDT == TVLV.MANDT
  • CRMS4_SERV_H_SEARCH.USAGE_TYPE == TVLV.ABRVW
Unit for the Volume of a Product
  • Client
  • Unit for the Volume of a Product
  • CRMS4_SERV_H_SEARCH.MANDT == T006.MANDT
  • CRMS4_SERV_H_SEARCH.VOLUME_UNIT_H == T006.MSEHI
Weight Unit
  • Client
  • Weight Unit
  • CRMS4_SERV_H_SEARCH.MANDT == T006.MANDT
  • CRMS4_SERV_H_SEARCH.WEIGHT_UNIT_H == T006.MSEHI
Other Relations | to Master Data Relations ↑ Join Conditions
Rule for Determining the Next Billing Date
  • Rule for Determining the Next Billing Date
  • Client
  • CRMS4_SERV_H_SEARCH.BILLPLAN_D_RULE_BILL_DATE == TIMERULEH.RULE_ID
  • CRMS4_SERV_H_SEARCH.MANDT == TIMERULEH.CLIENT
Rule for Determining Next Billing Document Creation Date
  • Client
  • Rule for Determining Next Billing Document Creation Date
  • CRMS4_SERV_H_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_H_SEARCH.BILLPLAN_D_RULE_INVCR_DATE == TIMERULEH.RULE_ID
Rule for Determining the Period Date
  • Rule for Determining the Period Date
  • Client
  • CRMS4_SERV_H_SEARCH.BILLPLAN_D_RULE_PERIOD_DATE == TIMERULEH.RULE_ID
  • CRMS4_SERV_H_SEARCH.MANDT == TIMERULEH.CLIENT
Rule for Determining Start of Settlement Period
  • Rule for Determining Start of Settlement Period
  • Client
  • CRMS4_SERV_H_SEARCH.BILLPLAN_D_RULE_SETTL_FROM == TIMERULEH.RULE_ID
  • CRMS4_SERV_H_SEARCH.MANDT == TIMERULEH.CLIENT
Rule for Determining End of Settlement Period
  • Client
  • Rule for Determining End of Settlement Period
  • CRMS4_SERV_H_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_H_SEARCH.BILLPLAN_D_RULE_SETTL_TO == TIMERULEH.RULE_ID
Rule for Determining the Next Billing Date
  • Client
  • Rule for Determining the Next Billing Date
  • CRMS4_SERV_H_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_H_SEARCH.RULE_BILL_DATE == TIMERULEH.RULE_ID
Rule for Determining Dates from
  • Client
  • Rule for Determining Dates from
  • CRMS4_SERV_H_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_H_SEARCH.RULE_DATE_FROM == TIMERULEH.RULE_ID
Rule for Determining Dates To
  • Client
  • Rule for Determining Dates To
  • CRMS4_SERV_H_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_H_SEARCH.RULE_DATE_TO == TIMERULEH.RULE_ID
Rule for Determining Billing Plan End Date
  • Rule for Determining Billing Plan End Date
  • Client
  • CRMS4_SERV_H_SEARCH.RULE_END_DATE == TIMERULEH.RULE_ID
  • CRMS4_SERV_H_SEARCH.MANDT == TIMERULEH.CLIENT
Rule for Determining Horizon in Billing Plan
  • Client
  • Rule for Determining Horizon in Billing Plan
  • CRMS4_SERV_H_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_H_SEARCH.RULE_HORIZON == TIMERULEH.RULE_ID
Rule for Determining Next Billing Document Creation Date
  • Client
  • Rule for Determining Next Billing Document Creation Date
  • CRMS4_SERV_H_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_H_SEARCH.RULE_INVCR_DATE == TIMERULEH.RULE_ID
Rule for Determining the Period Date
  • Client
  • Rule for Determining the Period Date
  • CRMS4_SERV_H_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_H_SEARCH.RULE_PERIOD_DATE == TIMERULEH.RULE_ID
Rule Reqested Delivery Date Header
  • Client
  • Rule Reqested Delivery Date Header
  • CRMS4_SERV_H_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_H_SEARCH.RULE_REQ_DATE_H == TIMERULEH.RULE_ID
Rule for Determining Start of Settlement Period
  • Rule for Determining Start of Settlement Period
  • Client
  • CRMS4_SERV_H_SEARCH.RULE_SETTL_FROM == TIMERULEH.RULE_ID
  • CRMS4_SERV_H_SEARCH.MANDT == TIMERULEH.CLIENT
Rule for Determining End of Settlement Period
  • Client
  • Rule for Determining End of Settlement Period
  • CRMS4_SERV_H_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_H_SEARCH.RULE_SETTL_TO == TIMERULEH.RULE_ID
Rule for Determining Billing Plan Start Date
  • Client
  • Rule for Determining Billing Plan Start Date
  • CRMS4_SERV_H_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_H_SEARCH.RULE_START_DATE == TIMERULEH.RULE_ID
Rule for Origin of Next Fixed Value Date
  • Client
  • Rule for Origin of Next Fixed Value Date
  • CRMS4_SERV_H_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_H_SEARCH.RULE_VALUE_DATE == TIMERULEH.RULE_ID