FINOC_ORGLCHG

Transparent Table Application Table
15 Fields 35 CDS Views

Organizational Change

FINOC_ORGLCHG is an SAP database table in S/4HANA. Organizational Change. It contains 15 fields. 35 CDS views read from this table.

CDS Views using this table (35)

ViewTypeJoinVDMDescription
E_OrganizationalChange view_entity from EXTENSION Extension View for Organizational Change
FINOC_CHECK_REC_02_ALL_TO_REC view_entity from Org. Change: From All to RE Contract
FINOC_CHECK_REC_02_ALL_TO_REC view_entity union Org. Change: From All to RE Contract
FINOC_CHECK_REC_02_REC_TO_ALL view_entity from Org. Change: From RE Contract to All
finoc_orglchg_date_status_buf view from Orgl Change: Buffered Date and Status
FINOC_RT_CCR_OPEN_ORGL view inner Orgl Change: Fill RT Cost Center (Hist.)
FINOC_RT_DLV_OPEN_ORGL view_entity inner Org Change: Fill RT DLV Item (Hist.)
FINOC_RT_FA_OPEN_ORGL view_entity inner Orgl Change: Fill RT FA (Hist.)
FINOC_RT_MAT_OPEN_ORGL view inner Orgl Change: Fill RT Material (Hist.)
FINOC_RT_NWA_OPEN_ORGL view inner Orgl Change: Fill RT Netw.Act. (Hist.)
FINOC_RT_OI_OPEN_ORGL view inner Orgl Change: Fill RT Open Items (Hist.)
FINOC_RT_ORD_OPEN_ORGL view inner Orgl Change: Fill RT Order (Hist.)
FINOC_RT_PC_OPEN_ORGL view_entity inner Orgl Change: Fill RT Prft Center (Hist.)
FINOC_RT_POI_OPEN_ORGL view_entity inner Orgl Change: Fill RT POI (Hist.)
FINOC_RT_PRO_OPEN_ORGL view inner Orgl Change: Fill RT PRO (Hist.)
FINOC_RT_RAR_OPEN_ORGL view_entity inner Org Change: Fill RT RAR (Hist.)
FINOC_RT_REC_FILL view_entity inner OrglChg: Fill RT for Real Estate Contr.
FINOC_RT_REC_FILL_ACCTOBJ view_entity inner Orgl Change: RE Contr. Val. Terms w/ OC
FINOC_RT_REC_OPEN_ORGL view_entity inner Orgl Change: Fill RT Order (Hist.)
FINOC_RT_SOI_OPEN_ORGL view inner Orgl Change: Fill RT Sales Doc (Hist.)
FINOC_RT_SOX_OPEN_ORGL view inner Orgl Change: Fill RT IC SOI (Hist.)
FINOC_RT_SRV_OPEN_ORGL view_entity inner Orgl Change: Fill RT SRV (Hist.)
FINOC_RT_WBS_OPEN_ORGL view inner Orgl Change: Fill RT WBS (Hist.)
FINOC_RULE_MAT_BASE view inner Orgl Change-Rule: Materials Base
FINOC_RULE_NWA_BASE view inner O/C Rule: Network Activity Base
FINOC_RULE_OI view inner OrgChange-Rule: Non-Assigned Open Items
FINOC_RULE_ORD_BASE view inner Orgl Change-Rule: Order Base
FINOC_RULE_PRO_BASE view inner Organizational Change: Base Rule Project
FINOC_RULE_SOX_BASE view inner Organizational Changes: Base Rle IC SOI
FINOC_RULE_SOX_EXAMPLE view inner Organizational Changes: Exmpl Rle IC SOI
FINOC_RULE_SRV_BASE view_entity inner Orgl Change-Rule: Service Doc Item Base
FINOC_RULE_WBS_BASE view inner Orgl Change-Rule: WBS Elements Base
FINOC_RULE_WBS_DEFAULT_CE view inner OC: Default Rule WBS elmts, EPPM wR CE
I_OrganizationalChange view from BASIC Organizational Change
I_OrganizationalChangeVH view from BASIC Organizational Change

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY orgl_change FINOC_ORGL_CHANGE Organizational Change
effective_date FINOC_EFFECTIVE_DATE Effective Date
processing_status FINOC_PROCESSING_STATUS Orgl Change Status
last_activity FINOC_ACTIVITY_ID Activity ID
appl_version FINOC_APPL_VERSION Application Version
creation_timestamp FINOC_CREATION_TIMESTAMP Creation Timestamp
created_by_user FINOC_CREATED_BY_USER Created by
last_change_timestamp FINOC_LAST_CHANGE_TIMESTAMP Last Chg Timestamp
last_changed_by_user FINOC_LAST_CHANGED_BY_USER Last Changed by
dummy_finoc_och_incl_eew_ps CFD_DUMMY Dummy
next_open_period FINOC_NEXT_OPEN_PERIOD Transfer posting in next open period
next_open_period_by FINOC_NEXT_OPEN_PERIOD_BY Next Open Period Set by User
next_open_period_on FINOC_NEXT_OPEN_PERIOD_ON Next Open Period Set On
xarch FINOC_XARCHIVED OrglChange archived

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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINOC_ORGLCHG (
    MANDT,                        -- Client [MANDT]
    ORGL_CHANGE,                  -- Organizational Change [FINOC_ORGL_CHANGE]
    EFFECTIVE_DATE,               -- Effective Date [FINOC_EFFECTIVE_DATE]
    PROCESSING_STATUS,            -- Orgl Change Status [FINOC_PROCESSING_STATUS]
    LAST_ACTIVITY,                -- Activity ID [FINOC_ACTIVITY_ID]
    APPL_VERSION,                 -- Application Version [FINOC_APPL_VERSION]
    CREATION_TIMESTAMP,           -- Creation Timestamp [FINOC_CREATION_TIMESTAMP]
    CREATED_BY_USER,              -- Created by [FINOC_CREATED_BY_USER]
    LAST_CHANGE_TIMESTAMP,        -- Last Chg Timestamp [FINOC_LAST_CHANGE_TIMESTAMP]
    LAST_CHANGED_BY_USER,         -- Last Changed by [FINOC_LAST_CHANGED_BY_USER]
    DUMMY_FINOC_OCH_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    NEXT_OPEN_PERIOD,             -- Transfer posting in next open period [FINOC_NEXT_OPEN_PERIOD]
    NEXT_OPEN_PERIOD_BY,          -- Next Open Period Set by User [FINOC_NEXT_OPEN_PERIOD_BY]
    NEXT_OPEN_PERIOD_ON,          -- Next Open Period Set On [FINOC_NEXT_OPEN_PERIOD_ON]
    XARCH,                        -- OrglChange archived [FINOC_XARCHIVED]
    PRIMARY KEY (MANDT, ORGL_CHANGE)
);

Learn More