CRMS4_OPPT_I_SEARCH

Opportunity/Lead Item | view: CRMS4_OPPTISRCH | Extraction: Not supported | Component: S4CRM: Reporting
Tables used: CRMS4D_OPPT_I, CRMS4C_STAT_LC_T, 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
net_value_man_i Total Expected Net Value Products in Document Currency
cost_amount_man Total Expected Cost Amount in Document Currency
net_value_i 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
Column Name Description
gross_weight_i Gross Weight
net_weight_i Net Weight
volume_i Volume Occupied by the Product per Volume Unit
order_qty CRM: Order Quantity
Column Name Description
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
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
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
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_open Status "Open" 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
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
item_guid GUID of a CRM Order Object SYSUUID
created_at_i Created At (Output in User Time Zone) COM_TSTMP
created_by_i User that Created the Transaction UNAME
changed_at_i Changed At (Output in User Time Zone) COM_TSTMP
changed_by_i 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
header_guid GUID of a CRM Order Object SYSUUID
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
product_name null
partner_prod Product Number of Business Partner PRSHTEXT40
description_i Product Description CRM_PRSHTEXT40_DB
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
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
netpr_pric_unit Condition Pricing Unit PRC_CONDITION_PRICING_UNIT
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_pr_group Product Group CRM_PROD_PR_GROUP
prc_group1 Product Group 1 CRM_PRC_GROUP1
prc_group2 Product Group 2 CRM_PRC_GROUP2
prc_group3 Product Group 3 CRM_PRC_GROUP3
prc_group4 Product Group 4 CRM_PRC_GROUP4
prc_group5 Product Group 5 CRM_PRC_GROUP5
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
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_open_desc Short Text for Fixed Values DDTEXT
first_req_date First Requested Delivery Date for an Item BCOS_TSTMP
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
Master Data Relations Join Conditions
Accounting Indicator
  • Client
  • Accounting Indicator
  • CRMS4_OPPT_I_SEARCH.MANDT == TBMOT.MANDT
  • CRMS4_OPPT_I_SEARCH.AC_INDICATOR == TBMOT.BEMOT
Object Type for Settlement Account Assignment
  • Object Type for Settlement Account Assignment
  • Client
Authorization Scope
  • Authorization Scope
  • Client
  • ?
Base Unit of Measure of Product
  • Base Unit of Measure of Product
  • Client
  • CRMS4_OPPT_I_SEARCH.BASE_QTY_UNIT == T006.MSEHI
  • CRMS4_OPPT_I_SEARCH.MANDT == T006.MANDT
CRM Business Transaction Classification
  • ?
  • CRM Business Transaction Classification
Competitor
  • Client
  • Competitor
  • CRMS4_OPPT_I_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_OPPT_I_SEARCH.COMPETITOR == BUT000.PARTNER
Customer Contact Person
  • Client
  • Customer Contact Person
  • CRMS4_OPPT_I_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_OPPT_I_SEARCH.CONTACT_PERSON == BUT000.PARTNER
Currency
  • Client
  • Currency
  • CRMS4_OPPT_I_SEARCH.MANDT == TCURC.MANDT
  • CRMS4_OPPT_I_SEARCH.CURRENCY == TCURC.WAERS
Business Partner Type
  • Client
  • Business Partner Type
  • CRMS4_OPPT_I_SEARCH.MANDT == TB004.CLIENT
  • CRMS4_OPPT_I_SEARCH.CUSTOMER_TYPE == TB004.BPKIND
Customer Group
  • Client
  • Customer Group
  • CRMS4_OPPT_I_SEARCH.MANDT == T151.MANDT
  • CRMS4_OPPT_I_SEARCH.CUST_GROUP == T151.KDGRP
Customer Group 1
  • Client
  • Customer Group 1
  • CRMS4_OPPT_I_SEARCH.MANDT == TVV1.MANDT
  • CRMS4_OPPT_I_SEARCH.CUST_GROUP1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • CRMS4_OPPT_I_SEARCH.MANDT == TVV2.MANDT
  • CRMS4_OPPT_I_SEARCH.CUST_GROUP2 == TVV2.KVGR2
