FCLM_BAM_DOC_DM_BK_ATTR

DDL: FCLM_BAM_DOC_DM_BK_ATTR SQL: VFCLMBAMBKATTR Type: view

Active Company Code List of FI

FCLM_BAM_DOC_DM_BK_ATTR is a CDS View that provides data about "Active Company Code List of FI" in SAP S/4HANA. It reads from 2 data sources (FCLM_BAM_DDL_AMD_BASE_NO_HBA, bnka) and exposes 7 fields.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
FCLM_BAM_DDL_AMD_BASE_NO_HBA a from
bnka b left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName VFCLMBAMBKATTR 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 (7)

KeyFieldSource TableSource FieldDescription
mandt FCLM_BAM_DDL_AMD_BASE_NO_HBA mandt
banks FCLM_BAM_DDL_AMD_BASE_NO_HBA banks
bankl FCLM_BAM_DDL_AMD_BASE_NO_HBA bankl
acc_id FCLM_BAM_DDL_AMD_BASE_NO_HBA acc_id
acc_num FCLM_BAM_DDL_AMD_BASE_NO_HBA acc_num
bukrs FCLM_BAM_DDL_AMD_BASE_NO_HBA bukrs
bgrup 
@AbapCatalog.sqlViewName: 'VFCLMBAMBKATTR'
@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_DOC_DM_BK_ATTR as
select from FCLM_BAM_DDL_AMD_BASE_NO_HBA as a
left outer join bnka as b
on a.mandt = b.mandt  and a.banks = b.banks and a.bankl = b.bankl
{
 a.mandt,a.banks,a.bankl,a.acc_id,a.acc_num,a.bukrs,cast(coalesce(b.bgrup,'') as bgrup ) as bgrup

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

Learn More