SAP Table
TPGPRF Profile for static pegging and data distribution
SAP table TPGPRF has 2 primary key fields being MANDT,PROFID.
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
TPGPRF columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | MANDT | ||
| KeyPROFID | 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 |