Faa_Curtyp

DDL: FAA_CURTYP SQL: FAAV_CURTYP Type: view
33 Fields 2 Data Sources

Intern: Waehrungsinformationen fuer AfA-Bereiche

Faa_Curtyp is a CDS View that provides data about "Intern: Waehrungsinformationen fuer AfA-Bereiche" in SAP S/4HANA. It reads from 2 data sources (FAA_CURTYP_O, FAA_CURTYP_N) and exposes 33 fields with key fields bukrs, afabe, afabe.

Data Sources (2)

SourceAliasJoin Type
FAA_CURTYP_O v1 from
FAA_CURTYP_N v2 union_all

Annotations (9)

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

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY bukrs FAA_CURTYP_O bukrs Value
KEY afabe FAA_CURTYP_O afabe Deprec. Area
afapl FAA_CURTYP_O afapl Chart of Depr.
lead_afabe FAA_CURTYP_O lead_afabe Deprec. Area
rep_ledger FAA_CURTYP_O rep_ledger Ledger
curtp FAA_CURTYP_O curtp Valuation Area
hsl FAA_CURTYP_O hsl Local Crcy Amt
ksl FAA_CURTYP_O ksl GrpCurr
osl FAA_CURTYP_O osl Other Crcy Amnt
vsl FAA_CURTYP_O vsl Amount in Currency 2
bsl FAA_CURTYP_O bsl Exchange Key
csl FAA_CURTYP_O csl Amount in Currency 4
dsl FAA_CURTYP_O dsl Amount in Currency 5
esl FAA_CURTYP_O esl Amount in Currency 6
fsl FAA_CURTYP_O fsl Amount in Currency 7
gsl FAA_CURTYP_O gsl Amount in Currency 8
bukrsasbukrs
KEY afabe FAA_CURTYP_N afabe Deprec. Area
afapl FAA_CURTYP_N afapl Chart of Depr.
lead_afabe FAA_CURTYP_N lead_afabe Deprec. Area
rep_ledger FAA_CURTYP_N rep_ledger Ledger
curtp FAA_CURTYP_N curtp Valuation Area
hsl FAA_CURTYP_N hsl Local Crcy Amt
ksl FAA_CURTYP_N ksl GrpCurr
osl FAA_CURTYP_N osl Other Crcy Amnt
vsl FAA_CURTYP_N vsl Amount in Currency 2
bsl FAA_CURTYP_N bsl Exchange Key
csl FAA_CURTYP_N csl Amount in Currency 4
dsl FAA_CURTYP_N dsl Amount in Currency 5
esl FAA_CURTYP_N esl Amount in Currency 6
fsl FAA_CURTYP_N fsl Amount in Currency 7
gsl FAA_CURTYP_N gsl Amount in Currency 8
afabe_type FAA_CURTYP_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_Curtyp.
-- 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_CURTYP

CREATE VIEW Faa_Curtyp AS
SELECT
  v1.bukrs AS bukrs,
  v1.afabe AS afabe,
  v1.afapl AS afapl,
  v1.lead_afabe AS lead_afabe,
  v1.rep_ledger AS rep_ledger,
  v1.curtp AS curtp,
  v1.hsl AS hsl,
  v1.ksl AS ksl,
  v1.osl AS osl,
  v1.vsl AS vsl,
  v1.bsl AS bsl,
  v1.csl AS csl,
  v1.dsl AS dsl,
  v1.esl AS esl,
  v1.fsl AS fsl,
  v1.gsl AS gsl,
  v1.afabe_type as afabe_type AS bukrsasbukrs,
  v2.afabe_type AS afabe_type
FROM FAA_CURTYP_O AS v1
-- UNION ALL with additional select branch(es): FAA_CURTYP_N
;

Learn More