SAP table WCOCOH (Condition Contract: Header)

SAP table WCOCOH has 2 primary key fields being CLIENT,NUM.

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 T000 MANDT
NUM Condition Contract CHAR 10 0 WCB_COCO_NUM
CONTRACT_TYPE Condition Contract Type CHAR 4 0 TWCBCONTRTYPE WCB_CONTRACT_TYPE
VEND_OWNER Supplier as Partner of a Condition Contract CHAR 10 0 LFA1 WCB_VEND_OWNER
CUST_OWNER Customer as Partner of a Condition Contract CHAR 10 0 KNA1 WCB_CUST_OWNER
REFERENCE Condition Contract: Reference CHAR 16 0 WCB_REFERENCE
ASSIGNMENT Condition Contract: Assignment CHAR 16 0 WCB_ASSIGNMENT
EXT_PARTNER Condition Contract: External Partner CHAR 10 0 WCB_EXTERNAL_PARTNER
CREATED_BY Condition Contract Created By CHAR 12 0 WCB_CREATED_BY
CREATED_ON Date of Condition Contract Creation DATS 8 0 WCB_CREATED_ON
REC_TIME Time of Condition Contract Creation TIMS 6 0 WCB_REC_TIME
EKORG Purchasing organization CHAR 4 0 T024E EKORG
EKGRP Purchasing Group CHAR 3 0 T024 EKGRP
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
SPART Division CHAR 2 0 TSPA SPART
ZTERM Terms of payment key CHAR 4 0 DZTERM
ZBD1T Cash (Prompt Payment) Discount Days DEC 3 0 DZBDET
ZBD1P Cash discount percentage 1 DEC 5 3 DZBD1P
ZBD2T Cash discount days 2 DEC 3 0 DZBD2T
ZBD2P Cash Discount Percentage 2 DEC 5 3 DZBD2P
ZBD3T Net Payment Terms Period DEC 3 0 DZBD3T
ZLSCH Payment Method CHAR 1 0 DZLSCH
GUID Condition Contract GUID RAW 16 0 WCB_GUID
DEACT Condition Contract or Eligible Partner is Inactive CHAR 1 0 WCB_DEACTIVATED
Active
X Deactivated
DATE_FROM Valid From DATS 8 0 WCB_DATE_FROM
DATE_TO Valid To DATS 8 0 WCB_DATE_TO
ZONLO Time Zone CHAR 6 0 SYSTZONLO
EXT_NUM External Document Identifier CHAR 30 0 WCB_EXTERNAL_NUMBER
CC_CURR Currency of Condition Contract CUKY 5 0 TCURC WCB_CC_CURR
RATE Exchange Rate DEC 9 5 WCB_WKURS
RATE_DATE Conversion Date DATS 8 0 WCB_WWERT_D
RATE_TYPE Exchange Rate Type CHAR 4 0 TCURV KURST
VKGRP Sales group CHAR 3 0 TVBVK VKGRP
VKBUR Sales office CHAR 4 0 TVBUR VKBUR
ACCESS_TYPE Access Type CHAR 1 0 WCB_ACCESS_TYPE
Exclusive
A Not Exclusive
SETTL_MATNR Settlement Material CHAR 40 0 MARA WB2_SETTLEMENT_MATNR
SETTL_TYPE_VEND Settlement Type Supplier CHAR 1 0 WB2_SETTLEMENT_TYPE_VENDOR
As Accounts Payable
1 As Accounts Receivable
2 No Automatic Settlement
3 Only Accruals Reversal
4 Proforma as Accounts Payable
5 Proforma as Accounts Receivable
SETTL_CAL_FINAL Calendar for Final Settlement CHAR 2 0 TFACD WB2_SETTLEMENT_CALENDAR
SETTL_CAL_PART Calendar for Partial Settlement CHAR 2 0 TFACD WB2_SETTLEMENT_CALENDAR_PART
BUKRS Company Code CHAR 4 0 T001 BUKRS
SETTL_TYPE_CUST Settlement Type Customer CHAR 1 0 WB2_SETTLEMENT_TYPE_CUSTOMER
As Accounts Receivable
1 As Accounts Payable
2 No Automatic Settlement
3 Only Accruals Reversal
4 Proforma as Accounts Receivable
5 Proforma as Accounts Payable
6 Only Accruals Reversal as Accounts Payable
CH_NAME Condition Contract Last Changed By CHAR 12 0 WCB_CHANGED_BY
CH_DATE Date of Last Condition Contract Change DATS 8 0 WCB_CHANGED_ON
CH_TIME Time of Last Condition Contract Change TIMS 6 0 WCB_CHANGED_AT
EXTENSION_CAL Calendar for Condition Contract Extension CHAR 2 0 TFACD WB2_EXTENSION_CALENDAR
PRED_CC Predecessor Condition Contract CHAR 10 0 WCB_PRED_COCO_NUM
CATEGORY Condition Contract Category CHAR 2 0 TWCBCATEGORY WCB_CONTRACT_CATEGORY
CC_PURPOSE Condition Contract Purpose CHAR 2 0 WCB_CC_PURPOSE
nothing
C CRM-Integration
P PMR-Integration
EXT_REF_CAT External Reference Document Category CHAR 2 0 WCB_REF_CAT
01 PMR
02 Trade Promotion
12 Sales Order/Contract
22 Provider Contract
99 External Document
EXT_REF External Reference CHAR 32 0 WCB_EXTERNAL_NUMBER2
KOLIF Prior Supplier CHAR 10 0 LFA1 KOLIF
SETTL_CAL_DELTA Calendar for Delta Settlement CHAR 2 0 TFACD WB2_SETTLEMENT_CALENDAR_DELTA
BVTAB_GROUP Business Volume Table Group CHAR 4 0 WB2_C_BVTAB_GRP WB2_BVTAB_GROUP
SETTL_CAL_ACCR Calendar for Delta Accruals Settlement CHAR 2 0 TFACD WB2_SETTLEMENT_CALENDAR_ACCR
AF_GROUP Amount Fields Group CHAR 4 0 WB2_C_AF_GROUP WB2_AMOUNT_FIELDS_GROUP
SETTL_MEINS Settlement Unit of Measure UNIT 3 0 T006 WB2_SETTLEMENT_MEINS
SETTL_GEWEI Settlement Unit of Weight UNIT 3 0 T006 WB2_SETTLEMENT_GEWEI
SETTL_VOLEH Settlement Unit of Volume UNIT 3 0 T006 WB2_SETTLEMENT_VOLEH
SETTL_PUNEI Settlement Points Unit UNIT 3 0 T006 WB2_SETTLEMENT_PUNEI
ACCRUALS_UPD_REQ Accruals Update Required CHAR 1 0 WB2_ACCRUALS_UPDATE_REQ
SETTL_CAL_ACCR_ROLLO Calendar for Accruals Deferral Settlement CHAR 2 0 TFACD WB2_SETTLEMENT_CAL_ACCR_ROLLO
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
CREATED_ON_TSTMP UTC Time Stamp of Condition Contract Creation DEC 15 0 WCB_CREATED_ON_TIMESTAMP
CH_TSTMP UTC Time Stamp of Last Condition Contract Change DEC 15 0 WCB_CHANGED_ON_TIMESTAMP
STCEG VAT Registration Number CHAR 20 0 WCB_STCEG
PERSON_OWNER Person as Partner of a Condition Contract NUMC 8 0 WCB_PERSON_OWNER
AFSC_GROUP Group of Split Criteria Used for Total Amounts as per Split CHAR 4 0 WB2_C_AFSC_GRP WB2_AMOUNT_FIELDS_SC_GROUP
TAX_COUNTRY Partner Tax Country/Region CHAR 3 0 T005 WCB_TAX_COUNTRY
PROCESS_VARIANT Condition Contract Process Variant CHAR 4 0 WCB_C_PROC_VAR WCB_PROCESS_VARIANT
EXT_REF_ITEM External Reference Item NUMC 10 0 WCB_EXTERNAL_REF_ITEM
COCO_DET_REL_CONTR CC Determination Relevance in Pricing (Condition Contract) CHAR 1 0 WB2_COCO_DETERM_REL_CONTRACT
From Customizing
1 Only if Partner is Business Volume Selection Criterion
2 Always
3 Not Relevant
TAX_REPORTING_COUNTRY Tax Reporting Country/Region CHAR 3 0 T005 FOT_TAX_COUNTRY
SETTL_VARIANT Settlement Variant in Condition Contract Management CHAR 4 0 WB2_C_SETTL_VAR WB2_SETTLEMENT_VARIANT
OWNER_TYPE Type of Business Partner for Condition Contract CHAR 2 0 WCB_OWNER_TYPE
C Customer
N No Contract Partner
V Supplier
PROCESS_CATEGORY Process Category of a Condition Contract CHAR 2 0 WCB_PROCESS_CATEGORY
Standard
1 Supplier Rebate
2 Customer Rebate
3 Commission
4 Royalties
5 Factoring
REBATE_TYPE Condition Contract Settlement Type CHAR 1 0 WB2_REBATE_TYPE
None
1 Supplier Contract Settlement
2 Customer Contract Settlement
SDM_VERSION SDM: Version Field for WCOCOH CHAR 2 0 WCB_SDM_VERSION_WCOCOH
01 Migrated Customizing Fields in WCOCOH
DUMMY_WCOCOH_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
EXT_GUID External Condition Contract GUID RAW 16 0 WCB_EXT_GUID_CC

