P_SpecPropertyNumSearch

Search via characteristics of type NUM | view: PSPECPRPNUMSRCH | Extraction: Not supported | Component: Product Safety
Tables used: AUSPESTVAESTVH
Column Name Description
estrh_recn FK Sequential Number of Data Record
estvh_recn FK Reference to Value Assignment Header
estva_recn Sequential Number of Data Record
estcat FK Value Assignment Type
atinn Internal characteristic
atcod Code for value dependency Show values
atflv Internal floating point from
atflb Internal floating point value to
valfr Valid-From Date
valto Valid-To Date
Column Name Description
Column Name Description
Column Name Description
valfr Valid-From Date
valto Valid-To Date
Column Name Description
atcod Code for value dependency Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Value Assignment Type
  • Value Assignment Type
  • Client
  • P_SPECPROPERTYNUMSEARCH.ESTCAT == TCG11.ESTCAT
  • P_SPECPROPERTYNUMSEARCH.MANDT == TCG11.MANDT
EHS: Relationship for Value Assignment Type
  • ?
  • Reference to Value Assignment Header
  • P_SPECPROPERTYNUMSEARCH.[column in domain "ESERECN"] == ESTVH.RECN
  • P_SPECPROPERTYNUMSEARCH.ESTVH_RECN == ESTVH.MANDT