ESTDF

Additional Information - User-Defined Text | #masterdata | Component: Product Safety
Column Name Description
MANDT FK Client
RECN Sequential Number of Data Record
ACTN Sequential Number of the Change State
Column Name Description
Column Name Description
Column Name Description
VALFR Valid-From Date
VALTO Valid-To Date
CRDAT Created On
UPDDAT Last Changed On
DOCDATE Document Date
Column Name Description
DELFLG Deletion Indicator Show values
PARKFLG Data Record Is Inactive Show values
LTXTFLG Long Text Show values
FORMATFLG Formatted Show values
Column Name Description Domain name
CRNAM Created By USNAM
UPDNAM Last Changed By USNAM
NAMEMST Name of Master Table CHAR30
RECNMST Reference to Master Table ESDRECN
ORD Sort Order NUMC4
HEADER Start of User-Defined Text TEXT132
DOKTL Document Part DOKTL
Master Data Relations Join Conditions
Change Number
  • Change Number
  • Client
  • ESTDF.AENNR == AENR.AENNR
  • ESTDF.MANDT == AENR.MANDT
Document Type
  • Document Type
  • Client
  • ESTDF.DOKAR == TDWA.DOKAR
  • ESTDF.MANDT == TDWA.MANDT
Language ESTDF.LANGU == T002.SPRAS
Client ESTDF.MANDT == T000.MANDT
EHS: Foreign Key for Substance Authorization Group
  • ESTDF.MANDT == TCG56.MANDT
  • ESTDF.SRSID == TCG56.SRSID
EHS: Foreign key for user-defined text category
  • ESTDF.MANDT == TCG41.MANDT
  • ESTDF.TEXTCAT == TCG41.TEXTCAT