AD01C_SEL is a standard SAP table in SAP ECC (or) S/4HANA which stores DIP profile: Sources data. There are total 12 fields in AD01C_SEL table.This blog post provides key technical details of SAP table AD01C_SEL, including its availability across SAP S/4HANA versions and the list of CDS views for AD01C_SEL 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_SEL Table Fields
The following is the list of fields that are available in SAP AD01C_SEL 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) | |
DLISRC | Dynamic Item Source | AD01DLISRC | AD01DLISRC | AD01SRC | CHAR (4) |
DEFPERCENT | Proposed Percentage Rate | AD01DEFPCT | AD01DEFPCT | DEC (5) | |
IFLAG | DI source: Error or warning when > 100% | IFLAG | XFELD | CHAR (1) | |
AUMOT | Apportionment reason | AUMOT | AD01COSTYP | AD01C_CT | CHAR (2) |
KALSM | Costing Sheet | AUFKALSM | KALSM | T683 | CHAR (6) |
ZSCHL | Overhead key | AUFZSCHL | CHAR6 | CHAR (6) | |
ONLYBAS | Only basis for surcharges | AD01ONLYBA | XFELD | CHAR (1) | |
ONLYR | DI source: Costs for results analysis | ONLYR | XFELD | CHAR (1) |
Availability
The SAP table AD01C_SEL 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_SEL table
The following is the list of AD01C_SEL CDS views, which can also be used instead of AD01C_SEL 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 |