P_Trdtflow

DDL: P_TRDTFLOW Type: view_entity BASIC Package: FTR_TREASURY_LEDGER_CORE
25 Fields 1 Data Sources

P_View for Table trdt_flow

P_Trdtflow is a Basic CDS View that provides data about "P_View for Table trdt_flow" in SAP S/4HANA. It reads from 1 data source (trdt_flow) and exposes 25 fields with key field TreasuryTransactionFlow. Part of development package FTR_TREASURY_LEDGER_CORE.

Data Sources (1)

SourceAliasJoin Type
trdt_flow trdtflow from

Annotations (3)

NameValueLevelField
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.

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