I_FINANCIALTRANSACTION

CDS View
51 Fields 22 CDS Views

Financial Transaction

I_FINANCIALTRANSACTION is a CDS View in S/4HANA. Financial Transaction. It contains 51 fields. 22 CDS views read from this table.

CDS Views using this table (22)

ViewTypeJoinVDMDescription
I_CmmdtyHdgCnstltnTransOvw view_entity inner COMPOSITE Commodity Hedge Constellation Overview
I_FinancialTransactionStdVH view from COMPOSITE FinancialTransaction
I_FinancialTransactionVH view from COMPOSITE Financial Transaction Value Help
I_FinTransActivityCategory view from BASIC Financial Transaction Activity Category
I_FinTransAdditionalAttribute view from COMPOSITE Financial Trans Additional Attribute
I_FinTransAttribute view from COMPOSITE Financial Transaction Attribute
I_FinTransCurrentActivity view inner COMPOSITE Financial Transaction Current Activity
I_FinTransOverallView view from COMPOSITE Financial Transaction Overall
I_Ftr_Cl_Key_Date_Utilization view inner COMPOSITE Facility Utilization by Key Date
I_Ftr_Cl_Utilize view inner COMPOSITE Facility Utilization With Contract Info
P_CmmdtyHedgeSwapCounterDeal view from BASIC
P_CommodityHedgeSwap view from COMPOSITE
P_FinancialTransactionManage view from COMPOSITE Manage Financial Transactions
P_FinTransFinancialObjectData view from COMPOSITE
P_FINTRANSINTCOND view left_outer COMPOSITE
P_FinTransIntrstRateInstr view from COMPOSITE
P_FinTransOpenFlowBusVol view inner COMPOSITE
P_FXOptionTransBusVol view inner COMPOSITE
P_TFTRANSCASHFLOW view from COMPOSITE
P_TFTRANSFEECOND view left_outer COMPOSITE
R_FinTransSecurityPaytFlow view inner BASIC Fin Trans Security Payment Flow
R_FinTransSecurityQuantityFlow view inner BASIC Fin Trans Security Quantity Flow

Fields (51)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 6
KEY Counterparty Counterparty 7
KEY FinancialTransaction FinancialTransaction 6
BusinessPlace BusinessPlace 1
ClassificationOfFinInstr ClassificationOfFinInstr 1
CostCenter CostCenter 1
CreatedByUser CreatedByUser 1
FinancialInstrCharacteristic FinancialInstrCharacteristic 1
FinancialInstrProductCategory FinancialInstrProductCategory 8
FinancialInstrTransactionType FinancialInstrTransactionType 8
FinancialInstrumentAssignment FinancialInstrumentAssignment 1
FinancialInstrumentGuarantor FinancialInstrumentGuarantor 1
FinancialInstrumentProductType FinancialInstrumentProductType 9
FinancialInstrumentReference FinancialInstrumentReference 1
FinancialInstrumentStatus FinancialInstrumentStatus 2
FinInstrTransactionCategory FinInstrTransactionCategory 1
FinInstrumentIncomingCurrency FinInstrumentIncomingCurrency 1
FinInstrumentLastChangedTime FinInstrumentLastChangedTime 1
FinInstrumentOutgoingCurrency FinInstrumentOutgoingCurrency 1
FinTransAuthorizationGroup FinTransAuthorizationGroup 1
FinTransCreationDate FinTransCreationDate 1
FinTransCreationTime FinTransCreationTime 1
FinTransGeneralValuationClass FinTransGeneralValuationClass 1
FinTransIsRiskMitigating FinTransIsRiskMitigating 1
FinTransNoticePeriod FinTransNoticePeriod 1
FinTransNoticePeriodUnit FinTransNoticePeriodUnit 1
FinTransRoundingCategory FinTransRoundingCategory 1
FunctionalArea FunctionalArea 1
Fund Fund 1
GrantID GrantID 1
InternationalSecuritiesIdnNmbr InternationalSecuritiesIdnNmbr 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
MarketIdentifierCode MarketIdentifierCode 1
Portfolio Portfolio 5
ProfitCenter ProfitCenter 1
ReportTrackingNumber ReportTrackingNumber 1
SecurityAccount SecurityAccount 1
TermStartDate TermStartDate 2
TransactionCurrency TransactionCurrency 3
TreasuryFacility TreasuryFacility 1
TreasuryFacilityCompanyCode TreasuryFacilityCompanyCode 1
TreasuryFinanceProject TreasuryFinanceProject 1
TreasuryFinancialObject TreasuryFinancialObject 1
TrsyPosCustomDiffntnTerm1 TrsyPosCustomDiffntnTerm1 1
TrsyPosCustomDiffntnTerm2 TrsyPosCustomDiffntnTerm2 1
TrsyPosCustomDiffntnTerm3 TrsyPosCustomDiffntnTerm3 1
TrsyPosCustomDiffntnTerm4 TrsyPosCustomDiffntnTerm4 1
TrsyPosCustomDiffntnTerm5 TrsyPosCustomDiffntnTerm5 1
UniqueProductIdentifier UniqueProductIdentifier 1
WBSElementInternalID WBSElementInternalID 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Financial Transaction
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FINANCIALTRANSACTION (
    COMPANYCODE,
    COUNTERPARTY,
    FINANCIALTRANSACTION,
    BUSINESSPLACE,
    CLASSIFICATIONOFFININSTR,
    COSTCENTER,
    CREATEDBYUSER,
    FINANCIALINSTRCHARACTERISTIC,
    FINANCIALINSTRPRODUCTCATEGORY,
    FINANCIALINSTRTRANSACTIONTYPE,
    FINANCIALINSTRUMENTASSIGNMENT,
    FINANCIALINSTRUMENTGUARANTOR,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    FINANCIALINSTRUMENTREFERENCE,
    FINANCIALINSTRUMENTSTATUS,
    FININSTRTRANSACTIONCATEGORY,
    FININSTRUMENTINCOMINGCURRENCY,
    FININSTRUMENTLASTCHANGEDTIME,
    FININSTRUMENTOUTGOINGCURRENCY,
    FINTRANSAUTHORIZATIONGROUP,
    FINTRANSCREATIONDATE,
    FINTRANSCREATIONTIME,
    FINTRANSGENERALVALUATIONCLASS,
    FINTRANSISRISKMITIGATING,
    FINTRANSNOTICEPERIOD,
    FINTRANSNOTICEPERIODUNIT,
    FINTRANSROUNDINGCATEGORY,
    FUNCTIONALAREA,
    FUND,
    GRANTID,
    INTERNATIONALSECURITIESIDNNMBR,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    MARKETIDENTIFIERCODE,
    PORTFOLIO,
    PROFITCENTER,
    REPORTTRACKINGNUMBER,
    SECURITYACCOUNT,
    TERMSTARTDATE,
    TRANSACTIONCURRENCY,
    TREASURYFACILITY,
    TREASURYFACILITYCOMPANYCODE,
    TREASURYFINANCEPROJECT,
    TREASURYFINANCIALOBJECT,
    TRSYPOSCUSTOMDIFFNTNTERM1,
    TRSYPOSCUSTOMDIFFNTNTERM2,
    TRSYPOSCUSTOMDIFFNTNTERM3,
    TRSYPOSCUSTOMDIFFNTNTERM4,
    TRSYPOSCUSTOMDIFFNTNTERM5,
    UNIQUEPRODUCTIDENTIFIER,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (COMPANYCODE, COUNTERPARTY, FINANCIALTRANSACTION)
);

Learn More