topic Re: Transparent table for Accounting Document Segment in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/transparent-table-for-accounting-document-segment/m-p/6860307#M1475631 <HTML><HEAD></HEAD><BODY><P><SPAN __default_attr="green" __jive_macro_name="color">Moderator message - Welcome to SCN. You should look at the secondary index tables: BSIS BSAS BSIK BSAK BSID BSAD These have most of the fields you will need; however, you may have to use the fiscal year, documenbt number and company code to go directly against BSEG and/or BKPF to get other fields. Rob</SPAN></P></BODY></HTML> Fri, 14 May 2010 18:02:16 GMT Former Member 2010-05-14T18:02:16Z Transparent table for Accounting Document Segment https://community.sap.com/t5/application-development-and-automation-discussions/transparent-table-for-accounting-document-segment/m-p/6860306#M1475630 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>I 've been tried to make a query or table join between BKPF (accounting document header) and BSEG (acc doc segment), however I cannot join a transparent table (BKPF) with a cluster table (BSEG). Is there any transparent table for accounting document segment??? Do you have a way to join them? PLease, help!</P><P></P><P>thank you</P><P></P><P>Carlos Mtz</P><P>SAP SD Consultant</P></BODY></HTML> Fri, 14 May 2010 17:39:37 GMT https://community.sap.com/t5/application-development-and-automation-discussions/transparent-table-for-accounting-document-segment/m-p/6860306#M1475630 Former Member 2010-05-14T17:39:37Z Re: Transparent table for Accounting Document Segment https://community.sap.com/t5/application-development-and-automation-discussions/transparent-table-for-accounting-document-segment/m-p/6860307#M1475631 <HTML><HEAD></HEAD><BODY><P><SPAN __default_attr="green" __jive_macro_name="color">Moderator message - Welcome to SCN. You should look at the secondary index tables: BSIS BSAS BSIK BSAK BSID BSAD These have most of the fields you will need; however, you may have to use the fiscal year, documenbt number and company code to go directly against BSEG and/or BKPF to get other fields. Rob</SPAN></P></BODY></HTML> Fri, 14 May 2010 18:02:16 GMT https://community.sap.com/t5/application-development-and-automation-discussions/transparent-table-for-accounting-document-segment/m-p/6860307#M1475631 Former Member 2010-05-14T18:02:16Z Re: Transparent table for Accounting Document Segment https://community.sap.com/t5/application-development-and-automation-discussions/transparent-table-for-accounting-document-segment/m-p/6860308#M1475632 <HTML><HEAD></HEAD><BODY><P>Thank you very much Rob...</P><P></P><P>regards!</P></BODY></HTML> Thu, 20 May 2010 18:17:33 GMT https://community.sap.com/t5/application-development-and-automation-discussions/transparent-table-for-accounting-document-segment/m-p/6860308#M1475632 Former Member 2010-05-20T18:17:33Z