STREET in ADRC
Street (DE: Straße)
STREET is a field in SAP table ADRC (Adressen (Business Address Services)). It represents "Street". Data element: AD_STREET. Available in 85 CDS view(s) as StreetName, street, Street_Name.
Business Meaning
| Description (EN) | Street |
|---|---|
| Beschreibung (DE) | Straße |
| Data Element | AD_STREET |
| Key Field | No |
CDS Views & Technical Names (85)
ADRC.STREET 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.
StreetName
(57 views)
Street
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| /BOFU/CV_BPAddress | direct | BOPF: Business Partner Address | ||
| CIC_PlantAddress | direct | Proj. view on Plant address | ||
| I_AddrOrgNamePostalAddress | direct | BASIC | Postal Address and Organization Name | |
| I_ScriptedOrganizationAddress | direct | COMPOSITE | Interational Address Version | |
| P_Emplprivpostaddr | direct | BASIC | Employee Postal Address | |
| P_StRpWhldgTxIntlAddrVers | direct | BASIC | International Address Version | |
| I_AddressPostalAddress | via 2 level | BASIC | Postal Address | |
| I_BankOrganizationAddress | via 2 level | COMPOSITE | Address of an Organization used for Bank | |
| 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_EmplHomeAddress | via 2 level | BASIC | Obsolete - DONOT USE_Employee Home Address | |
| 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 | |
| P_BillingAddrOrgNamePostalAddr | via 2 level | COMPOSITE | Postal Address and Organization Name | |
| R_AddrAddlRepresentationTP | via 2 level | Additional Representation - TP | ||
| R_OrganizationAddressTP | via 2 level | Organization Address - TP | ||
| C_PurchasingDeliveryAddressVH | via 3 levels | CONSUMPTION | Master Delivery Addresses | |
| C_PurReqnItemDeliveryAddress | via 3 levels | CONSUMPTION | Consumption View for Purchase Reqn Delivery address | |
| I_BankScriptedAddress | via 3 levels | COMPOSITE | Bank Scripted Address | |
| I_BusPartScriptedGroupAddrTP | via 3 levels | TRANSACTIONAL | Business partner scripted addresses | |
| I_BusPartScriptedOrgAddressTP | via 3 levels | TRANSACTIONAL | Business partner scripted addresses | |
| 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 | |
| P_BillgProcDocItemCmpltParAddr | via 3 levels | COMPOSITE | Billg Proc Doc Itm Cmplt Partner Address | |
| P_BillgProcDocPartnerAddress | via 3 levels | COMPOSITE | Billing Process Document Partner Address | |
| P_EG_CompanyCode_Address | via 3 levels | COMPOSITE | Returns concateneted fields from company code address | |
| P_SA_CompanyCode_Address | via 3 levels | COMPOSITE | KSA VAT Company Code Address | |
| R_AddlRepresentationTP | via 3 levels | TRANSACTIONAL | Address for Person BO | |
| R_BankAddressDepTP | via 3 levels | TRANSACTIONAL | Bank Address | |
| R_ProductionSupplyAreaAddrTP | via 3 levels | TRANSACTIONAL | Production Supply Area Address - TP | |
| A_BankAddress | via 4 levels | Bank Address | ||
| C_AddlRepresentationTP | via 4 levels | CONSUMPTION | Pview for R_AddlRepresentationTP | |
| C_BusPartScriptedGroupAddrTP | via 4 levels | CONSUMPTION | Business partner scripted addresses | |
| C_BusPartScriptedOrgAddressTP | via 4 levels | CONSUMPTION | Business partner scripted addresses | |
| C_ProductionSupplyAreaAddress | via 4 levels | CONSUMPTION | Production Supply Area Address | |
| I_BANKADDRESSDEPTP | via 4 levels | Bank Address Projection - TP | ||
| I_BusPartScriptedOrgAddrTP_2 | via 4 levels | TRANSACTIONAL | BP Scripted Org address | |
| I_BusPartScriptGroupAddrTP_2 | via 4 levels | TRANSACTIONAL | BP Scripted Group address | |
| I_DbtflAcctsValnCustomer | via 4 levels | COMPOSITE | DAV Customer Information | |
| I_JntVntrOperator | via 4 levels | BASIC | Operator data | |
| I_ProductionSupplyAreaAddrTP_2 | via 4 levels | TRANSACTIONAL | Production Supply Area Address - TP | |
| I_PurchaseReqnDeliveryAddress | via 4 levels | COMPOSITE | Pur Reqn Delivery Address Basic View | |
| I_SAFTAccountingCustomer | via 4 levels | COMPOSITE | SAF-T Regular Accounting Customers | |
| I_SAFTGeneralLedgerSupplier | via 4 levels | COMPOSITE | SAF-T Gen Ledger Supplier | |
| R_BankScriptedAddressTP | via 4 levels | TRANSACTIONAL | Bank Scripted Address | |
| A_BankScriptedAddress_3 | via 5 levels | CONSUMPTION | Scripted Addresses | |
| C_BankScriptedAddressTP | via 5 levels | CONSUMPTION | Consumption Bank Address TP | |
| C_CashBankScriptedAddress | via 5 levels | CONSUMPTION | Cash Bank Scripted Address | |
| C_DbtflAcctsValnCustomer | via 5 levels | CONSUMPTION | DAV Customer Information | |
| C_JntVntrOperator | via 5 levels | CONSUMPTION | Joint Venture Operator | |
| I_BankScriptedAddressTP | via 5 levels | TRANSACTIONAL | Bank International Address Versions - TP | |
| P_SuplrCoCodePurOrgAssgmt | via 5 levels | COMPOSITE | Supplier assignment to CoCode and Purch Org | |
| T_PurchaseReqnDeliveryAdd | via 5 levels | TRANSACTIONAL | Pur Reqn Delivery Address Basic View | |
| C_PurchaseReqnDelivAdd | via 6 levels | CONSUMPTION | Purchase Reqn Delivery Address C View |
street
(12 views)
Street Number for City/Street File
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| ESH_N_COMPANY_ADDRESS_ADDRESS | direct | Company Address | ||
| FAC_AUDIT_Z3_TAX_GROUP | direct | Tax Group | ||
| Fclm_Bm_Address | direct | Address data for bank master and business partner | ||
| ICM_EMPLOYEE_CONTACT | direct | Employee | ||
| ICM_PARTNER_CONTACT | direct | BusinessPartner_contact | ||
| ICM_PARTNER_ORGANIZATION | direct | BusinessPartner_Organization | ||
| ICM_PARTNER_PERSON | direct | BusinessPartner_person | ||
| P_CN_CADEOrganizationName | direct | BASIC | CADE Organization Name | |
| P_OrganizationAddress | direct | COMPOSITE | Address Info | |
| P_OrganizationAddressConsum | direct | CONSUMPTION | Address Info | |
| TSI_CONTACT_entry | direct | My Vendor Invoices: Contact | ||
| FAP_TSI_INVC_entry | via 2 level | My Vendor Invoices: Invoice Set |
Street_Name
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| v_sd_ci_item_party | direct | Customer Invoice Item Party | ||
| v_sd_ci_party | direct | Party information of Customer Invoices |
SupplierAddressStreet
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| C_Purdoclistsuppaddr | direct | CONSUMPTION | Supplier Address |
BPAddrStreetName
(12 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_Customer | via 3 levels | BASIC | Customer | |
| I_Supplier | via 3 levels | BASIC | Supplier | |
| C_CN_TaxInvcSupplier | via 4 levels | CONSUMPTION | China Tax Supplier | |
| ESH_N_CUSTOMERS_T | via 4 levels | Anchor view -CUSTOMERS_T | ||
| ESH_N_SUPPLIERS_M | via 4 levels | Anchor view -SUPPLIERS_M | ||
| I_Customer_VH | via 4 levels | BASIC | Customer | |
| I_SrlNumberHistoryCustomerVH | via 4 levels | COMPOSITE | Customer | |
| I_SrlNumberHistorySupplierVH | via 4 levels | COMPOSITE | Supplier | |
| P_SupplierWithCompanyCode | via 4 levels | COMPOSITE | Supplier extended by Company Code | |
| C_PCLblConfignShipToPartyVH | via 5 levels | CONSUMPTION | Configurations for Labels Ship To Party | |
| ESH_S_CUSTOMERS_T | via 5 levels | Search view -CUSTOMERS_T | ||
| ESH_S_SUPPLIERS_M | via 5 levels | Search view -SUPPLIERS_M |
PlantStreetName
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| C_SumzdJITCallDelivAddrOutput | via 3 levels | CONSUMPTION | Summarized JIT Call Delivery Address |
Other Tables with Field STREET (12)
| Table | Data Element | Key | Description |
|---|---|---|---|
| BUT_ADRC_IMOUT | AD_STREET | Master Data Consolidation: Process Table for ADRC | |
| BUT_ADRC_PRC | AD_STREET | Master Data Consolidation: Process Table for ADRC | |
| DEMO_SALES_BUPA1 | ABAP.CHAR | Business Partner Address | |
| DFKKZAX | AD_STREET | Rückzahlungsanforderung (Adressdaten für Scheck) | |
| EDOSIBPREG | GLO_DE_SI_STREET | Slovenia: Business Premise Master Data | |
| FPM_IDA_TEST_ADR | ABAP.CHAR | FPM IDA: Address Table | |
| SCUSTOM | S_STREET | Flugkunden | |
| SNWD_AD | SNWD_STREET | EPM: Address Table | |
| SNWD_BP_CRM | ABAP.CHAR | EPM HANA DG: CRM Business Partner Table (non-EPM) | |
| STRAVELAG | S_STREET | Reisebüro | |
| WFP_D_PRAD_DFT_2 | AD_STRNUM | Draft table for entity R_WORKASSGMTPRIVATEADDRESSTP_2 | |
| WFP_D_WAPRAD_DFT | AD_STRNUM | 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