CRMS4_SERV_I_SEARCH

Service Items | view: CRMS4_SERVISRCH | Extraction: Not supported | Component: S4CRM: Reporting
Tables used: CRMS4D_MAGR_I, CRMS4D_REFOBJ, CRMS4D_SERV_I, CRMS4D_TECH_RES, SIT_INST, SIT_INST_QUEUE, SIT_INST_QUEUE, CRMS4C_STAT_LC_T, CRMC_PROC_TYPE, CRMC_PROC_TYPE_T, SCPRIOT, TFK_VT_TRTT, BUT000, SIT_DEF, SIT_T_DEF
Column Name Description
object_type FK Business Trans. Cat.
object_id Transaction ID
number_int Shortened Item Number in Document
Column Name Description
billed_value Invoice Value
released_value Released Value
net_value_man_i Total Expected Net Value Products in Document Currency
cost_amount_man Total Expected Cost Amount in Document Currency
net_value Net Value
net_price_i Net Price
tax_amount_i Tax amount in document currency
freight_i Shipment costs in document currency
gross_value_i Gross Order Value in PO Currency
net_wo_freight_i Item Net Value Exclusive Shipment
subtotal1 Subtotal 1 from pricing procedure for condition
subtotal2 Subtotal 2 from pricing procedure for condition
subtotal3 Subtotal 3 from pricing procedure for condition
subtotal4 Subtotal 4 from pricing procedure for condition
subtotal5 Subtotal 5 from pricing procedure for condition
subtotal6 Subtotal 6 from pricing procedure for condition
total_discount_i Price Determination: Condition Value
recurring_charge Periodically charged values
recurring_tax Periodically charged taxes
recurring_gross Periodically charged values including taxes
target_value Target Value
Column Name Description
gi_quantity Goods Issue Quantity
ordered_quantity Ordered Quantity
billed_quantity Invoiced Quantity
dlv_quantity Delivered Quantity
released_quantity Released Quantity
orig_order_qty CRM: Original Order Quantity (Unrounded Cumulated qty.)
order_qty CRM: Order Quantity
quantity CRM: Order Quantity
confirmed_qty CRM: Confirmed Quantity
srv_conf_time Confirmed Duration
📏 Unit of Measure in Which the Product Is Sold (process_qty_unit):
gross_weight_i Gross Weight
net_weight_i Net Weight
volume_i Volume Occupied by the Product per Volume Unit
Column Name Description
valid_from null
valid_to 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
posting_date Posting Date for a Business Transaction
Column Name Description
aprv_activated Logical Variable Show values
change_allowed Logical Variable Show values
sepa_on Indicator for SEPA-Relevant Transactions Show values
itm_usage Usage of Higher-Level Item Show values
product_kind Product Technical Type Show values
revacc_relevant_type Revenue Accounting Type 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
statistical Statistical values Show values
prc_indicator Pricing indicator Show values
credit_indicator Credit Debit Indicator Show values
rec_main_itm_cum Cumulation of recurring charges on main item level Show values
cash_disc Specifies Whether a Cash Discount Can Be Given for the Prod. Show values
probability Order Probability Show values
date_qty_fixed Fixed Date and Quantity Show values
dispo_flg Relevant for Resource Planning Show values
confirm_relevant Relevant for Confirmation 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
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 Billing Release Status Show values
stat_cancelled Cancellation Status Show values
stat_open Status "Open" Show values
stat_chklst_exec Execution Status of Checklist Item Show values
stat_activation Activation Status of Subscription Order/Contract Show values
stat_cont_ts Status of Contract Time Slice Show values
stat_accepted Acceptance Status Show values
template_type Template Type of CRM Transaction Show values
archiving_flag Indicator Whether the Business Transaction Can Be Archived Show values
prod_sel_type Product Selection Type Show values
a3seltype Product Selection Type Show values
sc_author_info SC: Author Inform. Show values
sc_opt_indicator Solution Configurator Optional/Mandatory Indicator Show values
exist_vckey Indicator Variant Key Available for Item Show values
root_config Root Configuration Indicator Show values
Column Name Description Domain name
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
chkl_step_group Checklist Step Group GUID CHKLST_STEP_GRP_GUID
chkl_step_no Checklist Step Number CHKLST_STEP_NO
chkl_option_id Checklist Option ID CRM_CHKLST_OPTION
chkl_prev_group Checklist Previous Group GUID CHKLST_PREV_GRP_GUID
chkl_prev_no Checklist Previous Group Number CHKLST_PREV_GRP_NO
chkl_trigger_id Checklist Trigger ID CRM_CHKLST_TRIGID
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
cont_start_ts Start of Contract Time Slice DEC15
cont_end_ts End of Contract Time Slice DEC15
item_guid GUID of a CRM Order Object SYSUUID
GUID GUID of a CRM Order Object SYSUUID
created_at_i Created At TZNTSTMPS
created_at Created At TZNTSTMPS
created_by_i User that Created the Transaction UNAME
created_by User that Created the Transaction UNAME
changed_at_i Changed At TZNTSTMPS
changed_at Changed At TZNTSTMPS
changed_by_i Transaction Last Changed By UNAME
changed_by Transaction Last Changed By UNAME
header_guid GUID of a CRM Order Object SYSUUID
item_guid_char 32 Character CRM Object GUID (Converted)
sit_num_itm Number of Situations INT4
refobj_functional_location_id Functional Location TPLNR
refobj_serial_number Serial Number GERNR
parent GUID of a CRM Order Object SYSUUID
alternative GUID of a CRM Order Object SYSUUID
product Internal Unique ID of Product SYSUUID
ordered_prod Product Name Entered CRM_ORDERED_PROD
partner_prod Product Number of Business Partner PRSHTEXT40
description Product Description CRM_PRSHTEXT40_DB
description_uc null
itm_language Short Text Language for an Item SYLANGU
number_ext External Item Number
order_date Posting Date BCOS_TSTMP
revacc_refid Revenue Accounting Reference ID
revacc_reftype Revenue Accounting Reference Type
lead_tr_obj_id ID of Technical Resource CRM_TC_TECH_RES_ID
tr_type Type of Identification VTTRT_KK
tr_type_desc Text Field TEXT50
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
enterprise_service_org Enterprise Service Organization CRMS4_ENTERPRISE_SERVICE_ORG
sales_org_sd Sales Organization VKORG
sales_office_sd Sales office VKBUR
sales_group_sd Sales group VKGRP
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
exchg_rate Exchange Rate CRM_EXCHG_RATE
vat_reg_no Sales tax registration number
netpr_pric_unit Condition Pricing Unit PRC_CONDITION_PRICING_UNIT
rec_duration Duration of a recurrence period TIMEDURA
price_product Pricing Reference Product Globally Unique Identifier SYSUUID
process_qty_num Numerator (factor) for conversion trans. quantity in BME CRM_PROCESS_QTY_NUM
process_qty_den Denominator (factor) for conversion trans. quantity in BME CRM_PROCESS_QTY_DEN
exponent10 10 Exponent for Quantity Conversion CRM_EXPONENT10
comm_group Commission Group CRM_COMM_GROUP
rebate_group Volume Rebate Group CRM_REBATE_GROUP
prod_hierarchy Product Category COM_CATEGORY_ID
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
latest_conf_date Latest Confirmation Date for an Item BCOS_TSTMP
dlv_group_date Delivery Group Date BCOS_TSTMP
latest_req_date Latest Requested Date for an Item BCOS_TSTMP
first_req_date First Requested Delivery Date for an Item BCOS_TSTMP
first_conf_date First Confirmed Delivery Date for Item BCOS_TSTMP
service_type Service Type CRMT_SERVICE_TYPE
valuation_type Valuation Type CRMT_VALUATION_TYPE
srv_escal Response Profile CRM_SRV_ESCAL
srv_serwi Service Profile CRM_SRV_SERWI
srv_rule_id Internal Identification of Rules of Periodic Appointments TEXT25
srcl_service_profile Processing Times: Service Profile CRM_SRV_SERWI
srcl_response_profile Processing Time: Response Profile CRM_SRCL_RSPRF
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
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_open_desc Short Text for Fixed Values DDTEXT
stat_chklst_exec_desc Short Text for Fixed Values DDTEXT
stat_activation_desc Short Text for Fixed Values DDTEXT
stat_cont_ts_desc Short Text for Fixed Values DDTEXT
stat_accepted_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
priority_txt Description TEXT40
process_type_txt Description (20 Characters) TEXT20
description_h Transaction Description CRM_PROCESS_DESCRIPTION
created_at_h Created At (Output in User Time Zone) COM_TSTMP
created_by_h User that Created the Transaction UNAME
changed_at_h Changed At (Output in User Time Zone) COM_TSTMP
changed_by_h Transaction Last Changed By UNAME
item_no_appt Shortened Item Number in Document CRMS4_NUMBER_INT
item_no_partner Shortened Item Number in Document CRMS4_NUMBER_INT
item_no_qualif Shortened Item Number in Document CRMS4_NUMBER_INT
item_no_refobj Shortened Item Number in Document CRMS4_NUMBER_INT
item_no_subject Shortened Item Number in Document CRMS4_NUMBER_INT
item_no_survey Shortened Item Number in Document CRMS4_NUMBER_INT
ci_contract_id IS-T Contract Number IST_EXT_REF
a3extref IS-T Contract Number IST_EXT_REF
ci_contract_item Contract Item Identifier SYSUUID
btmf_process Process of Maint. FW IST_PROCESS
btmf_process_type Process Type IST_ITEM_PROCESS
sc_group Sol. Conf. Group IST_SC_GROUP
sc_doc_guid SC: Doc. GUID IST_SC_DOCUMENT_ID
sc_interlinkage_guid Internal, Unique ID of a Relationship SYSUUID
ccm_version Version CRM_IST_CCM_VERSION
pool_agr_ref Reference to Sharing Contract IST_EXT_REF
int_obj_no Configuration (Internal Object Number) IB_INSTANCE
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
ma_head_objid Transaction ID CRM_OBJECT_ID
ma_prod_id Custom Specific ID for Product or Product Range CRMT_ISX_PRVMA_PROD_ID
ma_number_int Shortened Item Number in Document CRMS4_NUMBER_INT
Master Data Relations | to Other Relations ↓ Join Conditions
Accounting Indicator
  • Accounting Indicator
  • Client
  • CRMS4_SERV_I_SEARCH.AC_INDICATOR == TBMOT.BEMOT
  • CRMS4_SERV_I_SEARCH.MANDT == TBMOT.MANDT
