STREETCODE in ADRC
Street Code (DE: Straßennummer)
STREETCODE is a field in SAP table ADRC (Adressen (Business Address Services)). It represents "Street Code". Data element: AD_STRNUM. Available in 18 CDS view(s) as street, streetcode.
Business Meaning
| Description (EN) | Street Code |
|---|---|
| Beschreibung (DE) | Straßennummer |
| Data Element | AD_STRNUM |
| Key Field | No |
CDS Views & Technical Names (18)
ADRC.STREETCODE 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.
street
(15 views)
Street Number for City/Street File
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| /SCMTMS/VE_LocQuByPhysAdd | direct | BOPF: Location Query By Physical Address | ||
| CIC_PlantAddress | direct | Proj. view on Plant address | ||
| I_AddrOrgNamePostalAddress | direct | BASIC | Postal Address and Organization Name | |
| I_AddressPostalAddress | via 2 level | BASIC | Postal Address | |
| I_BankOrganizationAddress | via 2 level | COMPOSITE | Address of an Organization used for Bank | |
| 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 | |
| I_PostalWorkplaceAddress | via 2 level | BASIC | Person Address type from ADRC & ADCP | |
| R_AddrAddlRepresentationTP | via 2 level | Additional Representation - TP | ||
| R_OrganizationAddressTP | via 2 level | Organization Address - TP | ||
| I_OrgAddressDefaultRprstn | via 3 levels | COMPOSITE | Default Representation of an Org Address | |
| I_PersonAddressDefaultRprstn | via 3 levels | COMPOSITE | Dflt Represention of a Person Address | |
| R_AddlRepresentationTP | via 3 levels | TRANSACTIONAL | Address for Person BO | |
| C_AddlRepresentationTP | via 4 levels | CONSUMPTION | Pview for R_AddlRepresentationTP |
streetcode
(3 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_CN_CADEOrganizationName | direct | BASIC | CADE Organization Name | |
| P_OrganizationAddress | direct | COMPOSITE | Address Info | |
| P_OrganizationAddressConsum | direct | CONSUMPTION | Address Info |
Other Tables with Field STREETCODE (2)
| Table | Data Element | Key | Description |
|---|---|---|---|
| BUT_ADRC_IMOUT | AD_STRNUM | Master Data Consolidation: Process Table for ADRC | |
| BUT_ADRC_PRC | AD_STRNUM | Master Data Consolidation: Process Table for ADRC |
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