SAP Table
AD01C_PROF DIP profile: Usage
SAP table AD01C_PROF has 3 primary key fields being MANDT,PROFNR,DPUS.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
AD01C_PROF columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||
| KeyPROFNR | Dynamic Item Processor Profile | CHAR | 8 | 0 | DPPROFH | AD01PROFNR | |||||||||
| KeyDPUS | 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 | |||||||||
/ Relationships
AD01C_PROF foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| AD01C_PROF | AD01SDAUART | TVAK | Sales Document Types | MANDT |
| AD01C_PROF | AD01SDAUART | TVAK | Sales Document Types | AUART |
| AD01C_PROF | MANDT | T000 | Clients | MANDT |
| AD01C_PROF | SDAUARG | TVAK | Sales Document Types | MANDT |
| AD01C_PROF | SDAUARG | TVAK | Sales Document Types | AUART |
| AD01C_PROF | SDAUART | TVAK | Sales Document Types | MANDT |
| AD01C_PROF | SDAUART | TVAK | Sales Document Types | AUART |