CRMS4D_OPPT_H

Header details of Opportunities and Leads | #header | Component: S4CRM: Business Transaction Framework

🔑 Keys (3)
💰 Amounts (8)
∑ Quantities (3)
📅 Dates (9)
☰ Categorical (22)
Other (35)
🔗 Relations (54)

Column Name	Description
CLIENT FK	Client
OBJTYPE_H FK	Business Trans. Cat.
OBJECT_ID	Transaction ID

Column Name	Description
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
💲 Currency (CURRENCY):
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
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
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
SDM_STATUS_DURA	SDM status of duration migration	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_OPEN	Status "Open"	Show values
STAT_DUPLICATE	Duplicate	Show values
STAT_NOTIF_REQUIRED	Status 'Lead Deduplication Notification Required'	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
NUMBER_ITEMS	Number of items in an order
QUAL_LEVEL_SVY	Questionnaire that Q-Level Sets (Automatically)	CHAR32
LEAD_END	End Date	TZNTSTMPS
LEAD_START	Start Date	TZNTSTMPS
SYS_PROBABILITY	Chance of Success of Opportunity - Calculated by System	CRM_SYSTEM_PROBABILITY
HEADER_GUID	GUID of a CRM Order Object	SYSUUID
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
HEAD_CHANGED_AT	Time of Last Change to the Transaction	BCOS_TSTMP
VERIFY_DATE	Time Period of Last Archiving Attempt	BCOS_TSTMP
HEADER_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
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
INBOX_STATUS	Status of Agent Inbox Item	CRM_AUI_STATUS
OPPT_H_DUMMY_PS	Single-Character Flag	CHAR1

