fac_opp_cds_co_biz_trans

DDL: FAC_OPP_CDS_CO_BIZ_TRANS SQL: FACOPPV_CO_BIZT Type: view

CDS View for CO business transaction

fac_opp_cds_co_biz_trans is a CDS View that provides data about "CDS View for CO business transaction" in SAP S/4HANA. It reads from 2 data sources (tj01, tj01t) and exposes 1 field with key field co_biz_trans.

Data Sources (2)

SourceAliasJoin Type
tj01 tj01 from
tj01t tj01t left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FACOPPV_CO_BIZT view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #AUTOMATED view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS View for CO business transaction view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY co_biz_trans tj01 vrgng
@AbapCatalog.sqlViewName: 'FACOPPV_CO_BIZT'
@ClientHandling.type: #INHERITED 
@ClientHandling.algorithm: #AUTOMATED 
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CDS View for CO business transaction'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #C

define view fac_opp_cds_co_biz_trans as 
select from tj01
left outer join tj01t
  on tj01.vrgng = tj01t.vrgng and 
     tj01t.spras = $session.system_language
{
 key tj01.vrgng as co_biz_trans, 
     tj01t.txt  as co_biz_trans_descr
} 
where wtkat = 'A'
  and persp = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TJ01",
"TJ01T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/