SAP ACMHEXDB_SCARR ACMHEX: Airlines (DBTable) Table

Overview

ACMHEXDB_SCARR is a standard SAP S/4HANA table that stores ACMHEX: Airlines (DBTable) data. There are total 5 fields in the ACMHEXDB_SCARR table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ACMHEXDB_SCARR belongs to Data Control Language (DCL) (Define Authorizations for CDS) (BC-SEC-AUT-DCL) module and is located in the package Hierarchy Example (SACMHIEREX).

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

Techincal Settings of ACMHEXDB_SCARR

Below are technical details of the table ACMHEXDB_SCARR

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

List of ACMHEXDB_SCARR Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDT*CLNT3
CARRIDACMHEX: Carrier-ID (=Airline-ID)ACMHEX_CARR_IDCHAR3
CARRNAMEACMHEX: Carrier Name (=Airline Name)ACMHEX_CARR_NAMECHAR20
COUNTRYCountry/Region KeyLAND1ACMHEXDB_SCOUNTRCHAR3
URLACMHEX: Carrier URL (=Airline URL)ACMHEX_CARR_URLCHAR255

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 ACMHEXDB_SCARR

Table NameFieldCardinalityCheck Table
ACMHEXDB_SCARRCOUNTRY:ACMHEXDB_SCOUNTR
ACMHEXDB_SCARRCURRCODE:ACMHEXDB_SCURREN

Other References