FCLM_BAM_DM_ATTR

DDL: FCLM_BAM_DM_ATTR SQL: VFCLMBAMDMATTR Type: view

Active Company Code List of FI

FCLM_BAM_DM_ATTR is a CDS View that provides data about "Active Company Code List of FI" in SAP S/4HANA. It reads from 3 data sources (draw, tdwa, drat) and exposes 11 fields.

3 data source(s) 11 fields

Data Sources (3)

SourceAliasJoin Type
draw a from
tdwa b inner
drat c left_outer

Parameters (1)

NameTypeDefault
plang spras

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName VFCLMBAMDMATTR view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Active Company Code List of FI view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (11)

KeyFieldSource TableSource FieldDescription
mandt draw mandt
dktxt
dktxt_uc
dokar draw dokar
doknr draw doknr
dokvr draw dokvr
doktl draw doktl
dwnam draw dwnam
dokst draw dokst
labor draw labor
begru draw begru 
@AbapCatalog.sqlViewName: 'VFCLMBAMDMATTR'
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Active Company Code List of FI'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
define view FCLM_BAM_DM_ATTR
 with parameters
                  @Environment.systemField: #SYSTEM_LANGUAGE
                  plang: spras
as
select from draw as a
inner join tdwa as b
on b.mandt = a.mandt and b.klasse = 'SAP_FCLM_BAM_DOC' and b.dokar = a.dokar
             and a.loedk = ''
left outer join drat as c
              on c.mandt = a.mandt and a.dokar = c.dokar and a.doknr = c.doknr and a.dokvr = c.dokvr and a.doktl = c.doktl
              and c.langu = $parameters.plang
{
 a.mandt,coalesce(c.dktxt,'') as dktxt,coalesce(c.dktxt_uc,'') as dktxt_uc,
             a.dokar,a.doknr,a.dokvr,a.doktl,a.dwnam,a.dokst,a.labor,a.begru

}
 
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"DRAT",
"DRAW",
"TDWA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More