Object Type for Settlement Account Assignment
  • Client
  • Object Type for Settlement Account Assignment
Approval Procedure
  • Client
  • Approval Procedure
Authorization Scope
  • ?
  • Client
  • Authorization Scope
Base Unit of Measure of Product
  • Client
  • Base Unit of Measure of Product
  • CRMS4_SERV_I_SEARCH.MANDT == T006.MANDT
  • CRMS4_SERV_I_SEARCH.BASE_QTY_UNIT == T006.MSEHI
Business Partner: Billing Block Reason
  • Client
  • Business Partner: Billing Block Reason
  • CRMS4_SERV_I_SEARCH.MANDT == TVFS.MANDT
  • CRMS4_SERV_I_SEARCH.BILLING_BLOCK == TVFS.FAKSP
Time Zone of Billing Plan Set
  • Time Zone of Billing Plan Set
  • Client
  • CRMS4_SERV_I_SEARCH.BILLING_TIMEZONE == TTZZ.TZONE
  • CRMS4_SERV_I_SEARCH.MANDT == TTZZ.CLIENT
Time Zone of Billing Plan Set
  • Client
  • Time Zone of Billing Plan Set
  • CRMS4_SERV_I_SEARCH.MANDT == TTZZ.CLIENT
  • CRMS4_SERV_I_SEARCH.BILLPLAN_D_TIMEZONE == TTZZ.TZONE
