1. SAP Tutorial
  2. Oil & Gas

OIUP_PDM_JOBS SAP table for – PDM: Job Data

Here we would like to draw your attention to OIUP_PDM_JOBS table in SAP. As we know it is being mainly used with the SAP IS-OIL-PRA (Production and Revenue Accounting in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIUP_PDM_JOBS is a SAP standard transp table used for storing PDM: Job Data related data in SAP. It comes under the package OIU_P.

SAP OIUP_PDM_JOBS table

Table OIUP_PDM_JOBS technical data

TableOIUP_PDM_JOBS
Data storingPDM: Job Data
ModuleIS-OIL
Sub ModuleIS-OIL-PRA
SAP PackageOIU_P
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUP_PDM_JOBS Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIUP_PDM_JOBS table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • JOBNAME : Background job name
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • JOBCOUNT : Job ID
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • JOBGROUP : Summary of jobs for a group
    Its data type is CHAR (Character String) with field length 12
  • INTREPORT : Name of internal report for batch job
    Its data type is CHAR (Character String) with field length 40
  • STEPCOUNT : Job step ID number.
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • SDLSTRTDT : Planned Start Date for Background Job
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SDLSTRTTM : Planned start time for background Job
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • BTCSYSTEM : Target System to Run Background Job
    Its data type is CHAR (Character String) with field length 32
  • SDLDATE : Date of job/step scheduling
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SDLTIME : Time of a scheduled job/step
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • SDLUNAME : Initiator of job/step scheduling
    Its data type is CHAR (Character String) with field length 12
  • LASTCHDATE : Date of last job change
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LASTCHTIME : Time of last job change
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • LASTCHNAME : Last job change made by
    Its data type is CHAR (Character String) with field length 12
  • RELDATE : Release Date for Background Scheduling
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RELTIME : Release time of scheduled background job
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RELUNAME : User that released scheduled batch job
    Its data type is CHAR (Character String) with field length 12
  • STRTDATE : Job start date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • STRTTIME : Batch job start time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ENDDATE : Job start date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ENDTIME : Batch job start time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • PRDMINS : Duration period (in minutes) for a batch job
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • PRDHOURS : Duration period (in hours) for a batch job
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • PRDDAYS : Duration (in days) of DBA action
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • PRDWEEKS : Duration period (in weeks) for a batch job
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • PRDMONTHS : Duration period (in months) for a batch job
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • PERIODIC : Periodic Jobs Indicator
    Its data type is CHAR (Character String) with field length 1
  • DELANFREP : Job deletion indicator after processing
    Its data type is CHAR (Character String) with field length 1
  • EMERGMODE : Emergency Job operation indicator (content ‘X’)
    Its data type is CHAR (Character String) with field length 1
  • STATUS : Background Job Status
    Its data type is CHAR (Character String) with field length 1
  • NEWFLAG : New job ID creation flag
    Its data type is CHAR (Character String) with field length 1
  • AUTHCKNAM : Background User Name for Authorization Check
    Its data type is CHAR (Character String) with field length 12
  • AUTHCKMAN : Background client for authorization check
    Its data type is CLNT (Character with length 3) with field length 3
  • SUCCNUM : Number of successor job(s)
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • PREDNUM : Number of previous jobs
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • JOBLOG : TemSe object name
    Its data type is CHAR (Character String) with field length 20
  • LASTSTRTDT : Latest Execution Date for a Background Job
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LASTSTRTTM : Latest Execution Time for Background Job
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • WPNUMBER : Work process number
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • WPPROCID : Work process ID
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • EVENTID : Background Processing Event
    Its data type is CHAR (Character String) with field length 32
  • EVENTPARM : Background Event Parameters (Such as, Jobname/Jobcount)
    Its data type is CHAR (Character String) with field length 64
  • BTCSYSREAX : Target System to Run Background Job
    Its data type is CHAR (Character String) with field length 32
  • JOBCLASS : Job classification
    Its data type is CHAR (Character String) with field length 1
  • PRIORITY : Job priority
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • EVENTCOUNT : Event number
    Its data type is CHAR (Character String) with field length 8
  • CHECKSTAT : Job status check indicator for subsequent job start
    Its data type is CHAR (Character String) with field length 1
  • CALENDARID : Factory calendar ID for background processing
    Its data type is CHAR (Character String) with field length 2
  • PRDBEHAV : Period behavior of jobs on non-workdays
    Its data type is CHAR (Character String) with field length 1
  • EXECSERVER : Server name
    Its data type is CHAR (Character String) with field length 20
  • EOMCORRECT : Correction field for calc. job execution (end-of-mth, cal.)
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • CALCORRECT : Correction field for calc. job execution (end-of-mth, cal.)
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • REAXSERVER : Server name
    Its data type is CHAR (Character String) with field length 20
  • RECLOGSYS : Logical system
    Its data type is CHAR (Character String) with field length 10
  • RECOBJTYPE : Object Type
    Its data type is CHAR (Character String) with field length 10
  • RECOBJKEY : Object key
    Its data type is CHAR (Character String) with field length 70
  • RECDESCRIB : Describe flag
    Its data type is CHAR (Character String) with field length 10
  • TGTSRVGRP : Server Group Name Background Processing
    Its data type is CHAR (Character String) with field length 40

    • OIUP_PDM_JOBS related tables

    • OIUP_SB_RNEWC : Residue and NGL entitlements at a WC level (PDM Shadow)
    • OIUP_EXE_GRP_T : PDM: Table Groups Description (Workbench Execution)
    • OIUPH_RV_RJE : Journal Entry (PDM Shadow)
    • OIUP_RFCDEST_TX : PDM – Valid RFC Destinations
    • OIUP_PR_WCTST : Well Test (PDM Shadow)
    • OIUP_DBCON : PDM – Valid DB Connections
    • OIUP_PDM_CONFIG : PDM Customer Configuration
    • OIUP_PDM_MONTHS : PDM: Set number of storage months by Box/Table
    • OIUP_SB_ACTMP : Actual Owner Level CA results at MP’s (PDM Shadow)
    • OIUP_REPLACEMENT : PDM – Replacement Includes
    • OIUP_APP_AREA_TX : PDM – Application Area Description
    • OIUP_PDM_JOBS : PDM: Job Data
    • OIUP_PDM_ON : PDM – Customer Configuration To Enable Specific PDM Tables
    • OIUP_PDM_ENAB_TX : PDM – Table Descriptions
    • OIUP_RFCDEST : PDM – Valid RFC Destinations
    • OIUP_EXE_GRP : PDM: Table Groups (Workbench Execution)
    • OIUP_SYNCED_TABS : PDM – Synchronized Tables – Which Are GUARANTEED To Be Equal
    • OIUP_PR_MPVL : PRA: Measurement Point Volumetric Data (PDM Shadow)
    • OIUP_DBCON_TX : PDM – Valid DB Connection Descriptions
    • OIUP_AREA_CUST : PDM – Application Area Specific Customer Customizing

    OIUP_PDM_JOBS related transaction codes under SAP package OIU_P

    • O3UP_ADMIN_WORKBENCH : PDM Administrators’ Workbench
    • O5UP_SET_MONTHS : Set Data Retention Periods

    Related References

    Related Tutorials

    OIUP_PDM_STATS SAP table for – PDM: Statistical details per table on PDM split jobs

    OIUP_PDM_STATS table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUP_PDM_ON SAP table for – PDM – Customer Configuration To Enable Specific PDM Tables

    OIUP_PDM_ON table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUP_PDM_ENABLED SAP table for – PDM Enabled Tables

    OIUP_PDM_ENABLED table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUP_RET_ASSIGN SAP table for – PDM – Group Assignment for Retention Period

    OIUP_RET_ASSIGN table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUP_CFG_LEVEL SAP table for – PDM – Customer Config for Level of Retention

    OIUP_CFG_LEVEL table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUP_DBCON SAP table for – PDM – Valid DB Connections

    OIUP_DBCON table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUP_SYNCED_TABS SAP table for – PDM – Synchronized Tables – Which Are GUARANTEED To Be Equal

    OIUP_SYNCED_TABS table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    «
    »