CRMS4_OPPT_SEARCH

Opportunity/Lead Search | view: CRMS4_OPPTSEARCH | Extraction: Not supported | Component: S4CRM: Reporting
Tables used: CRMD_BRELVONAE, CRMS4D_OPPT_H, CRMS4D_OPPT_H, CRMS4D_OPPT_I, SKWG_BREL, CRMC_SOURCE_T, CRMC_LEAD_TYPE_T, CRMS4C_STAT_LC_T, CRMC_AUI_STAT_T, SCPRIOT, CRMC_PROC_TYPE, CRMC_PROC_TYPE_T, BUT000, MAKT
Column Name Description
object_type FK Business Trans. Cat.
object_id Transaction ID
number_int Shortened Item Number in Document
Column Name Description
💲 Currency (currency):
gross_value_h Total Gross Value of Document in Document Currency
net_value_h 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
exp_revenue Expected Sales Revenue
budget_bp Budget Prospect
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
lead_end null
lead_start null
valid_to Expected Closing Date
valid_from Opportunity Start Date
startdate Opportunity Start Date
expect_end Expected Closing Date
phase_since Sales Stage Since
status_since Status Since
posting_date Posting Date for a Business Transaction
created_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
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
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
stat_lifecycle Life Cycle Status Show values
stat_lifecycle_oppt Opportunity Lifecycle Status Show values
stat_error Error Status Show values
stat_archivable Archivable Show values
stat_archived Archived Show values
stat_duplicate Duplicate Show values
Column Name Description Domain name
number_ext External Item Number
item_guid GUID of a CRM Order Object SYSUUID
ac_assignment Settlement Account Assignment CRMT_AC_ASSIGN
ac_percentage Percentage of Costs to Be Distributed DEC3_2
number_items Number of items in an order
lead_id Transaction ID CRM_OBJECT_ID
lead_des Transaction Description CRM_PROCESS_DESCRIPTION
lead_guid GUID of a CRM Order Object SYSUUID
qual_level_svy Questionnaire that Q-Level Sets (Automatically) CHAR32
sys_probability Chance of Success of Opportunity - Calculated by System CRM_SYSTEM_PROBABILITY
header_guid GUID of a CRM Order Object SYSUUID
guid GUID of a CRM Order Object SYSUUID
process_type_txt Description (20 Characters) TEXT20
description Transaction Description CRM_PROCESS_DESCRIPTION
description_uc null
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
CREATED_AT Created At (Output in User Time Zone) COM_TSTMP
CREATED_BY User that Created the Transaction UNAME
CHANGED_AT Changed At (Output in User Time Zone) COM_TSTMP
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_rep_list null
sales_prospect_list null
payer_list null
person_resp_list null
contact_person_list null
competitor_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
stat_lifecycle_desc Short Text for Fixed Values DDTEXT
stat_lifecycle_oppt_desc Short Text for Fixed Values DDTEXT
stat_error_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_duplicate_desc Short Text for Fixed Values DDTEXT
prod_hierarchy Product Category COM_CATEGORY_ID
ordered_prod Product Name Entered CRM_ORDERED_PROD
product Product Name Entered CRM_ORDERED_PROD
product_id Product Name Entered CRM_ORDERED_PROD
Master Data Relations Join Conditions
Accounting Indicator
  • Client
  • Accounting Indicator
  • CRMS4_OPPT_SEARCH.MANDT == TBMOT.MANDT
  • CRMS4_OPPT_SEARCH.AC_INDICATOR == TBMOT.BEMOT
Object Type for Settlement Account Assignment
  • Object Type for Settlement Account Assignment
  • Client
Authorization Scope
  • Client
  • ?
  • Authorization Scope
CRM Business Transaction Classification
  • CRM Business Transaction Classification
  • ?
Competitor
  • Client
  • Competitor
  • CRMS4_OPPT_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_OPPT_SEARCH.COMPETITOR == BUT000.PARTNER
Customer Contact Person
  • Client
  • Customer Contact Person
  • CRMS4_OPPT_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_OPPT_SEARCH.CONTACT_PERSON == BUT000.PARTNER
