- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Asset Retirement Obligation Management for Oil & Gas (CA-ARO)
- Available to Promise (ATP) (CA-ATP)
- Bank (CA-BK)
- CA-VCM: Value Chain Management (CA-VCM)
- Classification (CA-CL)
- Commercial Project Management (CA-CPD)
- Cross functional developments in Asset Intell. N/W (CA-AIN)
- Cross-Application Objects in HR (CA-HR)
- Data Transformation (CA-DT)
- Document Management System (CA-DMS)
- Field Logistics (CA-FL)
- General Application Functions (CA-GTF)
- Integration from S/4HC to Master Data for Worker (CA-WFD)
- Issue & Activity Management (CA-IAM)
- Joint Venture und Production Sharing Accounting (CA-JVA)
- Landscape Transformation (CA-LT)
- Machine Learning (CA-ML)
- Master Data Governance. (CA-MDG)
- Master Data Integration Services (CA-MDI)
- PLM Audit Management (CA-AUD)
- Prepayment agreements (CA-PPA)
- Processes and Tools for Enterprise Applications (CA-EPT)
- Production Volume Capture (CA-PVL)
- Resource Scheduling (CA-RSH)
- SAP UI development toolkit for HTML5 - Rendering library (CA-UI5)
- Situation handling across applications, generic (CA-SIT)
- Time Sheet (CA-TS)
- Cross-Application Components (CA)
- Asset Retirement Obligation Management for Oil & Gas (CA-ARO)
- Available to Promise (ATP) (CA-ATP)
- Bank (CA-BK)
- CA-VCM: Value Chain Management (CA-VCM)
- Classification (CA-CL)
- Commercial Project Management (CA-CPD)
- Cross functional developments in Asset Intell. N/W (CA-AIN)
- Cross-Application Objects in HR (CA-HR)
- Data Transformation (CA-DT)
- Document Management System (CA-DMS)
- Field Logistics (CA-FL)
- General Application Functions (CA-GTF)
- Integration from S/4HC to Master Data for Worker (CA-WFD)
- Issue & Activity Management (CA-IAM)
- Joint Venture und Production Sharing Accounting (CA-JVA)
- Landscape Transformation (CA-LT)
- Machine Learning (CA-ML)
- Master Data Governance. (CA-MDG)
- Master Data Integration Services (CA-MDI)
- PLM Audit Management (CA-AUD)
- Prepayment agreements (CA-PPA)
- Processes and Tools for Enterprise Applications (CA-EPT)
- Production Volume Capture (CA-PVL)
- Resource Scheduling (CA-RSH)
- SAP UI development toolkit for HTML5 - Rendering library (CA-UI5)
- Situation handling across applications, generic (CA-SIT)
- Time Sheet (CA-TS)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
P_EmployeeAllAttribs
Employee All Attributes
| view: PEMPLOYEEALLATTR
| Extraction:
Not supported
| Component: HCM Business Partner Integration
Tables used:
ADCP, ADRC, /SHCM/HRP5090, /SHCM/HRP5092, BUT020, BNKA, BUT0BK, CVI_VEND_LINK, LFB1, WFD_D_JOBCODET, T002, USR21, ADR2, ADR3, ADR6, BUT000, MOM052, /SHCM/D_SOR_KY, HRP1000, T513S, WFD_D_NEW_PERS, T527X
- 🔑 Keys (1)
- 💰 Amounts
- ∑ Quantities
- 📅 Dates (10)
- ☰ Categorical (1)
- Other (51)
- 🔗 Relations (7)
| Column Name | Description | |
|---|---|---|
| EmployeeID | Identification Number |
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| ValidityStartDate | Start Date | |
| ValidityEndDate | End Date | |
| OriginalSystemStartDate | Date | |
| OriginalSystemEndDate | Date | |
| EmploymentStartDate | Start Date | |
| EmploymentEndDate | End Date | |
| EmploymentDetailsStartDate | Start Date | |
| EmploymentDetailsEndDate | End Date | |
| EmploymentMgrStartDate | Start Date | |
| EmploymentMgrEndDate | End Date |
| Column Name | Description | |
|---|---|---|
| EmploymentStatus | Model S: Employment Status | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| PersonnelNumber | Object ID | HROBJID | |
| GenderCode | Single-Character Flag | CHAR1 | |
| EmployeeImageURL | EMPLOYEE_IMAGE_URL | /SHCM/EMPLOYEE_IMAGE_URL | |
| CorrespondenceLanguage | 2-Character SAP Language Code | LAISO | |
| GivenName | First name of business partner (person) | BU_NAME | |
| FamilyName | Last name of business partner (person) | BU_NAME | |
| MiddleName | Middle name or second forename of a person | BU_NAME | |
| FormOfAddress | Form-of-Address Key | AD_TITLE | |
| AdditionalFamilyName | Other Last Name of a Person | BU_NAME | |
| EmployeeFullName | Full Name | TEXT80 | |
| Initials | "Middle Initial" or personal initials | CHAR10 | |
| AcademicTitle | Academic Title: Key | AD_TITLE1 | |
| FamilyNamePrefix | Name Prefix (Key) | AD_PREFIX | |
| OriginalSystem | System ID | CHAR80 | |
| HouseNumber | House Number | TEXT10 | |
| StreetName | Street | TEXT60 | |
| PostalCode | City postal code | CHAR10 | |
| CityName | City | TEXT40 | |
| District | District | TEXT40 | |
| CareOfName | c/o name | TEXT40 | |
| HomeAddressStartDate | Validity Start of a Business Partner Address | TZNTSTMPS | |
| HomeAddressEndDate | Validity End of a Business Partner Address | TZNTSTMPS | |
| StreetPrefixName | Street 2 | TEXT40 | |
| StreetSuffixName | Street 4 | TEXT40 | |
| AdditionalStreetPrefixName | Street 3 | TEXT40 | |
| AdditionalStreetSuffixName | Street 5 | TEXT40 | |
| HomeAddressMailAddress | E-Mail Address | AD_SMTPADR | |
| HomePhoneSubscriberNumber | Telephone no.: dialling code+number | CHAR30 | |
| HomePhoneExtension | Telephone no.: Extension | CHAR10 | |
| WorkPhoneSubscriberNumber | Telephone no.: dialling code+number | CHAR30 | |
| WorkPhoneExtension | Telephone no.: Extension | CHAR10 | |
| MobPhoneSubscriberNumber | Telephone no.: dialling code+number | CHAR30 | |
| WorkAddressMailAddress | E-Mail Address | AD_SMTPADR | |
| MainEmploymentIndicator | Single-Character Flag | CHAR1 | |
| EmploymentPercent | Model S: Employment Percentage | /SHCM/EMPLOYMENT_PERCENTAGE | |
| CompanyCode | Company Code | BUKRS | |
| CostCenter | Cost Center | KOSTL | |
| Job | Job | STELL | |
| JobName | Job Title | TEXT25 | |
| Department | Organizational Unit | ORGEH | |
| DepartmentName | Short Text of Organizational Unit | TEXT25 | |
| Division | Organizational Unit | ORGEH | |
| DivisionName | Short Text of Organizational Unit | TEXT25 | |
| BusinessUnit | Organizational Unit | ORGEH | |
| BusinessUnitName | Short Text of Organizational Unit | TEXT25 | |
| WeeklyWorkingHours | Model S: Work Hours per Week | /SHCM/WORK_HOURS | |
| EmploymentMgrEmployeeID | Identification Number | CHAR60 | |
| PaymentInfoPaymentMethod | List of Respected Payment Methods | ZWELS | |
| PaymentInfoAccountHolderName | Account Holder Name | BU_KOINH | |
| PaymentInfoBankAccountNumber | Bank Account Number | CHAR18 | |
| IBAN | IBAN (International Bank Account Number) | CHAR34 |
| Master Data Relations | Join Conditions |
|---|---|
Country key
| |
Country key
| |
Country key
| |
Country/Region Key of Bank
| |
Region code
| |
Address key assignment to users
| |
Country key
|