CRMS4D_OPPT_I

Item details of Opportunities and Leads | #transactional | Component: S4CRM: Business Transaction Framework
Column Name Description
CLIENT FK Client
OBJTYPE_H 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
📏 Unit of Measure in Which the Product Is Sold (CRMS4D_SERV_I.PROCESS_QTY_UNIT):
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
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
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_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
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
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
PRODUCT_ID Product Number MATNR
ITEM_GUID_CHAR 32 Character CRM Object GUID (Converted)
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
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
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
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
ITEM_NO_BILLPLAN Shortened Item Number in Document CRMS4_NUMBER_INT
ITEM_NO_PAYPLAN Shortened Item Number in Document CRMS4_NUMBER_INT
OPPT_I_DUMMY_PS Single-Character Flag CHAR1
Master Data Relations Join Conditions
Accounting Indicator
  • CRMS4D_OPPT_I.CLIENT == TBMOT.MANDT
  • CRMS4D_OPPT_I.AC_INDICATOR == TBMOT.BEMOT
Object Type for Settlement Account Assignment
Authorization Scope
  • ?
  • Authorization Scope
Base Unit of Measure of Product
  • CRMS4D_OPPT_I.CLIENT == T006.MANDT
  • CRMS4D_OPPT_I.BASE_QTY_UNIT == T006.MSEHI
CRM Business Transaction Classification
  • CRM Business Transaction Classification
  • ?
Client CRMS4D_OPPT_I.CLIENT == T000.MANDT
Competitor
  • Competitor
  • Client
  • CRMS4D_OPPT_I.COMPETITOR == BUT000.PARTNER
  • CRMS4D_OPPT_I.CLIENT == BUT000.CLIENT
Customer Contact Person
  • Customer Contact Person
  • Client
  • CRMS4D_OPPT_I.CONTACT_PERSON == BUT000.PARTNER
  • CRMS4D_OPPT_I.CLIENT == BUT000.CLIENT
Currency
  • CRMS4D_OPPT_I.CLIENT == TCURC.MANDT
  • CRMS4D_OPPT_I.CURRENCY == TCURC.WAERS
Business Partner Type
  • CRMS4D_OPPT_I.CLIENT == TB004.CLIENT
  • CRMS4D_OPPT_I.CUSTOMER_TYPE == TB004.BPKIND
Customer Group
  • Customer Group
  • Client
  • CRMS4D_OPPT_I.CUST_GROUP == T151.KDGRP
  • CRMS4D_OPPT_I.CLIENT == T151.MANDT
Customer Group 1
  • CRMS4D_OPPT_I.CLIENT == TVV1.MANDT
  • CRMS4D_OPPT_I.CUST_GROUP1 == TVV1.KVGR1
Customer Group 2
  • CRMS4D_OPPT_I.CLIENT == TVV2.MANDT
  • CRMS4D_OPPT_I.CUST_GROUP2 == TVV2.KVGR2
Customer Group 3
  • Customer Group 3
  • Client
  • CRMS4D_OPPT_I.CUST_GROUP3 == TVV3.KVGR3
  • CRMS4D_OPPT_I.CLIENT == TVV3.MANDT
Customer Group 4
  • CRMS4D_OPPT_I.CLIENT == TVV4.MANDT
  • CRMS4D_OPPT_I.CUST_GROUP4 == TVV4.KVGR4
Customer Group 5
  • Customer Group 5
  • Client
  • CRMS4D_OPPT_I.CUST_GROUP5 == TVV5.KVGR5
  • CRMS4D_OPPT_I.CLIENT == TVV5.MANDT
Customer Pricing Procedure
  • Customer Pricing Procedure
  • Client
  • CRMS4D_OPPT_I.CUST_PRIC_PROC == TVKD.KALKS
  • CRMS4D_OPPT_I.CLIENT == TVKD.MANDT
Language Key of Description CRMS4D_OPPT_I.DESCR_LANGUAGE == T002.SPRAS
Distribution Channel
  • Distribution Channel
  • Client
  • CRMS4D_OPPT_I.DIS_CHANNEL == TVTW.VTWEG
  • CRMS4D_OPPT_I.CLIENT == TVTW.MANDT
Division
  • CRMS4D_OPPT_I.CLIENT == TSPA.MANDT
  • CRMS4D_OPPT_I.DIVISION == TSPA.SPART
Exchange Rate Type
  • CRMS4D_OPPT_I.CLIENT == TCURV.MANDT
  • CRMS4D_OPPT_I.EXCHG_TYPE == TCURV.KURST
Industry Sector
  • Industry Sector
  • Client
  • CRMS4D_OPPT_I.INDUSTRY == T016.BRSCH
  • CRMS4D_OPPT_I.CLIENT == T016.MANDT
Item Category
Item Category Usage
Condition Unit
  • CRMS4D_OPPT_I.CLIENT == T006.MANDT
  • CRMS4D_OPPT_I.NETPR_UOM == T006.MSEHI
Business Trans. Cat. CRMS4D_OPPT_I.OBJTYPE_H == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
CRM Item Object Type CRMS4D_OPPT_I.OBJTYPE_I == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Payer
  • Payer
  • Client
  • CRMS4D_OPPT_I.PAYER == BUT000.PARTNER
  • CRMS4D_OPPT_I.CLIENT == BUT000.CLIENT
Employee Responsible
  • Employee Responsible
  • Client
  • CRMS4D_OPPT_I.PERSON_RESP == BUT000.PARTNER
  • CRMS4D_OPPT_I.CLIENT == BUT000.CLIENT
Plant
  • CRMS4D_OPPT_I.CLIENT == T001W.MANDT
  • CRMS4D_OPPT_I.PLANT == T001W.WERKS
Terms of Payment
  • Terms of Payment
  • ?
  • Client
  • CRMS4D_OPPT_I.PMNTTRMS == T052.ZTERM
  • CRMS4D_OPPT_I.[column in domain "DZTAGG_052"] == T052.ZTAGG
  • CRMS4D_OPPT_I.CLIENT == T052.MANDT
Customer Price Group
  • Customer Price Group
  • Client
  • CRMS4D_OPPT_I.PRICE_GRP == T188.KONDA
  • CRMS4D_OPPT_I.CLIENT == T188.MANDT
Unit of Measure in Which the Product Is Sold
  • CRMS4D_OPPT_I.CLIENT == T006.MANDT
  • CRMS4D_OPPT_I.PROCESS_QTY_UNIT == T006.MSEHI
Business Transaction Type
Reference Currency
  • CRMS4D_OPPT_I.CLIENT == TCURC.MANDT
  • CRMS4D_OPPT_I.REF_CURRENCY == TCURC.WAERS
Region (State, Province, County)
  • ?
  • Region (State, Province, County)
  • CRMS4D_OPPT_I.CLIENT == T005S.MANDT
  • CRMS4D_OPPT_I.[column in domain "LAND1"] == T005S.LAND1
  • CRMS4D_OPPT_I.REGION == T005S.BLAND
Cancellation Reason Code
  • CRMS4D_OPPT_I.CLIENT == TVAG.MANDT
  • CRMS4D_OPPT_I.REJECTION == TVAG.ABGRU
Time Zone Requested Delivery Date Header
  • CRMS4D_OPPT_I.CLIENT == TTZZ.CLIENT
  • CRMS4D_OPPT_I.REQ_TIMEZONE_H == TTZZ.TZONE
Sales Prospect
  • Sales Prospect
  • Client
  • CRMS4D_OPPT_I.SALES_PROSPECT == BUT000.PARTNER
  • CRMS4D_OPPT_I.CLIENT == BUT000.CLIENT
Sales Rep
  • Sales Rep
  • Client
  • CRMS4D_OPPT_I.SALES_REP == BUT000.PARTNER
  • CRMS4D_OPPT_I.CLIENT == BUT000.CLIENT
Tax Jurisdiction Code (Structure for tax calculation)
  • ?
  • Tax Jurisdiction Code (Structure for tax calculation)
  • CRMS4D_OPPT_I.CLIENT == TTXJ.MANDT
  • CRMS4D_OPPT_I.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • CRMS4D_OPPT_I.TAXJURCODE == TTXJ.TXJCD
Tax Destination Country/Region
  • Tax Destination Country/Region
  • Client
  • CRMS4D_OPPT_I.TAX_DEST_CTY == T005.LAND1
  • CRMS4D_OPPT_I.CLIENT == T005.MANDT
Region (State, Province, County)
  • Tax Destination Country/Region
  • Region (State, Province, County)
  • CRMS4D_OPPT_I.CLIENT == T005S.MANDT
  • CRMS4D_OPPT_I.TAX_DEST_CTY == T005S.LAND1
  • CRMS4D_OPPT_I.TAX_DEST_REG == T005S.BLAND
Usage Indicator
  • Usage Indicator
  • Client
  • CRMS4D_OPPT_I.USAGE_TYPE == TVLV.ABRVW
  • CRMS4D_OPPT_I.CLIENT == TVLV.MANDT
Unit for the Volume of a Product
  • CRMS4D_OPPT_I.CLIENT == T006.MANDT
  • CRMS4D_OPPT_I.VOLUME_UNIT_I == T006.MSEHI
Weight Unit
  • CRMS4D_OPPT_I.CLIENT == T006.MANDT
  • CRMS4D_OPPT_I.WEIGHT_UNIT_I == T006.MSEHI
Other Relations | to Master Data Relations ↑ Join Conditions
Rule Reqested Delivery Date Header
  • Rule Reqested Delivery Date Header
  • Client
  • CRMS4D_OPPT_I.RULE_REQ_DATE_H == TIMERULEH.RULE_ID
  • CRMS4D_OPPT_I.CLIENT == TIMERULEH.CLIENT