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 Hstry of Mass Mntnce for SlsPrcgCndn

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 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,             -- Import Category [CNDNRECD_IMPORT_CATEGORY]
    PRIMARY KEY (MANDT, JOBUUID)
);

Learn More