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 |
|
|||||||||
| MACOND | Number of manual conditions | NUMC | 1 | 0 | AD01MACOND |
|
|||||||||
| 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 |