I_IntrastatSCForKeyDate

DDL: I_INTRASTATSCFORKEYDATE SQL: IISVCOFORKDATE Type: view COMPOSITE

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.

2 data source(s) 11 fields

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
KEY IntrastatServiceCode IntrastatServiceCode
TrdClassfctnNmbrSchmCntnt I_IntrastatServiceCode TrdClassfctnNmbrSchmCntnt
ValidityStartDate I_IntrastatServiceCode ValidityStartDate
ValidityEndDate I_IntrastatServiceCode ValidityEndDate
TrdClassfctnNmbrForOfclDesc TrdClassfctnNmbrForOfclDesc
TrdClassfctnNmbrForCnctntdDesc TrdClassfctnNmbrForCnctntdDesc
_OfficialDesc _OfficialDesc
_CnctntdDesc _CnctntdDesc
_TrdClassfctnNmbrSchmCntnt _TrdClassfctnNmbrSchmCntnt
_TrdClassfctnNmbrSchm I_TrdClassfctnNmbrSchmCntntAct _TrdClassfctnNmbrSchm 
@EndUserText.label: 'Intrastate service code for key date'
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'IISVCOFORKDATE'
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.privilegedAssociations:  [ '_CreatedByUser' , '_LastChangedByUser' ]
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'IntrastatServiceCode'

@ObjectModel.usageType.sizeCategory: 'L'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED

define view I_IntrastatSCForKeyDate
  with parameters
    P_KeyDate : sll_validon
  as select from I_IntrastatServiceCode                as IntrastatServiceCode
    inner join   I_TrdClassfctnNmbrSchmCntntAct as _TrdClassfctnNmbrSchmCntntAct on  _TrdClassfctnNmbrSchmCntntAct.TrdClassfctnNmbrSchmCntnt = IntrastatServiceCode.TrdClassfctnNmbrSchmCntnt
                                                                                 and _TrdClassfctnNmbrSchmCntntAct.ValidityStartDate         <= $parameters.P_KeyDate
                                                                                 and _TrdClassfctnNmbrSchmCntntAct.ValidityEndDate           >= $parameters.P_KeyDate
{
  key _TrdClassfctnNmbrSchmCntntAct.TrdClassfctnNmbrSchm,
  key IntrastatServiceCode,
      IntrastatServiceCode.TrdClassfctnNmbrSchmCntnt,
      IntrastatServiceCode.ValidityStartDate,
      IntrastatServiceCode.ValidityEndDate,
      TrdClassfctnNmbrForOfclDesc,
      TrdClassfctnNmbrForCnctntdDesc,
      
      _OfficialDesc,
      _CnctntdDesc,
      _TrdClassfctnNmbrSchmCntnt,
      _TrdClassfctnNmbrSchmCntntAct._TrdClassfctnNmbrSchm
}
where
      IntrastatServiceCode.ValidityStartDate <= $parameters.P_KeyDate
  and IntrastatServiceCode.ValidityEndDate   >= $parameters.P_KeyDate
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INTRASTATSERVICECODE",
"I_TRDCLASSFCTNNMBRSCHMCNTNTACT"
],
"ASSOCIATED":
[
"I_TRDCLASSFCTNNMBRCNCTNTDDESC",
"I_TRDCLASSFCTNNMBROFFICIALDESC",
"I_TRDCLASSFCTNNMBRSCHM",
"I_TRDCLASSFCTNNMBRSCHMCNTNT"
],
"BASE":
[
"I_INTRASTATSERVICECODE",
"I_TRDCLASSFCTNNMBRSCHMCNTNTACT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More