Faa_Anekpv

DDL: FAA_ANEKPV SQL: FAAV_ANEKPV Type: view
38 Fields 2 Data Sources

Kompatibilitaets-View fuer View ANEKPV

Faa_Anekpv is a CDS View that provides data about "Kompatibilitaets-View fuer View ANEKPV" in SAP S/4HANA. It reads from 2 data sources (Faa_Anek, Faa_Anep) and exposes 38 fields.

Data Sources (2)

SourceAliasJoin Type
Faa_Anek anek from
Faa_Anep anep inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_ANEKPV view
EndUserText.label Kompatibilitaets-View fuer View ANEKPV view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (38)

KeyFieldSource TableSource FieldDescription
mandt Faa_Anep mandt Editing Client
bukrs Faa_Anep bukrs Value
anln1 Faa_Anep anln1 Asset
anln2 Faa_Anep anln2 Sub-number
gjahr Faa_Anep gjahr Settlement Year
lnran Faa_Anep lnran Sequence Number
afabe Faa_Anep afabe Deprec. Area
zujhr Faa_Anep zujhr Acquisition Yr
zucod Faa_Anep zucod Acquisition Code
belnr Faa_Anep belnr SD Document
bzdat Faa_Anep bzdat Reference date
bwasl Faa_Anep bwasl Trans. Type
anbtr Faa_Anep anbtr Amount Posted
xawbt Faa_Anep xawbt Ind. diff.amt
bldat Faa_Anek bldat Journal Entry Date
budat Faa_Anek budat Posting Date
bvorg Faa_Anek bvorg Intercompany Transac
xblnr Faa_Anek xblnr Reference
sgtxt Faa_Anek sgtxt Text
menge Faa_Anek menge WarrCountValue
meins Faa_Anek meins Valuation Unit
bureg Faa_Anek bureg Distr. Rule Grp
monat Faa_Anek monat Period Block
cpudt Faa_Anek cpudt Imported On
cputm Faa_Anek cputm Time
usnam Faa_Anek usnam User Name
tcode Faa_Anek tcode Undefined range (can be used for patch levels)
stblg Faa_Anek stblg Reversed With
glvor Faa_Anek glvor Bus.transaction
vbund Faa_Anek vbund Trading Partner
pargb Faa_Anek pargb Trdg Part.BA
zuonr Faa_Anek zuonr Finance Project
mwskz Faa_Anek mwskz Tax Code
ebeln Faa_Anek ebeln Source PurchDoc
ebelp Faa_Anek ebelp Item pur. doc.
matnr Faa_Anek matnr Vehicle Model
ldgrp Faa_Anek ldgrp Target Ledger Group
augln Faa_Anep augln Reserve field

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_Anekpv.
-- 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_ANEKPV

CREATE VIEW Faa_Anekpv AS
SELECT
  anep.mandt AS mandt,
  anep.bukrs AS bukrs,
  anep.anln1 AS anln1,
  anep.anln2 AS anln2,
  anep.gjahr AS gjahr,
  anep.lnran AS lnran,
  anep.afabe AS afabe,
  anep.zujhr AS zujhr,
  anep.zucod AS zucod,
  anep.belnr AS belnr,
  anep.bzdat AS bzdat,
  anep.bwasl AS bwasl,
  anep.anbtr AS anbtr,
  anep.xawbt AS xawbt,
  anek.bldat AS bldat,
  anek.budat AS budat,
  anek.bvorg AS bvorg,
  anek.xblnr AS xblnr,
  anek.sgtxt AS sgtxt,
  anek.menge AS menge,
  anek.meins AS meins,
  anek.bureg AS bureg,
  anek.monat AS monat,
  anek.cpudt AS cpudt,
  anek.cputm AS cputm,
  anek.usnam AS usnam,
  anek.tcode AS tcode,
  anek.stblg AS stblg,
  anek.glvor AS glvor,
  anek.vbund AS vbund,
  anek.pargb AS pargb,
  anek.zuonr AS zuonr,
  anek.mwskz AS mwskz,
  anek.ebeln AS ebeln,
  anek.ebelp AS ebelp,
  anek.matnr AS matnr,
  anek.ldgrp AS ldgrp,
  anep.augln AS augln
FROM Faa_Anek AS anek
INNER JOIN Faa_Anep AS anep ON /* join condition not captured in parsed metadata */
;

Learn More