STR_SUPPL2 in ADRC
Street 3 (DE: Straße 3)
STR_SUPPL2 is a field in SAP table ADRC (Adressen (Business Address Services)). It represents "Street 3". Data element: AD_STRSPP2. Available in 50 CDS view(s) as StreetPrefixName2, AdditionalStreetPrefixName, str_suppl2.
Business Meaning
| Description (EN) | Street 3 |
|---|---|
| Beschreibung (DE) | Straße 3 |
| Data Element | AD_STRSPP2 |
| Key Field | No |
CDS Views & Technical Names (50)
ADRC.STR_SUPPL2 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.
StreetPrefixName2
(28 views)
Street 3
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| 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 | |
| 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 | ||
| I_BankScriptedAddress | via 3 levels | COMPOSITE | Bank Scripted Address | |
| I_OrgAddressDefaultRprstn | via 3 levels | COMPOSITE | Default Representation of an Org Address | |
| I_PersonAddressDefaultRprstn | via 3 levels | COMPOSITE | Dflt Represention of a Person Address | |
| P_BillgProcDocItemCmpltParAddr | via 3 levels | COMPOSITE | Billg Proc Doc Itm Cmplt Partner Address | |
| P_BillgProcDocPartnerAddress | via 3 levels | COMPOSITE | Billing Process Document Partner 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_ProductionSupplyAreaAddress | via 4 levels | CONSUMPTION | Production Supply Area Address | |
| I_BANKADDRESSDEPTP | via 4 levels | Bank Address Projection - TP | ||
| I_ProductionSupplyAreaAddrTP_2 | via 4 levels | TRANSACTIONAL | Production Supply Area Address - TP | |
| 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 | |
| I_BankScriptedAddressTP | via 5 levels | TRANSACTIONAL | Bank International Address Versions - TP |
AdditionalStreetPrefixName
(17 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_ScriptedOrganizationAddress | direct | COMPOSITE | Interational Address Version | |
| P_Emplprivpostaddr | direct | BASIC | Employee Postal Address | |
| P_StRpWhldgTxIntlAddrVers | direct | BASIC | International Address Version | |
| 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 | |
| C_PurReqnItemDeliveryAddress | via 3 levels | CONSUMPTION | Consumption View for Purchase Reqn Delivery address | |
| I_BusPartScriptedGroupAddrTP | via 3 levels | TRANSACTIONAL | Business partner scripted addresses | |
| I_BusPartScriptedOrgAddressTP | via 3 levels | TRANSACTIONAL | Business partner scripted addresses | |
| I_PurchaseReqnAddress | via 3 levels | COMPOSITE | Purchase Requisition Address Basic View | |
| C_BusPartScriptedGroupAddrTP | via 4 levels | CONSUMPTION | Business partner scripted addresses | |
| C_BusPartScriptedOrgAddressTP | via 4 levels | CONSUMPTION | Business partner scripted addresses | |
| I_BusPartScriptedOrgAddrTP_2 | via 4 levels | TRANSACTIONAL | BP Scripted Org address | |
| I_BusPartScriptGroupAddrTP_2 | via 4 levels | TRANSACTIONAL | BP Scripted Group address | |
| I_PurchaseReqnDeliveryAddress | via 4 levels | COMPOSITE | Pur Reqn Delivery Address Basic View | |
| T_PurchaseReqnDeliveryAdd | via 5 levels | TRANSACTIONAL | Pur Reqn Delivery Address Basic View | |
| C_PurchaseReqnDelivAdd | via 6 levels | CONSUMPTION | Purchase Reqn Delivery Address C View |
str_suppl2
(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 |
additional_street_prefix_name
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| /SCMTMS/VE_LocQuByPhysAdd | direct | BOPF: Location Query By Physical Address |
AddressLine2
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| Fclm_Bm_Address | direct | Address data for bank master and business partner |
Other Tables with Field STR_SUPPL2 (2)
| Table | Data Element | Key | Description |
|---|---|---|---|
| BUT_ADRC_IMOUT | AD_STRSPP2 | Master Data Consolidation: Process Table for ADRC | |
| BUT_ADRC_PRC | AD_STRSPP2 | 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