CRMS4D_OPPT_I

Transparent Table Application Table
167 Fields 3 CDS Views

Item details of Opportunities and Leads

CRMS4D_OPPT_I is an SAP database table in S/4HANA. Item details of Opportunities and Leads. It contains 167 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
CRMS4_OPPT_I_SEARCH view from Opportunity/Lead Item
E_PresalesDocumentItem view from EXTENSION Presales Document Item Extension
I_PresalesDocumentItem view from BASIC Presales Document Item

Fields (167)

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
KEY number_int CRMS4_NUMBER_INT Item Number in Doc.
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
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
btx_class CRMT_TRANSACTION_CLASSIFICATN Trans.Classification
auth_scope CRM_AUTH_SCOPE Authorization Scope
archiving_flag CRMT_ARCHIVING_FLAG Can Be Archived
item_guid CRMT_OBJECT_GUID Object GUID
created_at_i COMT_CREATED_AT_USR Created At
created_by_i CRMT_CREATED_BY Created By
changed_at_i COMT_CHANGED_AT_USR Changed On
changed_by_i CRMT_CHANGED_BY Changed By
objtype_i CRMT_SWO_OBJTYP_PROCESS_ITM_DB Object Type
header_guid CRMT_OBJECT_GUID Object GUID
parent CRMT_OBJECT_GUID Object GUID
alternative CRMT_OBJECT_GUID Object GUID
product CRMT_PRODUCT_GUID_DB Product GUID
ordered_prod CRMT_ORDERED_PROD_DB Product
partner_prod CRMT_ITEM_DESCR_PARTNER Partner Product
description_i CRMT_PRSHTEXTX_DB Short Text
itm_language CRMT_ITEM_LANGU Language
number_ext CRMT_ITEM_NO_EXT Ext. Item No.
itm_type CRMT_ITEM_TYPE_DB Item Category
order_date CRMT_ORDER_DATE Posting Date
itm_usage CRMT_ITEM_USAGE Usage HL Item
itm_type_usage CRMT_IT_TYPE_USAGE Item Cat. Usage
product_kind CRMT_PRODUCT_KIND Prod. Tech. Typ
revacc_refid CRMT_REVACC_REFID RA Reference ID
revacc_reftype CRMT_REVACC_REFTYPE RA Reference Type
revacc_relevant_type CRMT_REVACC_RELEVANT_TYPE Type
product_id PRODUCTNUMBER Product
item_guid_char CRMT_OBJECT_GUID32 Object GUID
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
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
net_value_man_i CRMT_NET_VALUE_MAN Exp.Total Value
cost_amount_man CRMT_COST_AMOUNT_MAN Exp. Total Cost
statistical CRMT_STATISTICAL Statist.value
prc_indicator CRMT_PRICING_INDICATOR Pric. indicat.
net_value_i CRMT_NET_VALUE Net Value
net_price_i CRMT_NET_PRICE Net price
tax_amount_i CRMT_TAX_AMOUNT Tax amount
freight_i CRMT_FREIGHT Shipment costs
gross_value_i CRMT_GROSS_VALUE Gross Value
net_wo_freight_i PRCT_NET_VALUE_WITHOUT_FREIGHT Net value
subtotal1 CRMT_SUBTOTAL1 Subtotal 1
subtotal2 CRMT_SUBTOTAL2 Subtotal 2
subtotal3 CRMT_SUBTOTAL3 Subtotal 3
subtotal4 CRMT_SUBTOTAL4 Subtotal 4
subtotal5 CRMT_SUBTOTAL5 Subtotal 5
subtotal6 CRMT_SUBTOTAL6 Subtotal 6
credit_indicator CRMT_CREDIT_INDICATOR Credit
netpr_pric_unit PRCT_COND_PRICING_UNIT Price Unit
netpr_uom PRCT_COND_UOM Condition Unit
total_discount_i PRCT_COND_VALUE Condition Value
gross_weight_i CRMT_GROSS_WEIGHT Gross Weight
net_weight_i CRMT_NET_WEIGHT Net Weight
weight_unit_i COMT_WEIGHT_UNIT Unit of Weight
volume_i CRMT_VOLUME Volume
volume_unit_i COMT_VOLUME_UNIT Volume Unit
price_product CRMT_PRICE_PRODUCT PricingRefProd.
process_qty_num CRMT_PROCESS_QTY_NUM Numerator
process_qty_den CRMT_PROCESS_QTY_DEN Denominator
exponent10 CRMT_EXPONENT10 Exponent
process_qty_unit CRMT_PROCESS_QTY_UNIT Sales Unit
comm_group CRMT_COMM_GROUP Commission Grp
rebate_group CRMT_REBATE_GROUP Vol. Rebate Grp
cash_disc CRMT_CASH_DISC Qual.for Cash Discnt
prod_pr_group CRMT_PROD_PR_GROUP Product Group
prc_group1 CRMT_PRC_GROUP1 Product Group 1
prc_group2 CRMT_PRC_GROUP2 Product Group 2
prc_group3 CRMT_PRC_GROUP3 Product Group 3
prc_group4 CRMT_PRC_GROUP4 Product Group 4
prc_group5 CRMT_PRC_GROUP5 Product Group 5
prod_hierarchy CRMT_PROD_HIERARCHY Product Cat.
base_qty_unit COMT_PRODUCT_BASE_UOM BUoM
plant WERKS_D Plant
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
order_qty CRMT_QTY_ORDER Order Quantity
first_req_date CRMS4_FIRST_REQ_DATE First Rqstd Dlv Date
item_no_appt CRMS4_NUMBER_INT Item Number in Doc.
item_no_partner CRMS4_NUMBER_INT Item Number in Doc.
item_no_qualif CRMS4_NUMBER_INT Item Number in Doc.
item_no_refobj CRMS4_NUMBER_INT Item Number in Doc.
item_no_subject CRMS4_NUMBER_INT Item Number in Doc.
item_no_survey CRMS4_NUMBER_INT Item Number in Doc.
item_no_billplan CRMS4_NUMBER_INT Item Number in Doc.
item_no_payplan CRMS4_NUMBER_INT Item Number in Doc.
ref_guid_appt CRMT_OBJECT_GUID Object GUID
oppt_i_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.

