P_Ftr_Asgn_Pos_With_Start

DDL: P_FTR_ASGN_POS_WITH_START SQL: PFTRPOSWITHSTART Type: view COMPOSITE Package: FTTR_CORE
8 Fields 2 Data Sources

Position Object with Start Information

P_Ftr_Asgn_Pos_With_Start is a Composite CDS View that provides data about "Position Object with Start Information" in SAP S/4HANA. It reads from 2 data sources (vtbfha, P_Ftr_Asgn_Pos) and exposes 8 fields. Part of development package FTTR_CORE.

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 Assignment Obj.
PositionObject P_Ftr_Asgn_Pos PositionObject Position Object
TermStartDate vtbfha dblfz Term Start
ChangeDate P_Ftr_Asgn_Pos ChangeDate Time Stamp
TransactionCurrency P_Ftr_Asgn_Pos TransactionCurrency Transaction Currency
ChangeAmount P_Ftr_Asgn_Pos ChangeAmount Amount Change
CurrencyConversionRate P_Ftr_Asgn_Pos CurrencyConversionRate Exchange Rate
_Currency P_Ftr_Asgn_Pos _Currency

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_Ftr_Asgn_Pos_With_Start.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PFTRPOSWITHSTART

CREATE VIEW P_Ftr_Asgn_Pos_With_Start AS
SELECT
  Position.RelatObject AS RelatObject,
  Position.PositionObject AS PositionObject,
  FinancialTransaction.dblfz AS TermStartDate,
  Position.ChangeDate AS ChangeDate,
  Position.TransactionCurrency AS TransactionCurrency,
  Position.ChangeAmount AS ChangeAmount,
  Position.CurrencyConversionRate AS CurrencyConversionRate,
  Position._Currency AS _Currency
FROM P_Ftr_Asgn_Pos AS Position
INNER JOIN vtbfha AS FinancialTransaction ON /* join condition not captured in parsed metadata */
;

Learn More