SORTL in KNMT
Search term (DE: Suchbegriff)
SORTL is a field in SAP table KNMT (Customer-Material Info Record Data Table). It represents "Search term". Data element: SORTL. Available in 9 CDS view(s) as CustomerMaterialSearchTerm, SortField, ETag.
Business Meaning
| Description (EN) | Search term |
|---|---|
| Beschreibung (DE) | Suchbegriff |
| Data Element | SORTL |
| Key Field | No |
CDS Views & Technical Names (9)
KNMT.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.
CustomerMaterialSearchTerm
(5 views)
Sort Field
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_CustomerMaterial_2 | direct | BASIC | Customer Material | |
| A_CustomerMaterial | via 2 level | COMPOSITE | Customer Materials | |
| I_CustomerMaterialTP | via 2 level | TRANSACTIONAL | Customer Material BO Draft | |
| R_CustomerMaterialTP | via 2 level | TRANSACTIONAL | Customer Material - TP | |
| C_CustomerMaterial_F2499 | via 3 levels | CONSUMPTION | Customer Material |
SortField
(3 views)
Sort Field
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_CustomerMaterial | direct | BASIC | Customer Material Information | |
| ESH_N_CUSTOMERMATERIAL | via 2 level | |||
| ESH_S_CUSTOMERMATERIAL | via 3 levels |
ETag
(1 view)
Sort Field
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_CustomerMaterial | direct | BASIC | Customer Material Information |
sortl
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_CL_SDM_SD_KNMT_SORTL | direct | BASIC |
Other Tables with Field SORTL (21)
| Table | Data Element | Key | Description |
|---|---|---|---|
| AFVC | SORTI | Operation within an order | |
| CUSTOMERCOCOD_VH | SORTL | Generated Table for View | |
| EINA | SORTI | Purchasing Info Record: General Data | |
| FPLA | SORTL | Billing Plan | |
| J_1BNFDOC | SORTL | Nota Fiscal Header | |
| J_1BNFNAD | SORTL | Nota Fiscal partners | |
| KNA1 | SORTL | General Data in Customer Master | |
| KNA1_PRC | SORTL | Master Data Consolidation: Process Table for KNA1 | |
| KNVK | SORTL | Customer Master Contact Partner | |
| LFA1 | SORTL | Supplier Master (General Section) | |
| LFA1_PRC | SORTL | Master Data Consolidation: Process Table for LFA1 | |
| M_DEBI_BO | SORTL | KEY | Generated Table for View |
| M_DEBID | SORTL | KEY | Generated Table for View |
| M_KRED_BO | SORTL | KEY | Generated Table for View |
| M_KREDK | SORTL | KEY | Generated Table for View |
| M_MEINN | SORTI | KEY | Generated Table for View |
| M_MEINP | SORTI | KEY | Generated Table for View |
| PLPO | SORTI | Task list - operation/activity | |
| SUPPLIERCOCOD_VH | SORTL | Generated Table for View | |
| VEKP | SORTL | Handling Unit - Header Table | |
| VSAFVC_CN | SORTI | Version: Operation in order |
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