I_PRCGCNDNEXERTRMCNVRSNRESULT

CDS View

I_PRCGCNDNEXERTRMCNVRSNRESULT is a CDS View in S/4HANA. It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PrcgCndnExerTermExchangeRate view_entity inner COMPOSITE
R_PrcgCndnExerTrmCnvrsnRsltTP view_entity from TRANSACTIONAL CPE Condition Exer Term Cnvrsn Rslt - TP

Fields (13)

KeyField CDS FieldsUsed in Views
KEY DocItmCmmdtyPrcgCndnUUID DocItmCmmdtyPrcgCndnUUID 1
KEY PrcgConditionConversionPlace PrcgConditionConversionPlace 1
KEY PricingConditionTerm PricingConditionTerm 1
PrcgCndnCnvrsnIsExchRateAvg PrcgCndnCnvrsnIsExchRateAvg 1
PrcgCndnCnvrsnQtyAdjmtFactor PrcgCndnCnvrsnQtyAdjmtFactor 1
PrcgCndnUsedExchangeRate PrcgCndnUsedExchangeRate 1
PrcgCndnUsedSourceCurrency PrcgCndnUsedSourceCurrency 1
PrcgCndnUsedSourceQuantityUnit PrcgCndnUsedSourceQuantityUnit 1
PrcgCndnUsedTargetCurrency PrcgCndnUsedTargetCurrency 1
PrcgCndnUsedTargetQuantityUnit PrcgCndnUsedTargetQuantityUnit 1
PrcgConditionUsedSourceFactor PrcgConditionUsedSourceFactor 1
PrcgConditionUsedTargetFactor PrcgConditionUsedTargetFactor 1
PricingConditionForecastStatus PricingConditionForecastStatus 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 I_PRCGCNDNEXERTRMCNVRSNRESULT (
    DOCITMCMMDTYPRCGCNDNUUID,
    PRCGCONDITIONCONVERSIONPLACE,
    PRICINGCONDITIONTERM,
    PRCGCNDNCNVRSNISEXCHRATEAVG,
    PRCGCNDNCNVRSNQTYADJMTFACTOR,
    PRCGCNDNUSEDEXCHANGERATE,
    PRCGCNDNUSEDSOURCECURRENCY,
    PRCGCNDNUSEDSOURCEQUANTITYUNIT,
    PRCGCNDNUSEDTARGETCURRENCY,
    PRCGCNDNUSEDTARGETQUANTITYUNIT,
    PRCGCONDITIONUSEDSOURCEFACTOR,
    PRCGCONDITIONUSEDTARGETFACTOR,
    PRICINGCONDITIONFORECASTSTATUS,
    PRIMARY KEY (DOCITMCMMDTYPRCGCNDNUUID, PRCGCONDITIONCONVERSIONPLACE, PRICINGCONDITIONTERM)
);