P_MDChgProcProdClAssgmt

DDL: P_MDCHGPROCPRODCLASSGMT SQL: PMDCPRODCLASSN Type: view BASIC

P_MDChgProcProdClAssgmt is a Basic CDS View in SAP S/4HANA. It reads from 4 data sources (inob, kssk, kssk, tcla) and exposes 27 fields with key fields objek, mafid, klart, source_clint, adzhl.

4 data source(s) 27 fields

Data Sources (4)

SourceAliasJoin Type
inob inob union
kssk kssk from
kssk kssk inner
tcla tcla inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMDCPRODCLASSN view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY objek kssk objek
KEY mafid kssk mafid
KEY klart kssk klart
KEY source_clint kssk clint
KEY adzhl kssk adzhl
clint kssk clint
zaehl kssk zaehl
statu kssk statu
stdcl kssk stdcl
rekri kssk rekri
aennr kssk aennr
datuv kssk datuv
lkenz kssk lkenz
objek
KEY mafid kssk mafid
KEY klart kssk klart
KEY source_clint kssk clint
KEY adzhl kssk adzhl
clint kssk clint
zaehl kssk zaehl
statu kssk statu
stdcl kssk stdcl
rekri kssk rekri
aennr kssk aennr
datuv kssk datuv
lkenz kssk lkenz
datub kssk datub 
@AbapCatalog.sqlViewName: 'PMDCPRODCLASSN'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@VDM.viewType: #BASIC

define view P_MDChgProcProdClAssgmt
  as select from kssk as kssk
    inner join   tcla as tcla on tcla.klart = kssk.klart
{
  key kssk.objek,
  key kssk.mafid,
  key kssk.klart,
  key kssk.clint as source_clint,
  key kssk.adzhl,
      kssk.clint,
      kssk.zaehl,
      kssk.statu,
      kssk.stdcl,
      kssk.rekri,
      kssk.aennr,
      kssk.datuv,
      kssk.lkenz,
      kssk.datub
}
where
  tcla.multobj = ''
union select from inob as inob
  inner join      kssk as kssk on inob.cuobj = kssk.objek
{
  key inob.objek,
  key kssk.mafid,
  key kssk.klart,
  key kssk.clint as source_clint,
  key kssk.adzhl,
      kssk.clint,
      kssk.zaehl,
      kssk.statu,
      kssk.stdcl,
      kssk.rekri,
      kssk.aennr,
      kssk.datuv,
      kssk.lkenz,
      kssk.datub
}
where
  inob.obtab = 'MARA'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"INOB",
"KSSK",
"TCLA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More