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
NULL Active
X Deactivated
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
NULL Exclusive
A Not Exclusive
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
NULL as Accounts Payable
1 as Accounts Receivable
2 no automatic Settlement
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
NULL as Accounts Receivable
1 as Accounts Payable
2 no automatic Settlement
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
NULL nothing
P PMR-Integration
EXT_REF_CAT External Reference Document Category WCB_REF_CAT CHAR 2 0
01 PMR
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