AD01C_SELA is a standard SAP table in SAP ECC (or) S/4HANA which stores DIP profile: Selection criteria data. There are total 11 fields in AD01C_SELA table.This blog post provides key technical details of SAP table AD01C_SELA, including its availability across SAP S/4HANA versions and the list of CDS views for AD01C_SELA table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering switched on |
| Buffering Type | Full buffering as specified by generic key |
| Package | DI Processor (Resource-Related Billing/Sales Pricing) (AD01) |
| Technical Component | Revenues and Earnings (PS-REV) |
SAP AD01C_SELA Table Fields
The following is the list of fields that are available in SAP AD01C_SELA table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT (3) |
| PROFNR | Dynamic Item Processor Profile | AD01PROFNR | AD01PROFNR | AD01C_PROF | CHAR (8) |
| DPUS | Usage of the DI profile | AD01USAGE | AD01USAGE | NUMC (2) | |
| LINENR | Source index (DIP profile) | AD01LINSEL | AD01LINSEL | * | NUMC (3) |
| FIELDNAME | Field Name | FIELDNAME | FDNAME | * | CHAR (30) |
| VAL_EXCL | Indicator: Exclude entered value | AD01VALXCL | XFELD | CHAR (1) | |
| VAL_FROM | From Value | SETVALMIN | SETVAL | CHAR (40) | |
| VAL_TO | To Value | SETVALMAX | SETVAL | CHAR (40) | |
| SETNR | Identification of a Set | SETID | SETID | CHAR (34) | |
| SETNAME | Set Name | SETNAMENEW | SETNAME | CHAR (24) | |
| SETTAB | Table for set | SETTABLE | AS4TAB | * | CHAR (30) |
Availability
The SAP table AD01C_SELA is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for AD01C_SELA table
The following is the list of AD01C_SELA CDS views, which can also be used instead of AD01C_SELA table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_ACTYTYPEDIPSOURCEMATLDETNREF | BASIC | Sources and Matl. Determination Activity Type References |
| P_ACTYTYPEDIPSOURCEMATLDETNREF | BASIC | Sources and Material Determination Activity Type References |
| I_ACTYTYPEDIPPROFILE | COMPOSITE | DIP Profile |
| C_ACTYTYPEDIPPROFILE | CONSUMPTION | DIP Profiles |
| P_ACTYTYPEDIPPROFILE | CONSUMPTION | DIP Profiles – without DCL |
