SHSM_M_KREDL

DDL: SHSM_M_KREDL SQL: SHSMMKREDL Type: view

CDS View replacing M_KREDL in search help KREDL

SHSM_M_KREDL is a CDS View that provides data about "CDS View replacing M_KREDL in search help KREDL" in SAP S/4HANA. It reads from 1 data source (lfa1) and exposes 18 fields.

Data Sources (1)

SourceAliasJoin Type
lfa1 lfa1 from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName SHSMMKREDL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label CDS View replacing M_KREDL in search help KREDL view

Fields (18)

KeyFieldSource TableSource FieldDescription
land1 lfa1 land1
sortl lfa1 sortl
mcod1 lfa1 mcod1
mcod3 lfa1 mcod3
lifnr lfa1 lifnr
begru lfa1 begru
ktokk lfa1 ktokk
DataController1 lfa1 data_ctrlr1
DataController2 lfa1 data_ctrlr2
DataController3 lfa1 data_ctrlr3
DataController4 lfa1 data_ctrlr4
DataController5 lfa1 data_ctrlr5
DataController6 lfa1 data_ctrlr6
DataController7 lfa1 data_ctrlr7
DataController8 lfa1 data_ctrlr8
DataController9 lfa1 data_ctrlr9
DataController10 lfa1 data_ctrlr10
DataControllerSet lfa1 xdcset
@AbapCatalog.sqlViewName: 'SHSMMKREDL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm : #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.dataCategory: #VALUE_HELP
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'CDS View replacing M_KREDL in search help KREDL' 


define view SHSM_M_KREDL
  as select from lfa1
    //inner join   lfb1 on lfa1.lifnr = lfb1.lifnr //3229444

{

  lfa1.land1,
  lfa1.sortl,
  lfa1.mcod1,
  lfa1.mcod3,
  lfa1.lifnr,
  lfa1.begru,
  lfa1.ktokk,
  //@Consumption.hidden:true                       //3229444

  //lfb1.begru as lfb1_begru                       //3229444

  
  @Consumption.hidden: true
  @UI.hidden: true
  lfa1.data_ctrlr1  as DataController1,
  @Consumption.hidden: true
  @UI.hidden: true
  lfa1.data_ctrlr2  as DataController2,
  @Consumption.hidden: true
  @UI.hidden: true
  lfa1.data_ctrlr3  as DataController3,
  @Consumption.hidden: true
  @UI.hidden: true
  lfa1.data_ctrlr4  as DataController4,
  @Consumption.hidden: true
  @UI.hidden: true
  lfa1.data_ctrlr5  as DataController5,
  @Consumption.hidden: true
  @UI.hidden: true
  lfa1.data_ctrlr6  as DataController6,
  @Consumption.hidden: true
  @UI.hidden: true
  lfa1.data_ctrlr7  as DataController7,
  @Consumption.hidden: true
  @UI.hidden: true
  lfa1.data_ctrlr8  as DataController8,
  @Consumption.hidden: true
  @UI.hidden: true
  lfa1.data_ctrlr9  as DataController9,
  @Consumption.hidden: true
  @UI.hidden: true
  lfa1.data_ctrlr10 as DataController10,
  @Consumption.hidden: true
  @UI.hidden: true
  lfa1.xdcset       as DataControllerSet
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"LFA1"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/