Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

open items date and clearing date

Former Member

‎2005 Oct 31 9:40 AM

0 Likes
1,229

Hi,

Could any one tell me what are the field names in BSEG table for the "open items date" and "clearing date"?

thank u

Kaki

Hi,

Could any one tell me what are the field names in BSEG table for the "open items date" and "clearing date"?

thank u

Kaki

Reply
3 REPLIES 3
Read only

Former Member

‎2005 Oct 31 9:48 AM

0 Likes
1,058

Hi,

AUGDT - Clearing date

Net due date is calculated from:

ZFBDT

ZBD1T

ZBD2T

ZBD3T

Svetlin

Read only

Former Member
In response to Former Member

‎2005 Oct 31 9:54 AM

0 Likes
1,058

Hi svetlin,

How we can find out how many open items are there by today's date using BSEG table?

using

ZFBDT

ZBD1T

ZBD2T

ZBD3T ??

kaki

Read only

sergey_korolev
Active Contributor
In response to Former Member

‎2005 Oct 31 10:53 AM

0 Likes
1,058

You should better analyze open items via secondary index tables (BSID for customers, BSIK for vendors, and BSIS for G/L accounts with open items), it would be more efficient. Those tables by design contain actual open items only.

Anyway if you have to select open items via BSEG then you should select those which have AUGBL and AUGDT fields cleared.

Another option is to use some LDB (Logical DataBase) - KDF or DDF.