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 Configuration 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,                   -- Configuration ID [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