ABAP Select data from SAP table IPSMS4CBDACTBSC 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 IPSMS4CBDACTBSC 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 IPSMS4CBDACTBSC. 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 IPSMS4CBDACTBSC 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_IPSMS4CBDACTBSC TYPE STANDARD TABLE OF IPSMS4CBDACTBSC,
      WA_IPSMS4CBDACTBSC TYPE IPSMS4CBDACTBSC,
      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: <IPSMS4CBDACTBSC> TYPE IPSMS4CBDACTBSC.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM IPSMS4CBDACTBSC
*  INTO TABLE @DATA(IT_IPSMS4CBDACTBSC2).
*--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_IPSMS4CBDACTBSC INDEX 1 INTO DATA(WA_IPSMS4CBDACTBSC2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_IPSMS4CBDACTBSC ASSIGNING <IPSMS4CBDACTBSC>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<IPSMS4CBDACTBSC>-MANDT = 1.
<IPSMS4CBDACTBSC>-SOURCELEDGER = 1.
<IPSMS4CBDACTBSC>-LEDGER = 1.
<IPSMS4CBDACTBSC>-COMPANYCODE = 1.
<IPSMS4CBDACTBSC>-FISCALYEAR = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_IPSMS4CBDACTBSC-ACCOUNTINGDOCUMENT, sy-vline,
WA_IPSMS4CBDACTBSC-FINANCIALPLANNINGREQTRANSSQNC, sy-vline,
WA_IPSMS4CBDACTBSC-FINANCIALPLANNINGDATAPACKET, sy-vline,
WA_IPSMS4CBDACTBSC-ACTUALPLANJOURNALENTRYITEM, sy-vline,
WA_IPSMS4CBDACTBSC-LEDGERGLLINEITEM, sy-vline,
WA_IPSMS4CBDACTBSC-FINANCIALPLANNINGENTRYITEM, sy-vline.
ENDLOOP. *Add any further fields from structure WA_IPSMS4CBDACTBSC 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_IPSMS4CBDACTBSC 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_IPSMS4CBDACTBSC INTO WA_IPSMS4CBDACTBSC. *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 SOURCELEDGER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IPSMS4CBDACTBSC-SOURCELEDGER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPSMS4CBDACTBSC-SOURCELEDGER.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit GJAHR, internal->external for field FISCALYEAR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_IPSMS4CBDACTBSC-FISCALYEAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPSMS4CBDACTBSC-FISCALYEAR.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit GJAHR, internal->external for field LEDGERFISCALYEAR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_IPSMS4CBDACTBSC-LEDGERFISCALYEAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPSMS4CBDACTBSC-LEDGERFISCALYEAR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

*Conversion exit ABPSN, internal->external for field PARTNERWBSELEMENT CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_IPSMS4CBDACTBSC-PARTNERWBSELEMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPSMS4CBDACTBSC-PARTNERWBSELEMENT.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

*Conversion exit BEKNZ, internal->external for field CONTROLLINGDEBITCREDITCODE CALL FUNCTION 'CONVERSION_EXIT_BEKNZ_OUTPUT' EXPORTING input = WA_IPSMS4CBDACTBSC-CONTROLLINGDEBITCREDITCODE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPSMS4CBDACTBSC-CONTROLLINGDEBITCREDITCODE.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit GJAHR, internal->external for field PUBSECBUDGETCNSMPNFSCLYEAR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_IPSMS4CBDACTBSC-PUBSECBUDGETCNSMPNFSCLYEAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPSMS4CBDACTBSC-PUBSECBUDGETCNSMPNFSCLYEAR.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit AUART, internal->external for field SALESORDERTYPE CALL FUNCTION 'CONVERSION_EXIT_AUART_OUTPUT' EXPORTING input = WA_IPSMS4CBDACTBSC-SALESORDERTYPE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPSMS4CBDACTBSC-SALESORDERTYPE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ASSETCLASS CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IPSMS4CBDACTBSC-ASSETCLASS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPSMS4CBDACTBSC-ASSETCLASS.
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_IPSMS4CBDACTBSC_STR,
MANDT TYPE STRING,
SOURCELEDGER TYPE STRING,
LEDGER TYPE STRING,
COMPANYCODE TYPE STRING,
FISCALYEAR TYPE STRING,
ACCOUNTINGDOCUMENT TYPE STRING,
FINANCIALPLANNINGREQTRANSSQNC TYPE STRING,
FINANCIALPLANNINGDATAPACKET TYPE STRING,
ACTUALPLANJOURNALENTRYITEM TYPE STRING,
LEDGERGLLINEITEM TYPE STRING,
FINANCIALPLANNINGENTRYITEM TYPE STRING,
LEDGERFISCALYEAR TYPE STRING,
CONTROLLINGAREA TYPE STRING,
GLACCOUNT TYPE STRING,
CHARTOFACCOUNTS TYPE STRING,
ACTUALPLANCODE TYPE STRING,
BUSINESSAREA TYPE STRING,
PROFITCENTER TYPE STRING,
COSTCENTER TYPE STRING,
PROJECTINTERNALID TYPE STRING,
PROJECTEXTERNALID TYPE STRING,
PARTNERPROJECTINTERNALID TYPE STRING,
PARTNERPROJECTEXTERNALID TYPE STRING,
WBSELEMENTINTERNALID TYPE STRING,
WBSELEMENTEXTERNALID TYPE STRING,
PARTNERWBSELEMENTINTERNALID TYPE STRING,
PARTNERWBSELEMENTEXTERNALID TYPE STRING,
FUNCTIONALAREA TYPE STRING,
SEGMENT TYPE STRING,
COSTCTRACTIVITYTYPE TYPE STRING,
COSTANALYSISRESOURCE TYPE STRING,
ORDERID TYPE STRING,
WORKPACKAGE TYPE STRING,
WORKITEM TYPE STRING,
PARTNERACCOUNTASSIGNMENTTYPE TYPE STRING,
PARTNERBUDGETPERIOD TYPE STRING,
PARTNERFUND TYPE STRING,
PARTNERGRANT TYPE STRING,
PARTNERCOMPANYCODE TYPE STRING,
PARTNERBUSINESSAREA TYPE STRING,
PARTNERPROFITCENTER TYPE STRING,
PARTNERCOSTCENTER TYPE STRING,
PARTNERWBSELEMENT TYPE STRING,
PARTNERFUNCTIONALAREA TYPE STRING,
PARTNERSEGMENT TYPE STRING,
PARTNERCOSTCTRACTIVITYTYPE TYPE STRING,
PARTNERORDER TYPE STRING,
PARTNERCOMPANY TYPE STRING,
ORIGINPROFITCENTER TYPE STRING,
ORIGINCOSTCENTER TYPE STRING,
ORIGINCOSTCTRACTIVITYTYPE TYPE STRING,
REFERENCEDOCUMENTTYPE TYPE STRING,
REFERENCEDOCUMENTCONTEXT TYPE STRING,
REFERENCEDOCUMENT TYPE STRING,
BUSINESSTRANSACTIONTYPE TYPE STRING,
FINANCIALTRANSACTIONTYPE TYPE STRING,
ACCOUNTINGDOCUMENTTYPE TYPE STRING,
FINANCIALACCOUNTTYPE TYPE STRING,
POSTINGDATE TYPE STRING,
FISCALPERIOD TYPE STRING,
FISCALYEARPERIOD TYPE STRING,
FISCALYEARVARIANT TYPE STRING,
PLANNINGCATEGORY TYPE STRING,
SERVICESRENDEREDDATE TYPE STRING,
CONTROLLINGDEBITCREDITCODE TYPE STRING,
ACCOUNTASSIGNMENTTYPE TYPE STRING,
PERSONNELNUMBER TYPE STRING,
VALUATIONAREA TYPE STRING,
PLANT TYPE STRING,
PRODUCT TYPE STRING,
CUSTOMER TYPE STRING,
SUPPLIER TYPE STRING,
SALESDOCUMENT TYPE STRING,
SALESDOCUMENTITEM TYPE STRING,
SERVICEDOCUMENT TYPE STRING,
SERVICEDOCUMENTTYPE TYPE STRING,
SERVICEDOCUMENTITEM TYPE STRING,
SERVICECONTRACTTYPE TYPE STRING,
SERVICECONTRACT TYPE STRING,
SERVICECONTRACTITEM TYPE STRING,
BILLINGDOCUMENTTYPE TYPE STRING,
SALESORGANIZATION TYPE STRING,
DISTRIBUTIONCHANNEL TYPE STRING,
ORGANIZATIONDIVISION TYPE STRING,
SOLDPRODUCT TYPE STRING,
CUSTOMERGROUP TYPE STRING,
CUSTOMERSUPPLIERCOUNTRY TYPE STRING,
CUSTOMERSUPPLIERINDUSTRY TYPE STRING,
SALESDISTRICT TYPE STRING,
BILLTOPARTY TYPE STRING,
SHIPTOPARTY TYPE STRING,
CUSTOMERSUPPLIERCORPORATEGROUP TYPE STRING,
ISSTATISTICALORDER TYPE STRING,
ISSTATISTICALCOSTCENTER TYPE STRING,
ISSTATISTICALSALESDOCUMENT TYPE STRING,
WBSISSTATISTICALWBSELEMENT TYPE STRING,
WORKCENTERINTERNALID TYPE STRING,
ORDEROPERATION TYPE STRING,
ORDERITEM TYPE STRING,
SOURCEREFERENCEDOCUMENTTYPE TYPE STRING,
SOURCELOGICALSYSTEM TYPE STRING,
SOURCEREFERENCEDOCUMENTCNTXT TYPE STRING,
SOURCEREFERENCEDOCUMENT TYPE STRING,
SOURCEREFERENCEDOCUMENTITEM TYPE STRING,
SOURCEREFERENCEDOCSUBITEM TYPE STRING,
ISCOMMITMENT TYPE STRING,
FINANCIALMANAGEMENTAREA TYPE STRING,
FUND TYPE STRING,
GRANTID TYPE STRING,
SPONSOREDCLASS TYPE STRING,
SPONSOREDPROGRAM TYPE STRING,
GTEEMBUDGETVALIDITYNUMBER TYPE STRING,
BUDGETPERIOD TYPE STRING,
CASHLEDGERACCOUNT TYPE STRING,
CASHLEDGERCOMPANYCODE TYPE STRING,
PUBSECBUDGETACCOUNT TYPE STRING,
PUBSECBUDGETACCOUNTCOCODE TYPE STRING,
PUBSECBUDGETCNSMPNDATE TYPE STRING,
PUBSECBUDGETCNSMPNFSCLPERIOD TYPE STRING,
PUBSECBUDGETCNSMPNFSCLYEAR TYPE STRING,
PUBSECBUDGETCNSMPNTYPE TYPE STRING,
PUBSECBUDGETCNSMPNAMTTYPE TYPE STRING,
PUBSECBUDGETISRELEVANT TYPE STRING,
BUDGETPROCESS TYPE STRING,
BUDGETINGTYPE TYPE STRING,
TRANSACTIONCURRENCY TYPE STRING,
COMPANYCODECURRENCY TYPE STRING,
GLOBALCURRENCY TYPE STRING,
COSTSOURCEUNIT TYPE STRING,
AMOUNTINTRANSACTIONCURRENCY TYPE STRING,
AMOUNTINCOMPANYCODECURRENCY TYPE STRING,
AMOUNTINGLOBALCURRENCY TYPE STRING,
VALUATIONQUANTITY TYPE STRING,
ACTUALAMOUNTINTRANSACTIONCRCY TYPE STRING,
ACTUALAMOUNTINCOMPANYCODECRCY TYPE STRING,
ACTUALAMOUNTINGLOBALCURRENCY TYPE STRING,
ACTUALVALUATIONQUANTITY TYPE STRING,
PLANAMOUNTINTRANSACTIONCRCY TYPE STRING,
PLANAMOUNTINCOMPANYCODECRCY TYPE STRING,
PLANAMOUNTINGLOBALCURRENCY TYPE STRING,
PLANVALUATIONQUANTITY TYPE STRING,
PLANPRICEINCOMPANYCODECURRENCY TYPE STRING,
PLANPRICEINTRANSACTIONCURRENCY TYPE STRING,
PLANPRICEINGLOBALCURRENCY TYPE STRING,
ACTLPLNDIFFAMTINTRANSCRCY TYPE STRING,
ACTLPLNDIFFAMTINCOCODECRCY TYPE STRING,
ACTLPLNDIFFAMTINGLOBALCRCY TYPE STRING,
ACTLPANDIFFVALUATIONQUANTITY TYPE STRING,
GLACCOUNTAUTHORIZATIONGROUP TYPE STRING,
SUPPLIERBASICAUTHORIZATIONGRP TYPE STRING,
CUSTOMERBASICAUTHORIZATIONGRP TYPE STRING,
ACCTGDOCTYPEAUTHORIZATIONGROUP TYPE STRING,
ORDERTYPE TYPE STRING,
SALESORDERTYPE TYPE STRING,
ASSETCLASS TYPE STRING,END OF T_EKKO_STR. DATA: WA_IPSMS4CBDACTBSC_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_IPSMS4CBDACTBSC_STR-MANDT sy-vline
WA_IPSMS4CBDACTBSC_STR-SOURCELEDGER sy-vline
WA_IPSMS4CBDACTBSC_STR-LEDGER sy-vline
WA_IPSMS4CBDACTBSC_STR-COMPANYCODE sy-vline
WA_IPSMS4CBDACTBSC_STR-FISCALYEAR sy-vline
WA_IPSMS4CBDACTBSC_STR-ACCOUNTINGDOCUMENT sy-vline
WA_IPSMS4CBDACTBSC_STR-FINANCIALPLANNINGREQTRANSSQNC sy-vline
WA_IPSMS4CBDACTBSC_STR-FINANCIALPLANNINGDATAPACKET sy-vline
WA_IPSMS4CBDACTBSC_STR-ACTUALPLANJOURNALENTRYITEM sy-vline
WA_IPSMS4CBDACTBSC_STR-LEDGERGLLINEITEM sy-vline
WA_IPSMS4CBDACTBSC_STR-FINANCIALPLANNINGENTRYITEM sy-vline
WA_IPSMS4CBDACTBSC_STR-LEDGERFISCALYEAR sy-vline
WA_IPSMS4CBDACTBSC_STR-CONTROLLINGAREA sy-vline
WA_IPSMS4CBDACTBSC_STR-GLACCOUNT sy-vline
WA_IPSMS4CBDACTBSC_STR-CHARTOFACCOUNTS sy-vline
WA_IPSMS4CBDACTBSC_STR-ACTUALPLANCODE sy-vline
WA_IPSMS4CBDACTBSC_STR-BUSINESSAREA sy-vline
WA_IPSMS4CBDACTBSC_STR-PROFITCENTER sy-vline
WA_IPSMS4CBDACTBSC_STR-COSTCENTER sy-vline
WA_IPSMS4CBDACTBSC_STR-PROJECTINTERNALID sy-vline
WA_IPSMS4CBDACTBSC_STR-PROJECTEXTERNALID sy-vline
WA_IPSMS4CBDACTBSC_STR-PARTNERPROJECTINTERNALID sy-vline
WA_IPSMS4CBDACTBSC_STR-PARTNERPROJECTEXTERNALID sy-vline
WA_IPSMS4CBDACTBSC_STR-WBSELEMENTINTERNALID sy-vline
WA_IPSMS4CBDACTBSC_STR-WBSELEMENTEXTERNALID sy-vline
WA_IPSMS4CBDACTBSC_STR-PARTNERWBSELEMENTINTERNALID sy-vline
WA_IPSMS4CBDACTBSC_STR-PARTNERWBSELEMENTEXTERNALID sy-vline
WA_IPSMS4CBDACTBSC_STR-FUNCTIONALAREA sy-vline
WA_IPSMS4CBDACTBSC_STR-SEGMENT sy-vline
WA_IPSMS4CBDACTBSC_STR-COSTCTRACTIVITYTYPE sy-vline
WA_IPSMS4CBDACTBSC_STR-COSTANALYSISRESOURCE sy-vline
WA_IPSMS4CBDACTBSC_STR-ORDERID sy-vline
WA_IPSMS4CBDACTBSC_STR-WORKPACKAGE sy-vline
WA_IPSMS4CBDACTBSC_STR-WORKITEM sy-vline
WA_IPSMS4CBDACTBSC_STR-PARTNERACCOUNTASSIGNMENTTYPE sy-vline
WA_IPSMS4CBDACTBSC_STR-PARTNERBUDGETPERIOD sy-vline
WA_IPSMS4CBDACTBSC_STR-PARTNERFUND sy-vline
WA_IPSMS4CBDACTBSC_STR-PARTNERGRANT sy-vline
WA_IPSMS4CBDACTBSC_STR-PARTNERCOMPANYCODE sy-vline
WA_IPSMS4CBDACTBSC_STR-PARTNERBUSINESSAREA sy-vline
WA_IPSMS4CBDACTBSC_STR-PARTNERPROFITCENTER sy-vline
WA_IPSMS4CBDACTBSC_STR-PARTNERCOSTCENTER sy-vline
WA_IPSMS4CBDACTBSC_STR-PARTNERWBSELEMENT sy-vline
WA_IPSMS4CBDACTBSC_STR-PARTNERFUNCTIONALAREA sy-vline
WA_IPSMS4CBDACTBSC_STR-PARTNERSEGMENT sy-vline
WA_IPSMS4CBDACTBSC_STR-PARTNERCOSTCTRACTIVITYTYPE sy-vline
WA_IPSMS4CBDACTBSC_STR-PARTNERORDER sy-vline
WA_IPSMS4CBDACTBSC_STR-PARTNERCOMPANY sy-vline
WA_IPSMS4CBDACTBSC_STR-ORIGINPROFITCENTER sy-vline
WA_IPSMS4CBDACTBSC_STR-ORIGINCOSTCENTER sy-vline
WA_IPSMS4CBDACTBSC_STR-ORIGINCOSTCTRACTIVITYTYPE sy-vline
WA_IPSMS4CBDACTBSC_STR-REFERENCEDOCUMENTTYPE sy-vline
WA_IPSMS4CBDACTBSC_STR-REFERENCEDOCUMENTCONTEXT sy-vline
WA_IPSMS4CBDACTBSC_STR-REFERENCEDOCUMENT sy-vline
WA_IPSMS4CBDACTBSC_STR-BUSINESSTRANSACTIONTYPE sy-vline
WA_IPSMS4CBDACTBSC_STR-FINANCIALTRANSACTIONTYPE sy-vline
WA_IPSMS4CBDACTBSC_STR-ACCOUNTINGDOCUMENTTYPE sy-vline
WA_IPSMS4CBDACTBSC_STR-FINANCIALACCOUNTTYPE sy-vline
WA_IPSMS4CBDACTBSC_STR-POSTINGDATE sy-vline
WA_IPSMS4CBDACTBSC_STR-FISCALPERIOD sy-vline
WA_IPSMS4CBDACTBSC_STR-FISCALYEARPERIOD sy-vline
WA_IPSMS4CBDACTBSC_STR-FISCALYEARVARIANT sy-vline
WA_IPSMS4CBDACTBSC_STR-PLANNINGCATEGORY sy-vline
WA_IPSMS4CBDACTBSC_STR-SERVICESRENDEREDDATE sy-vline
WA_IPSMS4CBDACTBSC_STR-CONTROLLINGDEBITCREDITCODE sy-vline
WA_IPSMS4CBDACTBSC_STR-ACCOUNTASSIGNMENTTYPE sy-vline
WA_IPSMS4CBDACTBSC_STR-PERSONNELNUMBER sy-vline
WA_IPSMS4CBDACTBSC_STR-VALUATIONAREA sy-vline
WA_IPSMS4CBDACTBSC_STR-PLANT sy-vline
WA_IPSMS4CBDACTBSC_STR-PRODUCT sy-vline
WA_IPSMS4CBDACTBSC_STR-CUSTOMER sy-vline
WA_IPSMS4CBDACTBSC_STR-SUPPLIER sy-vline
WA_IPSMS4CBDACTBSC_STR-SALESDOCUMENT sy-vline
WA_IPSMS4CBDACTBSC_STR-SALESDOCUMENTITEM sy-vline
WA_IPSMS4CBDACTBSC_STR-SERVICEDOCUMENT sy-vline
WA_IPSMS4CBDACTBSC_STR-SERVICEDOCUMENTTYPE sy-vline
WA_IPSMS4CBDACTBSC_STR-SERVICEDOCUMENTITEM sy-vline
WA_IPSMS4CBDACTBSC_STR-SERVICECONTRACTTYPE sy-vline
WA_IPSMS4CBDACTBSC_STR-SERVICECONTRACT sy-vline
WA_IPSMS4CBDACTBSC_STR-SERVICECONTRACTITEM sy-vline
WA_IPSMS4CBDACTBSC_STR-BILLINGDOCUMENTTYPE sy-vline
WA_IPSMS4CBDACTBSC_STR-SALESORGANIZATION sy-vline
WA_IPSMS4CBDACTBSC_STR-DISTRIBUTIONCHANNEL sy-vline
WA_IPSMS4CBDACTBSC_STR-ORGANIZATIONDIVISION sy-vline
WA_IPSMS4CBDACTBSC_STR-SOLDPRODUCT sy-vline
WA_IPSMS4CBDACTBSC_STR-CUSTOMERGROUP sy-vline
WA_IPSMS4CBDACTBSC_STR-CUSTOMERSUPPLIERCOUNTRY sy-vline
WA_IPSMS4CBDACTBSC_STR-CUSTOMERSUPPLIERINDUSTRY sy-vline
WA_IPSMS4CBDACTBSC_STR-SALESDISTRICT sy-vline
WA_IPSMS4CBDACTBSC_STR-BILLTOPARTY sy-vline
WA_IPSMS4CBDACTBSC_STR-SHIPTOPARTY sy-vline
WA_IPSMS4CBDACTBSC_STR-CUSTOMERSUPPLIERCORPORATEGROUP sy-vline
WA_IPSMS4CBDACTBSC_STR-ISSTATISTICALORDER sy-vline
WA_IPSMS4CBDACTBSC_STR-ISSTATISTICALCOSTCENTER sy-vline
WA_IPSMS4CBDACTBSC_STR-ISSTATISTICALSALESDOCUMENT sy-vline
WA_IPSMS4CBDACTBSC_STR-WBSISSTATISTICALWBSELEMENT sy-vline
WA_IPSMS4CBDACTBSC_STR-WORKCENTERINTERNALID sy-vline
WA_IPSMS4CBDACTBSC_STR-ORDEROPERATION sy-vline
WA_IPSMS4CBDACTBSC_STR-ORDERITEM sy-vline
WA_IPSMS4CBDACTBSC_STR-SOURCEREFERENCEDOCUMENTTYPE sy-vline
WA_IPSMS4CBDACTBSC_STR-SOURCELOGICALSYSTEM sy-vline
WA_IPSMS4CBDACTBSC_STR-SOURCEREFERENCEDOCUMENTCNTXT sy-vline
WA_IPSMS4CBDACTBSC_STR-SOURCEREFERENCEDOCUMENT sy-vline
WA_IPSMS4CBDACTBSC_STR-SOURCEREFERENCEDOCUMENTITEM sy-vline
WA_IPSMS4CBDACTBSC_STR-SOURCEREFERENCEDOCSUBITEM sy-vline
WA_IPSMS4CBDACTBSC_STR-ISCOMMITMENT sy-vline
WA_IPSMS4CBDACTBSC_STR-FINANCIALMANAGEMENTAREA sy-vline
WA_IPSMS4CBDACTBSC_STR-FUND sy-vline
WA_IPSMS4CBDACTBSC_STR-GRANTID sy-vline
WA_IPSMS4CBDACTBSC_STR-SPONSOREDCLASS sy-vline
WA_IPSMS4CBDACTBSC_STR-SPONSOREDPROGRAM sy-vline
WA_IPSMS4CBDACTBSC_STR-GTEEMBUDGETVALIDITYNUMBER sy-vline
WA_IPSMS4CBDACTBSC_STR-BUDGETPERIOD sy-vline
WA_IPSMS4CBDACTBSC_STR-CASHLEDGERACCOUNT sy-vline
WA_IPSMS4CBDACTBSC_STR-CASHLEDGERCOMPANYCODE sy-vline
WA_IPSMS4CBDACTBSC_STR-PUBSECBUDGETACCOUNT sy-vline
WA_IPSMS4CBDACTBSC_STR-PUBSECBUDGETACCOUNTCOCODE sy-vline
WA_IPSMS4CBDACTBSC_STR-PUBSECBUDGETCNSMPNDATE sy-vline
WA_IPSMS4CBDACTBSC_STR-PUBSECBUDGETCNSMPNFSCLPERIOD sy-vline
WA_IPSMS4CBDACTBSC_STR-PUBSECBUDGETCNSMPNFSCLYEAR sy-vline
WA_IPSMS4CBDACTBSC_STR-PUBSECBUDGETCNSMPNTYPE sy-vline
WA_IPSMS4CBDACTBSC_STR-PUBSECBUDGETCNSMPNAMTTYPE sy-vline
WA_IPSMS4CBDACTBSC_STR-PUBSECBUDGETISRELEVANT sy-vline
WA_IPSMS4CBDACTBSC_STR-BUDGETPROCESS sy-vline
WA_IPSMS4CBDACTBSC_STR-BUDGETINGTYPE sy-vline
WA_IPSMS4CBDACTBSC_STR-TRANSACTIONCURRENCY sy-vline
WA_IPSMS4CBDACTBSC_STR-COMPANYCODECURRENCY sy-vline
WA_IPSMS4CBDACTBSC_STR-GLOBALCURRENCY sy-vline
WA_IPSMS4CBDACTBSC_STR-COSTSOURCEUNIT sy-vline
WA_IPSMS4CBDACTBSC_STR-AMOUNTINTRANSACTIONCURRENCY sy-vline
WA_IPSMS4CBDACTBSC_STR-AMOUNTINCOMPANYCODECURRENCY sy-vline
WA_IPSMS4CBDACTBSC_STR-AMOUNTINGLOBALCURRENCY sy-vline
WA_IPSMS4CBDACTBSC_STR-VALUATIONQUANTITY sy-vline
WA_IPSMS4CBDACTBSC_STR-ACTUALAMOUNTINTRANSACTIONCRCY sy-vline
WA_IPSMS4CBDACTBSC_STR-ACTUALAMOUNTINCOMPANYCODECRCY sy-vline
WA_IPSMS4CBDACTBSC_STR-ACTUALAMOUNTINGLOBALCURRENCY sy-vline
WA_IPSMS4CBDACTBSC_STR-ACTUALVALUATIONQUANTITY sy-vline
WA_IPSMS4CBDACTBSC_STR-PLANAMOUNTINTRANSACTIONCRCY sy-vline
WA_IPSMS4CBDACTBSC_STR-PLANAMOUNTINCOMPANYCODECRCY sy-vline
WA_IPSMS4CBDACTBSC_STR-PLANAMOUNTINGLOBALCURRENCY sy-vline
WA_IPSMS4CBDACTBSC_STR-PLANVALUATIONQUANTITY sy-vline
WA_IPSMS4CBDACTBSC_STR-PLANPRICEINCOMPANYCODECURRENCY sy-vline
WA_IPSMS4CBDACTBSC_STR-PLANPRICEINTRANSACTIONCURRENCY sy-vline
WA_IPSMS4CBDACTBSC_STR-PLANPRICEINGLOBALCURRENCY sy-vline
WA_IPSMS4CBDACTBSC_STR-ACTLPLNDIFFAMTINTRANSCRCY sy-vline
WA_IPSMS4CBDACTBSC_STR-ACTLPLNDIFFAMTINCOCODECRCY sy-vline
WA_IPSMS4CBDACTBSC_STR-ACTLPLNDIFFAMTINGLOBALCRCY sy-vline
WA_IPSMS4CBDACTBSC_STR-ACTLPANDIFFVALUATIONQUANTITY sy-vline
WA_IPSMS4CBDACTBSC_STR-GLACCOUNTAUTHORIZATIONGROUP sy-vline
WA_IPSMS4CBDACTBSC_STR-SUPPLIERBASICAUTHORIZATIONGRP sy-vline
WA_IPSMS4CBDACTBSC_STR-CUSTOMERBASICAUTHORIZATIONGRP sy-vline
WA_IPSMS4CBDACTBSC_STR-ACCTGDOCTYPEAUTHORIZATIONGROUP sy-vline
WA_IPSMS4CBDACTBSC_STR-ORDERTYPE sy-vline
WA_IPSMS4CBDACTBSC_STR-SALESORDERTYPE sy-vline
WA_IPSMS4CBDACTBSC_STR-ASSETCLASS sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.