ABAP Select data from SAP table PPOSTJOURNAL 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 PPOSTJOURNAL 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 PPOSTJOURNAL. 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 PPOSTJOURNAL 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_PPOSTJOURNAL TYPE STANDARD TABLE OF PPOSTJOURNAL,
      WA_PPOSTJOURNAL TYPE PPOSTJOURNAL,
      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: <PPOSTJOURNAL> TYPE PPOSTJOURNAL.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM PPOSTJOURNAL
*  INTO TABLE @DATA(IT_PPOSTJOURNAL2).
*--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_PPOSTJOURNAL INDEX 1 INTO DATA(WA_PPOSTJOURNAL2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_PPOSTJOURNAL ASSIGNING <PPOSTJOURNAL>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<PPOSTJOURNAL>-MANDT = 1.
<PPOSTJOURNAL>-DOCUMENTUUID = 1.
<PPOSTJOURNAL>-ACCOUNTINGDOCUMENTITEMREF = 1.
<PPOSTJOURNAL>-POSCONTEXUUID = 1.
<PPOSTJOURNAL>-FININSTRPRODUCTGROUP = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PPOSTJOURNAL-FININSTRPRODUCTGROUPNAME, sy-vline,
WA_PPOSTJOURNAL-TREASURYPOSTINGSTATUS, sy-vline,
WA_PPOSTJOURNAL-TREASURYPOSTINGSTATUSNAME, sy-vline,
WA_PPOSTJOURNAL-TREASURYUPDATETYPE, sy-vline,
WA_PPOSTJOURNAL-TREASURYUPDATETYPENAME, sy-vline,
WA_PPOSTJOURNAL-ISUSEDINPAYMENTTRANSACTION, sy-vline.
ENDLOOP. *Add any further fields from structure WA_PPOSTJOURNAL 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_PPOSTJOURNAL 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_PPOSTJOURNAL INTO WA_PPOSTJOURNAL. *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 GLACCOUNT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_PPOSTJOURNAL-GLACCOUNT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PPOSTJOURNAL-GLACCOUNT.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field FINANCIALEXPOSURESUBITEM CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_PPOSTJOURNAL-FINANCIALEXPOSURESUBITEM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PPOSTJOURNAL-FINANCIALEXPOSURESUBITEM.
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_PPOSTJOURNAL_STR,
MANDT TYPE STRING,
DOCUMENTUUID TYPE STRING,
ACCOUNTINGDOCUMENTITEMREF TYPE STRING,
POSCONTEXUUID TYPE STRING,
FININSTRPRODUCTGROUP TYPE STRING,
FININSTRPRODUCTGROUPNAME TYPE STRING,
TREASURYPOSTINGSTATUS TYPE STRING,
TREASURYPOSTINGSTATUSNAME TYPE STRING,
TREASURYUPDATETYPE TYPE STRING,
TREASURYUPDATETYPENAME TYPE STRING,
ISUSEDINPAYMENTTRANSACTION TYPE STRING,
TREASURYGLACCOUNTASSIGNMENTREF TYPE STRING,
TREASURYGLACCOUNTASSIGNREFNAME TYPE STRING,
TREASURYPOSTINGCATEGORY TYPE STRING,
TREASURYPOSTINGCATEGORYNAME TYPE STRING,
TREASURYGLACCOUNTSYMBOL TYPE STRING,
TREASURYGLACCOUNTSYMBOLNAME TYPE STRING,
POSTINGKEY TYPE STRING,
POSTINGKEYNAME TYPE STRING,
GLACCOUNT TYPE STRING,
GLACCOUNTLONGNAME TYPE STRING,
POSITIONCURRENCY TYPE STRING,
AMOUNTINPOSITIONCURRENCY TYPE STRING,
COMPANYCODECURRENCY TYPE STRING,
AMOUNTINCOMPANYCODECURRENCY TYPE STRING,
TREASURYTRANSACTIONFLOW TYPE STRING,
ACCOUNTINGDOCUMENT TYPE STRING,
REVERSEDOCUMENT TYPE STRING,
JOURNALENTRYTYPE TYPE STRING,
ACCOUNTINGDOCUMENTTYPENAME TYPE STRING,
PAYMENTDATE TYPE STRING,
CUSTOMER TYPE STRING,
PAYMENTTERMS TYPE STRING,
PAYMENTMETHOD TYPE STRING,
PAYMENTMETHODNAME TYPE STRING,
PAYMENTMETHODSUPPLEMENT TYPE STRING,
PAYMENTMETHODSUPPLEMENTNAME TYPE STRING,
PAYMENTBLOCKINGREASON TYPE STRING,
PAYMENTBLOCKINGREASONNAME TYPE STRING,
PAYERPAYEE TYPE STRING,
PAYERPAYEEFULLNAME TYPE STRING,
BPBANKACCOUNTINTERNALID TYPE STRING,
HOUSEBANK TYPE STRING,
HOUSEBANKACCOUNT TYPE STRING,
TREASURYPAYMENTFLOWDIRECTION TYPE STRING,
STATECENTRALBANKPAYMENTREASON TYPE STRING,
SUPPLYINGCOUNTRY TYPE STRING,
COUNTRYNAME TYPE STRING,
ASSIGNMENTREFERENCE TYPE STRING,
JOURNALENTRYITEMTEXT TYPE STRING,
BUSINESSAREA TYPE STRING,
BUSINESSAREANAME TYPE STRING,
COSTCENTER TYPE STRING,
COSTCENTERNAME TYPE STRING,
FINANCIALTRANSACTIONTYPE TYPE STRING,
FINANCIALTRANSACTIONTYPENAME TYPE STRING,
PARTNERCOMPANY TYPE STRING,
COMPANYNAME TYPE STRING,
COUNTERPARTY TYPE STRING,
COUNTERPARTYFULLNAME TYPE STRING,
ISSUER TYPE STRING,
ISSUERFULLNAME TYPE STRING,
SPECIALGLCODE TYPE STRING,
SPECIALGLCODENAME TYPE STRING,
TREASURYBUSINESSTRANSACTION TYPE STRING,
TREASURYVALUATIONAREA TYPE STRING,
TREASURYVALUATIONAREANAME TYPE STRING,
REFERENCEDOCUMENT TYPE STRING,
REFERENCEDOCUMENTCONTEXT TYPE STRING,
POSTINGDATE TYPE STRING,
FISCALPERIOD TYPE STRING,
FISCALYEAR TYPE STRING,
REVERSALREFERENCEDOCUMENT TYPE STRING,
REVERSALREFERENCEDOCUMENTCNTXT TYPE STRING,
REVERSEDOCUMENTPOSTINGDATE TYPE STRING,
REVERSEDOCUMENTFISCALPERIOD TYPE STRING,
REVERSEDOCUMENTFISCALYEAR TYPE STRING,
LEDGER TYPE STRING,
DOCUMENTDATE TYPE STRING,
ACCOUNTINGPRINCIPLE TYPE STRING,
TREASURYACCTGPOSTINGCATEGORY TYPE STRING,
TREASURYBUSINESSTRANSCATEGORY TYPE STRING,
TREASURYBUSTRANSCATEGORYNAME TYPE STRING,
DOCUMENTHEADERTEXT TYPE STRING,
DOCUMENTREFERENCE TYPE STRING,
FINANCIALINSTRVALUATIONCLASS TYPE STRING,
FINANCIALINSTRVALCLASSNAME TYPE STRING,
TREASURYVALUATIONCLASS TYPE STRING,
TREASURYVALUATIONCLASSNAME TYPE STRING,
COMPANYCODE TYPE STRING,
COMPANYCODENAME TYPE STRING,
CHARTOFACCOUNTS TYPE STRING,
FINANCIALINSTRUMENTPRODUCTTYPE TYPE STRING,
FINANCIALINSTRPRODTYPENAME TYPE STRING,
SECURITYACCOUNT TYPE STRING,
SECURITYACCOUNTNAME TYPE STRING,
SECURITYCLASS TYPE STRING,
SECURITYCLASSNAME TYPE STRING,
SECURITYCLASSDESCRIPTION TYPE STRING,
DIFFERENTIATIONPORTFOLIO TYPE STRING,
DIFFERENTIATIONPORTFOLIONAME TYPE STRING,
SECURITYACCOUNTGROUP TYPE STRING,
SECURITYACCOUNTGROUPNAME TYPE STRING,
LOANCONTRACT TYPE STRING,
LOANCONTRACTNAME TYPE STRING,
TREASURYPOSITIONACCOUNT TYPE STRING,
TREASURYPOSITIONACCOUNTNAME TYPE STRING,
TREASURYPOSITIONLONGSHORTCODE TYPE STRING,
FUND TYPE STRING,
FUNDNAME TYPE STRING,
GRANTID TYPE STRING,
CENTRALCLEARINGACCOUNT TYPE STRING,
CENTRALCLEARINGACCOUNTNAME TYPE STRING,
ACTIVITYFINANCIALTRANSACTION TYPE STRING,
FINANCIALTRANSACTION TYPE STRING,
FINANCIALINSTRTRANSACTIONTYPE TYPE STRING,
FINANCIALINSTRTRANSTYPENAME TYPE STRING,
FINANCIALINSTRCHARACTERISTIC TYPE STRING,
FINANCIALINSTRUMENTREFERENCE TYPE STRING,
FINANCIALINSTRUMENTASSIGNMENT TYPE STRING,
PORTFOLIO TYPE STRING,
LETTEROFCREDIT TYPE STRING,
HEDGINGCLASSIFICATION TYPE STRING,
HEDGINGCLASSIFICATIONNAME TYPE STRING,
CREATEDBYUSER TYPE STRING,
CREATIONDATE TYPE STRING,
LASTCHANGEDBYUSER TYPE STRING,
LASTCHANGEDATE TYPE STRING,
PAYMENTREQUEST TYPE STRING,
PAYTREQORIGLREFERENCEDOCUMENT TYPE STRING,
PAYMENTCURRENCY TYPE STRING,
AMOUNTINPAYMENTCURRENCY TYPE STRING,
TREASURYINDIVIDUALPAYMENT TYPE STRING,
TRSYPAYTGROUPINGSAMEDRCTNISRQD TYPE STRING,
TREASURYPAYMENTREQUESTGROUPING TYPE STRING,
TRSYPAYTREQUESTGROUPINGNAME TYPE STRING,
PAYMENTREQUESTPAYMENTGROUP TYPE STRING,
CONSIDEREDPAYMENTMETHODS TYPE STRING,
PAYTREQADDITIONALINSTRUCTIONS TYPE STRING,
PAYTREQADDLINSTRUCTIONSNAME TYPE STRING,
BANKCLEARINGGLACCOUNT TYPE STRING,
TRSYPAYTREQUESTRELEASESTATUS TYPE STRING,
TRSYPAYTREQUESTRELSTATUSNAME TYPE STRING,
TRSYPOSFREEDEFINEDATTRIBUTE1 TYPE STRING,
TRSYPOSFREEDEFINEDATTRIBUTE2 TYPE STRING,
TRSYPOSFREEDEFINEDATTRIBUTE3 TYPE STRING,
TRSYPOSFREEDEFINEDATTRIBUTE4 TYPE STRING,
TRSYPOSFREEDEFINEDATTRIBUTE5 TYPE STRING,
TRSYPOSFREEDEFINEDATTRIBUTE6 TYPE STRING,
TRSYPOSFREEDEFINEDATTRIBUTE7 TYPE STRING,
TRSYPOSFREEDEFINEDATTRIBUTE8 TYPE STRING,
TRSYPOSFREEDEFINEDATTRIBUTE9 TYPE STRING,
TRSYPOSFREEDFNDATTRIBUTE1NAME TYPE STRING,
TRSYPOSFREEDFNDATTRIBUTE2NAME TYPE STRING,
TRSYPOSFREEDFNDATTRIBUTE3NAME TYPE STRING,
TRSYPOSFREEDFNDATTRIBUTE4NAME TYPE STRING,
TRSYPOSFREEDFNDATTRIBUTE5NAME TYPE STRING,
TRSYPOSFREEDFNDATTRIBUTE6NAME TYPE STRING,
TREASURYACCOUNTINGCODE TYPE STRING,
FINANCIALEXPOSUREITEM TYPE STRING,
FINANCIALEXPOSUREITEMNAME TYPE STRING,
FINANCIALEXPOSURESUBITEM TYPE STRING,
FINANCIALEXPOSURESUBITEMNAME TYPE STRING,END OF T_EKKO_STR. DATA: WA_PPOSTJOURNAL_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_PPOSTJOURNAL_STR-MANDT sy-vline
WA_PPOSTJOURNAL_STR-DOCUMENTUUID sy-vline
WA_PPOSTJOURNAL_STR-ACCOUNTINGDOCUMENTITEMREF sy-vline
WA_PPOSTJOURNAL_STR-POSCONTEXUUID sy-vline
WA_PPOSTJOURNAL_STR-FININSTRPRODUCTGROUP sy-vline
WA_PPOSTJOURNAL_STR-FININSTRPRODUCTGROUPNAME sy-vline
WA_PPOSTJOURNAL_STR-TREASURYPOSTINGSTATUS sy-vline
WA_PPOSTJOURNAL_STR-TREASURYPOSTINGSTATUSNAME sy-vline
WA_PPOSTJOURNAL_STR-TREASURYUPDATETYPE sy-vline
WA_PPOSTJOURNAL_STR-TREASURYUPDATETYPENAME sy-vline
WA_PPOSTJOURNAL_STR-ISUSEDINPAYMENTTRANSACTION sy-vline
WA_PPOSTJOURNAL_STR-TREASURYGLACCOUNTASSIGNMENTREF sy-vline
WA_PPOSTJOURNAL_STR-TREASURYGLACCOUNTASSIGNREFNAME sy-vline
WA_PPOSTJOURNAL_STR-TREASURYPOSTINGCATEGORY sy-vline
WA_PPOSTJOURNAL_STR-TREASURYPOSTINGCATEGORYNAME sy-vline
WA_PPOSTJOURNAL_STR-TREASURYGLACCOUNTSYMBOL sy-vline
WA_PPOSTJOURNAL_STR-TREASURYGLACCOUNTSYMBOLNAME sy-vline
WA_PPOSTJOURNAL_STR-POSTINGKEY sy-vline
WA_PPOSTJOURNAL_STR-POSTINGKEYNAME sy-vline
WA_PPOSTJOURNAL_STR-GLACCOUNT sy-vline
WA_PPOSTJOURNAL_STR-GLACCOUNTLONGNAME sy-vline
WA_PPOSTJOURNAL_STR-POSITIONCURRENCY sy-vline
WA_PPOSTJOURNAL_STR-AMOUNTINPOSITIONCURRENCY sy-vline
WA_PPOSTJOURNAL_STR-COMPANYCODECURRENCY sy-vline
WA_PPOSTJOURNAL_STR-AMOUNTINCOMPANYCODECURRENCY sy-vline
WA_PPOSTJOURNAL_STR-TREASURYTRANSACTIONFLOW sy-vline
WA_PPOSTJOURNAL_STR-ACCOUNTINGDOCUMENT sy-vline
WA_PPOSTJOURNAL_STR-REVERSEDOCUMENT sy-vline
WA_PPOSTJOURNAL_STR-JOURNALENTRYTYPE sy-vline
WA_PPOSTJOURNAL_STR-ACCOUNTINGDOCUMENTTYPENAME sy-vline
WA_PPOSTJOURNAL_STR-PAYMENTDATE sy-vline
WA_PPOSTJOURNAL_STR-CUSTOMER sy-vline
WA_PPOSTJOURNAL_STR-PAYMENTTERMS sy-vline
WA_PPOSTJOURNAL_STR-PAYMENTMETHOD sy-vline
WA_PPOSTJOURNAL_STR-PAYMENTMETHODNAME sy-vline
WA_PPOSTJOURNAL_STR-PAYMENTMETHODSUPPLEMENT sy-vline
WA_PPOSTJOURNAL_STR-PAYMENTMETHODSUPPLEMENTNAME sy-vline
WA_PPOSTJOURNAL_STR-PAYMENTBLOCKINGREASON sy-vline
WA_PPOSTJOURNAL_STR-PAYMENTBLOCKINGREASONNAME sy-vline
WA_PPOSTJOURNAL_STR-PAYERPAYEE sy-vline
WA_PPOSTJOURNAL_STR-PAYERPAYEEFULLNAME sy-vline
WA_PPOSTJOURNAL_STR-BPBANKACCOUNTINTERNALID sy-vline
WA_PPOSTJOURNAL_STR-HOUSEBANK sy-vline
WA_PPOSTJOURNAL_STR-HOUSEBANKACCOUNT sy-vline
WA_PPOSTJOURNAL_STR-TREASURYPAYMENTFLOWDIRECTION sy-vline
WA_PPOSTJOURNAL_STR-STATECENTRALBANKPAYMENTREASON sy-vline
WA_PPOSTJOURNAL_STR-SUPPLYINGCOUNTRY sy-vline
WA_PPOSTJOURNAL_STR-COUNTRYNAME sy-vline
WA_PPOSTJOURNAL_STR-ASSIGNMENTREFERENCE sy-vline
WA_PPOSTJOURNAL_STR-JOURNALENTRYITEMTEXT sy-vline
WA_PPOSTJOURNAL_STR-BUSINESSAREA sy-vline
WA_PPOSTJOURNAL_STR-BUSINESSAREANAME sy-vline
WA_PPOSTJOURNAL_STR-COSTCENTER sy-vline
WA_PPOSTJOURNAL_STR-COSTCENTERNAME sy-vline
WA_PPOSTJOURNAL_STR-FINANCIALTRANSACTIONTYPE sy-vline
WA_PPOSTJOURNAL_STR-FINANCIALTRANSACTIONTYPENAME sy-vline
WA_PPOSTJOURNAL_STR-PARTNERCOMPANY sy-vline
WA_PPOSTJOURNAL_STR-COMPANYNAME sy-vline
WA_PPOSTJOURNAL_STR-COUNTERPARTY sy-vline
WA_PPOSTJOURNAL_STR-COUNTERPARTYFULLNAME sy-vline
WA_PPOSTJOURNAL_STR-ISSUER sy-vline
WA_PPOSTJOURNAL_STR-ISSUERFULLNAME sy-vline
WA_PPOSTJOURNAL_STR-SPECIALGLCODE sy-vline
WA_PPOSTJOURNAL_STR-SPECIALGLCODENAME sy-vline
WA_PPOSTJOURNAL_STR-TREASURYBUSINESSTRANSACTION sy-vline
WA_PPOSTJOURNAL_STR-TREASURYVALUATIONAREA sy-vline
WA_PPOSTJOURNAL_STR-TREASURYVALUATIONAREANAME sy-vline
WA_PPOSTJOURNAL_STR-REFERENCEDOCUMENT sy-vline
WA_PPOSTJOURNAL_STR-REFERENCEDOCUMENTCONTEXT sy-vline
WA_PPOSTJOURNAL_STR-POSTINGDATE sy-vline
WA_PPOSTJOURNAL_STR-FISCALPERIOD sy-vline
WA_PPOSTJOURNAL_STR-FISCALYEAR sy-vline
WA_PPOSTJOURNAL_STR-REVERSALREFERENCEDOCUMENT sy-vline
WA_PPOSTJOURNAL_STR-REVERSALREFERENCEDOCUMENTCNTXT sy-vline
WA_PPOSTJOURNAL_STR-REVERSEDOCUMENTPOSTINGDATE sy-vline
WA_PPOSTJOURNAL_STR-REVERSEDOCUMENTFISCALPERIOD sy-vline
WA_PPOSTJOURNAL_STR-REVERSEDOCUMENTFISCALYEAR sy-vline
WA_PPOSTJOURNAL_STR-LEDGER sy-vline
WA_PPOSTJOURNAL_STR-DOCUMENTDATE sy-vline
WA_PPOSTJOURNAL_STR-ACCOUNTINGPRINCIPLE sy-vline
WA_PPOSTJOURNAL_STR-TREASURYACCTGPOSTINGCATEGORY sy-vline
WA_PPOSTJOURNAL_STR-TREASURYBUSINESSTRANSCATEGORY sy-vline
WA_PPOSTJOURNAL_STR-TREASURYBUSTRANSCATEGORYNAME sy-vline
WA_PPOSTJOURNAL_STR-DOCUMENTHEADERTEXT sy-vline
WA_PPOSTJOURNAL_STR-DOCUMENTREFERENCE sy-vline
WA_PPOSTJOURNAL_STR-FINANCIALINSTRVALUATIONCLASS sy-vline
WA_PPOSTJOURNAL_STR-FINANCIALINSTRVALCLASSNAME sy-vline
WA_PPOSTJOURNAL_STR-TREASURYVALUATIONCLASS sy-vline
WA_PPOSTJOURNAL_STR-TREASURYVALUATIONCLASSNAME sy-vline
WA_PPOSTJOURNAL_STR-COMPANYCODE sy-vline
WA_PPOSTJOURNAL_STR-COMPANYCODENAME sy-vline
WA_PPOSTJOURNAL_STR-CHARTOFACCOUNTS sy-vline
WA_PPOSTJOURNAL_STR-FINANCIALINSTRUMENTPRODUCTTYPE sy-vline
WA_PPOSTJOURNAL_STR-FINANCIALINSTRPRODTYPENAME sy-vline
WA_PPOSTJOURNAL_STR-SECURITYACCOUNT sy-vline
WA_PPOSTJOURNAL_STR-SECURITYACCOUNTNAME sy-vline
WA_PPOSTJOURNAL_STR-SECURITYCLASS sy-vline
WA_PPOSTJOURNAL_STR-SECURITYCLASSNAME sy-vline
WA_PPOSTJOURNAL_STR-SECURITYCLASSDESCRIPTION sy-vline
WA_PPOSTJOURNAL_STR-DIFFERENTIATIONPORTFOLIO sy-vline
WA_PPOSTJOURNAL_STR-DIFFERENTIATIONPORTFOLIONAME sy-vline
WA_PPOSTJOURNAL_STR-SECURITYACCOUNTGROUP sy-vline
WA_PPOSTJOURNAL_STR-SECURITYACCOUNTGROUPNAME sy-vline
WA_PPOSTJOURNAL_STR-LOANCONTRACT sy-vline
WA_PPOSTJOURNAL_STR-LOANCONTRACTNAME sy-vline
WA_PPOSTJOURNAL_STR-TREASURYPOSITIONACCOUNT sy-vline
WA_PPOSTJOURNAL_STR-TREASURYPOSITIONACCOUNTNAME sy-vline
WA_PPOSTJOURNAL_STR-TREASURYPOSITIONLONGSHORTCODE sy-vline
WA_PPOSTJOURNAL_STR-FUND sy-vline
WA_PPOSTJOURNAL_STR-FUNDNAME sy-vline
WA_PPOSTJOURNAL_STR-GRANTID sy-vline
WA_PPOSTJOURNAL_STR-CENTRALCLEARINGACCOUNT sy-vline
WA_PPOSTJOURNAL_STR-CENTRALCLEARINGACCOUNTNAME sy-vline
WA_PPOSTJOURNAL_STR-ACTIVITYFINANCIALTRANSACTION sy-vline
WA_PPOSTJOURNAL_STR-FINANCIALTRANSACTION sy-vline
WA_PPOSTJOURNAL_STR-FINANCIALINSTRTRANSACTIONTYPE sy-vline
WA_PPOSTJOURNAL_STR-FINANCIALINSTRTRANSTYPENAME sy-vline
WA_PPOSTJOURNAL_STR-FINANCIALINSTRCHARACTERISTIC sy-vline
WA_PPOSTJOURNAL_STR-FINANCIALINSTRUMENTREFERENCE sy-vline
WA_PPOSTJOURNAL_STR-FINANCIALINSTRUMENTASSIGNMENT sy-vline
WA_PPOSTJOURNAL_STR-PORTFOLIO sy-vline
WA_PPOSTJOURNAL_STR-LETTEROFCREDIT sy-vline
WA_PPOSTJOURNAL_STR-HEDGINGCLASSIFICATION sy-vline
WA_PPOSTJOURNAL_STR-HEDGINGCLASSIFICATIONNAME sy-vline
WA_PPOSTJOURNAL_STR-CREATEDBYUSER sy-vline
WA_PPOSTJOURNAL_STR-CREATIONDATE sy-vline
WA_PPOSTJOURNAL_STR-LASTCHANGEDBYUSER sy-vline
WA_PPOSTJOURNAL_STR-LASTCHANGEDATE sy-vline
WA_PPOSTJOURNAL_STR-PAYMENTREQUEST sy-vline
WA_PPOSTJOURNAL_STR-PAYTREQORIGLREFERENCEDOCUMENT sy-vline
WA_PPOSTJOURNAL_STR-PAYMENTCURRENCY sy-vline
WA_PPOSTJOURNAL_STR-AMOUNTINPAYMENTCURRENCY sy-vline
WA_PPOSTJOURNAL_STR-TREASURYINDIVIDUALPAYMENT sy-vline
WA_PPOSTJOURNAL_STR-TRSYPAYTGROUPINGSAMEDRCTNISRQD sy-vline
WA_PPOSTJOURNAL_STR-TREASURYPAYMENTREQUESTGROUPING sy-vline
WA_PPOSTJOURNAL_STR-TRSYPAYTREQUESTGROUPINGNAME sy-vline
WA_PPOSTJOURNAL_STR-PAYMENTREQUESTPAYMENTGROUP sy-vline
WA_PPOSTJOURNAL_STR-CONSIDEREDPAYMENTMETHODS sy-vline
WA_PPOSTJOURNAL_STR-PAYTREQADDITIONALINSTRUCTIONS sy-vline
WA_PPOSTJOURNAL_STR-PAYTREQADDLINSTRUCTIONSNAME sy-vline
WA_PPOSTJOURNAL_STR-BANKCLEARINGGLACCOUNT sy-vline
WA_PPOSTJOURNAL_STR-TRSYPAYTREQUESTRELEASESTATUS sy-vline
WA_PPOSTJOURNAL_STR-TRSYPAYTREQUESTRELSTATUSNAME sy-vline
WA_PPOSTJOURNAL_STR-TRSYPOSFREEDEFINEDATTRIBUTE1 sy-vline
WA_PPOSTJOURNAL_STR-TRSYPOSFREEDEFINEDATTRIBUTE2 sy-vline
WA_PPOSTJOURNAL_STR-TRSYPOSFREEDEFINEDATTRIBUTE3 sy-vline
WA_PPOSTJOURNAL_STR-TRSYPOSFREEDEFINEDATTRIBUTE4 sy-vline
WA_PPOSTJOURNAL_STR-TRSYPOSFREEDEFINEDATTRIBUTE5 sy-vline
WA_PPOSTJOURNAL_STR-TRSYPOSFREEDEFINEDATTRIBUTE6 sy-vline
WA_PPOSTJOURNAL_STR-TRSYPOSFREEDEFINEDATTRIBUTE7 sy-vline
WA_PPOSTJOURNAL_STR-TRSYPOSFREEDEFINEDATTRIBUTE8 sy-vline
WA_PPOSTJOURNAL_STR-TRSYPOSFREEDEFINEDATTRIBUTE9 sy-vline
WA_PPOSTJOURNAL_STR-TRSYPOSFREEDFNDATTRIBUTE1NAME sy-vline
WA_PPOSTJOURNAL_STR-TRSYPOSFREEDFNDATTRIBUTE2NAME sy-vline
WA_PPOSTJOURNAL_STR-TRSYPOSFREEDFNDATTRIBUTE3NAME sy-vline
WA_PPOSTJOURNAL_STR-TRSYPOSFREEDFNDATTRIBUTE4NAME sy-vline
WA_PPOSTJOURNAL_STR-TRSYPOSFREEDFNDATTRIBUTE5NAME sy-vline
WA_PPOSTJOURNAL_STR-TRSYPOSFREEDFNDATTRIBUTE6NAME sy-vline
WA_PPOSTJOURNAL_STR-TREASURYACCOUNTINGCODE sy-vline
WA_PPOSTJOURNAL_STR-FINANCIALEXPOSUREITEM sy-vline
WA_PPOSTJOURNAL_STR-FINANCIALEXPOSUREITEMNAME sy-vline
WA_PPOSTJOURNAL_STR-FINANCIALEXPOSURESUBITEM sy-vline
WA_PPOSTJOURNAL_STR-FINANCIALEXPOSURESUBITEMNAME sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.