Domain
» See all 3720 related threads
Nov 10 23

Generic Data Source using COEP and COBK Tables  

06:40 // Sasidhar Gunturu

Hi ,

I have a requirement to create a Generic DataSource based on the COEP and COBK tables. As these tables contain the currency fields i have to create a datasource based on the function module. I have copied from the standard function module RSAX_BIW_GET_DATA_SIMPLE and made changes .However it has thrown a short dump with the error description as "DBIF_RSQL_INVALID_RSQL". This might also because of large of records in the database tables COEP and COBK.Could you please help me a way of fetching data from these tables.Select statements i have used in the FM are as below .Highly appreciate your suggestions  this regard.

OPEN CURSOR WITH HOLD S_CURSOR FOR

     SELECT KOKRS

           BELNR

           BUZEI

           WTGBTR

          WOGBTR

           WKGBTR

           WKFBTR

          PAGBTR

           PAFBTR FROM COEP WHERE KOKRS IN L_R_KOKRS AND

                                   BELNR IN L_R_BELNR.

      SELECT KOKRS

           BELNR

           GJAHR

           PERAB

           PERBI

           BLDAT

           BUDAT

          REFBN FROM COBK INTO corresponding fields of TABLE IT_COBK

                       WHERE KOKRS IN L_R_KOKRS AND

                                  BELNR IN L_R_BELNR.

Regards,

