Back end BW table for Controls in BPC

[former_member226690]

Hi Experts,

There is a requirement from the customer to pull out all the CONTROLS data along with the Validations in them.

(We have approx 2000 controls, and its a lot of manual effort to copy paste each control ID with the validations inside it.)

I would like to know the back-end BW table where all this information is stored.

I tried all the *CPMB* and all *UJ* tables in se11 but was unsuccessful....

Attached the document with screenshots.

I'm looking to get table information of screenshot no.3 which contain all the validations of a control.

Please help.

Regards,

Lavanya

[former_member186338]

Ups, what about UJCTRL_* ?

UJ0_GET_GEN_TABNAME is not related to the subject

Vadim

[former_member226690]

Hi Vadim,

Thanks for your response, i did check those tables as well, but none of them had the validation details for the controls.

Regards,

Lavanya

[former_member186338]

Sorry, but if you look on UJCTRL_CONTROL on the field EXPRESSION you will find xml with the control logic definition.

Vadim

[former_member226690]

Hi Vadim,

Sorry,Im really not sure how to convert the xml logic definition into a readable format, could you kindly help me out?

Regards,

Lavanya

[former_member186338]

You have to read and write this xml programmatically - using ABAP or if you download text in the text file (full xml field!) then you can use VBA to work with xml. It's a complex job and require development skills. Sorry, no other way.

Vadim

[former_member226690]

Hi Vadim,

This is a pretty complex job like you said. Thanks for all your help though.

[former_member186338]

But may be you can simply export the whole table and import records without changing the EXPRESSION field?

[former_member186338]

Just look on the sample EXPRESSION field for some control from IFRS kit:

#<?xml version="1.0" encoding="utf-16"?><ns2:ujctrl_expression xmlns:ns2="http://xml.sap.com/2010/02/bpc/controls"><ns2:expression><ns2:leftExpression><ns2:operand rank="0" sign="+" multiply="x" value="1"><ns2:tupple><ns2:dimensionMember dimensionId="ACCOUNT" memberId="TA140"/><ns2:dimensionMember dimensionId="AUDIT_TRAIL" memberId="ALL_INPUT"/><ns2:dimensionMember dimensionId="FLOW" memberId="F15"/><ns2:dimensionMember dimensionId="INTERCO" memberId="I_NONE"/></ns2:tupple><ns2:multiply>x</ns2:multiply></ns2:operand></ns2:leftExpression><ns2:rightExpression/></ns2:expression></ns2:ujctrl_expression>

If you have the same dimension names...

Vadim

[dinesh_veluru]

Hi Lavanya,

To find out the control tables related to model specific then go to SE38 run the program UJ0_GET_GEN_TABNAME

Thanks,

Dinesh.V

[former_member226690]

Hi Dinesh,

I ran the program but all i got was table names for Comment, Audit Data, Journal, Member and Work Status specific to the model.