BPC 7.5 Data Dictionary (ERD)

[former_member244885]

Hi,

I'm supporting a BPC 7.5 environment that another person did some modification to.

Can anyone point me to where I can find a data dictionary for BPC 7.5?

What I'm looking for specifically is a list of the stored procedures that are included in a vanilla BPC 7.5 installation.

I'm attempting to identify those stored procedures that were written to supplement the base install in an effort to identify the work that will be required for a 10.1 upgrade.

Thanks,

Jon

[former_member186498 · Accepted solution]

Hi Jon,

I never saw a complete list of stored procedures in a SAP doc, just this note that contains a partial list 1446515 - List of out of support business rule stored procedures

you can exclude also repeated stored procedures for all the applications like DMU<application> or INS1<application>.

Think also that normally custom stored procedures begins with sp and have an acronym in the name and inside a comment with author and hopefully descriptions of the steps, in addition most of the SAP sp are encrypted and you cannot modify it, if modify is greyed you can skip it.

Another possibility is to install a new version of 7.5 from scratch and see all the installed stored procedures .

Regards

     Roberto

[former_member244885 · Accepted solution]

Would the ApShell database contain the list of stored procedures I'm looking for?

Here's what I came up with:

SELECT *
FROM   [MYAPP].information_schema.routines
WHERE  routine_type = 'PROCEDURE'
       AND specific_name NOT IN (SELECT specific_name
                                 FROM   appserver.information_schema.routines
                                 WHERE  routine_type = 'PROCEDURE'
                                 UNION ALL
                                 SELECT specific_name
                                 FROM   apshell.information_schema.routines
                                 WHERE  routine_type = 'PROCEDURE')
       AND specific_name NOT LIKE 'INS%'
       AND specific_name NOT LIKE 'DMU%'
ORDER  BY specific_name 

[former_member186498 · Accepted solution]

Hi Jon,

yes it could be also a good start but remember that on ApShell the list is not complete, e.g workstatus, IsAvailable ...

You have anyway to check the remaing stored procedures.

Regards

     Roberto

[former_member244885 · Accepted solution]

Thanks for the info!