faa_md_ld_mig

DDL: FAA_MD_LD_MIG SQL: FAAVMDLDMIG Type: view Package: FINS_FAA_MD_MIG
5 Fields 2 Data Sources

Migration View for New Ledger

faa_md_ld_mig is a CDS View that provides data about "Migration View for New Ledger" in SAP S/4HANA. It reads from 2 data sources (anlb, FAA_CFG_DEPR_AREA) and exposes 5 fields with key fields client, comp_code, asset_no, asset_subno, ledger. Part of development package FINS_FAA_MD_MIG.

Data Sources (2)

SourceAliasJoin Type
anlb anlb inner
FAA_CFG_DEPR_AREA cfg_da inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FAAVMDLDMIG view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Migration View for New Ledger view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY client anla mandt Editing Client
KEY comp_code anla bukrs Value
KEY asset_no anla anln1 Asset
KEY asset_subno anla anln2 Sub-number
KEY ledger FAA_CFG_DEPR_AREA ledger Ledger

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_md_ld_mig.
-- 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: FAAVMDLDMIG

CREATE VIEW faa_md_ld_mig AS
SELECT
  anla.mandt AS client,
  anla.bukrs AS comp_code,
  anla.anln1 AS asset_no,
  anla.anln2 AS asset_subno,
  cfg_da.ledger AS ledger
INNER JOIN anlb ON /* join condition not captured in parsed metadata */
INNER JOIN FAA_CFG_DEPR_AREA AS cfg_da ON /* join condition not captured in parsed metadata */
;

Learn More