ID of Billing Plan Line
  • ID of Billing Plan Line
  • Client
  • Billing Plan Type
Time Zone of Billing Plan Set
  • Client
  • Time Zone of Billing Plan Set
  • CRMS4_SERV_I_SEARCH.MANDT == TTZZ.CLIENT
  • CRMS4_SERV_I_SEARCH.BILLPLAN_TIMEZONE == TTZZ.TZONE
Billing Plan Type
  • Client
  • Billing Plan Type
Bill-To Party
  • Bill-To Party
  • Client
  • CRMS4_SERV_I_SEARCH.BILL_TO_PARTY == BUT000.PARTNER
  • CRMS4_SERV_I_SEARCH.MANDT == BUT000.CLIENT
CRM Business Transaction Classification
  • ?
  • CRM Business Transaction Classification
Cancelling Party
  • Client
  • Cancelling Party
  • CRMS4_SERV_I_SEARCH.MANDT == CRMC_PARTY.CLIENT
  • CRMS4_SERV_I_SEARCH.CANCPARTY == CRMC_PARTY.CANC_PARTY
Cancellation Procedure
  • Client
  • Cancellation Procedure
CRM Service : Reason for Cancellation
  • Client
  • CRM Service : Reason for Cancellation
Checklist Step ID
  • Client
  • Checklist Step ID
  • Checklist Step ID
