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 | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
EXT_REF_CAT | External Reference Document Category | WCB_REF_CAT | CHAR | 2 | 0 |
Possible values
|
||||||||
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 | CATEGORY | TWCBCATEGORY | Condition Contract Category | CATEGORY |
WCOCOH | CATEGORY | WCOCOH | CLIENT | TWCBCATEGORY | Condition Contract Category | CLIENT |
WCOCOH | CC_CURR | WCOCOH | CLIENT | TCURC | Currency Codes | MANDT |
WCOCOH | CC_CURR | WCOCOH | CC_CURR | TCURC | Currency Codes | WAERS |
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 | EKORG | T024E | Purchasing Organizations | EKORG |
WCOCOH | EKORG | WCOCOH | CLIENT | T024E | Purchasing Organizations | MANDT |
WCOCOH | EXTENSION_CAL | WCOCOH | EXTENSION_CAL | TFACD | Factory calendar definition | IDENT |
WCOCOH | KOLIF | WCOCOH | KOLIF | LFA1 | Vendor Master (General Section) | LIFNR |
WCOCOH | KOLIF | WCOCOH | CLIENT | LFA1 | Vendor Master (General Section) | MANDT |
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 | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
WCOCOH | SPART | WCOCOH | CLIENT | TSPA | Organizational Unit: Sales Divisions | MANDT |
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 |