Calling BAPI_PO_GETDETAIL returns empty row

[Former Member]

Hi All,

Im executing SAP R/3 "BAPI_PO_GETDETAIL" from ASP.Net C# program which returns empty rows & all my datagrids looks blank with 0 rows only

" Datagrid Columns are created !!! ".

Please do help me guys to fix this bug.

Here the code

-

---

private void btnSearch_Click(object sender, System.EventArgs e)

{

SPOProxyDll.SPOProxyDll proxy = new SPOProxyDll.SPOProxyDll();

SPOProxyDll.BAPIADDRESS Po_Address = new SPOProxyDll.BAPIADDRESS();

SPOProxyDll.BAPIEKKOL Po_Header = new SPOProxyDll.BAPIEKKOL();

SPOProxyDll.BAPIPAREXTable Extensionout = new SPOProxyDll.BAPIPAREXTable();

SPOProxyDll.BAPIEKKOTXTable Po_Header_Texts = new SPOProxyDll.BAPIEKKOTXTable();

SPOProxyDll.BAPIEKKNTable Po_Item_Account_Assignment = new SPOProxyDll.BAPIEKKNTable();

SPOProxyDll.BAPIEKESTable Po_Item_Confirmations = new SPOProxyDll.BAPIEKESTable();

SPOProxyDll.BAPIESUCTable Po_Item_Contract_Limits = new SPOProxyDll.BAPIESUCTable();

SPOProxyDll.BAPIEKBETable Po_Item_History = new SPOProxyDll.BAPIEKBETable();

SPOProxyDll.BAPIEKBESTable Po_Item_History_Totals = new SPOProxyDll.BAPIEKBESTable();

SPOProxyDll.BAPIESUHTable Po_Item_Limits = new SPOProxyDll.BAPIESUHTable();

SPOProxyDll.BAPIEKETTable Po_Item_Schedules = new SPOProxyDll.BAPIEKETTable();

SPOProxyDll.BAPIESLLTable Po_Item_Services = new SPOProxyDll.BAPIESLLTable();

SPOProxyDll.BAPIESKLTable Po_Item_Srv_Accass_Values = new SPOProxyDll.BAPIESKLTable();

SPOProxyDll.BAPIEKPOTXTable Po_Item_Texts = new SPOProxyDll.BAPIEKPOTXTable();

SPOProxyDll.BAPIEKPOTable Po_Items = new SPOProxyDll.BAPIEKPOTable();

SPOProxyDll.BAPIESLLTXTable Po_Services_Texts = new SPOProxyDll.BAPIESLLTXTable();

SPOProxyDll.BAPIRETURNTable Return = new SPOProxyDll.BAPIRETURNTable();

//

using(proxy.Connection = new SAP.Connector.SAPConnection(this.sapLogonDestination1))

{

//proxy.Bapi_Po_Getdetail("X",txtPO.Text.ToString(),bapiekpoTable1);

proxy.Bapi_Po_Getdetail("","","","","","","X",txtPO.Text.ToString(),"","","",

out Po_Address,out Po_Header,ref Extensionout,

ref Po_Header_Texts,ref Po_Item_Account_Assignment,

ref Po_Item_Confirmations,ref Po_Item_Contract_Limits,

ref Po_Item_History, ref Po_Item_History_Totals,

ref Po_Item_Limits,ref Po_Item_Schedules,ref Po_Item_Services,

ref Po_Item_Srv_Accass_Values,ref Po_Item_Texts,

ref Po_Items,ref Po_Services_Texts,ref Return);

//

grdTest.DataSource = Po_Items;

grdPO1.DataSource = Po_Header_Texts;

this.DataBind();

//

}

//

}

[Former Member]

Thanks

[Former Member]

Hi Shakthi,

how are you doing ?

if the structure is being created, that would mean that the bulk of the work is done.

now check your input parameters to ensure that you are not excluding any rows

please verify the data available in the ekpo table

also note that the selection criteria is client dependant, so the client number specified in the user connection will be used for the query.

with respect,

amit