C_ChCoInfoIntlTransptPrmssn

DDL: C_CHCOINFOINTLTRANSPTPRMSSN SQL: CCCIINTTRPRM Type: view CONSUMPTION

CCI International Transport Permission

C_ChCoInfoIntlTransptPrmssn is a Consumption CDS View that provides data about "CCI International Transport Permission" in SAP S/4HANA. It reads from 2 data sources (I_ChmlCmplncInfo, I_DngrsGdsModeOfTransptGrpMap) and exposes 6 fields with key fields ChmlCmplncInfoUUID, DngrsGoodsModeOfTransport. It has 1 association to related views.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_ChmlCmplncInfo I_ChmlCmplncInfo from
I_DngrsGdsModeOfTransptGrpMap MOTGroup cross

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_DngrsGoodsModeOfTransportTxt _DngrsGoodsModeOfTransportTxt $projection.DngrsGoodsModeOfTransport = _DngrsGoodsModeOfTransportTxt.DngrsGoodsModeOfTransport

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCCIINTTRPRM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label CCI International Transport Permission view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID
KEY DngrsGoodsModeOfTransport DngrsGoodsModeOfTransport
TransportPermission
TransportPermissionName
TransportPermissionCriticality
_DngrsGoodsModeOfTransportTxt _DngrsGoodsModeOfTransportTxt 
@AbapCatalog.sqlViewName: 'CCCIINTTRPRM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'CCI International Transport Permission'

@VDM.viewType: #CONSUMPTION

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel:
{
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #L, // < 10.000.000

    serviceQuality: #C // <= 15 msec

  }
}

define view C_ChCoInfoIntlTransptPrmssn
  as select from I_ChmlCmplncInfo
    cross join   I_DngrsGdsModeOfTransptGrpMap as MOTGroup

  // Text Tables

  association [0..*] to I_DngrsGoodsModeOfTransportTxt as _DngrsGoodsModeOfTransportTxt on $projection.DngrsGoodsModeOfTransport = _DngrsGoodsModeOfTransportTxt.DngrsGoodsModeOfTransport
  
{
  key ChmlCmplncInfoUUID,
  
  @ObjectModel.text.association: '_DngrsGoodsModeOfTransportTxt'
  key DngrsGoodsModeOfTransport,

  @ObjectModel.virtualElement
  @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHDGM_INT_TRANS_PRMSSN_EXIT'
  cast( '' as ehdgm_transport_permission ) as TransportPermission,

  @ObjectModel.virtualElement
  @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHDGM_INT_TRANS_PRMSSN_EXIT'
  cast( '' as val_text )                   as TransportPermissionName,

  @ObjectModel.virtualElement
  @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHDGM_INT_TRANS_PRMSSN_EXIT'
  cast( 0 as int1)                       as TransportPermissionCriticality,
  
  _DngrsGoodsModeOfTransportTxt

}
where
  DngrsGoodsModeOfTransptIsDmstc = ''
  and DngrsGoodsModeOfTransport <> 'AIR'

Learn More