Fisvd_Saknr_Vh

DDL: FISVD_SAKNR_VH SQL: FISV_SAKNR_F4 Type: view

View for Company Code Dependent G/L Account Value Help

Fisvd_Saknr_Vh is a CDS View that provides data about "View for Company Code Dependent G/L Account Value Help" in SAP S/4HANA. It reads from 5 data sources (ska1, skat, skb1, t001, t002) and exposes 9 fields with key fields bukrs, saknr, ktopl, spras.

5 data source(s) 9 fields

Data Sources (5)

SourceAliasJoin Type
ska1 ska1 inner
skat skat left_outer
skb1 skb1 from
t001 t001 inner
t002 t002 inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FISV_SAKNR_F4 view
EndUserText.label View for Company Code Dependent G/L Account Value Help view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY bukrs skb1 bukrs
KEY saknr skb1 saknr
KEY ktopl t001 ktopl
KEY spras t002 spras
txt20 skat txt20
txt50 skat txt50
mitkz skb1 mitkz
xgkon skb1 xgkon
xopvw skb1 xopvw 
@AbapCatalog.sqlViewName: 'FISV_SAKNR_F4'
// @ClientDependent: true

// @AbapCatalog.compiler.compareFilter: true

// @AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'View for Company Code Dependent G/L Account Value Help'
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view Fisvd_Saknr_Vh as 
select from skb1 
       inner      join ska1 on ska1.saknr = skb1.saknr
       inner      join t001 on t001.bukrs = skb1.bukrs and t001.ktopl = ska1.ktopl 
       inner      join t002 on skb1.bukrs <> ''
       left outer join skat on skat.saknr = skb1.saknr and skat.ktopl = t001.ktopl and skat.spras = t002.spras
{
key skb1.bukrs, 
key skb1.saknr, 
key t001.ktopl, 
key t002.spras, 
skat.txt20, 
skat.txt50,
skb1.mitkz, 
skb1.xgkon,
skb1.xopvw,
ska1.glaccount_type    
}

Learn More