Tables BW for BPC 10.1(Embedded)
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. 😀
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. 😎
A very good central repository for list of BPC relevant BW tables from BPC 10.1 Embedded prospective.
Thanks for sharing it.
Thank you for taking the time to read the publication Shubhranshu Patra 🙂
Thanks for sharing 🙂
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
Very nice.
Thanks for sharing
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