SAP Table TPEXT
Profile for external procurement
TPEXT (Profile for external procurement) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TPEXT to other SAP tables.
Source: TPEXT (Profile for external procurement)
TPEXT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| PROFIL | External procurement profile | PROFILEXT | CHAR | 7 | 0 | |||||||
| KSTAR | Cost Element | KSTAR | CSKA | CHAR | 10 | 0 | ||||||
| EKORG | Purchasing Organization | EKORG | T024E | CHAR | 4 | 0 | ||||||
| EKGRP | Purchasing Group | EKGRP | T024 | CHAR | 3 | 0 | ||||||
| MATKL | Material Group | MATKL | T023 | CHAR | 9 | 0 | ||||||
| WEMPF | Goods Recipient/Ship-To Party | WEMPF | CHAR | 12 | 0 | |||||||
| ABLAD | Unloading Point | ABLAD | CHAR | 25 | 0 | |||||||
| FLG_DFTVAL | Default Values for External Material | FLG_DFTVAL | CHAR | 1 | 0 |
Possible values
|
||||||
TPEXT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TPEXT | EKGRP | TPEXT | MANDT | T024 | Purchasing Groups | MANDT |
| TPEXT | EKGRP | TPEXT | EKGRP | T024 | Purchasing Groups | EKGRP |
| TPEXT | EKORG | TPEXT | MANDT | T024E | Purchasing Organizations | MANDT |
| TPEXT | EKORG | TPEXT | EKORG | T024E | Purchasing Organizations | EKORG |
| TPEXT | KSTAR | TPEXT | MANDT | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | MANDT |
| TPEXT | KSTAR | * | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KTOPL | |
| TPEXT | KSTAR | TPEXT | KSTAR | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KSTAR |
| TPEXT | MANDT | TPEXT | MANDT | T000 | Clients | MANDT |
| TPEXT | MATKL | TPEXT | MANDT | T023 | Material Groups | MANDT |
| TPEXT | MATKL | TPEXT | MATKL | T023 | Material Groups | MATKL |
