VFCLM_BAM_DDL_CDPOS

DDL: FCLM_BAM_CDPOS SQL: VFCLM_BAM_CDP_VW Type: view

VFCLM_BAM_DDL_CDPOS is a CDS View in SAP S/4HANA. It reads from 2 data sources (cdpos, dd03l) and exposes 16 fields with key fields AccountID, changenr, tabname, tabkey, fname.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
cdpos cdpos from
dd03l structdef left_outer

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName VFCLM_BAM_CDP_VW view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY AccountID cdpos objectid
KEY changenr cdpos changenr
KEY tabname cdpos tabname
KEY tabkey cdpos tabkey
KEY fname cdpos fname
KEY chngind cdpos chngind
text_case cdpos text_case
unit_old cdpos unit_old
unit_new cdpos unit_new
cuky_old cdpos cuky_old
cuky_new cdpos cuky_new
value_new cdpos value_new
value_old cdpos value_old
rollname dd03l rollname
as4local dd03l as4local
as4vers dd03l as4vers 
@AbapCatalog.sqlViewName: 'VFCLM_BAM_CDP_VW'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE 
define view VFCLM_BAM_DDL_CDPOS as 
  select from cdpos as cdpos //[objectclas = 'FCLM_BAM2']

    left outer join dd03l as structdef
      on cdpos.tabname = structdef.tabname
      and structdef.as4local = 'A' // Active only

      and cdpos.fname = structdef.fieldname
{
  key cdpos.objectid as AccountID, 
  key cdpos.changenr,
  key cdpos.tabname,
  key cdpos.tabkey,
  key cdpos.fname,
  key cdpos.chngind,
  cdpos.text_case,
  cdpos.unit_old,
  cdpos.unit_new,
  cdpos.cuky_old,
  cdpos.cuky_new,
  cdpos.value_new,
  cdpos.value_old,
  
  structdef.rollname,
  structdef.as4local,
  structdef.as4vers
}
where objectclas = 'FCLM_BAM3'; 
 
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"CDPOS",
"DD03L"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More