SAP Table WCOCOH
Condition Contract: Header
WCOCOH (Condition Contract: Header) 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 WCOCOH to other SAP tables.
WCOCOH table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CLIENT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
NUM
Condition Contract Number
|
WCB_COCO_NUM |
CHAR
|
10 | 0 | ||||||||||
|
CONTRACT_TYPE
Condition Contract Type
|
WCB_CONTRACT_TYPE | TWCBCONTRTYPE |
CHAR
|
4 | 0 | |||||||||
|
VEND_OWNER
Condition Contract: Owner Vendor
|
WCB_VEND_OWNER | LFA1 |
CHAR
|
10 | 0 | |||||||||
|
CUST_OWNER
Condition Contract: Customer Owner
|
WCB_CUST_OWNER | KNA1 |
CHAR
|
10 | 0 | |||||||||
|
REFERENCE
Condition Contract: Reference
|
WCB_REFERENCE |
CHAR
|
16 | 0 | ||||||||||
|
ASSIGNMENT
Condition Contract: Assignment
|
WCB_ASSIGNMENT |
CHAR
|
16 | 0 | ||||||||||
|
EXT_PARTNER
Condition Contract: External Partner
|
WCB_EXTERNAL_PARTNER |
CHAR
|
10 | 0 | ||||||||||
|
CREATED_BY
Condition Contract: Name of Processor
|
WCB_CREATED_BY |
CHAR
|
12 | 0 | ||||||||||
|
CREATED_ON
Condition Contract: Date on Which Record Was Added
|
WCB_CREATED_ON |
DATS
|
8 | 0 | ||||||||||
|
REC_TIME
Condition Contr.: Time at Which Record Was Added
|
WCB_REC_TIME |
TIMS
|
6 | 0 | ||||||||||
|
EKORG
Purchasing Organization
|
EKORG | T024E |
CHAR
|
4 | 0 | |||||||||
|
EKGRP
Purchasing Group
|
EKGRP | T024 |
CHAR
|
3 | 0 | |||||||||
|
VKORG
Sales Organization
|
VKORG | TVKO |
CHAR
|
4 | 0 | |||||||||
|
VTWEG
Distribution Channel
|
VTWEG | TVTW |
CHAR
|
2 | 0 | |||||||||
|
SPART
Division
|
SPART | TSPA |
CHAR
|
2 | 0 | |||||||||
|
ZTERM
Terms of Payment Key
|
DZTERM |
CHAR
|
4 | 0 | ||||||||||
|
ZBD1T
Cash (Prompt Payment) Discount Days
|
DZBDET |
DEC
|
3 | 0 | ||||||||||
|
ZBD1P
Cash Discount Percentage 1
|
DZBD1P |
DEC
|
5 | 3 | ||||||||||
|
ZBD2T
Cash discount days 2
|
DZBD2T |
DEC
|
3 | 0 | ||||||||||
|
ZBD2P
Cash Discount Percentage 2
|
DZBD2P |
DEC
|
5 | 3 | ||||||||||
|
ZBD3T
Net Payment Terms Period
|
DZBD3T |
DEC
|
3 | 0 | ||||||||||
|
ZLSCH
Payment Method
|
DZLSCH |
CHAR
|
1 | 0 | ||||||||||
|
GUID
Condition Contract GUID
|
WCB_GUID |
RAW
|
16 | 0 | ||||||||||
|
DEACT
Deactivated
|
WCB_DEACTIVATED |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
DATE_FROM
Valid from
|
WCB_DATE_FROM |
DATS
|
8 | 0 | ||||||||||
|
DATE_TO
Valid to
|
WCB_DATE_TO |
DATS
|
8 | 0 | ||||||||||
|
ZONLO
Time Zone
|
SYSTZONLO |
CHAR
|
6 | 0 | ||||||||||
|
EXT_NUM
External Number of Document
|
WCB_EXTERNAL_NUMBER |
CHAR
|
30 | 0 | ||||||||||
|
CC_CURR
Currency of Condition Contract
|
WCB_CC_CURR | TCURC |
CUKY
|
5 | 0 | |||||||||
|
RATE
Exchange Rate
|
WCB_WKURS |
DEC
|
9 | 5 | ||||||||||
|
RATE_DATE
Conversion Date
|
WCB_WWERT_D |
DATS
|
8 | 0 | ||||||||||
|
RATE_TYPE
Exchange Rate Type
|
KURST | TCURV |
CHAR
|
4 | 0 | |||||||||
|
VKGRP
Sales Group
|
VKGRP | TVBVK |
CHAR
|
3 | 0 | |||||||||
|
VKBUR
Sales Office
|
VKBUR | TVBUR |
CHAR
|
4 | 0 | |||||||||
|
ACCESS_TYPE
Access Type
|
WCB_ACCESS_TYPE |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SETTL_MATNR
CCS: Settlement Material
|
WB2_SETTLEMENT_MATNR | MARA |
CHAR
|
18 | 0 | |||||||||
|
SETTL_TYPE_VEND
Condition Contract Settlement: Settlement Type Vendor
|
WB2_SETTLEMENT_TYPE_VENDOR |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
SETTL_CAL_FINAL
Condition Contract Settlement: Settlement Calendar
|
WB2_SETTLEMENT_CALENDAR | TFACD |
CHAR
|
2 | 0 | |||||||||
|
SETTL_CAL_PART
Condition Contract Settlement: Calendar Partial Settlement
|
WB2_SETTLEMENT_CALENDAR_PART | TFACD |
CHAR
|
2 | 0 | |||||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||
|
SETTL_TYPE_CUST
Condition Contract Settlement: Settlement Type Customer
|
WB2_SETTLEMENT_TYPE_CUSTOMER |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
CH_NAME
Name of Person Who Changed Object
|
AENAM |
CHAR
|
12 | 0 | ||||||||||
|
CH_DATE
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||||
|
CH_TIME
Time of Change
|
AEZEIT |
TIMS
|
6 | 0 | ||||||||||
|
EXTENSION_CAL
CCS: Calendar for Contract Extension
|
WB2_EXTENSION_CALENDAR | TFACD |
CHAR
|
2 | 0 | |||||||||
|
PRED_CC
Predecessor Condition Contract number
|
WCB_PRED_COCO_NUM |
CHAR
|
10 | 0 | ||||||||||
|
CATEGORY
Condition Contract Category
|
WCB_CONTRACT_CATEGORY | TWCBCATEGORY |
CHAR
|
2 | 0 | |||||||||
|
CC_PURPOSE
Condition Contract Purpose
|
WCB_CC_PURPOSE |
CHAR
|
2 | 0 | ||||||||||
|
||||||||||||||
|
EXT_REF_CAT
External Reference Document Category
|
WCB_REF_CAT |
CHAR
|
2 | 0 | ||||||||||
|
||||||||||||||
|
EXT_REF
External Reference
|
WCB_EXTERNAL_NUMBER2 |
CHAR
|
32 | 0 | ||||||||||
|
KOLIF
Prior Vendor
|
KOLIF | LFA1 |
CHAR
|
10 | 0 | |||||||||
|
SETTL_CAL_DELTA
Condition Contract Settlement: Calendar Delta Settlement
|
WB2_SETTLEMENT_CALENDAR_DELTA | TFACD |
CHAR
|
2 | 0 | |||||||||
WCOCOH foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| WCOCOH | BUKRS | WCOCOH | CLIENT |
T001
Company Codes
|
MANDT |
| WCOCOH | BUKRS | WCOCOH | BUKRS |
T001
Company Codes
|
BUKRS |
| WCOCOH | CATEGORY | WCOCOH | CLIENT |
TWCBCATEGORY
Condition Contract Category
|
CLIENT |
| WCOCOH | CATEGORY | WCOCOH | CATEGORY |
TWCBCATEGORY
Condition Contract Category
|
CATEGORY |
| WCOCOH | CC_CURR | WCOCOH | CC_CURR |
TCURC
Currency Codes
|
WAERS |
| WCOCOH | CC_CURR | WCOCOH | CLIENT |
TCURC
Currency Codes
|
MANDT |
| WCOCOH | CLIENT | WCOCOH | CLIENT |
T000
Clients
|
MANDT |
| WCOCOH | CONTRACT_TYPE | WCOCOH | CLIENT |
TWCBCONTRTYPE
Condition Contract Type
|
CLIENT |
| WCOCOH | CONTRACT_TYPE | WCOCOH | CONTRACT_TYPE |
TWCBCONTRTYPE
Condition Contract Type
|
CONTRACT_TYPE |
| WCOCOH | CUST_OWNER | WCOCOH | CLIENT |
KNA1
General Data in Customer Master
|
MANDT |
| WCOCOH | CUST_OWNER | WCOCOH | CUST_OWNER |
KNA1
General Data in Customer Master
|
KUNNR |
| WCOCOH | EKGRP | WCOCOH | CLIENT |
T024
Purchasing Groups
|
MANDT |
| WCOCOH | EKGRP | WCOCOH | EKGRP |
T024
Purchasing Groups
|
EKGRP |
| WCOCOH | EKORG | WCOCOH | CLIENT |
T024E
Purchasing Organizations
|
MANDT |
| WCOCOH | EKORG | WCOCOH | EKORG |
T024E
Purchasing Organizations
|
EKORG |
| WCOCOH | EXTENSION_CAL | WCOCOH | EXTENSION_CAL |
TFACD
Factory calendar definition
|
IDENT |
| WCOCOH | KOLIF | WCOCOH | CLIENT |
LFA1
Vendor Master (General Section)
|
MANDT |
| WCOCOH | KOLIF | WCOCOH | KOLIF |
LFA1
Vendor Master (General Section)
|
LIFNR |
| WCOCOH | RATE_TYPE | WCOCOH | CLIENT |
TCURV
Exchange rate types for currency translation
|
MANDT |
| WCOCOH | RATE_TYPE | WCOCOH | RATE_TYPE |
TCURV
Exchange rate types for currency translation
|
KURST |
| WCOCOH | SETTL_CAL_DELTA | WCOCOH | SETTL_CAL_DELTA |
TFACD
Factory calendar definition
|
IDENT |
| WCOCOH | SETTL_CAL_FINAL | WCOCOH | SETTL_CAL_FINAL |
TFACD
Factory calendar definition
|
IDENT |
| WCOCOH | SETTL_CAL_PART | WCOCOH | SETTL_CAL_PART |
TFACD
Factory calendar definition
|
IDENT |
| WCOCOH | SETTL_MATNR | WCOCOH | CLIENT |
MARA
General Material Data
|
MANDT |
| WCOCOH | SETTL_MATNR | WCOCOH | SETTL_MATNR |
MARA
General Material Data
|
MATNR |
| WCOCOH | SPART | WCOCOH | CLIENT |
TSPA
Organizational Unit: Sales Divisions
|
MANDT |
| WCOCOH | SPART | WCOCOH | SPART |
TSPA
Organizational Unit: Sales Divisions
|
SPART |
| WCOCOH | VEND_OWNER | WCOCOH | CLIENT |
LFA1
Vendor Master (General Section)
|
MANDT |
| WCOCOH | VEND_OWNER | WCOCOH | VEND_OWNER |
LFA1
Vendor Master (General Section)
|
LIFNR |
| WCOCOH | VKBUR | WCOCOH | CLIENT |
TVBUR
Organizational Unit: Sales Offices
|
MANDT |
| WCOCOH | VKBUR | WCOCOH | VKBUR |
TVBUR
Organizational Unit: Sales Offices
|
VKBUR |
| WCOCOH | VKGRP | WCOCOH | CLIENT |
TVBVK
Organizational Unit: Sales Groups per Sales Office
|
MANDT |
| WCOCOH | VKGRP | WCOCOH | VKBUR |
TVBVK
Organizational Unit: Sales Groups per Sales Office
|
VKBUR |
| WCOCOH | VKGRP | WCOCOH | VKGRP |
TVBVK
Organizational Unit: Sales Groups per Sales Office
|
VKGRP |
| WCOCOH | VKORG | WCOCOH | CLIENT |
TVKO
Organizational Unit: Sales Organizations
|
MANDT |
| WCOCOH | VKORG | WCOCOH | VKORG |
TVKO
Organizational Unit: Sales Organizations
|
VKORG |
| WCOCOH | VTWEG | WCOCOH | CLIENT |
TVTW
Organizational Unit: Distribution Channels
|
MANDT |
| WCOCOH | VTWEG | WCOCOH | VTWEG |
TVTW
Organizational Unit: Distribution Channels
|
VTWEG |