RSPSADEL SAP table for – Delete PSA request in batch

Here we would like to draw your attention to RSPSADEL table in SAP. As we know it is being mainly used with the SAP BW-WHM (Warehouse Management in BW) component which is coming under BW module (Business Warehouse). RSPSADEL is a SAP standard transp table used for storing Delete PSA request in batch related data in SAP. It comes under the package RSSM.

SAP RSPSADEL table

Table RSPSADEL technical data

TableRSPSADEL
Data storingDelete PSA request in batch
ModuleBW
Sub ModuleBW-WHM-DST
SAP PackageRSSM
Delivery ClassL – Table for storing temporary data
ComponentSAP_BW
Table CategoryTRANSP

SAP RSPSADEL 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 RSPSADEL table.

  • ODSNAME : InfoCube
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • JOBNAME : Background job name
    Its data type is CHAR (Character String) with field length 32
  • UNAME : User Name
    Its data type is CHAR (Character String) with field length 12
  • TIMESTAMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • EVENT_ID_OK : Background Processing Event
    Its data type is CHAR (Character String) with field length 32
  • EVENT_PM_OK : Background Event Parameters (Such as, Jobname/Jobcount)
    Its data type is CHAR (Character String) with field length 64
  • EVENT_ID_ER : Background Processing Event
    Its data type is CHAR (Character String) with field length 32
  • EVENT_PM_ER : Background Event Parameters (Such as, Jobname/Jobcount)
    Its data type is CHAR (Character String) with field length 64
  • OLDER_DAYS : Natural number
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • BEFORE_DATE : Field of type DATS
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FLAG_OLDER : Single-Character Flag
    Its data type is CHAR (Character String) with field length 1
  • FLAG_BEFORE : Single-Character Flag
    Its data type is CHAR (Character String) with field length 1
  • FLAG_ONLY_SUC : Only successfully booked requests
    Its data type is CHAR (Character String) with field length 1
  • FLAG_ONLY_RED : Only requests with errors, not updated in any data target
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Start data description / Repetition period of background job
  • 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
  • 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
  • PREDJOB : Name of previous job
    Its data type is CHAR (Character String) with field length 32
  • PREDJOBCNT : Job ID
    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
  • 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
  • STARTDTTYP : Start date type ID
    Its data type is CHAR (Character String) with field length 1
  • 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
  • INSTNAME : Server name
    Its data type is CHAR (Character String) with field length 20
  • CALENDARID : Factory calendar ID for background processing
    Its data type is CHAR (Character String) with field length 2
  • 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
  • IMSTRTPOS : Flag indicating whether job can be started immediately
    Its data type is CHAR (Character String) with field length 1
  • PRDBEHAV : Period behavior of jobs on non-workdays
    Its data type is CHAR (Character String) with field length 1
  • WDAYNO : No. of workday on which a job is to start
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • WDAYCDIR : Count direction for ‘on workday’ start date of a job
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • NOTBEFORE : Planned Start Date for Background Job
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8