FAA_CMP_LDT

DDL: FAA_CMP_LDT SQL: FAAV_CMP_LDT Type: view

Join of FAAT_CMP and FAAT_CMP_LDT

FAA_CMP_LDT is a CDS View that provides data about "Join of FAAT_CMP and FAAT_CMP_LDT" in SAP S/4HANA. It reads from 2 data sources (FAA_TF_CMPACTIVELDTSEGMENT, faat_cmp) and exposes 7 fields with key fields mandt, comp_code.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
FAA_TF_CMPACTIVELDTSEGMENT FAA_TF_CMPACTIVELDTSEGMENT left_outer
faat_cmp v1 from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_CMP_LDT view
ClientHandling.algorithm #AUTOMATED view
AccessControl.authorizationCheck #NOT_ALLOWED view
ObjectModel.usageType.serviceQuality #P view
EndUserText.label Join of FAAT_CMP and FAAT_CMP_LDT view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY mandt faat_cmp mandt
KEY comp_code faat_cmp comp_code
cmp_status faat_cmp status
locked faat_cmp locked
ldt_status v2 Status
Dateendasldt_date
ldt_doc_type v2 doc_type 
@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

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

Learn More