Checklist Step ID
  • Client
  • Checklist Step ID
  • Checklist Step ID
Billing Cycle
  • Billing Cycle
  • Client
  • CRMS4_SERV_I_SEARCH.CI_BILLING_CYCLE == TFK2607.CYCLE
  • CRMS4_SERV_I_SEARCH.MANDT == TFK2607.MANDT
Customer Contact Person
  • Client
  • Customer Contact Person
  • CRMS4_SERV_I_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_I_SEARCH.CONTACT_PERSON == BUT000.PARTNER
Contract Account Number
  • Client
  • Contract Account Number
  • CRMS4_SERV_I_SEARCH.MANDT == FKKVK.MANDT
  • CRMS4_SERV_I_SEARCH.CONTRACT_ACCOUNT == FKKVK.VKONT
Currency
  • Client
  • Currency
  • CRMS4_SERV_I_SEARCH.MANDT == TCURC.MANDT
  • CRMS4_SERV_I_SEARCH.CURRENCY == TCURC.WAERS
Business Partner Type
  • Client
  • Business Partner Type
  • CRMS4_SERV_I_SEARCH.MANDT == TB004.CLIENT
  • CRMS4_SERV_I_SEARCH.CUSTOMER_TYPE == TB004.BPKIND
Customer Group
  • Client
  • Customer Group
  • CRMS4_SERV_I_SEARCH.MANDT == T151.MANDT
  • CRMS4_SERV_I_SEARCH.CUST_GROUP == T151.KDGRP
Customer Group 1
  • Client
  • Customer Group 1
  • CRMS4_SERV_I_SEARCH.MANDT == TVV1.MANDT
  • CRMS4_SERV_I_SEARCH.CUST_GROUP1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • CRMS4_SERV_I_SEARCH.MANDT == TVV2.MANDT
  • CRMS4_SERV_I_SEARCH.CUST_GROUP2 == TVV2.KVGR2
Customer Group 3
  • Client
  • Customer Group 3
  • CRMS4_SERV_I_SEARCH.MANDT == TVV3.MANDT
  • CRMS4_SERV_I_SEARCH.CUST_GROUP3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • CRMS4_SERV_I_SEARCH.MANDT == TVV4.MANDT
  • CRMS4_SERV_I_SEARCH.CUST_GROUP4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • CRMS4_SERV_I_SEARCH.MANDT == TVV5.MANDT
  • CRMS4_SERV_I_SEARCH.CUST_GROUP5 == TVV5.KVGR5
Customer Pricing Procedure
  • Client
  • Customer Pricing Procedure
  • CRMS4_SERV_I_SEARCH.MANDT == TVKD.MANDT
  • CRMS4_SERV_I_SEARCH.CUST_PRIC_PROC == TVKD.KALKS
