SAP table AD01C_PROF (DIP profile: Usage)

SAP table AD01C_PROF has 3 primary key fields being MANDT,PROFNR,DPUS.

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 DPPROFH 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
MACOND Number of manual conditions NUMC 1 0 AD01MACOND
0 No manual condition on selection screen
1 1 manual condition on selection screen
2 2 manual conditions on selection screen
3 3 manual conditions on selection screen
SDAUART Sales Document Type CHAR 4 0 TVAK AD01CAUART
SDAUARG Sales Document Type for Credit Memo Request CHAR 4 0 TVAK AUARG
WCHECK Warranty check CHAR 1 0 WACHK
FLDIMAT Process Dynamic Items with Material Only CHAR 1 0 FLDIMAT
FLITD Inception-to-Date Billing CHAR 1 0 FLITD
AD01SDAUART Sales Document Type CHAR 4 0 TVAK AUART

AD01C_PROF foreign key relationships

Table Field Check Table Check Field
0 AD01C_PROF AD01SDAUART TVAK Sales Document Types MANDT
0 AD01C_PROF AD01SDAUART TVAK Sales Document Types AUART
1 AD01C_PROF MANDT T000 Clients MANDT
0 AD01C_PROF SDAUARG TVAK Sales Document Types MANDT
0 AD01C_PROF SDAUARG TVAK Sales Document Types AUART
1 AD01C_PROF SDAUART TVAK Sales Document Types MANDT
1 AD01C_PROF SDAUART TVAK Sales Document Types AUART