ABAP Select data from SAP table PCMMPNLBPSUM 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 PCMMPNLBPSUM 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 PCMMPNLBPSUM. 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 PCMMPNLBPSUM 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_PCMMPNLBPSUM TYPE STANDARD TABLE OF PCMMPNLBPSUM,
      WA_PCMMPNLBPSUM TYPE PCMMPNLBPSUM,
      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: <PCMMPNLBPSUM> TYPE PCMMPNLBPSUM.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM PCMMPNLBPSUM
*  INTO TABLE @DATA(IT_PCMMPNLBPSUM2).
*--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_PCMMPNLBPSUM INDEX 1 INTO DATA(WA_PCMMPNLBPSUM2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_PCMMPNLBPSUM ASSIGNING <PCMMPNLBPSUM>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<PCMMPNLBPSUM>-MANDT = 1.
<PCMMPNLBPSUM>-PRICINGKEY = 1.
<PCMMPNLBPSUM>-VERSION = 1.
<PCMMPNLBPSUM>-PRICINGDOCUMENTITEM = 1.
<PCMMPNLBPSUM>-CONDITIONTYPE = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PCMMPNLBPSUM-SUBCONDITIONTYPE, sy-vline,
WA_PCMMPNLBPSUM-VERSSTOCKRECORDUUID, sy-vline,
WA_PCMMPNLBPSUM-BEGINNINGPOSBROUGHTFORWARDVAL, sy-vline,
WA_PCMMPNLBPSUM-MARKETPRICEBROUGHTFWDVAL, sy-vline,
WA_PCMMPNLBPSUM-SPREADBROUGHTFORWARDVAL, sy-vline,
WA_PCMMPNLBPSUM-MKTTOSTSTCFXBROUGHTFWDVAL, sy-vline.
ENDLOOP. *Add any further fields from structure WA_PCMMPNLBPSUM 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_PCMMPNLBPSUM 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_PCMMPNLBPSUM INTO WA_PCMMPNLBPSUM. *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 ALPHA, internal->external for field MKTDRVTVCONTRMATURITYCODE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_PCMMPNLBPSUM-MKTDRVTVCONTRMATURITYCODE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PCMMPNLBPSUM-MKTDRVTVCONTRMATURITYCODE.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field CMMDTYPRICEEXPSRVOLUMEUNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_PCMMPNLBPSUM-CMMDTYPRICEEXPSRVOLUMEUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PCMMPNLBPSUM-CMMDTYPRICEEXPSRVOLUMEUNIT.
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_PCMMPNLBPSUM_STR,
MANDT TYPE STRING,
PRICINGKEY TYPE STRING,
VERSION TYPE STRING,
PRICINGDOCUMENTITEM TYPE STRING,
CONDITIONTYPE TYPE STRING,
SUBCONDITIONTYPE TYPE STRING,
VERSSTOCKRECORDUUID TYPE STRING,
BEGINNINGPOSBROUGHTFORWARDVAL TYPE STRING,
MARKETPRICEBROUGHTFWDVAL TYPE STRING,
SPREADBROUGHTFORWARDVAL TYPE STRING,
MKTTOSTSTCFXBROUGHTFWDVAL TYPE STRING,
DOCTOSTSTCFXBROUGHTFWDVAL TYPE STRING,
MKTVALADJMTFXBROUGHTFWDVAL TYPE STRING,
COMMODITYQUANTITYINTERMUNIT TYPE STRING,
MARKETCONDITIONTERMRATE TYPE STRING,
COMPARMKTCONDITIONTERMRATE TYPE STRING,
CONTRSPREADCNDNTERMRATE TYPE STRING,
COMPARCONTRSPREADCNDNTERMRATE TYPE STRING,
FIXEDMKTSPREADCNDNTERMRATE TYPE STRING,
FLOATINGMKTSPREADCNDNTERMRATE TYPE STRING,
SPREADCURRENCY TYPE STRING,
MKTDOCTOSTSTCEXCHRATE TYPE STRING,
COMPARMKTDOCTOSTSTCEXCHRATE TYPE STRING,
MKTMARKETTODOCEXCHRATE TYPE STRING,
COMPARMKTMARKETTODOCEXCHRATE TYPE STRING,
MKTMARKETTOSTSTCEXCHRATE TYPE STRING,
COMPARMKTMARKETTOSTSTCEXCHRATE TYPE STRING,
CONTRACTMKTTODOCEXCHRATE TYPE STRING,
MKTADJMTVALUECNDNTERMVALUE TYPE STRING,
MKTADJMTVALDOCTOSTSTCEXCHRATE TYPE STRING,
CONTRACTCONDITIONTERMRATE TYPE STRING,
COMPARCONTRCNDNTERMRATE TYPE STRING,
EVALUATIONDATE TYPE STRING,
COMPARATIVEEVALUATIONDATE TYPE STRING,
MARKETDCS TYPE STRING,
MKTMARKETIDENTIFIERCODE TYPE STRING,
MKTDRVTVCONTRMATURITYCODE TYPE STRING,
MKTMATURITYKEYDATE TYPE STRING,
MARKETBASISTYPE TYPE STRING,
MARKETBASISID TYPE STRING,
MKTQUOTATIONPRICETYPE TYPE STRING,
HASERROR TYPE STRING,
SYSTEMMESSAGENUMBER TYPE STRING,
MTMDATASOURCETYPE TYPE STRING,
VALIDITYSTARTDATE TYPE STRING,
VALIDITYSTARTDATETIME TYPE STRING,
VALIDITYENDDATE TYPE STRING,
VALIDITYENDDATETIME TYPE STRING,
SOURCETRANSACTIONEVENTDATETIME TYPE STRING,
SOURCETRANSACEVENTENDDATETIME TYPE STRING,
ENDOFDAYBUSINESSENTITYKEY TYPE STRING,
COMPANYCODE TYPE STRING,
SALESORGANIZATION TYPE STRING,
DISTRIBUTIONCHANNEL TYPE STRING,
DIVISION TYPE STRING,
CREDITOR TYPE STRING,
SOLDTOPARTY TYPE STRING,
MATERIAL TYPE STRING,
PHYSICALCOMMODITY TYPE STRING,
PLANT TYPE STRING,
STORAGELOCATION TYPE STRING,
BATCH TYPE STRING,
INCOTERMSCLASSIFICATION TYPE STRING,
INCOTERMSTRANSFERLOCATION TYPE STRING,
CONDITIONAPPLICATION TYPE STRING,
SOURCEDOCUMENT TYPE STRING,
SOURCEDOCUMENTITEM TYPE STRING,
SOURCEDOCUMENTBUSOBJTYPE TYPE STRING,
ORIGINREFERENCEDOCUMENT TYPE STRING,
ORIGINREFERENCEDOCUMENTITEM TYPE STRING,
ORIGINREFERENCEDOCBUSOBJTYPE TYPE STRING,
REFERENCEDOCUMENT TYPE STRING,
REFERENCEDOCUMENTITEM TYPE STRING,
REFERENCEDOCBUSOBJTYPE TYPE STRING,
DELIVERYDATE TYPE STRING,
EXPECTEDPAYMENTDATE TYPE STRING,
STATISTICSCURRENCY TYPE STRING,
DOCUMENTCURRENCY TYPE STRING,
PROFITCENTER TYPE STRING,
BUSINESSAREA TYPE STRING,
PURCHASINGORGANIZATION TYPE STRING,
MATERIALGROUP TYPE STRING,
ISINTERCOMPANYTRANSFER TYPE STRING,
CONDITIONCALCULATIONTYPE TYPE STRING,
CONDITIONRATE TYPE STRING,
CONDITIONCURRENCY TYPE STRING,
CONDITIONQUANTITY TYPE STRING,
CONDITIONQUANTITYUNIT TYPE STRING,
CONDITIONTERMRATE TYPE STRING,
CONDITIONTERMRATECURRENCY TYPE STRING,
CONDITIONTERMRATEQUANTITY TYPE STRING,
CONDITIONTERMRATEQUANTITYUNIT TYPE STRING,
CONDITIONTERMVALUE TYPE STRING,
CONDITIONTERMVALUECURRENCY TYPE STRING,
CONDITIONTERMNAME TYPE STRING,
CONDITIONTERMSTATUS TYPE STRING,
ROUNDINGDECIMALPLACES TYPE STRING,
CONDITIONTERMRATEISROUNDED TYPE STRING,
CONDITIONTERMRATENMRTR TYPE STRING,
CONDITIONTERMRATEDNMNTR TYPE STRING,
CONDITIONTERMEXTENSIONUSAGE TYPE STRING,
MATURITYSELECTIONTYPE TYPE STRING,
EXCHRATEMATURITYDATE TYPE STRING,
FIXEDEXCHRATEDATE TYPE STRING,
QUOTATIONKEYTYPE TYPE STRING,
QUOTATIONDATELIST TYPE STRING,
QUOTATIONPERIODSTARTDATE TYPE STRING,
QUOTATIONPERIODENDDATE TYPE STRING,
COMPARATIVEMARKETDCS TYPE STRING,
COMPARMKTMARKETIDENTIFIERCODE TYPE STRING,
COMPARMKTMATURITYKEYDATE TYPE STRING,
COMPARMKTDRVTVCONTRCODE TYPE STRING,
COMPARMARKETBASISID TYPE STRING,
COMPARMARKETBASISTYPE TYPE STRING,
COMPARMKTQUOTATIONPRICETYPE TYPE STRING,
QUOTATIONPERIODREFERENCEDATE TYPE STRING,
COMPARQTANPERIODREFERENCEDATE TYPE STRING,
QUOTATIONGROUP TYPE STRING,
QUOTATIONGROUPCALCULATIONRULE TYPE STRING,
CONDITIONTERMRATEFIXATION TYPE STRING,
PRICINGSTATUS TYPE STRING,
CNDNTERMRATEFIXATIONDATE TYPE STRING,
CNDNTERMRATEFIXATIONTIME TYPE STRING,
CNDNTERMEXCHRATEFIXATIONDATE TYPE STRING,
CNDNTERMEXCHRATEFIXATIONTIME TYPE STRING,
COMMODITYQUANTITY TYPE STRING,
COMMODITYUNIT TYPE STRING,
QUANTITYSIGN TYPE STRING,
MTMCONDITIONGROUPCATEGORY TYPE STRING,
MTMCONDITIONGROUP TYPE STRING,
MTMCALCULATIONGROUP TYPE STRING,
MTMADJUSTMENTTYPE TYPE STRING,
MTMCALCGRPMARKETPRICECONDITION TYPE STRING,
CONDITIONTERMRATEISFIXED TYPE STRING,
CONDITIONTERMEXCHRATEISFIXED TYPE STRING,
PRICEISREALIZED TYPE STRING,
PNLEVENTCATEGORY TYPE STRING,
PNLEVENTTYPE TYPE STRING,
COMPARIMPLICITFIXATION TYPE STRING,
IMPLICITFIXATION TYPE STRING,
CONDITIONTERMFACTOR TYPE STRING,
COMPARCONDITIONTERMFACTOR TYPE STRING,
CMMDTYPRICEEXPSRMASSUNIT TYPE STRING,
CMMDTYPRICEEXPSRQTYINMASSUNIT TYPE STRING,
CMMDTYPRICEEXPSRVOLUMEUNIT TYPE STRING,
CMMDTYPRICEEXPSRQTYINVOLUNIT TYPE STRING,END OF T_EKKO_STR. DATA: WA_PCMMPNLBPSUM_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_PCMMPNLBPSUM_STR-MANDT sy-vline
WA_PCMMPNLBPSUM_STR-PRICINGKEY sy-vline
WA_PCMMPNLBPSUM_STR-VERSION sy-vline
WA_PCMMPNLBPSUM_STR-PRICINGDOCUMENTITEM sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONTYPE sy-vline
WA_PCMMPNLBPSUM_STR-SUBCONDITIONTYPE sy-vline
WA_PCMMPNLBPSUM_STR-VERSSTOCKRECORDUUID sy-vline
WA_PCMMPNLBPSUM_STR-BEGINNINGPOSBROUGHTFORWARDVAL sy-vline
WA_PCMMPNLBPSUM_STR-MARKETPRICEBROUGHTFWDVAL sy-vline
WA_PCMMPNLBPSUM_STR-SPREADBROUGHTFORWARDVAL sy-vline
WA_PCMMPNLBPSUM_STR-MKTTOSTSTCFXBROUGHTFWDVAL sy-vline
WA_PCMMPNLBPSUM_STR-DOCTOSTSTCFXBROUGHTFWDVAL sy-vline
WA_PCMMPNLBPSUM_STR-MKTVALADJMTFXBROUGHTFWDVAL sy-vline
WA_PCMMPNLBPSUM_STR-COMMODITYQUANTITYINTERMUNIT sy-vline
WA_PCMMPNLBPSUM_STR-MARKETCONDITIONTERMRATE sy-vline
WA_PCMMPNLBPSUM_STR-COMPARMKTCONDITIONTERMRATE sy-vline
WA_PCMMPNLBPSUM_STR-CONTRSPREADCNDNTERMRATE sy-vline
WA_PCMMPNLBPSUM_STR-COMPARCONTRSPREADCNDNTERMRATE sy-vline
WA_PCMMPNLBPSUM_STR-FIXEDMKTSPREADCNDNTERMRATE sy-vline
WA_PCMMPNLBPSUM_STR-FLOATINGMKTSPREADCNDNTERMRATE sy-vline
WA_PCMMPNLBPSUM_STR-SPREADCURRENCY sy-vline
WA_PCMMPNLBPSUM_STR-MKTDOCTOSTSTCEXCHRATE sy-vline
WA_PCMMPNLBPSUM_STR-COMPARMKTDOCTOSTSTCEXCHRATE sy-vline
WA_PCMMPNLBPSUM_STR-MKTMARKETTODOCEXCHRATE sy-vline
WA_PCMMPNLBPSUM_STR-COMPARMKTMARKETTODOCEXCHRATE sy-vline
WA_PCMMPNLBPSUM_STR-MKTMARKETTOSTSTCEXCHRATE sy-vline
WA_PCMMPNLBPSUM_STR-COMPARMKTMARKETTOSTSTCEXCHRATE sy-vline
WA_PCMMPNLBPSUM_STR-CONTRACTMKTTODOCEXCHRATE sy-vline
WA_PCMMPNLBPSUM_STR-MKTADJMTVALUECNDNTERMVALUE sy-vline
WA_PCMMPNLBPSUM_STR-MKTADJMTVALDOCTOSTSTCEXCHRATE sy-vline
WA_PCMMPNLBPSUM_STR-CONTRACTCONDITIONTERMRATE sy-vline
WA_PCMMPNLBPSUM_STR-COMPARCONTRCNDNTERMRATE sy-vline
WA_PCMMPNLBPSUM_STR-EVALUATIONDATE sy-vline
WA_PCMMPNLBPSUM_STR-COMPARATIVEEVALUATIONDATE sy-vline
WA_PCMMPNLBPSUM_STR-MARKETDCS sy-vline
WA_PCMMPNLBPSUM_STR-MKTMARKETIDENTIFIERCODE sy-vline
WA_PCMMPNLBPSUM_STR-MKTDRVTVCONTRMATURITYCODE sy-vline
WA_PCMMPNLBPSUM_STR-MKTMATURITYKEYDATE sy-vline
WA_PCMMPNLBPSUM_STR-MARKETBASISTYPE sy-vline
WA_PCMMPNLBPSUM_STR-MARKETBASISID sy-vline
WA_PCMMPNLBPSUM_STR-MKTQUOTATIONPRICETYPE sy-vline
WA_PCMMPNLBPSUM_STR-HASERROR sy-vline
WA_PCMMPNLBPSUM_STR-SYSTEMMESSAGENUMBER sy-vline
WA_PCMMPNLBPSUM_STR-MTMDATASOURCETYPE sy-vline
WA_PCMMPNLBPSUM_STR-VALIDITYSTARTDATE sy-vline
WA_PCMMPNLBPSUM_STR-VALIDITYSTARTDATETIME sy-vline
WA_PCMMPNLBPSUM_STR-VALIDITYENDDATE sy-vline
WA_PCMMPNLBPSUM_STR-VALIDITYENDDATETIME sy-vline
WA_PCMMPNLBPSUM_STR-SOURCETRANSACTIONEVENTDATETIME sy-vline
WA_PCMMPNLBPSUM_STR-SOURCETRANSACEVENTENDDATETIME sy-vline
WA_PCMMPNLBPSUM_STR-ENDOFDAYBUSINESSENTITYKEY sy-vline
WA_PCMMPNLBPSUM_STR-COMPANYCODE sy-vline
WA_PCMMPNLBPSUM_STR-SALESORGANIZATION sy-vline
WA_PCMMPNLBPSUM_STR-DISTRIBUTIONCHANNEL sy-vline
WA_PCMMPNLBPSUM_STR-DIVISION sy-vline
WA_PCMMPNLBPSUM_STR-CREDITOR sy-vline
WA_PCMMPNLBPSUM_STR-SOLDTOPARTY sy-vline
WA_PCMMPNLBPSUM_STR-MATERIAL sy-vline
WA_PCMMPNLBPSUM_STR-PHYSICALCOMMODITY sy-vline
WA_PCMMPNLBPSUM_STR-PLANT sy-vline
WA_PCMMPNLBPSUM_STR-STORAGELOCATION sy-vline
WA_PCMMPNLBPSUM_STR-BATCH sy-vline
WA_PCMMPNLBPSUM_STR-INCOTERMSCLASSIFICATION sy-vline
WA_PCMMPNLBPSUM_STR-INCOTERMSTRANSFERLOCATION sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONAPPLICATION sy-vline
WA_PCMMPNLBPSUM_STR-SOURCEDOCUMENT sy-vline
WA_PCMMPNLBPSUM_STR-SOURCEDOCUMENTITEM sy-vline
WA_PCMMPNLBPSUM_STR-SOURCEDOCUMENTBUSOBJTYPE sy-vline
WA_PCMMPNLBPSUM_STR-ORIGINREFERENCEDOCUMENT sy-vline
WA_PCMMPNLBPSUM_STR-ORIGINREFERENCEDOCUMENTITEM sy-vline
WA_PCMMPNLBPSUM_STR-ORIGINREFERENCEDOCBUSOBJTYPE sy-vline
WA_PCMMPNLBPSUM_STR-REFERENCEDOCUMENT sy-vline
WA_PCMMPNLBPSUM_STR-REFERENCEDOCUMENTITEM sy-vline
WA_PCMMPNLBPSUM_STR-REFERENCEDOCBUSOBJTYPE sy-vline
WA_PCMMPNLBPSUM_STR-DELIVERYDATE sy-vline
WA_PCMMPNLBPSUM_STR-EXPECTEDPAYMENTDATE sy-vline
WA_PCMMPNLBPSUM_STR-STATISTICSCURRENCY sy-vline
WA_PCMMPNLBPSUM_STR-DOCUMENTCURRENCY sy-vline
WA_PCMMPNLBPSUM_STR-PROFITCENTER sy-vline
WA_PCMMPNLBPSUM_STR-BUSINESSAREA sy-vline
WA_PCMMPNLBPSUM_STR-PURCHASINGORGANIZATION sy-vline
WA_PCMMPNLBPSUM_STR-MATERIALGROUP sy-vline
WA_PCMMPNLBPSUM_STR-ISINTERCOMPANYTRANSFER sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONCALCULATIONTYPE sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONRATE sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONCURRENCY sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONQUANTITY sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONQUANTITYUNIT sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONTERMRATE sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONTERMRATECURRENCY sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONTERMRATEQUANTITY sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONTERMRATEQUANTITYUNIT sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONTERMVALUE sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONTERMVALUECURRENCY sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONTERMNAME sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONTERMSTATUS sy-vline
WA_PCMMPNLBPSUM_STR-ROUNDINGDECIMALPLACES sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONTERMRATEISROUNDED sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONTERMRATENMRTR sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONTERMRATEDNMNTR sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONTERMEXTENSIONUSAGE sy-vline
WA_PCMMPNLBPSUM_STR-MATURITYSELECTIONTYPE sy-vline
WA_PCMMPNLBPSUM_STR-EXCHRATEMATURITYDATE sy-vline
WA_PCMMPNLBPSUM_STR-FIXEDEXCHRATEDATE sy-vline
WA_PCMMPNLBPSUM_STR-QUOTATIONKEYTYPE sy-vline
WA_PCMMPNLBPSUM_STR-QUOTATIONDATELIST sy-vline
WA_PCMMPNLBPSUM_STR-QUOTATIONPERIODSTARTDATE sy-vline
WA_PCMMPNLBPSUM_STR-QUOTATIONPERIODENDDATE sy-vline
WA_PCMMPNLBPSUM_STR-COMPARATIVEMARKETDCS sy-vline
WA_PCMMPNLBPSUM_STR-COMPARMKTMARKETIDENTIFIERCODE sy-vline
WA_PCMMPNLBPSUM_STR-COMPARMKTMATURITYKEYDATE sy-vline
WA_PCMMPNLBPSUM_STR-COMPARMKTDRVTVCONTRCODE sy-vline
WA_PCMMPNLBPSUM_STR-COMPARMARKETBASISID sy-vline
WA_PCMMPNLBPSUM_STR-COMPARMARKETBASISTYPE sy-vline
WA_PCMMPNLBPSUM_STR-COMPARMKTQUOTATIONPRICETYPE sy-vline
WA_PCMMPNLBPSUM_STR-QUOTATIONPERIODREFERENCEDATE sy-vline
WA_PCMMPNLBPSUM_STR-COMPARQTANPERIODREFERENCEDATE sy-vline
WA_PCMMPNLBPSUM_STR-QUOTATIONGROUP sy-vline
WA_PCMMPNLBPSUM_STR-QUOTATIONGROUPCALCULATIONRULE sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONTERMRATEFIXATION sy-vline
WA_PCMMPNLBPSUM_STR-PRICINGSTATUS sy-vline
WA_PCMMPNLBPSUM_STR-CNDNTERMRATEFIXATIONDATE sy-vline
WA_PCMMPNLBPSUM_STR-CNDNTERMRATEFIXATIONTIME sy-vline
WA_PCMMPNLBPSUM_STR-CNDNTERMEXCHRATEFIXATIONDATE sy-vline
WA_PCMMPNLBPSUM_STR-CNDNTERMEXCHRATEFIXATIONTIME sy-vline
WA_PCMMPNLBPSUM_STR-COMMODITYQUANTITY sy-vline
WA_PCMMPNLBPSUM_STR-COMMODITYUNIT sy-vline
WA_PCMMPNLBPSUM_STR-QUANTITYSIGN sy-vline
WA_PCMMPNLBPSUM_STR-MTMCONDITIONGROUPCATEGORY sy-vline
WA_PCMMPNLBPSUM_STR-MTMCONDITIONGROUP sy-vline
WA_PCMMPNLBPSUM_STR-MTMCALCULATIONGROUP sy-vline
WA_PCMMPNLBPSUM_STR-MTMADJUSTMENTTYPE sy-vline
WA_PCMMPNLBPSUM_STR-MTMCALCGRPMARKETPRICECONDITION sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONTERMRATEISFIXED sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONTERMEXCHRATEISFIXED sy-vline
WA_PCMMPNLBPSUM_STR-PRICEISREALIZED sy-vline
WA_PCMMPNLBPSUM_STR-PNLEVENTCATEGORY sy-vline
WA_PCMMPNLBPSUM_STR-PNLEVENTTYPE sy-vline
WA_PCMMPNLBPSUM_STR-COMPARIMPLICITFIXATION sy-vline
WA_PCMMPNLBPSUM_STR-IMPLICITFIXATION sy-vline
WA_PCMMPNLBPSUM_STR-CONDITIONTERMFACTOR sy-vline
WA_PCMMPNLBPSUM_STR-COMPARCONDITIONTERMFACTOR sy-vline
WA_PCMMPNLBPSUM_STR-CMMDTYPRICEEXPSRMASSUNIT sy-vline
WA_PCMMPNLBPSUM_STR-CMMDTYPRICEEXPSRQTYINMASSUNIT sy-vline
WA_PCMMPNLBPSUM_STR-CMMDTYPRICEEXPSRVOLUMEUNIT sy-vline
WA_PCMMPNLBPSUM_STR-CMMDTYPRICEEXPSRQTYINVOLUNIT sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.