FAGL_ACCOUNT_ITEMS_GL_API doesn't return any data by I_POSTING_DATES range
In SE37, I am trying to execute FAGL_ACCOUNT_ITEMS_GL_API function module but in import parameters area I_POSTING_DATE is not working and output brings all records to BUDAT column although I insert 01.05.2020 - 30.05.2020. Complete input is:
SIGN column -->I
OPTION column -->BT
LOW column -->01.05.2020
HIGH column -->30.05.2020
My question is: What should be written inside of the I_POSTING_DATES column by column to get the data from ET_FAGLPOSX table as i want.
Thank you
The parameters of FAGL_ACCOUNT_ITEMS_GL_API reflect the ones in the selection screen of transaction code FAGLL03.
As you can see in FAGLL03, the selection by posting date is possible only when "All items" is selected:
The parameter I_KIND_OF_SELECTION of FAGL_ACCOUNT_ITEMS_GL_API corresponds to the 3 radio buttons:
1: Open items2: Cleared items3: All items
The selection by posting date is possible only if you select "all items", and it's the same with FAGL_ACCOUNT_ITEMS_GL_API, the parameter I_POSTING_DATES is considered only with I_KIND_OF_SELECTION = '3'.
- How to change timezone of datetime object using timezone abbreviation
- Incorrect datetime value: ' ' for function str_to_date
- check date input for complete date
- Regarding the pytz module and the time module in Python
- Django - can not get a time function (timezone, datetime) to work properly, Getting ErrorName message: global name not defined
- Sort a 2d array by date (Y-m-d) date and time (Hi) columns
- Sort a 2d array by a datetime column formatted as Y-m-d\TH:i:s.\+000
- Sort a 2d array by a datetime column formatted as Y-m-d H:i:s
- Sort a 2d array by a date column formatted as d M, Y H:i a
- Sort a 2d array by datetime column formatted as d/m/Y H:i:s A
- PHP Sort a multidimensional array by element containing Y-m-d H:i:s date
- PHP order array by date?
- Unable to extract timestamp from Date/Timestamp combo column in Excel 2016
- Remove time expressions from a flat array of datetime strings
- How Do I use the formats in DateTime::Locale with a DateTime object?
- How to convert DateTime to/from specific string format (both ways, e.g. given Format is "yyyyMMdd")?
- How to handle jodatime Illegal instant due to time zone offset transition
- Timespan between Now and Next Hour?
- How do I find the time difference between two datetime objects in python?
- Polars Adding Days to a date
- How can I get the first and last day of the month with Perl's DateTime?
- SQLite query to join on a range of dates?
- C# Linq Datatable groupby datetime month
- Error when parsing dates using Lubridate. All formats failed to parse. No formats found
- How to specify a timezone for a joda DateTime object?
- How do I target a specific day of the current month with DateTime functions?
- How to get Timestamp of the current Date and time in Rust
- Determination of the time difference
- How can I calculate the number of years between two dates?
- How to set a timezone with org.joda.time?