SAP ATO_ITEMS Key User adaptation Items Table

Overview

ATO_ITEMS is a standard SAP S/4HANA table that stores Key User adaptation Items data. There are total 11 fields in the ATO_ITEMS table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ATO_ITEMS belongs to Manage and Import Software Collections (BC-SRV-APS-EXT-SL) module and is located in the package Collection based core functions - internal use w/o transl. (S_ATO_COL_CORE).

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

Techincal Settings of ATO_ITEMS

Below are technical details of the table ATO_ITEMS

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of ATO_ITEMS Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
ITEM_IDATO Item IDATO_ITEM_IDCHAR60
TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TIMESTAMPDEC15
ORIGINAL_SYSTEM_TYPEIdentify the original system of an ATO entityATO_ORIGINAL_SYSTEM_IDCHAR1
CHANGED_BYLast Changed ByAS4USERCHAR12
ITEM_DESCRIPTIONDescription of an adaptation ItemATO_ITEM_DESCRIPTIONCHAR127
ITEM_STATUSStatus of ATO ItemsATO_ITEM_STATUSCHAR1
CHANGEREASON_Ireason for a change of an ATO itemATO_CHANGEREASONCHAR1
LAST_NOTIFICATIONUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TIMESTAMPDEC15
TRANSPORTATION_MODETransportation ModeATO_TRANSPORTATION_MODECHAR1
CHANGED_IN_BATCHBoolean Variable (X = True, - = False, Space = Unknown)BOOLEANCHAR1
FINISH_STATUSStatus of Item Finish CallATO_ITEM_FINISH_STATUSCHAR1

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 ATO_ITEMS

Table NameFieldCardinalityCheck Table
ATO_ITEMSITEM_TYPE1: CNATO_ADAPT_TYPES

Other References