SAP Table AD01C_MAT

DIP profile: Material determination

AD01C_MAT (DIP profile: Material determination) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link AD01C_MAT to other SAP tables.

AD01C_MAT table fields

Field

Data element

Checktable

Datatype

Length

Decimals

MANDT

Client

MANDT

T000

CLNT

PROFNR

Dynamic Item Processor Profile

AD01PROFNR

AD01C_PROF

CHAR

DPUS

Usage of the DI profile

AD01USAGE

NUMC

Possible values

01	Billing and results analysis
11	Quotation creation and sales pricing
51	Down Payment Request
52	Downpayment Request - Difference Records

LINENR

DI Profile: Material determination line

AD01LINMAT

NUMC

MAT_DIR

Use material from posting (if possible)

AD01MATDIR

CHAR

Possible values

NULL	No
X	Yes

INV_MAT

Material Determination for Dynamic Items

AD01INVMAT

MARA

CHAR

INV_SINGLE

Individual billing items for each dynamic item

AD01INVSIN

CHAR

Possible values

NULL	No
X	Yes

INV_QUANT

Transfer Quantity and Costs

AD01INVQUA

CHAR

Possible values

NULL	Transfer Costs Only
X	Transfer Costs and Quantity
A	For Costs <> 0: Transfer Costs and Quantity
B	For Quantity <> 0: Transfer Costs and Quantity
C	Transfer Quantity Only

FLMEH

Conversion in Sales Unit/Base Unit of Measure

FLMEH

CHAR

Possible values

X	Yes
NULL	No

AD01C_MAT foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table		Check field
AD01C_MAT	INV_MAT	AD01C_MAT	MANDT	MARA	General Material Data	MANDT
AD01C_MAT	INV_MAT	AD01C_MAT	INV_MAT	MARA	General Material Data	MATNR
AD01C_MAT	MANDT	AD01C_MAT	MANDT	T000	Clients	MANDT
AD01C_MAT	PROFNR	AD01C_MAT	DPUS	AD01C_PROF	DIP profile: Usage	DPUS
AD01C_MAT	PROFNR	AD01C_MAT	MANDT	AD01C_PROF	DIP profile: Usage	MANDT
AD01C_MAT	PROFNR	AD01C_MAT	PROFNR	AD01C_PROF	DIP profile: Usage	PROFNR