ROOMNUMBER in ADRC

Table Field AD_ROOMNUM

Room Number (DE: Raumnummer)

ROOMNUMBER is a field in SAP table ADRC (Adressen (Business Address Services)). It represents "Room Number". Data element: AD_ROOMNUM. Available in 81 CDS view(s) as RoomNumber, room_id.

Business Meaning

Description (EN)Room Number
Beschreibung (DE)Raumnummer
Data ElementAD_ROOMNUM
Key FieldNo

CDS Views & Technical Names (81)

ADRC.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 (80 views)

Room or Apartment Number

ViewAccessVDMReleaseDescription
CIC_PlantAddress direct Proj. view on Plant address
CRMS4_IU_C_CONVAR direct Connection Object by Various Fields
Fclm_Bm_Address direct Address data for bank master and business partner
I_Address direct BASIC Address
I_AddrOrgNamePostalAddress direct BASIC Postal Address and Organization Name
I_BusinessPartnerAddress_2 direct BASIC Basic View for BP Address
I_InvgCsMAddress direct BASIC ICM Address
I_ScriptedAddress direct BASIC Interational Address Version
I_ScriptedOrganizationAddress direct BASIC Interational Address Version
I_ScriptedPersonAddress direct BASIC Interational Address Version for Persons
P_CN_CADEOrganizationName direct BASIC
P_FrcElmntOrgBusinessAddress direct BASIC
P_OrganizationAddress direct COMPOSITE
P_OrganizationAddressConsum direct CONSUMPTION
A_PurReqAddDelivery via 2 level COMPOSITE Delivery Address
C_CorrespondenceAddress via 2 level CONSUMPTION Address with printable lines for an address label
C_CustomerAddressIDValueHelp via 2 level CONSUMPTION Customer Address ID Value Help
C_SupplierAddressIDValueHelp via 2 level CONSUMPTION Supplier Address ID Value Help
CRMS4_IU_P_ADDRESS via 2 level I_Address + additional fields from ADRC
I_AddressPostalAddress via 2 level BASIC Postal Address
I_BankOrganizationAddress via 2 level Address of an Organization used for Bank
I_BusinessPartnerAddress via 2 level BASIC Core view for Business Partner Address
I_BusPartScriptedGroupAddress via 2 level BASIC International version of a business partner address
I_BusPartScriptedOrgAddress via 2 level BASIC International version of a business partner address
I_BusPartScriptedPersonAddress via 2 level COMPOSITE International version of a business partner address
I_FrcElmntOrgBusinessAddress via 2 level COMPOSITE Int. View for FE Org Business Address
I_InvgCsMLocation via 2 level BASIC ICM Location
I_OrganizationAddress via 2 level BASIC Address of an Organization
I_OrgNamePostlAddrDfltRprstn via 2 level COMPOSITE Dflt Addr Rprstn for Org and Postal
I_PersonAddress via 2 level COMPOSITE Address of a Person
P_TH_BUSINESSPLACE_ADDR2J via 2 level CONSUMPTION
P_TH_BUSINESSPLACE_ADDR2JP via 2 level CONSUMPTION
R_AddrAddlRepresentationTP via 2 level Additional Representation - TP
R_OrganizationAddressTP via 2 level Organization Address - TP
R_PurchaseReqnDelivAddressTP via 2 level TRANSACTIONAL Purchase Requisition Delivery Address
R_WorkAssgmtPrivateAddressTP via 2 level TRANSACTIONAL Private Address for Work Assignment
A_PurchaseReqnDelivAddress_2 via 3 levels CONSUMPTION Delivery Address
C_FrcElmntOrgBusinessAddress via 3 levels CONSUMPTION Consumption View for Business Address
C_PurReqnItemDeliveryAddress via 3 levels CONSUMPTION Consumption View for Purchase Reqn Delivery address
CIC_CustBPAddress via 3 levels Proj. View on BP Address
CIC_SupplierBPASsociation via 3 levels Proj. View for Supplier-BP Assoc.
I_BusPartScriptedGroupAddrTP via 3 levels TRANSACTIONAL Business partner scripted addresses
I_BusPartScriptedOrgAddressTP via 3 levels TRANSACTIONAL Business partner scripted addresses
I_BusPartScriptedPersonAddrTP via 3 levels TRANSACTIONAL Business partner scripted addresses
I_FrcElmntOrgAddress via 3 levels COMPOSITE Int. View for FE Org Address
I_InvgCsMVisibleLocation via 3 levels COMPOSITE Nonhidden Location
I_OrgAddressDefaultRprstn via 3 levels COMPOSITE Default Representation of an Org Address
I_PersonAddressDefaultRprstn via 3 levels COMPOSITE Dflt Represention of a Person Address
I_PurchaseReqnAddress via 3 levels COMPOSITE Purchase Requisition Address Basic View
I_PurchaseReqnDelivAddrTP via 3 levels TRANSACTIONAL Purchase Reqn Delivery Address - TP
R_BankAddressDepTP via 3 levels TRANSACTIONAL Bank Address
R_BankAddressTP via 3 levels TRANSACTIONAL Bank Address
R_BankScriptedAddressTP via 3 levels TRANSACTIONAL Bank Scripted Address
A_BankAddress via 4 levels Bank Address
A_BankAddress_3 via 4 levels CONSUMPTION Bank Address
A_BankScriptedAddress_3 via 4 levels CONSUMPTION Scripted Addresses
C_BankAddressTP via 4 levels CONSUMPTION Consumption Bank Address TP
C_BankScriptedAddressTP via 4 levels CONSUMPTION Consumption Bank Address TP
C_BusPartScriptedOrgAddressTP via 4 levels CONSUMPTION Business partner scripted addresses
C_BusPartScriptedPersonAddrTP via 4 levels CONSUMPTION Business partner scripted addresses
C_CashBankAddress via 4 levels CONSUMPTION Cash Bank Address
C_CashBankScriptedAddress via 4 levels CONSUMPTION Cash Bank Scripted Address
CIC_CustomerAddress via 4 levels Proj. View on Customer Address
CIC_SupplierAddress via 4 levels Proj. View on Supplier Address
I_BANKADDRESSDEPTP via 4 levels Bank Address Projection - TP
I_BankAddressTP via 4 levels TRANSACTIONAL Bank Address - TP
I_BankScriptedAddressTP via 4 levels TRANSACTIONAL Bank International Address Versions - TP
I_BusPartScriptedOrgAddrTP_2 via 4 levels TRANSACTIONAL BP Scripted Org address
I_BusPartScriptPersonAddrTP_2 via 4 levels TRANSACTIONAL BP Scripted Person address
I_InvgCsMLocationTP via 4 levels TRANSACTIONAL TP View for ICM Location
I_InvgCsMLocRelatedLocTP via 4 levels TRANSACTIONAL TP view for ICM Relationship Location to Location
I_InvgCsMObjRelatedLocTP via 4 levels TRANSACTIONAL TP view for ICM Relationship Object to Location
I_PurchaseReqnDeliveryAddress via 4 levels COMPOSITE Pur Reqn Delivery Address Basic View
C_InvgCsMLocationTP via 5 levels CONSUMPTION ICM Location
C_InvgCsMLocRelatedLocTP via 5 levels CONSUMPTION ICM Relationship Location to Location
C_InvgCsMObjRelatedLocTP via 5 levels CONSUMPTION ICM Relationship Object to Location
R_PPS_PurchaseReqnDelivAddrTP via 5 levels TRANSACTIONAL Purchase Req Delivery Address
T_PurchaseReqnDeliveryAdd via 5 levels TRANSACTIONAL Pur Reqn Delivery Address Basic View
C_PPS_PurchaseReqnDelivAddrTP via 6 levels CONSUMPTION Purchase Reqn Delivery Address
C_PurchaseReqnDelivAdd via 6 levels CONSUMPTION Purchase Reqn Delivery Address C View

room_id (1 view)

ViewAccessVDMReleaseDescription
/SCMTMS/CV_LocQuByPhysAdd direct Helper View for Query By Phys. Address

Other Tables with Field ROOMNUMBER (17)

TableData ElementKeyDescription
ADCP AD_ROOMNUM Zuordnung Person/Adresse (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
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
EVBS AD_ROOMNUM Verbrauchsstelle
MMSRCGPADDR_D AD_ROOMNUM Draft Table for R_SrcgProjDeliveryAddressTP
PPS_PC_ADDRESS_D AD_ROOMNUM Draft table for entity R_PPS_PURCONTRDELIVADDRESSTP
PPS_PO_SUPADDR_D AD_ROOMNUM Draft table for entity R_PPS_PURORDSUPPLIERADDRESSTP
PPS_PR_DELADDR_D AD_ROOMNUM Draft table for entity R_PPS_PURCHASEREQNDELIVADDRTP
WFP_D_WAPRAD_DFT AD_ROOMNUM Draft table for entity R_WORKASSGMTPRIVATEADDRESSTP

Learn More