fisvd_bilabtyp

DDL: FISVD_BILABTYP SQL: FISV_BILABTYP Type: view

Balance Sheet Type

fisvd_bilabtyp is a CDS View that provides data about "Balance Sheet Type" in SAP S/4HANA. It reads from 3 data sources (dd07l, dd07t, t002) and exposes 3 fields.

3 data source(s) 3 fields

Data Sources (3)

SourceAliasJoin Type
dd07l dd07l from
dd07t dd07t left_outer
t002 t002 inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FISV_BILABTYP view
EndUserText.label Balance Sheet Type view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (3)

KeyFieldSource TableSource FieldDescription
BILABTYP
spras t002 spras
TEXT dd07t ddtext 
@AbapCatalog.sqlViewName: 'FISV_BILABTYP'
@EndUserText.label: 'Balance Sheet Type'
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass:  #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view  fisvd_bilabtyp as 
    select from dd07l inner join t002 on dd07l.domname = 'BILA_BTYP' 
                     left outer join dd07t on dd07l.domname = dd07t.domname and dd07l.domvalue_l = dd07t.domvalue_l and dd07t.ddlanguage = t002.spras                    
{
cast(SUBSTRING(dd07l.domvalue_l,1,1) as abap.char(1)) as BILABTYP,
t002.spras,
dd07t.ddtext as TEXT
}
where dd07l.domname = 'BILA_BTYP' and dd07l.domvalue_l <> '3         ' 
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L",
"DD07T",
"T002"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More