TRANSACTIONCONDITION

37 Fields

TRANSACTIONCONDITION is an SAP database table in S/4HANA. It contains 37 fields.

Fields (37)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY ConditionItemValidityStartDate ConditionItemValidityStartDate 3
KEY ConditionLevelNumber ConditionLevelNumber 1
KEY FinancialInstrumentActivity FinancialInstrumentActivity 2
KEY FinancialTransaction FinancialTransaction 2
KEY FinInstrConditionLogicGroup FinInstrConditionLogicGroup 1
KEY FinInstrConditoinNumber FinInstrConditoinNumber 1
ActivityEndDate ActivityEndDate 1
ActivityStartDate ActivityStartDate 1
CalcDateIsAsEndDateInclusive CalcDateIsAsEndDateInclusive 3
CashFlowCalculationCategory CashFlowCalculationCategory 1
CashFlowDirection CashFlowDirection 1
ConditionFixAmount ConditionFixAmount 3
ConditionIsManuallyDtmnd ConditionIsManuallyDtmnd 1
ConditionPercentageRate ConditionPercentageRate 3
ContractType ContractType 3
Counterparty Counterparty 1
FinancialInstrProductCategory FinancialInstrProductCategory 3
FinancialInstrTransactionType FinancialInstrTransactionType 2
FinancialInstrumentProductType FinancialInstrumentProductType 2
FinancialTranactionDirection FinancialTranactionDirection 1
FinInstrConditionType FinInstrConditionType 1
FinInstrConditoinType FinInstrConditoinType 1
FinInstrumentIncomingCurrency FinInstrumentIncomingCurrency 1
FinInstrumentOutgoingCurrency FinInstrumentOutgoingCurrency 1
FixedVariableInterestRateCat FixedVariableInterestRateCat 1
InterestRateInPercent InterestRateInPercent 1
ReferenceInterestRate ReferenceInterestRate 3
ScaledConditionLowerLimit ScaledConditionLowerLimit 1
ScaledConditionUpperLimit ScaledConditionUpperLimit 2
ScaledCondtionLowerLimit ScaledCondtionLowerLimit 1
ScaledCondtionType ScaledCondtionType 1
SecurityAccount SecurityAccount 1
SecurityClass SecurityClass 1
TermEndDate TermEndDate 2
TermStartDate TermStartDate 1
TransactionCurrency TransactionCurrency 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRANSACTIONCONDITION (
    COMPANYCODE,
    CONDITIONITEMVALIDITYSTARTDATE,
    CONDITIONLEVELNUMBER,
    FINANCIALINSTRUMENTACTIVITY,
    FINANCIALTRANSACTION,
    FININSTRCONDITIONLOGICGROUP,
    FININSTRCONDITOINNUMBER,
    ACTIVITYENDDATE,
    ACTIVITYSTARTDATE,
    CALCDATEISASENDDATEINCLUSIVE,
    CASHFLOWCALCULATIONCATEGORY,
    CASHFLOWDIRECTION,
    CONDITIONFIXAMOUNT,
    CONDITIONISMANUALLYDTMND,
    CONDITIONPERCENTAGERATE,
    CONTRACTTYPE,
    COUNTERPARTY,
    FINANCIALINSTRPRODUCTCATEGORY,
    FINANCIALINSTRTRANSACTIONTYPE,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    FINANCIALTRANACTIONDIRECTION,
    FININSTRCONDITIONTYPE,
    FININSTRCONDITOINTYPE,
    FININSTRUMENTINCOMINGCURRENCY,
    FININSTRUMENTOUTGOINGCURRENCY,
    FIXEDVARIABLEINTERESTRATECAT,
    INTERESTRATEINPERCENT,
    REFERENCEINTERESTRATE,
    SCALEDCONDITIONLOWERLIMIT,
    SCALEDCONDITIONUPPERLIMIT,
    SCALEDCONDTIONLOWERLIMIT,
    SCALEDCONDTIONTYPE,
    SECURITYACCOUNT,
    SECURITYCLASS,
    TERMENDDATE,
    TERMSTARTDATE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (COMPANYCODE, CONDITIONITEMVALIDITYSTARTDATE, CONDITIONLEVELNUMBER, FINANCIALINSTRUMENTACTIVITY, FINANCIALTRANSACTION, FININSTRCONDITIONLOGICGROUP, FININSTRCONDITOINNUMBER)
);

Learn More