CSKS_DRAFT_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.

-- Draft table for entity R_COSTCENTERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CSKS_DRAFT_2 (
    MANDT,                           -- Client [mandt]
    CONTROLLINGAREA,                 -- CO Area [kokrs]
    COSTCENTER,                      -- Cost Center [kostl]
    VALIDITYENDDATE,                 -- Valid To [datbi]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    VALIDITYSTARTDATE,               -- Valid From [datab]
    CONTROLLINGAREAFOREDIT,          -- CO Area [kokrs]
    COSTCENTERFOREDIT,               -- Cost Center [kostl]
    VALIDITYENDDATEFOREDIT,          -- Valid To [datbi]
    COSTCENTERNAME,                  -- Cost Center Name [fis_kostl_name]
    COSTCENTERDESCRIPTION,           -- Cost Center Desc. [fis_kostl_ltext]
    ISBLKDFORPRIMARYCOSTSPOSTING,    -- Lock Primary Costs Posting [fis_cc_bkzkp]
    ISBLOCKEDFORPLANPRIMARYCOSTS,    -- Lock Primary Costs Planning [fis_cc_pkzkp]
    COMPANYCODE,                     -- Company Code [bukrs]
    BUSINESSAREA,                    -- Business Area [gsber]
    COSTCENTERCATEGORY,              -- CCtr Category [kosar]
    COSTCTRRESPONSIBLEPERSONNAME,    -- Person Resp. [verak]
    COSTCTRRESPONSIBLEUSER,          -- User Responsible [verak_user]
    COSTCENTERCURRENCY,              -- Currency [waers]
    COSTINGSHEET,                    -- Costing Sheet [aufkalsm]
    TAXJURISDICTION,                 -- Tax Jur. [txjcd]
    PROFITCENTER,                    -- Profit Center [prctr]
    PLANT,                           -- Plant [werks_d]
    LOGICALSYSTEM,                   -- Logical System [logsystem]
    COSTCENTERCREATIONDATE,          -- Created On [fis_cc_erfdt]
    COSTCENTERCREATEDBYUSER,         -- Created By [fis_cc_erfnm]
    ISBLKDFORSECONDARYCOSTSPOSTING,  -- Lock Secondary Costs Posting [fis_cc_bkzks]
    ISBLOCKEDFORREVENUEPOSTING,      -- Lock Revenue Posting [fis_cc_bkzer]
    ISBLOCKEDFORCOMMITMENTPOSTING,   -- Lock Commitment Updates [fis_cc_bkzob]
    ISBLOCKEDFORPLANSECONDARYCOSTS,  -- Lock Secondary Costs Planning [fis_cc_pkzks]
    ISBLOCKEDFORPLANREVENUES,        -- Lock Revenue Planning [fis_cc_pkzer]
    COSTCENTERALLOCATIONMETHOD,      -- Alloc. Methods [vmeth]
    CONSUMPTIONQTYISRECORDED,        -- Record Quantity [mgefl]
    DEPARTMENT,                      -- Department [abtei]
    SUBSEQUENTCOSTCENTER,            -- Subseq.CCtr [nkost]
    CONDITIONUSAGE,                  -- Usage [kvewe]
    CONDITIONAPPLICATION,            -- Application [kappl]
    COSTCENTERACCOUNTINGOVERHEAD,    -- Overhead Key [koszschl]
    COUNTRY,                         -- Country/Region [fis_land1]
    FORMOFADDRESS,                   -- Title [anred]
    ADDRESSNAME,                     -- Address Name [fco_cc_addressname]
    ADDRESSADDITIONALNAME,           -- Name 2 [name2_gp]
    COSTCENTERADDRNAME3,             -- Name 3 [name3_gp]
    COSTCENTERADDRNAME4,             -- Name 4 [name4_gp]
    CITYNAME,                        -- City [ort01_gp]
    DISTRICT,                        -- District [ort02_gp]
    STREETADDRESSNAME,               -- Street [stras_gp]
    POBOX,                           -- PO Box [pfach]
    POSTALCODE,                      -- Postal Code [pstlz]
    POBOXPOSTALCODE,                 -- PO Box PCode [pstl2]
    REGION,                          -- Region [regio]
    LANGUAGE,                        -- Language [spras]
    TELEBOXNUMBER,                   -- Telebox [telbx]
    PHONENUMBER1,                    -- Phone [fco_cc_telf1]
    PHONENUMBER2,                    -- Telephone 2 [telf2]
    FAXNUMBER,                       -- Fax Number [telfx]
    TELETEXNUMBER,                   -- Teletex [teltx]
    TELEXNUMBER,                     -- Telex [telx1]
    DATACOMMUNICATIONPHONENUMBER,    -- Data line [datlt]
    COSTCENTERPRINTERDESTINATION,    -- Printer Destination [fis_kdnam]
    COSTCENTERSTANDARDHIERAREA,      -- Standard Hierarchy Node [fco_cc_khinr]
    COSTCOLLECTOR,                   -- Cost Collector [cckey]
    COSTCENTERISCOMPLETE,            -- Complete [kskom]
    ISSTATISTICALCOSTCENTER,         -- Cost Center Is Stat. [fins_xkostl_stat]
    OBJECTINTERNALID,                -- Object number [j_objnr]
    COSTCENTERFUNCTION,              -- Function [funkt_dlk]
    COSTCENTERALTERNATIVEFUNCTION,   -- Alt. Function [afunk_dlk]
    FUNCTIONALAREA,                  -- Functional Area [fkber]
    ACTYINDEPFORMULAPLANNINGTMPL,    -- Act. Indep. Formula Planning Template [fco_cca_templ_cpi]
    ACTYDEPDNTFORMULAPLANNINGTMPL,   -- Act. Depen. Formula Planning Template [fco_cca_templ_cpd]
    ACTYINDEPENDENTALLOCATIONTMPL,   -- Activity Independent Allocation Template [fco_cca_templ_sci]
    ACTYDEPENDENTALLOCATIONTMPL,     -- Activity Dependent Allocation Template [fco_cca_templ_scd]
    ACTLINDEPSTATISTICALKEYFIGURES,  -- Act. Indep. Statistical Key Figure Tmp. [fco_cca_templ_ski]
    ACTLDEPSTATISTICALKEYFIGURES,    -- Act. Dep. Statistical Key Figure Tmp. [fco_cca_templ_skd]
    JOINTVENTURE,                    -- Joint venture [jv_name]
    JOINTVENTURERECOVERYCODE,        -- Recovery Ind. [jv_recind]
    JOINTVENTUREEQUITYTYPE,          -- Equity Type [jv_etype]
    JOINTVENTUREOBJECTTYPE,          -- JV Object Type [jv_otype]
    JOINTVENTURECLASS,               -- JIB/JIBE Class [jv_jibcl]
    JOINTVENTURESUBCLASS,            -- JIB/JIBE SbClsA [jv_jibsa]
    BUDGETCARRYINGCOSTCENTER,        -- Budget-Carrying Cost Center [fco_budgetcarryingcostcenter]
    AVAILABILITYCONTROLPROFILE,      -- Budget Availability Control Profile [fco_budgetavailabilityctrlprof]
    AVAILABILITYCONTROLISACTIVE,     -- Budget Availability Control is Active [fco_availabilityctrlprofisact]
    FUND,                            -- Fund [bp_geber]
    GRANTID,                         -- Grant [gm_grant_nbr]
    FUNDISFIXASSIGNED,               -- Fund Fixed Assignment [psm_fund_fix_assigned]
    GRANTIDISFIXASSIGNED,            -- Grant Fixed Assignment [psm_grant_fix_assigned]
    FUNCTIONALAREAISFIXASSIGNED,     -- Functional Area Fixed Assignment [psm_func_area_fix_assigned]
    FINANCIALMANAGEMENTAREA,         -- FM Area [fikrs]
    COSTCENTERISBUDGETCARRYING,      -- Is Budget Carrying [fco_costcenterisbudgetcarrying]
    CHANGEDOCOBJECT,                 -- Object Value [cdobjectv]
    COSTCENTERVALIDONDATE,           -- Valid On [fco_valid_on]
    COSTCENTERLASTCHANGEDBYUSER,     -- fco_last_changed_by
    COSTCENTERLASTCHANGEDONDATE,     -- fco_last_changed_on
    COSTCENTERLASTCHANGEDATTIME,     -- fco_last_changed_at
    COSTCENTERCREATIONDATETIME,      -- abap.dec
    COSTCENTERLASTCHANGEDDATETIME,   -- abap.dec
    COSTCENTERCREATIONTIME,          -- fco_created_at
    PRIMARY KEY (MANDT, CONTROLLINGAREA, COSTCENTER, VALIDITYENDDATE, DRAFTUUID)
);