P_CLFNSDMEXTCAWNBASE

DDL: P_CLFNSDMEXTCAWNBASE Type: view BASIC

P_CLFNSDMEXTCAWNBASE is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (cabn) and exposes 11 fields with key fields atinn, adzhl.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
cabn cabn from

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #AUTOMATED view
AbapCatalog.sqlViewName PSDMECAWNB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true 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
AccessControl.authorizationCheck #NOT_ALLOWED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY atinn cabn atinn
KEY adzhl cabn adzhl
atnam cabn atnam
atfor cabn atfor
anzst cabn anzst
anzdz cabn anzdz
atdim cabn atdim
atdex cabn atdex
msehi cabn msehi
atvor cabn atvor
anzdz_atdim 
// Classification Helper View for Ext. CAWN SDM, base

@ClientHandling.algorithm: #AUTOMATED
@AbapCatalog: {
  sqlViewName: 'PSDMECAWNB',
  compiler.compareFilter: true,
  preserveKey: true
}
@VDM: {
  private: true,
  viewType: #BASIC,
  lifecycle.contract.type: #NONE
}
@ObjectModel: {
  usageType.sizeCategory: #L,
  usageType.serviceQuality: #X,
  usageType.dataClass: #TRANSACTIONAL
}
@AccessControl.authorizationCheck: #NOT_ALLOWED

define view P_CLFNSDMEXTCAWNBASE as
  select from cabn
{
  key cabn.atinn,
  key cabn.adzhl,
      cabn.atnam,
      cabn.atfor,
      cabn.anzst,
      cabn.anzdz,
      cabn.atdim,
      cabn.atdex,
      cabn.msehi,
      cabn.atvor,
      ( cabn.anzdz - cabn.atdim ) as anzdz_atdim
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CABN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More