Business Partner: Delivery Block Reason
  • Client
  • Business Partner: Delivery Block Reason
  • CRMS4_SERV_I_SEARCH.MANDT == TVLS.MANDT
  • CRMS4_SERV_I_SEARCH.DELIVERY_BLOCK == TVLS.LIFSP
Language Key of Description CRMS4_SERV_I_SEARCH.DESCR_LANGUAGE == T002.SPRAS
Distribution Channel
  • Client
  • Distribution Channel
  • CRMS4_SERV_I_SEARCH.MANDT == TVTW.MANDT
  • CRMS4_SERV_I_SEARCH.DIS_CHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • CRMS4_SERV_I_SEARCH.MANDT == TSPA.MANDT
  • CRMS4_SERV_I_SEARCH.DIVISION == TSPA.SPART
Delivery Priority
  • Client
  • Delivery Priority
  • CRMS4_SERV_I_SEARCH.MANDT == TPRIO.MANDT
  • CRMS4_SERV_I_SEARCH.DLV_PRIO == TPRIO.LPRIO
Equipment Number
  • Client
  • Equipment Number
  • Equipment Number
  • CRMS4_SERV_I_SEARCH.MANDT == EQUI.MANDT
  • CRMS4_SERV_I_SEARCH.EQUIPMENT_ID == EQUI.EQUNR
  • CRMS4_SERV_I_SEARCH.REFOBJ_EQUIPMENT_ID == EQUI.EQUNR
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • CRMS4_SERV_I_SEARCH.MANDT == TCURV.MANDT
  • CRMS4_SERV_I_SEARCH.EXCHG_TYPE == TCURV.KURST
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • CRMS4_SERV_I_SEARCH.MANDT == TINC.MANDT
  • CRMS4_SERV_I_SEARCH.INCOTERMS1 == TINC.INCO1
Industry Sector
  • Client
  • Industry Sector
  • CRMS4_SERV_I_SEARCH.MANDT == T016.MANDT
  • CRMS4_SERV_I_SEARCH.INDUSTRY == T016.BRSCH
Item Category
  • Client
  • Item Category
Item Category Usage
  • Client
  • Item Category Usage
Date type
  • Client
  • Date type
  • CRMS4_SERV_I_SEARCH.MANDT == SCAPPTTYPE.CLIENT
  • CRMS4_SERV_I_SEARCH.KIND_BILL_DATE == SCAPPTTYPE.APPT_TYPE
Date type
  • Client
  • Date type
  • CRMS4_SERV_I_SEARCH.MANDT == SCAPPTTYPE.CLIENT
  • CRMS4_SERV_I_SEARCH.KIND_DATE_FROM == SCAPPTTYPE.APPT_TYPE
Date type
  • Client
  • Date type
  • CRMS4_SERV_I_SEARCH.MANDT == SCAPPTTYPE.CLIENT
  • CRMS4_SERV_I_SEARCH.KIND_DATE_TO == SCAPPTTYPE.APPT_TYPE
Date type
  • Client
  • Date type
  • CRMS4_SERV_I_SEARCH.MANDT == SCAPPTTYPE.CLIENT
  • CRMS4_SERV_I_SEARCH.KIND_END_DATE == SCAPPTTYPE.APPT_TYPE
Date type
  • Client
  • Date type
  • CRMS4_SERV_I_SEARCH.MANDT == SCAPPTTYPE.CLIENT
  • CRMS4_SERV_I_SEARCH.KIND_INVCR_DATE == SCAPPTTYPE.APPT_TYPE
Date type
  • Client
  • Date type
  • CRMS4_SERV_I_SEARCH.MANDT == SCAPPTTYPE.CLIENT
  • CRMS4_SERV_I_SEARCH.KIND_PERIOD_DATE == SCAPPTTYPE.APPT_TYPE
Date type
  • Client
  • Date type
  • CRMS4_SERV_I_SEARCH.MANDT == SCAPPTTYPE.CLIENT
  • CRMS4_SERV_I_SEARCH.KIND_SETTL_FROM == SCAPPTTYPE.APPT_TYPE
