CNDN_MJOB_HIST

Transparent Table Temporary Data
23 Fields 1 CDS Views

Pricing Condition Mass Maintenance Job History

CNDN_MJOB_HIST is an SAP database table in S/4HANA. Pricing Condition Mass Maintenance Job History. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SlsCndnMassMaintJobHist view_entity from BASIC Job History of Mass Maintenance for Conditions in Sales

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY jobuuid /bobf/uuid Key
job_name btcjob Job Name
job_count btcjobcnt Job No.
ernam ernam Created By
mass_maintenance_status cndnrecd_import_status Import Status
create_time_utc timestamp Time Stamp
planned_start_time_utc timestamp Time Stamp
error_lines int4 INT4
success_lines int4 INT4
datab kodatab Valid From
datbi kodatbi Valid To
datab_shift int2 INT2
datab_shift_unit timeunit Time unit
datbi_shift int2 INT2
datbi_shift_unit timeunit Time unit
kbetr_amount vfprc_element_amount Amount
konwa_amount konwa Cond. Currency
kbetr_ratio vfprc_element_ratio Ratio
konwa_ratio msehiunit Unit of Measure
kproae kproae Percentage
krund krund Rounding rule
job_category cndnrecd_import_category

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.

-- Pricing Condition Mass Maintenance Job History
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CNDN_MJOB_HIST (
    MANDT,                    -- Client [mandt]
    JOBUUID,                  -- Key [/bobf/uuid]
    JOB_NAME,                 -- Job Name [btcjob]
    JOB_COUNT,                -- Job No. [btcjobcnt]
    ERNAM,                    -- Created By [ernam]
    MASS_MAINTENANCE_STATUS,  -- Import Status [cndnrecd_import_status]
    CREATE_TIME_UTC,          -- Time Stamp [timestamp]
    PLANNED_START_TIME_UTC,   -- Time Stamp [timestamp]
    ERROR_LINES,              -- INT4 [int4]
    SUCCESS_LINES,            -- INT4 [int4]
    DATAB,                    -- Valid From [kodatab]
    DATBI,                    -- Valid To [kodatbi]
    DATAB_SHIFT,              -- INT2 [int2]
    DATAB_SHIFT_UNIT,         -- Time unit [timeunit]
    DATBI_SHIFT,              -- INT2 [int2]
    DATBI_SHIFT_UNIT,         -- Time unit [timeunit]
    KBETR_AMOUNT,             -- Amount [vfprc_element_amount]
    KONWA_AMOUNT,             -- Cond. Currency [konwa]
    KBETR_RATIO,              -- Ratio [vfprc_element_ratio]
    KONWA_RATIO,              -- Unit of Measure [msehiunit]
    KPROAE,                   -- Percentage [kproae]
    KRUND,                    -- Rounding rule [krund]
    JOB_CATEGORY,             -- cndnrecd_import_category
    PRIMARY KEY (MANDT, JOBUUID)
);

Learn More