P_ACMTrdgContrTypeWithStatsGrp

DDL: P_ACMTRDGCONTRTYPEWITHSTATSGRP SQL: PACMTCTYPSTATGRP Type: view BASIC

P_ACMTrdgContrTypeWithStatsGrp is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (tb2be, /accgo/t_cak_typ) and exposes 66 fields with key field tctyp.

2 data source(s) 66 fields

Data Sources (2)

SourceAliasJoin Type
tb2be a from
/accgo/t_cak_typ b inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PACMTCTYPSTATGRP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (66)

KeyFieldSource TableSource FieldDescription
KEY tctyp tb2be tctyp
tdtpv tdtpv
tdtpc tdtpc
statgr statgr
txtgr txtgr
incpo incpo
defwaers defwaers
defkurst defkurst
numki numki
tcuncgr tcuncgr
tcsachv tcsachv
gbatch gbatch
tctdid tctdid
wchun wchun
wchqu wchqu
livar livar
kappl_na kappl_na
kalsmk_mgt kalsmk_mgt
kalsmp_mgt kalsmp_mgt
tc_url tc_url
use_case use_case
ceact ceact
pdact pdact
pprot pprot
puser puser
pausw pausw
atnam atnam
tccat tccat
tkonn_ex_act tkonn_ex_act
pofost pofost
btbsta_def btbsta_def
fol_doc_dir fol_doc_dir
pzugr pzugr
tcgroup tcgroup
delivdef delivdef
pargr pargr
closing_rule closing_rule
wb2_bezob wb2_bezob
asso_off asso_off
prchgrp prchgrp
bwrel bwrel
pricing_type pricing_type
tcvariant tcvariant
gts_relevant gts_relevant
ligru ligru
context context
type_usage type_usage
rep_group rep_group
ar_object ar_object
change_doc change_doc
partner_hi partner_hi
txzuf txzuf
freeze_group freeze_group
wrart wrart
lfart_c lfart_c
lfart_v lfart_v
lfart lfart
set_variant set_variant
gts_check gts_check
flow_display flow_display
flow_size flow_size
release_log release_log
purpose purpose
batch_class batch_class
trmrisk_ctrl trmrisk_ctrl
time_control time_control 
@AbapCatalog.sqlViewName: 'PACMTCTYPSTATGRP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #BASIC
@VDM.private: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #S
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_ACMTrdgContrTypeWithStatsGrp 
as select from tb2be as a
inner join /accgo/t_cak_typ as b 
on a.tctyp = b.tctyp {
//a

key a.tctyp,
tdtpv,
tdtpc,
statgr,
txtgr,
incpo,
defwaers,
defkurst,
numki,
tcuncgr,
tcsachv,
gbatch,
tctdid,
wchun,
wchqu,
livar,
kappl_na,
kalsmk_mgt,
kalsmp_mgt,
tc_url,
use_case,
ceact,
pdact,
pprot,
puser,
pausw,
atnam,
tccat,
tkonn_ex_act,
tkonn_ex_check,
tc_change_check,
pofost,
btbsta_def_inco,
btbsta_def,
fol_doc_dir,
tc_type_block,
pzugr,
tcgroup,
delivdef,
price_default,
pargr,
closing_rule,
wb2_bezob,
asso_off,
prchgrp,
bwrel,
pricing_type,
tcvariant,
gts_relevant,
event_relevant,
ligru,
plant_control,
purchase_plant,
context,
type_usage,
rep_group,
ar_object,
item_handling,
change_doc,
document_index,
doc_index_delete,
partner_hi,
batch_det_act,
txzuf,
single_org_data,
consol_context,
freeze_group,
call_off_party,
wrart,
lfart_c,
lfart_v,
lfart,
set_variant,
gts_check,
flow_display,
flow_size,
release_log,
purpose,
item_rel_type,
lock_fol_docs,
settl_purpose,
batch_class,
ppe_group_code,
delivdef_type,
trmrisk_ctrl,
time_control,
//b

contract_type,
contract_sub_type

} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/ACCGO/T_CAK_TYP",
"TB2BE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More