P_SpecPropertyCharSearch

Search via characteristics of type CHAR | view: PSPECPRPCHARSRCH | 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
atwrt Characteristic Value
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
Column Name Description Domain name
Master Data Relations Join Conditions
Value Assignment Type
  • Client
  • Value Assignment Type
  • P_SPECPROPERTYCHARSEARCH.MANDT == TCG11.MANDT
  • P_SPECPROPERTYCHARSEARCH.ESTCAT == TCG11.ESTCAT
EHS: Relationship for Value Assignment Type
  • Reference to Value Assignment Header
  • ?
  • P_SPECPROPERTYCHARSEARCH.ESTVH_RECN == ESTVH.MANDT
  • P_SPECPROPERTYCHARSEARCH.[column in domain "ESERECN"] == ESTVH.RECN