FAC_OPP_JOB

Transparent Table Application Table
32 Fields 1 CDS Views

Updating Records for Posting Period Job

FAC_OPP_JOB is an SAP database table in S/4HANA. Updating Records for Posting Period Job. It contains 32 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
Fac_Opp_Cds_Scheduled_Job view from CDS View For Scheduled Jobs

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY rrcty rrcty Record Type
KEY opvar opvar Pstg Per.Var.
KEY mkoar fac_opp_account_type Account Type
KEY bkont bkont_001b To Account
KEY job_run_time fac_opp_job_run_time Next Execution Time
KEY time_period fac_opp_time_period Period - O/S/C
schedule_id fac_opp_schedule_id Schedule ID
vkont vkont_001b From Account
periv periv FY Variant
anzbp anzbp Posting Period
anzsp anzsp Special Periods
periodic_action fac_opp_periodic_action Action
job_type fac_opp_job_type Job Type
job_name btcjob Job Name
job_count btcjobcnt Job No.
frpe_next fac_opp_job_from_period From Period
tope_next fac_opp_job_to_period To Period
frye_next fac_opp_job_from_year From Year
toye_next fac_opp_job_to_year To Year
auth_group fac_opp_auth_group Authorization Group
action_auth_group fac_opp_action_auth_group Action on Auth Group
sched_start_time fac_opp_job_start_time Start time of schedu
sched_time_zone fac_opp_job_time_zone Time Zone
onetime_start_date fac_opp_job_start_date Start date of schedu
periodic_offset_way fac_opp_periodic_offset_way Offset
periodic_offset_days fac_opp_periodic_offset_days Offset Days of the p
periodic_start_year fac_opp_periodic_start_year Start year of Period
periodic_for_period fac_opp_periodic_for_period For Period
factory_calendar fac_opp_factory_calendar Factory Calendar
create_by fac_opp_create_by Create By
create_at fac_opp_create_at Create At

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.

-- Updating Records for Posting Period Job
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAC_OPP_JOB (
    MANDT,                 -- Client [mandt]
    RRCTY,                 -- Record Type [rrcty]
    OPVAR,                 -- Pstg Per.Var. [opvar]
    MKOAR,                 -- Account Type [fac_opp_account_type]
    BKONT,                 -- To Account [bkont_001b]
    JOB_RUN_TIME,          -- Next Execution Time [fac_opp_job_run_time]
    TIME_PERIOD,           -- Period - O/S/C [fac_opp_time_period]
    SCHEDULE_ID,           -- Schedule ID [fac_opp_schedule_id]
    VKONT,                 -- From Account [vkont_001b]
    PERIV,                 -- FY Variant [periv]
    ANZBP,                 -- Posting Period [anzbp]
    ANZSP,                 -- Special Periods [anzsp]
    PERIODIC_ACTION,       -- Action [fac_opp_periodic_action]
    JOB_TYPE,              -- Job Type [fac_opp_job_type]
    JOB_NAME,              -- Job Name [btcjob]
    JOB_COUNT,             -- Job No. [btcjobcnt]
    FRPE_NEXT,             -- From Period [fac_opp_job_from_period]
    TOPE_NEXT,             -- To Period [fac_opp_job_to_period]
    FRYE_NEXT,             -- From Year [fac_opp_job_from_year]
    TOYE_NEXT,             -- To Year [fac_opp_job_to_year]
    AUTH_GROUP,            -- Authorization Group [fac_opp_auth_group]
    ACTION_AUTH_GROUP,     -- Action on Auth Group [fac_opp_action_auth_group]
    SCHED_START_TIME,      -- Start time of schedu [fac_opp_job_start_time]
    SCHED_TIME_ZONE,       -- Time Zone [fac_opp_job_time_zone]
    ONETIME_START_DATE,    -- Start date of schedu [fac_opp_job_start_date]
    PERIODIC_OFFSET_WAY,   -- Offset [fac_opp_periodic_offset_way]
    PERIODIC_OFFSET_DAYS,  -- Offset Days of the p [fac_opp_periodic_offset_days]
    PERIODIC_START_YEAR,   -- Start year of Period [fac_opp_periodic_start_year]
    PERIODIC_FOR_PERIOD,   -- For Period [fac_opp_periodic_for_period]
    FACTORY_CALENDAR,      -- Factory Calendar [fac_opp_factory_calendar]
    CREATE_BY,             -- Create By [fac_opp_create_by]
    CREATE_AT,             -- Create At [fac_opp_create_at]
    PRIMARY KEY (MANDT, RRCTY, OPVAR, MKOAR, BKONT, JOB_RUN_TIME, TIME_PERIOD)
);

Learn More