OIRA_AGGSCHDEF SAP table for – Pre-aggregation schema definition parameters

Here we would like to draw your attention to OIRA_AGGSCHDEF table in SAP. As we know it is being mainly used with the SAP IS-OIL-DS (Downstream in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIRA_AGGSCHDEF is a SAP standard transp table used for storing Pre-aggregation schema definition parameters related data in SAP. It comes under the package OIR.

SAP OIRA_AGGSCHDEF table

Table OIRA_AGGSCHDEF technical data

TableOIRA_AGGSCHDEF
Data storingPre-aggregation schema definition parameters
ModuleIS-OIL
Sub ModuleIS-OIL-DS-SSR
SAP PackageOIR
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • AGGSCHEMA : Aggregation schema into Document Base Table
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • DESTSTRUCT : Reference structure for destination
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • DESTFNAME : Aggregation destination field name
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • SRCESTRUCT : Reference source structure
    Its data type is CHAR (Character String) with field length 30
  • SRCEFNAME : Name of source field for aggregation
    Its data type is CHAR (Character String) with field length 30
  • INBADI : Reference to BADI to transfer data into pre-aggregation
    Its data type is CHAR (Character String) with field length 20
  • AGCONST : Constant for aggregation procedure
    Its data type is CHAR (Character String) with field length 20