WCOCOH foreign key relationships

Table Field Check Table Check Field
0 WCOCOH AFSC_GROUP WB2_C_AFSC_GRP Amount Fields Split criteria Groups MANDT
1 WCOCOH AF_GROUP WB2_C_AF_GROUP Amount Fields Groups MANDT
0 WCOCOH BUKRS T001 Company Codes BUKRS
1 WCOCOH BVTAB_GROUP WB2_C_BVTAB_GRP Business Volume Table Group MANDT
0 WCOCOH CATEGORY TWCBCATEGORY Condition Contract Category CLIENT
0 WCOCOH CATEGORY TWCBCATEGORY Condition Contract Category CATEGORY
1 WCOCOH CC_CURR TCURC Currency Codes MANDT
1 WCOCOH CC_CURR TCURC Currency Codes WAERS
0 WCOCOH CLIENT T000 Clients MANDT
1 WCOCOH CONTRACT_TYPE TWCBCONTRTYPE Condition Contract Type CLIENT
1 WCOCOH CONTRACT_TYPE TWCBCONTRTYPE Condition Contract Type CONTRACT_TYPE
0 WCOCOH CUST_OWNER KNA1 General Data in Customer Master MANDT
0 WCOCOH CUST_OWNER KNA1 General Data in Customer Master KUNNR
1 WCOCOH EKGRP T024 Purchasing Groups EKGRP
0 WCOCOH EKORG T024E Purchasing Organizations EKORG
1 WCOCOH KOLIF LFA1 Supplier Master (General Section) MANDT
1 WCOCOH KOLIF LFA1 Supplier Master (General Section) LIFNR
0 WCOCOH PROCESS_VARIANT WCB_C_PROC_VAR Condition Contract Process Variant MANDT
1 WCOCOH RATE_TYPE TCURV Exchange rate types for currency translation MANDT
1 WCOCOH RATE_TYPE TCURV Exchange rate types for currency translation KURST
0 WCOCOH SETTL_GEWEI T006 Units of Measurement MANDT
0 WCOCOH SETTL_GEWEI T006 Units of Measurement MSEHI
1 WCOCOH SETTL_MATNR MARA General Material Data MATNR
0 WCOCOH SETTL_MEINS T006 Units of Measurement MANDT
0 WCOCOH SETTL_MEINS T006 Units of Measurement MSEHI
1 WCOCOH SETTL_PUNEI T006 Units of Measurement MANDT
1 WCOCOH SETTL_PUNEI T006 Units of Measurement MSEHI
0 WCOCOH SETTL_VARIANT WB2_C_SETTL_VAR Settlement Variant MANDT
1 WCOCOH SETTL_VOLEH T006 Units of Measurement MANDT
1 WCOCOH SETTL_VOLEH T006 Units of Measurement MSEHI
0 WCOCOH SPART TSPA Organizational Unit: Sales Divisions MANDT
0 WCOCOH SPART TSPA Organizational Unit: Sales Divisions SPART
1 WCOCOH TAX_COUNTRY T005 Countries MANDT
1 WCOCOH TAX_COUNTRY T005 Countries LAND1
0 WCOCOH TAX_REPORTING_COUNTRY T005 Countries MANDT
0 WCOCOH TAX_REPORTING_COUNTRY T005 Countries LAND1
1 WCOCOH VEND_OWNER LFA1 Supplier Master (General Section) MANDT
1 WCOCOH VEND_OWNER LFA1 Supplier Master (General Section) LIFNR
0 WCOCOH VKBUR TVBUR Organizational Unit: Sales Offices MANDT
1 WCOCOH VKGRP TVBVK Organizational Unit: Sales Groups per Sales Office MANDT
0 WCOCOH VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 WCOCOH VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 WCOCOH VTWEG TVTW Organizational Unit: Distribution Channels MANDT
1 WCOCOH VTWEG TVTW Organizational Unit: Distribution Channels VTWEG