Master Data Relations	Join Conditions
Accounting Indicator	`CRMS4D_OPPT_H.CLIENT == TBMOT.MANDT` `CRMS4D_OPPT_H.AC_INDICATOR == TBMOT.BEMOT`
Object Type for Settlement Account Assignment	`CRMS4D_OPPT_H.CLIENT == CRMC_AC_ASSIGN.CLIENT` `CRMS4D_OPPT_H.AC_OBJECT_TYPE == CRMC_AC_ASSIGN.AC_OBJECT_TYPE`
Authorization Scope ? Authorization Scope	`CRMS4D_OPPT_H.CLIENT == CRMC_AUTH_SCP.CLIENT` `CRMS4D_OPPT_H.[column in domain "CRM_AUTH_DOM"] == CRMC_AUTH_SCP.AUTH_DOM` `CRMS4D_OPPT_H.AUTH_SCOPE == CRMC_AUTH_SCP.AUTH_SCOPE`
CRM Business Transaction Classification CRM Business Transaction Classification ?	`CRMS4D_OPPT_H.BTX_CLASS == CRMC_TRANS_CLASS.BTX_CLASS` `CRMS4D_OPPT_H.[column in domain "CRMT_SWO_OBJTYP_PROCESS"] == CRMC_TRANS_CLASS.OBJECT_TYPE`
Client	`CRMS4D_OPPT_H.CLIENT == T000.MANDT`
Competitor Competitor Client	`CRMS4D_OPPT_H.COMPETITOR == BUT000.PARTNER` `CRMS4D_OPPT_H.CLIENT == BUT000.CLIENT`
Customer Contact Person Customer Contact Person Client	`CRMS4D_OPPT_H.CONTACT_PERSON == BUT000.PARTNER` `CRMS4D_OPPT_H.CLIENT == BUT000.CLIENT`
Currency	`CRMS4D_OPPT_H.CLIENT == TCURC.MANDT` `CRMS4D_OPPT_H.CURRENCY == TCURC.WAERS`
Sales Stage	`CRMS4D_OPPT_H.CLIENT == CRMC_PHASE.CLIENT` `CRMS4D_OPPT_H.CURR_PHASE == CRMC_PHASE.PHASE`
Business Partner Type	`CRMS4D_OPPT_H.CLIENT == TB004.CLIENT` `CRMS4D_OPPT_H.CUSTOMER_TYPE == TB004.BPKIND`
Customer Group Customer Group Client	`CRMS4D_OPPT_H.CUST_GROUP == T151.KDGRP` `CRMS4D_OPPT_H.CLIENT == T151.MANDT`
Customer Group 1	`CRMS4D_OPPT_H.CLIENT == TVV1.MANDT` `CRMS4D_OPPT_H.CUST_GROUP1 == TVV1.KVGR1`
Customer Group 2	`CRMS4D_OPPT_H.CLIENT == TVV2.MANDT` `CRMS4D_OPPT_H.CUST_GROUP2 == TVV2.KVGR2`
Customer Group 3 Customer Group 3 Client	`CRMS4D_OPPT_H.CUST_GROUP3 == TVV3.KVGR3` `CRMS4D_OPPT_H.CLIENT == TVV3.MANDT`
Customer Group 4	`CRMS4D_OPPT_H.CLIENT == TVV4.MANDT` `CRMS4D_OPPT_H.CUST_GROUP4 == TVV4.KVGR4`
Customer Group 5 Customer Group 5 Client	`CRMS4D_OPPT_H.CUST_GROUP5 == TVV5.KVGR5` `CRMS4D_OPPT_H.CLIENT == TVV5.MANDT`
Customer Pricing Procedure Customer Pricing Procedure Client	`CRMS4D_OPPT_H.CUST_PRIC_PROC == TVKD.KALKS` `CRMS4D_OPPT_H.CLIENT == TVKD.MANDT`
Language Key of Description	`CRMS4D_OPPT_H.DESCR_LANGUAGE == T002.SPRAS`
Distribution Channel Distribution Channel Client	`CRMS4D_OPPT_H.DIS_CHANNEL == TVTW.VTWEG` `CRMS4D_OPPT_H.CLIENT == TVTW.MANDT`
Division	`CRMS4D_OPPT_H.CLIENT == TSPA.MANDT` `CRMS4D_OPPT_H.DIVISION == TSPA.SPART`
Exchange Rate Type	`CRMS4D_OPPT_H.CLIENT == TCURV.MANDT` `CRMS4D_OPPT_H.EXCHG_TYPE == TCURV.KURST`
Sales Partners Sales Partners Client	`CRMS4D_OPPT_H.INBOX_ACCOUNT == BUT000.PARTNER` `CRMS4D_OPPT_H.CLIENT == BUT000.CLIENT`
Employee Responsible Employee Responsible Client	`CRMS4D_OPPT_H.INBOX_ASSIGNED_TO == BUT000.PARTNER` `CRMS4D_OPPT_H.CLIENT == BUT000.CLIENT`
Customer Contact Person Customer Contact Person Client	`CRMS4D_OPPT_H.INBOX_CONTACT_PERSON == BUT000.PARTNER` `CRMS4D_OPPT_H.CLIENT == BUT000.CLIENT`
Responsible Group Responsible Group Client	`CRMS4D_OPPT_H.INBOX_GROUP_ASSIGNED == BUT000.PARTNER` `CRMS4D_OPPT_H.CLIENT == BUT000.CLIENT`
Industry Sector Industry Sector Client	`CRMS4D_OPPT_H.INDUSTRY == T016.BRSCH` `CRMS4D_OPPT_H.CLIENT == T016.MANDT`
Lead Group Lead Group Client	`CRMS4D_OPPT_H.LEAD_TYPE == CRMC_LEAD_TYPE.LEAD_TYPE` `CRMS4D_OPPT_H.CLIENT == CRMC_LEAD_TYPE.CLIENT`
Business Trans. Cat.	`CRMS4D_OPPT_H.OBJTYPE_H == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY`
Payer Payer Client	`CRMS4D_OPPT_H.PAYER == BUT000.PARTNER` `CRMS4D_OPPT_H.CLIENT == BUT000.CLIENT`
Employee Responsible Employee Responsible Client	`CRMS4D_OPPT_H.PERSON_RESP == BUT000.PARTNER` `CRMS4D_OPPT_H.CLIENT == BUT000.CLIENT`
Terms of Payment Terms of Payment ? Client	`CRMS4D_OPPT_H.PMNTTRMS == T052.ZTERM` `CRMS4D_OPPT_H.[column in domain "DZTAGG_052"] == T052.ZTAGG` `CRMS4D_OPPT_H.CLIENT == T052.MANDT`
Customer Price Group Customer Price Group Client	`CRMS4D_OPPT_H.PRICE_GRP == T188.KONDA` `CRMS4D_OPPT_H.CLIENT == T188.MANDT`
Procedure (Pricing, Output Control, Acct. Det., Costing,...) ? Procedure (Pricing, Output Control, Acct. Det., Costing,...) ?	`CRMS4D_OPPT_H.CLIENT == T683.MANDT` `CRMS4D_OPPT_H.[column in domain "KAPPL"] == T683.KAPPL` `CRMS4D_OPPT_H.PRICING_PROCEDURE == T683.KALSM` `CRMS4D_OPPT_H.[column in domain "KVEWE"] == T683.KVEWE`
Activity Priority	`CRMS4D_OPPT_H.CLIENT == SCPRIO.CLIENT` `CRMS4D_OPPT_H.PRIORITY == SCPRIO.PRIORITY`
Business Transaction Type	`CRMS4D_OPPT_H.CLIENT == CRMC_PROC_TYPE.CLIENT` `CRMS4D_OPPT_H.PROCESS_TYPE == CRMC_PROC_TYPE.PROCESS_TYPE`
Lead Qualification Level (Automatic)	`CRMS4D_OPPT_H.CLIENT == CRMC_LEAD_QL.CLIENT` `CRMS4D_OPPT_H.QUAL_LEVEL_AUTO == CRMC_LEAD_QL.QUAL_LEVEL`
Lead Qualification Level	`CRMS4D_OPPT_H.CLIENT == CRMC_LEAD_QL.CLIENT` `CRMS4D_OPPT_H.QUAL_LEVEL_MAN == CRMC_LEAD_QL.QUAL_LEVEL`
Reference Currency	`CRMS4D_OPPT_H.CLIENT == TCURC.MANDT` `CRMS4D_OPPT_H.REF_CURRENCY == TCURC.WAERS`
Region (State, Province, County) ? Region (State, Province, County)	`CRMS4D_OPPT_H.CLIENT == T005S.MANDT` `CRMS4D_OPPT_H.[column in domain "LAND1"] == T005S.LAND1` `CRMS4D_OPPT_H.REGION == T005S.BLAND`
Cancellation Reason Code	`CRMS4D_OPPT_H.CLIENT == TVAG.MANDT` `CRMS4D_OPPT_H.REJECTION == TVAG.ABGRU`
Time Zone Requested Delivery Date Header	`CRMS4D_OPPT_H.CLIENT == TTZZ.CLIENT` `CRMS4D_OPPT_H.REQ_TIMEZONE_H == TTZZ.TZONE`
Sales Cycle Sales Cycle Client	`CRMS4D_OPPT_H.SALESCYCLE == CRMC_CYCLE.SALESCYCLE` `CRMS4D_OPPT_H.CLIENT == CRMC_CYCLE.CLIENT`
Sales Prospect Sales Prospect Client	`CRMS4D_OPPT_H.SALES_PROSPECT == BUT000.PARTNER` `CRMS4D_OPPT_H.CLIENT == BUT000.CLIENT`
Sales Rep Sales Rep Client	`CRMS4D_OPPT_H.SALES_REP == BUT000.PARTNER` `CRMS4D_OPPT_H.CLIENT == BUT000.CLIENT`
Origin of Opportunity/Lead Origin of Opportunity/Lead Client	`CRMS4D_OPPT_H.SOURCE == CRMC_SOURCE.SOURCE` `CRMS4D_OPPT_H.CLIENT == CRMC_SOURCE.CLIENT`
Tax Jurisdiction Code (Structure for tax calculation) ? Tax Jurisdiction Code (Structure for tax calculation)	`CRMS4D_OPPT_H.CLIENT == TTXJ.MANDT` `CRMS4D_OPPT_H.[column in domain "TAX_KALSM"] == TTXJ.KALSM` `CRMS4D_OPPT_H.TAXJURCODE == TTXJ.TXJCD`
Tax Destination Country/Region Tax Destination Country/Region Client	`CRMS4D_OPPT_H.TAX_DEST_CTY == T005.LAND1` `CRMS4D_OPPT_H.CLIENT == T005.MANDT`
Region (State, Province, County) Tax Destination Country/Region Region (State, Province, County)	`CRMS4D_OPPT_H.CLIENT == T005S.MANDT` `CRMS4D_OPPT_H.TAX_DEST_CTY == T005S.LAND1` `CRMS4D_OPPT_H.TAX_DEST_REG == T005S.BLAND`
Opportunity Type	`CRMS4D_OPPT_H.CLIENT == CRMC_OPPT_TYPE.CLIENT` `CRMS4D_OPPT_H.TYPE == CRMC_OPPT_TYPE.TYPE`
Usage Indicator Usage Indicator Client	`CRMS4D_OPPT_H.USAGE_TYPE == TVLV.ABRVW` `CRMS4D_OPPT_H.CLIENT == TVLV.MANDT`
Unit for the Volume of a Product	`CRMS4D_OPPT_H.CLIENT == T006.MANDT` `CRMS4D_OPPT_H.VOLUME_UNIT_H == T006.MSEHI`
Weight Unit	`CRMS4D_OPPT_H.CLIENT == T006.MANDT` `CRMS4D_OPPT_H.WEIGHT_UNIT_H == T006.MSEHI`

Other Relations \| to Master Data Relations ↑	Join Conditions
Rule Reqested Delivery Date Header Rule Reqested Delivery Date Header Client	`CRMS4D_OPPT_H.RULE_REQ_DATE_H == TIMERULEH.RULE_ID` `CRMS4D_OPPT_H.CLIENT == TIMERULEH.CLIENT`