Customer Group 3
  • Client
  • Customer Group 3
  • CRMS4_OPPT_I_SEARCH.MANDT == TVV3.MANDT
  • CRMS4_OPPT_I_SEARCH.CUST_GROUP3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • CRMS4_OPPT_I_SEARCH.MANDT == TVV4.MANDT
  • CRMS4_OPPT_I_SEARCH.CUST_GROUP4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • CRMS4_OPPT_I_SEARCH.MANDT == TVV5.MANDT
  • CRMS4_OPPT_I_SEARCH.CUST_GROUP5 == TVV5.KVGR5
Customer Pricing Procedure
  • Client
  • Customer Pricing Procedure
  • CRMS4_OPPT_I_SEARCH.MANDT == TVKD.MANDT
  • CRMS4_OPPT_I_SEARCH.CUST_PRIC_PROC == TVKD.KALKS
Language Key of Description CRMS4_OPPT_I_SEARCH.DESCR_LANGUAGE == T002.SPRAS
Distribution Channel
  • Client
  • Distribution Channel
  • CRMS4_OPPT_I_SEARCH.MANDT == TVTW.MANDT
  • CRMS4_OPPT_I_SEARCH.DIS_CHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • CRMS4_OPPT_I_SEARCH.MANDT == TSPA.MANDT
  • CRMS4_OPPT_I_SEARCH.DIVISION == TSPA.SPART
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • CRMS4_OPPT_I_SEARCH.MANDT == TCURV.MANDT
  • CRMS4_OPPT_I_SEARCH.EXCHG_TYPE == TCURV.KURST
Industry Sector
  • Client
  • Industry Sector
  • CRMS4_OPPT_I_SEARCH.MANDT == T016.MANDT
  • CRMS4_OPPT_I_SEARCH.INDUSTRY == T016.BRSCH
Item Category
  • Client
  • Item Category
Item Category Usage
  • Client
  • Item Category Usage
Condition Unit
  • Client
  • Condition Unit
  • CRMS4_OPPT_I_SEARCH.MANDT == T006.MANDT
  • CRMS4_OPPT_I_SEARCH.NETPR_UOM == T006.MSEHI
Business Trans. Cat. CRMS4_OPPT_I_SEARCH.OBJECT_TYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
CRM Item Object Type CRMS4_OPPT_I_SEARCH.OBJTYPE_I == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Payer
  • Client
  • Payer
  • CRMS4_OPPT_I_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_OPPT_I_SEARCH.PAYER == BUT000.PARTNER
Employee Responsible
  • Client
  • Employee Responsible
  • CRMS4_OPPT_I_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_OPPT_I_SEARCH.PERSON_RESP == BUT000.PARTNER
Plant
  • Client
  • Plant
  • CRMS4_OPPT_I_SEARCH.MANDT == T001W.MANDT
  • CRMS4_OPPT_I_SEARCH.PLANT == T001W.WERKS
Terms of Payment
  • Client
  • ?
  • Terms of Payment
  • CRMS4_OPPT_I_SEARCH.MANDT == T052.MANDT
  • CRMS4_OPPT_I_SEARCH.[column in domain "DZTAGG_052"] == T052.ZTAGG
  • CRMS4_OPPT_I_SEARCH.PMNTTRMS == T052.ZTERM
Customer Price Group
  • Client
  • Customer Price Group
  • CRMS4_OPPT_I_SEARCH.MANDT == T188.MANDT
  • CRMS4_OPPT_I_SEARCH.PRICE_GRP == T188.KONDA
Unit of Measure in Which the Product Is Sold
  • Client
  • Unit of Measure in Which the Product Is Sold
  • CRMS4_OPPT_I_SEARCH.MANDT == T006.MANDT
  • CRMS4_OPPT_I_SEARCH.PROCESS_QTY_UNIT == T006.MSEHI
