FAA_MIG_PREP

DDL: FAA_MIG_PREP SQL: FAAV_MIG_PREP Type: view

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.

2 data source(s) 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
xanueb t093c xanueb
ldgrp_gl t093 ldgrp_gl
gjahr anlc gjahr
buhbkt t093 buhbkt
xstore t093 xstore 
@AbapCatalog.sqlViewName: 'FAAV_MIG_PREP'
@EndUserText.label: 'Get combinations of BUKRS/GJAHR for ANLC migration'

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P

define view  FAA_MIG_PREP 
as select from ( t093c    
     inner join anlc
             on anlc.bukrs = t093c.bukrs 
left outer join t093
             on t093.afapl = t093c.afapl )
{   
   t093c.bukrs,
   t093c.xanueb,
   t093.ldgrp_gl, 
   anlc.gjahr,
   t093.buhbkt,
   t093.xstore
 
  }     
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ANLC",
"T093",
"T093C"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More