SAP AD01C_MATA DIP profile: Material determination criteria Table
Overview
AD01C_MATA is a standard SAP S/4HANA table that stores DIP profile: Material determination criteria data. There are total 12 fields in the AD01C_MATA table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AD01C_MATA belongs to Revenues and Earnings (PS-REV) module and is located in the package DI Processor (Resource-Related Billing/Sales Pricing) (AD01).
In addition, following links provide an overview of foreign key relationships, if any, that link AD01C_MATA to other SAP tables and standard CDS views available based on AD01C_MATA table in S/4HANA 2020.
Techincal Settings of AD01C_MATA
Below are technical details of the table AD01C_MATA
- Buffering switched on
- Full buffering as specified by generic key
- Storage type is Column Store
List of AD01C_MATA Fields
The following table gives you an overview of the fields available in AD01C_MATA
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| PROFNR | Dynamic Item Processor Profile | AD01PROFNR | AD01C_PROF | CHAR | 8 |
| DPUS | Usage of the DI profile | AD01USAGE | NUMC | 2 | |
| LINENR | DI Profile: Material determination line | AD01LINMAT | AD01C_MAT | NUMC | 5 |
| FIELDNAME | Field Name | FIELDNAME | * | CHAR | 30 |
| VAL_EXCL | Indicator: Exclude entered value | AD01VALXCL | CHAR | 1 | |
| VAL_FROM | From Value | SETVALMIN | CHAR | 40 | |
| VAL_TO | To Value | SETVALMAX | CHAR | 40 | |
| SETNR | Identification of a Set | SETID | CHAR | 34 | |
| SETNAME | Set Name | SETNAMENEW | CHAR | 24 | |
| SETTAB | Table for set | SETTABLE | * | CHAR | 30 |
| VAL_SNGL | Set Value | SETVAL | CHAR | 40 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AD01C_MATA
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AD01C_MATA | LINENR | 1: CN | AD01C_MAT |
| AD01C_MATA | MANDT | 1: CN | T000 |
| AD01C_MATA | PROFNR | 1: CN | AD01C_PROF |