CPE_FORMCONV

Transparent Table Application Table
38 Fields 1 CDS Views

CPE Formula Conversion

CPE_FORMCONV is an SAP database table in S/4HANA. CPE Formula Conversion. It contains 38 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CmmdtyPrcgCndnFmlaConversion view_entity from BASIC CPE Condition Formula Conversion

Fields (38)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY docitemcond_guid cpet_docitemcond_guid Doc. Cond. Item GUID
KEY convplace cpet_convplace Conv. Place
KEY formid cpet_formid Formula Key
KEY currfrom cpet_currfrom Curr:Conv. from
KEY uomfrom cpet_uomfrom UoM: Conv. from
KEY currto cpet_currto Curr.: Conv. to
KEY uomto cpet_uomto UoM: Conv. to
usedexchrate cpet_usedexchrate Conv.:Ex.Rate
usedcurrfrom cpet_currfrom Curr:Conv. from
usedcurrto cpet_currto Curr.: Conv. to
usedfactorfrom cpet_usedfactorfrom Conv:FromFactor
usedfactorfrom_df34 cpet_usedfactorfrom_df34 Conv:FromFactor
useduomfrom cpet_uomfrom UoM: Conv. from
usedfactorto cpet_usedfactorto Conv:To-Factor
usedfactorto_df34 cpet_usedfactorto_df34 Conv:To-Factor
useduomto cpet_uomto UoM: Conv. to
forecast_status cpet_forecast_status Forecast Status
quan_adj_factor cpet_quan_adjustment_factor Qty. Adj. Factor
formconvout_guid cpet_formconvout_guid ConvOut:Formula
formconvin_guid cpet_formconvin_guid ConvInp:Formula
conversionrule cpet_conversionrule Conv. Rule
fixexchrate cpet_fixexchrate Fix.Exch.Rate
factorfrom cpet_factorfrom From-Fctr Conv.
factorto cpet_factorto To-Fctr Conv.
conversionrout cpet_conversionrout Conv. Routine
exchratetype kurst_curr Exch. Rate Type
exchrateavg cpet_exchrateavg Ex.Rate Avging
convround cpet_round_conv Round Rule Curr
quanconvrule cpet_quanconvrule Quantity Conv. Rule
roundrout_cr cpet_roundrout_conv Rnd.Routine for Curr
numdecs_cr cpet_numdecs_conv Dec. Plcs. conv curr
numtens_cr cpet_numtens_conv Predec. Rnd. Curr.
quanconvrout cpet_quanconvrout Qty Conv. Rtine
quanconvround cpet_round_quan Round Rule Qty
roundrout_qcr cpet_roundrout_quan Rnd.Routine for Qty
numdecs_qcr cpet_numdecs_quan Dec. Plcs. convt Qty
numtens_qcr cpet_numtens_quan Predec. Rnd. Qty.

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 Formula Conversion
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CPE_FORMCONV (
    CLIENT,               -- Client [mandt]
    DOCITEMCOND_GUID,     -- Doc. Cond. Item GUID [cpet_docitemcond_guid]
    CONVPLACE,            -- Conv. Place [cpet_convplace]
    FORMID,               -- Formula Key [cpet_formid]
    CURRFROM,             -- Curr:Conv. from [cpet_currfrom]
    UOMFROM,              -- UoM: Conv. from [cpet_uomfrom]
    CURRTO,               -- Curr.: Conv. to [cpet_currto]
    UOMTO,                -- UoM: Conv. to [cpet_uomto]
    USEDEXCHRATE,         -- Conv.:Ex.Rate [cpet_usedexchrate]
    USEDCURRFROM,         -- Curr:Conv. from [cpet_currfrom]
    USEDCURRTO,           -- Curr.: Conv. to [cpet_currto]
    USEDFACTORFROM,       -- Conv:FromFactor [cpet_usedfactorfrom]
    USEDFACTORFROM_DF34,  -- Conv:FromFactor [cpet_usedfactorfrom_df34]
    USEDUOMFROM,          -- UoM: Conv. from [cpet_uomfrom]
    USEDFACTORTO,         -- Conv:To-Factor [cpet_usedfactorto]
    USEDFACTORTO_DF34,    -- Conv:To-Factor [cpet_usedfactorto_df34]
    USEDUOMTO,            -- UoM: Conv. to [cpet_uomto]
    FORECAST_STATUS,      -- Forecast Status [cpet_forecast_status]
    QUAN_ADJ_FACTOR,      -- Qty. Adj. Factor [cpet_quan_adjustment_factor]
    FORMCONVOUT_GUID,     -- ConvOut:Formula [cpet_formconvout_guid]
    FORMCONVIN_GUID,      -- ConvInp:Formula [cpet_formconvin_guid]
    CONVERSIONRULE,       -- Conv. Rule [cpet_conversionrule]
    FIXEXCHRATE,          -- Fix.Exch.Rate [cpet_fixexchrate]
    FACTORFROM,           -- From-Fctr Conv. [cpet_factorfrom]
    FACTORTO,             -- To-Fctr Conv. [cpet_factorto]
    CONVERSIONROUT,       -- Conv. Routine [cpet_conversionrout]
    EXCHRATETYPE,         -- Exch. Rate Type [kurst_curr]
    EXCHRATEAVG,          -- Ex.Rate Avging [cpet_exchrateavg]
    CONVROUND,            -- Round Rule Curr [cpet_round_conv]
    QUANCONVRULE,         -- Quantity Conv. Rule [cpet_quanconvrule]
    ROUNDROUT_CR,         -- Rnd.Routine for Curr [cpet_roundrout_conv]
    NUMDECS_CR,           -- Dec. Plcs. conv curr [cpet_numdecs_conv]
    NUMTENS_CR,           -- Predec. Rnd. Curr. [cpet_numtens_conv]
    QUANCONVROUT,         -- Qty Conv. Rtine [cpet_quanconvrout]
    QUANCONVROUND,        -- Round Rule Qty [cpet_round_quan]
    ROUNDROUT_QCR,        -- Rnd.Routine for Qty [cpet_roundrout_quan]
    NUMDECS_QCR,          -- Dec. Plcs. convt Qty [cpet_numdecs_quan]
    NUMTENS_QCR,          -- Predec. Rnd. Qty. [cpet_numtens_quan]
    PRIMARY KEY (CLIENT, DOCITEMCOND_GUID, CONVPLACE, FORMID, CURRFROM, UOMFROM, CURRTO, UOMTO)
);

Learn More