C_ChCoInfoIntlTransptPrmssn

DDL: C_CHCOINFOINTLTRANSPTPRMSSN SQL: CCCIINTTRPRM Type: view CONSUMPTION
6 Fields 2 Data Sources 1 Associations

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.

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 Chemical Compliance Information PP
KEY DngrsGoodsModeOfTransport DngrsGoodsModeOfTransport Mode of Transport
TransportPermission
TransportPermissionName
TransportPermissionCriticality
_DngrsGoodsModeOfTransportTxt _DngrsGoodsModeOfTransportTxt

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ChCoInfoIntlTransptPrmssn.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CCCIINTTRPRM

CREATE VIEW C_ChCoInfoIntlTransptPrmssn AS
SELECT
  ChmlCmplncInfoUUID,
  DngrsGoodsModeOfTransport,
  cast( '' as ehdgm_transport_permission ) AS TransportPermission,
  cast( '' as val_text ) AS TransportPermissionName,
  cast( 0 as int1) AS TransportPermissionCriticality
FROM I_ChmlCmplncInfo
CROSS JOIN I_DngrsGdsModeOfTransptGrpMap AS MOTGroup
LEFT OUTER JOIN I_DngrsGoodsModeOfTransportTxt AS _DngrsGoodsModeOfTransportTxt ON DngrsGoodsModeOfTransport = _DngrsGoodsModeOfTransportTxt.DngrsGoodsModeOfTransport  -- association [0..*]
;

Learn More