STR_SUPPL1 in ADRC
Street 2 (DE: Straße 2)
STR_SUPPL1 is a field in SAP table ADRC (Addresses (Business Address Services)). It represents "Street 2". Data element: AD_STRSPP1. Available in 67 CDS view(s) as StreetPrefixName1, StreetPrefixName, str_suppl1.
Business Meaning
| Description (EN) | Street 2 |
|---|---|
| Beschreibung (DE) | Straße 2 |
| Data Element | AD_STRSPP1 |
| Key Field | No |
CDS Views & Technical Names (67)
ADRC.STR_SUPPL1 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.
StreetPrefixName1
(27 views)
Street 2
| 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_EWA_SalesContractCube | via 2 level | COMPOSITE | Sales Contract - Cube | |
| 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 | ||
| C_EWA_SalesContractQuery | via 3 levels | CONSUMPTION | Sales contracts - Query | |
| 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 | |
| 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 |
StreetPrefixName
(26 views)
Street 2
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_InvgCsMAddress | direct | BASIC | ICM Address | |
| I_ScriptedOrganizationAddress | direct | COMPOSITE | Interational Address Version | |
| P_Emplprivpostaddr | direct | BASIC | ||
| P_StRpWhldgTxIntlAddrVers | direct | BASIC | ||
| 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_InvgCsMLocation | via 2 level | BASIC | ICM Location | |
| 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_InvgCsMVisibleLocation | via 3 levels | COMPOSITE | Nonhidden Location | |
| 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_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 | |
| 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_suppl1
(7 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| /UCOM/I_MCM_ADRC | direct | BASIC | Address (Basic) | |
| CRMS4_IU_C_CONVAR | direct | Connection Object by Various Fields | ||
| CRMS4_IU_C_CONVAR_DEVPOD | direct | Con. Object by Various Fields (Dev, PoD) | ||
| CRMS4_IU_C_PRMADDR | direct | Premise by Address | ||
| P_CN_CADEOrganizationName | direct | BASIC | ||
| P_OrganizationAddress | direct | COMPOSITE | ||
| P_OrganizationAddressConsum | direct | CONSUMPTION |
FrcElmntOrgAddrStreetName2
(4 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_FrcElmntOrgBusinessAddress | direct | BASIC | ||
| I_FrcElmntOrgBusinessAddress | via 2 level | COMPOSITE | Int. View for FE Org Business Address | |
| C_FrcElmntOrgBusinessAddress | via 3 levels | CONSUMPTION | Consumption View for Business Address | |
| I_FrcElmntOrgAddress | via 3 levels | COMPOSITE | Int. View for FE Org Address |
street_prefix_name
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| /SCMTMS/CV_LocQuByPhysAdd | direct | Obsolete: Use CDS View /SCMTMS/VE_LocQuByPhysAdd | ||
| /SCMTMS/VE_LocQuByPhysAdd | direct | BOPF: Location Query By Physical Address |
AddressLine1
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| Fclm_Bm_Address | direct | Address data for bank master and business partner |
Other Tables with Field STR_SUPPL1 (4)
| Table | Data Element | Key | Description |
|---|---|---|---|
| BUT_ADRC_IMOUT | AD_STRSPP1 | Master Data Consolidation: Process Table for ADRC | |
| BUT_ADRC_PRC | AD_STRSPP1 | Master Data Consolidation: Process Table for ADRC | |
| J_1BNFCPD | AD_STRSPP1 | Nota Fiscal one-time accounts | |
| SIPT_HIST_KUNNR | AD_STRSPP1 | Signature PT: History specific customer data for print out |
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