E_TradingContract

DDL: E_TRADINGCONTRACT SQL: EPPMGTCONTR Type: view EXTENSION

Trading Contract Header Extension view

E_TradingContract is a Extension CDS View that provides data about "Trading Contract Header Extension view" in SAP S/4HANA. It reads from 2 data sources (wbhd, wbhk) and exposes 1 field with key field TradingContract.

2 data source(s) 1 fields

Data Sources (2)

SourceAliasJoin Type
wbhd PersistanceBus inner
wbhk PersistanceHeader from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName EPPMGTCONTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Trading Contract Header Extension view view
VDM.viewType #EXTENSION view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY TradingContract wbhk tkonn 
@AbapCatalog.sqlViewName: 'EPPMGTCONTR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Trading Contract Header Extension view'

@VDM.viewType: #EXTENSION

@ObjectModel.usageType: {
    serviceQuality: #A,
    sizeCategory: #L,
    dataClass: #TRANSACTIONAL 
 }

define view E_TradingContract as select from wbhk as PersistanceHeader
inner join wbhd as PersistanceBus
on PersistanceHeader.tkonn = PersistanceBus.tkonn 
and PersistanceBus.tposn is initial 
and PersistanceBus.tposn_sub is initial
{
    key PersistanceHeader.tkonn                    as TradingContract
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WBHD",
"WBHK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More