I_CustomsTariffNumber

DDL: I_CUSTOMSTARIFFNUMBER SQL: ICUSTRIFNMBR Type: view COMPOSITE Package: VDM_SLL_CLS
24 Fields 1 Data Sources 2 Associations

Customs Tariff Number

I_CustomsTariffNumber is a Composite CDS View that provides data about "Customs Tariff Number" in SAP S/4HANA. It reads from 1 data source (I_TrdClassfctnNmbr) and exposes 24 fields with key fields TrdClassfctnNmbrSchmCntnt, CustomsTariffNumber, ValidityStartDate. It has 2 associations to related views. Part of development package VDM_SLL_CLS.

Data Sources (1)

SourceAliasJoin Type
I_TrdClassfctnNmbr _TrdClassfctnNmbr from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_TrdClassfctnNmbrOfficialDesc _OfficialDesc $projection.TrdClassfctnNmbrSchmCntnt = _OfficialDesc.TrdClassfctnNmbrSchmCntnt and $projection.CustomsTariffNumber = _OfficialDesc.TrdClassfctnNmbr and $projection.ValidityStartDate = _OfficialDesc.ValidityStartDate
[0..*] I_TrdClassfctnNmbrCnctntdDesc _CnctntdDesc $projection.TrdClassfctnNmbrSchmCntnt = _CnctntdDesc.TrdClassfctnNmbrSchmCntnt and $projection.CustomsTariffNumber = _CnctntdDesc.TrdClassfctnNmbr and $projection.ValidityStartDate = _CnctntdDesc.ValidityStartDate

Annotations (10)

NameValueLevelField
EndUserText.label Customs Tariff Number view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName ICUSTRIFNMBR view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey CustomsTariffNumber view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY TrdClassfctnNmbrSchmCntnt I_TrdClassfctnNmbr TrdClassfctnNmbrSchmCntnt No. Scheme Content
KEY CustomsTariffNumber Number
KEY ValidityStartDate ValidityStartDate Validity Start Date
TrdClassfctnNmbrForOfclDesc TrdClassfctnNmbr Number
TrdClassfctnNmbrForCnctntdDesc TrdClassfctnNmbr Number
ValidityEndDate ValidityEndDate ValidTo
SupplementaryUnit SupplementaryUnit
SecondSupplementaryUnit SecondSupplementaryUnit
CustomsUnitOfMeasure CustomsUnitOfMeasure 1st Customs Unit
SecondCustomsUnitOfMeasure SecondCustomsUnitOfMeasure 2nd Customs Unit
UnitOfMeasureSystem UnitOfMeasureSystem
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
_TrdClassfctnNmbrSchmCntnt _TrdClassfctnNmbrSchmCntnt
_OfficialDesc _OfficialDesc
_CnctntdDesc _CnctntdDesc
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_SupplementaryUnit _SupplementaryUnit
_SecondSupplementaryUnit _SecondSupplementaryUnit
_CustomsUnitOfMeasure _CustomsUnitOfMeasure
_SecondCustomsUnitOfMeasure _SecondCustomsUnitOfMeasure

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 I_CustomsTariffNumber.
-- 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: ICUSTRIFNMBR

CREATE VIEW I_CustomsTariffNumber AS
SELECT
  _TrdClassfctnNmbr.TrdClassfctnNmbrSchmCntnt AS TrdClassfctnNmbrSchmCntnt,
  cast ( TrdClassfctnNmbr as /sapsll/tarno) AS CustomsTariffNumber,
  ValidityStartDate,
  TrdClassfctnNmbr AS TrdClassfctnNmbrForOfclDesc,
  TrdClassfctnNmbr AS TrdClassfctnNmbrForCnctntdDesc,
  ValidityEndDate,
  SupplementaryUnit,
  SecondSupplementaryUnit,
  CustomsUnitOfMeasure,
  SecondCustomsUnitOfMeasure,
  UnitOfMeasureSystem,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM I_TrdClassfctnNmbr AS _TrdClassfctnNmbr
LEFT OUTER JOIN I_TrdClassfctnNmbrOfficialDesc AS _OfficialDesc ON TrdClassfctnNmbrSchmCntnt = _OfficialDesc.TrdClassfctnNmbrSchmCntnt AND CustomsTariffNumber = _OfficialDesc.TrdClassfctnNmbr AND ValidityStartDate = _OfficialDesc.ValidityStartDate  -- association [0..*]
LEFT OUTER JOIN I_TrdClassfctnNmbrCnctntdDesc AS _CnctntdDesc ON TrdClassfctnNmbrSchmCntnt = _CnctntdDesc.TrdClassfctnNmbrSchmCntnt AND CustomsTariffNumber = _CnctntdDesc.TrdClassfctnNmbr AND ValidityStartDate = _CnctntdDesc.ValidityStartDate  -- association [0..*]
;

Learn More