ESTALE SAP table for – EHS: ALE – reference to originals

Here we would like to draw your attention to ESTALE table in SAP. As we know it is being mainly used with the SAP EHS-SAF (Product Safety in EHS) component which is coming under EHS module (Environment, Health and Safety). ESTALE is a SAP standard transp table used for storing EHS: ALE – reference to originals related data in SAP. It comes under the package CBUI.

SAP ESTALE table

Table ESTALE technical data

TableESTALE
Data storingEHS: ALE – reference to originals
ModuleEHS
Sub ModuleEHS-SAF
SAP PackageCBUI
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP ESTALE Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in ESTALE table.

  • .INCLUDE : EHS: Structure for key info of master data
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RECN : Sequential Number of Data Record
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
  • ACTN : Sequential Number of the Change State
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
  • LOGSYS : Logical system
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • ALE_OBJECT : Single-Character Flag
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • OBJECTID : Data Element Type CHAR Length 35
    Its a key field. Its data type is CHAR (Character String) with field length 35
  • RECN_LOC : Sequential Number of Data Record
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • ACTN_LOC : Sequential Number of the Change State
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • TABLENAME : Single-Character Flag
    Its data type is CHAR (Character String) with field length 1