topic open items date and clearing date in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/open-items-date-and-clearing-date/m-p/1052134#M89483 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Could any one tell me what are the field names in BSEG table for the "open items date" and "clearing date"?</P><P></P><P>thank u</P><P>Kaki</P></BODY></HTML> Mon, 31 Oct 2005 09:40:40 GMT Former Member 2005-10-31T09:40:40Z open items date and clearing date https://community.sap.com/t5/application-development-and-automation-discussions/open-items-date-and-clearing-date/m-p/1052134#M89483 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Could any one tell me what are the field names in BSEG table for the "open items date" and "clearing date"?</P><P></P><P>thank u</P><P>Kaki</P></BODY></HTML> Mon, 31 Oct 2005 09:40:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-items-date-and-clearing-date/m-p/1052134#M89483 Former Member 2005-10-31T09:40:40Z Re: open items date and clearing date https://community.sap.com/t5/application-development-and-automation-discussions/open-items-date-and-clearing-date/m-p/1052135#M89484 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>AUGDT - Clearing date</P><P></P><P>Net due date is calculated from:</P><P>ZFBDT</P><P>ZBD1T</P><P>ZBD2T</P><P>ZBD3T</P><P></P><P>Svetlin</P></BODY></HTML> Mon, 31 Oct 2005 09:48:08 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-items-date-and-clearing-date/m-p/1052135#M89484 Former Member 2005-10-31T09:48:08Z Re: open items date and clearing date https://community.sap.com/t5/application-development-and-automation-discussions/open-items-date-and-clearing-date/m-p/1052136#M89485 <HTML><HEAD></HEAD><BODY><P>Hi svetlin,</P><P>How we can find out how many open items are there by today's date using BSEG table?</P><P>using </P><P> ZFBDT</P><P> ZBD1T</P><P> ZBD2T</P><P> ZBD3T ??</P><P></P><P>kaki</P></BODY></HTML> Mon, 31 Oct 2005 09:54:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-items-date-and-clearing-date/m-p/1052136#M89485 Former Member 2005-10-31T09:54:18Z Re: open items date and clearing date https://community.sap.com/t5/application-development-and-automation-discussions/open-items-date-and-clearing-date/m-p/1052137#M89486 <HTML><HEAD></HEAD><BODY><P>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.</P><P>Anyway if you have to select open items via BSEG then you should select those which have AUGBL and AUGDT fields cleared.</P><P>Another option is to use some LDB (Logical DataBase) - KDF or DDF.</P></BODY></HTML> Mon, 31 Oct 2005 10:53:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-items-date-and-clearing-date/m-p/1052137#M89486 sergey_korolev 2005-10-31T10:53:01Z