I_IntrastatSCForKeyDate

DDL: I_INTRASTATSCFORKEYDATE SQL: IISVCOFORKDATE Type: view COMPOSITE Package: VDM_SLL_CLS
11 Fields 2 Data Sources

Intrastate service code for key date

I_IntrastatSCForKeyDate is a Composite CDS View that provides data about "Intrastate service code for key date" in SAP S/4HANA. It reads from 2 data sources (I_TrdClassfctnNmbrSchmCntntAct, I_IntrastatServiceCode) and exposes 11 fields with key fields TrdClassfctnNmbrSchm, IntrastatServiceCode. Part of development package VDM_SLL_CLS.

Data Sources (2)

SourceAliasJoin Type
I_TrdClassfctnNmbrSchmCntntAct _TrdClassfctnNmbrSchmCntntAct inner
I_IntrastatServiceCode IntrastatServiceCode from

Parameters (1)

NameTypeDefault
P_KeyDate sll_validon

Annotations (10)

NameValueLevelField
EndUserText.label Intrastate service code for key date view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IISVCOFORKDATE 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 (11)

KeyFieldSource TableSource FieldDescription
KEY TrdClassfctnNmbrSchm I_TrdClassfctnNmbrSchmCntntAct TrdClassfctnNmbrSchm Numbering Scheme
KEY IntrastatServiceCode IntrastatServiceCode Intrastat Srvc. Code
TrdClassfctnNmbrSchmCntnt I_IntrastatServiceCode TrdClassfctnNmbrSchmCntnt No. Scheme Content
ValidityStartDate I_IntrastatServiceCode ValidityStartDate Validity Start Date
ValidityEndDate I_IntrastatServiceCode ValidityEndDate ValidTo
TrdClassfctnNmbrForOfclDesc TrdClassfctnNmbrForOfclDesc
TrdClassfctnNmbrForCnctntdDesc TrdClassfctnNmbrForCnctntdDesc
_OfficialDesc _OfficialDesc
_CnctntdDesc _CnctntdDesc
_TrdClassfctnNmbrSchmCntnt _TrdClassfctnNmbrSchmCntnt
_TrdClassfctnNmbrSchm I_TrdClassfctnNmbrSchmCntntAct _TrdClassfctnNmbrSchm

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_IntrastatSCForKeyDate.
-- 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: IISVCOFORKDATE
-- Parameters: P_KeyDate : sll_validon

CREATE VIEW I_IntrastatSCForKeyDate AS
SELECT
  _TrdClassfctnNmbrSchmCntntAct.TrdClassfctnNmbrSchm AS TrdClassfctnNmbrSchm,
  IntrastatServiceCode,
  IntrastatServiceCode.TrdClassfctnNmbrSchmCntnt AS TrdClassfctnNmbrSchmCntnt,
  IntrastatServiceCode.ValidityStartDate AS ValidityStartDate,
  IntrastatServiceCode.ValidityEndDate AS ValidityEndDate,
  TrdClassfctnNmbrForOfclDesc,
  TrdClassfctnNmbrForCnctntdDesc,
  _TrdClassfctnNmbrSchmCntntAct._TrdClassfctnNmbrSchm AS _TrdClassfctnNmbrSchm
FROM I_IntrastatServiceCode AS IntrastatServiceCode
INNER JOIN I_TrdClassfctnNmbrSchmCntntAct AS _TrdClassfctnNmbrSchmCntntAct ON /* join condition not captured in parsed metadata */
;

Learn More