T5E33

Assign countries to Social Insurance key (RED System) | #other | Component: Spain
Column Name Description
MANDT FK Client
LAND1 FK Country/Region Key
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
LARED RED System: Country code CHAR3
NARED RED system: Nationality key CHAR3
ILAND Country code LAND1
CPSHA Country code according to the Internal Revenue Service CHAR3
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • T5E33.LAND1 == T005.LAND1
  • T5E33.MANDT == T005.MANDT
Client T5E33.MANDT == T000.MANDT