Faa_Rc1_It_Base
Mapping ANEP, ANEA to ANLC (Base View)
Faa_Rc1_It_Base is a CDS View that provides data about "Mapping ANEP, ANEA to ANLC (Base View)" in SAP S/4HANA. It reads from 4 data sources (anea, anep, tabw, tabwg) and exposes 6 fields.
Data Sources (4)
Annotations (6)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | FAAV_RC1_IT_BASE | view | |
| EndUserText.label | Mapping ANEP, ANEA to ANLC (Base View) | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| ObjectModel.usageType.serviceQuality | #P | view |
@AbapCatalog.sqlViewName: 'FAAV_RC1_IT_BASE'
@EndUserText.label: 'Mapping ANEP, ANEA to ANLC (Base View) '
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
define view Faa_Rc1_It_Base
as select from anep as anep
left outer join anea as anea
on anea.bukrs = anep.bukrs
and anea.anln1 = anep.anln1
and anea.anln2 = anep.anln2
and anea.gjahr = anep.gjahr
and anea.lnran = anep.lnran
and anea.afabe = anep.afabe
inner join tabw as tabw
on tabw.bwasl = anep.bwasl
inner join tabwg as tabwg
on tabwg.bwagrp = tabw.bwagrp
{ anep.mandt,
anep.bukrs,
anep.anln1,
anep.anln2,
anep.gjahr,
anep.afabe,
// Set value fields
-----------------------
case when tabwg.bwatyp = '1' -- AHK
or tabwg.bwatyp = '2' -- ANZ
or tabwg.bwatyp = '3' -- INV
then anep.anbtr
else 0 end as answl,
case when tabwg.bwatyp = '2' -- ANZ
then anep.anbtr
else 0 end as ansaz,
case when tabwg.bwatyp = '6' -- AUF
then anep.anbtr
else 0 end as aufwm,
case when tabwg.bwatyp = '6' -- AUF
and anep.xantw = 'X'
then anea.aufnv + anea.aufnl
else 0 end as aufnm,
case when tabwg.bwatyp = '3' -- INV
then anep.anbtr
else 0 end as invzm,
case when tabwg.bwatyp = '4' and tabwg.xbnafa = 'X' -- AFA
then anep.anbtr
else 0 end as nafam,
case when tabwg.bwatyp = '4' and tabwg.xbsafa = 'X' -- AFA
then anep.anbtr
else 0 end as safam,
case when tabwg.bwatyp = '4' and tabwg.xbaafa = 'X' -- AFA
then anep.anbtr
else 0 end as aafam,
case when tabwg.bwatyp = '4' and tabwg.xbmafa = 'X' -- AFA
then anep.anbtr
else 0 end as mafam,
case when tabwg.bwatyp = '5' -- ZUS
then anea.nafav
else 0 end as zusna,
case when tabwg.bwatyp = '5' -- ZUS
then anea.safav
else 0 end as zussa,
case when tabwg.bwatyp = '5' -- ZUS
then anea.aafav
else 0 end as zusaa,
case when tabwg.bwatyp = '5' -- ZUS
then anea.mafav
else 0 end as zusma,
case when anep.xantw = 'X' and
tabwg.bwatyp <> '5' and -- ZUS
tabwg.bwatyp <> '7' and -- VAHK
tabwg.bwatyp <> '8' and -- VANZ
tabwg.bwatyp <> '6' -- AUF
then anea.aufwv
else 0 end as aufwv,
case when anep.xantw = 'X' and
tabwg.bwatyp <> '5' and -- ZUS
tabwg.bwatyp <> '7' and -- VAHK
tabwg.bwatyp <> '8' and -- VANZ
tabwg.bwatyp <> '6' -- AUF
then anea.invzv
else 0 end as invzv,
case when anep.xantw = 'X' and
tabwg.bwatyp <> '5' and -- ZUS
tabwg.bwatyp <> '7' and -- VAHK
tabwg.bwatyp <> '8' and -- VANZ
tabwg.bwatyp <> '6' -- AUF
then anea.nafav
else 0 end as nafav,
case when anep.xantw = 'X' and
tabwg.bwatyp <> '5' and -- ZUS
tabwg.bwatyp <> '7' and -- VAHK
tabwg.bwatyp <> '8' and -- VANZ
tabwg.bwatyp <> '6' -- AUF
then anea.safav
else 0 end as safav,
case when anep.xantw = 'X' and
tabwg.bwatyp <> '5' and -- ZUS
tabwg.bwatyp <> '7' and -- VAHK
tabwg.bwatyp <> '8' and -- VANZ
tabwg.bwatyp <> '6' -- AUF
then anea.aafav
else 0 end as aafav,
case when anep.xantw = 'X' and
tabwg.bwatyp <> '5' and -- ZUS
tabwg.bwatyp <> '7' and -- VAHK
tabwg.bwatyp <> '8' and -- VANZ
tabwg.bwatyp <> '6' -- AUF
then anea.mafav
else 0 end as mafav,
case when anep.xantw = 'X' and
tabwg.bwatyp <> '5' and -- ZUS
tabwg.bwatyp <> '7' and -- VAHK
tabwg.bwatyp <> '8' and -- VANZ
tabwg.bwatyp <> '6' -- AUF
then anea.aufnv
else 0 end as aufnv,
case when anep.xantw = 'X' and
tabwg.bwatyp <> '5' and -- ZUS
tabwg.bwatyp <> '7' and -- VAHK
tabwg.bwatyp <> '8' and -- VANZ
tabwg.bwatyp <> '6' -- AUF
then anea.aufwl
else 0 end as aufwl,
case when anep.xantw = 'X' and
tabwg.bwatyp <> '5' and -- ZUS
tabwg.bwatyp <> '7' and -- VAHK
tabwg.bwatyp <> '8' and -- VANZ
tabwg.bwatyp <> '6' -- AUF
then anea.invzl
else 0 end as invzl,
case when anep.xantw = 'X' and
tabwg.bwatyp <> '5' and -- ZUS
tabwg.bwatyp <> '7' and -- VAHK
tabwg.bwatyp <> '8' and -- VANZ
tabwg.bwatyp <> '6' -- AUF
then anea.nafal
else 0 end as nafal,
case when anep.xantw = 'X' and
tabwg.bwatyp <> '5' and -- ZUS
tabwg.bwatyp <> '7' and -- VAHK
tabwg.bwatyp <> '8' and -- VANZ
tabwg.bwatyp <> '6' -- AUF
then anea.safal
else 0 end as safal,
case when anep.xantw = 'X' and
tabwg.bwatyp <> '5' and -- ZUS
tabwg.bwatyp <> '7' and -- VAHK
tabwg.bwatyp <> '8' and -- VANZ
tabwg.bwatyp <> '6' -- AUF
then anea.aafal
else 0 end as aafal,
case when anep.xantw = 'X' and
tabwg.bwatyp <> '5' and -- ZUS
tabwg.bwatyp <> '7' and -- VAHK
tabwg.bwatyp <> '8' and -- VANZ
tabwg.bwatyp <> '6' -- AUF
then anea.mafal
else 0 end as mafal,
case when anep.xantw = 'X' and
tabwg.bwatyp <> '5' and -- ZUS
tabwg.bwatyp <> '7' and -- VAHK
tabwg.bwatyp <> '8' and -- VANZ
tabwg.bwatyp <> '6' -- AUF
then anea.aufnl
else 0 end as aufnl,
case when anep.xantw = 'X' and
tabwg.bwatyp <> '5' and -- ZUS
tabwg.bwatyp <> '7' and -- VAHK
tabwg.bwatyp <> '8' and -- VANZ
tabwg.bwatyp <> '6' -- AUF
then anea.sanwv
else 0 end as sansl }
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ANEA",
"ANEP",
"TABW",
"TABWG"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA