SAP BW Create SPO via BAdI - Part 1

At my current project I needed a way to create Semantic Partitioning Object (SPO) via BAdI to reduce the end-of-year work. After a little search via Google (you cannot find anything on the new SAP Community Page), I found these threads.

Both were not perfect, so I build a solution between them. I also put everything via control tables, so it would be easier for the users to manage them. So let's get started.

Create own data dictionary objects

The following domains have to be implemented:

  • ZSPOPARTGROUP - SPO Partition Group
  • ZSPOPATTERNID - SPO Partitioning Pattern
  • ZSPOTLOGO - SPO Object Type for DTP

SPO Partition Group

Domain: ZSPOPARTGROUP
Domain: ZSPOPARTGROUP

SPO Partitioning Pattern

Domain: ZSPOPATTERNID
Domain: ZSPOPATTERNID

SPO Object Type for DTP

Domain: ZSPOTLOGO
Domain: ZSPOTLOGO
Domain: ZSPOTLOGO Value Range
Domain: ZSPOTLOGO Value Range

After we created the domains, we have to create the following data elements:

  • ZSPOPARTGROUP - SPO Partition Group
  • ZSPOPATTERNID - SPO Partitioning Pattern
  • ZSPOPATTERNID1 - SPO Partitioning Pattern 1
  • ZSPOPATTERNID2 - SPO Partitioning Pattern 2
  • ZSPOPATTERNID3 - SPO Partitioning Pattern 3
  • ZSPOPATTERNID4 - SPO Partitioning Pattern 4
  • ZSPOTLOGO - SPO Object Type for DTP

SPO Partition Group

Data Element: ZSPOPARTGROUP
Data Element: ZSPOPARTGROUP

SPO Partitioning Pattern

Data Element: ZSPOPATTERNID
Data Element: ZSPOPATTERNID

Note: The data elements ZSPOPATTERNID1, ZSPOPATTERNID2, ZSPOPATTERNID3 and ZSPOPATTERNID4 are defined like the ZSPOPATTERNID.

SPO Object Type for DTP

Data Element: ZSPOTLOGO
Data Element: ZSPOTLOGO

We also implement a search help ZSPO_DTPTEMPLATE - SPO Templates

SPO Templates

Search Help: ZSPO_DTPTEMPLATE
Search Help: ZSPO_DTPTEMPLATE

Create Transparent Tables

After all these elements are created, we can now create the following transparent tables:

  • ZSPOINFOPROV - SPO BAdI Managed InfoProvider
  • ZSPOPATTERN - SPO Authorized Partition Pattern
  • ZSPOPATTERNT - SPO Authorized Partition Pattern Text
  • ZSPOCRITERIA - SPO Pattern Partition Criteria
  • ZSPODTP - SPO BAdI Managed DTP

Table ZSPOPATTERN

The following fields have to be implemented:

  • PATTERNID
  • INFOOBJECT
Table ZSPOPATTERN Fields
Table ZSPOPATTERN Fields

This entry helps and checks have to be implemented:

Table ZSPOPATTERN Entry help/check
Table ZSPOPATTERN Entry help/check
Table ZSPOPATTERN Foreign Key
Table ZSPOPATTERN Foreign Key

Table ZSPOPATTERNT

The following fields have to be implemented:

  • LANGU
  • PATTERNID
  • TXTLG
  • TXTSM
Table ZSPOPATTERNT Fields
Table ZSPOPATTERNT Fields

This entry helps and checks have to be implemented:

Table ZSPOPATTERNT Entry help/check
Table ZSPOPATTERNT Entry help/check
Table ZSPOPATTERNT Foreign Key
Table ZSPOPATTERNT Foreign Key

Table ZSPOCRITERIA

The following fields have to be implemented:

  • PATTERNID
  • PARTGROUP
  • LOWVALUE
  • HIGHVALUE
Table ZSPOCRITERIA Fields
Table ZSPOCRITERIA Fields

This entry helps and checks have to be implemented:

Table ZSPOCRITERIA Entry help/check
Table ZSPOCRITERIA Entry help/check
Table ZSPOCRITERIA Foreign Key
Table ZSPOCRITERIA Foreign Key

Table ZSPOINFOPROV

The following fields have to be implemented:

  • SPONAME
  • PATTERNID1
  • PATTERNID2
  • PATTERNID3
  • PATTERNID4
Table ZSPOINFOPROV Fields
Table ZSPOINFOPROV Fields

This entry helps and checks have to be implemented:

Table ZSPOINFOPROV Entry help/check
Table ZSPOINFOPROV Entry help/check
Table ZSPOINFOPROV Foreign Key
Table ZSPOINFOPROV Foreign Key

Table ZSPODTP

The following fields have to be implemented:

  • SPONAME
  • OBJTYPE
  • OBJNAME
  • LOGSYS
  • DTPTEMPLATE
  • DTPTEMPLATEID
Table ZSPODTP Fields
Table ZSPODTP Fields

This entry helps and checks have to be implemented:

Table ZSPODTP Entry help/check
Table ZSPODTP Entry help/check
Table ZSPODTP Foreign Key ZSPOINFOPROV
Table ZSPODTP Foreign Key ZSPOINFOPROV
Table ZSPODTP Foreign Key TBDLS
Table ZSPODTP Foreign Key TBDLS
Table ZSPODTP Foreign Key RSLPO_DFG_DTPTPL
Table ZSPODTP Foreign Key RSLPO_DFG_DTPTPL

After we created all control tables, we can now create an implementation of BAdI RSLPO_BADI_PARTITIONING. How this works, can be read in Part 2.

Analysis Office - The Comprehensive Guide
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.3 and contains 227 Pages.
29,99 € 1
Analysis Office - The Comprehensive Guide 2nd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.4 and contains 243 pages.
39,99 € 1

Write a comment

Comments: 0