view_cc_head_p

DDL: CDS_CC_HEAD_P SQL: CDS_CC_HEAD_P Type: view

Header Related Data of Condition Contract

view_cc_head_p is a CDS View that provides data about "Header Related Data of Condition Contract" in SAP S/4HANA. It reads from 1 data source (wcocoh) and exposes 10 fields with key field num. It has 4 associations to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
wcocoh wcocoh from

Associations (4)

CardinalityTargetAliasCondition
[1..1] twcbcontrtype condition_contract_type $projection.contract_type = condition_contract_type.contract_type
[0..*] twcbcontrtypet condition_contract_type_texts $projection.contract_type = condition_contract_type_texts.contract_type
[0..1] view_lfa1_name_p vend_owner_name $projection.vend_owner = vend_owner_name.vendor_account
[0..1] view_Kna1_name_p cust_owner_name $projection.cust_owner = cust_owner_name.customer_account

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CDS_CC_HEAD_P view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Header Related Data of Condition Contract view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY num num
vend_owner vend_owner
cust_owner cust_owner
category category
reference reference
ekorg ekorg
ekgrp ekgrp
vkorg vkorg
vtweg vtweg
spart spart 
@AbapCatalog.sqlViewName:'CDS_CC_HEAD_P'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Header Related Data of Condition Contract'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #L
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
//can have associations to CDS-views with parameters:

define view view_cc_head_p as
//head of condition contract:

  select from wcocoh
//condition contract type and describing texts:

  association [1..1] to twcbcontrtype  as condition_contract_type       on $projection.contract_type = condition_contract_type.contract_type
  association [0..*] to twcbcontrtypet as condition_contract_type_texts on $projection.contract_type = condition_contract_type_texts.contract_type

// display name of owner vendor

     association [0..1] to view_lfa1_name_p as vend_owner_name           on $projection.vend_owner = vend_owner_name.vendor_account

// display name of owner customer

     association [0..1] to view_Kna1_name_p as cust_owner_name           on $projection.cust_owner = cust_owner_name.customer_account

  {
    key num                                    ,
        contract_type                          ,
        vend_owner                             ,
        cust_owner                             ,
        category                               ,
        reference                              ,
        ekorg                                  ,
        ekgrp                                  ,
        vkorg                                  ,
        vtweg                                  ,
        spart                                  ,
  
//Assoziations:

        condition_contract_type                ,
        condition_contract_type_texts          ,
        vend_owner_name                        ,
        cust_owner_name                        
  } 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WCOCOH"
],
"ASSOCIATED":
[
"VIEW_KNA1_NAME_P",
"VIEW_LFA1_NAME_P",
"TWCBCONTRTYPE",
"TWCBCONTRTYPET"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More