I_ChmlCmplncAddlPrptyStatus

DDL: I_CHMLCMPLNCADDLPRPTYSTATUS Type: view BASIC

Chml Cmplnc Additional Property Status

I_ChmlCmplncAddlPrptyStatus is a Basic CDS View that provides data about "Chml Cmplnc Additional Property Status" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field ChmlCmplncAddlPrptyStatus.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
dd07l Status from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICCADLPTYSTATUS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.representativeKey ChmlCmplncAddlPrptyStatus view
EndUserText.label Chml Cmplnc Additional Property Status view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncAddlPrptyStatus
ChmlCmplncAssgdObjStatusName StatusText ddtext 
@AbapCatalog:
{
  sqlViewName: 'ICCADLPTYSTATUS',
  compiler.compareFilter: true,
  preserveKey: true
}

--Access Control: Authorizations Checks
@AccessControl:
{
  // authorization check not required as view only reads domain values

  authorizationCheck: #NOT_REQUIRED
}

--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

--VDM view type
@VDM.viewType: #BASIC

@ObjectModel:
{
  resultSet.sizeCategory: #XS,
  
  --Performance Annotations
  usageType:
  {
    dataClass: #META,
    sizeCategory: #S,
    serviceQuality: #B
  },
  representativeKey: 'ChmlCmplncAddlPrptyStatus'
}

@EndUserText.label: 'Chml Cmplnc Additional Property Status'
define view I_ChmlCmplncAddlPrptyStatus  
       as select from dd07l as Status
  left outer to one join dd07t as StatusText on Status.domname = StatusText.domname
                                             and Status.domvalue_l = StatusText.domvalue_l 
                                             and StatusText.ddlanguage = $session.system_language
{
  
  key  cast( Status.domvalue_l as ehfnd_cca_adlpr_status ) as ChmlCmplncAddlPrptyStatus,
  
       @Semantics.text: true
       StatusText.ddtext as ChmlCmplncAssgdObjStatusName 
}

where
      Status.domname  = 'EHFND_CCA_ADLPR_STATUS'
  and Status.as4local = 'A'
  and StatusText.domname  = 'EHFND_CCA_ADLPR_STATUS'
  and StatusText.as4local = 'A';

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

Learn More