topic Re: table relationship.... in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/table-relationship/m-p/2364133#M523315 <HTML><HEAD></HEAD><BODY><P>Hi jimmy </P><P></P><P></P><P>all are related to Purchase order and all related WITH THE FOLLOWING FIELDS</P><P>all have EBELN and EBELP fields </P><P></P><P></P><P>Reward if helpfull</P><P></P><P>Regards</P><P>Pavan</P></BODY></HTML> Thu, 07 Jun 2007 08:10:38 GMT Former Member 2007-06-07T08:10:38Z table relationship.... https://community.sap.com/t5/application-development-and-automation-discussions/table-relationship/m-p/2364126#M523308 <HTML><HEAD></HEAD><BODY><P>Hey experts,</P><P></P><P>How are these tables related: EKKO, EKPO, EKBE...what hierarchy exists b/w them...</P><P></P><P>thnkx</P></BODY></HTML> Thu, 07 Jun 2007 07:41:45 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-relationship/m-p/2364126#M523308 Former Member 2007-06-07T07:41:45Z Re: table relationship.... https://community.sap.com/t5/application-development-and-automation-discussions/table-relationship/m-p/2364127#M523309 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>These r all PO tables.</P><P>EKKO-PO header</P><P>EKPO-PO items</P><P>EKBE-History of PO</P><P></P><P>These r all related based on the Purchasing Document Number</P></BODY></HTML> Thu, 07 Jun 2007 07:46:14 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-relationship/m-p/2364127#M523309 Former Member 2007-06-07T07:46:14Z Re: table relationship.... https://community.sap.com/t5/application-development-and-automation-discussions/table-relationship/m-p/2364128#M523310 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>With PO number and Item number they are related</P><P>Hierarchy</P><P>is</P><P>EKKO</P><P>EKPO </P><P>EKBE</P><P>all have EBELN and EBELP fields </P><P>link them using these fields</P><P></P><P>Reward points for useful Answers</P><P>Regards</P><P>Anji</P></BODY></HTML> Thu, 07 Jun 2007 07:46:46 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-relationship/m-p/2364128#M523310 Former Member 2007-06-07T07:46:46Z Re: table relationship.... https://community.sap.com/t5/application-development-and-automation-discussions/table-relationship/m-p/2364129#M523311 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>ekko-ebeln = ekpo-ebeln = ekbe-ebeln</P><P>ekpo-ebeln = ekbe-ebeln</P><P>ekpo-ebelp = ekbe-ebelp</P><P></P><P>if helpful, reward</P><P>Sathish. R</P></BODY></HTML> Thu, 07 Jun 2007 07:47:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-relationship/m-p/2364129#M523311 Former Member 2007-06-07T07:47:00Z Re: table relationship.... https://community.sap.com/t5/application-development-and-automation-discussions/table-relationship/m-p/2364130#M523312 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>Refer to this flow, ths might help you</P><P></P><P><A href="http://www.sapgenie.com/abap/tables_mm.htm" target="test_blank">http://www.sapgenie.com/abap/tables_mm.htm</A></P><P></P><P><A href="http://www.sapgenie.com/abap/tables_fi.htm" target="test_blank">http://www.sapgenie.com/abap/tables_fi.htm</A></P><P></P><P><A href="http://www.sapgenie.com/abap/tables_mm.htm#Purchasing%20Tables" target="test_blank">http://www.sapgenie.com/abap/tables_mm.htm#Purchasing%20Tables</A></P><P></P><P></P><P>Regards</P><P>Anversha</P></BODY></HTML> Thu, 07 Jun 2007 07:50:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-relationship/m-p/2364130#M523312 anversha_s 2007-06-07T07:50:31Z Re: table relationship.... https://community.sap.com/t5/application-development-and-automation-discussions/table-relationship/m-p/2364131#M523313 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>EKKO and EKPO related to MM Purchasing Documents and EKBE related Good reciept in MM Purchasing.</P><P>MSEG and EKBE are related like below:</P><P></P><P>MSEG (Document Segment: Material) </P><P>Document No (MBLNR)</P><P>Fiscal Year (MJAHR)</P><P>Line Item (ZEILE)</P><P>EKBE (History of Purchasing Document)</P><P>Purchasing Doc (EBELN) Item (EBELP) Account Assign (ZEKKN) Trans Type (VGABE) Fiscal Year (MJAHR) Document No (MBLNR) Line Item (ZEILE)</P><P></P><P>EKKO and EKPO related like below with fields:</P><P></P><P>EKPO</P><P>(Purchasing Document Item)</P><P>Purchasing Doc (EBELN)</P><P>Item (EBELP)</P><P>EKKO</P><P>(Purchasing Document Header)</P><P>Purchasing Doc (EBELN)</P><P></P><P>All shud be related with EBELN.</P><P></P><P>Regards</P><P></P><P>Kannaiah</P></BODY></HTML> Thu, 07 Jun 2007 07:51:45 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-relationship/m-p/2364131#M523313 Former Member 2007-06-07T07:51:45Z Re: table relationship.... https://community.sap.com/t5/application-development-and-automation-discussions/table-relationship/m-p/2364132#M523314 <HTML><HEAD></HEAD><BODY><P>EKKO Purchasing Document Header</P><P> EKPO Purchasing Document Item </P><P>EKBE History per Purchasing Document </P><P>They relate with the purchase doc(ebeln)and the item(ebelp)</P></BODY></HTML> Thu, 07 Jun 2007 07:57:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-relationship/m-p/2364132#M523314 Former Member 2007-06-07T07:57:18Z Re: table relationship.... https://community.sap.com/t5/application-development-and-automation-discussions/table-relationship/m-p/2364133#M523315 <HTML><HEAD></HEAD><BODY><P>Hi jimmy </P><P></P><P></P><P>all are related to Purchase order and all related WITH THE FOLLOWING FIELDS</P><P>all have EBELN and EBELP fields </P><P></P><P></P><P>Reward if helpfull</P><P></P><P>Regards</P><P>Pavan</P></BODY></HTML> Thu, 07 Jun 2007 08:10:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-relationship/m-p/2364133#M523315 Former Member 2007-06-07T08:10:38Z