topic Aging report in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/aging-report/m-p/2589905#M592887 <HTML><HEAD></HEAD><BODY><P>hi I am developing a aging report for which I am getting fields from the tables EKPO and EKKO based on </P><P></P><PRE><CODE> s_gjahr FOR bsid-gjahr OBLIGATORY. "Document Fiscal year p_date TYPE vbak-aedat OBLIGATORY, "A/P Open items p_bukrs TYPE t001-bukrs OBLIGATORY. "Company s_ekorg FOR mepo1222-ekorg OBLIGATORY, "Purchasing Organization s_ekgrp FOR mepo1222-ekgrp, "Purchasing group s_zterm FOR bseg-zterm, "Terms s_ebeln FOR bseg-ebeln, "Purchase order s_hkont FOR bseg-hkont, "Reconciliation Account. s_blart FOR invfo-blart OBLIGATORY, "Document type s_date FOR bseg-zfbdt NO-DISPLAY. SELECT * FROM ekko INTO TABLE tbl_ekko WHERE bukrs = p_bukrs AND zterm IN s_zterm AND ekorg IN s_ekorg AND ekgrp IN s_ekgrp. IF tbl_ekko[] IS NOT INITIAL. SELECT * FROM ekpo INTO TABLE tbl_ekpo FOR ALL ENTRIES IN tbl_ekko WHERE ebeln = tbl_ekko-ebeln AND bukrs = p_bukrs AND repos = 'X' AND werks IN s_werks. "additonal. ENDIF. </CODE></PRE><P>Now my problem is I need to combine the data I have selected from EKKO with a table which has EBELN, I found BSIK but that doesnt have the EBELN field filled.</P><P></P><P>Can you tell me some table other than BSEG ( performace issue ) which I can use to select my entries with Inner join... only BSIK has BLART not BSEG..</P><P></P><P></P><P>I will definitely award points for all the helpful answers</P></BODY></HTML> Mon, 30 Jul 2007 15:10:51 GMT Former Member 2007-07-30T15:10:51Z Aging report https://community.sap.com/t5/application-development-and-automation-discussions/aging-report/m-p/2589905#M592887 <HTML><HEAD></HEAD><BODY><P>hi I am developing a aging report for which I am getting fields from the tables EKPO and EKKO based on </P><P></P><PRE><CODE> s_gjahr FOR bsid-gjahr OBLIGATORY. "Document Fiscal year p_date TYPE vbak-aedat OBLIGATORY, "A/P Open items p_bukrs TYPE t001-bukrs OBLIGATORY. "Company s_ekorg FOR mepo1222-ekorg OBLIGATORY, "Purchasing Organization s_ekgrp FOR mepo1222-ekgrp, "Purchasing group s_zterm FOR bseg-zterm, "Terms s_ebeln FOR bseg-ebeln, "Purchase order s_hkont FOR bseg-hkont, "Reconciliation Account. s_blart FOR invfo-blart OBLIGATORY, "Document type s_date FOR bseg-zfbdt NO-DISPLAY. SELECT * FROM ekko INTO TABLE tbl_ekko WHERE bukrs = p_bukrs AND zterm IN s_zterm AND ekorg IN s_ekorg AND ekgrp IN s_ekgrp. IF tbl_ekko[] IS NOT INITIAL. SELECT * FROM ekpo INTO TABLE tbl_ekpo FOR ALL ENTRIES IN tbl_ekko WHERE ebeln = tbl_ekko-ebeln AND bukrs = p_bukrs AND repos = 'X' AND werks IN s_werks. "additonal. ENDIF. </CODE></PRE><P>Now my problem is I need to combine the data I have selected from EKKO with a table which has EBELN, I found BSIK but that doesnt have the EBELN field filled.</P><P></P><P>Can you tell me some table other than BSEG ( performace issue ) which I can use to select my entries with Inner join... only BSIK has BLART not BSEG..</P><P></P><P></P><P>I will definitely award points for all the helpful answers</P></BODY></HTML> Mon, 30 Jul 2007 15:10:51 GMT https://community.sap.com/t5/application-development-and-automation-discussions/aging-report/m-p/2589905#M592887 Former Member 2007-07-30T15:10:51Z Re: Aging report https://community.sap.com/t5/application-development-and-automation-discussions/aging-report/m-p/2589906#M592888 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>U need to read the EKBE table here you should fine the FI invoices linked to PO</P><P></P><P>Max</P></BODY></HTML> Mon, 30 Jul 2007 15:13:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/aging-report/m-p/2589906#M592888 Former Member 2007-07-30T15:13:04Z Re: Aging report https://community.sap.com/t5/application-development-and-automation-discussions/aging-report/m-p/2589907#M592889 <HTML><HEAD></HEAD><BODY><P>RSEG was the missing table which I needed to connect EKBE with BSIK</P></BODY></HTML> Fri, 08 Aug 2008 09:55:27 GMT https://community.sap.com/t5/application-development-and-automation-discussions/aging-report/m-p/2589907#M592889 Former Member 2008-08-08T09:55:27Z