I_CLFNCLASSCHARCBASIC

CDS View

Clfn Class Characteristic Basic

I_CLFNCLASSCHARCBASIC is a CDS View in S/4HANA. Clfn Class Characteristic Basic. It contains 17 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 17 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ClfnClassCharacteristicDEX view_entity from BASIC Characteristic of Clfn Class DEX
I_ClfnClassHierCharcForKeyDate view inner COMPOSITE Clfn Cl Hier Characteristic For Key Date
I_VMSVehicleCharacteristic view inner BASIC View for vehicle Characteristics
P_CharcCtlgVCCharcClAssgmt view from COMPOSITE

Fields (17)

KeyField CDS FieldsUsed in Views
KEY CharcInternalID CharcInternalID 3
KEY CharcPositionNumber CharcPositionNumber 3
KEY ClassInternalID ClassInternalID 2
KEY ValidityEndDate ValidityEndDate 2
ChangeNumber ChangeNumber 2
CharcIsDisplayRelevant CharcIsDisplayRelevant 2
CharcIsPrintRelevant CharcIsPrintRelevant 2
CharcIsProposalRelevant CharcIsProposalRelevant 2
CharcIsPrptnOrProdUnitRelevant CharcIsPrptnOrProdUnitRelevant 2
CharcIsSearchRelevant CharcIsSearchRelevant 2
CharcOriginText CharcOriginText 2
ClassType ClassType 1
ClfnOrganizationalArea ClfnOrganizationalArea 2
IsDeleted IsDeleted 1
OverwrittenCharcInternalID OverwrittenCharcInternalID 2
TimeIntervalNumber TimeIntervalNumber 1
ValidityStartDate ValidityStartDate 2 
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'INGCCLS12'
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Clfn Class Characteristic Basic'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #BASIC
define view I_ClfnClassCharcBasic
  as select from ksml as ClassCharc

{     
  key ClassCharc.clint    as ClassInternalID,
  key ClassCharc.posnr    as CharcPositionNumber,
  key ClassCharc.adzhl    as TimeIntervalNumber,  
      cast ( ClassCharc.imerk as atinn_no_conv preserving type ) as CharcInternalID,
      cast ( ClassCharc.omerk as atinn_no_conv preserving type ) as OverwrittenCharcInternalID,
      cast ( ClassCharc.abtei as clfnorganizationalarea preserving type ) as ClfnOrganizationalArea,
      ClassCharc.klart    as ClassType,
      ClassCharc.aennr    as ChangeNumber,
      ClassCharc.datuv    as ValidityStartDate,
      ClassCharc.datub    as ValidityEndDate,
      ClassCharc.lkenz    as IsDeleted,
//      ClassCharc.dinkb  as CharcCodeLetter, 

      ClassCharc.herku    as CharcOriginText,
      ClassCharc.prop_rel as CharcIsProposalRelevant,
      ClassCharc.pprel    as CharcIsPrptnOrProdUnitRelevant,
//      ClassCharc.mkenn  as CharcStandardCodeLetter, 


      cast ( case ClassCharc.amerk 
      when '1000000000' then 'X'
      when '1200000000' then 'X'
      when '1300000000' then 'X'
      when '1400000000' then 'X'
      when '1230000000' then 'X'
      when '1240000000' then 'X'
      when '1340000000' then 'X'
      when '1234000000' then 'X'
      else ''
      end as charcisprintrelevant preserving type ) as CharcIsPrintRelevant, 
      
      cast ( case ClassCharc.amerk 
      when '2000000000' then 'X'
      when '1200000000' then 'X'
      when '2300000000' then 'X'
      when '2400000000' then 'X'
      when '1230000000' then 'X'
      when '1240000000' then 'X'
      when '2340000000' then 'X'
      when '1234000000' then 'X'
      else ''
      end as charcissearchrelevant preserving type ) as CharcIsSearchRelevant, 
      
      cast ( case ClassCharc.amerk  
      when '3000000000' then 'X'
      when '1300000000' then 'X'
      when '2300000000' then 'X'
      when '3400000000' then 'X'
      when '1230000000' then 'X'
      when '1340000000' then 'X'
      when '2340000000' then 'X'
      when '1234000000' then 'X'
      else ''
      end as charcisdisplayrelevant preserving type ) as CharcIsDisplayRelevant      
}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"KSML"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More