I_CMMDTYPRCGCNDNTERMCONVERSION

CDS View
39 Fields 8 CDS Views

Conversion in Pricing Condition Term

I_CMMDTYPRCGCNDNTERMCONVERSION is a CDS View in S/4HANA. Conversion in Pricing Condition Term. It contains 39 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_CmmdtyPrcgCndnTrmCnvrsnInput view_entity from COMPOSITE Conversion Input in Term
I_CmmdtyPrcgCndnTrmCnvrsnRslt view_entity from COMPOSITE Term Conversion Result
I_CndnRmndrFltgTrmCnvrsnResult view_entity from COMPOSITE
I_CndnRmndrTrmConversionResult view_entity from COMPOSITE
I_PrcgCndnExerTrmCnvrsnInput view_entity from COMPOSITE
I_PrcgCndnExerTrmCnvrsnResult view_entity from COMPOSITE
I_PrcgCndnRootTrmCnvrsnInput view_entity from COMPOSITE CPE Root term conversion input
I_PrcgCndnRootTrmCnvrsnResult view_entity from COMPOSITE CPE Root term conversion result

Fields (39)

KeyField CDS FieldsUsed in Views
KEY DocItmCmmdtyPrcgCndnUUID DocItmCmmdtyPrcgCndnUUID 7
KEY PrcgCndnSourceQuantityUnit PrcgCndnSourceQuantityUnit 3
KEY PrcgCndnTargetQuantityUnit PrcgCndnTargetQuantityUnit 3
KEY PrcgConditionConversionPlace PrcgConditionConversionPlace 7
KEY PricingConditionSourceCurrency PricingConditionSourceCurrency 3
KEY PricingConditionTargetCurrency PricingConditionTargetCurrency 3
KEY PricingConditionTerm PricingConditionTerm 7
KEY PricingConditionTermKey PricingConditionTermKey 3
CndnCrcyCnvrsnRoundingRoutine CndnCrcyCnvrsnRoundingRoutine 3
CndnQtyCnvrsnRoundingRoutine CndnQtyCnvrsnRoundingRoutine 3
CndnQtyConversionRoundingRule CndnQtyConversionRoundingRule 3
CndnQuantityConversionRoutine CndnQuantityConversionRoutine 3
CrcyCnvrsnNrOfDcmlsToBeRnddTo CrcyCnvrsnNrOfDcmlsToBeRnddTo 3
CrcyCnvrsnNrOfPreDcmlsRnddTo CrcyCnvrsnNrOfPreDcmlsRnddTo 3
PrcgCndnCnvrsnIsExchRateAvg PrcgCndnCnvrsnIsExchRateAvg 7
PrcgCndnCnvrsnQtyAdjmtFactor PrcgCndnCnvrsnQtyAdjmtFactor 4
PrcgCndnConversionRoundingRule PrcgCndnConversionRoundingRule 3
PrcgCndnFXRateChangeDateTime PrcgCndnFXRateChangeDateTime 3
PrcgCndnFXRateChangedByUser PrcgCndnFXRateChangedByUser 3
PrcgCndnFXRateCreatedByUser PrcgCndnFXRateCreatedByUser 2
PrcgCndnFXRateCreationDateTime PrcgCndnFXRateCreationDateTime 2
PrcgCndnQuantityConversionRule PrcgCndnQuantityConversionRule 3
PrcgCndnUsedExchangeRate PrcgCndnUsedExchangeRate 4
PrcgCndnUsedSourceCurrency PrcgCndnUsedSourceCurrency 4
PrcgCndnUsedSourceQuantityUnit PrcgCndnUsedSourceQuantityUnit 4
PrcgCndnUsedTargetCurrency PrcgCndnUsedTargetCurrency 4
PrcgCndnUsedTargetQuantityUnit PrcgCndnUsedTargetQuantityUnit 4
PrcgConditionConversionRoutine PrcgConditionConversionRoutine 3
PrcgConditionExchangeRateType PrcgConditionExchangeRateType 3
PrcgConditionFixedExchangeRate PrcgConditionFixedExchangeRate 3
PrcgConditionUsedSourceFactor PrcgConditionUsedSourceFactor 4
PrcgConditionUsedTargetFactor PrcgConditionUsedTargetFactor 4
PricingCndnTermExtensionGroup PricingCndnTermExtensionGroup 1
PricingConditionConversionRule PricingConditionConversionRule 3
PricingConditionForecastStatus PricingConditionForecastStatus 4
QtyCnvrsnNrOfDcmlsToBeRnddTo QtyCnvrsnNrOfDcmlsToBeRnddTo 3
QtyCnvrsnNrOfPreDcmlsRoundedTo QtyCnvrsnNrOfPreDcmlsRoundedTo 3
SourceConversionFactor SourceConversionFactor 3
TargetConversionFactor TargetConversionFactor 3

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.

