FAA_COMP_CODE

DDL: FAA_COMP_CODE SQL: FAAV_COMP_CODE Type: view

FIAA asset company codes

FAA_COMP_CODE is a CDS View that provides data about "FIAA asset company codes" in SAP S/4HANA. It reads from 2 data sources (t001, t001) and exposes 4 fields with key field comp_code.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
t001 t left_outer
t001 t left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_COMP_CODE view
EndUserText.label FIAA asset company codes view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY comp_code v1 comp_code
bukrs v1 comp_code
bukrs v1 comp_code
butxtasDESCRIPTION_SHORT 
@AbapCatalog.sqlViewName: 'FAAV_COMP_CODE'
@EndUserText.label: 'FIAA asset company codes'

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.sizeCategory: #S

// this view is just to list company codes defined in

// asset management

-----------------------------------------------------
define view FAA_COMP_CODE

  // select for FIN_AA_CONFIG_REDESIGN_1 = OFF

  // =========================================

  as select distinct from faa_comp_code_bf_off as v1
    left outer join       t001                 as t    on v1.comp_code  = t.bukrs
{
  key v1.comp_code                             as comp_code,
      v1.comp_code                             as bukrs,                  --"for compat reasons  
      t.butxt                                  as DESCRIPTION_SHORT
}

union all

// select for FIN_AA_CONFIG_REDESIGN_1 = ON

// ========================================

select distinct from FAA_COMP_CODE_BF_ON as v1
    left outer join       t001           as t         on  v1.comp_code   = t.bukrs
{
  key v1.comp_code                       as comp_code,
      v1.comp_code                       as bukrs,                  --"for compat reasons    
      t.butxt                            as DESCRIPTION_SHORT
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAA_COMP_CODE_BF_OFF",
"FAA_COMP_CODE_BF_ON",
"T001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More