Date type
  • Client
  • Date type
  • CRMS4_SERV_I_SEARCH.MANDT == SCAPPTTYPE.CLIENT
  • CRMS4_SERV_I_SEARCH.KIND_SETTL_TO == SCAPPTTYPE.APPT_TYPE
Date type
  • Client
  • Date type
  • CRMS4_SERV_I_SEARCH.MANDT == SCAPPTTYPE.CLIENT
  • CRMS4_SERV_I_SEARCH.KIND_START_DATE == SCAPPTTYPE.APPT_TYPE
Date type
  • Client
  • Date type
  • CRMS4_SERV_I_SEARCH.MANDT == SCAPPTTYPE.CLIENT
  • CRMS4_SERV_I_SEARCH.KIND_VALUE_DATE == SCAPPTTYPE.APPT_TYPE
Condition Unit
  • Client
  • Condition Unit
  • CRMS4_SERV_I_SEARCH.MANDT == T006.MANDT
  • CRMS4_SERV_I_SEARCH.NETPR_UOM == T006.MSEHI
Business Trans. Cat. CRMS4_SERV_I_SEARCH.OBJECT_TYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
CRM Item Object Type CRMS4_SERV_I_SEARCH.OBJTYPE_I == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Payer
  • Client
  • Payer
  • CRMS4_SERV_I_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_I_SEARCH.PAYER == BUT000.PARTNER
Employee Responsible
  • Client
  • Employee Responsible
  • CRMS4_SERV_I_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_I_SEARCH.PERSON_RESP == BUT000.PARTNER
Terms of Payment
  • ?
  • Client
  • Terms of Payment
  • CRMS4_SERV_I_SEARCH.[column in domain "DZTAGG_052"] == T052.ZTAGG
  • CRMS4_SERV_I_SEARCH.MANDT == T052.MANDT
  • CRMS4_SERV_I_SEARCH.PMNTTRMS == T052.ZTERM
Material Group 1
  • Client
  • Material Group 1
  • CRMS4_SERV_I_SEARCH.MANDT == TVM1.MANDT
  • CRMS4_SERV_I_SEARCH.PRC_GROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • CRMS4_SERV_I_SEARCH.MANDT == TVM2.MANDT
  • CRMS4_SERV_I_SEARCH.PRC_GROUP2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • CRMS4_SERV_I_SEARCH.MANDT == TVM3.MANDT
  • CRMS4_SERV_I_SEARCH.PRC_GROUP3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • CRMS4_SERV_I_SEARCH.MANDT == TVM4.MANDT
  • CRMS4_SERV_I_SEARCH.PRC_GROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • CRMS4_SERV_I_SEARCH.MANDT == TVM5.MANDT
  • CRMS4_SERV_I_SEARCH.PRC_GROUP5 == TVM5.MVGR5
Customer Price Group
  • Client
  • Customer Price Group
  • CRMS4_SERV_I_SEARCH.MANDT == T188.MANDT
  • CRMS4_SERV_I_SEARCH.PRICE_GRP == T188.KONDA
Activity Priority
  • Client
  • Activity Priority
  • CRMS4_SERV_I_SEARCH.MANDT == SCPRIO.CLIENT
  • CRMS4_SERV_I_SEARCH.PRIORITY == SCPRIO.PRIORITY
Unit of Measure in Which the Product Is Sold
  • Client
  • Unit of Measure in Which the Product Is Sold
  • CRMS4_SERV_I_SEARCH.MANDT == T006.MANDT
  • CRMS4_SERV_I_SEARCH.PROCESS_QTY_UNIT == T006.MSEHI
Business Transaction Type
  • Client
  • Business Transaction Type
Material Price Group
  • Client
  • Material Price Group
  • CRMS4_SERV_I_SEARCH.MANDT == T178.MANDT
  • CRMS4_SERV_I_SEARCH.PROD_PR_GROUP == T178.KONDM
Time unit of a recurrence period
  • Client
  • Time unit of a recurrence period
  • CRMS4_SERV_I_SEARCH.MANDT == TIMECUUT.CLIENT
  • CRMS4_SERV_I_SEARCH.REC_TIME_UNIT == TIMECUUT.NAME_UNIT
