I_IntrastatServiceCode

DDL: I_INTRASTATSERVICECODE SQL: IISSRVCCD Type: view COMPOSITE Package: VDM_SLL_CLS
20 Fields 1 Data Sources 2 Associations

Intrastat Service Code

I_IntrastatServiceCode is a Composite CDS View that provides data about "Intrastat Service Code" in SAP S/4HANA. It reads from 1 data source (I_TrdClassfctnNmbr) and exposes 20 fields with key fields TrdClassfctnNmbrSchmCntnt, IntrastatServiceCode, 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.IntrastatServiceCode = _OfficialDesc.TrdClassfctnNmbr and $projection.ValidityStartDate = _OfficialDesc.ValidityStartDate
[0..*] I_TrdClassfctnNmbrCnctntdDesc _CnctntdDesc $projection.TrdClassfctnNmbrSchmCntnt = _CnctntdDesc.TrdClassfctnNmbrSchmCntnt and $projection.IntrastatServiceCode = _CnctntdDesc.TrdClassfctnNmbr and $projection.ValidityStartDate = _CnctntdDesc.ValidityStartDate

Annotations (10)

NameValueLevelField
EndUserText.label Intrastat Service Code view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IISSRVCCD view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey IntrastatServiceCode view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY TrdClassfctnNmbrSchmCntnt I_TrdClassfctnNmbr TrdClassfctnNmbrSchmCntnt No. Scheme Content
KEY IntrastatServiceCode 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

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_IntrastatServiceCode.
-- 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: IISSRVCCD

CREATE VIEW I_IntrastatServiceCode AS
SELECT
  _TrdClassfctnNmbr.TrdClassfctnNmbrSchmCntnt AS TrdClassfctnNmbrSchmCntnt,
  cast ( TrdClassfctnNmbr as /sapsll/isvco) AS IntrastatServiceCode,
  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 IntrastatServiceCode = _OfficialDesc.TrdClassfctnNmbr AND ValidityStartDate = _OfficialDesc.ValidityStartDate  -- association [0..*]
LEFT OUTER JOIN I_TrdClassfctnNmbrCnctntdDesc AS _CnctntdDesc ON TrdClassfctnNmbrSchmCntnt = _CnctntdDesc.TrdClassfctnNmbrSchmCntnt AND IntrastatServiceCode = _CnctntdDesc.TrdClassfctnNmbr AND ValidityStartDate = _CnctntdDesc.ValidityStartDate  -- association [0..*]
;

Learn More