Tables BW for BPC 10.1(Embedded)

[former_member223971]

Hi,

On many occasions we have found with inconsistencies within the SAP BPC 10.1 Embedded system such as:

:!: No allow delete BPF´s

:!: No allow delete Instances BPF's

:!: Some action buttons do not run if the administrator does not have BPC Web in English language

Therefore the only way I found to delete the BPF and instances of BPF, is delete the component by the tables of BW.

Seeing that the transactions and tables in BW for the classical model are not the same for the embedded model.

After searching and not finding documentation on tables for embedded model. But as he says the saying "he who seeks finds" With the help of my love found some the tables applying the embedded model.

which today want to share. :grin:

I hope to be of use.

Table	Description
RSBPC_EN_BCS	POA SBC E&N BCS Send Document Fiel
RSBPC_EN_DEFPRE	E&N Master User Preferences for De
RSBPC_EN_EMAILPR	E&N Email Preferences
RSBPC_EN_MYMSGPR	POA SBC Event & NotificationMy Mes
RSBPC_EN_PREF_T	E&N User Preferences Item Descript
RSBPC_EN_USRPRE	E&N User Preferences
RSBPC_EN_V_DEFPR	E&N: User Channel Preferences
RSBPC_WEB_CONN	BPC Web Connections
RSBPC_WEB_DISP	BPC Web resource handler dispatch
RSBPC_WEB_UP	BPC user preference
RSBPC_WEB_V_DISP	BPC: Programa de control Web
RSBPC0_AUTO_UPDT	BPC: Autoupdate
RSBPC0_PARAM	BPC BW Extension: Global Parameter
RSBPC0_PARAM_APP	BPC Extension: Environment/Model P
RSBPC0_PARAM_DEF	BPC BW Extension: Default Paramete
RSBPC0_TR_CONT	BPC: request for transport deletio
RSBPC0_TR_DELETE	BPC: request for transport deletio
RSBPCA_APPL	BPC model information
RSBPCA_APPL_IPRV	BPC information about infoprovider
RSBPCA_APPLT	BPC Model description text
RSBPCA_APPSET	BPC Environment information
RSBPCA_APPSETT	BPC Environment text table
RSBPCA_ENVM	BPC Environment information
RSBPCA_ENVMT	BPC Environment text table
RSBPCB_ACTION	BPC: Activity action
RSBPCB_ACTION_CV	BPC: BPF action context
RSBPCB_ACTION_PA	BPC: BPF action parameter
RSBPCB_ACTIONT	BPC: Activity action text
RSBPCB_DRV_DIM	BPC: BPF Driver Dimension
RSBPCB_EMAIL	BPC: BPF Email Template
RSBPCB_EMAILT	BPC: BPF Email Template Text
RSBPCB_INST	BPC: BPF Instance
RSBPCB_INST_OWN	BPC: BPF Instance Owner
RSBPCB_MEM_ATTR	BPC: BPF Driver Dimension Attr
RSBPCB_MEM_HIE	BPC: BPF Driver Dimension Hier
RSBPCB_REPORT	BPC: Vista BPF para informe de
RSBPCB_RGN_ACC	BPC: BPF Step Region Access
RSBPCB_SOBJ	BPC: BPF Semantic Object
RSBPCB_SOBJ_LK	BPC: Semantic object link
RSBPCB_SOBJ_LKP	BPC: Semantic object link para
RSBPCB_SOBJ_LKPT	BPC: Semantic object link para
RSBPCB_STEP	BPC: BPF Step
RSBPCB_STEP_MAP	BPC: BPF Step Map
RSBPCB_STEP_RGN	BPC: BPF Step Region
RSBPCB_STEP_ROLE	BPC: BPF Step Role
RSBPCB_STEPT	BPC: BPF Step Text
RSBPCB_TEMPLATE	BPC: BPF Template header
RSBPCB_TMPL	BPC: BPF Template
RSBPCB_TMPL_ACC	BPC: BPF Template Access
RSBPCB_TMPLT	BPC: BPF Template Text
RSBPCC_F_DAO_V	Configuración de DAO feed BPC
RSBPCC_FEED	BPC Comment feed table
RSBPCC_FEED_COM	BPC Comment Feed comment table
RSBPCC_FEED_DAO	BPC Comment Feed DAO table
RSBPCE_DAP_DET	BPC: Detalles del perfil de acceso a datos
RSBPCE_DAP_DIM	BPC: DAP Dimension & Hierarchy
RSBPCE_MEMACCESS	BPC: Dmension member access table
RSBPCE_PROFILE	Profile/Role Mapping
RSBPCE_PROFILET	BPC: Profile text
RSBPCE_TEAM	BPC: Team
RSBPCE_TEAMT	BPC: Team text
RSBPCE_USER_TEAM	BPC: User team
RSBPCF_APSRV_DIR	BPC File Service Application Server Direct
RSBPCF_CLUSTER	BPC File Service Document Cluster Table
RSBPCF_DOC	BPC File Service Document Master Table
RSBPCF_DOC_ACC	BPC: File Service Security Check Table, on
RSBPCF_DOCMAP	BPC File Service Document Directory Path M
RSBPCF_DOCTREE	BPC File Service Document Tree Table
RSBPCK_AO	BPC IP Extension : Primary Object Table
RSBPCK_AO_R	BPC IP Extension: Workbook relationship
RSBPCK_AOT	BPC IP Extension:  Workbook description
RSBPCPS_ALIAS	BPC: Persistence reource alias
RSBPCPS_TEAM_RES	BPC: Team Folder resource
RSBPCR_ACT_PROV	BPC: Activity workspace action provider
RSBPCR_APPS_PROV	BPC: Resource releated appset handler
RSBPCR_CNTXT_HDR	BPC: Resource context header
RSBPCR_CNTXT_ITM	BPC: Resource context item
RSBPCR_FILE_UPLD	BPC: Upload files
RSBPCR_MODEL_DAO	BPC: Model DAO configuration
RSBPCR_OWNER_PRV	BPC: Owner authority provider
RSBPCR_PROPERTY	BPC: Resource Property
RSBPCR_RES_PROVD	BPC: Resource provider
RSBPCR_RESOURCE	BPC: Persistence Resource
RSBPCR_V_ACT_PRV	BPC: Proveedor de acciones p.área de traba
RSBPCR_V_APS_PRV	BPC: Programa control conjunto actividades
RSBPCR_V_OWN_PRV	BPC: Verificación de autorización para pro
RSBPCR_V_RES_DAO	BPC: DAO de recursos
RSBPCR_V_RES_PRV	BPC: Proveedor para tipo de recurso
RSBPCR_V_VIW_PRV	BPC: Proveedor de vista
RSBPCR_VIEW	BPC: Persistence Resource View
RSBPCR_VIEW_PROV	BPC: View provider
RSBPCR_VIEW_VALS	BPC: Resource View Values
RSBPCR_VIEWT	BPC: Persistence Resource View Text
RSBPCU_DA_CTL	BPC-PAK: Data Audit Control Table
RSBPCW_APP_STATU	Application lock status cache
RSBPCW_EMAIL	BPC Work Status - Email Setting Table
RSBPCW_EMAIL_CFG	Work Status Email Confiuration
RSBPCW_EMAILT	BPC Work Status - Email Setting Text Table
RSBPCW_LCK_DIM	BPC Work Status - Lock Dimension Table
RSBPCW_MODTAB	Model Table: Work Status
RSBPCW_STATCODE	BPC Work Status - Status Code Table
RSBPCW_STATCODET	BPC Work Status - Status Code Text Table
RSBPCW_STATCOMP	BPC Work Status - Component Enablement Sta
RSBPCW_UPD_LOG	BPC Work Status - Locks Update Log Table
RSBPCW_WK_STATUS	BPC Work Status: Meta Info for Work Status

Best Regards,

Juan Pablo Chaparro. :cool:

[Former Member]

A very good central repository for list of BPC relevant BW tables from BPC 10.1 Embedded prospective.

Thanks for sharing it.

[former_member223971]

Thank you for taking the time to read the publication shubhranshu.patra

[former_member224609]

Thanks for sharing :smile:

[former_member187400]

it's very helpful information, thanks you.

Btw, do you have any information on FOX tables?

At the moment, FOX Formula only shows the key E.g. {Amount, Account }, it will be : {Amount, 100101} = {Amount, 100102} +{Amount, 100103}.

It's very difficult for the users to review the formula, I am thinking to create a report where it can show the formula with the account in Text.

Do you have any tables for Fox formula?

Many thanks,

Daniel

[Former Member]

Very nice.

Thanks for sharing

[damovand]

Hello,

This is a great list and helpful information but I recommend not deleting anything directly from the tables.  Here is why.  The features of BPC embedded that are coming from BPC standard are designed and implemented to work a specific way.  They are similar to data marts, where everything is very specific.  This means there are many dependencies between the content of different tables.  Based on my experience you could break a functionality if you do manual deleting of such content.

Best Regards,

Leila