chart of accounts query. I want a query to generate sap business one chart of account heirarchy. We are trying to create a report using bi publisher and we require a sql query to obtain the chart of account value set values (value and description shown on screenshot) from.
chart of accounts query Chart of accounts is the combination of many segments in oracle and we attach the value sets in these chart of. Use the below query to get the same hierarchy as in chart of accounts select t0.[acctcode],t0.[acctname] from oact t0. We are trying to create a report using bi publisher and we require a sql query to obtain the chart of account value set values (value and description shown on screenshot) from.
The Query Here Will Fetch You Following List Of Columns:
Chart of accounts is the combination of many segments in oracle and we attach the value sets with these chart of accounts. If you are looking for a quick answer to fetch the charts of accounts structure, query is given below. I want a query to generate sap business one chart of account heirarchy.
We Are Trying To Create A Report Using Bi Publisher And We Require A Sql Query To Obtain The Chart Of Account Value Set Values (Value And Description Shown On Screenshot) From.
Chart of accounts is the combination of many segments in oracle and we attach the value sets in these chart of. Use the below query to get the same hierarchy as in chart of accounts select t0.[acctcode],t0.[acctname] from oact t0.