FCC_INST_ITEM

Transparent Table Application Table
64 Fields 3 CDS Views

Administration of a Job (Report/Transaction or Workflow)....

FCC_INST_ITEM is an SAP database table in S/4HANA. Administration of a Job (Report/Transaction or Workflow)..... It contains 64 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_FCC_ClosingTask view from BASIC FCC Closing Task Definition Data
I_FCC_ClosingTaskText view from BASIC Task description
P_FCC_CLOSINGTASKEXECUTION3 view from BASIC

Fields (64)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY profile FCC_PROFILE Task List
KEY instance FCC_NUM Counter
KEY node FCC_NODE Node ID
KEY item FCC_NODE Node ID
node_grp FCC_INT Node Name
pos FCC_POSITION Pos. Under Node
grp_prev FCC_INT Node Name
kind FCC_TASK_TYPE Task Type
report FCC_PROGRAMM Program
variante FCC_VARIANT Variant
sequence FCC_SEQUENCE Flow Definition
transact FCC_TRANSACTION Transaction
exe_usr FCC_TASK_OWNER Processor
res_usr FCC_TASK_RES Responsible
exe_day_offset FCC_OFFSET_REL Offset in Days
day_type FCC_DAY_TYPE Day Type
exe_time FCC_TIME Plannd Start Time
def_time_zone FCC_DEF_TIME_ZONE Def. Time Zone
inactive FCC_ACTIVE Active
locked FCC_LOCKED Lock Status
auto_var FCC_AUTO_VAR Variant Autom.
text FCC_FOLDER_TEXT Description
job FCC_JOB Task
job_id FCC_JOB_ID ID
laufzeit_d SYDATUM Current Date
laufzeit_t SYUZEIT Time
document_id BDS_DOCID Document ID
iusage FCC_USAGE Usage
test_node FCC_NODE Node ID
crit_path FCC_CRIT_PATH Critical Path
batchjob_id BTCJOB Job Name
agr_name AGR_NAME Role
comment_flag CHAR1 Single-Character Flag
sap_script_id GUID_32 GUID 16
rt_def_id FCC_RT_DEF_ID Job Def.
rt_queue FCC_RT_QUEUE Queue
notified FCC_NOTIFIED Email Notif.
start_immd FCC_START_IMMD Starts Immd.
exe_usr_id FCC_TASK_OWNER_OBJID Processor
exe_usr_type FCC_TASK_OWNER_OTYPE Processor Type
res_usr_id FCC_TASK_RES_OBJID Responsible
res_usr_type FCC_TASK_RES_OTYPE Responsible Type
task_group FCC_PROFILE_SELECT Template
tg_item FCC_NODE Node ID
authgrp FCC_AUTHGRP Authoriz. Group
global_id FCC_GLOBAL_ID Global ID
rfc_id FCC_RFC_ID Remote System
created_by UNAME User Name
created_on TIMESTAMPL Time Stamp
changed_by UNAME User Name
changed_on TIMESTAMPL Time Stamp
rj_usr FCC_REMOTE_JOB_OWNER Job Owner
rj_jobname FCC_RJ_JOBNAME Job Name
rj_creator FCC_RJ_CREATOR Job Creator
ic_sig FCC_INTERNALCONTROL_SIG Significance
ic_auto FCC_INTERNALCONTROL_AUTO Automation
ic_purp FCC_INTERNALCONTROL_PURP Purpose
closing_hier_1 FCC_CLOSING_HIERARCHY Group One
closing_hier_2 FCC_CLOSING_HIERARCHY2 Group Two
closing_hier_3 FCC_CLOSING_HIERARCHY3 Group Three
milestone FCC_MILESTONE Milestone
closing_phase FCC_CLOSING_PHASE Phase
ignore_error FCC_IGNORE_ERROR Ignore error

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.

