topic SAP Internal Tables - Reading Data in Application Development and Automation Discussions

SAP Internal Tables - Reading Data

former_member645803 — Thu, 16 Jul 2020 09:06:20 GMT

Hello,

I have created an internal table AR and infoset field ARREARS. I am trying to get infoset field ARREARS to report the value in internal table AR field KUNNR. Can anyone please assist? The script I am using is below

DATA: ARS TYPE SORTED TABLE OF BSID WITH NON-UNIQUE KEY KKBER KUNNR.

DATA: AR TYPE BSID.

SELECT * FROM BSID INTO TABLE ARS.

CLEAR ARREARS.

READ TABLE ARS INTO AR WITH KEY KUNNR = '224560'.

ARREARS = AR-KUNNR.

Re: SAP Internal Tables - Reading Data

FredericGirod — Thu, 16 Jul 2020 09:24:17 GMT

ARREARS = '224560'

I don't understand the objective of this code

you could replace all this with

SELECT * 
into table @data(ars)
from bsis.

read table ars into @data(ar) with kunnr = ...

but this code is evil, and should be really optimized

Re: SAP Internal Tables - Reading Data

ponrajasekharan — Thu, 16 Jul 2020 09:26:22 GMT

Check the sy-subrc result .

Re: SAP Internal Tables - Reading Data

Abinathsiva — Thu, 16 Jul 2020 09:26:31 GMT

Hi,

Please use code button when using code in questions. Also follow coding standards, KUNNR data type mismatch could be reason pass value with preceding zero and try

Re: SAP Internal Tables - Reading Data

Sandra_Rossi — Thu, 16 Jul 2020 09:46:30 GMT

As S Abinath said: "Please use code button when using code in questions."

Re: SAP Internal Tables - Reading Data

Sandra_Rossi — Thu, 16 Jul 2020 09:48:41 GMT

Your question is completely unclear. Selecting data from the whole table BSID is non-sense -> please ask an "experienced" ABAP developer.