ROOMNUMBER in ADCP
Room Number (DE: Raumnummer)
ROOMNUMBER is a field in SAP table ADCP (Zuordnung Person/Adresse (Business Address Services)). It represents "Room Number". Data element: AD_ROOMNUM. Available in 31 CDS view(s) as RoomNumber, Room, WorkplaceRoomNumber.
Business Meaning
| Description (EN) | Room Number |
|---|---|
| Beschreibung (DE) | Raumnummer |
| Data Element | AD_ROOMNUM |
| Key Field | No |
CDS Views & Technical Names (31)
ADCP.ROOMNUMBER 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.
RoomNumber
(20 views)
Room or Apartment Number
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| C_BPUsrAssignmentVH | direct | CONSUMPTION | Business User-Value Help User Assignment | |
| CUAN_TG_TEAM_MEMBER_SEARCH | direct | AT_TG_TEAM_MEMBER_SEARCH | ||
| cuan_user_search | direct | User Search | ||
| ESH_N_USER_USER_DETAILS | direct | ESH View for User Details | ||
| fiscds_adrp | direct | User Office Data | ||
| I_BPContactPersonAddressGov | direct | TRANSACTIONAL | Base Contact Person Workplace Address | |
| I_BPRelshpCntctPersnAddrVersTP | direct | TRANSACTIONAL | RAP BO Contact Person Address Versions | |
| I_WorkplaceAddress | direct | BASIC | Employee Workplace Address | |
| P_Bpcontacts_Address | direct | BASIC | Address Data of BP Contacts | |
| P_USER_ADDR | direct | BASIC | F4 Suchhilfe für Benutzer | |
| C_BPCntctPersnAddressVersionTP | via 2 level | CONSUMPTION | Projection for Contact Address Version | |
| C_BPRelshpCntctAddrVersTP_2 | via 2 level | CONSUMPTION | Projection for Contact Address Version | |
| C_BPRelshpCntctPersnAddrVersTP | via 2 level | CONSUMPTION | Projection for Contact Address Version | |
| fiscds_userdefaultcontactdata | via 2 level | User Default Contact Data | ||
| I_BPContactPersonAddressGovTP | via 2 level | TRANSACTIONAL | BP Rel Cntct Persn Workplace Addr - TP | |
| I_PMContactCardEmployee | via 2 level | COMPOSITE | Employee | |
| P_BusinessPartnerContacts | via 2 level | BASIC | Business Partner Contact | |
| P_Businesspartnerpcontacts | via 2 level | BASIC | Business Partner Contacts | |
| R_WrkfrcPersonWorkplaceAddress | via 2 level | BASIC | Employee Workplace Address | |
| C_BPContactPersonAddressGovTP | via 3 levels | CONSUMPTION | Projection for CntctPersn Workplace Addr |
Room
(7 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| aps_iam_busr_core | direct | Business User | ||
| aps_iam_busr_locked_user | via 2 level | Locked Business Users | ||
| i_aps_iam_busr_rap_root | via 2 level | IAM: Business User - Root | ||
| c_aps_iam_busr_rap_cdoc_bu | via 3 levels | IAM: Business User - Change Document User Projection | ||
| c_aps_iam_busr_rap_dload_bubr | via 3 levels | IAM: Business User - Download User Role Assignments | ||
| c_aps_iam_busr_rap_dload_idp | via 3 levels | IAM: Business User - Download for IDP | ||
| c_aps_iam_busr_rap_root | via 3 levels | IAM: Business User - Root Projection |
WorkplaceRoomNumber
(4 views)
Room or Apartment Number
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_AddressWorkplaceDetails | direct | BASIC | Person Workplace Address Details | |
| I_PersonWorkplaceAddress | via 2 level | COMPOSITE | Corporate Workplace Address of a Person | |
| I_PostalWorkplaceAddress | via 2 level | BASIC | Person Address type from ADRC & ADCP | |
| R_AddlRepresentationTP | via 3 levels | TRANSACTIONAL | Address for Person BO |
Other Tables with Field ROOMNUMBER (15)
| Table | Data Element | Key | Description |
|---|---|---|---|
| ADRC | AD_ROOMNUM | Adressen (Business Address Services) | |
| BUPA_ADRC_D_2 | AD_ROOMNUM | Draft table for entity I_BUSINESSPARTNERADDRESSTP_2 | |
| BUPA_GRP_ADDR_D | AD_ROOMNUM | Draft table for entity I_BUSPARTSCRIPTEDGROUPADDRTP | |
| BUPA_ORG_ADDR_D | AD_ROOMNUM | Draft table for entity I_BUSPARTSCRIPTEDORGADDRESSTP | |
| BUPA_PERS_ADDR_D | AD_ROOMNUM | Draft table for entity I_BUSPARTSCRIPTEDPERSONADDRTP | |
| BUT_ADRC_IMOUT | AD_ROOMNUM | Master Data Consolidation: Process Table for ADRC | |
| BUT_ADRC_PRC | AD_ROOMNUM | Master Data Consolidation: Process Table for ADRC | |
| BUT020_DFT | AD_ROOMNUM | Draft table for entity I_BUSINESSPARTNERADDRESSGOVTP | |
| BUT020SCRGRP_DFT | AD_ROOMNUM | Draft table for entity I_BUSPARTSCRIPTEDGRPADDRGOVTP | |
| BUT020SCRORG_DFT | AD_ROOMNUM | Draft table for entity I_BUSPARTSCRIPTEDORGADDRGOVTP | |
| BUT020SCRPER_DFT | AD_ROOMNUM | Draft table for entity I_BUSPARTSCRIPTEDPERSADDRGOVTP | |
| BUT052_DFT | AD_ROOMNUM | Draft table for entity I_BPCONTACTPERSONADDRESSGOVTP | |
| MMSRCGPADDR_D | AD_ROOMNUM | Draft Table for R_SrcgProjDeliveryAddressTP | |
| WFP_D_PRAD_DFT_2 | AD_ROOMNUM | Draft table for entity R_WORKASSGMTPRIVATEADDRESSTP_2 | |
| WFP_D_WAPRAD_DFT | AD_ROOMNUM | Draft table for entity R_WORKASSGMTPRIVATEADDRESSTP |
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