FCC_INST_ITEM

7 Fields 3 CDS Views

FCC_INST_ITEM is an SAP database table in S/4HANA. It contains 7 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 FCC Closing Task Execution Data 3

Fields (7)

KeyField CDS FieldsUsed in Views
KEY instance ClosingTaskListInstance,instance 3
KEY item ClosingTask,item 2
KEY mandt mandt 1
KEY profile ClosingTemplate,profile 3
res_usr_id ClosingTaskResponsible 1
res_usr_type ClosingTaskResponsibleType 1
text ClosingTaskName 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FCC_INST_ITEM (
    INSTANCE,
    ITEM,
    MANDT,
    PROFILE,
    RES_USR_ID,
    RES_USR_TYPE,
    TEXT,
    PRIMARY KEY (INSTANCE, ITEM, MANDT, PROFILE)
);

Learn More