GENDER in SMI_USR_IDENTITY
Gender (DE: Geschlecht)
GENDER is a field in SAP table SMI_USR_IDENTITY (User Identity). It represents "Gender". Data element: SMI_GENDERCODE. Available in 2 CDS view(s) as GenderCode.
Business Meaning
| Description (EN) | Gender |
|---|---|
| Beschreibung (DE) | Geschlecht |
| Data Element | SMI_GENDERCODE |
| Key Field | No |
CDS Views & Technical Names (2)
SMI_USR_IDENTITY.GENDER is exposed in CDS views under the following technical name. Views reading the table directly are listed first; "via" marks views that pass the field on through intermediate views.
GenderCode
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_Somi_Usr_Identity | direct | BASIC | Idenitity of user provided by Data Provider | |
| C_Smi_Usr_Consolidate | via 2 level | CONSUMPTION | Consumption view for User Information from Data Provider |
Other Tables with Field GENDER (14)
| Table | Data Element | Key | Description |
|---|---|---|---|
| ACMTST_DB_EMPL | ACMTST_GENDER | ACMTST: Employee (DB-Table) | |
| BUT000 | BU_SEXID | BP: General data I | |
| BUT000_PRC | BU_SEXID | Master Data Consolidation: Process Table for BUT000 | |
| BUT000_SRC | BU_SEXID | Master Data Consolidation: Source Table for BUT000 | |
| CRMM_ICM_BP_AID | BU_SEXID | ICM BP Alternative Identity Master Data | |
| DEMO_SALES_BUPA | ABAP.CHAR | Business Partner | |
| SMI_USR_PROFILE | SMI_GENDERCODE | User Profile | |
| SNWD_BP_CRM | ABAP.CHAR | EPM HANA DG: CRM Business Partner Table (non-EPM) | |
| T77PAD_GENDER | HRPAD_GENDER | KEY | Gender |
| T77PAD_GENDER_T | HRPAD_GENDER | KEY | Texts for Gender |
| TB995 | BU_SEXID | KEY | BP Gender |
| TB995T | BU_SEXID | KEY | BP Gender : Text |
| TSAD15 | AD_SEX | KEY | Gender key (Business Address Services) |
| TSAD15T | AD_SEX | KEY | Gender Text (Business Address Services) |
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA