SORTL in KNA1
Search term (DE: Suchbegriff)
SORTL is a field in SAP table KNA1 (General Data in Customer Master). It represents "Search term". Data element: SORTL. Available in 8 CDS view(s) as sortl, SortField, kna1_sortl.
Business Meaning
| Description (EN) | Search term |
|---|---|
| Beschreibung (DE) | Suchbegriff |
| Data Element | SORTL |
| Key Field | No |
CDS Views & Technical Names (8)
KNA1.SORTL 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.
sortl
(5 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| fac_ad_cds_customer | direct | Value-Help for Customers | ||
| P_AUDIT_AT_KNA1 | direct | BASIC | Austrian Audit Masterdata Customer Accts | |
| SHSM_DEBIK | direct | CDS view replacing M_DEBIK for DEBIK | ||
| SHSM_FAR_CUSTOMER | direct | Value-Help for Customers | ||
| VC_INTEGRATION_KNA1 | direct | Extraction for KNA1 |
SortField
(2 views)
Sort Field
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_Customer | direct | BASIC | Customer | |
| P_ARLineItemMixedAccount | via 2 level | BASIC | Customer Accounts belonging to mixed accounts |
kna1_sortl
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| FGL_LIB_P_D | direct | FI LIB: Parked Items - Customers |
Other Tables with Field SORTL (8)
| Table | Data Element | Key | Description |
|---|---|---|---|
| EINA | SORTI | Purchasing Info Record: General Data | |
| FPLA | SORTL | Billing Plan | |
| KNA1_PRC | SORTL | Master Data Consolidation: Process Table for KNA1 | |
| KNMT | SORTL | Customer-Material Info Record Data Table | |
| LFA1 | SORTL | Supplier Master (General Section) | |
| LFA1_PRC | SORTL | Master Data Consolidation: Process Table for LFA1 | |
| PLPO | SORTI | Task list - operation/activity | |
| VEKP | SORTL | Handling Unit - Header Table |
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