/CRYSTAL/CA_JOB SAP table for – Publishing job details

Here we would like to draw your attention to /CRYSTAL/CA_JOB table in SAP. As we know it is being mainly used with the SAP BW-BEX (Business Explorer in BW) component which is coming under BW module (Business Warehouse). /CRYSTAL/CA_JOB is a SAP standard transp table used for storing Publishing job details related data in SAP. It comes under the package /CRYSTAL/BC.

SAP /CRYSTAL/CA_JOB table

Table /CRYSTAL/CA_JOB technical data

Table/CRYSTAL/CA_JOB
Data storingPublishing job details
ModuleBW
Sub ModuleBW-BEX-ET
SAP Package/CRYSTAL/BC
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_BW
Table CategoryTRANSP

SAP /CRYSTAL/CA_JOB 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 /CRYSTAL/CA_JOB table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • JOB_ID : Numeric Character Field, Length 10
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • SYS_ID : Numeric field length 5
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • ROLE : Role Name
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • REPORTID : BW Generation tool: GUID in compressed form (CHAR25)
    Its a key field. Its data type is CHAR (Character String) with field length 25
  • OBJSTAT : Object Status
    Its data type is CHAR (Character String) with field length 3