I want to understand how OTM database (GLOGOWNER) is aligned with OAC database (HDOWNER)

Summary:

HOW OTM data is mapped in OAC, I want to understand this, because data in OTM database have different tables and in HDOWNER have diff hierarchy, wanted to understand it, so it helps me to create workbooks

Content (please ensure you mask any confidential information):

In OTM database, we have different tables and this data flowsto OAC, but in different hierarchy, means shipment related info some are indifferent folders in OAC database, so wants to understand this mapping, so ableto create workbooks, with validation that this folder in subject area has datafrom that tables OTM database tables - Mapping with subject area in OAC .