Export Organisational Attributes from PPOMA_CRM into Excel

[CarrieMason]

Hi Experts

We use the PPOMA_CRM Org Structure to identify the shops which are managed by different Area Managers within different Territories for our shops. Our Master Data Team would like to export this information to do a data quality check within the CRM system. However, when exporting the expended Nodes (as advised here: how to download the org structure from PPOMA_CRM to excel | SAP Community) we don't get to the attributes which are included in the different Org units, is there a way to download all of the information included in the units (e.g. all attributes assigned to the node)?

[FabianJ]

Hello Carrie,

Organizational Units attributes are stored in tables HRP1222 and HRT1222.

I think the best option is to download the content of the Database View HRV1222A and consolidate with your extract using OTYPE and OBJID as the key to identify the Org Unit.

Kind Regards,

Fabian