SAP table TCGC3 (Exchange profile)
SAP table TCGC3 has 2 primary key fields being MANDT,EPRID.
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 | |
| EPRID | Exchange Profile for Export or Import | CHAR | 10 | 0 | ESEEPRID | ||
| IEFILE | Path or Name of Transfer File | CHAR | 200 | 0 | ESEIEFILE | ||
| IEFULL | Incomplete import or export | CHAR | 1 | 0 | ESEIEFULL | ||
| IEFOW | Overwrite Export File | CHAR | 1 | 0 | ESEIEFOW | ||
| IEREF | Import or Export of Phrase References | CHAR | 1 | 0 | ESEIEREF | ||
| IEJOIN | Import or Export of Phrase Set Assignments | CHAR | 1 | 0 | ESEIEJOIN | ||
| SUBCAT | Specification Type | CHAR | 10 | 0 | TCG31 | ESESUBCAT | |
| AUTHGRP | Authorization Group | CHAR | 10 | 0 | TCG36 | ESEAUTHGRP | |
| IESEAR | Search Type Used to Identify Specifications | CHAR | 1 | 0 | ESEIESEAR | ||
| IDLIDSCR | Identification Listing | CHAR | 10 | 0 | TCG26 | ESEIDLID | |
| IDLIDSEAR | Identification Listing | CHAR | 10 | 0 | TCG26 | ESEIDLID | |
| IEOPCAT | Link type of logical operations | CHAR | 5 | 0 | ESEIEOPCAT | ||
| IESUBCAT | Specification Type | CHAR | 10 | 0 | TCG31 | ESESUBCAT | |
| MENID | Property Tree | CHAR | 10 | 0 | TCG51 | ESEMENID | |
| USEPROF | Usage Profile | CHAR | 10 | 0 | TCG96 | ESEUSEPROF | |
| OWNID | Data Provider | CHAR | 10 | 0 | * | ESEOWNID | |
| TEXTCAT | User-Defined Text Type | CHAR | 10 | 0 | TCG41 | ESETEXTCAT | |
| COMPCAT | Component Type | CHAR | 10 | 0 | TCG76 | ESECOMPCAT | |
| IEDEL | Deletion Type for Specification Import | CHAR | 1 | 0 | ESEIEDEL | ||
| IEPHCON | Import/export flag: Convert phrases in active library | CHAR | 1 | 0 | ESEIEPHCON | ||
| IEUSE | Import or Export of Usages | CHAR | 1 | 0 | ESEIEUSE | ||
| IEREL | Indicator: Import/export of assessments | CHAR | 1 | 0 | ESEIEREL | ||
| IESLST | Import or Export of Assignments to Regulatory Lists | CHAR | 1 | 0 | ESEIESLST | ||
| IEMAT | Indicator: Import/export of material assignments | CHAR | 1 | 0 | ESEIEMAT | ||
| IEEMUSE | Export of Value Assignments Not Used | CHAR | 1 | 0 | ESEIEEMUSE | ||
| IEIKEY | Specification Key from Internal Number Range | CHAR | 1 | 0 | ESEIEIKEY | ||
| IENACT | Do Not Set Active Indicator for Value Assignments | CHAR | 1 | 0 | ESEIENACT | ||
| IERESRR | Specification References Will Be Expanded | CHAR | 1 | 0 | ESEIERESRR | ||
| IEADMIN | Exporting administrative fields | CHAR | 1 | 0 | ESEIEADMIN | ||
| IENOCDW | No creation of change documents during import | CHAR | 1 | 0 | ESEIENOCDW | ||
| IESTATE | Import or Export of Phrase Item Status | CHAR | 1 | 0 | ESEFLGTOVR | ||
| IEIDCHK | Check Whether Nonstandardized Identifiers | CHAR | 1 | 0 | ESEIEIDCHK |
TCGC3 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TCGC3 | AUTHGRP | TCG36 | Specification Authorization Object | MANDT |
| 0 TCGC3 | AUTHGRP | TCG36 | Specification Authorization Object | AUTHGRP |
| 1 TCGC3 | COMPCAT | TCG76 | Component category | MANDT |
| 1 TCGC3 | COMPCAT | TCG76 | Component category | COMPCAT |
| 0 TCGC3 | IDLIDSCR | TCG26 | EHS: Identification Listings | MANDT |
| 0 TCGC3 | IDLIDSCR | TCG26 | EHS: Identification Listings | IDLID |
| 1 TCGC3 | IDLIDSEAR | TCG26 | EHS: Identification Listings | MANDT |
| 1 TCGC3 | IDLIDSEAR | TCG26 | EHS: Identification Listings | IDLID |
| 0 TCGC3 | IESUBCAT | TCG31 | Specification Type | MANDT |
| 0 TCGC3 | IESUBCAT | TCG31 | Specification Type | SUBCAT |
| 1 TCGC3 | MENID | TCG51 | Property Tree | MANDT |
| 1 TCGC3 | MENID | TCG51 | Property Tree | MENID |
| 0 TCGC3 | SUBCAT | TCG31 | Specification Type | MANDT |
| 0 TCGC3 | SUBCAT | TCG31 | Specification Type | SUBCAT |
| 1 TCGC3 | TEXTCAT | TCG41 | EHS: Value Assignment Text Type | MANDT |
| 1 TCGC3 | TEXTCAT | TCG41 | EHS: Value Assignment Text Type | TEXTCAT |
| 0 TCGC3 | USEPROF | TCG96 | Usage profile | MANDT |
| 0 TCGC3 | USEPROF | TCG96 | Usage profile | USEPROF |