T5E12

Assignment of Social Insurance center | #other | Component: Spain
Column Name Description
MANDT FK Client
NISSE FK Company CA code
ENDDA End Date
Column Name Description
Column Name Description
Column Name Description
ENDDA End Date
BEGDA Start Date
Column Name Description
REGIMEN RED system: Social Insurance category Show values
TIPO_IDEN RED system: Identification type Show values
TIPO_EMPRE Alphabetical type for employer Show values
COMPANY_EE_IND Number of company employees indicator Show values
Column Name Description Domain name
NISSC Center identifier NUM3
SECTOR RED system: Social Insurance sector NUMC2
CALIFIC RED system: Company code classifier CHAR2
RAZON_SOC Registered company name CHAR55
CONTACTO RED system: Contact employee TEXT34
TELEFONO RED system: Telephone number CHAR12
FAX RED system: Fax number CHAR12
DOMICIL Address TEXT32
CODPOS Postal code NUM5
LOCALIDAD Town PES_LOCAL
DENO_EXPLO Name of activity CHAR40
AEPTX Description of the company's main economic activity TEXT80
Master Data Relations | to Other Relations ↓ Join Conditions
Company group/grouping indentifier
  • T5E12.MANDT == T5E11.MANDT
  • T5E12.GROUP_ID == T5E11.GROUP_ID
Client check T5E12.MANDT == T000.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Town code according to SEPE
  • Town code according to SEPE
  • ?
  • T5E12.MANDT == T5E35.MANDT
  • T5E12.COD_LOC == T5E35.COD_LOC
  • T5E12.[column in domain "PSTLZ_HR"] == T5E35.COD_POS
Check existence of entries in T5E04
  • Company CA code
  • Client
  • ?
  • T5E12.NISSE == T5E08.NISSE
  • T5E12.MANDT == T5E08.MANDT
  • T5E12.[column in domain "ENDDA"] == T5E08.ENDDA