BEx is a multidimensional query framework on top of SAP BW InfoProvider. BEx queries use standard SAP BW access methods and all authorization concepts from SAP BW are inherited. BEx queries represent business logic applied to InfoProvider views, and metadata is therefore crucial to understand filters, variables, rows, columns, cell-based formulas, exceptions and conditions.
If the BEx query has dynamic columns (a characteristic on columns with key figures such that every key figure is repeated along with the characteristic value) then this will create a dynamic output. Dynamic columns are not supported by Foundry so adjust your query accordingly if this is the case.
Use the bex object type to extract data from BEx queries.
Example sync configuration:
Copied!1 2 3type: magritte-sap-source-adapter sapType: bex obj: PALQ16
Additional parameters are supported when configuring transaction code extraction:
Multiple parameters can be defined in the same sync.
Provide filters values for BEx query variables.
Example sync configuration:
Copied!1 2 3 4type: magritte-sap-source-adapter sapType: bex obj: PALQ16 filter: VAR006=A;VAR006=B
Filter the data after the query is run.
Copied!1 2 3 4type: magritte-sap-source-adapter sapType: bex obj: PALQ16 charFilter: PMAT=M001
Add characteristics to the output. These characteristics need to be defined as free characteristics in the BEx query.
The following example adds PAL01 to the output:
Copied!1 2 3 4type: magritte-sap-source-adapter sapType: bex obj: PALQ16 freeChars: PAL01
Remove key characteristics from the output.
The following example removes PAL01 from the output:
Copied!1 2 3 4type: magritte-sap-source-adapter sapType: bex obj: PALQ16 dropColumns: PAL01
Allows to toggle between technical and humand-readable (language-dependent) column names.
Example sync configuration:
Copied!1 2 3 4type: magritte-sap-source-adapter sapType: bex obj: PALQ16 technicalNames: true