C_SCChkSalesDocTypeVH

DDL: C_SCCHKSALESDOCTYPEVH SQL: CSCCSALESTYPEVH Type: view CONSUMPTION

Consumption VH for Sales Document Type

C_SCChkSalesDocTypeVH is a Consumption CDS View that provides data about "Consumption VH for Sales Document Type" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentType) and exposes 4 fields with key field SalesDocumentType. It has 1 association to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentType I_SalesDocumentType from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_SalesDocumentTypeText _Text $projection.SalesDocumentType = _Text.SalesDocumentType

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CSCCSALESTYPEVH view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey SalesDocumentType view
Search.searchable true view
EndUserText.label Consumption VH for Sales Document Type view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY SalesDocumentType SalesDocumentType Sales Document Type
SalesDocumentTypeName Description
SDDocumentCategory SDDocumentCategory
_Text _Text 
@AbapCatalog.sqlViewName:'CSCCSALESTYPEVH'
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm:#SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'SalesDocumentType'
@Search.searchable: true
@EndUserText.label: 'Consumption VH for Sales Document Type'
define view C_SCChkSalesDocTypeVH 

as select from I_SalesDocumentType 
    association [0..*] to I_SalesDocumentTypeText as _Text 
    on $projection.SalesDocumentType = _Text.SalesDocumentType

{   
    @EndUserText.label : 'Sales Document Type'
    @ObjectModel.text.association: '_Text'
    @UI.hidden: true
    @Search: { defaultSearchElement: true, ranking: #HIGH } 
    key SalesDocumentType,

  
    @EndUserText.label: 'Description'
    cast(_Text[1: Language=$session.system_language].SalesDocumentTypeName as tvakt_bezei) as SalesDocumentTypeName,

     @Search: { defaultSearchElement: true, ranking: #HIGH }
     SDDocumentCategory,
  
    _Text
}
where SDDocumentCategory = 'G' 
  or  SDDocumentCategory = 'C'   
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENTTYPE",
"I_SALESDOCUMENTTYPETEXT"
],
"ASSOCIATED":
[
"I_SALESDOCUMENTTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More