faa_comp_code_nriv

DDL: FAA_COMP_CODE_NRIV SQL: FAAV_BUKRSN Type: view

Asset Company Codes with Number Range SubObject

faa_comp_code_nriv is a CDS View that provides data about "Asset Company Codes with Number Range SubObject" in SAP S/4HANA. It reads from 4 data sources (faav_comp_code_n, faac_cmp0, faac_cmp0, faav_comp_code_o) and exposes 3 fields with key fields client, comp_code, comp_code.

4 data source(s) 3 fields

Data Sources (4)

SourceAliasJoin Type
faav_comp_code_n cmp_faa from
faac_cmp0 cmp_generic left_outer
faac_cmp0 cmp_nriv left_outer
faav_comp_code_o t093c union_all

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_BUKRSN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Asset Company Codes with Number Range SubObject view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY client faav_comp_code_n client
KEY comp_code faav_comp_code_n comp_code
KEY comp_code faav_comp_code_o comp_code 
@AbapCatalog.sqlViewName: 'FAAV_BUKRSN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Asset Company Codes with Number Range SubObject'
define view faa_comp_code_nriv
  as select from    faav_comp_code_n as cmp_faa // all BUKRS in Switch-ON case

    left outer join faac_cmp0        as cmp_nriv    on cmp_faa.comp_code = cmp_nriv.comp_code
    left outer join faac_cmp0        as cmp_generic on cmp_generic.comp_code = '*'
{
  key cmp_faa.client    as client,
  key cmp_faa.comp_code as comp_code,
      case
      when cmp_nriv.comp_code_nriv is not null    --- specific entry for company code ---
       and cmp_nriv.comp_code_nriv <> ''          --- explicit value for COMP_CODE_NRIV
      then cmp_nriv.comp_code_nriv

      // when cmp_nriv.comp_code_nriv is not null --- specific entry for company code ---

      //  and cmp_nriv.comp_code_nriv = ''        --- no value for COMP_CODE_NRIV => take over COMP_CODE

      // then cmp_faa.comp_code

      //

      // when cmp_nriv.comp_code_nriv is null     --- NO specific entry for company code => use generic entry ---

      //  and cmp_generic.comp_code_nriv = ''     --- NO explicit value for COMP_CODE_NRIV in GENERIC entry

      // then cmp_faa.comp_code


      when cmp_nriv.comp_code_nriv is null        --- NO specific entry for company code => use generic entry ---
       and cmp_generic.comp_code_nriv <> ''       --- explicit value for COMP_CODE_NRIV in GENERIC entry
      then cmp_generic.comp_code_nriv

      //--- all other cases (incl commented cases above!)

      else cmp_faa.comp_code
      end               as comp_code_nriv
}

union all select from faav_comp_code_o as t093c // all BUKRS in Switch-OFF case

{
  key t093c.client             as client,
  key t093c.comp_code          as comp_code,
      t093c.comp_code_nriv     as comp_code_nriv
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAAC_CMP0",
"FAAV_COMP_CODE_N",
"FAAV_COMP_CODE_O"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More