Business Transaction Type
  • Client
  • Business Transaction Type
Reference Currency
  • Client
  • Reference Currency
  • CRMS4_OPPT_I_SEARCH.MANDT == TCURC.MANDT
  • CRMS4_OPPT_I_SEARCH.REF_CURRENCY == TCURC.WAERS
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • ?
  • CRMS4_OPPT_I_SEARCH.MANDT == T005S.MANDT
  • CRMS4_OPPT_I_SEARCH.REGION == T005S.BLAND
  • CRMS4_OPPT_I_SEARCH.[column in domain "LAND1"] == T005S.LAND1
Cancellation Reason Code
  • Client
  • Cancellation Reason Code
  • CRMS4_OPPT_I_SEARCH.MANDT == TVAG.MANDT
  • CRMS4_OPPT_I_SEARCH.REJECTION == TVAG.ABGRU
Time Zone Requested Delivery Date Header
  • Client
  • Time Zone Requested Delivery Date Header
  • CRMS4_OPPT_I_SEARCH.MANDT == TTZZ.CLIENT
  • CRMS4_OPPT_I_SEARCH.REQ_TIMEZONE_H == TTZZ.TZONE
Sales Prospect
  • Client
  • Sales Prospect
  • CRMS4_OPPT_I_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_OPPT_I_SEARCH.SALES_PROSPECT == BUT000.PARTNER
Sales Rep
  • Client
  • Sales Rep
  • CRMS4_OPPT_I_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_OPPT_I_SEARCH.SALES_REP == BUT000.PARTNER
Tax Jurisdiction Code (Structure for tax calculation)
  • Client
  • Tax Jurisdiction Code (Structure for tax calculation)
  • ?
  • CRMS4_OPPT_I_SEARCH.MANDT == TTXJ.MANDT
  • CRMS4_OPPT_I_SEARCH.TAXJURCODE == TTXJ.TXJCD
  • CRMS4_OPPT_I_SEARCH.[column in domain "TAX_KALSM"] == TTXJ.KALSM
Tax Destination Country/Region
  • Client
  • Tax Destination Country/Region
  • CRMS4_OPPT_I_SEARCH.MANDT == T005.MANDT
  • CRMS4_OPPT_I_SEARCH.TAX_DEST_CTY == T005.LAND1
Region (State, Province, County)
  • Client
  • Tax Destination Country/Region
  • Region (State, Province, County)
  • CRMS4_OPPT_I_SEARCH.MANDT == T005S.MANDT
  • CRMS4_OPPT_I_SEARCH.TAX_DEST_CTY == T005S.LAND1
  • CRMS4_OPPT_I_SEARCH.TAX_DEST_REG == T005S.BLAND
Usage Indicator
  • Client
  • Usage Indicator
  • CRMS4_OPPT_I_SEARCH.MANDT == TVLV.MANDT
  • CRMS4_OPPT_I_SEARCH.USAGE_TYPE == TVLV.ABRVW
Unit for the Volume of a Product
  • Client
  • Unit for the Volume of a Product
  • CRMS4_OPPT_I_SEARCH.MANDT == T006.MANDT
  • CRMS4_OPPT_I_SEARCH.VOLUME_UNIT_I == T006.MSEHI
Weight Unit
  • Client
  • Weight Unit
  • CRMS4_OPPT_I_SEARCH.MANDT == T006.MANDT
  • CRMS4_OPPT_I_SEARCH.WEIGHT_UNIT_I == T006.MSEHI
Other Relations | to Master Data Relations ↑ Join Conditions
Rule Reqested Delivery Date Header
  • Client
  • Rule Reqested Delivery Date Header
  • CRMS4_OPPT_I_SEARCH.MANDT == TIMERULEH.CLIENT
  • CRMS4_OPPT_I_SEARCH.RULE_REQ_DATE_H == TIMERULEH.RULE_ID