TERMRATE

121 Fields

TERMRATE is an SAP database table in S/4HANA. It contains 121 fields.

Fields (121)

KeyField CDS FieldsUsed in Views
KEY ConditionType ConditionType 3
KEY FXvaluationDate FXvaluationDate 3
KEY FXvaluationDateDocToStstc FXvaluationDateDocToStstc 3
KEY PricingDocumentItem PricingDocumentItem 2
KEY PricingKey PricingKey 3
KEY Scenario Scenario 3
KEY SubConditionType SubConditionType 3
KEY valuationDate valuationDate 3
KEY Version Version 3
KEY VersStockRecordUUID VersStockRecordUUID 1
BasisID BasisID 3
BasisMarketRefAdjustmentSpread BasisMarketRefAdjustmentSpread 3
BasisMarketRefKeyDate BasisMarketRefKeyDate 3
BasisMarketRefRate BasisMarketRefRate 3
BasisMarketRefRateCurrency BasisMarketRefRateCurrency 3
BasisType BasisType 3
Batch Batch 3
BsMktRefDrvtvContrMaturityCode BsMktRefDrvtvContrMaturityCode 3
BusinessArea BusinessArea 3
CndnTermExchRateFixationDate CndnTermExchRateFixationDate 3
CndnTermExchRateFixationTime CndnTermExchRateFixationTime 3
CndnTermRateFixationDate CndnTermRateFixationDate 3
CndnTermRateFixationTime CndnTermRateFixationTime 3
CommodityContractMaturityCode CommodityContractMaturityCode 3
CommodityQuantityInBaseUnit CommodityQuantityInBaseUnit 1
CommodityQuantityInTermUnit CommodityQuantityInTermUnit 2
CommodityUnit CommodityUnit 2
ConditionApplication ConditionApplication 3
ConditionTermExchRateIsFixed ConditionTermExchRateIsFixed 3
ConditionTermExtensionUsage ConditionTermExtensionUsage 3
ConditionTermName ConditionTermName 3
ConditionTermRate ConditionTermRate 1
ConditionTermRateConv ConditionTermRateConv 1
ConditionTermRateCurrency ConditionTermRateCurrency 2
ConditionTermRateFixation ConditionTermRateFixation 3
ConditionTermRateIsFixed ConditionTermRateIsFixed 3
ConditionTermRateIsRounded ConditionTermRateIsRounded 3
ConditionTermRateQuantity ConditionTermRateQuantity 3
ConditionTermRateQuantityUnit ConditionTermRateQuantityUnit 3
ConditionTermStatus ConditionTermStatus 3
ConditionTermValue ConditionTermValue 2
ConditionTermValueCurrency ConditionTermValueCurrency 2
Creditor Creditor 3
DataSelectionType DataSelectionType 3
DeliveryDate DeliveryDate 3
DerivativeContrSpecification DerivativeContrSpecification 3
DistributionChannel DistributionChannel 3
Division Division 3
DocumentCurrency DocumentCurrency 3
EndOfDayBusinessEntityKey EndOfDayBusinessEntityKey 3
EndOfDaySnapshotDate EndOfDaySnapshotDate 3
EndOfDayTimestampFrom EndOfDayTimestampFrom 3
EndOfDayTimestampTo EndOfDayTimestampTo 3
ExchRateMaturityDate ExchRateMaturityDate 3
ExpectedPaymentDate ExpectedPaymentDate 3
FixedExchRateDate FixedExchRateDate 3
GoodsMovementType GoodsMovementType 1
IncotermsClassification IncotermsClassification 1
IncotermsTransferLocation IncotermsTransferLocation 3
IsIntercompanyTransfer IsIntercompanyTransfer 3
MarketIdentifierCode MarketIdentifierCode 3
MarketToDocExchrate MarketToDocExchrate 2
MarketToDocExchrateDate MarketToDocExchrateDate 2
MarketToDocFrozenExchrate MarketToDocFrozenExchrate 3
Material Material 3
MaterialBaseUnit MaterialBaseUnit 1
MaterialGroup MaterialGroup 3
MaturityKeyDate MaturityKeyDate 3
MaximumVersion MaximumVersion 3
MTMAdjustmentType MTMAdjustmentType 3
MTMCalcGrpMarketPriceCondition MTMCalcGrpMarketPriceCondition 3
MTMCalculationGroup MTMCalculationGroup 3
MTMConditionGroup MTMConditionGroup 3
MTMConditionGroupCategory MTMConditionGroupCategory 3
MTMDataSourceType MTMDataSourceType 3
OldConditionTermrate OldConditionTermrate 3
OldConditionTermValue OldConditionTermValue 3
OldestQuotationDate OldestQuotationDate 3
OriginReferenceDocBusObjType OriginReferenceDocBusObjType 3
OriginReferenceDocument OriginReferenceDocument 3
OriginReferenceDocumentItem OriginReferenceDocumentItem 3
PhysicalCommodity PhysicalCommodity 3
Plant Plant 3
PreviousSubConditionType PreviousSubConditionType 3
PreviousVersion PreviousVersion 3
PreviousVersionQuantitySign PreviousVersionQuantitySign 3
PrevVersCndnTermRateCurrency PrevVersCndnTermRateCurrency 3
PrevVersionCommodityQuantity PrevVersionCommodityQuantity 3
PrevVersionConditionTermValue PrevVersionConditionTermValue 3
PricingStatus PricingStatus 3
ProfitCenter ProfitCenter 3
PurchasingOrganization PurchasingOrganization 3
QuantitySign QuantitySign 1
QuotationCurrency QuotationCurrency 3
QuotationGroup QuotationGroup 3
QuotationPeriodEndDate QuotationPeriodEndDate 3
QuotationPeriodReferenceDate QuotationPeriodReferenceDate 3
QuotationPeriodStartDate QuotationPeriodStartDate 3
QuotationPriceType QuotationPriceType 3
QuotationQuantityUnit QuotationQuantityUnit 3
ReferenceDocBusObjType ReferenceDocBusObjType 3
ReferenceDocument ReferenceDocument 3
ReferenceDocumentItem ReferenceDocumentItem 3
RoundingDecimalPlaces DocToFunctionalExchRate,RoundingDecimalPlaces 3
SalesOrganization SalesOrganization 3
SnapshotDate0 SnapshotDate0 3
SnapshotDate1 SnapshotDate1 3
SoldToParty SoldToParty 3
SourceDocument SourceDocument 2
SourceDocumentBusObjType SourceDocumentBusObjType 2
SourceDocumentItem SourceDocumentItem 1
SourceTransacEventEndDateTime SourceTransacEventEndDateTime 3
SourceTransactionEventDateTime SourceTransactionEventDateTime 3
StatisticsCurrency StatisticsCurrency 3
StorageLocation StorageLocation 3
SystemMessageNumber SystemMessageNumber 2
ValidityEndDate ValidityEndDate 3
ValidityEndDateTime ValidityEndDateTime 3
ValidityStartDate ValidityStartDate 3
ValidityStartDateTime ValidityStartDateTime 3
ValueSign ValueSign 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 TERMRATE (
    CONDITIONTYPE,
    FXVALUATIONDATE,
    FXVALUATIONDATEDOCTOSTSTC,
    PRICINGDOCUMENTITEM,
    PRICINGKEY,
    SCENARIO,
    SUBCONDITIONTYPE,
    VALUATIONDATE,
    VERSION,
    VERSSTOCKRECORDUUID,
    BASISID,
    BASISMARKETREFADJUSTMENTSPREAD,
    BASISMARKETREFKEYDATE,
    BASISMARKETREFRATE,
    BASISMARKETREFRATECURRENCY,
    BASISTYPE,
    BATCH,
    BSMKTREFDRVTVCONTRMATURITYCODE,
    BUSINESSAREA,
    CNDNTERMEXCHRATEFIXATIONDATE,
    CNDNTERMEXCHRATEFIXATIONTIME,
    CNDNTERMRATEFIXATIONDATE,
    CNDNTERMRATEFIXATIONTIME,
    COMMODITYCONTRACTMATURITYCODE,
    COMMODITYQUANTITYINBASEUNIT,
    COMMODITYQUANTITYINTERMUNIT,
    COMMODITYUNIT,
    CONDITIONAPPLICATION,
    CONDITIONTERMEXCHRATEISFIXED,
    CONDITIONTERMEXTENSIONUSAGE,
    CONDITIONTERMNAME,
    CONDITIONTERMRATE,
    CONDITIONTERMRATECONV,
    CONDITIONTERMRATECURRENCY,
    CONDITIONTERMRATEFIXATION,
    CONDITIONTERMRATEISFIXED,
    CONDITIONTERMRATEISROUNDED,
    CONDITIONTERMRATEQUANTITY,
    CONDITIONTERMRATEQUANTITYUNIT,
    CONDITIONTERMSTATUS,
    CONDITIONTERMVALUE,
    CONDITIONTERMVALUECURRENCY,
    CREDITOR,
    DATASELECTIONTYPE,
    DELIVERYDATE,
    DERIVATIVECONTRSPECIFICATION,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTCURRENCY,
    ENDOFDAYBUSINESSENTITYKEY,
    ENDOFDAYSNAPSHOTDATE,
    ENDOFDAYTIMESTAMPFROM,
    ENDOFDAYTIMESTAMPTO,
    EXCHRATEMATURITYDATE,
    EXPECTEDPAYMENTDATE,
    FIXEDEXCHRATEDATE,
    GOODSMOVEMENTTYPE,
    INCOTERMSCLASSIFICATION,
    INCOTERMSTRANSFERLOCATION,
    ISINTERCOMPANYTRANSFER,
    MARKETIDENTIFIERCODE,
    MARKETTODOCEXCHRATE,
    MARKETTODOCEXCHRATEDATE,
    MARKETTODOCFROZENEXCHRATE,
    MATERIAL,
    MATERIALBASEUNIT,
    MATERIALGROUP,
    MATURITYKEYDATE,
    MAXIMUMVERSION,
    MTMADJUSTMENTTYPE,
    MTMCALCGRPMARKETPRICECONDITION,
    MTMCALCULATIONGROUP,
    MTMCONDITIONGROUP,
    MTMCONDITIONGROUPCATEGORY,
    MTMDATASOURCETYPE,
    OLDCONDITIONTERMRATE,
    OLDCONDITIONTERMVALUE,
    OLDESTQUOTATIONDATE,
    ORIGINREFERENCEDOCBUSOBJTYPE,
    ORIGINREFERENCEDOCUMENT,
    ORIGINREFERENCEDOCUMENTITEM,
    PHYSICALCOMMODITY,
    PLANT,
    PREVIOUSSUBCONDITIONTYPE,
    PREVIOUSVERSION,
    PREVIOUSVERSIONQUANTITYSIGN,
    PREVVERSCNDNTERMRATECURRENCY,
    PREVVERSIONCOMMODITYQUANTITY,
    PREVVERSIONCONDITIONTERMVALUE,
    PRICINGSTATUS,
    PROFITCENTER,
    PURCHASINGORGANIZATION,
    QUANTITYSIGN,
    QUOTATIONCURRENCY,
    QUOTATIONGROUP,
    QUOTATIONPERIODENDDATE,
    QUOTATIONPERIODREFERENCEDATE,
    QUOTATIONPERIODSTARTDATE,
    QUOTATIONPRICETYPE,
    QUOTATIONQUANTITYUNIT,
    REFERENCEDOCBUSOBJTYPE,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTITEM,
    ROUNDINGDECIMALPLACES,
    SALESORGANIZATION,
    SNAPSHOTDATE0,
    SNAPSHOTDATE1,
    SOLDTOPARTY,
    SOURCEDOCUMENT,
    SOURCEDOCUMENTBUSOBJTYPE,
    SOURCEDOCUMENTITEM,
    SOURCETRANSACEVENTENDDATETIME,
    SOURCETRANSACTIONEVENTDATETIME,
    STATISTICSCURRENCY,
    STORAGELOCATION,
    SYSTEMMESSAGENUMBER,
    VALIDITYENDDATE,
    VALIDITYENDDATETIME,
    VALIDITYSTARTDATE,
    VALIDITYSTARTDATETIME,
    VALUESIGN,
    PRIMARY KEY (CONDITIONTYPE, FXVALUATIONDATE, FXVALUATIONDATEDOCTOSTSTC, PRICINGDOCUMENTITEM, PRICINGKEY, SCENARIO, SUBCONDITIONTYPE, VALUATIONDATE, VERSION, VERSSTOCKRECORDUUID)
);

Learn More