P_Ftr_Asgn_Pos_With_Start

DDL: P_FTR_ASGN_POS_WITH_START SQL: PFTRPOSWITHSTART Type: view COMPOSITE

P_Ftr_Asgn_Pos_With_Start is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (vtbfha, P_Ftr_Asgn_Pos) and exposes 8 fields.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
vtbfha FinancialTransaction inner
P_Ftr_Asgn_Pos Position from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PFTRPOSWITHSTART view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #B view
VDM.private true view

Fields (8)

KeyFieldSource TableSource FieldDescription
RelatObject P_Ftr_Asgn_Pos RelatObject
PositionObject P_Ftr_Asgn_Pos PositionObject
TermStartDate vtbfha dblfz
ChangeDate P_Ftr_Asgn_Pos ChangeDate
TransactionCurrency P_Ftr_Asgn_Pos TransactionCurrency
ChangeAmount P_Ftr_Asgn_Pos ChangeAmount
CurrencyConversionRate P_Ftr_Asgn_Pos CurrencyConversionRate
_Currency P_Ftr_Asgn_Pos _Currency 
@AbapCatalog.sqlViewName: 'PFTRPOSWITHSTART'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #B
@VDM.private:true
define view P_Ftr_Asgn_Pos_With_Start
  as select from           P_Ftr_Asgn_Pos                              as Position
    inner join             vtbfha                                      as FinancialTransaction on  Position.CompanyCode          = FinancialTransaction.bukrs //Need to be changed to I_FinancialTransaction once the field is ready, keep this view as a composite view

                                                                                               and Position.FinancialTransaction = FinancialTransaction.rfha
{
  Position.RelatObject,
  Position.PositionObject,
  FinancialTransaction.dblfz  as TermStartDate, //Do not use I_FinancialTransaction since this view does not contain this field, use start date to get split ratio

  Position.ChangeDate,
  @Semantics.currencyCode: true
  Position.TransactionCurrency,

  @Semantics.amount.currencyCode: 'TransactionCurrency'
  @DefaultAggregation: #SUM
  Position.ChangeAmount,
  Position.CurrencyConversionRate,

  Position._Currency
}
where
  FinancialTransaction.saktiv <> '3'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_FTR_ASGN_POS",
"VTBFHA"
],
"ASSOCIATED":
[
"I_CURRENCY"
],
"BASE":
[
"P_FTR_ASGN_POS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More