CRMS4D_OPPT_H

Transparent Table Application Table
133 Fields 4 CDS Views

Header details of Opportunities and Leads

CRMS4D_OPPT_H is an SAP database table in S/4HANA. Header details of Opportunities and Leads. It contains 133 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
CRMS4_LEAD_H_SEARCH view from Lead Header
CRMS4_OPPT_H_SEARCH view from Opportunity/Lead Header
E_PresalesDocument view from EXTENSION Presales Document Extension
I_PresalesDocument view from BASIC Presales Document

Fields (133)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY objtype_h CRMT_SUBOBJECT_CATEGORY_DB Trans. Cat.
KEY object_id CRMT_OBJECT_ID_DB Transaction ID
ac_object_type CRMT_AC_OBJECT_TYPE Acct Assgt Obj.Type
ac_assignment CRMT_AC_ASSIGN Sett.Account Assgmnt
ac_percentage CRMT_AC_COST_PERCENTAGE Percent. of Costs
gross_weight_h CRMT_GROSS_WEIGHT_CUM Gross Weight
net_weight_h CRMT_NET_WEIGHT_CUM Net Weight
weight_unit_h COMT_WEIGHT_UNIT Unit of Weight
volume_h CRMT_VOLUME_CUM Volume
volume_unit_h COMT_VOLUME_UNIT Volume Unit
gross_value_h CRMT_GROSS_VALUE_CUM Gross Value
net_value_h CRMT_NET_VALUE_CUM Net Value
net_value_man_h CRMT_NET_VALUE_MAN_CUM Exp.Prod.Value
tax_amount_h CRMT_TAX_AMOUNT_CUM Tax Amount
freight_h CRMT_FREIGHT_CUM Shipment Costs
net_wo_freight_h CRMT_NET_WO_FREIGHT_CUM Net w/out freight
number_items CRMT_NUMBER_ITEMS Number of items
lead_type CRMT_LEAD_TYPE Lead Group
qual_level_man CRMT_LEAD_QUAL_LEVEL_MAN Q Level
qual_level_auto CRMT_LEAD_QUAL_LEVEL_AUTO Q Level (Auto)
qual_level_svy CRMT_LEAD_QUAL_LEVEL_AUTO_SVY QuestionnaireID
lead_end CRMS4_LEAD_END End Date
lead_start CRMS4_LEAD_START Start Date
exp_revenue CRMT_REPORT_EXP_REVENUE Expected Sales Vol.
budget_bp CRMT_BUDGET_BP Budget Prospect
startdate CRMT_STARTDATE Start Date
expect_end CRMT_EXPECT_END Closing Date
curr_phase CRMT_CURR_PHASE Sales Stage
phase_since CRMT_PHASE_SINCE Stage Since
source CRMT_SOURCE Origin
priority CRMT_PRIORITY Priority
salescycle CRMT_SALESCYCLE Sales Cycle
type CRMT_OPPORT_TYPE Type
status_since CRMT_STATUS_SINCE Status Since
sys_probability CRMT_SYSTEM_PROBABILITY Chance Success (cal)
header_guid CRMT_OBJECT_GUID Object GUID
process_type CRMT_PROCESS_TYPE_DB Transaction Type
posting_date CRMT_POSTING_DATE Posting Date
description_h CRMT_PROCESS_DESCRIPTION Description
descr_language CRMT_PROCESS_DESCRIPTION_LANGU Language
template_type CRMT_TEMPLATE_TYPE_DB Templ. Type
created_at_h COMT_CREATED_AT_USR Created At
created_by_h CRMT_CREATED_BY Created By
changed_at_h COMT_CHANGED_AT_USR Changed On
changed_by_h CRMT_CHANGED_BY Changed By
head_changed_at CRMT_CHANGED_AT Changed On
btx_class CRMT_TRANSACTION_CLASSIFICATN Trans.Classification
auth_scope CRM_AUTH_SCOPE Authorization Scope
archiving_flag CRMT_ARCHIVING_FLAG Can Be Archived
object_id_ok CRMT_OBJECT_ID_OK ID Valid
verify_date CRMT_VERIFY_DATE Verify Date
pricing_document KNUMV Doc. Condition
pricing_procedure KALSM_D Procedure
header_guid_char CRMT_OBJECT_GUID32 Object GUID
sdm_status_dura CRMS4_SDM_STATUS_DURA Duration Flag
dis_channel CRMT_DISTRIBUTION_CHANNEL Distribution Channel
division CRMT_DIVISION Division
service_org_ori CRMT_SERVICE_ORG_ORIGIN Origin srvc. org.
service_orgr_ori CRMT_SERVICE_ORG_RESP_ORIGIN Origin Sales Org.
sales_org_ori CRMT_SALES_ORG_ORIGIN Origin sales org.
dis_channel_ori CRMT_DIS_CHANNEL_ORIGIN Origin: Distr. chnl
sales_off_ori CRMT_SALES_OFFICE_ORIGIN Origin: Sales office
sales_group_ori CRMT_SALES_GROUP_ORIGIN Origin: Sales group
sales_orgr_ori CRMT_SALES_ORG_RESP_ORIGIN Origin SOrg
division_ori CRMT_DIVISION_ORIGIN Origin: Division
sales_org CRMT_SALES_ORG Sales Org. ID
sales_office CRMT_SALES_OFFICE Sales Office
sales_group CRMT_SALES_GROUP Sales Group
sales_org_resp CRMT_SALES_ORG_RESP Org. Unit (Sales)
service_org CRMT_SERVICE_ORG Service Organization
service_org_resp CRMT_SERVICE_ORG_RESP OU (Service)
sales_org_sd VKORG Sales Org.
sales_office_sd VKBUR Sales Office
sales_group_sd VKGRP Sales Group
sales_rep CRMS4_SALES_REP Sales Rep
person_resp CRMT_PERSON_RESP Employee Resp.
contact_person CRMT_CONTACT_PERSON Contact Pers.
sales_prospect CRMS4_SALES_PROSPECT Sales Prospect
payer CRMT_RP_PAYER Payer
competitor CRMS4_COMPETITOR Competitor
inbox_assigned_to CRMT_PERSON_RESP Employee Resp.
inbox_group_assigned CRMT_RESPONSIBLE_GROUP Responsible Group
inbox_account CRMT_SALESPARTNER Sales Partners
inbox_contact_person CRMT_CONTACT_PERSON Contact Pers.
exchg_type CRMT_EXCHG_TYPE Exch. Rate Type
exchg_date CRMT_EXCHG_DATE Exch. Rate Date
taxjurcode CRMT_TAXJURCODE Jurisdict.Code
cust_pric_proc CRMT_CUST_PRIC_PROC Cust.Pric.Proc.
ref_currency CRMT_REF_CURRENCY Ref. Currency
currency CRMT_CURRENCY Currency
price_date CRMT_PRICE_DATE Pricing Date
pmnttrms CRMT_PMNTTRMS Terms of Paymnt
price_grp CRMT_PRICE_GRP Price Group
cust_group CRMT_CUST_GROUP Customer Group
exchg_rate CRMT_EXCHG_RATE Exchange Rate
tax_dest_cty CRMT_TAX_DEST_CTY Dest.Ctry/Reg.
tax_dest_reg CRMT_REGION Region
vat_reg_no CRMT_VAT_REG_NO Sales tax no.
ac_indicator CRMT_AC_INDICATOR Account. Indic.
customer_type CRMT_CUSTOMER_TYPE Part. Type
payment_method CRMT_BUAG_PAYMETH Payment Method
region CRMT_REGION Region
industry CRMT_INDUSTRY Industry Sector
cust_group1 CRMT_CUST_GROUP1 Customer Grp 1
cust_group2 CRMT_CUST_GROUP2 Customer Grp 2
cust_group3 CRMT_CUST_GROUP3 Customer Grp 3
cust_group4 CRMT_CUST_GROUP4 Customer Grp 4
cust_group5 CRMT_CUST_GROUP5 Customer Grp 5
po_number_sold CRMT_PO_NUMBER_SOLD Ext. Reference
po_date_sold CRMT_PO_DATE_SOLD Reference Date
your_ref_sold CRMT_YOUR_REFERENCE_SOLD Your Reference
po_number_ship CRMT_PO_NUMBER_SHIP Ext. Reference
po_date_ship CRMT_PO_DATE_SHIP Reference Doc SH
your_ref_ship CRMT_YOUR_REFERENCE_SHIP Your Reference
usage_type CRMT_USAGE Usage
submission CRMT_SUBMISSION Collective No.
rejection CRMT_REJECTION_CODE Cancel Rsn Code
probability CRMT_ORDER_PROBABILITY Probability %
date_qty_fixed CRMT_DATE_QTY_FIXED Fixed Date/Qty
req_dlv_date_h CRMT_REQ_DLV_DATE Rqstd Deliv. Date
req_timezone_h CRMT_REQ_DATE_TIMEZONE Time Zone
rule_req_date_h CRMT_RULE_REQ_DATE Rule ReqDelDate
stat_lifecycle CRMS4_STAT_LIFECYCLE Life Cycle Status
stat_lifecycle_oppt CRMS4_STAT_LIFECYCLE_OPPT Lifecycle Status
stat_error CRMS4_STAT_ERROR Error Status
stat_archivable CRMS4_STAT_ARCHIVABLE Archivable
stat_archived CRMS4_STAT_ARCHIVED Archived
stat_open CRMS4_STAT_OPEN Open
stat_duplicate CRMS4_STAT_DUPLICATE Duplicate
inbox_status CRMT_AUI_STATUS Status
stat_notif_required CRMS4_STAT_NOTIF_REQUIRED Status Notificat.Req
oppt_h_dummy_ps CHAR1 Single-Character Flag

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Header details of Opportunities and Leads
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_OPPT_H (
    CLIENT,                -- Client [MANDT]
    OBJTYPE_H,             -- Trans. Cat. [CRMT_SUBOBJECT_CATEGORY_DB]
    OBJECT_ID,             -- Transaction ID [CRMT_OBJECT_ID_DB]
    AC_OBJECT_TYPE,        -- Acct Assgt Obj.Type [CRMT_AC_OBJECT_TYPE]
    AC_ASSIGNMENT,         -- Sett.Account Assgmnt [CRMT_AC_ASSIGN]
    AC_PERCENTAGE,         -- Percent. of Costs [CRMT_AC_COST_PERCENTAGE]
    GROSS_WEIGHT_H,        -- Gross Weight [CRMT_GROSS_WEIGHT_CUM]
    NET_WEIGHT_H,          -- Net Weight [CRMT_NET_WEIGHT_CUM]
    WEIGHT_UNIT_H,         -- Unit of Weight [COMT_WEIGHT_UNIT]
    VOLUME_H,              -- Volume [CRMT_VOLUME_CUM]
    VOLUME_UNIT_H,         -- Volume Unit [COMT_VOLUME_UNIT]
    GROSS_VALUE_H,         -- Gross Value [CRMT_GROSS_VALUE_CUM]
    NET_VALUE_H,           -- Net Value [CRMT_NET_VALUE_CUM]
    NET_VALUE_MAN_H,       -- Exp.Prod.Value [CRMT_NET_VALUE_MAN_CUM]
    TAX_AMOUNT_H,          -- Tax Amount [CRMT_TAX_AMOUNT_CUM]
    FREIGHT_H,             -- Shipment Costs [CRMT_FREIGHT_CUM]
    NET_WO_FREIGHT_H,      -- Net w/out freight [CRMT_NET_WO_FREIGHT_CUM]
    NUMBER_ITEMS,          -- Number of items [CRMT_NUMBER_ITEMS]
    LEAD_TYPE,             -- Lead Group [CRMT_LEAD_TYPE]
    QUAL_LEVEL_MAN,        -- Q Level [CRMT_LEAD_QUAL_LEVEL_MAN]
    QUAL_LEVEL_AUTO,       -- Q Level (Auto) [CRMT_LEAD_QUAL_LEVEL_AUTO]
    QUAL_LEVEL_SVY,        -- QuestionnaireID [CRMT_LEAD_QUAL_LEVEL_AUTO_SVY]
    LEAD_END,              -- End Date [CRMS4_LEAD_END]
    LEAD_START,            -- Start Date [CRMS4_LEAD_START]
    EXP_REVENUE,           -- Expected Sales Vol. [CRMT_REPORT_EXP_REVENUE]
    BUDGET_BP,             -- Budget Prospect [CRMT_BUDGET_BP]
    STARTDATE,             -- Start Date [CRMT_STARTDATE]
    EXPECT_END,            -- Closing Date [CRMT_EXPECT_END]
    CURR_PHASE,            -- Sales Stage [CRMT_CURR_PHASE]
    PHASE_SINCE,           -- Stage Since [CRMT_PHASE_SINCE]
    SOURCE,                -- Origin [CRMT_SOURCE]
    PRIORITY,              -- Priority [CRMT_PRIORITY]
    SALESCYCLE,            -- Sales Cycle [CRMT_SALESCYCLE]
    TYPE,                  -- Type [CRMT_OPPORT_TYPE]
    STATUS_SINCE,          -- Status Since [CRMT_STATUS_SINCE]
    SYS_PROBABILITY,       -- Chance Success (cal) [CRMT_SYSTEM_PROBABILITY]
    HEADER_GUID,           -- Object GUID [CRMT_OBJECT_GUID]
    PROCESS_TYPE,          -- Transaction Type [CRMT_PROCESS_TYPE_DB]
    POSTING_DATE,          -- Posting Date [CRMT_POSTING_DATE]
    DESCRIPTION_H,         -- Description [CRMT_PROCESS_DESCRIPTION]
    DESCR_LANGUAGE,        -- Language [CRMT_PROCESS_DESCRIPTION_LANGU]
    TEMPLATE_TYPE,         -- Templ. Type [CRMT_TEMPLATE_TYPE_DB]
    CREATED_AT_H,          -- Created At [COMT_CREATED_AT_USR]
    CREATED_BY_H,          -- Created By [CRMT_CREATED_BY]
    CHANGED_AT_H,          -- Changed On [COMT_CHANGED_AT_USR]
    CHANGED_BY_H,          -- Changed By [CRMT_CHANGED_BY]
    HEAD_CHANGED_AT,       -- Changed On [CRMT_CHANGED_AT]
    BTX_CLASS,             -- Trans.Classification [CRMT_TRANSACTION_CLASSIFICATN]
    AUTH_SCOPE,            -- Authorization Scope [CRM_AUTH_SCOPE]
    ARCHIVING_FLAG,        -- Can Be Archived [CRMT_ARCHIVING_FLAG]
    OBJECT_ID_OK,          -- ID Valid [CRMT_OBJECT_ID_OK]
    VERIFY_DATE,           -- Verify Date [CRMT_VERIFY_DATE]
    PRICING_DOCUMENT,      -- Doc. Condition [KNUMV]
    PRICING_PROCEDURE,     -- Procedure [KALSM_D]
    HEADER_GUID_CHAR,      -- Object GUID [CRMT_OBJECT_GUID32]
    SDM_STATUS_DURA,       -- Duration Flag [CRMS4_SDM_STATUS_DURA]
    DIS_CHANNEL,           -- Distribution Channel [CRMT_DISTRIBUTION_CHANNEL]
    DIVISION,              -- Division [CRMT_DIVISION]
    SERVICE_ORG_ORI,       -- Origin srvc. org. [CRMT_SERVICE_ORG_ORIGIN]
    SERVICE_ORGR_ORI,      -- Origin Sales Org. [CRMT_SERVICE_ORG_RESP_ORIGIN]
    SALES_ORG_ORI,         -- Origin sales org. [CRMT_SALES_ORG_ORIGIN]
    DIS_CHANNEL_ORI,       -- Origin: Distr. chnl [CRMT_DIS_CHANNEL_ORIGIN]
    SALES_OFF_ORI,         -- Origin: Sales office [CRMT_SALES_OFFICE_ORIGIN]
    SALES_GROUP_ORI,       -- Origin: Sales group [CRMT_SALES_GROUP_ORIGIN]
    SALES_ORGR_ORI,        -- Origin SOrg [CRMT_SALES_ORG_RESP_ORIGIN]
    DIVISION_ORI,          -- Origin: Division [CRMT_DIVISION_ORIGIN]
    SALES_ORG,             -- Sales Org. ID [CRMT_SALES_ORG]
    SALES_OFFICE,          -- Sales Office [CRMT_SALES_OFFICE]
    SALES_GROUP,           -- Sales Group [CRMT_SALES_GROUP]
    SALES_ORG_RESP,        -- Org. Unit (Sales) [CRMT_SALES_ORG_RESP]
    SERVICE_ORG,           -- Service Organization [CRMT_SERVICE_ORG]
    SERVICE_ORG_RESP,      -- OU (Service) [CRMT_SERVICE_ORG_RESP]
    SALES_ORG_SD,          -- Sales Org. [VKORG]
    SALES_OFFICE_SD,       -- Sales Office [VKBUR]
    SALES_GROUP_SD,        -- Sales Group [VKGRP]
    SALES_REP,             -- Sales Rep [CRMS4_SALES_REP]
    PERSON_RESP,           -- Employee Resp. [CRMT_PERSON_RESP]
    CONTACT_PERSON,        -- Contact Pers. [CRMT_CONTACT_PERSON]
    SALES_PROSPECT,        -- Sales Prospect [CRMS4_SALES_PROSPECT]
    PAYER,                 -- Payer [CRMT_RP_PAYER]
    COMPETITOR,            -- Competitor [CRMS4_COMPETITOR]
    INBOX_ASSIGNED_TO,     -- Employee Resp. [CRMT_PERSON_RESP]
    INBOX_GROUP_ASSIGNED,  -- Responsible Group [CRMT_RESPONSIBLE_GROUP]
    INBOX_ACCOUNT,         -- Sales Partners [CRMT_SALESPARTNER]
    INBOX_CONTACT_PERSON,  -- Contact Pers. [CRMT_CONTACT_PERSON]
    EXCHG_TYPE,            -- Exch. Rate Type [CRMT_EXCHG_TYPE]
    EXCHG_DATE,            -- Exch. Rate Date [CRMT_EXCHG_DATE]
    TAXJURCODE,            -- Jurisdict.Code [CRMT_TAXJURCODE]
    CUST_PRIC_PROC,        -- Cust.Pric.Proc. [CRMT_CUST_PRIC_PROC]
    REF_CURRENCY,          -- Ref. Currency [CRMT_REF_CURRENCY]
    CURRENCY,              -- Currency [CRMT_CURRENCY]
    PRICE_DATE,            -- Pricing Date [CRMT_PRICE_DATE]
    PMNTTRMS,              -- Terms of Paymnt [CRMT_PMNTTRMS]
    PRICE_GRP,             -- Price Group [CRMT_PRICE_GRP]
    CUST_GROUP,            -- Customer Group [CRMT_CUST_GROUP]
    EXCHG_RATE,            -- Exchange Rate [CRMT_EXCHG_RATE]
    TAX_DEST_CTY,          -- Dest.Ctry/Reg. [CRMT_TAX_DEST_CTY]
    TAX_DEST_REG,          -- Region [CRMT_REGION]
    VAT_REG_NO,            -- Sales tax no. [CRMT_VAT_REG_NO]
    AC_INDICATOR,          -- Account. Indic. [CRMT_AC_INDICATOR]
    CUSTOMER_TYPE,         -- Part. Type [CRMT_CUSTOMER_TYPE]
    PAYMENT_METHOD,        -- Payment Method [CRMT_BUAG_PAYMETH]
    REGION,                -- Region [CRMT_REGION]
    INDUSTRY,              -- Industry Sector [CRMT_INDUSTRY]
    CUST_GROUP1,           -- Customer Grp 1 [CRMT_CUST_GROUP1]
    CUST_GROUP2,           -- Customer Grp 2 [CRMT_CUST_GROUP2]
    CUST_GROUP3,           -- Customer Grp 3 [CRMT_CUST_GROUP3]
    CUST_GROUP4,           -- Customer Grp 4 [CRMT_CUST_GROUP4]
    CUST_GROUP5,           -- Customer Grp 5 [CRMT_CUST_GROUP5]
    PO_NUMBER_SOLD,        -- Ext. Reference [CRMT_PO_NUMBER_SOLD]
    PO_DATE_SOLD,          -- Reference Date [CRMT_PO_DATE_SOLD]
    YOUR_REF_SOLD,         -- Your Reference [CRMT_YOUR_REFERENCE_SOLD]
    PO_NUMBER_SHIP,        -- Ext. Reference [CRMT_PO_NUMBER_SHIP]
    PO_DATE_SHIP,          -- Reference Doc SH [CRMT_PO_DATE_SHIP]
    YOUR_REF_SHIP,         -- Your Reference [CRMT_YOUR_REFERENCE_SHIP]
    USAGE_TYPE,            -- Usage [CRMT_USAGE]
    SUBMISSION,            -- Collective No. [CRMT_SUBMISSION]
    REJECTION,             -- Cancel Rsn Code [CRMT_REJECTION_CODE]
    PROBABILITY,           -- Probability % [CRMT_ORDER_PROBABILITY]
    DATE_QTY_FIXED,        -- Fixed Date/Qty [CRMT_DATE_QTY_FIXED]
    REQ_DLV_DATE_H,        -- Rqstd Deliv. Date [CRMT_REQ_DLV_DATE]
    REQ_TIMEZONE_H,        -- Time Zone [CRMT_REQ_DATE_TIMEZONE]
    RULE_REQ_DATE_H,       -- Rule ReqDelDate [CRMT_RULE_REQ_DATE]
    STAT_LIFECYCLE,        -- Life Cycle Status [CRMS4_STAT_LIFECYCLE]
    STAT_LIFECYCLE_OPPT,   -- Lifecycle Status [CRMS4_STAT_LIFECYCLE_OPPT]
    STAT_ERROR,            -- Error Status [CRMS4_STAT_ERROR]
    STAT_ARCHIVABLE,       -- Archivable [CRMS4_STAT_ARCHIVABLE]
    STAT_ARCHIVED,         -- Archived [CRMS4_STAT_ARCHIVED]
    STAT_OPEN,             -- Open [CRMS4_STAT_OPEN]
    STAT_DUPLICATE,        -- Duplicate [CRMS4_STAT_DUPLICATE]
    INBOX_STATUS,          -- Status [CRMT_AUI_STATUS]
    STAT_NOTIF_REQUIRED,   -- Status Notificat.Req [CRMS4_STAT_NOTIF_REQUIRED]
    OPPT_H_DUMMY_PS,       -- Single-Character Flag [CHAR1]
    PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID)
);

Learn More