I_FinTransFlowAcctgPaytInfo

DDL: I_FINTRANSFLOWACCTGPAYTINFO Type: view_entity COMPOSITE Package: FTTR_CORE
13 Fields 1 Data Sources 1 Associations

Main acctg payt info of a flow

I_FinTransFlowAcctgPaytInfo (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Financial Operations

I_FinTransFlowAcctgPaytInfo is a Composite CDS View that provides data about "Main acctg payt info of a flow" in SAP S/4HANA. It reads from 1 data source (I_FinancialTransaction) and exposes 13 fields with key field TrsyTransacMgmtBizTransaction. It has 1 association to related views. Part of development package FTTR_CORE.

SAP Help Documentation

CategoryFinancial Transaction Data
StatusPymnt Request Status
Purpose
This CDS view shows the main position information that is important to a cash flow of the current activity of a financial transaction, including detailed information about accounting document, fiscal year, payment request. This CDS view provides the data to answer the following business questions: What is the accounting and payment information of the cash flow of the current activity of a financial transaction? With which payment request is the flow paid? With which accounting document and when is the flow posted? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: Company Code/Product Type/Financial Transaction Type Company Code/Securities Account Company Code/Portfolio Company Code/Paying Valuation Area/Product Type These restriction types are edited in the Maintain Business Roles app. Configuration

Structure
Important Fields Important fields in this view include the following: Field Name Description Comment TRSYTRANSACMGMTBIZTRANSACTION TM Bus.Transaction For most instruments, this is a concatenation of Company Code , Financial Transaction , Activity , Flow Creation Date , Flow Creation Time , Flow Number . For the product category Securities , it's a concatenation of Company Code , Financial Transaction , Activity and X02 . Less COMPANYCODE Company Code FINANCIALTRANSACTION Transaction FINANCIALINSTRPRODUCTCATEGORY Product Category PAYINGVALUATIONAREA Valuation Area ACCOUNTINGDOCUMENT Document Number FISCALYEAR Fiscal Year FINTRANSFLOWPOSTINGDATE Posting Date PAYMENTREQUEST Payment Request PAYTREQORIGLREFERENCEDOCUMENT Pay. Req. Ref. Key TRSYPAYTREQUESTRELEASESTATUS PReq. Release Status TREASURYPAYMENTREQUESTSTATUS Pymnt Request Status

Data Extraction
Data Extraction Type

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-TRM-2CL
CapabilitiesAssociation Target for Defining CDS Entities,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageFinancial Operations for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_FinancialTransaction FinTrans from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FinancialTransaction _FinTrans $projection.CompanyCode = _FinTrans.CompanyCode and $projection.FinancialTransaction = _FinTrans.FinancialTransaction

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Main acctg payt info of a flow view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY TrsyTransacMgmtBizTransaction BizTransac TrsyTransacMgmtBizTransaction Business Transaction Identifier in Transaction Management
CompanyCode I_FinancialTransaction CompanyCode Receiver Company Code
FinancialTransaction I_FinancialTransaction FinancialTransaction Financial Transaction
FinancialInstrProductCategory I_FinancialTransaction FinancialInstrProductCategory Financial Instrument Product Category
PayingValuationArea BizTransac PayingValuationArea
AccountingDocument AcctInfo AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
FinTransFlowPostingDate AcctInfo PostingDate Posting Date in the Document
PaymentRequest PaytRequest PaymentRequest Payment Request
PaytReqOriglReferenceDocument PaytRequest PaytReqOriglReferenceDocument Payment Request Reference Key
TrsyPaytRequestReleaseStatus PaytRequest TrsyPaytRequestReleaseStatus Payment Request Release Status
TreasuryPaymentRequestStatus PaytRequest TreasuryPaymentRequestStatus Payment Request Status
_FinTrans _FinTrans

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 I_FinTransFlowAcctgPaytInfo.
-- 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 I_FinTransFlowAcctgPaytInfo AS
SELECT
  BizTransac.TrsyTransacMgmtBizTransaction AS TrsyTransacMgmtBizTransaction,
  FinTrans.CompanyCode AS CompanyCode,
  FinTrans.FinancialTransaction AS FinancialTransaction,
  FinTrans.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  BizTransac.PayingValuationArea AS PayingValuationArea,
  AcctInfo.AccountingDocument AS AccountingDocument,
  cast( AcctInfo.FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  AcctInfo.PostingDate AS FinTransFlowPostingDate,
  PaytRequest.PaymentRequest AS PaymentRequest,
  PaytRequest.PaytReqOriglReferenceDocument AS PaytReqOriglReferenceDocument,
  PaytRequest.TrsyPaytRequestReleaseStatus AS TrsyPaytRequestReleaseStatus,
  PaytRequest.TreasuryPaymentRequestStatus AS TreasuryPaymentRequestStatus
FROM I_FinancialTransaction AS FinTrans
LEFT OUTER JOIN I_FinancialTransaction AS _FinTrans ON CompanyCode = _FinTrans.CompanyCode AND FinancialTransaction = _FinTrans.FinancialTransaction  -- association [0..1]
;

Learn More