Currency
  • Currency
  • Client
  • CRMS4_OPPT_SEARCH.CURRENCY == TCURC.WAERS
  • CRMS4_OPPT_SEARCH.MANDT == TCURC.MANDT
Sales Stage
  • Client
  • Sales Stage
Business Partner Type
  • Client
  • Business Partner Type
  • CRMS4_OPPT_SEARCH.MANDT == TB004.CLIENT
  • CRMS4_OPPT_SEARCH.CUSTOMER_TYPE == TB004.BPKIND
Customer Group
  • Client
  • Customer Group
  • CRMS4_OPPT_SEARCH.MANDT == T151.MANDT
  • CRMS4_OPPT_SEARCH.CUST_GROUP == T151.KDGRP
Customer Group 1
  • Client
  • Customer Group 1
  • CRMS4_OPPT_SEARCH.MANDT == TVV1.MANDT
  • CRMS4_OPPT_SEARCH.CUST_GROUP1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • CRMS4_OPPT_SEARCH.MANDT == TVV2.MANDT
  • CRMS4_OPPT_SEARCH.CUST_GROUP2 == TVV2.KVGR2
Customer Group 3
  • Customer Group 3
  • Client
  • CRMS4_OPPT_SEARCH.CUST_GROUP3 == TVV3.KVGR3
  • CRMS4_OPPT_SEARCH.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • CRMS4_OPPT_SEARCH.CUST_GROUP4 == TVV4.KVGR4
  • CRMS4_OPPT_SEARCH.MANDT == TVV4.MANDT
Customer Group 5
  • Client
  • Customer Group 5
  • CRMS4_OPPT_SEARCH.MANDT == TVV5.MANDT
  • CRMS4_OPPT_SEARCH.CUST_GROUP5 == TVV5.KVGR5
Customer Pricing Procedure
  • Client
  • Customer Pricing Procedure
  • CRMS4_OPPT_SEARCH.MANDT == TVKD.MANDT
  • CRMS4_OPPT_SEARCH.CUST_PRIC_PROC == TVKD.KALKS
Language Key of Description CRMS4_OPPT_SEARCH.DESCR_LANGUAGE == T002.SPRAS
Distribution Channel
  • Distribution Channel
  • Client
  • CRMS4_OPPT_SEARCH.DIS_CHANNEL == TVTW.VTWEG
  • CRMS4_OPPT_SEARCH.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • CRMS4_OPPT_SEARCH.MANDT == TSPA.MANDT
  • CRMS4_OPPT_SEARCH.DIVISION == TSPA.SPART
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • CRMS4_OPPT_SEARCH.EXCHG_TYPE == TCURV.KURST
  • CRMS4_OPPT_SEARCH.MANDT == TCURV.MANDT
Industry Sector
  • Industry Sector
  • Client
  • CRMS4_OPPT_SEARCH.INDUSTRY == T016.BRSCH
  • CRMS4_OPPT_SEARCH.MANDT == T016.MANDT
Item Category
  • Client
  • Item Category
Business Trans. Cat.
  • Business Trans. Cat.
  • Business Trans. Cat.
Lead Group
  • Client
  • Lead Group
Business Trans. Cat.
  • Business Trans. Cat.
  • Business Trans. Cat.
Payer
  • Client
  • Payer
  • CRMS4_OPPT_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_OPPT_SEARCH.PAYER == BUT000.PARTNER
Employee Responsible
  • Client
  • Employee Responsible
  • CRMS4_OPPT_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_OPPT_SEARCH.PERSON_RESP == BUT000.PARTNER
Terms of Payment
  • Terms of Payment
  • Client
  • ?
  • CRMS4_OPPT_SEARCH.PMNTTRMS == T052.ZTERM
  • CRMS4_OPPT_SEARCH.MANDT == T052.MANDT
  • CRMS4_OPPT_SEARCH.[column in domain "DZTAGG_052"] == T052.ZTAGG
Customer Price Group
  • Client
  • Customer Price Group
  • CRMS4_OPPT_SEARCH.MANDT == T188.MANDT
  • CRMS4_OPPT_SEARCH.PRICE_GRP == T188.KONDA
