I_CstmsTrifNmbrForKeyDate

DDL: I_CSTMSTRIFNMBRFORKEYDATE SQL: ITRIFNMBRFKDATE Type: view COMPOSITE Package: VDM_SLL_CLS
20 Fields 2 Data Sources

Customs Tariff Number for Key Date

I_CstmsTrifNmbrForKeyDate is a Composite CDS View that provides data about "Customs Tariff Number for Key Date" in SAP S/4HANA. It reads from 2 data sources (I_TrdClassfctnNmbrSchmCntntAct, I_CustomsTariffNumber) and exposes 20 fields with key fields TrdClassfctnNmbrSchm, CustomsTariffNumber. Part of development package VDM_SLL_CLS.

Data Sources (2)

SourceAliasJoin Type
I_TrdClassfctnNmbrSchmCntntAct _TrdClassfctnNmbrSchmCntntAct inner
I_CustomsTariffNumber CustomsTariffNumber from

Parameters (1)

NameTypeDefault
P_KeyDate sll_validon

Annotations (8)

NameValueLevelField
EndUserText.label Customs Tariff Number for Key Date view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName ITRIFNMBRFKDATE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY TrdClassfctnNmbrSchm I_TrdClassfctnNmbrSchmCntntAct TrdClassfctnNmbrSchm Numbering Scheme
KEY CustomsTariffNumber CustomsTariffNumber
TrdClassfctnNmbrSchmCntnt I_CustomsTariffNumber TrdClassfctnNmbrSchmCntnt No. Scheme Content
ValidityStartDate I_CustomsTariffNumber ValidityStartDate Validity Start Date
ValidityEndDate I_CustomsTariffNumber ValidityEndDate ValidTo
TrdClassfctnNmbrForOfclDesc TrdClassfctnNmbrForOfclDesc
TrdClassfctnNmbrForCnctntdDesc TrdClassfctnNmbrForCnctntdDesc
UnitOfMeasureSystem UnitOfMeasureSystem
CustomsUnitOfMeasure CustomsUnitOfMeasure
SecondCustomsUnitOfMeasure SecondCustomsUnitOfMeasure
SupplementaryUnit SupplementaryUnit
SecondSupplementaryUnit SecondSupplementaryUnit
_OfficialDesc _OfficialDesc
_CnctntdDesc _CnctntdDesc
_TrdClassfctnNmbrSchmCntnt _TrdClassfctnNmbrSchmCntnt
_TrdClassfctnNmbrSchm I_TrdClassfctnNmbrSchmCntntAct _TrdClassfctnNmbrSchm
_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_CstmsTrifNmbrForKeyDate.
-- 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: ITRIFNMBRFKDATE
-- Parameters: P_KeyDate : sll_validon

CREATE VIEW I_CstmsTrifNmbrForKeyDate AS
SELECT
  _TrdClassfctnNmbrSchmCntntAct.TrdClassfctnNmbrSchm AS TrdClassfctnNmbrSchm,
  CustomsTariffNumber,
  CustomsTariffNumber.TrdClassfctnNmbrSchmCntnt AS TrdClassfctnNmbrSchmCntnt,
  CustomsTariffNumber.ValidityStartDate AS ValidityStartDate,
  CustomsTariffNumber.ValidityEndDate AS ValidityEndDate,
  TrdClassfctnNmbrForOfclDesc,
  TrdClassfctnNmbrForCnctntdDesc,
  UnitOfMeasureSystem,
  CustomsUnitOfMeasure,
  SecondCustomsUnitOfMeasure,
  SupplementaryUnit,
  SecondSupplementaryUnit,
  _TrdClassfctnNmbrSchmCntntAct._TrdClassfctnNmbrSchm AS _TrdClassfctnNmbrSchm
FROM I_CustomsTariffNumber AS CustomsTariffNumber
INNER JOIN I_TrdClassfctnNmbrSchmCntntAct AS _TrdClassfctnNmbrSchmCntntAct ON /* join condition not captured in parsed metadata */
;

Learn More