SAP WCOCOH Condition Contract: Header Table
Overview
WCOCOH is a standard SAP S/4HANA table that stores Condition Contract: Header data. There are total 81 fields in the WCOCOH table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WCOCOH belongs to Chargeback (LO-GT-CHB) module and is located in the package Condition Contract Persistence Layer (WCB_CC_PERS).
In addition, following links provide an overview of foreign key relationships, if any, that link WCOCOH to other SAP tables and standard CDS views available based on WCOCOH table in S/4HANA 2020.
Techincal Settings of WCOCOH
Below are technical details of the table WCOCOH
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WCOCOH Fields
The following table gives you an overview of the fields available in WCOCOH
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 |
| NUM | Condition Contract | WCB_COCO_NUM | CHAR | 10 | |
| CONTRACT_TYPE | Condition Contract Type | WCB_CONTRACT_TYPE | TWCBCONTRTYPE | CHAR | 4 |
| VEND_OWNER | Supplier as Partner of a Condition Contract | WCB_VEND_OWNER | LFA1 | CHAR | 10 |
| CUST_OWNER | Customer as Partner of a Condition Contract | WCB_CUST_OWNER | KNA1 | CHAR | 10 |
| REFERENCE | Condition Contract: Reference | WCB_REFERENCE | CHAR | 16 | |
| ASSIGNMENT | Condition Contract: Assignment | WCB_ASSIGNMENT | CHAR | 16 | |
| EXT_PARTNER | Condition Contract: External Partner | WCB_EXTERNAL_PARTNER | CHAR | 10 | |
| CREATED_BY | Condition Contract Created By | WCB_CREATED_BY | CHAR | 12 | |
| CREATED_ON | Date of Condition Contract Creation | WCB_CREATED_ON | DATS | 8 | |
| REC_TIME | Time of Condition Contract Creation | WCB_REC_TIME | TIMS | 6 | |
| EKORG | Purchasing organization | EKORG | T024E | CHAR | 4 |
| EKGRP | Purchasing Group | EKGRP | T024 | CHAR | 3 |
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 |
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 |
| SPART | Division | SPART | TSPA | CHAR | 2 |
| ZTERM | Terms of payment key | DZTERM | CHAR | 4 | |
| ZBD1T | Cash (Prompt Payment) Discount Days | DZBDET | DEC | 3 | |
| ZBD1P | Cash discount percentage 1 | DZBD1P | DEC | 5 | |
| ZBD2T | Cash discount days 2 | DZBD2T | DEC | 3 | |
| ZBD2P | Cash Discount Percentage 2 | DZBD2P | DEC | 5 | |
| ZBD3T | Net Payment Terms Period | DZBD3T | DEC | 3 | |
| ZLSCH | Payment Method | DZLSCH | CHAR | 1 | |
| GUID | Condition Contract GUID | WCB_GUID | RAW | 16 | |
| DEACT | Condition Contract or Eligible Partner is Inactive | WCB_DEACTIVATED | CHAR | 1 | |
| DATE_FROM | Valid From | WCB_DATE_FROM | DATS | 8 | |
| DATE_TO | Valid To | WCB_DATE_TO | DATS | 8 | |
| ZONLO | Time Zone | SYSTZONLO | CHAR | 6 | |
| EXT_NUM | External Document Identifier | WCB_EXTERNAL_NUMBER | CHAR | 30 | |
| CC_CURR | Currency of Condition Contract | WCB_CC_CURR | TCURC | CUKY | 5 |
| RATE | Exchange Rate | WCB_WKURS | DEC | 9 | |
| RATE_DATE | Conversion Date | WCB_WWERT_D | DATS | 8 | |
| RATE_TYPE | Exchange Rate Type | KURST | TCURV | CHAR | 4 |
| VKGRP | Sales group | VKGRP | TVBVK | CHAR | 3 |
| VKBUR | Sales office | VKBUR | TVBUR | CHAR | 4 |
| ACCESS_TYPE | Access Type | WCB_ACCESS_TYPE | CHAR | 1 | |
| SETTL_MATNR | Settlement Material | WB2_SETTLEMENT_MATNR | MARA | CHAR | 40 |
| SETTL_TYPE_VEND | Settlement Type Supplier | WB2_SETTLEMENT_TYPE_VENDOR | CHAR | 1 | |
| SETTL_CAL_FINAL | Calendar for Final Settlement | WB2_SETTLEMENT_CALENDAR | TFACD | CHAR | 2 |
| SETTL_CAL_PART | Calendar for Partial Settlement | WB2_SETTLEMENT_CALENDAR_PART | TFACD | CHAR | 2 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| SETTL_TYPE_CUST | Settlement Type Customer | WB2_SETTLEMENT_TYPE_CUSTOMER | CHAR | 1 | |
| CH_NAME | Condition Contract Last Changed By | WCB_CHANGED_BY | CHAR | 12 | |
| CH_DATE | Date of Last Condition Contract Change | WCB_CHANGED_ON | DATS | 8 | |
| CH_TIME | Time of Last Condition Contract Change | WCB_CHANGED_AT | TIMS | 6 | |
| EXTENSION_CAL | Calendar for Condition Contract Extension | WB2_EXTENSION_CALENDAR | TFACD | CHAR | 2 |
| PRED_CC | Predecessor Condition Contract | WCB_PRED_COCO_NUM | CHAR | 10 | |
| CATEGORY | Condition Contract Category | WCB_CONTRACT_CATEGORY | TWCBCATEGORY | CHAR | 2 |
| CC_PURPOSE | Condition Contract Purpose | WCB_CC_PURPOSE | CHAR | 2 | |
| EXT_REF_CAT | External Reference Document Category | WCB_REF_CAT | CHAR | 2 | |
| EXT_REF | External Reference | WCB_EXTERNAL_NUMBER2 | CHAR | 32 | |
| KOLIF | Prior Supplier | KOLIF | LFA1 | CHAR | 10 |
| SETTL_CAL_DELTA | Calendar for Delta Settlement | WB2_SETTLEMENT_CALENDAR_DELTA | TFACD | CHAR | 2 |
| BVTAB_GROUP | Business Volume Table Group | WB2_BVTAB_GROUP | WB2_C_BVTAB_GRP | CHAR | 4 |
| SETTL_CAL_ACCR | Calendar for Delta Accruals Settlement | WB2_SETTLEMENT_CALENDAR_ACCR | TFACD | CHAR | 2 |
| AF_GROUP | Amount Fields Group | WB2_AMOUNT_FIELDS_GROUP | WB2_C_AF_GROUP | CHAR | 4 |
| SETTL_MEINS | Settlement Unit of Measure | WB2_SETTLEMENT_MEINS | T006 | UNIT | 3 |
| SETTL_GEWEI | Settlement Unit of Weight | WB2_SETTLEMENT_GEWEI | T006 | UNIT | 3 |
| SETTL_VOLEH | Settlement Unit of Volume | WB2_SETTLEMENT_VOLEH | T006 | UNIT | 3 |
| SETTL_PUNEI | Settlement Points Unit | WB2_SETTLEMENT_PUNEI | T006 | UNIT | 3 |
| ACCRUALS_UPD_REQ | Accruals Update Required | WB2_ACCRUALS_UPDATE_REQ | CHAR | 1 | |
| SETTL_CAL_ACCR_ROLLO | Calendar for Accruals Deferral Settlement | WB2_SETTLEMENT_CAL_ACCR_ROLLO | TFACD | CHAR | 2 |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 | |
| CREATED_ON_TSTMP | UTC Time Stamp of Condition Contract Creation | WCB_CREATED_ON_TIMESTAMP | DEC | 15 | |
| CH_TSTMP | UTC Time Stamp of Last Condition Contract Change | WCB_CHANGED_ON_TIMESTAMP | DEC | 15 | |
| STCEG | VAT Registration Number | WCB_STCEG | CHAR | 20 | |
| PERSON_OWNER | Person as Partner of a Condition Contract | WCB_PERSON_OWNER | NUMC | 8 | |
| AFSC_GROUP | Group of Split Criteria Used for Total Amounts as per Split | WB2_AMOUNT_FIELDS_SC_GROUP | WB2_C_AFSC_GRP | CHAR | 4 |
| TAX_COUNTRY | Partner Tax Country | WCB_TAX_COUNTRY | T005 | CHAR | 3 |
| PROCESS_VARIANT | Condition Contract Process Variant | WCB_PROCESS_VARIANT | WCB_C_PROC_VAR | CHAR | 4 |
| EXT_REF_ITEM | External Reference Item | WCB_EXTERNAL_REF_ITEM | NUMC | 10 | |
| COCO_DET_REL_CONTR | CC Determination Relevance in Pricing (Condition Contract) | WB2_COCO_DETERM_REL_CONTRACT | CHAR | 1 | |
| TAX_REPORTING_COUNTRY | Tax Reporting Country | FOT_TAX_COUNTRY | T005 | CHAR | 3 |
| SETTL_VARIANT | Settlement Variant | WB2_SETTLEMENT_VARIANT | WB2_C_SETTL_VAR | CHAR | 4 |
| EXT_GUID | External Condition Contract GUID | WCB_EXT_GUID_CC | RAW | 16 | |
| YTARGET1 | First Quater Target | YTARGET1 | CHAR | 10 | |
| YTARGET2 | Second Quater Target | YTARGET2 | CHAR | 10 | |
| YTARGET3 | Third Quater Target | YTARGET3 | CHAR | 10 | |
| YTARGET4 | Deal Reg. No. | YTARGET4 | CHAR | 10 | |
| RESELLER | Reseller | ZRESELLER | * | CHAR | 10 |
| END_CUSTOMER | End Customer | ZEND_CUSTOMER | * | CHAR | 10 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WCOCOH
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WCOCOH | AFSC_GROUP | : | WB2_C_AFSC_GRP |
| WCOCOH | AF_GROUP | : | WB2_C_AF_GROUP |
| WCOCOH | BUKRS | : | T001 |
| WCOCOH | BVTAB_GROUP | : | WB2_C_BVTAB_GRP |
| WCOCOH | CATEGORY | : | TWCBCATEGORY |
| WCOCOH | CC_CURR | 1: CN | TCURC |
| WCOCOH | CLIENT | 1: CN | T000 |
| WCOCOH | CONTRACT_TYPE | 1: CN | TWCBCONTRTYPE |
| WCOCOH | CUST_OWNER | 1: CN | KNA1 |
| WCOCOH | EKGRP | : | T024 |
| WCOCOH | EKORG | 1: CN | T024E |
| WCOCOH | EXTENSION_CAL | : | TFACD |
| WCOCOH | KOLIF | : | LFA1 |
| WCOCOH | PROCESS_VARIANT | : | WCB_C_PROC_VAR |
| WCOCOH | RATE_TYPE | 1: CN | TCURV |
| WCOCOH | SETTL_CAL_ACCR | : | TFACD |
| WCOCOH | SETTL_CAL_ACCR_ROLLO | : | TFACD |
| WCOCOH | SETTL_CAL_DELTA | : | TFACD |
| WCOCOH | SETTL_CAL_FINAL | : | TFACD |
| WCOCOH | SETTL_CAL_PART | : | TFACD |
| WCOCOH | SETTL_GEWEI | : | T006 |
| WCOCOH | SETTL_MATNR | : | MARA |
| WCOCOH | SETTL_MEINS | : | T006 |
| WCOCOH | SETTL_PUNEI | : | T006 |
| WCOCOH | SETTL_VARIANT | : | WB2_C_SETTL_VAR |
| WCOCOH | SETTL_VOLEH | : | T006 |
| WCOCOH | SPART | 1: CN | TSPA |
| WCOCOH | TAX_COUNTRY | : | T005 |
| WCOCOH | TAX_REPORTING_COUNTRY | : | T005 |
| WCOCOH | VEND_OWNER | 1: CN | LFA1 |
| WCOCOH | VKBUR | 1: CN | TVBUR |
| WCOCOH | VKGRP | 1: CN | TVBVK |
| WCOCOH | VKORG | 1: CN | TVKO |
| WCOCOH | VTWEG | 1: CN | TVTW |