-- Conversion in Pricing Condition Term
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CMMDTYPRCGCNDNTERMCONVERSION (
    DOCITMCMMDTYPRCGCNDNUUID,
    PRCGCNDNSOURCEQUANTITYUNIT,
    PRCGCNDNTARGETQUANTITYUNIT,
    PRCGCONDITIONCONVERSIONPLACE,
    PRICINGCONDITIONSOURCECURRENCY,
    PRICINGCONDITIONTARGETCURRENCY,
    PRICINGCONDITIONTERM,
    PRICINGCONDITIONTERMKEY,
    CNDNCRCYCNVRSNROUNDINGROUTINE,
    CNDNQTYCNVRSNROUNDINGROUTINE,
    CNDNQTYCONVERSIONROUNDINGRULE,
    CNDNQUANTITYCONVERSIONROUTINE,
    CRCYCNVRSNNROFDCMLSTOBERNDDTO,
    CRCYCNVRSNNROFPREDCMLSRNDDTO,
    PRCGCNDNCNVRSNISEXCHRATEAVG,
    PRCGCNDNCNVRSNQTYADJMTFACTOR,
    PRCGCNDNCONVERSIONROUNDINGRULE,
    PRCGCNDNFXRATECHANGEDATETIME,
    PRCGCNDNFXRATECHANGEDBYUSER,
    PRCGCNDNFXRATECREATEDBYUSER,
    PRCGCNDNFXRATECREATIONDATETIME,
    PRCGCNDNQUANTITYCONVERSIONRULE,
    PRCGCNDNUSEDEXCHANGERATE,
    PRCGCNDNUSEDSOURCECURRENCY,
    PRCGCNDNUSEDSOURCEQUANTITYUNIT,
    PRCGCNDNUSEDTARGETCURRENCY,
    PRCGCNDNUSEDTARGETQUANTITYUNIT,
    PRCGCONDITIONCONVERSIONROUTINE,
    PRCGCONDITIONEXCHANGERATETYPE,
    PRCGCONDITIONFIXEDEXCHANGERATE,
    PRCGCONDITIONUSEDSOURCEFACTOR,
    PRCGCONDITIONUSEDTARGETFACTOR,
    PRICINGCNDNTERMEXTENSIONGROUP,
    PRICINGCONDITIONCONVERSIONRULE,
    PRICINGCONDITIONFORECASTSTATUS,
    QTYCNVRSNNROFDCMLSTOBERNDDTO,
    QTYCNVRSNNROFPREDCMLSROUNDEDTO,
    SOURCECONVERSIONFACTOR,
    TARGETCONVERSIONFACTOR,
    PRIMARY KEY (DOCITMCMMDTYPRCGCNDNUUID, PRCGCNDNSOURCEQUANTITYUNIT, PRCGCNDNTARGETQUANTITYUNIT, PRCGCONDITIONCONVERSIONPLACE, PRICINGCONDITIONSOURCECURRENCY, PRICINGCONDITIONTARGETCURRENCY, PRICINGCONDITIONTERM, PRICINGCONDITIONTERMKEY)
);

Learn More