-- Item 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_I (
    CLIENT,                -- Client [MANDT]
    OBJTYPE_H,             -- Trans. Cat. [CRMT_SUBOBJECT_CATEGORY_DB]
    OBJECT_ID,             -- Transaction ID [CRMT_OBJECT_ID_DB]
    NUMBER_INT,            -- Item Number in Doc. [CRMS4_NUMBER_INT]
    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]
    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]
    BTX_CLASS,             -- Trans.Classification [CRMT_TRANSACTION_CLASSIFICATN]
    AUTH_SCOPE,            -- Authorization Scope [CRM_AUTH_SCOPE]
    ARCHIVING_FLAG,        -- Can Be Archived [CRMT_ARCHIVING_FLAG]
    ITEM_GUID,             -- Object GUID [CRMT_OBJECT_GUID]
    CREATED_AT_I,          -- Created At [COMT_CREATED_AT_USR]
    CREATED_BY_I,          -- Created By [CRMT_CREATED_BY]
    CHANGED_AT_I,          -- Changed On [COMT_CHANGED_AT_USR]
    CHANGED_BY_I,          -- Changed By [CRMT_CHANGED_BY]
    OBJTYPE_I,             -- Object Type [CRMT_SWO_OBJTYP_PROCESS_ITM_DB]
    HEADER_GUID,           -- Object GUID [CRMT_OBJECT_GUID]
    PARENT,                -- Object GUID [CRMT_OBJECT_GUID]
    ALTERNATIVE,           -- Object GUID [CRMT_OBJECT_GUID]
    PRODUCT,               -- Product GUID [CRMT_PRODUCT_GUID_DB]
    ORDERED_PROD,          -- Product [CRMT_ORDERED_PROD_DB]
    PARTNER_PROD,          -- Partner Product [CRMT_ITEM_DESCR_PARTNER]
    DESCRIPTION_I,         -- Short Text [CRMT_PRSHTEXTX_DB]
    ITM_LANGUAGE,          -- Language [CRMT_ITEM_LANGU]
    NUMBER_EXT,            -- Ext. Item No. [CRMT_ITEM_NO_EXT]
    ITM_TYPE,              -- Item Category [CRMT_ITEM_TYPE_DB]
    ORDER_DATE,            -- Posting Date [CRMT_ORDER_DATE]
    ITM_USAGE,             -- Usage HL Item [CRMT_ITEM_USAGE]
    ITM_TYPE_USAGE,        -- Item Cat. Usage [CRMT_IT_TYPE_USAGE]
    PRODUCT_KIND,          -- Prod. Tech. Typ [CRMT_PRODUCT_KIND]
    REVACC_REFID,          -- RA Reference ID [CRMT_REVACC_REFID]
    REVACC_REFTYPE,        -- RA Reference Type [CRMT_REVACC_REFTYPE]
    REVACC_RELEVANT_TYPE,  -- Type [CRMT_REVACC_RELEVANT_TYPE]
    PRODUCT_ID,            -- Product [PRODUCTNUMBER]
    ITEM_GUID_CHAR,        -- Object GUID [CRMT_OBJECT_GUID32]
    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]
    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]
    NET_VALUE_MAN_I,       -- Exp.Total Value [CRMT_NET_VALUE_MAN]
    COST_AMOUNT_MAN,       -- Exp. Total Cost [CRMT_COST_AMOUNT_MAN]
    STATISTICAL,           -- Statist.value [CRMT_STATISTICAL]
    PRC_INDICATOR,         -- Pric. indicat. [CRMT_PRICING_INDICATOR]
    NET_VALUE_I,           -- Net Value [CRMT_NET_VALUE]
    NET_PRICE_I,           -- Net price [CRMT_NET_PRICE]
    TAX_AMOUNT_I,          -- Tax amount [CRMT_TAX_AMOUNT]
    FREIGHT_I,             -- Shipment costs [CRMT_FREIGHT]
    GROSS_VALUE_I,         -- Gross Value [CRMT_GROSS_VALUE]
    NET_WO_FREIGHT_I,      -- Net value [PRCT_NET_VALUE_WITHOUT_FREIGHT]
    SUBTOTAL1,             -- Subtotal 1 [CRMT_SUBTOTAL1]
    SUBTOTAL2,             -- Subtotal 2 [CRMT_SUBTOTAL2]
    SUBTOTAL3,             -- Subtotal 3 [CRMT_SUBTOTAL3]
    SUBTOTAL4,             -- Subtotal 4 [CRMT_SUBTOTAL4]
    SUBTOTAL5,             -- Subtotal 5 [CRMT_SUBTOTAL5]
    SUBTOTAL6,             -- Subtotal 6 [CRMT_SUBTOTAL6]
    CREDIT_INDICATOR,      -- Credit [CRMT_CREDIT_INDICATOR]
    NETPR_PRIC_UNIT,       -- Price Unit [PRCT_COND_PRICING_UNIT]
    NETPR_UOM,             -- Condition Unit [PRCT_COND_UOM]
    TOTAL_DISCOUNT_I,      -- Condition Value [PRCT_COND_VALUE]
    GROSS_WEIGHT_I,        -- Gross Weight [CRMT_GROSS_WEIGHT]
    NET_WEIGHT_I,          -- Net Weight [CRMT_NET_WEIGHT]
    WEIGHT_UNIT_I,         -- Unit of Weight [COMT_WEIGHT_UNIT]
    VOLUME_I,              -- Volume [CRMT_VOLUME]
    VOLUME_UNIT_I,         -- Volume Unit [COMT_VOLUME_UNIT]
    PRICE_PRODUCT,         -- PricingRefProd. [CRMT_PRICE_PRODUCT]
    PROCESS_QTY_NUM,       -- Numerator [CRMT_PROCESS_QTY_NUM]
    PROCESS_QTY_DEN,       -- Denominator [CRMT_PROCESS_QTY_DEN]
    EXPONENT10,            -- Exponent [CRMT_EXPONENT10]
    PROCESS_QTY_UNIT,      -- Sales Unit [CRMT_PROCESS_QTY_UNIT]
    COMM_GROUP,            -- Commission Grp [CRMT_COMM_GROUP]
    REBATE_GROUP,          -- Vol. Rebate Grp [CRMT_REBATE_GROUP]
    CASH_DISC,             -- Qual.for Cash Discnt [CRMT_CASH_DISC]
    PROD_PR_GROUP,         -- Product Group [CRMT_PROD_PR_GROUP]
    PRC_GROUP1,            -- Product Group 1 [CRMT_PRC_GROUP1]
    PRC_GROUP2,            -- Product Group 2 [CRMT_PRC_GROUP2]
    PRC_GROUP3,            -- Product Group 3 [CRMT_PRC_GROUP3]
    PRC_GROUP4,            -- Product Group 4 [CRMT_PRC_GROUP4]
    PRC_GROUP5,            -- Product Group 5 [CRMT_PRC_GROUP5]
    PROD_HIERARCHY,        -- Product Cat. [CRMT_PROD_HIERARCHY]
    BASE_QTY_UNIT,         -- BUoM [COMT_PRODUCT_BASE_UOM]
    PLANT,                 -- Plant [WERKS_D]
    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]
    ORDER_QTY,             -- Order Quantity [CRMT_QTY_ORDER]
    FIRST_REQ_DATE,        -- First Rqstd Dlv Date [CRMS4_FIRST_REQ_DATE]
    ITEM_NO_APPT,          -- Item Number in Doc. [CRMS4_NUMBER_INT]
    ITEM_NO_PARTNER,       -- Item Number in Doc. [CRMS4_NUMBER_INT]
    ITEM_NO_QUALIF,        -- Item Number in Doc. [CRMS4_NUMBER_INT]
    ITEM_NO_REFOBJ,        -- Item Number in Doc. [CRMS4_NUMBER_INT]
    ITEM_NO_SUBJECT,       -- Item Number in Doc. [CRMS4_NUMBER_INT]
    ITEM_NO_SURVEY,        -- Item Number in Doc. [CRMS4_NUMBER_INT]
    ITEM_NO_BILLPLAN,      -- Item Number in Doc. [CRMS4_NUMBER_INT]
    ITEM_NO_PAYPLAN,       -- Item Number in Doc. [CRMS4_NUMBER_INT]
    REF_GUID_APPT,         -- Object GUID [CRMT_OBJECT_GUID]
    OPPT_I_DUMMY_PS,       -- Single-Character Flag [CHAR1]
    PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID, NUMBER_INT)
);

Learn More