FINOC_ACTIVITY

Transparent Table Application Table
17 Fields 1 CDS Views

Organizational Change: Activity

FINOC_ACTIVITY is an SAP database table in S/4HANA. Organizational Change: Activity. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OrganizationalChangeActivity view from BASIC Organizational Change Activity

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY orgl_change FINOC_ORGL_CHANGE Organizational Change
KEY activity FINOC_ACTIVITY_ID Activity ID
job_type FINOC_JOB_TYPE Job Type
jobname BTCJOB Job Name
jobcount BTCJOBCNT Job No.
jobstatus BTCSTATUS Job status
appl_log_ext_id BALNREXT External ID
appl_log_number BALOGNR Log Number
num_smsg FINOC_NUM_SMSG Number of S Messages
num_imsg FINOC_NUM_IMSG Number of I Messages
num_wmsg FINOC_NUM_WMSG Number of Warnings
num_emsg FINOC_NUM_EMSG Number of Errors
triggered_by FINOC_TRIGGERED_BY Triggered by
status_from FINOC_PROCESSING_STATUS_FROM Status before Act.
status_to FINOC_PROCESSING_STATUS_TO Status after Act.
activity_timestamp FINOC_ACTIVITY_TIMESTAMP Activity processed 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.

-- Organizational Change: Activity
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINOC_ACTIVITY (
    MANDT,               -- Client [MANDT]
    ORGL_CHANGE,         -- Organizational Change [FINOC_ORGL_CHANGE]
    ACTIVITY,            -- Activity ID [FINOC_ACTIVITY_ID]
    JOB_TYPE,            -- Job Type [FINOC_JOB_TYPE]
    JOBNAME,             -- Job Name [BTCJOB]
    JOBCOUNT,            -- Job No. [BTCJOBCNT]
    JOBSTATUS,           -- Job status [BTCSTATUS]
    APPL_LOG_EXT_ID,     -- External ID [BALNREXT]
    APPL_LOG_NUMBER,     -- Log Number [BALOGNR]
    NUM_SMSG,            -- Number of S Messages [FINOC_NUM_SMSG]
    NUM_IMSG,            -- Number of I Messages [FINOC_NUM_IMSG]
    NUM_WMSG,            -- Number of Warnings [FINOC_NUM_WMSG]
    NUM_EMSG,            -- Number of Errors [FINOC_NUM_EMSG]
    TRIGGERED_BY,        -- Triggered by [FINOC_TRIGGERED_BY]
    STATUS_FROM,         -- Status before Act. [FINOC_PROCESSING_STATUS_FROM]
    STATUS_TO,           -- Status after Act. [FINOC_PROCESSING_STATUS_TO]
    ACTIVITY_TIMESTAMP,  -- Activity processed on [FINOC_ACTIVITY_TIMESTAMP]
    PRIMARY KEY (MANDT, ORGL_CHANGE, ACTIVITY)
);

Learn More