P_CndnContr_ValueHelp
Search Help for Condition Contracts
P_CndnContr_ValueHelp is a Basic CDS View that provides data about "Search Help for Condition Contracts" in SAP S/4HANA. It reads from 1 data source (wcocoh) and exposes 33 fields with key field num. It has 5 associations to related views. Part of development package WCB_CC_PERS.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| wcocoh | wcocoh | from |
Associations (5)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | R_CndnContrType | _ContractType | $projection.contract_type = _ContractType.CndnContrType |
| [0..1] | P_WLF_CDS_LFA1_BG | _Supplier | $projection.vend_owner = _Supplier.vendor_account |
| [0..1] | P_WLF_CDS_KNA1_BG | _Customer | $projection.cust_owner = _Customer.customer_account |
| [0..1] | P_WLF_CDS_LFA1_BG | _PriorSupplier | $projection.kolif = _PriorSupplier.vendor_account |
| [0..1] | P_WLF_CDS_PERNR_BEGRU | _PersonWorkAgreement | $projection.person_owner = _PersonWorkAgreement.Pernr |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PWCBCOCOVH | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| VDM.viewType | #BASIC | view | |
| VDM.private | true | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ClientHandling.type | #INHERITED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (33)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | num | |||
| vend_owner | vend_owner | |||
| cust_owner | cust_owner | |||
| reference | reference | |||
| assignment | assignment | |||
| ext_partner | ext_partner | |||
| created_by | created_by | |||
| created_on | created_on | |||
| rec_time | rec_time | |||
| ekorg | ekorg | |||
| ekgrp | ekgrp | |||
| vkorg | vkorg | |||
| vtweg | vtweg | |||
| spart | spart | |||
| deact | ||||
| date_from | date_from | |||
| date_to | date_to | |||
| ext_num | ext_num | |||
| vkgrp | vkgrp | |||
| vkbur | vkbur | |||
| owner_type | owner_type | |||
| no_condition | _ContractType | CndnContrHasNoConditions | ||
| name1_kna1 | _Customer | customer_name | ||
| name1_lfa1 | _Supplier | supplier_name | ||
| category | category | |||
| kolif | kolif | |||
| bukrs | bukrs | |||
| pers_kostl | pers_kostl | |||
| person_owner | person_owner | |||
| guid | guid | |||
| rebate_type | ||||
| sont_abbrv_h | sont_abbrv_h | |||
| kolif_begru | _PriorSupplier | vendor_begru |
@AbapCatalog.sqlViewName: 'PWCBCOCOVH'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@VDM.private: true
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XL
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #MANDATORY
@Metadata.ignorePropagatedAnnotations: true
// 'Search Help for Condition Contracts'
define view P_CndnContr_ValueHelp
as select from wcocoh
association [0..1] to R_CndnContrType as _ContractType on $projection.contract_type = _ContractType.CndnContrType
association [0..1] to P_WLF_CDS_LFA1_BG as _Supplier on $projection.vend_owner = _Supplier.vendor_account
association [0..1] to P_WLF_CDS_KNA1_BG as _Customer on $projection.cust_owner = _Customer.customer_account
association [0..1] to P_WLF_CDS_LFA1_BG as _PriorSupplier on $projection.kolif = _PriorSupplier.vendor_account
association [0..1] to P_WLF_CDS_PERNR_BEGRU as _PersonWorkAgreement on $projection.person_owner = _PersonWorkAgreement.Pernr
{
key cast( num as wcb_coco_num preserving type ) as num,
contract_type as contract_type,
vend_owner as vend_owner,
cust_owner as cust_owner,
reference as reference,
assignment as assignment,
ext_partner as ext_partner,
created_by as created_by,
created_on as created_on,
rec_time as rec_time,
ekorg as ekorg,
ekgrp as ekgrp,
vkorg as vkorg,
vtweg as vtweg,
spart as spart,
cast( deact as wcb_deactivated preserving type ) as deact,
date_from as date_from,
date_to as date_to,
ext_num as ext_num,
vkgrp as vkgrp,
vkbur as vkbur,
process_category as process_category,
cast( _ContractType._Text[1: Language = $session.system_language ].CndnContrTypeDesc as wcb_text preserving type ) as text_contrtype,
owner_type as owner_type,
_ContractType.CndnContrHasNoConditions as no_condition,
_Customer.customer_name as name1_kna1,
_Supplier.supplier_name as name1_lfa1,
category as category,
kolif as kolif,
bukrs as bukrs,
pers_kostl as pers_kostl,
person_owner as person_owner,
guid as guid,
cast( rebate_type as wb2_rebate_type preserving type ) as rebate_type,
_ContractType.CndnContrEligibleCat as eligible_type,
_ContractType.BusVolFldCombnSet as busvolbase_type,
cast( _ContractType.CnConMnlSettlmtAllwncCat as wb2_manual_settl_docs_allowed preserving type ) as man_settl_docs,
sont_abbrv_h as sont_abbrv_h,
semantic_type_h as semantic_type_h,
_Supplier.vendor_begru as vend_owner_begru,
_Customer.customer_begru as cust_owner_begru,
_PriorSupplier.vendor_begru as kolif_begru,
_PersonWorkAgreement.pernr_begru as person_owner_begru
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA