I_FINTRANSACTIVITY

CDS View
57 Fields 9 CDS Views

Financial Transaction Activity

I_FINTRANSACTIVITY is a CDS View in S/4HANA. Financial Transaction Activity. It contains 57 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_CmmdtyHdgFinTransaction view inner COMPOSITE Basic for Financial Transaction
I_CmmdtyHedgeTransFlowActivity view inner COMPOSITE Financial Transaction Flow
I_FinTransAttribute view inner COMPOSITE Financial Transaction Attribute
I_FinTransContractActivity view from COMPOSITE Financial Transaction Contract Activity
I_FinTransCurrentActivity view from COMPOSITE Financial Transaction Current Activity
I_FinTransOverallView view inner COMPOSITE Financial Transaction Overall
P_CmmdtyFinancialTransaction view inner COMPOSITE Commodity Financial Transaction
P_FinTransOpenFlowBusVol view inner COMPOSITE The Business Volume for Open Trans Flow
P_FXOptionTransBusVol view inner COMPOSITE Business Vol for FX Option Transaction

Fields (57)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY FinancialInstrumentActivity FinancialInstrumentActivity 3
KEY FinancialTransaction FinancialTransaction 2
_ActivityCategory _ActivityCategory 1
_AdvisingBankBP _AdvisingBankBP 1
_ApplicantBP _ApplicantBP 1
_BeneficiaryBP _BeneficiaryBP 1
_CntrconfStatus _CntrconfStatus 1
_CompanyCode _CompanyCode 2
_ConfStatus _ConfStatus 1
_FinTrans _FinTrans 2
_FixRef _FixRef 1
_FollowingCurrency _FollowingCurrency 1
_IssuingBankBP _IssuingBankBP 1
_LeadingCurrency _LeadingCurrency 1
_RevReason _RevReason 1
_TimeZone _TimeZone 3
EffectiveInterestMethod EffectiveInterestMethod 1
EffectiveInterestRate EffectiveInterestRate 1
ExchangeRate ExchangeRate 2
FinancialInstrActivityCategory FinancialInstrActivityCategory 2
FinancialInstrContactPerson FinancialInstrContactPerson 2
FinInstrExternalReference FinInstrExternalReference 2
FinTransActyConclusionDate FinTransActyConclusionDate,FinTransContractDate,FinTransContractStartDate 5
FinTransActyConclusionTime FinTransActyConclusionTime,FinTransContractStartTime 5
FinTransActyConclusionTimeZone FinTransActyConclusionTimeZone 4
FinTransCntrconfCreatedByUser FinTransCntrconfCreatedByUser 1
FinTransCntrconfDate FinTransCntrconfDate 1
FinTransCntrconfStatus FinTransCntrconfStatus 1
FinTransConfirmationDate FinTransConfirmationDate 1
FinTransConfirmationStatus FinTransConfirmationStatus 1
FinTransConfirmedByUser FinTransConfirmedByUser 1
FinTransExerciseDate FinTransExerciseDate 1
FinTransFixingDate FinTransFixingDate 1
FinTransIntrstHndlgAtRollover FinTransIntrstHndlgAtRollover 1
FinTransNoticeDate FinTransNoticeDate 2
FinTransOrderValidityEndDate FinTransOrderValidityEndDate 1
FinTransRolloverDate FinTransRolloverDate 2
FinTransTermCategory FinTransTermCategory 1
FinTransTermStartEndInclusive FinTransTermStartEndInclusive 1
FollowingCurrency FollowingCurrency 1
ForeignExchangeFixingReference ForeignExchangeFixingReference 1
LeadingCurrency LeadingCurrency 1
LetterOfCredit LetterOfCredit 1
RolloverDfrrdIntrstPyoutDte RolloverDfrrdIntrstPyoutDte 1
SpotExchangeRate SpotExchangeRate 1
SwapExchangeRate SwapExchangeRate 1
TermEndDate TermEndDate 2
TermEndDateIsInclusive TermEndDateIsInclusive 1
Trader Trader 2
TreasuryAdvisingBank TreasuryAdvisingBank 1
TreasuryApplicant TreasuryApplicant 1
TreasuryBeneficiary TreasuryBeneficiary 1
TreasuryIssuingBank TreasuryIssuingBank 1
TreasuryReversalReason TreasuryReversalReason 1
TrsyMnllyEnteredApplcntName TrsyMnllyEnteredApplcntName 1
TrsyMnllyEnteredBnfcyName TrsyMnllyEnteredBnfcyName 1

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 Activity
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FINTRANSACTIVITY (
    COMPANYCODE,
    FINANCIALINSTRUMENTACTIVITY,
    FINANCIALTRANSACTION,
    _ACTIVITYCATEGORY,
    _ADVISINGBANKBP,
    _APPLICANTBP,
    _BENEFICIARYBP,
    _CNTRCONFSTATUS,
    _COMPANYCODE,
    _CONFSTATUS,
    _FINTRANS,
    _FIXREF,
    _FOLLOWINGCURRENCY,
    _ISSUINGBANKBP,
    _LEADINGCURRENCY,
    _REVREASON,
    _TIMEZONE,
    EFFECTIVEINTERESTMETHOD,
    EFFECTIVEINTERESTRATE,
    EXCHANGERATE,
    FINANCIALINSTRACTIVITYCATEGORY,
    FINANCIALINSTRCONTACTPERSON,
    FININSTREXTERNALREFERENCE,
    FINTRANSACTYCONCLUSIONDATE,
    FINTRANSACTYCONCLUSIONTIME,
    FINTRANSACTYCONCLUSIONTIMEZONE,
    FINTRANSCNTRCONFCREATEDBYUSER,
    FINTRANSCNTRCONFDATE,
    FINTRANSCNTRCONFSTATUS,
    FINTRANSCONFIRMATIONDATE,
    FINTRANSCONFIRMATIONSTATUS,
    FINTRANSCONFIRMEDBYUSER,
    FINTRANSEXERCISEDATE,
    FINTRANSFIXINGDATE,
    FINTRANSINTRSTHNDLGATROLLOVER,
    FINTRANSNOTICEDATE,
    FINTRANSORDERVALIDITYENDDATE,
    FINTRANSROLLOVERDATE,
    FINTRANSTERMCATEGORY,
    FINTRANSTERMSTARTENDINCLUSIVE,
    FOLLOWINGCURRENCY,
    FOREIGNEXCHANGEFIXINGREFERENCE,
    LEADINGCURRENCY,
    LETTEROFCREDIT,
    ROLLOVERDFRRDINTRSTPYOUTDTE,
    SPOTEXCHANGERATE,
    SWAPEXCHANGERATE,
    TERMENDDATE,
    TERMENDDATEISINCLUSIVE,
    TRADER,
    TREASURYADVISINGBANK,
    TREASURYAPPLICANT,
    TREASURYBENEFICIARY,
    TREASURYISSUINGBANK,
    TREASURYREVERSALREASON,
    TRSYMNLLYENTEREDAPPLCNTNAME,
    TRSYMNLLYENTEREDBNFCYNAME,
    PRIMARY KEY (COMPANYCODE, FINANCIALINSTRUMENTACTIVITY, FINANCIALTRANSACTION)
);

Learn More