Equipment Number
  • Client
  • Equipment Number
  • Equipment Number
  • CRMS4_SERV_I_SEARCH.MANDT == EQUI.MANDT
  • CRMS4_SERV_I_SEARCH.EQUIPMENT_ID == EQUI.EQUNR
  • CRMS4_SERV_I_SEARCH.REFOBJ_EQUIPMENT_ID == EQUI.EQUNR
Material Number
  • Client
  • Material Number
  • CRMS4_SERV_I_SEARCH.MANDT == MARA.MANDT
  • CRMS4_SERV_I_SEARCH.REFOBJ_PRODUCT_ID == MARA.MATNR
Reference Currency
  • Client
  • Reference Currency
  • CRMS4_SERV_I_SEARCH.MANDT == TCURC.MANDT
  • CRMS4_SERV_I_SEARCH.REF_CURRENCY == TCURC.WAERS
Region (State, Province, County)
  • ?
  • Client
  • Region (State, Province, County)
  • CRMS4_SERV_I_SEARCH.[column in domain "LAND1"] == T005S.LAND1
  • CRMS4_SERV_I_SEARCH.MANDT == T005S.MANDT
  • CRMS4_SERV_I_SEARCH.REGION == T005S.BLAND
Cancellation Reason Code
  • Client
  • Cancellation Reason Code
  • CRMS4_SERV_I_SEARCH.MANDT == TVAG.MANDT
  • CRMS4_SERV_I_SEARCH.REJECTION == TVAG.ABGRU
Responsible Group
  • Client
  • Responsible Group
  • CRMS4_SERV_I_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_I_SEARCH.RESP_GROUP == BUT000.PARTNER
Executing Service Employee
  • Client
  • Executing Service Employee
  • CRMS4_SERV_I_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_I_SEARCH.SERVICE_EMPLOYEE == BUT000.PARTNER
Service Team
  • Client
  • Service Team
  • CRMS4_SERV_I_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_I_SEARCH.SERVICE_TEAM == BUT000.PARTNER
Shipping Conditions
  • Client
  • Shipping Conditions
  • CRMS4_SERV_I_SEARCH.MANDT == TVSB.MANDT
  • CRMS4_SERV_I_SEARCH.SHIP_COND == TVSB.VSBED
Ship-To Party
  • Client
  • Ship-To Party
  • CRMS4_SERV_I_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_I_SEARCH.SHIP_TO_PARTY == BUT000.PARTNER
Country/Region
  • Client
  • Country/Region
  • CRMS4_SERV_I_SEARCH.MANDT == T005.MANDT
  • CRMS4_SERV_I_SEARCH.SOLD_TO_COUNTRY == T005.LAND1
Sold-To Party
  • Client
  • Sold-To Party
  • CRMS4_SERV_I_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_SERV_I_SEARCH.SOLD_TO_PARTY == BUT000.PARTNER
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Country/Region
  • CRMS4_SERV_I_SEARCH.MANDT == T005S.MANDT
  • CRMS4_SERV_I_SEARCH.SOLD_TO_REGION == T005S.BLAND
  • CRMS4_SERV_I_SEARCH.SOLD_TO_COUNTRY == T005S.LAND1
Tax Jurisdiction Code (Structure for tax calculation)
  • ?
  • Client
  • Tax Jurisdiction Code (Structure for tax calculation)
  • CRMS4_SERV_I_SEARCH.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • CRMS4_SERV_I_SEARCH.MANDT == TTXJ.MANDT
  • CRMS4_SERV_I_SEARCH.TAXJURCODE == TTXJ.TXJCD
Tax Destination Country/Region
  • Client
  • Tax Destination Country/Region
  • CRMS4_SERV_I_SEARCH.MANDT == T005.MANDT
  • CRMS4_SERV_I_SEARCH.TAX_DEST_CTY == T005.LAND1
Region (State, Province, County)
  • Client
  • Tax Destination Country/Region
  • Region (State, Province, County)
  • CRMS4_SERV_I_SEARCH.MANDT == T005S.MANDT
  • CRMS4_SERV_I_SEARCH.TAX_DEST_CTY == T005S.LAND1
  • CRMS4_SERV_I_SEARCH.TAX_DEST_REG == T005S.BLAND
