WCOCOI
Condition Contract: Eligible Partner
WCOCOI is an SAP database table in S/4HANA. Condition Contract: Eligible Partner. It contains 27 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_CndnContr_Eligible_ValueHelp | view | from | BASIC | Search Help for Condition Contracts with Eligible Partners |
| P_CndnContrItemText | view_entity | from | BASIC | Condition Contract Item Plain Long Text |
| R_ConditionDocumentItem | view_entity | from | BASIC | Condition Document Item |
Fields (27)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | mandt | Client | |||
| KEY | num | wcb_coco_num | Condition Contract | |||
| KEY | item_guid | wcb_item_guid | Item GUID | |||
| guid | wcb_guid | ConContr. GUID | ||||
| eligible_cust | wcb_eligible_cust | Eligible Cust. | ||||
| eligible_vendor | wcb_eligible_vendor | Eligible Suppl. | ||||
| list_num | wcb_list_num | List Number | ||||
| exclusion | wcb_exclusion | Exclude Partner | ||||
| reference | wcb_reference_elig_partner | Reference | ||||
| deact | wcb_deactivated | Inactive | ||||
| date_from | wcb_date_from_i | Valid From | ||||
| date_to | wcb_date_to_i | Valid To | ||||
| eligible_plant | werks_d | Plant | ||||
| quantity | wcb_quantity | Quantity | ||||
| unit_of_measure | wcb_unit_of_measure | Unit | ||||
| _dataaging | data_temperature | Data Aging | ||||
| amount | wcb_amount | Amount | ||||
| currency | wcb_currency | Currency | ||||
| material | matnr | Material | ||||
| posnr | wcb_posnr | Contract Item | ||||
| sont_abbrv_i | wlf_bo_node_type_abbrv | SAP Object Node Type Abbreviation | ||||
| semantic_type_i | wlf_semantic_type | Semantic Type | ||||
| bukrs | bukrs | Company Code | ||||
| kostl | kostl | Cost Center | ||||
| aufnr | aufnr | Order | ||||
| ps_psp_pnr | ps_psp_pnr | WBS Element | ||||
| distribution_ratio | wcb_distribution_ratio | Distribution Ratio |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Condition Contract: Eligible Partner
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WCOCOI (
CLIENT, -- Client [mandt]
NUM, -- Condition Contract [wcb_coco_num]
ITEM_GUID, -- Item GUID [wcb_item_guid]
GUID, -- ConContr. GUID [wcb_guid]
ELIGIBLE_CUST, -- Eligible Cust. [wcb_eligible_cust]
ELIGIBLE_VENDOR, -- Eligible Suppl. [wcb_eligible_vendor]
LIST_NUM, -- List Number [wcb_list_num]
EXCLUSION, -- Exclude Partner [wcb_exclusion]
REFERENCE, -- Reference [wcb_reference_elig_partner]
DEACT, -- Inactive [wcb_deactivated]
DATE_FROM, -- Valid From [wcb_date_from_i]
DATE_TO, -- Valid To [wcb_date_to_i]
ELIGIBLE_PLANT, -- Plant [werks_d]
QUANTITY, -- Quantity [wcb_quantity]
UNIT_OF_MEASURE, -- Unit [wcb_unit_of_measure]
_DATAAGING, -- Data Aging [data_temperature]
AMOUNT, -- Amount [wcb_amount]
CURRENCY, -- Currency [wcb_currency]
MATERIAL, -- Material [matnr]
POSNR, -- Contract Item [wcb_posnr]
SONT_ABBRV_I, -- SAP Object Node Type Abbreviation [wlf_bo_node_type_abbrv]
SEMANTIC_TYPE_I, -- Semantic Type [wlf_semantic_type]
BUKRS, -- Company Code [bukrs]
KOSTL, -- Cost Center [kostl]
AUFNR, -- Order [aufnr]
PS_PSP_PNR, -- WBS Element [ps_psp_pnr]
DISTRIBUTION_RATIO, -- Distribution Ratio [wcb_distribution_ratio]
PRIMARY KEY (CLIENT, NUM, ITEM_GUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA