topic Query in Database Table!!!! in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/query-in-database-table/m-p/4534052#M1071380 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P> I have a requirement which requires me to get the Object Ids for all orders where Sold-To-Party Partner Number has been changed.</P><P></P><P>Any pointers on how I could fetch this data from CDPOS table?</P><P></P><P>Any pointers on how the field TABKEY is formed.</P><P></P><P></P><P>Regards,</P><P>Vijay</P></BODY></HTML> Sat, 27 Sep 2008 12:27:48 GMT Former Member 2008-09-27T12:27:48Z Query in Database Table!!!! https://community.sap.com/t5/application-development-and-automation-discussions/query-in-database-table/m-p/4534052#M1071380 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P> I have a requirement which requires me to get the Object Ids for all orders where Sold-To-Party Partner Number has been changed.</P><P></P><P>Any pointers on how I could fetch this data from CDPOS table?</P><P></P><P>Any pointers on how the field TABKEY is formed.</P><P></P><P></P><P>Regards,</P><P>Vijay</P></BODY></HTML> Sat, 27 Sep 2008 12:27:48 GMT https://community.sap.com/t5/application-development-and-automation-discussions/query-in-database-table/m-p/4534052#M1071380 Former Member 2008-09-27T12:27:48Z Re: Query in Database Table!!!! https://community.sap.com/t5/application-development-and-automation-discussions/query-in-database-table/m-p/4534053#M1071381 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P> I googled about TABKEY ,</P><P>Ifound some thing about that ... hope it helps ...</P><P></P><P>first 3 letters is for client ,</P><P></P><P>and after that i found different things for different sites .... </P><P></P><P></P><P>1.</P><P>BKKRS = TABKEY+3(4)</P><P>PLANT = TABKEY+21(4).</P><P>ACNUM = TABKEY+7(10)</P><P></P><P>2.</P><P>SY-MANDT = TABKEY(3).</P><P>BSTNR = TABKEY+3(8).</P><P>BUKRS = TABKEY+11(2).</P><P>EBELP = TABKEY+13(5).</P><P></P><P>3.</P><P>TABKEY(6) = POSNR.</P><P>TABKEY+3(10) = VBELN.</P><P>TABKEY+13(6) = POSNR.</P><P>TABKEY+19(4) = ITAB-ETENR.</P><P></P><P></P><P>4.</P><P>TABKEY = SY-MANDT+EKKO-EBELN</P></BODY></HTML> Mon, 29 Sep 2008 04:40:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/query-in-database-table/m-p/4534053#M1071381 Former Member 2008-09-29T04:40:30Z