SORT2 in ADRC

Table Field AD_SORT2

Search Term 2 (DE: Suchbegriff 2)

SORT2 is a field in SAP table ADRC (Addresses (Business Address Services)). It represents "Search Term 2". Data element: AD_SORT2. Available in 62 CDS view(s) as SearchTerm2, AddressSearchTerm2, sort2.

Business Meaning

Description (EN)Search Term 2
Beschreibung (DE)Suchbegriff 2
Data ElementAD_SORT2
Key FieldNo

CDS Views & Technical Names (62)

ADRC.SORT2 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.

SearchTerm2 (27 views)

ViewAccessVDMReleaseDescription
I_Address direct BASIC Address
I_BusinessPartnerAddress_2 direct BASIC Basic View for BP Address
I_DfsAddress direct BASIC Address
I_InvgCsMAddress direct BASIC ICM Address
I_ScriptedOrganizationAddress direct COMPOSITE Interational Address Version
C_CorrespondenceAddress via 2 level CONSUMPTION Address with printable lines for an address label
C_ProcmtHubRefDeliveryAddrIDVH via 2 level CONSUMPTION Reference Delivery Addr ID Value Help from Connected System
CRMS4_IU_P_ADDRESS via 2 level I_Address + additional fields from ADRC
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_DfsLocationAddress via 2 level BASIC Location and Account Assignment
I_INS_ClmPrtcpntStdAddress via 2 level BASIC Basic Interface Participant Address
I_InvgCsMLocation via 2 level BASIC ICM Location
C_DFS_EquipmentAddressVH via 3 levels CONSUMPTION Equipment Address Selection Search Help
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
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
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

AddressSearchTerm2 (20 views)

Search Term 2

ViewAccessVDMReleaseDescription
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_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
C_PurchasingDeliveryAddressVH via 3 levels CONSUMPTION Master Delivery Addresses
I_BankScriptedAddress via 3 levels COMPOSITE Bank Scripted Address
I_OrgAddressDefaultRprstn via 3 levels COMPOSITE Default Representation of an Org Address
R_AddlRepresentationTP via 3 levels TRANSACTIONAL Address for Person BO
C_AddlRepresentationTP via 4 levels CONSUMPTION Pview for R_AddlRepresentationTP
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

sort2 (7 views)

ViewAccessVDMReleaseDescription
/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

AddressSearchText2 (5 views)

ViewAccessVDMReleaseDescription
P_FrcElmntOrgBusinessAddress direct BASIC
I_FrcElmntOrgBusinessAddress via 2 level COMPOSITE Int. View for FE Org Business Address
C_FrcElmntOrgAddrNumberVH via 3 levels CONSUMPTION VH Consumption View for Address Number
C_FrcElmntOrgBusinessAddress via 3 levels CONSUMPTION Consumption View for Business Address
I_FrcElmntOrgAddress via 3 levels COMPOSITE Int. View for FE Org Address

search_term_2 (2 views)

ViewAccessVDMReleaseDescription
/SCMTMS/CV_LocQuByPhysAdd direct Obsolete: Use CDS View /SCMTMS/VE_LocQuByPhysAdd
/SCMTMS/VE_LocQuByPhysAdd direct BOPF: Location Query By Physical Address

SearchTeam2 (1 view)

ViewAccessVDMReleaseDescription
Fclm_Bm_Address direct Address data for bank master and business partner

Other Tables with Field SORT2 (16)

TableData ElementKeyDescription
ADCP AD_SORTOLD Person/Address Assignment (Business Address Services)
ADRP AD_SORT2 Persons (Business Address Services)
BUR_ADCP_PRC AD_SORTOLD Process Records Of OTC 1405, Table ADCP
BUT_ADRC_IMOUT AD_SORT2 Master Data Consolidation: Process Table for ADRC
BUT_ADRC_PRC AD_SORT2 Master Data Consolidation: Process Table for ADRC
COPC_ACCOUNT AD_SORT2UL Cash Account
J_1BNFCPD AD_SORT2UL Nota Fiscal one-time accounts
M_BETRA AD_SORT2 KEY Generated Table for View
M_BETRB AD_SORT2 KEY Generated Table for View
M_BETRC AD_SORT2 KEY Generated Table for View
MDTB SORT2 MRP Table
MT001W AD_SORT2 KEY Generated Table for View
NAST NAST_SORTK Message Status
PRPS PL_SORT2 WBS (Work Breakdown Structure) Element Master Data
VSPRPS_CN PL_SORT2 Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data
VWRF_BETRWH AD_SORT1 Generated Table for View

Learn More