Sasidhar Gunturu

 
Date Views Headline Answers
29.01.2013 118 bkpf-stblg extractION 6
28.01.2013 358 ORDERS05 idoc to file 8
23.01.2013 62 can't join tables using Calculated Attributes 3
23.01.2013 46 calculated attribute to combine BELNR (char -10) and GJAHR(numc-4) 2
22.01.2013 31 how to find billing document number against accounting document type AB? 2
17.01.2013 59 FF_5_Not clearing automatically(Collection Return)/Compensação não efetuada (Reto 4
17.01.2013 308 PO Number Wise MIGO MIRO Delivery Cost ( MIRO) Subsequent DR/CR ( MIRO) 9
15.01.2013 41 delete method in FIPP, not working 3
10.01.2013 29 Posting run Document Link with Travel request 3
10.01.2013 372 Call transaction for MIR7/MIRO using set parameter Id not working 11
09.01.2013 180 Working with MIRO 25
21.12.2012 122 Any BAPI or FM for FB03 transaction 4
19.12.2012 296 abap : problem in select query 12
18.12.2012 247 ABAP Programming Error  GETWA_NOT_ASSIGNED 9
17.12.2012 109 ABAP: not to remove duplicates values 4
17.12.2012 90 ABAP : report developed Problem basis of FS10n 4
14.12.2012 168 Payment Advice from SAP 1
14.12.2012 297 ABAP : getting problem in select queries 10
14.12.2012 185 Pulling data from multiple tables into one internal table. 10
13.12.2012 194 Dynamic internal table with special symbols 14
12.12.2012 84 ECC upgrade Native SQL statements 6
07.12.2012 322 pass internal table  in standard report select-option 16
07.12.2012 139 VF03- Accounting Doc Pop up not displayed 7
04.12.2012 167 How to process IDOC transaction (MIRO) in the foreground 8
03.12.2012 87 pr po gr ir report 3
01.12.2012 114 Electronic Bank Statement 7
27.11.2012 100 Various amount and unit field of FBL3N 8
26.11.2012 342 FBL1N Report 14
24.11.2012 146 RE :Issue in syntax errors in ABAP 5
23.11.2012 429 Program goes in Infinite loop 16
22.11.2012 135 Performance issue inner join vs FAE 4
20.11.2012 238 Structure RFPOSXEXT 9
19.11.2012 108 Making an effective Select 6
16.11.2012 38 How to write select statment for this? 1
15.11.2012 36 parameter id 2
15.11.2012 198 BW infosets and Multiprovider 8
15.11.2012 255 Z report is coming dumped 19
14.11.2012 353 SAP Report that displays both Vendor Invoice and PO info 3
12.11.2012 126 Field appears in purchasing document FBL1N. 3
12.11.2012 243 Fectching data in a optimised way from BKPF and BSEG. 11
09.11.2012 78 How to get BKPF-BELNR from VF01 / RV_INVOICE_DOCUMMENT_ADD 2
08.11.2012 72 Ordenação do boleto 3
08.11.2012 346 How to get Cost Center/Profit Center when the DataSource do not have the fields 12
06.11.2012 103 function modul for read follow-on Documents in TA MIR4 4
05.11.2012 77 How to retreive the items in the PO which are not delivered yet 8
05.11.2012 75 EBS Issue 5
03.11.2012 320 Edit multiple records in PSA Table/Error Stack 8
02.11.2012 192 Payroll and CATSDB Integration 9
02.11.2012 109 How to know whether the item has been invoiced for full amount? 12
30.10.2012 80 Same Custom fields in the uwl for different views 4
30.10.2012 92 PS Work flow for CJ30 and CJ37 and CJ32 1
29.10.2012 209 Tds is not showing as per std tcode 15
29.10.2012 390 SAP Note Nr. 9458. NO Batch input data for screen SAPLKACB 0002 4
25.10.2012 132 column modify in hana tables 3
25.10.2012 40 Suppress node for JDBC Update Message 4
25.10.2012 326 How to handle the large volumes of data retreived from BSEG 9
21.10.2012 210 Retrieving data from BSAK and BSIK 3
16.10.2012 168 MIRO and MIR4, using BADI MRM_WT_SPLIT_UPDATE 3
16.10.2012 228 Manual bank statement clear vendor invoices 11
15.10.2012 79 POSTING_INTERFACE_CLEARING 4
15.10.2012 186 GETWA_NOT_ASSIGNED 7
12.10.2012 116 Accounting document details 9
11.10.2012 283 SELECT with JOIN from internal tables? 15
11.10.2012 112 Tables not existing in DD03T? 7
10.10.2012 19 PDF conversion 3
09.10.2012 163 Export/Import Command 5
03.10.2012 96 Derivation of field "SEGMENT" from BSEG Table 4
01.10.2012 38 Performance problems with FI docs 1
21.09.2012 75 not getting any out put after waiting long time 2
21.09.2012 157 ABAP ZRF03 Report for offset accounting 5
20.09.2012 53 How to append last record for each invoice of internal table 2
18.09.2012 56 MIRO document line item against corresponding PO line item 4
17.09.2012 138 CRM Billing Question 14
13.09.2012 107 Payment Advice Selection Rule - OBCU 3
13.09.2012 71 Fetching Account Document Details 8
12.09.2012 195 DSO target for 2LIS_06_INV, key fields? 5
12.09.2012 44 idoc split issue 4
11.09.2012 244 Use One as Many 8
11.09.2012 313 how to solve the performance issue of FI report using BSEG and BKPF query ? 13
07.09.2012 37 IDOC Number Lost 2
07.09.2012 178 In my alv report values are repeating 7
05.09.2012 37 Down payment reduces vendor payment even though no goods receipt on PO 3
05.09.2012 312 Refresh is not working using cl_salv_table 8
05.09.2012 128 customer closing balance is not matching with std tcode fbl5n/fd10n 2
30.08.2012 57 help - fast connection in abap 3
28.08.2012 33 Infoset - join EKBE - VBFA 1
28.08.2012 112 Pass BSIS – BELNR to BSEG and get the “HKONT” starts with “4”... is th 7
24.08.2012 352 IDoc to CSV file help 9
24.08.2012 337 time out while fetching data from bkpf 15
21.08.2012 118 Mapping problem 13
20.08.2012 187 Uploading Documents through BDC ervery time loop is called. 12
17.08.2012 52 calling function module 'TABLE_ENTRIES_GET_VIA_RFC' 1
10.08.2012 443 Accounting and Internal Cash Document Number in FBCJ 3
09.08.2012 288 Issue processing return file Itau - Error Message FB002 7
09.08.2012 104 HU_PACKING_AND_UNPACKING 1
07.08.2012 189 Error while installing IDES 6.0 in the phase Import ABAP 4
06.08.2012 278 How change sales order with idoc 2
04.08.2012 162 Control Break help needed. 9
01.08.2012 176 How to avoid loop inside loop. 3
31.07.2012 262 F4 Help for Document Number 15

Feedback