FAA_ASSETVALYDDAS4

DDL: FAA_ASSETVALYDDAS4 SQL: FAAVASTVALYDDAS4 Type: view
7 Fields 3 Data Sources

Unit Test View for Asset Assignment

FAA_ASSETVALYDDAS4 is a CDS View that provides data about "Unit Test View for Asset Assignment" in SAP S/4HANA. It reads from 3 data sources (faac_t093_emu, faat_md_val_ydda, faat_md_val_ydda) and exposes 7 fields with key fields companycode, fixedasset, ledger, fiscalyear, fixedasset.

Data Sources (3)

SourceAliasJoin Type
faac_t093_emu faac_t093_emu inner
faat_md_val_ydda faat_md_val_ydda from
faat_md_val_ydda faat_md_val_ydda union_all

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FAAVASTVALYDDAS4 view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Unit Test View for Asset Assignment view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY companycode faat_md_val_ydda comp_code Procuring Comp. Cde
KEY fixedasset faat_md_val_ydda asset_subno Sub-number
KEY ledger faat_md_val_ydda ledger Ledger
KEY fiscalyear faat_md_val_ydda fisc_year Year
KEY fixedasset faat_md_val_ydda asset_subno Sub-number
KEY ledger faat_md_val_ydda ledger Ledger
KEY fiscalyear faat_md_val_ydda fisc_year Year

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_ASSETVALYDDAS4.
-- 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: FAAVASTVALYDDAS4

CREATE VIEW FAA_ASSETVALYDDAS4 AS
SELECT
  faat_md_val_ydda.comp_code AS companycode,
  faat_md_val_ydda.asset_subno AS fixedasset,
  faat_md_val_ydda.ledger AS ledger,
  faat_md_val_ydda.fisc_year AS fiscalyear
FROM faat_md_val_ydda
INNER JOIN faac_t093_emu ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): faat_md_val_ydda
;

Learn More