FAA_CMP_LDT

CDS View

Join of FAAT_CMP and FAAT_CMP_LDT

FAA_CMP_LDT is a CDS View in S/4HANA. Join of FAAT_CMP and FAAT_CMP_LDT. It contains 4 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 4 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FAA_CFG_CMP view left_outer Configuration of CompCodes in Asset Accounting
faa_t093c view left_outer compatibilty view for T093C

Fields (4)

KeyField CDS FieldsUsed in Views
ldt_date ldt_date 1
ldt_doc_type ldt_doc_type 1
ldt_status ldt_status 1
ldt_wo_depr_calc ldt_wo_depr_calc 1 
@AbapCatalog.sqlViewName: 'FAAV_CMP_LDT'
@ClientHandling.algorithm: #AUTOMATED
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ObjectModel.usageType.serviceQuality: #P
@EndUserText.label: 'Join of FAAT_CMP and FAAT_CMP_LDT'


define view FAA_CMP_LDT
  as select

  from              faat_cmp                                                   as v1
  left outer join   FAA_TF_CMPACTIVELDTSEGMENT( P_SAPClient : $session.client )  as v2 on  v2.sapclient = v1.mandt
                                                                                     and v2.Comp_Code = v1.comp_code

{
  key v1.mandt        as mandt,
  key v1.comp_code    as comp_code,
      v1.status       as cmp_status,
      v1.locked       as locked,
      v2.Status       as ldt_status,
      case when v2.Date is null
        then '00000000'
        else v2.Date
        end           as ldt_date,
      v2.doc_type     as ldt_doc_type,
      v2.wo_depr_calc as ldt_wo_depr_calc

}

Learn More