FAA_CFG_CMP

DDL: FAA_CFG_CMP SQL: FAAV_CFG_CMP Type: view Package: FINS_FAA_CFG_DB

Configuration of CompCodes in Asset Accounting

FAA_CFG_CMP is a CDS View that provides data about "Configuration of CompCodes in Asset Accounting" in SAP S/4HANA. It reads from 5 data sources (faat_cmp, faac_cmp0, faa_cmp_ldt, faac_cmp0, t001) and exposes 7 fields with key field comp_code. Part of development package FINS_FAA_CFG_DB.

5 data source(s) 7 fields

Data Sources (5)

SourceAliasJoin Type
faat_cmp cmp from
faac_cmp0 cmp_generic left_outer
faa_cmp_ldt cmp_ldt left_outer
faac_cmp0 cmp_specific left_outer
t001 t001 left_outer

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_CFG_CMP view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 1 view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Configuration of CompCodes in Asset Accounting view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY comp_code t001 bukrs
country t001 land1
status faat_cmp status
sdm_status faat_cmp sdm_status
ldt_date faa_cmp_ldt ldt_date
ldt_status faa_cmp_ldt ldt_status
ldt_doc_type faa_cmp_ldt ldt_doc_type 
@AbapCatalog.sqlViewName: 'FAAV_CFG_CMP'
@ClientHandling.algorithm: #SESSION_VARIABLE
--@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
--@AbapCatalog.buffering.status: #ACTIVE
--@AbapCatalog.buffering.type: #FULL
--@AbapCatalog.buffering.type: #GENERIC
--@AbapCatalog.buffering.numberOfKeyFields: 1
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Configuration of CompCodes in Asset Accounting'
define view FAA_CFG_CMP

as 

select from                 faat_cmp        as cmp

       left outer join      t001            as t001         on  t001.bukrs               = cmp.comp_code
       left outer join      faa_cmp_ldt     as cmp_ldt      on  cmp_ldt.comp_code        = cmp.comp_code
       left outer join      faac_cmp0       as cmp_generic  on  cmp_generic.comp_code    = '*   '                                             
       left outer join      faac_cmp0       as cmp_specific on cmp_specific.comp_code    = cmp.comp_code

{
  key t001.bukrs                                                        as comp_code,
      t001.waers                                                        as local_currency,
      t001.land1                                                        as country,
      t001.ktopl                                                        as gl_account_chart,
      
      --- Company Code Settings (AA)
      case cmp_specific.comp_code
      when cmp.comp_code then  case cmp_specific.comp_code_nriv 
                              when ' '
                                    then cmp.comp_code 
                                    else cmp_specific.comp_code_nriv 
                              end
                         else  cmp.comp_code                             end as comp_code_nriv,                 
      case cmp_specific.comp_code
      when cmp.comp_code then cmp_specific.settlement_profile
                         else cmp_generic.settlement_profile             end as settlement_profile,                   
      case cmp_specific.comp_code
      when cmp.comp_code then cmp_specific.add_retention_period
                         else cmp_generic.add_retention_period           end as add_retention_period,
                         
      ---  Master Data from FAAT_CMP
      cmp.locked                                                         as locked,
      cmp.status                                                         as status,
      cmp.sdm_status                                                     as sdm_status,
      // --- Master Data from FAAT_CMP_LDT

      cmp_ldt.ldt_date                                                   as ldt_date,
      cmp_ldt.ldt_status                                                 as ldt_status,
      cmp_ldt.ldt_doc_type                                               as ldt_doc_type,
      cmp_ldt.ldt_wo_depr_calc                                           as ldt_wo_depr_calc
     //cmp_ldt.ldt_comment                                               as ldt_comment,

      
}

Learn More