CIC_I_DistributionChainText

DDL: CIC_I_DISTRIBUTIONCHAINTEXT Type: view_entity

Projection on Distribution Chain

CIC_I_DistributionChainText is a CDS View that provides data about "Projection on Distribution Chain" in SAP S/4HANA. It reads from 3 data sources (tvkov, tvtwt, tvkot) and exposes 4 fields with key fields SalesOrganization, DistributionChannel, Language.

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
tvkov DistributionChain from
tvtwt DistributionChannelText inner
tvkot SalesOrganizationText inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Projection on Distribution Chain view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY SalesOrganization tvkov vkorg
KEY DistributionChannel tvkov vtweg
KEY Language tvkot spras
DistributionChainName 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Projection on Distribution Chain'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
}
define view entity CIC_I_DistributionChainText
  as select from tvkov as DistributionChain
  inner join tvkot as SalesOrganizationText on DistributionChain.vkorg = SalesOrganizationText.vkorg
  inner join tvtwt as DistributionChannelText on DistributionChain.vtweg = DistributionChannelText.vtweg and SalesOrganizationText.spras = DistributionChannelText.spras
{
  key DistributionChain.vkorg as SalesOrganization,
  key DistributionChain.vtweg as DistributionChannel,

  key SalesOrganizationText.spras as Language,

  concat( concat( SalesOrganizationText.vtext, '/' ), DistributionChannelText.vtext ) as DistributionChainName
};

Learn More