You can use SAP Table Reader Connector to connect to the SAP BW/4HANA application and read large volumes of data from SAP ADSO objects.
SAP Advanced DataStore Object (ADSO) is the central object for data storage and data consolidation in the SAP BW system. ADSO is the primary persistent object in BW/4HANA and simplifies the modeling and support environment. ADSOs are commonly stored in 2-dimensional transparent database tables.
Data Integration imports the following SAP ADSO information:
•ADSO name
•Description
•Type
•Info area
•Transfer structure
•Field information such as the name, type, description, precision, scale, SAP type, SAP length, SAP output length, and SAP decimals.
Naming conventions of SAP ADSO objects
When you import an ADSO object as a source in Data Integration mappings, it follows /BIC/A<technical_name of ADSO>* naming convention, where * represents the table number associated with an ADSO.
When you import an ADSO into Cloud Data Integration, the Secure Agent imports the following five tables associated with each ADSO:
•/BIC/A<technical_name of ADSO>1. Inbound table for data store <technical_name of ADSO>.
•/BIC/A<technical_name of ADSO>2. Active data table for data store <technical_name of ADSO>.
•/BIC/A<technical_name of ADSO>3. Change log for data store <technical_name of ADSO>.
•/BIC/A<technical_name of ADSO>6. View for extraction from data store <technical_name of ADSO>.
•/BIC/A<technical_name of ADSO>7. View for reporting for datastore <technical_name of ADSO>.
•/BIC/A<technical_name of ADSO>8. View for external access (introduced in BW/4HANA 2.0 <technical_name of ADSO>.
The following image shows the five tables of an ADSO with technical name ZDELTA that you can import from BW/4HANA 1.0 into Cloud Data Integration:
