FINPLAN_PCC_CE

Transparent Table Temporary Data
39 Fields 1 CDS Views

Prepared Cost Estimate Items for SAP Analytics Cloud

FINPLAN_PCC_CE is an SAP database table in S/4HANA. Prepared Cost Estimate Items for SAP Analytics Cloud. It contains 39 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_CostEstPreparedItemization view_entity from BASIC Prepared Cost Estimate Itemization

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY confid fcom_conf_id
KEY record rsarecord Data record number
reference_object ck_obj Reference Obj.
ce_number ck_kalnr1 ProdCostEst.No.
costing_type ck_kalka Costing Type
costing_date ck_kadky Costing Date
costing_version ck_tvers Costing Version
valuation_variant ck_bwvar Valuation Variant
cost_component_view ck_sicht Cost Comp. View
costing_variant ck_klvar Costing Variant
costs_entered_manually ck_kkzma Additive Costs
item_position_number ck_posnr Item Number
costing_status ck_feh_sta Costing Status
cost_component_layout ck_elesmhk Cost Comp. Str.
valuation_type bwtar_d Valuation Type
plant werks_d Plant
product fins_matnr_pa Product Sold
use_cogs_split fcom_cogs_split_is_used COGS Split is used
mat_plant werks_d Plant
material matnr Material
chart_of_accounts fis_ktopl Chart of Accounts
account fis_racct G/L Account
partner_cost_center fis_skost Partner Cost Center
partner_activity_type fis_par_lstar Partner Cost Center Activity Type
co_area fis_kokrs Controlling Area
profit_ctr fis_prctr Profit Center
compcode fis_bukrs Company Code
ledger fins_ledger Ledger
cost_component ck_element Cost Component
quantity vquan1_12 Val. quantity
base_unit_of_measure rvunit Valuation UoM
lotsize ck_losgr Cstg Lot Size
lotsizeunit fcom_lot_size_unit Lot Size Unit
fix_var_indicator fcom_fixed_variable_type Fixed Variable Type
co_area_currency_amount fis_ksl Amount in Global Currency
co_area_currency_key fis_rkcur Global Currency
ccode_currency_amount fis_hsl Amount in Company Code Currency
ccode_currency_key fis_hwaer Company Code Currency

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.

-- Prepared Cost Estimate Items for SAP Analytics Cloud
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINPLAN_PCC_CE (
    CLIENT,                   -- Client [mandt]
    CONFID,                   -- fcom_conf_id
    RECORD,                   -- Data record number [rsarecord]
    REFERENCE_OBJECT,         -- Reference Obj. [ck_obj]
    CE_NUMBER,                -- ProdCostEst.No. [ck_kalnr1]
    COSTING_TYPE,             -- Costing Type [ck_kalka]
    COSTING_DATE,             -- Costing Date [ck_kadky]
    COSTING_VERSION,          -- Costing Version [ck_tvers]
    VALUATION_VARIANT,        -- Valuation Variant [ck_bwvar]
    COST_COMPONENT_VIEW,      -- Cost Comp. View [ck_sicht]
    COSTING_VARIANT,          -- Costing Variant [ck_klvar]
    COSTS_ENTERED_MANUALLY,   -- Additive Costs [ck_kkzma]
    ITEM_POSITION_NUMBER,     -- Item Number [ck_posnr]
    COSTING_STATUS,           -- Costing Status [ck_feh_sta]
    COST_COMPONENT_LAYOUT,    -- Cost Comp. Str. [ck_elesmhk]
    VALUATION_TYPE,           -- Valuation Type [bwtar_d]
    PLANT,                    -- Plant [werks_d]
    PRODUCT,                  -- Product Sold [fins_matnr_pa]
    USE_COGS_SPLIT,           -- COGS Split is used [fcom_cogs_split_is_used]
    MAT_PLANT,                -- Plant [werks_d]
    MATERIAL,                 -- Material [matnr]
    CHART_OF_ACCOUNTS,        -- Chart of Accounts [fis_ktopl]
    ACCOUNT,                  -- G/L Account [fis_racct]
    PARTNER_COST_CENTER,      -- Partner Cost Center [fis_skost]
    PARTNER_ACTIVITY_TYPE,    -- Partner Cost Center Activity Type [fis_par_lstar]
    CO_AREA,                  -- Controlling Area [fis_kokrs]
    PROFIT_CTR,               -- Profit Center [fis_prctr]
    COMPCODE,                 -- Company Code [fis_bukrs]
    LEDGER,                   -- Ledger [fins_ledger]
    COST_COMPONENT,           -- Cost Component [ck_element]
    QUANTITY,                 -- Val. quantity [vquan1_12]
    BASE_UNIT_OF_MEASURE,     -- Valuation UoM [rvunit]
    LOTSIZE,                  -- Cstg Lot Size [ck_losgr]
    LOTSIZEUNIT,              -- Lot Size Unit [fcom_lot_size_unit]
    FIX_VAR_INDICATOR,        -- Fixed Variable Type [fcom_fixed_variable_type]
    CO_AREA_CURRENCY_AMOUNT,  -- Amount in Global Currency [fis_ksl]
    CO_AREA_CURRENCY_KEY,     -- Global Currency [fis_rkcur]
    CCODE_CURRENCY_AMOUNT,    -- Amount in Company Code Currency [fis_hsl]
    CCODE_CURRENCY_KEY,       -- Company Code Currency [fis_hwaer]
    PRIMARY KEY (CLIENT, CONFID, RECORD)
);

Learn More