P_CONTRACTTYPESIDE

DDL: P_CONTRACTTYPESIDE SQL: PCNTRTYPESIDE Type: view BASIC

P_CONTRACTTYPESIDE is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (tb2be, /accgo/t_cak_typ) and exposes 3 fields.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
tb2be a from
/accgo/t_cak_typ b inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PCNTRTYPESIDE view
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view

Fields (3)

KeyFieldSource TableSource FieldDescription
tctyp tb2be tctyp
tdtpv tb2be tdtpv
tdtpc tb2be tdtpc 
@AbapCatalog.sqlViewName: 'PCNTRTYPESIDE'
@VDM.private: true
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
define view P_CONTRACTTYPESIDE as select from tb2be as a
inner join /accgo/t_cak_typ as b 
on a.tctyp = b.tctyp {
a.tctyp,
a.tdtpv,
a.tdtpc,
a.tc_type_block,
b.contract_type,  
b.contract_sub_type
}

Learn More