ABAP Select data from SAP table PVALIDVERSNBOM 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 PVALIDVERSNBOM 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 PVALIDVERSNBOM. 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 PVALIDVERSNBOM 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_PVALIDVERSNBOM TYPE STANDARD TABLE OF PVALIDVERSNBOM,
      WA_PVALIDVERSNBOM TYPE PVALIDVERSNBOM,
      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: <PVALIDVERSNBOM> TYPE PVALIDVERSNBOM.

*Process all fields in table header/work area as string values
  PERFORM process_as_string_field_values CHANGING wa_PVALIDVERSNBOM.

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM PVALIDVERSNBOM
  INTO TABLE IT_PVALIDVERSNBOM.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM PVALIDVERSNBOM
*  INTO TABLE @DATA(IT_PVALIDVERSNBOM2).
*--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_PVALIDVERSNBOM INDEX 1 INTO DATA(WA_PVALIDVERSNBOM2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_PVALIDVERSNBOM ASSIGNING <PVALIDVERSNBOM>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<PVALIDVERSNBOM>-MANDT = 1.
<PVALIDVERSNBOM>-BILLOFMATERIALITEMUUID = 1.
<PVALIDVERSNBOM>-SAPCLIENT = 1.
<PVALIDVERSNBOM>-BILLOFMATERIALCATEGORY = 1.
<PVALIDVERSNBOM>-BILLOFMATERIAL = 1.
ENDLOOP.

LOOP AT IT_PVALIDVERSNBOM INTO WA_PVALIDVERSNBOM.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PVALIDVERSNBOM-BILLOFMATERIALVARIANT, sy-vline,
WA_PVALIDVERSNBOM-BILLOFMATERIALITEMNODENUMBER, sy-vline,
WA_PVALIDVERSNBOM-BOMITEMINTERNALCHANGECOUNT, sy-vline,
WA_PVALIDVERSNBOM-INHERITEDNODENUMBERFORBOMITEM, sy-vline,
WA_PVALIDVERSNBOM-INHERITEDNODENUMBERVERSIONBOM, sy-vline,
WA_PVALIDVERSNBOM-BILLOFMATERIALVERSION, sy-vline.
ENDLOOP. *Add any further fields from structure WA_PVALIDVERSNBOM 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_PVALIDVERSNBOM 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_PVALIDVERSNBOM INTO WA_PVALIDVERSNBOM. *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.

*Conversion exit NUMCV, internal->external for field BILLOFMATERIAL CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_PVALIDVERSNBOM-BILLOFMATERIAL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PVALIDVERSNBOM-BILLOFMATERIAL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field BILLOFMATERIALVARIANT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_PVALIDVERSNBOM-BILLOFMATERIALVARIANT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PVALIDVERSNBOM-BILLOFMATERIALVARIANT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field CHANGENUMBERFROM CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_PVALIDVERSNBOM-CHANGENUMBERFROM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PVALIDVERSNBOM-CHANGENUMBERFROM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field CHANGENUMBERTO CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_PVALIDVERSNBOM-CHANGENUMBERTO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PVALIDVERSNBOM-CHANGENUMBERTO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN1, internal->external for field BILLOFMATERIALCOMPONENT CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_PVALIDVERSNBOM-BILLOFMATERIALCOMPONENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PVALIDVERSNBOM-BILLOFMATERIALCOMPONENT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit NUMCV, internal->external for field BILLOFMATERIALITEMNUMBER CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_PVALIDVERSNBOM-BILLOFMATERIALITEMNUMBER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PVALIDVERSNBOM-BILLOFMATERIALITEMNUMBER.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field BILLOFMATERIALITEMUNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_PVALIDVERSNBOM-BILLOFMATERIALITEMUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PVALIDVERSNBOM-BILLOFMATERIALITEMUNIT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field OPSLEADTIMEOFFSETUNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_PVALIDVERSNBOM-OPSLEADTIMEOFFSETUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PVALIDVERSNBOM-OPSLEADTIMEOFFSETUNIT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field CREDITOR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_PVALIDVERSNBOM-CREDITOR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PVALIDVERSNBOM-CREDITOR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field COSTELEMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_PVALIDVERSNBOM-COSTELEMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PVALIDVERSNBOM-COSTELEMENT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field UNITOFMEASUREFORSIZE1TO3 CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_PVALIDVERSNBOM-UNITOFMEASUREFORSIZE1TO3 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PVALIDVERSNBOM-UNITOFMEASUREFORSIZE1TO3.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field UNITOFMEASUREFORVARSIZEITEM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_PVALIDVERSNBOM-UNITOFMEASUREFORVARSIZEITEM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PVALIDVERSNBOM-UNITOFMEASUREFORVARSIZEITEM.
WRITE:/ 'New Value:', ld_input.
ENDFORM. *&---------------------------------------------------------------------* *& Form process_as_string_field_values *&---------------------------------------------------------------------* FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO. TYPES: BEGIN OF T_PVALIDVERSNBOM_STR,
MANDT TYPE STRING,
BILLOFMATERIALITEMUUID TYPE STRING,
SAPCLIENT TYPE STRING,
BILLOFMATERIALCATEGORY TYPE STRING,
BILLOFMATERIAL TYPE STRING,
BILLOFMATERIALVARIANT TYPE STRING,
BILLOFMATERIALITEMNODENUMBER TYPE STRING,
BOMITEMINTERNALCHANGECOUNT TYPE STRING,
INHERITEDNODENUMBERFORBOMITEM TYPE STRING,
INHERITEDNODENUMBERVERSIONBOM TYPE STRING,
BILLOFMATERIALVERSION TYPE STRING,
VALIDITYSTARTDATE TYPE STRING,
VALIDITYENDDATE TYPE STRING,
CHANGENUMBERFROM TYPE STRING,
CHANGENUMBERTO TYPE STRING,
BOMITEMRECORDCREATIONDATE TYPE STRING,
BOMITEMCREATEDBYUSER TYPE STRING,
BOMITEMLASTCHANGEDATE TYPE STRING,
BOMITEMLASTCHANGEDBYUSER TYPE STRING,
BILLOFMATERIALCOMPONENT TYPE STRING,
BILLOFMATERIALITEMCATEGORY TYPE STRING,
BILLOFMATERIALITEMNUMBER TYPE STRING,
BILLOFMATERIALITEMUNIT TYPE STRING,
BILLOFMATERIALITEMQUANTITY TYPE STRING,
ISSUBITEM TYPE STRING,
SORTSTRING TYPE STRING,
BOMITEMSORTER TYPE STRING,
FIXEDQUANTITY TYPE STRING,
PURCHASINGGROUP TYPE STRING,
CURRENCY TYPE STRING,
MATERIALCOMPONENTPRICE TYPE STRING,
IDENTIFIERBOMITEM TYPE STRING,
MATERIALPRICEUNITQTY TYPE STRING,
COMPONENTSCRAPINPERCENT TYPE STRING,
OPERATIONSCRAPINPERCENT TYPE STRING,
ISNETSCRAP TYPE STRING,
NUMBEROFVARIABLESIZEITEM TYPE STRING,
QUANTITYVARIABLESIZEITEM TYPE STRING,
FORMULAKEY TYPE STRING,
BOMITEMDESCRIPTION TYPE STRING,
BOMITEMTEXT2 TYPE STRING,
MATERIALGROUP TYPE STRING,
CLASSNUMBER TYPE STRING,
CLASSTYPE TYPE STRING,
RESULTINGITEMCATEGORY TYPE STRING,
DEPENDENCYOBJECTNUMBER TYPE STRING,
OBJECTTYPE TYPE STRING,
ISCLASSIFICATIONRELEVANT TYPE STRING,
ISBULKMATERIAL TYPE STRING,
BOMITEMISSPAREPART TYPE STRING,
BOMITEMISSALESRELEVANT TYPE STRING,
ISPRODUCTIONRELEVANT TYPE STRING,
BOMITEMISPLANTMAINTRELEVANT TYPE STRING,
BOMITEMISCOSTINGRELEVANT TYPE STRING,
ISENGINEERINGRELEVANT TYPE STRING,
SPECIALPROCUREMENTTYPE TYPE STRING,
ISBOMRECURSIVEALLOWED TYPE STRING,
OPERATIONLEADTIMEOFFSET TYPE STRING,
OPSLEADTIMEOFFSETUNIT TYPE STRING,
BOMITEMCHANGEDATE TYPE STRING,
ISMATERIALPROVISION TYPE STRING,
BOMISRECURSIVE TYPE STRING,
DOCUMENTISCREATEDBYCAD TYPE STRING,
DISTRKEYCOMPCONSUMPTION TYPE STRING,
DELIVERYDURATIONINDAYS TYPE STRING,
CREDITOR TYPE STRING,
COSTELEMENT TYPE STRING,
SIZE1 TYPE STRING,
SIZE2 TYPE STRING,
SIZE3 TYPE STRING,
UNITOFMEASUREFORSIZE1TO3 TYPE STRING,
GOODSRECEIPTDURATION TYPE STRING,
PURCHASINGORGANIZATION TYPE STRING,
REQUIREDCOMPONENT TYPE STRING,
MULTIPLESELECTIONALLOWED TYPE STRING,
PRODORDERISSUELOCATION TYPE STRING,
MATERIALISCOPRODUCT TYPE STRING,
EXPLOSIONTYPE TYPE STRING,
ALTERNATIVEITEMGROUP TYPE STRING,
FOLLOWUPGROUP TYPE STRING,
DISCONTINUATIONGROUP TYPE STRING,
REINSURCONTRORGUNIT TYPE STRING,
ISCONFIGURABLEBOM TYPE STRING,
REFERENCEPOINT TYPE STRING,
LEADTIMEOFFSET TYPE STRING,
PRODUCTIONSUPPLYAREA TYPE STRING,
ISDELETED TYPE STRING,
ISALE TYPE STRING,
UNITOFMEASUREFORVARSIZEITEM TYPE STRING,
ISASSEMBLY TYPE STRING,
ISPHANTOMITEM TYPE STRING,END OF T_EKKO_STR. DATA: WA_PVALIDVERSNBOM_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_PVALIDVERSNBOM_STR-MANDT sy-vline
WA_PVALIDVERSNBOM_STR-BILLOFMATERIALITEMUUID sy-vline
WA_PVALIDVERSNBOM_STR-SAPCLIENT sy-vline
WA_PVALIDVERSNBOM_STR-BILLOFMATERIALCATEGORY sy-vline
WA_PVALIDVERSNBOM_STR-BILLOFMATERIAL sy-vline
WA_PVALIDVERSNBOM_STR-BILLOFMATERIALVARIANT sy-vline
WA_PVALIDVERSNBOM_STR-BILLOFMATERIALITEMNODENUMBER sy-vline
WA_PVALIDVERSNBOM_STR-BOMITEMINTERNALCHANGECOUNT sy-vline
WA_PVALIDVERSNBOM_STR-INHERITEDNODENUMBERFORBOMITEM sy-vline
WA_PVALIDVERSNBOM_STR-INHERITEDNODENUMBERVERSIONBOM sy-vline
WA_PVALIDVERSNBOM_STR-BILLOFMATERIALVERSION sy-vline
WA_PVALIDVERSNBOM_STR-VALIDITYSTARTDATE sy-vline
WA_PVALIDVERSNBOM_STR-VALIDITYENDDATE sy-vline
WA_PVALIDVERSNBOM_STR-CHANGENUMBERFROM sy-vline
WA_PVALIDVERSNBOM_STR-CHANGENUMBERTO sy-vline
WA_PVALIDVERSNBOM_STR-BOMITEMRECORDCREATIONDATE sy-vline
WA_PVALIDVERSNBOM_STR-BOMITEMCREATEDBYUSER sy-vline
WA_PVALIDVERSNBOM_STR-BOMITEMLASTCHANGEDATE sy-vline
WA_PVALIDVERSNBOM_STR-BOMITEMLASTCHANGEDBYUSER sy-vline
WA_PVALIDVERSNBOM_STR-BILLOFMATERIALCOMPONENT sy-vline
WA_PVALIDVERSNBOM_STR-BILLOFMATERIALITEMCATEGORY sy-vline
WA_PVALIDVERSNBOM_STR-BILLOFMATERIALITEMNUMBER sy-vline
WA_PVALIDVERSNBOM_STR-BILLOFMATERIALITEMUNIT sy-vline
WA_PVALIDVERSNBOM_STR-BILLOFMATERIALITEMQUANTITY sy-vline
WA_PVALIDVERSNBOM_STR-ISSUBITEM sy-vline
WA_PVALIDVERSNBOM_STR-SORTSTRING sy-vline
WA_PVALIDVERSNBOM_STR-BOMITEMSORTER sy-vline
WA_PVALIDVERSNBOM_STR-FIXEDQUANTITY sy-vline
WA_PVALIDVERSNBOM_STR-PURCHASINGGROUP sy-vline
WA_PVALIDVERSNBOM_STR-CURRENCY sy-vline
WA_PVALIDVERSNBOM_STR-MATERIALCOMPONENTPRICE sy-vline
WA_PVALIDVERSNBOM_STR-IDENTIFIERBOMITEM sy-vline
WA_PVALIDVERSNBOM_STR-MATERIALPRICEUNITQTY sy-vline
WA_PVALIDVERSNBOM_STR-COMPONENTSCRAPINPERCENT sy-vline
WA_PVALIDVERSNBOM_STR-OPERATIONSCRAPINPERCENT sy-vline
WA_PVALIDVERSNBOM_STR-ISNETSCRAP sy-vline
WA_PVALIDVERSNBOM_STR-NUMBEROFVARIABLESIZEITEM sy-vline
WA_PVALIDVERSNBOM_STR-QUANTITYVARIABLESIZEITEM sy-vline
WA_PVALIDVERSNBOM_STR-FORMULAKEY sy-vline
WA_PVALIDVERSNBOM_STR-BOMITEMDESCRIPTION sy-vline
WA_PVALIDVERSNBOM_STR-BOMITEMTEXT2 sy-vline
WA_PVALIDVERSNBOM_STR-MATERIALGROUP sy-vline
WA_PVALIDVERSNBOM_STR-CLASSNUMBER sy-vline
WA_PVALIDVERSNBOM_STR-CLASSTYPE sy-vline
WA_PVALIDVERSNBOM_STR-RESULTINGITEMCATEGORY sy-vline
WA_PVALIDVERSNBOM_STR-DEPENDENCYOBJECTNUMBER sy-vline
WA_PVALIDVERSNBOM_STR-OBJECTTYPE sy-vline
WA_PVALIDVERSNBOM_STR-ISCLASSIFICATIONRELEVANT sy-vline
WA_PVALIDVERSNBOM_STR-ISBULKMATERIAL sy-vline
WA_PVALIDVERSNBOM_STR-BOMITEMISSPAREPART sy-vline
WA_PVALIDVERSNBOM_STR-BOMITEMISSALESRELEVANT sy-vline
WA_PVALIDVERSNBOM_STR-ISPRODUCTIONRELEVANT sy-vline
WA_PVALIDVERSNBOM_STR-BOMITEMISPLANTMAINTRELEVANT sy-vline
WA_PVALIDVERSNBOM_STR-BOMITEMISCOSTINGRELEVANT sy-vline
WA_PVALIDVERSNBOM_STR-ISENGINEERINGRELEVANT sy-vline
WA_PVALIDVERSNBOM_STR-SPECIALPROCUREMENTTYPE sy-vline
WA_PVALIDVERSNBOM_STR-ISBOMRECURSIVEALLOWED sy-vline
WA_PVALIDVERSNBOM_STR-OPERATIONLEADTIMEOFFSET sy-vline
WA_PVALIDVERSNBOM_STR-OPSLEADTIMEOFFSETUNIT sy-vline
WA_PVALIDVERSNBOM_STR-BOMITEMCHANGEDATE sy-vline
WA_PVALIDVERSNBOM_STR-ISMATERIALPROVISION sy-vline
WA_PVALIDVERSNBOM_STR-BOMISRECURSIVE sy-vline
WA_PVALIDVERSNBOM_STR-DOCUMENTISCREATEDBYCAD sy-vline
WA_PVALIDVERSNBOM_STR-DISTRKEYCOMPCONSUMPTION sy-vline
WA_PVALIDVERSNBOM_STR-DELIVERYDURATIONINDAYS sy-vline
WA_PVALIDVERSNBOM_STR-CREDITOR sy-vline
WA_PVALIDVERSNBOM_STR-COSTELEMENT sy-vline
WA_PVALIDVERSNBOM_STR-SIZE1 sy-vline
WA_PVALIDVERSNBOM_STR-SIZE2 sy-vline
WA_PVALIDVERSNBOM_STR-SIZE3 sy-vline
WA_PVALIDVERSNBOM_STR-UNITOFMEASUREFORSIZE1TO3 sy-vline
WA_PVALIDVERSNBOM_STR-GOODSRECEIPTDURATION sy-vline
WA_PVALIDVERSNBOM_STR-PURCHASINGORGANIZATION sy-vline
WA_PVALIDVERSNBOM_STR-REQUIREDCOMPONENT sy-vline
WA_PVALIDVERSNBOM_STR-MULTIPLESELECTIONALLOWED sy-vline
WA_PVALIDVERSNBOM_STR-PRODORDERISSUELOCATION sy-vline
WA_PVALIDVERSNBOM_STR-MATERIALISCOPRODUCT sy-vline
WA_PVALIDVERSNBOM_STR-EXPLOSIONTYPE sy-vline
WA_PVALIDVERSNBOM_STR-ALTERNATIVEITEMGROUP sy-vline
WA_PVALIDVERSNBOM_STR-FOLLOWUPGROUP sy-vline
WA_PVALIDVERSNBOM_STR-DISCONTINUATIONGROUP sy-vline
WA_PVALIDVERSNBOM_STR-REINSURCONTRORGUNIT sy-vline
WA_PVALIDVERSNBOM_STR-ISCONFIGURABLEBOM sy-vline
WA_PVALIDVERSNBOM_STR-REFERENCEPOINT sy-vline
WA_PVALIDVERSNBOM_STR-LEADTIMEOFFSET sy-vline
WA_PVALIDVERSNBOM_STR-PRODUCTIONSUPPLYAREA sy-vline
WA_PVALIDVERSNBOM_STR-ISDELETED sy-vline
WA_PVALIDVERSNBOM_STR-ISALE sy-vline
WA_PVALIDVERSNBOM_STR-UNITOFMEASUREFORVARSIZEITEM sy-vline
WA_PVALIDVERSNBOM_STR-ISASSEMBLY sy-vline
WA_PVALIDVERSNBOM_STR-ISPHANTOMITEM sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.