Sunday, May 19, 2024

SAP Table ATLA – Limit Type

ATLA is a standard SAP table in SAP ERP (or) S/4HANA which stores Limit Type data. There are total 18 fields in ATLA table.This blog post provides key technical details of SAP table ATLA, including its availability across SAP S/4HANA versions and the list of CDS views for ATLA table in SAP.

SAP HANA Table Type Not Defined
Buffering Permission Buffering switched on
Buffering Type Full table is passed to buffer
Package CRA Limit Management (FTLM)
Technical Component Limit Management (FIN-FSCM-TRM-CR-LM)

SAP ATLA Table Fields

The following is the list of fields that are available in SAP ATLA table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type
MANDT Client MANDT MANDT T000 CLNT (3)
SLA Limit Type TB_SLA T_SLA CHAR (3)
SLE Determination Procedure for Limit Utilizations TB_SLE KL_DETPROC KLEVDEF NUMC (2)
SLD Transactions Included for Limit Management TB_SLD T_SLD NUMC (1)
SLVC Generate Limits Automatically TB_SLVC TB_SLVC CHAR (1)
SLSC Update Category TB_SLSC TB_SLSC NUMC (1)
SPR Relationship Category of Business Partner TB_SPR BU_RELTYP TBZ9 CHAR (6)
SPS Evaluation Depth for Business Partner Relationships TB_SPS T_SPS NUMC (2)
SPD Attribution Direction TB_SPD TB_SPD NUMC (1)
RELACT Indicator for Limit Type: Is Release Active? TB_RELACT X CHAR (1)
RELSTAT Initital Status Used as a Basis for Release TB_RELSTAT TB_RELSTAT CHAR (1)
SLCOMM Take Single Transaction Commitment into Account TB_SLCOMM TB_SLCOMM CHAR (1)
SLGLSEC Include Global Collateral TB_SLGLSEC TB_SLGLSEC CHAR (1)
RSMP Review Period TB_RSMP NUM3 NUMC (3)
FRSM Review Deadline Before End of Validity Period TB_FRSM NUM3 NUMC (3)
WLIMIT Limit Currency TB_WLIMIT WAERS TCURC CUKY (5)
SIGTYP Early Warning Control TB_SIGTYP TB_SIGTYP NUMC (1)
EVFIL Selection Filter TB_EVFIL KL_EVFIL KLTAGENDSF CHAR (20)

Availability

The SAP table ATLA is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Available?
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for ATLA table

The following is the list of ATLA CDS views, which can also be used instead of ATLA table based on your business requirements.

CDS View CDS View Type Description
I_TRSYCTPTYLIMITTYPE BASIC Treasury Counterparty Limit Type
I_TRSYCTPTYLIMITOVERVIEWCUBE COMPOSITE Treasury Counterparty Limit Overview Cube
C_TRSYCTPTYLIMITOVERVIEWQ CONSUMPTION Treasury Counterparty Limit Overview Query