Faa_Anek_Parob1

DDL: FAAV_ANEK_PAROB1 SQL: FAAV_ANEK_PAROB1 Type: view

Ermittlung des Feldes PAROB1

Faa_Anek_Parob1 is a CDS View that provides data about "Ermittlung des Feldes PAROB1" in SAP S/4HANA. It reads from 2 data sources (acdoca, Faa_Rep_Ledger) and exposes 7 fields with key fields mandt, bukrs, anln1, anln2, gjahr.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
acdoca adoc inner
Faa_Rep_Ledger ldnr from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_ANEK_PAROB1 view
EndUserText.label Ermittlung des Feldes PAROB1 view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY mandt acdoca rclnt
KEY bukrs acdoca rbukrs
KEY anln1 acdoca anln1
KEY anln2 acdoca anln2
KEY gjahr acdoca ryear
KEY subta acdoca subta
parob1 
@AbapCatalog.sqlViewName: 'FAAV_ANEK_PAROB1'
@EndUserText.label: 'Ermittlung des Feldes PAROB1'

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P


// this view is to determine the partner object on LNRAN-level for ANLN1

------------------------------------------------------------------

define view Faa_Anek_Parob1

as select from Faa_Rep_Ledger as ldnr

inner join     acdoca         as adoc
   on ldnr.bukrs      = adoc.rbukrs
  and ldnr.rep_ledger = adoc.rldnr
  and ldnr.lead_afabe = adoc.afabe
  and ldnr.xstore     = 'X'

{ key adoc.rclnt       as mandt,
  key adoc.rbukrs      as bukrs,
  key adoc.anln1       as anln1,
  key adoc.anln2       as anln2,
//  key adoc.gjahr       as gjahr,

  key adoc.ryear       as gjahr,
  key adoc.subta       as subta,
    max (adoc.parob1)   as parob1
}


  where adoc.anln1 <> ''
    and adoc.awtyp <> 'AMDP'
    and adoc.afabe <> '00'
    and bstat      <> 'C'
    and ( mig_source = 'A' or mig_source = '' )

    group by adoc.rclnt,
             adoc.rbukrs,
             adoc.anln1,
             adoc.anln2,
//             adoc.gjahr,

             adoc.ryear,
             adoc.subta

Learn More