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 can I specify the latest time of day with DateTime
- Getting today's date in YYYY-MM-DD in Python?
- Extracting date, hour and minute from Instant.now() generated date
- SimpleDateFormat ignores "XXX" if timezone is set to "UTC"
- javascript getting hour and min from epoch value
- how to construct and write a formula to google sheets to perform a dynamic date calculation
- How do you determine a processing time in Python?
- If I wanted to work using dates and time going millions of years into the past/future how would I do it?
- How should I parse times in the Japanese "30-hour" format for data analysis?
- Powershell showing old time after changing the time zone
- How can I align high frequency time series data in microsoft excel
- Add or Sum of hours like 13:30+00:00:20=13:30:20 but how?
- Ignore milliseconds when comparing two datetimes
- UnParseable Date Exception :"2015-02-06T16:05:20"
- Fill pandas columns based on datetime condition
- Using DateFormat with locale causes FormatException: Trying to read yyyy from 2020-08-07 15:00 at position 0
- Change date format in js for jquery datatable
- How to format date displayed in Datatable
- Python generating a list of dates between two dates
- Displaying date/time in user's timezone - on client side
- Parsing dates with dart
- Convert date to datetime in Python
- Why does the Python datetime.replace() method return a new object instead of mutate the existing object?
- How to check if DST (Daylight Saving Time) is in effect, and if so, the offset?
- Convert String month to integer java
- What is the Z ending on date strings like 2014-01-01T00:00:00.588Z
- Denote timezone in ISO 8601 when using date only
- Django + FactoryBoy -> Postgres not converting datetime to utc correctly
- What are "offsets" and "gaps" mentioned in the Javadoc for ZonedDateTime::plusDays?
- Simulating DateTime to test scheduled events