SAP table AD01C_MAT (DIP profile: Material determination)

SAP table AD01C_MAT has 4 primary key fields being MANDT,PROFNR,DPUS,LINENR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PROFNR Dynamic Item Processor Profile CHAR 8 0 AD01C_PROF AD01PROFNR
DPUS Usage of the DI profile NUMC 2 0 AD01USAGE
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 NUMC 5 0 AD01LINMAT
MAT_DIR Use material from posting (if possible) CHAR 1 0 AD01MATDIR
INV_MAT Material Determination for Dynamic Items CHAR 40 0 MARA AD01INVMAT
INV_SINGLE Individual billing items for each dynamic item CHAR 1 0 AD01INVSIN
INV_QUANT Transfer Quantity and Costs CHAR 1 0 AD01INVQUA
Transfer Costs Only
A For Costs <> 0: Transfer Costs and Quantity
B For Quantity <> 0: Transfer Costs and Quantity
C Transfer Quantity Only
X Transfer Costs and Quantity
FLMEH Conversion in Sales Unit/Base Unit of Measure CHAR 1 0 FLMEH

AD01C_MAT foreign key relationships

Table Field Check Table Check Field
0 AD01C_MAT INV_MAT MARA General Material Data MATNR
1 AD01C_MAT MANDT T000 Clients MANDT
0 AD01C_MAT PROFNR AD01C_PROF DIP profile: Usage MANDT
0 AD01C_MAT PROFNR AD01C_PROF DIP profile: Usage PROFNR