TERM

44 Fields

TERM is an SAP database table in S/4HANA. It contains 44 fields.

Fields (44)

KeyField CDS FieldsUsed in Views
KEY PricingConditionTerm ConditionTermNumber,ConditionTermRateFixation,PricingConditionTerm 8
CalcdPrcgCndnTermQuantityUnit CalcdPrcgCndnTermQuantityUnit 2
CalcdPrcgConditionTermQuantity CalcdPrcgConditionTermQuantity 2
CndnTermFixationOptionLimitQty limit_quantity 2
CndnTrmCrcyPerdDetnResultUUID CndnExchRatePerdDetnResultUUID 1
CndnTrmFixationOptnLmtRoutine limit_routine 2
CndnTrmFixationOptnNonFixedQty CndnTrmFixationOptnNonFixedQty 2
CndnTrmFixationOptnRsltLmtQty limit_quantity_out 2
ConditionTermRate PricingConditionTermRate 2
ConditionTermRateCurrency ConditionTermRateCurrency,PrcgConditionTermRateCrcy 4
ConditionTermRateQuantity ConditionTermRateQuantity,PrcgConditionTermRateQty 4
ConditionTermRateQuantityUnit ConditionTermRateQuantityUnit,PrcgConditionTermRateQtyUnit 4
DerivativeContrSpecification DerivativeContrSpecification 4
DocItmCmmdtyPrcgCndnUUID DocItmCmmdtyPrcgCndnUUID 1
MarketIdentifierCode MarketIdentifierCode 2
PrcgCndnTermCalculationRule PrcgCndnTermCalculationRule 2
PrcgCndnTermCalculationType PrcgCndnTermCalculationType 2
PrcgCndnTermConversionRsltUUID PrcgCndnTermConversionRsltUUID 1
PrcgCndnTermFixationOptnStatus PrcgCndnTermFixationOptnStatus 2
PrcgCndnTermFixedRateQtyUnit PrcgCndnTermFixedRateQtyUnit 2
PrcgCndnTermQuotationRule PrcgCndnTermQuotationRule 2
PrcgCndnTrmConversionInputUUID PrcgCndnTrmConversionInputUUID 1
PrcgCndnTrmQtanRateCurrency PrcgCndnTrmQtanRateCurrency 2
PrcgCndnTrmQtanRateQtyUnit PrcgCndnTrmQtanRateQtyUnit 2
PrcgCndnTrmQtanRateQuantity PrcgCndnTrmQtanRateQuantity 2
PrcgCndnTrmSurchargeRteCrcy PrcgCndnTrmSurchargeRteCrcy 2
PrcgCndnTrmSurchargeRteQty PrcgCndnTrmSurchargeRteQty 2
PrcgCndnTrmSurchargeRteQtyUnit PrcgCndnTrmSurchargeRteQtyUnit 2
PrcgConditionTermFixedRateCrcy PrcgConditionTermFixedRateCrcy 2
PrcgConditionTermFixedRateQty PrcgConditionTermFixedRateQty 2
PrcgConditionTermQuotationRate PrcgConditionTermQuotationRate 2
PrcgConditionTermSurchargeRate PrcgConditionTermSurchargeRate 2
PriceQuotationType QuotationPriceType 2
PricingConditionQuotationKey quotkey_term 2
PricingConditionTermFixedRate PricingConditionTermFixedRate 2
PricingConditionTermGroup PricingConditionTermGroup 2
PricingConditionTermKey PricingConditionTermKey 2
PricingConditionTermRule PricingConditionTermRule 2
TimeToMaturity TimeToMaturity 2
TrmCrcyPerdDetnCalcdRefDate PrcgCndnTrmExchRatePerdRefDate 2
TrmFixationOptionLimitQtyUnit limit_quantity_uom 2
TrmFixationOptnNonFixedQtyUnit TrmFixationOptnNonFixedQtyUnit 2
TrmFixationOptnRsltLmtQtyUnit limit_quantity_uom_out 2
TrmQtnPerdDetnCalcdRefDate PrcgCndnTrmQtanPerdRefDate 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 TERM (
    PRICINGCONDITIONTERM,
    CALCDPRCGCNDNTERMQUANTITYUNIT,
    CALCDPRCGCONDITIONTERMQUANTITY,
    CNDNTERMFIXATIONOPTIONLIMITQTY,
    CNDNTRMCRCYPERDDETNRESULTUUID,
    CNDNTRMFIXATIONOPTNLMTROUTINE,
    CNDNTRMFIXATIONOPTNNONFIXEDQTY,
    CNDNTRMFIXATIONOPTNRSLTLMTQTY,
    CONDITIONTERMRATE,
    CONDITIONTERMRATECURRENCY,
    CONDITIONTERMRATEQUANTITY,
    CONDITIONTERMRATEQUANTITYUNIT,
    DERIVATIVECONTRSPECIFICATION,
    DOCITMCMMDTYPRCGCNDNUUID,
    MARKETIDENTIFIERCODE,
    PRCGCNDNTERMCALCULATIONRULE,
    PRCGCNDNTERMCALCULATIONTYPE,
    PRCGCNDNTERMCONVERSIONRSLTUUID,
    PRCGCNDNTERMFIXATIONOPTNSTATUS,
    PRCGCNDNTERMFIXEDRATEQTYUNIT,
    PRCGCNDNTERMQUOTATIONRULE,
    PRCGCNDNTRMCONVERSIONINPUTUUID,
    PRCGCNDNTRMQTANRATECURRENCY,
    PRCGCNDNTRMQTANRATEQTYUNIT,
    PRCGCNDNTRMQTANRATEQUANTITY,
    PRCGCNDNTRMSURCHARGERTECRCY,
    PRCGCNDNTRMSURCHARGERTEQTY,
    PRCGCNDNTRMSURCHARGERTEQTYUNIT,
    PRCGCONDITIONTERMFIXEDRATECRCY,
    PRCGCONDITIONTERMFIXEDRATEQTY,
    PRCGCONDITIONTERMQUOTATIONRATE,
    PRCGCONDITIONTERMSURCHARGERATE,
    PRICEQUOTATIONTYPE,
    PRICINGCONDITIONQUOTATIONKEY,
    PRICINGCONDITIONTERMFIXEDRATE,
    PRICINGCONDITIONTERMGROUP,
    PRICINGCONDITIONTERMKEY,
    PRICINGCONDITIONTERMRULE,
    TIMETOMATURITY,
    TRMCRCYPERDDETNCALCDREFDATE,
    TRMFIXATIONOPTIONLIMITQTYUNIT,
    TRMFIXATIONOPTNNONFIXEDQTYUNIT,
    TRMFIXATIONOPTNRSLTLMTQTYUNIT,
    TRMQTNPERDDETNCALCDREFDATE,
    PRIMARY KEY (PRICINGCONDITIONTERM)
);

Learn More