Usage Indicator
  • Client
  • Usage Indicator
  • CRMS4_SERV_I_SEARCH.MANDT == TVLV.MANDT
  • CRMS4_SERV_I_SEARCH.USAGE_TYPE == TVLV.ABRVW
Unit for the Volume of a Product
  • Client
  • Unit for the Volume of a Product
  • CRMS4_SERV_I_SEARCH.MANDT == T006.MANDT
  • CRMS4_SERV_I_SEARCH.VOLUME_UNIT_I == T006.MSEHI
Weight Unit
  • Client
  • Weight Unit
  • CRMS4_SERV_I_SEARCH.MANDT == T006.MANDT
  • CRMS4_SERV_I_SEARCH.WEIGHT_UNIT_I == 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_I_SEARCH.BILLPLAN_D_RULE_BILL_DATE == TIMERULEH.RULE_ID
  • CRMS4_SERV_I_SEARCH.MANDT == TIMERULEH.CLIENT
Rule for Determining Next Billing Document Creation Date
  • Client
  • Rule for Determining Next Billing Document Creation Date
  • CRMS4_SERV_I_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_I_SEARCH.BILLPLAN_D_RULE_INVCR_DATE == TIMERULEH.RULE_ID
Rule for Determining the Period Date
  • Client
  • Rule for Determining the Period Date
  • CRMS4_SERV_I_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_I_SEARCH.BILLPLAN_D_RULE_PERIOD_DATE == TIMERULEH.RULE_ID
Rule for Determining Start of Settlement Period
  • Rule for Determining Start of Settlement Period
  • Client
  • CRMS4_SERV_I_SEARCH.BILLPLAN_D_RULE_SETTL_FROM == TIMERULEH.RULE_ID
  • CRMS4_SERV_I_SEARCH.MANDT == TIMERULEH.CLIENT
Rule for Determining End of Settlement Period
  • Client
  • Rule for Determining End of Settlement Period
  • CRMS4_SERV_I_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_I_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_I_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_I_SEARCH.RULE_BILL_DATE == TIMERULEH.RULE_ID
Rule for Determining Dates from
  • Client
  • Rule for Determining Dates from
  • CRMS4_SERV_I_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_I_SEARCH.RULE_DATE_FROM == TIMERULEH.RULE_ID
Rule for Determining Dates To
  • Client
  • Rule for Determining Dates To
  • CRMS4_SERV_I_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_I_SEARCH.RULE_DATE_TO == TIMERULEH.RULE_ID
Rule for Determining Billing Plan End Date
  • Client
  • Rule for Determining Billing Plan End Date
  • CRMS4_SERV_I_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_I_SEARCH.RULE_END_DATE == TIMERULEH.RULE_ID
Rule for Determining Horizon in Billing Plan
  • Client
  • Rule for Determining Horizon in Billing Plan
  • CRMS4_SERV_I_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_I_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_I_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_I_SEARCH.RULE_INVCR_DATE == TIMERULEH.RULE_ID
Rule for Determining the Period Date
  • Client
  • Rule for Determining the Period Date
  • CRMS4_SERV_I_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_I_SEARCH.RULE_PERIOD_DATE == TIMERULEH.RULE_ID
Rule for Determining Start of Settlement Period
  • Client
  • Rule for Determining Start of Settlement Period
  • CRMS4_SERV_I_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_I_SEARCH.RULE_SETTL_FROM == TIMERULEH.RULE_ID
Rule for Determining End of Settlement Period
  • Client
  • Rule for Determining End of Settlement Period
  • CRMS4_SERV_I_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_I_SEARCH.RULE_SETTL_TO == TIMERULEH.RULE_ID
Rule for Determining Billing Plan Start Date
  • Client
  • Rule for Determining Billing Plan Start Date
  • CRMS4_SERV_I_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_I_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_I_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_SERV_I_SEARCH.RULE_VALUE_DATE == TIMERULEH.RULE_ID