P_Trdtflow

DDL: P_TRDTFLOW SQL: PTRDTFLOW Type: view BASIC
25 Fields 1 Data Sources

P_Trdtflow is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (trdt_flow) and exposes 25 fields with key field TreasuryTransactionFlow.

Data Sources (1)

SourceAliasJoin Type
trdt_flow trdtflow from

Annotations (6)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PTRDTFLOW view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY TreasuryTransactionFlow trdt_flow flow_number Flow Number
AssignmentReference trdt_flow alloc_nmbr Assignment
FinancialInstrActivityCategory trdt_flow sfgzustt Activity Cat.
DirectionOfTransaction trdt_flow rkondgr Direction
HouseBank trdt_flow house_bank House Bank
HouseBankAccount trdt_flow house_bank_acc House Bank Acct
PaymentDate trdt_flow payment_date Pymt Date
PaymentReason trdt_flow payment_reason Reason Code
ConditionItemValidityStartDate ptrdtsecflow ConditionItemValidityStartDate
FinancialInstrCharacteristic ptrdtsecflow FinancialInstrCharacteristic Characteristics
FinancialInstrumentReference ptrdtsecflow FinancialInstrumentReference
CalcPeriodEndDateIsInclusive ptrdtsecflow CalcPeriodEndDateIsInclusive
SourceOfFlow ptrdtsecflow SourceOfFlow
InterestCalculationMethod ptrdtsecflow InterestCalculationMethod
FinancialInstrumentAssignment ptrdtsecflow FinancialInstrumentAssignment
NumberOfDays ptrdtsecflow NumberOfDays Number of Days
TreasuryFacilityCompanyCode _FinancialTransaction TreasuryFacilityCompanyCode
Portfolio _FinancialTransaction Portfolio Portfolio
PortfolioName
TreasuryFacility _FinancialTransaction TreasuryFacility
TreasuryFinanceProject _FinancialTransaction TreasuryFinanceProject
Counterparty _FinancialTransaction Counterparty Supplier
FinancialInstrumentStatus _FinancialTransaction FinancialInstrumentStatus
FinancialInstrTransactionType _FinancialTransaction FinancialInstrTransactionType
FinancialTransaction _FinancialTransaction FinancialTransaction Transaction

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_Trdtflow.
-- 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: PTRDTFLOW

CREATE VIEW P_Trdtflow AS
SELECT
  trdtflow.flow_number AS TreasuryTransactionFlow,
  trdtflow.alloc_nmbr AS AssignmentReference,
  trdtflow.sfgzustt AS FinancialInstrActivityCategory,
  trdtflow.rkondgr AS DirectionOfTransaction,
  trdtflow.house_bank AS HouseBank,
  trdtflow.house_bank_acc AS HouseBankAccount,
  trdtflow.payment_date AS PaymentDate,
  trdtflow.payment_reason AS PaymentReason,
  ptrdtsecflow.ConditionItemValidityStartDate AS ConditionItemValidityStartDate,
  ptrdtsecflow.FinancialInstrCharacteristic AS FinancialInstrCharacteristic,
  ptrdtsecflow.FinancialInstrumentReference AS FinancialInstrumentReference,
  ptrdtsecflow.CalcPeriodEndDateIsInclusive AS CalcPeriodEndDateIsInclusive,
  ptrdtsecflow.SourceOfFlow AS SourceOfFlow,
  ptrdtsecflow.InterestCalculationMethod AS InterestCalculationMethod,
  ptrdtsecflow.FinancialInstrumentAssignment AS FinancialInstrumentAssignment,
  ptrdtsecflow.NumberOfDays AS NumberOfDays,
  _FinancialTransaction.TreasuryFacilityCompanyCode AS TreasuryFacilityCompanyCode,
  _FinancialTransaction.Portfolio AS Portfolio,
  _FinancialTransaction._Portfolio._TreasuryPortfolioText[1: Language = $session.system_language].PortfolioName AS PortfolioName,
  _FinancialTransaction.TreasuryFacility AS TreasuryFacility,
  _FinancialTransaction.TreasuryFinanceProject AS TreasuryFinanceProject,
  _FinancialTransaction.Counterparty AS Counterparty,
  _FinancialTransaction.FinancialInstrumentStatus AS FinancialInstrumentStatus,
  _FinancialTransaction.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  _FinancialTransaction.FinancialTransaction AS FinancialTransaction
FROM trdt_flow AS trdtflow
;

Learn More