-- Administration of a Job (Report/Transaction or Workflow)....
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCC_INST_ITEM (
    MANDT,           -- Client [MANDT]
    PROFILE,         -- Task List [FCC_PROFILE]
    INSTANCE,        -- Counter [FCC_NUM]
    NODE,            -- Node ID [FCC_NODE]
    ITEM,            -- Node ID [FCC_NODE]
    NODE_GRP,        -- Node Name [FCC_INT]
    POS,             -- Pos. Under Node [FCC_POSITION]
    GRP_PREV,        -- Node Name [FCC_INT]
    KIND,            -- Task Type [FCC_TASK_TYPE]
    REPORT,          -- Program [FCC_PROGRAMM]
    VARIANTE,        -- Variant [FCC_VARIANT]
    SEQUENCE,        -- Flow Definition [FCC_SEQUENCE]
    TRANSACT,        -- Transaction [FCC_TRANSACTION]
    EXE_USR,         -- Processor [FCC_TASK_OWNER]
    RES_USR,         -- Responsible [FCC_TASK_RES]
    EXE_DAY_OFFSET,  -- Offset in Days [FCC_OFFSET_REL]
    DAY_TYPE,        -- Day Type [FCC_DAY_TYPE]
    EXE_TIME,        -- Plannd Start Time [FCC_TIME]
    DEF_TIME_ZONE,   -- Def. Time Zone [FCC_DEF_TIME_ZONE]
    INACTIVE,        -- Active [FCC_ACTIVE]
    LOCKED,          -- Lock Status [FCC_LOCKED]
    AUTO_VAR,        -- Variant Autom. [FCC_AUTO_VAR]
    TEXT,            -- Description [FCC_FOLDER_TEXT]
    JOB,             -- Task [FCC_JOB]
    JOB_ID,          -- ID [FCC_JOB_ID]
    LAUFZEIT_D,      -- Current Date [SYDATUM]
    LAUFZEIT_T,      -- Time [SYUZEIT]
    DOCUMENT_ID,     -- Document ID [BDS_DOCID]
    IUSAGE,          -- Usage [FCC_USAGE]
    TEST_NODE,       -- Node ID [FCC_NODE]
    CRIT_PATH,       -- Critical Path [FCC_CRIT_PATH]
    BATCHJOB_ID,     -- Job Name [BTCJOB]
    AGR_NAME,        -- Role [AGR_NAME]
    COMMENT_FLAG,    -- Single-Character Flag [CHAR1]
    SAP_SCRIPT_ID,   -- GUID 16 [GUID_32]
    RT_DEF_ID,       -- Job Def. [FCC_RT_DEF_ID]
    RT_QUEUE,        -- Queue [FCC_RT_QUEUE]
    NOTIFIED,        -- Email Notif. [FCC_NOTIFIED]
    START_IMMD,      -- Starts Immd. [FCC_START_IMMD]
    EXE_USR_ID,      -- Processor [FCC_TASK_OWNER_OBJID]
    EXE_USR_TYPE,    -- Processor Type [FCC_TASK_OWNER_OTYPE]
    RES_USR_ID,      -- Responsible [FCC_TASK_RES_OBJID]
    RES_USR_TYPE,    -- Responsible Type [FCC_TASK_RES_OTYPE]
    TASK_GROUP,      -- Template [FCC_PROFILE_SELECT]
    TG_ITEM,         -- Node ID [FCC_NODE]
    AUTHGRP,         -- Authoriz. Group [FCC_AUTHGRP]
    GLOBAL_ID,       -- Global ID [FCC_GLOBAL_ID]
    RFC_ID,          -- Remote System [FCC_RFC_ID]
    CREATED_BY,      -- User Name [UNAME]
    CREATED_ON,      -- Time Stamp [TIMESTAMPL]
    CHANGED_BY,      -- User Name [UNAME]
    CHANGED_ON,      -- Time Stamp [TIMESTAMPL]
    RJ_USR,          -- Job Owner [FCC_REMOTE_JOB_OWNER]
    RJ_JOBNAME,      -- Job Name [FCC_RJ_JOBNAME]
    RJ_CREATOR,      -- Job Creator [FCC_RJ_CREATOR]
    IC_SIG,          -- Significance [FCC_INTERNALCONTROL_SIG]
    IC_AUTO,         -- Automation [FCC_INTERNALCONTROL_AUTO]
    IC_PURP,         -- Purpose [FCC_INTERNALCONTROL_PURP]
    CLOSING_HIER_1,  -- Group One [FCC_CLOSING_HIERARCHY]
    CLOSING_HIER_2,  -- Group Two [FCC_CLOSING_HIERARCHY2]
    CLOSING_HIER_3,  -- Group Three [FCC_CLOSING_HIERARCHY3]
    MILESTONE,       -- Milestone [FCC_MILESTONE]
    CLOSING_PHASE,   -- Phase [FCC_CLOSING_PHASE]
    IGNORE_ERROR,    -- Ignore error [FCC_IGNORE_ERROR]
    PRIMARY KEY (MANDT, PROFILE, INSTANCE, NODE, ITEM)
);

Learn More