C_CntrlPurContrTypeValueHelp

DDL: C_CNTRLPURCONTRTYPEVALUEHELP SQL: CCNTRLPCTYPEVH Type: view CONSUMPTION

View for Contract Type F4 Help in Central Purchase Contract

C_CntrlPurContrTypeValueHelp is a Consumption CDS View that provides data about "View for Contract Type F4 Help in Central Purchase Contract" in SAP S/4HANA. It reads from 1 data source (I_PurchasingDocumentType) and exposes 2 fields with key field PurchasingDocumentType. It has 1 association to related views.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchasingDocumentType I_PurchasingDocumentType from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PurchasingDocumentTypeText _Text _Text.PurchasingDocumentCategory = 'C' and _Text.PurchasingDocumentType = $projection.PurchasingDocumentType and Language = $session.system_language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CCNTRLPCTYPEVH view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.compiler.compareFilter true view
EndUserText.label View for Contract Type F4 Help in Central Purchase Contract view
Search.searchable true view
VDM.viewType #CONSUMPTION view
ObjectModel.semanticKey PurchasingDocumentType view
ObjectModel.representativeKey PurchasingDocumentType view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocumentType PurchasingDocumentType
PurchasingDocumentTypeName _Text PurchasingDocumentTypeName 
@AbapCatalog.sqlViewName: 'CCNTRLPCTYPEVH'
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'View for Contract Type F4 Help in Central Purchase Contract'
@Search.searchable: true
@VDM.viewType: #CONSUMPTION
@ObjectModel.semanticKey: 'PurchasingDocumentType'
@ObjectModel.representativeKey: 'PurchasingDocumentType'

@ObjectModel.resultSet.sizeCategory: #XS
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER 
define view C_CntrlPurContrTypeValueHelp 

as select from I_PurchasingDocumentType

association [0..1] to I_PurchasingDocumentTypeText as _Text on  _Text.PurchasingDocumentCategory = 'C'
                                                              and _Text.PurchasingDocumentType     = $projection.PurchasingDocumentType
                                                              and Language                         = $session.system_language

 {
   
   @ObjectModel.text.element:  [ 'PurchasingDocumentTypeName' ]
    key PurchasingDocumentType,
    
      @Semantics.text: true
      _Text.PurchasingDocumentTypeName
      
}
where
      PurchasingDocumentCategory = 'C'
       and PurchasingDocumentSubtype is initial

Learn More