FAA_MIG_PREP

DDL: FAA_MIG_PREP SQL: FAAV_MIG_PREP Type: view
6 Fields 2 Data Sources

Get combinations of BUKRS/GJAHR for ANLC migration

FAA_MIG_PREP is a CDS View that provides data about "Get combinations of BUKRS/GJAHR for ANLC migration" in SAP S/4HANA. It reads from 2 data sources (anlc, t093) and exposes 6 fields.

Data Sources (2)

SourceAliasJoin Type
anlc anlc inner
t093 t093 left_outer

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_MIG_PREP view
EndUserText.label Get combinations of BUKRS/GJAHR for ANLC migration view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

Fields (6)

KeyFieldSource TableSource FieldDescription
bukrs t093c bukrs Value
xanueb t093c xanueb Status Co.Code
ldgrp_gl t093 ldgrp_gl Target Ledger Group
gjahr anlc gjahr Settlement Year
buhbkt t093 buhbkt Ind.: G/L Acct.
xstore t093 xstore Real Dep. Area

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_MIG_PREP.
-- 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_MIG_PREP

CREATE VIEW FAA_MIG_PREP AS
SELECT
  t093c.bukrs AS bukrs,
  t093c.xanueb AS xanueb,
  t093.ldgrp_gl AS ldgrp_gl,
  anlc.gjahr AS gjahr,
  t093.buhbkt AS buhbkt,
  t093.xstore AS xstore
INNER JOIN anlc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t093 ON /* join condition not captured in parsed metadata */
;

Learn More