CONDITION

39 Fields

CONDITION is an SAP database table in S/4HANA. It contains 39 fields.

Fields (39)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 6
KEY FinancialTransaction FinancialTransaction 6
KEY FinancialTransactionDirection FinancialTransactionDirection 5
KEY FinConditionItem FinConditionItem 4
KEY IHBConditionUUID IHBConditionUUID 2
KEY PostingRuleConditionUUID PostingRuleConditionUUID 1
ConditionItemValidityStartDate ConditionItemValidityStartDate 1
ConditionLevelNumber ConditionLevelNumber 1
ConditionPercentageRate ConditionPercentageRate,FinInstrOutgCndnPctgRate,InterestMarkupMarkdownValue 2
CreditLineIdentifier CreditLineIdentifier 1
FinancialInstrProductCategory FinancialInstrProductCategory 5
FinConditionInterestCategory FinConditionInterestCategory,FinInstrOutgCndnIntrstCategory 1
FinInstrConditionLogicGroup FinInstrConditionLogicGroup 1
IHBCndnIntrstAdjmtPerdInDays IHBCndnIntrstAdjmtPerdInDays 2
IHBCndnIntrstLockoutPerdInDays IHBCndnIntrstLockoutPerdInDays 2
IHBCndnIntrstMarkUpDownRate IHBCndnIntrstMarkUpDownRate 2
IHBConditionFactoryCalendarID IHBConditionFactoryCalendarID 2
IHBConditionFixedRate IHBConditionFixedRate 2
IHBConditionInterestCalcMethod IHBConditionInterestCalcMethod 2
IHBConditionInterestCalcType IHBConditionInterestCalcType 2
IHBConditionInterestCurrency IHBConditionInterestCurrency 2
IHBConditionInterestMaxRate IHBConditionInterestMaxRate 2
IHBConditionInterestMinRate IHBConditionInterestMinRate 2
IHBConditionInterestType IHBConditionInterestType 2
IHBConditionInterestWeightCode IHBConditionInterestWeightCode 2
IHBConditionRefRateCode IHBConditionRefRateCode 2
IHBConditionValidFromDate IHBConditionValidFromDate 1
IHBConditionValidToDate IHBConditionValidToDate 1
IHBObjectUUID IHBObjectUUID 1
InterestCalculationMethod FinInstrOutgIntrstCalcMeth,InterestCalculationMethod 1
InterestCalculationType InterestCalculationType 1
InterestMarkupMarkdownValue InterestMarkupMarkdownValue 1
InterestReference FinInstrOutgIntrstReference 1
PostgRuleCndnRangeHigh PostgRuleCndnRangeHigh 1
PostgRuleCndnRangeLow PostgRuleCndnRangeLow 1
PostgRuleCndnRangeOption PostgRuleCndnRangeOption 1
PostgRuleCndnRangeSign PostgRuleCndnRangeSign 1
PostingRuleConditionField PostingRuleConditionField 1
PostingRuleUUID PostingRuleUUID 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CONDITION (
    COMPANYCODE,
    FINANCIALTRANSACTION,
    FINANCIALTRANSACTIONDIRECTION,
    FINCONDITIONITEM,
    IHBCONDITIONUUID,
    POSTINGRULECONDITIONUUID,
    CONDITIONITEMVALIDITYSTARTDATE,
    CONDITIONLEVELNUMBER,
    CONDITIONPERCENTAGERATE,
    CREDITLINEIDENTIFIER,
    FINANCIALINSTRPRODUCTCATEGORY,
    FINCONDITIONINTERESTCATEGORY,
    FININSTRCONDITIONLOGICGROUP,
    IHBCNDNINTRSTADJMTPERDINDAYS,
    IHBCNDNINTRSTLOCKOUTPERDINDAYS,
    IHBCNDNINTRSTMARKUPDOWNRATE,
    IHBCONDITIONFACTORYCALENDARID,
    IHBCONDITIONFIXEDRATE,
    IHBCONDITIONINTERESTCALCMETHOD,
    IHBCONDITIONINTERESTCALCTYPE,
    IHBCONDITIONINTERESTCURRENCY,
    IHBCONDITIONINTERESTMAXRATE,
    IHBCONDITIONINTERESTMINRATE,
    IHBCONDITIONINTERESTTYPE,
    IHBCONDITIONINTERESTWEIGHTCODE,
    IHBCONDITIONREFRATECODE,
    IHBCONDITIONVALIDFROMDATE,
    IHBCONDITIONVALIDTODATE,
    IHBOBJECTUUID,
    INTERESTCALCULATIONMETHOD,
    INTERESTCALCULATIONTYPE,
    INTERESTMARKUPMARKDOWNVALUE,
    INTERESTREFERENCE,
    POSTGRULECNDNRANGEHIGH,
    POSTGRULECNDNRANGELOW,
    POSTGRULECNDNRANGEOPTION,
    POSTGRULECNDNRANGESIGN,
    POSTINGRULECONDITIONFIELD,
    POSTINGRULEUUID,
    PRIMARY KEY (COMPANYCODE, FINANCIALTRANSACTION, FINANCIALTRANSACTIONDIRECTION, FINCONDITIONITEM, IHBCONDITIONUUID, POSTINGRULECONDITIONUUID)
);

Learn More