I_CMMDTYPRCGCNDNTERMCONVERSION

CDS View
38 Fields 6 CDS Views

CPE Condition Term Conversion

I_CMMDTYPRCGCNDNTERMCONVERSION is a CDS View in S/4HANA. CPE Condition Term Conversion. It contains 38 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
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 (38)

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

-- CPE Condition Term Conversion
-- 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,
    PRICINGCONDITIONCONVERSIONRULE,
    PRICINGCONDITIONFORECASTSTATUS,
    QTYCNVRSNNROFDCMLSTOBERNDDTO,
    QTYCNVRSNNROFPREDCMLSROUNDEDTO,
    SOURCECONVERSIONFACTOR,
    TARGETCONVERSIONFACTOR,
    PRIMARY KEY (DOCITMCMMDTYPRCGCNDNUUID, PRCGCNDNSOURCEQUANTITYUNIT, PRCGCNDNTARGETQUANTITYUNIT, PRCGCONDITIONCONVERSIONPLACE, PRICINGCONDITIONSOURCECURRENCY, PRICINGCONDITIONTARGETCURRENCY, PRICINGCONDITIONTERM, PRICINGCONDITIONTERMKEY)
);

Learn More