IDNUMBER in BUT0ID
ID Number (DE: ID-Nummer)
IDNUMBER is a field in SAP table BUT0ID (BP: ID Numbers). It represents "ID Number". Data element: BU_ID_NUMBER. Available in 56 CDS view(s) as BPIdentificationNumber, Employee, idnumber.
Business Meaning
| Description (EN) | ID Number |
|---|---|
| Beschreibung (DE) | ID-Nummer |
| Data Element | BU_ID_NUMBER |
| Key Field | Yes |
CDS Views & Technical Names (56)
BUT0ID.IDNUMBER is exposed in CDS views under the following technical names. Views reading the table directly are listed first; "via" marks views that pass the field on through intermediate views.
BPIdentificationNumber
(26 views)
Identification Number
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_BPUsrExternalID | direct | BASIC | Business Partner External ID (BUM) | |
| I_BuPaIdentification | direct | BASIC | Business Partner Identification | |
| P_BPUSRPERSONEXTERNALID | direct | BASIC | Business Partner Person External ID-BUM | |
| A_BuPaIdentification | via 2 level | BASIC | Identification | |
| C_EnvrmtWastePartnerIdn | via 2 level | CONSUMPTION | Environment Waste Partner Identification | |
| C_InsurCust360BPIdentification | via 2 level | CONSUMPTION | Kundenidentifikationsdetails | |
| I_BuPaIdentificationTP | via 2 level | TRANSACTIONAL | Business Partner Identification | |
| I_BusinessUserVH | via 2 level | COMPOSITE | Business User - Value Help | |
| I_BusPartIdentificationTP_2 | via 2 level | TRANSACTIONAL | Transactional View for I_BuPaIdentification | |
| I_SupplierToEmployment | via 2 level | COMPOSITE | Supplier with his supported employments | |
| P_BPTRANSPSTDCARRALPHACODE | via 2 level | COMPOSITE | ||
| P_BusinessPartnerTranspIATA | via 2 level | COMPOSITE | ||
| P_PH_CASForeignBPTIN | via 2 level | COMPOSITE | ||
| P_PH_ForeignBPTIN | via 2 level | COMPOSITE | ||
| R_BPUsrPersonExternalID | via 2 level | COMPOSITE | Business User Person External ID | |
| C_BankAccountReviewerVH | via 3 levels | CONSUMPTION | Bank Account Reviewer | |
| C_BuPaIdentification | via 3 levels | CONSUMPTION | BP Identification Numbers Consumption View | |
| C_BusPartIdentificationTP_2 | via 3 levels | CONSUMPTION | Projection View for I_BUSPARTIDENTIFICATIONTP_2 | |
| C_EnvrmtWastePartnerTP | via 3 levels | CONSUMPTION | Waste Partner- Transporters & Disposers | |
| C_EnvrmtWastePartnerVH | via 3 levels | CONSUMPTION | Environment Waste Partner Value Help | |
| C_WrkOrdForOPgNew | via 3 levels | CONSUMPTION | Work Order Details for new persistency | |
| FCLM_BAM_BUSINESSUSER | via 3 levels | Cash Business User | ||
| I_BPTranspStdCarrAlphaCode | via 3 levels | COMPOSITE | Composite View for BP Transp SCAC | |
| I_BusinessPartnerTranspIATA | via 3 levels | COMPOSITE | Composite View for BP Transp IATA Code | |
| I_BusPartIdentificationTP_3 | via 3 levels | TRANSACTIONAL | Business Partner Identification | |
| C_EnvrmtWastePrtnTransptrVH | via 4 levels | CONSUMPTION | Selelct Waste Transport Partner |
Employee
(13 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_EmployeeCl | direct | BASIC | ||
| P_N_Employee | direct | BASIC | ||
| P_N_EmployeeOp | direct | BASIC | ||
| P_O_EmployeeOp | direct | BASIC | ||
| C_PurReqnReqdByUsrVH | via 2 level | CONSUMPTION | List of Requested By User of PR | |
| I_WorkerSearch | via 2 level | COMPOSITE | Workforce CDS view for OP | |
| I_WorkForcePersonSearch | via 2 level | COMPOSITE | Workforce Person basic details | |
| ESH_N_WORKPRSNSEARCH | via 3 levels | |||
| I_AssignmentSearch | via 3 levels | COMPOSITE | Workforce Search | |
| C_AssignmentSearch | via 4 levels | CONSUMPTION | Workforce Assignment Search | |
| ESH_S_WORKPRSNSEARCH | via 4 levels | |||
| ESH_N_ASSGMTSRCH | via 5 levels | |||
| ESH_S_ASSGMTSRCH | via 6 levels |
idnumber
(5 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| /BOFU/CV_BPIdentification | direct | BOPF: /BOFU/BuPa Node Identification | ||
| /BOFU/CV_Q_BPIdentification | direct | BOPF: BP Query on Identification | ||
| /BOFU/VE_BPID | direct | BOPF: Business Partner Identification | ||
| FNDEI_BUT0ID_BLOCKINGINFO | direct | Filter View for table BUT0ID | ||
| FNDEI_BUT0ID_FILTER | direct | Filter View for table BUT0ID |
PersonExternalID
(6 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| C_ProjectBudgetReportLineItems | via 3 levels | CONSUMPTION | Project Budget Report - Line Items | |
| C_ProjectCostLineItem | via 3 levels | CONSUMPTION | Project Cost Line Item | |
| C_Projectcostlineitems | via 3 levels | CONSUMPTION | Project Cost Line Items | |
| R_WorkforcePerson | via 3 levels | COMPOSITE | Workforce Person data | |
| R_WorkforcePersonTP | via 4 levels | TRANSACTIONAL | Workforce Person TP | |
| C_ManageWorkforce_F6097 | via 5 levels | CONSUMPTION | Manage Workforce App |
WorkforcePersonExternalID
(4 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_WorkAssignment | via 2 level | BASIC | Work Assignments | |
| I_WorkforcePersonRoleTP | via 2 level | Workforce Person Role | ||
| I_WorkforcePersonTP | via 2 level | TRANSACTIONAL | BUM - Workforce Person TP | |
| I_WrkfrcPersnRelshpToCoTP | via 2 level | Workforce Person Relationship to Company |
BPIdnNumberForEditValue
(3 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_BusPartIdentificationTP_2 | via 2 level | TRANSACTIONAL | Transactional View for I_BuPaIdentification | |
| C_BusPartIdentificationTP_2 | via 3 levels | CONSUMPTION | Projection View for I_BUSPARTIDENTIFICATIONTP_2 | |
| I_BusPartIdentificationTP_3 | via 3 levels | TRANSACTIONAL | Business Partner Identification |
BPIdentificationNumberForEdit
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_BuPaIdentificationTP | via 2 level | TRANSACTIONAL | Business Partner Identification | |
| C_BuPaIdentification | via 3 levels | CONSUMPTION | BP Identification Numbers Consumption View |
InsurClmDriverLicenseNumber
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_InsurClmPolicySnpshtDriver | via 2 level | COMPOSITE | Fahrer im Vertragsspiegel | |
| C_InsurClmPolicySnpshtDriver | via 3 levels | CONSUMPTION | Fahrerdetails für Fallauskunft |
WorkforcePersonExternalUUID
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_WorkforcePersonTP | via 2 level | TRANSACTIONAL | BUM - Workforce Person TP |
Other Tables with Field IDNUMBER (3)
| Table | Data Element | Key | Description |
|---|---|---|---|
| BUT0ID_DQ_RES | BU_ID_NUMBER | KEY | Master Data Quality Results of OTC 147, Table BUT0ID |
| BUT0ID_PRC | BU_ID_NUMBER | KEY | Master Data Consolidation: Process Table for BUT0ID |
| MDBPCV_DC | MDBPCV_IDNUM | KEY | Data Controller and Purpose Assignment for Cust, Supl and CP |
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