Sunday, May 19, 2024

SAP Table AD01C_MATA – DIP profile: Material determination criteria

AD01C_MATA is a standard SAP table in SAP ECC (or) S/4HANA which stores DIP profile: Material determination criteria data. There are total 12 fields in AD01C_MATA table.This blog post provides key technical details of SAP table AD01C_MATA, including its availability across SAP S/4HANA versions and the list of CDS views for AD01C_MATA 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_MATA Table Fields

The following is the list of fields that are available in SAP AD01C_MATA 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 DI Profile: Material determination line AD01LINMAT AD01LINMAT AD01C_MAT NUMC (5)
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)
VAL_SNGL Set Value SETVAL SETVAL CHAR (40)

Availability

The SAP table AD01C_MATA 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_MATA table

The following is the list of AD01C_MATA CDS views, which can also be used instead of AD01C_MATA 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