Current Position:Home > join BSEG and VBRP

join BSEG and VBRP

  • BSEG to VBRP AND VBRK Updated:11-30

    Hello, I need to link sales orders in VBRP and VBRK to their respective GL line entries in BSEG.  Dos anyone have a SQL query that accomplishes this?  I'm not sure what the relationships are between BSEG and these sales tables. Any help would be grea

  • Join bseg to ekko and proj Updated:11-30

    have to link between 3modules.. MM,FI and PS. FROM MM : EKKO and EKPO FI : BKPF and BSEG PS : PROJ and PRPS. am able to get the data from MM but am not able to link from ekko to bkpf and to proj or from proj to bkpf or to ekko or ekpo. once i get the

  • BSEG Table join Updated:11-30

    Hi, Please help me to join BSEG and VBRK table in the SAP query(SQ02). Because there is an error as "Table BSEG cannot be used in a join". Regards, SanjayaHiya, BSEG is too massive, so SAP doesn't allow using it in queries. You may create some A

  • Error while activating the BSEG table Updated:10-11

    hi guys ,             today i joined SAP SCN . I have this error First i appended a structure of 5 fields in BSEG table .Then i tried to delete this append structure. But while deletiing it took nearly 20-25 minutes to process and timed out.So the st

  • How to get EKBE-BUDAT (GR Date) using data of BSEG Updated:10-11

    hI , My requirement is to get the GR date from EBKE which is in the field BUDAT. my report already has BSEG data , using that i want to get the EKBE-BUDAT. One of the Function person suggested this: Select LFBNR            LFPOS            LFGJA    F

  • Query on inner join Updated:11-30

    Hello experts, i 'd like to join the tables BKPF and BSEG using the joins concept. let me know the statement for this so that i get the output as desired. USING selection screen concept as well. BKPF-BELNR, BKPF-BUKRS BKPF-GJAHR ( FISCAL YEAR) BSEG-W

  • BSEG in a query Updated:11-30

    HI , I wanto to join BSEG and BKPF. And I cant use BSEG because is a Pool table. how can I solve it? any idea? Is urgent ..thanks! thanks a lot!Hi, You can't join BSEG as it is a Cluster Table.In the place of BSEG you can use: If you wants Account Re

  • Help with a join Updated:11-30

    I have the following code and it is giving me a syntax error.  I originally had it as a single join (I didn't have coep in it) and it worked.  This tells me that the issue is with the second join (coep).  I have no idea what it could be.   SELECT a~b

  • How can i join pool table to a cluster tables ? Updated:11-30

    Hi Experts, is it possible to join bseg to bkpf table if possible then please do help me with the required query for the same purpose. Thanks Aditya Rajput.Hi Aditya, There is nice blog on create joins for BSEG and BKPF. Refer to the link below Query

  • How to 'inner join' internal table or cluster table ?? Updated:11-30

    Hi, when i inner join table BSEG it said is a cluster table can't be inner joined . i wonder how i can "inner join" bseg with a internal table such as data: begin of i_bseg_trans,         bukrs like bseg-bukrs,         gjahr like bseg-gjahr,    

  • How do i join 3 table with the 'join' query ? Updated:11-30

    Hello, i want to join 3 tables -> bsis, bsad and vbrp the components of the query to be are , - select (matnr from vbrp) sum(amount from bsad). - join bsis and bsad on  bsisbukrs = bsadbukrs, bsisbelnr = bsadaugbl and bsisbldat = bsadaugdt. - where b

  • Report for payment due billing doc with taxes Updated:10-11

    Hi All, I want the report for payment due billing documents with following fields and after payment is done( F-28 )  that document should not appear in the report for the said period. Billing date, Billing doc no, Net value, Tax Amount Thanks and reg

  • List of invoices past due per sales order Updated:10-11

    Hello community, I am working on a report which is supposed to give me the following data: Invoices which are past due (invoice #), corresponding sales order # and the consulting manager (CEM) for that sales order. The CEMs are maintained in table VA

  • Export Screen to Flat Text file Updated:10-11

    Hello, I'm very new in SAP and need to modify a little program. I would like to export the current screen in a flat text file. The file must be stored on the SAP server ( /usr/sap/data/bel) so not on my local harddrive. I searched and found found fun

  • Sales report with gl numbers Updated:11-30

    Hi Gurus, I want to generate a report from SD showing details of Material description (items sold) and amount from G/L Numbers 400013, 400017, 400018, 400001 and 400005.with the gl number also displayed. pls help. thanks MaureenHi, You can get the De

  • Print smartform from background Updated:10-11

    Dear Experts, I have requirement to create delivery then create bill automatically so i open background job from program (A) and submit the creating program for bill (B) via this job what happened is the delivery creating is ok, the delivery printing

  • Alv Report for invoice details Updated:10-11

    Dear All,              I need to develop one alv report for following details. i developed coding for this requirment but i am getting some error.kindley help me to how to move data from different internal table to final internal table. I used LOOP A

  • In FBL5N report user wants the sales document number to be displayed, Updated:10-11

    HI, Guys Need ur help to sort out the problem In FBL5N report user wants the sales document number to be displayed, but the sales ducument number column is coming blank and this needs to pick from VBRP table As I discussed with Abaper, he reqiures a

  • Report to display purchase orders Updated:10-11

    Hi I am Venkat can any one send me report to display a list of Purchase orders open for period more than one year. I need the following output fields to be dispayed are Vendor, Period, Purchasing organization, PO number, Document date, GR status, che

  • Logic needed Updated:10-11

    I have a report in which most of condition types hard coded in the program and every time required modification on creation of new condition type. I wish to make this report flexi to show the values of all condition type of selected records. Wht step