ABAP Select data from SAP table /BIC/CCTA0000021191 into internal table
Get Example source ABAP code based on a different SAP table
Below is a number of ABAP code snippets to demonstrate how to select data from SAP /BIC/CCTA0000021191 table and store it within an internal table, including using the newer @DATA inline declaration methods. It also shows you various ways to process this data using ABAP work area, inline declaration or field symbols including executing all the relevant CONVERSION_EXIT routines specific to /BIC/CCTA0000021191. See here for more generic Select statement tips.
Sometimes data within SAP is stored within the database table in a different format to what it is displayed to the user. These input/output conversation FM routines are what translates the data between the two formats.
There is also a full declaration of the /BIC/CCTA0000021191 table where each field has a char/string type for you to simply copy and paste. This allows you to use processing that is only available to these field types such as the CONCATENATE statement.
DATA: IT_/BIC/CCTA0000021191 TYPE STANDARD TABLE OF /BIC/CCTA0000021191,
WA_/BIC/CCTA0000021191 TYPE /BIC/CCTA0000021191,
GD_STR TYPE STRING.
DATA: lo_typedescr type REF TO cl_abap_typedescr.
DATA: lv_fieldname type fieldname.
FIELD-SYMBOLS: <FIELD> TYPE any.
FIELD-SYMBOLS: </BIC/CCTA0000021191> TYPE /BIC/CCTA0000021191.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_/BIC/CCTA0000021191.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM /BIC/CCTA0000021191
INTO TABLE IT_/BIC/CCTA0000021191.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM /BIC/CCTA0000021191
* INTO TABLE @DATA(IT_/BIC/CCTA00000211912).
*--Further methods of using ABAP code to select data from SAP database tables
*You can also declare the header/work area using the in-line DATA declaration method
READ TABLE IT_/BIC/CCTA0000021191 INDEX 1 INTO DATA(WA_/BIC/CCTA00000211912).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/BIC/CCTA0000021191 ASSIGNING </BIC/CCTA0000021191>.
*To update a field value using a field symbol simply change the value via the field symbol pointer</BIC/CCTA0000021191>-MANDT = 1.
</BIC/CCTA0000021191>-VALUATION_AREA = 1.
</BIC/CCTA0000021191>-BUSTRANSID = 1.
</BIC/CCTA0000021191>-TRLFLOWNUMBER = 1.
</BIC/CCTA0000021191>-BUKRS = 1.
ENDLOOP. LOOP AT IT_/BIC/CCTA0000021191 INTO WA_/BIC/CCTA0000021191. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_/BIC/CCTA0000021191-TR_ACC_CODE, sy-vline,
WA_/BIC/CCTA0000021191-VALUATION_CLASS, sy-vline,
WA_/BIC/CCTA0000021191-GSART, sy-vline,
WA_/BIC/CCTA0000021191-PORTFOLIO, sy-vline,
WA_/BIC/CCTA0000021191-SECURITY_ID, sy-vline,
WA_/BIC/CCTA0000021191-LOANS_CONTRACT, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/BIC/CCTA0000021191 you want to display... WRITE:/ sy-uline. * Aternatively use generic code to Write field values (and NAME) to screen report DO. ASSIGN COMPONENT sy-index OF STRUCTURE wa_/BIC/CCTA0000021191 TO <field>. IF sy-subrc <> 0. EXIT. ENDIF. WRITE:/ 'Field Value', <field>, sy-vline. gd_str = <field> . lo_typedescr ?= CL_ABAP_DATADESCR=>DESCRIBE_BY_DATA( <field> ). lv_fieldname = lo_typedescr->GET_RELATIVE_NAME( ). WRITE:/ 'Field Name', lv_fieldname. ENDDO. *Redo loop but convert all fields from internal to out value LOOP AT IT_/BIC/CCTA0000021191 INTO WA_/BIC/CCTA0000021191. *Write horizonal line to screen report. WRITE:/ sy-uline. *Convert all fields to display/output versions using conversion routines PERFORM convert_all_field_values CHANGING wa_EKKO. ENDLOOP. *&---------------------------------------------------------------------* *& Form convert_all_field_values *&---------------------------------------------------------------------* FORM convert_all_field_values CHANGING p_EKKO LIKE wa_EKKO. DATA: ld_input(1000) TYPE c, ld_output(1000) TYPE C.
ENDFORM. *&---------------------------------------------------------------------* *& Form process_as_string_field_values *&---------------------------------------------------------------------* FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO. TYPES: BEGIN OF T_/BIC/CCTA0000021191_STR,
MANDT TYPE STRING,
VALUATION_AREA TYPE STRING,
BUSTRANSID TYPE STRING,
TRLFLOWNUMBER TYPE STRING,
BUKRS TYPE STRING,
TR_ACC_CODE TYPE STRING,
VALUATION_CLASS TYPE STRING,
GSART TYPE STRING,
PORTFOLIO TYPE STRING,
SECURITY_ID TYPE STRING,
LOANS_CONTRACT TYPE STRING,
DEAL_NUMBER TYPE STRING,
ACCOUNT_GROUP TYPE STRING,
SECURITY_ACCOUNT TYPE STRING,
POSITION_ACCOUNT TYPE STRING,
FLAG_LONG_SHORT TYPE STRING,
LOT_ID TYPE STRING,
DLOTGENERATION TYPE STRING,
TLOTGENERATION TYPE STRING,
LOTGENERATION_US TYPE STRING,
LOTGENERATION_CT TYPE STRING,
LOTPOS_INIT_DATE TYPE STRING,
LOTPOS_ORG_DATE TYPE STRING,
LOTGEN_DEALNR TYPE STRING,
FIKRS TYPE STRING,
FUND TYPE STRING,
GRANT_NBR TYPE STRING,
ACC_ASS_REF TYPE STRING,
HKONT TYPE STRING,
DBESTAND TYPE STRING,
SE_DEAL_NUMBER TYPE STRING,
RKONTRA TYPE STRING,
FLOW_TYPE TYPE STRING,
BUSTRANSCAT TYPE STRING,
GEN_BUSTRANSCAT TYPE STRING,
SOURCETARGET_FLG TYPE STRING,
QUANT_CAT TYPE STRING,
AMOUNT_CAT TYPE STRING,
TRL_BOOKINGSTATE TYPE STRING,
PL_CATEGORY TYPE STRING,
LEDGER_POST_STAT TYPE STRING,
BELNR TYPE STRING,
AWKEY TYPE STRING,
GL_ACCOUNT_D TYPE STRING,
GL_ACCOUNT_C TYPE STRING,
DBUDAT TYPE STRING,
DGJAHR TYPE STRING,
DMONAT TYPE STRING,
PERIO TYPE STRING,
SZBMETH TYPE STRING,
SSOLHAB TYPE STRING,
SHWHR TYPE STRING,
SVWHR TYPE STRING,
SBWHR TYPE STRING,
PLWHR TYPE STRING,
D_UNITS TYPE STRING,
D_NOMINAL_AMT_PC TYPE STRING,
D_NOMINAL_ORG_PC TYPE STRING,
D_PURCH_PC TYPE STRING,
D_PURCH_LC TYPE STRING,
D_PURCH_VC TYPE STRING,
D_AQU_VAL_PC TYPE STRING,
D_AQU_VAL_LC TYPE STRING,
D_AQU_VAL_VC TYPE STRING,
D_BOOK_VAL_PC TYPE STRING,
D_BOOK_VAL_LC TYPE STRING,
D_BOOK_VAL_VC TYPE STRING,
D_CHARGE_PC TYPE STRING,
D_CHARGE_LC TYPE STRING,
D_CHARGE_VC TYPE STRING,
D_BOOK_VAL_EX_PC TYPE STRING,
D_BOOK_VAL_EX_LC TYPE STRING,
D_BOOK_VAL_EX_VC TYPE STRING,
D_VAL_TI_PC TYPE STRING,
D_VAL_TI_LC TYPE STRING,
D_VAL_TI_VC TYPE STRING,
D_VAL_FX_LC TYPE STRING,
D_VAL_FX_VC TYPE STRING,
D_VALFXAAQUVL_LC TYPE STRING,
D_VALFXAAQUVL_VC TYPE STRING,
D_VAL_CH_TI_PC TYPE STRING,
D_VAL_CH_TI_LC TYPE STRING,
D_VAL_CH_TI_VC TYPE STRING,
D_VAL_CH_FX_LC TYPE STRING,
D_VAL_CH_FX_VC TYPE STRING,
D_AMORT_PC TYPE STRING,
D_AMORT_LC TYPE STRING,
D_AMORT_VC TYPE STRING,
D_IMPMNT_PC TYPE STRING,
D_IMPMNT_LC TYPE STRING,
D_IMPMNT_VC TYPE STRING,
D_IMPMNT_FX_LC TYPE STRING,
D_IMPMNT_FX_VC TYPE STRING,
D_REPAYMENT_PC TYPE STRING,
D_REPAYMENT_LC TYPE STRING,
D_REPAYMENT_VC TYPE STRING,
D_AMAQU_VAL_PC TYPE STRING,
D_AMAQU_VAL_LC TYPE STRING,
D_AMAQU_VAL_VC TYPE STRING,
D_DISAGIO_PC TYPE STRING,
D_DISAGIO_LC TYPE STRING,
D_DISAGIO_VC TYPE STRING,
D_VAL_TI_NPL_PC TYPE STRING,
D_VAL_TI_NPL_LC TYPE STRING,
D_VAL_TI_NPL_VC TYPE STRING,
D_VAL_FX_NPL_LC TYPE STRING,
D_VAL_FX_NPL_VC TYPE STRING,
D_VAL_CH_TI_N_PC TYPE STRING,
D_VAL_CH_TI_N_LC TYPE STRING,
D_VAL_CH_TI_N_VC TYPE STRING,
D_VAL_CH_FX_N_LC TYPE STRING,
D_VAL_CH_FX_N_VC TYPE STRING,
D_VARMAR_PC TYPE STRING,
D_VARMAR_LC TYPE STRING,
D_VARMAR_VC TYPE STRING,
D_SPOTVALP_LC TYPE STRING,
D_SPOTVALP_VC TYPE STRING,
D_SPOTVALS_LC TYPE STRING,
D_SPOTVALS_VC TYPE STRING,
D_SWAPACC_PC TYPE STRING,
D_SWAPACC_LC TYPE STRING,
D_SWAPACC_VC TYPE STRING,
D_SWAPVAL_LC TYPE STRING,
D_SWAPVAL_VC TYPE STRING,
AMOUNT_PC TYPE STRING,
AMOUNT_LC TYPE STRING,
AMOUNT_VC TYPE STRING,
PLAMOUNT_PLC TYPE STRING,
PLAMOUNT_LC TYPE STRING,
UPDMOD TYPE STRING,END OF T_EKKO_STR. DATA: WA_/BIC/CCTA0000021191_STR type T_EKKO_STR. DATA: ld_text TYPE string. LOOP AT IT_EKKO INTO WA_EKKO. MOVE-CORRESPONDING wa_EKKO TO WA_EKKO_STR. CONCATENATE: sy-vline
WA_/BIC/CCTA0000021191_STR-MANDT sy-vline
WA_/BIC/CCTA0000021191_STR-VALUATION_AREA sy-vline
WA_/BIC/CCTA0000021191_STR-BUSTRANSID sy-vline
WA_/BIC/CCTA0000021191_STR-TRLFLOWNUMBER sy-vline
WA_/BIC/CCTA0000021191_STR-BUKRS sy-vline
WA_/BIC/CCTA0000021191_STR-TR_ACC_CODE sy-vline
WA_/BIC/CCTA0000021191_STR-VALUATION_CLASS sy-vline
WA_/BIC/CCTA0000021191_STR-GSART sy-vline
WA_/BIC/CCTA0000021191_STR-PORTFOLIO sy-vline
WA_/BIC/CCTA0000021191_STR-SECURITY_ID sy-vline
WA_/BIC/CCTA0000021191_STR-LOANS_CONTRACT sy-vline
WA_/BIC/CCTA0000021191_STR-DEAL_NUMBER sy-vline
WA_/BIC/CCTA0000021191_STR-ACCOUNT_GROUP sy-vline
WA_/BIC/CCTA0000021191_STR-SECURITY_ACCOUNT sy-vline
WA_/BIC/CCTA0000021191_STR-POSITION_ACCOUNT sy-vline
WA_/BIC/CCTA0000021191_STR-FLAG_LONG_SHORT sy-vline
WA_/BIC/CCTA0000021191_STR-LOT_ID sy-vline
WA_/BIC/CCTA0000021191_STR-DLOTGENERATION sy-vline
WA_/BIC/CCTA0000021191_STR-TLOTGENERATION sy-vline
WA_/BIC/CCTA0000021191_STR-LOTGENERATION_US sy-vline
WA_/BIC/CCTA0000021191_STR-LOTGENERATION_CT sy-vline
WA_/BIC/CCTA0000021191_STR-LOTPOS_INIT_DATE sy-vline
WA_/BIC/CCTA0000021191_STR-LOTPOS_ORG_DATE sy-vline
WA_/BIC/CCTA0000021191_STR-LOTGEN_DEALNR sy-vline
WA_/BIC/CCTA0000021191_STR-FIKRS sy-vline
WA_/BIC/CCTA0000021191_STR-FUND sy-vline
WA_/BIC/CCTA0000021191_STR-GRANT_NBR sy-vline
WA_/BIC/CCTA0000021191_STR-ACC_ASS_REF sy-vline
WA_/BIC/CCTA0000021191_STR-HKONT sy-vline
WA_/BIC/CCTA0000021191_STR-DBESTAND sy-vline
WA_/BIC/CCTA0000021191_STR-SE_DEAL_NUMBER sy-vline
WA_/BIC/CCTA0000021191_STR-RKONTRA sy-vline
WA_/BIC/CCTA0000021191_STR-FLOW_TYPE sy-vline
WA_/BIC/CCTA0000021191_STR-BUSTRANSCAT sy-vline
WA_/BIC/CCTA0000021191_STR-GEN_BUSTRANSCAT sy-vline
WA_/BIC/CCTA0000021191_STR-SOURCETARGET_FLG sy-vline
WA_/BIC/CCTA0000021191_STR-QUANT_CAT sy-vline
WA_/BIC/CCTA0000021191_STR-AMOUNT_CAT sy-vline
WA_/BIC/CCTA0000021191_STR-TRL_BOOKINGSTATE sy-vline
WA_/BIC/CCTA0000021191_STR-PL_CATEGORY sy-vline
WA_/BIC/CCTA0000021191_STR-LEDGER_POST_STAT sy-vline
WA_/BIC/CCTA0000021191_STR-BELNR sy-vline
WA_/BIC/CCTA0000021191_STR-AWKEY sy-vline
WA_/BIC/CCTA0000021191_STR-GL_ACCOUNT_D sy-vline
WA_/BIC/CCTA0000021191_STR-GL_ACCOUNT_C sy-vline
WA_/BIC/CCTA0000021191_STR-DBUDAT sy-vline
WA_/BIC/CCTA0000021191_STR-DGJAHR sy-vline
WA_/BIC/CCTA0000021191_STR-DMONAT sy-vline
WA_/BIC/CCTA0000021191_STR-PERIO sy-vline
WA_/BIC/CCTA0000021191_STR-SZBMETH sy-vline
WA_/BIC/CCTA0000021191_STR-SSOLHAB sy-vline
WA_/BIC/CCTA0000021191_STR-SHWHR sy-vline
WA_/BIC/CCTA0000021191_STR-SVWHR sy-vline
WA_/BIC/CCTA0000021191_STR-SBWHR sy-vline
WA_/BIC/CCTA0000021191_STR-PLWHR sy-vline
WA_/BIC/CCTA0000021191_STR-D_UNITS sy-vline
WA_/BIC/CCTA0000021191_STR-D_NOMINAL_AMT_PC sy-vline
WA_/BIC/CCTA0000021191_STR-D_NOMINAL_ORG_PC sy-vline
WA_/BIC/CCTA0000021191_STR-D_PURCH_PC sy-vline
WA_/BIC/CCTA0000021191_STR-D_PURCH_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_PURCH_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_AQU_VAL_PC sy-vline
WA_/BIC/CCTA0000021191_STR-D_AQU_VAL_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_AQU_VAL_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_BOOK_VAL_PC sy-vline
WA_/BIC/CCTA0000021191_STR-D_BOOK_VAL_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_BOOK_VAL_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_CHARGE_PC sy-vline
WA_/BIC/CCTA0000021191_STR-D_CHARGE_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_CHARGE_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_BOOK_VAL_EX_PC sy-vline
WA_/BIC/CCTA0000021191_STR-D_BOOK_VAL_EX_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_BOOK_VAL_EX_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VAL_TI_PC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VAL_TI_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VAL_TI_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VAL_FX_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VAL_FX_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VALFXAAQUVL_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VALFXAAQUVL_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VAL_CH_TI_PC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VAL_CH_TI_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VAL_CH_TI_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VAL_CH_FX_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VAL_CH_FX_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_AMORT_PC sy-vline
WA_/BIC/CCTA0000021191_STR-D_AMORT_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_AMORT_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_IMPMNT_PC sy-vline
WA_/BIC/CCTA0000021191_STR-D_IMPMNT_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_IMPMNT_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_IMPMNT_FX_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_IMPMNT_FX_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_REPAYMENT_PC sy-vline
WA_/BIC/CCTA0000021191_STR-D_REPAYMENT_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_REPAYMENT_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_AMAQU_VAL_PC sy-vline
WA_/BIC/CCTA0000021191_STR-D_AMAQU_VAL_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_AMAQU_VAL_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_DISAGIO_PC sy-vline
WA_/BIC/CCTA0000021191_STR-D_DISAGIO_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_DISAGIO_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VAL_TI_NPL_PC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VAL_TI_NPL_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VAL_TI_NPL_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VAL_FX_NPL_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VAL_FX_NPL_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VAL_CH_TI_N_PC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VAL_CH_TI_N_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VAL_CH_TI_N_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VAL_CH_FX_N_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VAL_CH_FX_N_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VARMAR_PC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VARMAR_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_VARMAR_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_SPOTVALP_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_SPOTVALP_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_SPOTVALS_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_SPOTVALS_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_SWAPACC_PC sy-vline
WA_/BIC/CCTA0000021191_STR-D_SWAPACC_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_SWAPACC_VC sy-vline
WA_/BIC/CCTA0000021191_STR-D_SWAPVAL_LC sy-vline
WA_/BIC/CCTA0000021191_STR-D_SWAPVAL_VC sy-vline
WA_/BIC/CCTA0000021191_STR-AMOUNT_PC sy-vline
WA_/BIC/CCTA0000021191_STR-AMOUNT_LC sy-vline
WA_/BIC/CCTA0000021191_STR-AMOUNT_VC sy-vline
WA_/BIC/CCTA0000021191_STR-PLAMOUNT_PLC sy-vline
WA_/BIC/CCTA0000021191_STR-PLAMOUNT_LC sy-vline
WA_/BIC/CCTA0000021191_STR-UPDMOD sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.