P_ClfnSdmInobIncons

DDL: P_CLFNSDMINOBINCONS Type: view BASIC Package: NGC_CORE_DB

Helper View for INOB Inconsistency SDM

P_ClfnSdmInobIncons is a Basic CDS View that provides data about "Helper View for INOB Inconsistency SDM" in SAP S/4HANA. It reads from 3 data sources (inob, kssk, tcla) and exposes 5 fields. Part of development package NGC_CORE_DB.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
inob inob left_outer
kssk kssk from
tcla tcla inner

Annotations (11)

NameValueLevelField
EndUserText.label Helper View for INOB Inconsistency SDM view
ClientHandling.algorithm #AUTOMATED view
AbapCatalog.sqlViewName PSDMINOBINC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
VDM.private true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #NONE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (5)

KeyFieldSource TableSource FieldDescription
kssk_objek kssk objek
kssk_mafid kssk mafid
kssk_klart kssk klart
kssk_clint kssk clint
kssk_adzhl kssk adzhl 
// Classification Helper View for INOB Inconsistency SDM

@EndUserText.label: 'Helper View for INOB Inconsistency SDM'
@ClientHandling.algorithm: #AUTOMATED
@AbapCatalog: {
  sqlViewName: 'PSDMINOBINC',
  compiler.compareFilter: true
}
@AccessControl.authorizationCheck: #NOT_ALLOWED
@VDM: {
  private: true,
  viewType: #BASIC,
  lifecycle.contract.type: #NONE
}

@ObjectModel: {
  usageType.sizeCategory: #L,
  usageType.serviceQuality: #X,
  usageType.dataClass: #TRANSACTIONAL
}

// Statuses:

//   01 - Existent line in KSSK without existent line in INOB

//   02 - Everything is ok, no conversion required


define view P_ClfnSdmInobIncons
  as select from kssk
    inner join tcla on kssk.klart = tcla.klart and tcla.multobj = 'X'
    left outer join inob on kssk.objek = inob.cuobj
  {
    kssk.objek as kssk_objek,
    kssk.mafid as kssk_mafid,
    kssk.klart as kssk_klart,
    kssk.clint as kssk_clint,
    kssk.adzhl as kssk_adzhl,

    case
      when inob.objek is null
      then '01'
      else '02'
    end as sdm_status
  } where kssk.mafid = 'O'

Learn More