Business Transaction Type
  • Client
  • Business Transaction Type
Lead Qualification Level (Automatic)
  • Lead Qualification Level (Automatic)
  • Client
Lead Qualification Level
  • Lead Qualification Level
  • Client
Reference Currency
  • Client
  • Reference Currency
  • CRMS4_OPPT_SEARCH.MANDT == TCURC.MANDT
  • CRMS4_OPPT_SEARCH.REF_CURRENCY == TCURC.WAERS
Region (State, Province, County)
  • Region (State, Province, County)
  • Client
  • ?
  • CRMS4_OPPT_SEARCH.REGION == T005S.BLAND
  • CRMS4_OPPT_SEARCH.MANDT == T005S.MANDT
  • CRMS4_OPPT_SEARCH.[column in domain "LAND1"] == T005S.LAND1
Cancellation Reason Code
  • Client
  • Cancellation Reason Code
  • CRMS4_OPPT_SEARCH.MANDT == TVAG.MANDT
  • CRMS4_OPPT_SEARCH.REJECTION == TVAG.ABGRU
Time Zone Requested Delivery Date Header
  • Client
  • Time Zone Requested Delivery Date Header
  • CRMS4_OPPT_SEARCH.MANDT == TTZZ.CLIENT
  • CRMS4_OPPT_SEARCH.REQ_TIMEZONE_H == TTZZ.TZONE
Sales Cycle
  • Client
  • Sales Cycle
Sales Prospect
  • Client
  • Sales Prospect
  • CRMS4_OPPT_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_OPPT_SEARCH.SALES_PROSPECT == BUT000.PARTNER
Sales Rep
  • Client
  • Sales Rep
  • CRMS4_OPPT_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_OPPT_SEARCH.SALES_REP == BUT000.PARTNER
Origin of Opportunity/Lead
  • Client
  • Origin of Opportunity/Lead
Tax Jurisdiction Code (Structure for tax calculation)
  • Tax Jurisdiction Code (Structure for tax calculation)
  • Client
  • ?
  • CRMS4_OPPT_SEARCH.TAXJURCODE == TTXJ.TXJCD
  • CRMS4_OPPT_SEARCH.MANDT == TTXJ.MANDT
  • CRMS4_OPPT_SEARCH.[column in domain "TAX_KALSM"] == TTXJ.KALSM
Tax Destination Country/Region
  • Client
  • Tax Destination Country/Region
  • CRMS4_OPPT_SEARCH.MANDT == T005.MANDT
  • CRMS4_OPPT_SEARCH.TAX_DEST_CTY == T005.LAND1
Region (State, Province, County)
  • Region (State, Province, County)
  • Client
  • Tax Destination Country/Region
  • CRMS4_OPPT_SEARCH.TAX_DEST_REG == T005S.BLAND
  • CRMS4_OPPT_SEARCH.MANDT == T005S.MANDT
  • CRMS4_OPPT_SEARCH.TAX_DEST_CTY == T005S.LAND1
Opportunity Type
  • Opportunity Type
  • Client
Usage Indicator
  • Client
  • Usage Indicator
  • CRMS4_OPPT_SEARCH.MANDT == TVLV.MANDT
  • CRMS4_OPPT_SEARCH.USAGE_TYPE == TVLV.ABRVW
Unit for the Volume of a Product
  • Client
  • Unit for the Volume of a Product
  • CRMS4_OPPT_SEARCH.MANDT == T006.MANDT
  • CRMS4_OPPT_SEARCH.VOLUME_UNIT_H == T006.MSEHI
Weight Unit
  • Weight Unit
  • Client
  • CRMS4_OPPT_SEARCH.WEIGHT_UNIT_H == T006.MSEHI
  • CRMS4_OPPT_SEARCH.MANDT == T006.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Rule Reqested Delivery Date Header
  • Client
  • Rule Reqested Delivery Date Header
  • CRMS4_OPPT_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_OPPT_SEARCH.RULE_REQ_DATE_H == TIMERULEH.RULE_ID