topic Re: fico table in Application Development and Automation Discussions

fico table

anupam_srivastava2 — Thu, 28 Feb 2008 10:04:35 GMT

Hi All

For transcation FBL5N, for Open Item at key date, field name ALLGSTID which is a structure component, I want to know where actually the field value is stored, in which table.

Regards

Re: fico table

Former Member — Thu, 28 Feb 2008 10:19:04 GMT

Hi,

if you are using SAP 4.72 then follow below step...it may work for other versions also...

1) put this ALLGSTID field in data type and press Utilities---> where used list.

2) check the tables and press enter

3) then the list of tables will get displayed.

Re: fico table

RaymondGiuseppi — Thu, 28 Feb 2008 10:50:58 GMT

FBL5N use a logical database, the field you mentioned is programmatically used in the logical database program. (in fact 2 date parameters refer to this structure field)

The field is stored nowhere. It is used to evaluate the "open item" status at a date. For this purpose it can be compared with :

- BSID or BSAD-BUDAT (posting date) to select records created before the parameter

- BSAD-AUGDT (clearing date) to select records cleared after (open) or before the parameter (cleared)

Call transaction SE36 to look at the logical database DDF. (field STIDA)

Regards

Re: fico table

Former Member — Thu, 28 Feb 2008 15:40:45 GMT

Why do you want to know the table for "Open item at key date"..

there is no use of this date accept user interaction..

If you want to know the accounting document which are open till this date.... only for user's use.. no other use..

Edited by: Sumeet Maheshwari on Feb 28, 2008 4:40 PM

Re: fico table

Former Member — Thu, 28 Feb 2008 17:57:12 GMT

Dear frend,

Just place the cursor on the component type of the field and go for where-used list icon near activate button and then find the entries in the table fields which u require.

Regards,

Ameet

Re: fico table

Former Member — Fri, 29 Feb 2008 06:00:30 GMT

In table BSID with validating of the below fields of date you will get the Open item

data for customer by key date .

AUGDT AUGDT DATS 8 0 Clearing Date

BUDAT BUDAT DATS 8 0 Posting Date in the Document

Reward points if it is usefull..

Girish