TERMVALUE

117 Fields

TERMVALUE is an SAP database table in S/4HANA. It contains 117 fields.

Fields (117)

KeyField CDS FieldsUsed in Views
KEY ConditionType ConditionType 3
KEY FXvaluationDate FXvaluationDate 3
KEY FXvaluationDateDocToStstc FXvaluationDateDocToStstc 3
KEY PricingDocumentItem PricingDocumentItem 3
KEY PricingKey PricingKey 3
KEY Scenario Scenario 3
KEY SubConditionType SubConditionType 3
KEY valuationDate valuationDate 3
KEY Version Version 3
KEY VersStockRecordUUID VersStockRecordUUID 3
BasisID BasisID 2
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 2
CommodityQuantityInTermUnit CommodityQuantityInTermUnit 2
CommodityUnit CommodityUnit 1
ConditionApplication ConditionApplication 3
ConditionTermExchRateIsFixed ConditionTermExchRateIsFixed 3
ConditionTermExtensionUsage ConditionTermExtensionUsage 2
ConditionTermName ConditionTermName 2
ConditionTermRateCurrency ConditionTermRateCurrency 3
ConditionTermRateFixation ConditionTermRateFixation 3
ConditionTermRateIsFixed ConditionTermRateIsFixed 3
ConditionTermRateIsRounded ConditionTermRateIsRounded 2
ConditionTermRateQuantity ConditionTermRateQuantity 3
ConditionTermRateQuantityUnit ConditionTermRateQuantityUnit 2
ConditionTermStatus ConditionTermStatus 2
ConditionTermValueInMarketCurr ConditionTermValueInMarketCurr 2
Creditor Creditor 3
DataSelectionType DataSelectionType 3
DeliveryDate DeliveryDate 3
DerivativeContrSpecification DerivativeContrSpecification 3
DistributionChannel DistributionChannel 3
Division Division 3
DocumentCurrency DocumentCurrency 3
EndOfDayBusinessEntityKey EndOfDayBusinessEntityKey 2
EndOfDaySnapshotDate EndOfDaySnapshotDate 3
EndOfDayTimestampFrom EndOfDayTimestampFrom 3
EndOfDayTimestampTo EndOfDayTimestampTo 3
ExchRateMaturityDate ExchRateMaturityDate 3
ExpectedPaymentDate ExpectedPaymentDate 3
FixedExchRateDate FixedExchRateDate 3
GoodsMovementType GoodsMovementType 3
IncotermsTransferLocation IncotermsTransferLocation 3
IsIntercompanyTransfer IsIntercompanyTransfer 3
MarketIdentifierCode MarketIdentifierCode 3
MarketToDocExchrate MarketToDocExchrate 3
MarketToDocExchrateDate MarketToDocExchrateDate 3
MarketToDocFrozenExchrate MarketToDocFrozenExchrate 3
Material Material 3
MaterialBaseUnit MaterialBaseUnit 3
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 2
OldConditionTermValue OldConditionTermValue 2
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 2
QuotationCurrency QuotationCurrency 2
QuotationGroup QuotationGroup 2
QuotationPeriodEndDate QuotationPeriodEndDate 2
QuotationPeriodReferenceDate QuotationPeriodReferenceDate 3
QuotationPeriodStartDate QuotationPeriodStartDate 2
QuotationPriceType QuotationPriceType 3
QuotationQuantityUnit QuotationQuantityUnit 2
ReferenceDocBusObjType ReferenceDocBusObjType 3
ReferenceDocument ReferenceDocument 3
ReferenceDocumentItem ReferenceDocumentItem 3
RoundingDecimalPlaces RoundingDecimalPlaces 2
SalesOrganization SalesOrganization 3
SnapshotDate0 SnapshotDate0 3
SnapshotDate1 SnapshotDate1 3
SoldToParty SoldToParty 3
SourceDocument SourceDocument 3
SourceDocumentBusObjType SourceDocumentBusObjType 3
SourceDocumentItem SourceDocumentItem 3
SourceTransacEventEndDateTime SourceTransacEventEndDateTime 2
SourceTransactionEventDateTime SourceTransactionEventDateTime 2
StatisticsCurrency StatisticsCurrency 3
StorageLocation StorageLocation 3
SystemMessageNumber SystemMessageNumber 3
ValidityEndDate ValidityEndDate 2
ValidityEndDateTime ValidityEndDateTime 2
ValidityStartDate ValidityStartDate 3
ValidityStartDateTime ValidityStartDateTime 3
ValueSign ValueSign 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 TERMVALUE (
    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,
    CONDITIONTERMRATECURRENCY,
    CONDITIONTERMRATEFIXATION,
    CONDITIONTERMRATEISFIXED,
    CONDITIONTERMRATEISROUNDED,
    CONDITIONTERMRATEQUANTITY,
    CONDITIONTERMRATEQUANTITYUNIT,
    CONDITIONTERMSTATUS,
    CONDITIONTERMVALUEINMARKETCURR,
    CREDITOR,
    DATASELECTIONTYPE,
    DELIVERYDATE,
    DERIVATIVECONTRSPECIFICATION,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTCURRENCY,
    ENDOFDAYBUSINESSENTITYKEY,
    ENDOFDAYSNAPSHOTDATE,
    ENDOFDAYTIMESTAMPFROM,
    ENDOFDAYTIMESTAMPTO,
    EXCHRATEMATURITYDATE,
    EXPECTEDPAYMENTDATE,
    FIXEDEXCHRATEDATE,
    GOODSMOVEMENTTYPE,
    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