CEPC_DRAFT_2

Transparent Table Application Table
45 Fields 2 CDS Views

Draft table for entity R_PROFITCENTERTP

CEPC_DRAFT_2 is an SAP database table in S/4HANA. Draft table for entity R_PROFITCENTERTP. It contains 45 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_ProfitCenterDraft view_entity from EXTENSION Profit Center - Extension
R_ProfitCenterDraft view_entity from BASIC Profit Center Draft

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY controllingarea kokrs CO Area
KEY profitcenter prctr Profit Center
KEY validityenddate datbi Valid To
KEY draftuuid sdraft_uuid Draft Document ID
validitystartdate datab Valid From
controllingareaforedit kokrs CO Area
profitcenterforedit prctr Profit Center
validityenddateforedit datbi Valid To
profitcentername fis_prctr_shorttext Profit Center Name
profitcenterlongname fac_prctr_ltext Profit Center Description
profitctrresponsiblepersonname verapc Person Respons.
profitctrresponsibleuser verapc_user User Responsible
profitcentercreationdate erfdt Entered On
profitcentercreatedbyuser erfnm Created By
profitcenterisblocked fac_mpc_lock_indicator Locked
profitcenterstandardhierarchy fac_mpc_pcg Standard Hierarchy Node
segment fb_segment Segment
profitcenterdepartment abteil Department
profitcentertitlename anred Title
addressname name1_gp Name
additionalname name2_gp Name 2
profitcenteraddrname3 name3_gp Name 3
profitcenteraddrname4 name4_gp Name 4
streetaddressname stras_gp Street
cityname ort01_gp City
postalcode pstlz Postal Code
district ort02_gp District
country fis_land1 Country/Region
region regio Region
taxjurisdiction txjcd Tax Jur.
pobox pfach PO Box
poboxpostalcode pstl2 PO Box PCode
language spras Language
phonenumber1 telf1 Telephone 1
phonenumber2 telf2 Telephone 2
faxnumber telfx Fax Number
teleboxnumber fac_mpc_comm_telbx Telebox Number
telexnumber fac_mpc_comm_telx1 Telex Number
teletexnumber fac_mpc_teltx Teletex Number
datacommunicationphonenumber fac_mpc_comm_data_line Data Line
profitcenterprintername fac_mpc_comm_printer Printer
logicalsystem logsystem Logical System
changedocobject cdobjectv Object Value
profitcentervalidondate rap_fin_prft_ctr_valid_on

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_PROFITCENTERTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CEPC_DRAFT_2 (
    MANDT,                           -- Client [mandt]
    CONTROLLINGAREA,                 -- CO Area [kokrs]
    PROFITCENTER,                    -- Profit Center [prctr]
    VALIDITYENDDATE,                 -- Valid To [datbi]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    VALIDITYSTARTDATE,               -- Valid From [datab]
    CONTROLLINGAREAFOREDIT,          -- CO Area [kokrs]
    PROFITCENTERFOREDIT,             -- Profit Center [prctr]
    VALIDITYENDDATEFOREDIT,          -- Valid To [datbi]
    PROFITCENTERNAME,                -- Profit Center Name [fis_prctr_shorttext]
    PROFITCENTERLONGNAME,            -- Profit Center Description [fac_prctr_ltext]
    PROFITCTRRESPONSIBLEPERSONNAME,  -- Person Respons. [verapc]
    PROFITCTRRESPONSIBLEUSER,        -- User Responsible [verapc_user]
    PROFITCENTERCREATIONDATE,        -- Entered On [erfdt]
    PROFITCENTERCREATEDBYUSER,       -- Created By [erfnm]
    PROFITCENTERISBLOCKED,           -- Locked [fac_mpc_lock_indicator]
    PROFITCENTERSTANDARDHIERARCHY,   -- Standard Hierarchy Node [fac_mpc_pcg]
    SEGMENT,                         -- Segment [fb_segment]
    PROFITCENTERDEPARTMENT,          -- Department [abteil]
    PROFITCENTERTITLENAME,           -- Title [anred]
    ADDRESSNAME,                     -- Name [name1_gp]
    ADDITIONALNAME,                  -- Name 2 [name2_gp]
    PROFITCENTERADDRNAME3,           -- Name 3 [name3_gp]
    PROFITCENTERADDRNAME4,           -- Name 4 [name4_gp]
    STREETADDRESSNAME,               -- Street [stras_gp]
    CITYNAME,                        -- City [ort01_gp]
    POSTALCODE,                      -- Postal Code [pstlz]
    DISTRICT,                        -- District [ort02_gp]
    COUNTRY,                         -- Country/Region [fis_land1]
    REGION,                          -- Region [regio]
    TAXJURISDICTION,                 -- Tax Jur. [txjcd]
    POBOX,                           -- PO Box [pfach]
    POBOXPOSTALCODE,                 -- PO Box PCode [pstl2]
    LANGUAGE,                        -- Language [spras]
    PHONENUMBER1,                    -- Telephone 1 [telf1]
    PHONENUMBER2,                    -- Telephone 2 [telf2]
    FAXNUMBER,                       -- Fax Number [telfx]
    TELEBOXNUMBER,                   -- Telebox Number [fac_mpc_comm_telbx]
    TELEXNUMBER,                     -- Telex Number [fac_mpc_comm_telx1]
    TELETEXNUMBER,                   -- Teletex Number [fac_mpc_teltx]
    DATACOMMUNICATIONPHONENUMBER,    -- Data Line [fac_mpc_comm_data_line]
    PROFITCENTERPRINTERNAME,         -- Printer [fac_mpc_comm_printer]
    LOGICALSYSTEM,                   -- Logical System [logsystem]
    CHANGEDOCOBJECT,                 -- Object Value [cdobjectv]
    PROFITCENTERVALIDONDATE,         -- rap_fin_prft_ctr_valid_on
    PRIMARY KEY (MANDT, CONTROLLINGAREA, PROFITCENTER, VALIDITYENDDATE, DRAFTUUID)
);

Learn More