SAP ACE_SOP_INDTYPE Type of Index Used for Award Program Table

Overview

ACE_SOP_INDTYPE is a standard SAP S/4HANA table that stores Type of Index Used for Award Program data. There are total 7 fields in the ACE_SOP_INDTYPE table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ACE_SOP_INDTYPE belongs to Provisions for Awards (FI-GL-GL-SOA) module and is located in the package Stock Option Accounting (FI-SOA).

In addition, following links provide an overview of foreign key relationships, if any, that link ACE_SOP_INDTYPE to other SAP tables and standard CDS views available based on ACE_SOP_INDTYPE table in S/4HANA 2020.

Techincal Settings of ACE_SOP_INDTYPE

Below are technical details of the table ACE_SOP_INDTYPE

  • Buffering switched on
  • Full table is passed to buffer
  • Storage type is Column Store

List of ACE_SOP_INDTYPE Fields

The following table gives you an overview of the fields available in ACE_SOP_INDTYPE

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDT*CLNT3
BUKRSCompany CodeBUKRS*CHAR4
AWARDAwardACE_SOP_AWARDCHAR4
IDXSecurities IndexIDXINDEXDCHAR10
INDEX_TYPEIndex TypeIDXARTINDEXACHAR2
INDEX_CURRCurrency KeyWAERSTCURCCUKY5
INDEX_CURR_TYPEExchange rate typeKURST_CURRTCURVCHAR4

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ACE_SOP_INDTYPE

Table NameFieldCardinalityCheck Table
ACE_SOP_INDTYPEIDX:INDEXD
ACE_SOP_INDTYPEINDEX_CURR:TCURC
ACE_SOP_INDTYPEINDEX_CURR_TYPE:TCURV
ACE_SOP_INDTYPEINDEX_TYPE:INDEXA

Other References