T7SA17H

Sponsor ID Entity Table | #masterdata | Component: Kingdom of Saudi Arabia
Column Name Description
MANDT FK Client
SPONR Sponsor Id
Column Name Description
Column Name Description
Column Name Description
ISSDT Issue Date
EXPID expiry date
Column Name Description
Column Name Description Domain name
WKPNM Work Permit Number CHAR20
BUSIN Company Business Activity Type TEXT30
ISSPL Place of Issue of Identification TEXT30
OWNER Sponsor Owner Name TEXT20
OFFIC Sponsor officer in charge name TEXT20
TITLE Sponsor officer in charge title TEXT20
FLENM Sponsor File number at labor office TEXT10
Master Data Relations Join Conditions
Address Number
  • Address Number
  • ?
  • ?
  • T7SA17H.MANDT == ADRC.CLIENT
  • T7SA17H.ADRNR == ADRC.ADDRNUMBER
  • T7SA17H.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • T7SA17H.[column in domain "AD_NATION"] == ADRC.NATION
Client T7SA17H.MANDT == T000.MANDT
Work Permit Type
  • T7SA17H.MANDT == T7SA32.MANDT
  • T7SA17H.WKPTY == T7SA32.WKPTY