Faa_Rep_Ledger

DDL: FAA_REP_LEDGER SQL: FAAV_REP_LEDGER Type: view
15 Fields 2 Data Sources

Intern: Representative Ledger fuer AfA-Bereiche

Faa_Rep_Ledger is a CDS View that provides data about "Intern: Representative Ledger fuer AfA-Bereiche" in SAP S/4HANA. It reads from 2 data sources (FAA_REP_LEDGER_O, FAA_REP_LEDGER_N) and exposes 15 fields with key fields bukrs, lead_afabe, lead_afabe.

Data Sources (2)

SourceAliasJoin Type
FAA_REP_LEDGER_O v1 from
FAA_REP_LEDGER_N v2 union_all

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_REP_LEDGER view
EndUserText.label Intern: Representative Ledger fuer AfA-Bereiche view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY bukrs FAA_REP_LEDGER_O bukrs Value
KEY lead_afabe FAA_REP_LEDGER_O lead_afabe Deprec. Area
afapl FAA_REP_LEDGER_O afapl Chart of Depr.
rep_ledger FAA_REP_LEDGER_O rep_ledger Ledger
tech_ledger Technical Ledger
ldgrp FAA_REP_LEDGER_O ldgrp Target Ledger Group
xstore FAA_REP_LEDGER_O xstore Real Dep. Area
bukrsasbukrs
KEY lead_afabe FAA_REP_LEDGER_N lead_afabe Deprec. Area
afapl FAA_REP_LEDGER_N afapl Chart of Depr.
rep_ledger FAA_REP_LEDGER_N rep_ledger Ledger
tech_ledger FAA_REP_LEDGER_N tech_ledger Technical Ledger
ldgrp FAA_REP_LEDGER_N ldgrp Target Ledger Group
xstore FAA_REP_LEDGER_N xstore Real Dep. Area
afabe_type FAA_REP_LEDGER_N afabe_type

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view Faa_Rep_Ledger.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: FAAV_REP_LEDGER

CREATE VIEW Faa_Rep_Ledger AS
SELECT
  v1.bukrs AS bukrs,
  v1.lead_afabe AS lead_afabe,
  v1.afapl AS afapl,
  v1.rep_ledger AS rep_ledger,
  ' ' AS tech_ledger,
  v1.ldgrp AS ldgrp,
  v1.xstore AS xstore,
  v1.afabe_type as afabe_type AS bukrsasbukrs,
  v2.afabe_type AS afabe_type
FROM FAA_REP_LEDGER_O AS v1
-- UNION ALL with additional select branch(es): FAA_REP_LEDGER_N
;

Learn More