SAP table TPGPRF (Profile for static pegging and data distribution)
SAP table TPGPRF has 2 primary key fields being MANDT,PROFID.
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 | MANDT | ||
| PROFID | Distribution profile | CHAR | 6 | 0 | PGPROFID | ||
| ASSINT | Assignment of internal procurement elements (prod. orders) | CHAR | 1 | 0 | PGASSINT | ||
| ASSEXT | Assignment of external procurement elements (purch. orders) | CHAR | 1 | 0 | PGASSEXT | ||
| DICOST | Distribute costs of internal procurement | CHAR | 1 | 0 | PGDICOST | ||
| DICOMM | Distribute commitments from internal procurement | CHAR | 1 | 0 | PGDICOMM | ||
| DICASH | Distribute payments for internal procurement | CHAR | 1 | 0 | PGDICASH | ||
| DIRA | Distribute results analysis data | CHAR | 1 | 0 | PGDIRA | ||
| DIEVA | Distribute earned value data | CHAR | 1 | 0 | PGDIEVA | ||
| DECOST | Distribute costs of external procurement | CHAR | 1 | 0 | PGDECOST | ||
| DECOMM | Distribute commitments from external procurement | CHAR | 1 | 0 | PGDECOMM | ||
| DECASH | Distributepayments for external procurement | CHAR | 1 | 0 | PGDECASH | ||
| DSTOCK | Distribute stock values | CHAR | 1 | 0 | PGDSTOCK | ||
| DIVARI | Variance indicator | CHAR | 1 | 0 | PGVARIANT | ||
| DISCRP | Material scrap indicator | CHAR | 1 | 0 | PGSCRAP | ||
| VERSI | Version | CHAR | 3 | 0 | * | COVERSI | |
| DILCOMM | Distribution of Commitment Line Items | CHAR | 1 | 0 | DIS_LCOMM | ||
| DILACT | Distribution of Actual Line Items | CHAR | 1 | 0 | DIS_LACT | ||
| DISTR_VENDOR_DP | Distribution: Distribute Vendor Down Payment | CHAR | 1 | 0 | PMMO_DISTR_PROF_VENDOR_DP_D |