- Home
- Resources
- SAP Tables
- WCONCONTRACTS - Determined and Selected Contracts
SAP Table WCONCONTRACTS
Determined and Selected Contracts
WCONCONTRACTS (Determined and Selected Contracts) 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 WCONCONTRACTS to other SAP tables.
Source: WCONCONTRACTS (Determined and Selected Contracts)
WCONCONTRACTS table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| MATNR |
Material Number |
MATNR |
|
CHAR |
|
18 |
0 |
|
| PSTYP |
Item Category in Purchasing Document |
PSTYP |
|
CHAR |
|
1 |
0 |
|
| EPSTP |
Item Category in Purchasing Document |
EPSTP |
|
CHAR |
|
1 |
0 |
|
| KNTTP |
Account Assignment Category |
KNTTP |
|
CHAR |
|
1 |
0 |
|
| WERKS |
Plant |
WERKS_D |
|
CHAR |
|
4 |
0 |
|
| LIFNR |
Account Number of Vendor or Creditor |
LIFNR |
|
CHAR |
|
10 |
0 |
|
| KDATB |
Start of Validity Period |
KDATB |
|
DATS |
|
8 |
0 |
|
| LIFNR_NAME1 |
Name 1 |
NAME1_GP |
|
CHAR |
|
35 |
0 |
|
| EKORG |
Purchasing Organization |
EKORG |
|
CHAR |
|
4 |
0 |
|
| EKGRP |
Purchasing Group |
EKGRP |
|
CHAR |
|
3 |
0 |
|
| MATNR_TXZ01 |
Short Text |
TXZ01 |
|
CHAR |
|
40 |
0 |
|
| MATKL |
Material Group |
MATKL |
|
CHAR |
|
9 |
0 |
|
| SATNR |
Cross-Plant Configurable Material |
SATNR |
|
CHAR |
|
18 |
0 |
|
| KONNR |
Number of Principal Purchase Agreement |
KONNR |
|
CHAR |
|
10 |
0 |
|
| KTPNR |
Item Number of Principal Purchase Agreement |
KTPNR |
|
NUMC |
|
5 |
0 |
|
| KTWRT |
Target Value for Header Area per Distribution |
KTWRT |
|
CURR |
|
15 |
2 |
|
| KMEINH |
Base Unit of Measure |
MEINS |
|
UNIT |
|
3 |
0 |
|
| UMREZ |
Numerator for Conversion of Order Unit to Base Unit |
UMBSZ |
|
DEC |
|
5 |
0 |
|
| UMREN |
Denominator for Conversion of Order Unit to Base Unit |
UMBSN |
|
DEC |
|
5 |
0 |
|
| KDATE |
End of Validity Period |
KDATE |
|
DATS |
|
8 |
0 |
|
| BEDAT |
Purchasing Document Date |
EBDAT |
|
DATS |
|
8 |
0 |
|
| KTMNG |
Target Quantity |
KTMNG |
|
QUAN |
|
13 |
3 |
|
| NETPR |
Net Price in Purchasing Document (in Document Currency) |
BPREI |
|
CURR |
|
11 |
2 |
|
| PEINH |
Price Unit |
EPEIN |
|
DEC |
|
5 |
0 |
|
| BPRME |
Order Price Unit (Purchasing) |
BBPRM |
|
UNIT |
|
3 |
0 |
|
| BPUMZ |
Numerator for Conversion of Order Price Unit into Order Unit |
BPUMZ |
|
DEC |
|
5 |
0 |
|
| BPUMN |
Denominator for Conv. of Order Price Unit into Order Unit |
BPUMN |
|
DEC |
|
5 |
0 |
|
| WAERS |
Currency Key |
WAERS |
|
CUKY |
|
5 |
0 |
|
| WKURS |
Exchange Rate |
WKURS |
|
DEC |
|
9 |
5 |
|
| KUFIX |
Indicator: Fixing of Exchange Rate |
KUFIX |
|
CHAR |
|
1 |
0 |
Possible values
|
| LMEIN |
Base Unit of Measure |
LAGME |
|
UNIT |
|
3 |
0 |
|
| OFZMG |
Open Target Quantity in the Case of Outline Agreements |
OFZMG |
|
QUAN |
|
13 |
3 |
|
| OMEINH |
Base Unit of Measure |
MEINS |
|
UNIT |
|
3 |
0 |
|
| OVALUE |
Target Value for Header Area per Distribution |
KTWRT |
|
CURR |
|
15 |
2 |
|
| OWAERS |
Currency Key |
WAERS |
|
CUKY |
|
5 |
0 |
|
| OPROC |
Open Contract Quantity in % |
WCONOPROC |
|
DEC |
|
5 |
2 |
|
| OPROCV |
Open Contract Value in % |
WCONOPROCV |
|
DEC |
|
5 |
2 |
|
| BSART |
Purchasing Document Type |
ESART |
|
CHAR |
|
4 |
0 |
|
| NOTSELECT |
Contract Cannot Be Selected |
WCONNOTSELECT |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Not Selected |
| X |
Selected |
|
| SELECTED |
Selected Contract |
WCONSELECTED |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Not Selected |
| X |
Selected |
|
| FRGKZ |
Release Indicator |
FRGKZ |
|
CHAR |
|
1 |
0 |
|
| FRGKZ_ICON |
Release Status Icon |
FRGKZ_ICON |
|
CHAR |
|
30 |
0 |
|
