fico table

[anupam_srivastava2]

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

AJ

[Former Member]

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.

[RaymondGiuseppi]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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