ABAP Select data from SAP table PPRDPLANTBASIC 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 PPRDPLANTBASIC 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 PPRDPLANTBASIC. 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 PPRDPLANTBASIC 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_PPRDPLANTBASIC TYPE STANDARD TABLE OF PPRDPLANTBASIC, WA_PPRDPLANTBASIC TYPE PPRDPLANTBASIC, 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: <PPRDPLANTBASIC> TYPE PPRDPLANTBASIC. *Process all fields in table header/work area as string values PERFORM process_as_string_field_values CHANGING wa_PPRDPLANTBASIC. SELECT * *restrict ABAP select to first 10 rows UP TO 10 ROWS FROM PPRDPLANTBASIC INTO TABLE IT_PPRDPLANTBASIC. *Select data and declare internal table using in-line method @DATA *SELECT * * FROM PPRDPLANTBASIC * INTO TABLE @DATA(IT_PPRDPLANTBASIC2). *--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_PPRDPLANTBASIC INDEX 1 INTO DATA(WA_PPRDPLANTBASIC2). *Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL LOOP AT IT_PPRDPLANTBASIC ASSIGNING <PPRDPLANTBASIC>.*To update a field value using a field symbol simply change the value via the field symbol pointer
<PPRDPLANTBASIC>-MANDT = 1.
<PPRDPLANTBASIC>-PRODUCT = 1.
<PPRDPLANTBASIC>-PLANT = 1.
<PPRDPLANTBASIC>-MAINTENANCESTATUS = 1.
<PPRDPLANTBASIC>-ISMARKEDFORDELETION = 1.
ENDLOOP. LOOP AT IT_PPRDPLANTBASIC INTO WA_PPRDPLANTBASIC. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_PPRDPLANTBASIC-VALUATIONCATEGORY, sy-vline,
WA_PPRDPLANTBASIC-ISINTERNALBATCHMANAGED, sy-vline,
WA_PPRDPLANTBASIC-PROFILECODE, sy-vline,
WA_PPRDPLANTBASIC-PROFILEVALIDITYSTARTDATE, sy-vline,
WA_PPRDPLANTBASIC-ABCINDICATOR, sy-vline,
WA_PPRDPLANTBASIC-PRODUCTISCRITICALPRT, sy-vline.
ENDLOOP. *Add any further fields from structure WA_PPRDPLANTBASIC 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_PPRDPLANTBASIC 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_PPRDPLANTBASIC INTO WA_PPRDPLANTBASIC. *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 MATN1, internal->external for field PRODUCT CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_PPRDPLANTBASIC-PRODUCT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PPRDPLANTBASIC-PRODUCT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field GOODSISSUEUNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_PPRDPLANTBASIC-GOODSISSUEUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PPRDPLANTBASIC-GOODSISSUEUNIT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field FOLLOWUPPRODUCT CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_PPRDPLANTBASIC-FOLLOWUPPRODUCT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PPRDPLANTBASIC-FOLLOWUPPRODUCT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field PRODMAXIMUMSTORAGEPERIODUNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_PPRDPLANTBASIC-PRODMAXIMUMSTORAGEPERIODUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PPRDPLANTBASIC-PRODMAXIMUMSTORAGEPERIODUNIT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field COMMODITIYCODENUMBERUNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_PPRDPLANTBASIC-COMMODITIYCODENUMBERUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PPRDPLANTBASIC-COMMODITIYCODENUMBERUNIT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PROFITCENTER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_PPRDPLANTBASIC-PROFITCENTER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PPRDPLANTBASIC-PROFITCENTER.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field SOURCEBOMALTERNATIVE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_PPRDPLANTBASIC-SOURCEBOMALTERNATIVE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PPRDPLANTBASIC-SOURCEBOMALTERNATIVE.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field TASKLISTGROUP CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_PPRDPLANTBASIC-TASKLISTGROUP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PPRDPLANTBASIC-TASKLISTGROUP.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field TASKLISTGROUPCOUNTER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_PPRDPLANTBASIC-TASKLISTGROUPCOUNTER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PPRDPLANTBASIC-TASKLISTGROUPCOUNTER.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field PRODUCTPRODUCTIONQUANTITYUNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_PPRDPLANTBASIC-PRODUCTPRODUCTIONQUANTITYUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PPRDPLANTBASIC-PRODUCTPRODUCTIONQUANTITYUNIT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field CONFIGURABLEPRODUCT CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_PPRDPLANTBASIC-CONFIGURABLEPRODUCT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PPRDPLANTBASIC-CONFIGURABLEPRODUCT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field CONSUMPTIONREFERENCEPRODUCT CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_PPRDPLANTBASIC-CONSUMPTIONREFERENCEPRODUCT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PPRDPLANTBASIC-CONSUMPTIONREFERENCEPRODUCT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PRODUCTCFOPCATEGORY CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_PPRDPLANTBASIC-PRODUCTCFOPCATEGORY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PPRDPLANTBASIC-PRODUCTCFOPCATEGORY.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field ORIGINALBATCHREFERENCEMATERIAL CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_PPRDPLANTBASIC-ORIGINALBATCHREFERENCEMATERIAL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PPRDPLANTBASIC-ORIGINALBATCHREFERENCEMATERIAL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field GRHANDLINGCAPACITYUNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_PPRDPLANTBASIC-GRHANDLINGCAPACITYUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PPRDPLANTBASIC-GRHANDLINGCAPACITYUNIT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field GIHANDLINGCAPACITYUNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_PPRDPLANTBASIC-GIHANDLINGCAPACITYUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PPRDPLANTBASIC-GIHANDLINGCAPACITYUNIT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field LOTSIZEUNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_PPRDPLANTBASIC-LOTSIZEUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PPRDPLANTBASIC-LOTSIZEUNIT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field CONSUMPTIONOFSTORAGECAPUNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_PPRDPLANTBASIC-CONSUMPTIONOFSTORAGECAPUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PPRDPLANTBASIC-CONSUMPTIONOFSTORAGECAPUNIT.
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_PPRDPLANTBASIC_STR,
MANDT TYPE STRING,
PRODUCT TYPE STRING,
PLANT TYPE STRING,
MAINTENANCESTATUS TYPE STRING,
ISMARKEDFORDELETION TYPE STRING,
VALUATIONCATEGORY TYPE STRING,
ISINTERNALBATCHMANAGED TYPE STRING,
PROFILECODE TYPE STRING,
PROFILEVALIDITYSTARTDATE TYPE STRING,
ABCINDICATOR TYPE STRING,
PRODUCTISCRITICALPRT TYPE STRING,
PURCHASINGGROUP TYPE STRING,
GOODSISSUEUNIT TYPE STRING,
MRPPROFILE TYPE STRING,
MRPTYPE TYPE STRING,
MRPRESPONSIBLE TYPE STRING,
PLANNEDDELIVERYDURATIONINDAYS TYPE STRING,
GOODSRECEIPTDURATION TYPE STRING,
PERIODTYPE TYPE STRING,
ASSEMBLYSCRAPPERCENT TYPE STRING,
LOTSIZINGPROCEDURE TYPE STRING,
PROCUREMENTTYPE TYPE STRING,
PROCUREMENTSUBTYPE TYPE STRING,
REORDERTHRESHOLDQUANTITY TYPE STRING,
SAFETYSTOCKQUANTITY TYPE STRING,
MINIMUMLOTSIZEQUANTITY TYPE STRING,
MAXIMUMLOTSIZEQUANTITY TYPE STRING,
FIXEDLOTSIZEQUANTITY TYPE STRING,
LOTSIZEROUNDINGQUANTITY TYPE STRING,
MAXIMUMSTOCKQUANTITY TYPE STRING,
LOTSIZEINDEPENDENTCOSTS TYPE STRING,
DEPENDENTREQUIREMENTSTYPE TYPE STRING,
STORAGECOSTSPERCENTAGECODE TYPE STRING,
PRODUCTISTOBEDISCONTINUED TYPE STRING,
EFFECTIVEOUTDATE TYPE STRING,
FOLLOWUPPRODUCT TYPE STRING,
PRODRQMTSARECONSOLIDATED TYPE STRING,
MRPAVAILABILITYTYPE TYPE STRING,
SCHEDULINGMARGINKEY TYPE STRING,
MATLCOMPISMARKEDFORBACKFLUSH TYPE STRING,
PRODUCTIONSUPERVISOR TYPE STRING,
PROCESSINGTIMEINDAYS TYPE STRING,
SETUPANDTEARDOWNTIME TYPE STRING,
TRANSITIONTIME TYPE STRING,
MATERIALBASEQUANTITY TYPE STRING,
INHOUSEPRODUCTIONTIME TYPE STRING,
MAXIMUMSTORAGEPERIOD TYPE STRING,
PRODMAXIMUMSTORAGEPERIODUNIT TYPE STRING,
PRODISWITHDRAWNFRMPRODNBIN TYPE STRING,
OVERDELIVTOLERANCELIMIT TYPE STRING,
UNLIMITEDOVERDELIVISALLOWED TYPE STRING,
UNDERDELIVTOLERANCELIMIT TYPE STRING,
TOTALREPLENISHMENTLEADTIME TYPE STRING,
REPLACEMENTPARTTYPE TYPE STRING,
HASPOSTTOINSPECTIONSTOCK TYPE STRING,
INSPLOTSAMPLEQUANTITYINPERCENT TYPE STRING,
QUALITYMGMTCTRLKEY TYPE STRING,
INSPLOTDURATIONINDAYS TYPE STRING,
INSPLOTDOCUMENTATIONISREQUIRED TYPE STRING,
RECRRGINSPINTERVALTIMEINDAYS TYPE STRING,
LOADINGGROUP TYPE STRING,
ISBATCHMANAGEMENTREQUIRED TYPE STRING,
QUOTAARRANGEMENTUSAGE TYPE STRING,
SRVCLVL TYPE STRING,
FORECASTREQUIREMENTSARESPLIT TYPE STRING,
AVAILABILITYCHECKTYPE TYPE STRING,
FISCALYEARVARIANT TYPE STRING,
CORRECTIONFACTORISREQUIRED TYPE STRING,
WRKCENTERSSHIPGSETUPTIMEINDAYS TYPE STRING,
CAPPLANNINGQUANTITYINBASEUOM TYPE STRING,
PRODUCTSHIPPINGPROCESSINGTIME TYPE STRING,
SOURCEOFSUPPLYCATEGORY TYPE STRING,
ISAUTOPURORDCREATIONALLOWED TYPE STRING,
ISSOURCELISTREQUIRED TYPE STRING,
COUNTRYOFORIGIN TYPE STRING,
REGIONOFORIGIN TYPE STRING,
COMMODITIYCODENUMBERUNIT TYPE STRING,
EXPORTANDIMPORTPRODUCTGROUP TYPE STRING,
PROFITCENTER TYPE STRING,
MRPPLANNINGCALENDAR TYPE STRING,
REPETITIVEMANUFACTURINGISALLWD TYPE STRING,
PLANNINGTIMEFENCE TYPE STRING,
PRODRQMTSCONSUMPTIONMODE TYPE STRING,
BACKWARDCNSMPNPERIODINWORKDAYS TYPE STRING,
FWDCONSUMPTIONPERIODINWORKDAYS TYPE STRING,
HASPRODUCTIONVERSION TYPE STRING,
SOURCEBOMALTERNATIVE TYPE STRING,
PRODUCTBOMUSAGE TYPE STRING,
TASKLISTGROUP TYPE STRING,
TASKLISTGROUPCOUNTER TYPE STRING,
COSTINGLOTSIZE TYPE STRING,
COSTINGSPECIALPROCUREMENTTYPE TYPE STRING,
PRODUCTPRODUCTIONQUANTITYUNIT TYPE STRING,
PRODUCTIONINVTRYMANAGEDLOC TYPE STRING,
MRPGROUP TYPE STRING,
COMPONENTSCRAPINPERCENT TYPE STRING,
PRODUCTQUALITYCERTIFICATETYPE TYPE STRING,
PRODUCTPLANTHASINSPECTIONSETUP TYPE STRING,
RQMTQTYRCPTTAKTTMEINWRKGDAYS TYPE STRING,
RANGEOFCVRGPRFLCODE TYPE STRING,
INVENTORYFORCYCLECOUNTIND TYPE STRING,
VARIANCEKEY TYPE STRING,
SERIALNUMBERPROFILE TYPE STRING,
PRODUCTCONFIGURATION TYPE STRING,
CONFIGURABLEPRODUCT TYPE STRING,
REPETITIVEMANUFACTURINGPROFILE TYPE STRING,
ISNEGATIVESTOCKALLOWED TYPE STRING,
SUPLRQUALITYMANAGEMENTSYSTEM TYPE STRING,
PLANANDORDERDAYDETERMINATION TYPE STRING,
ROUNDINGPROFILE TYPE STRING,
CONSUMPTIONREFERENCEPRODUCT TYPE STRING,
CONSUMPTIONREFERENCEPLANT TYPE STRING,
CONSUMPTIONREFUSAGEENDDATE TYPE STRING,
CONSUMPTIONQTYMULTIPLIER TYPE STRING,
FORECASTMODELISRESET TYPE STRING,
PROVISIONINGSERVICELEVEL TYPE STRING,
ISCOPRODUCT TYPE STRING,
PLANNINGSTRATEGYGROUP TYPE STRING,
DFLTSTORAGELOCATIONEXTPROCMT TYPE STRING,
ISBULKMATERIALCOMPONENT TYPE STRING,
CYCLECOUNTINGINDICATORISFIXED TYPE STRING,
STOCKDETERMINATIONGROUP TYPE STRING,
MATLQUALITYAUTHORIZATIONGROUP TYPE STRING,
TASKLISTTYPE TYPE STRING,
PRODUCTIONSCHEDULINGPROFILE TYPE STRING,
ISSAFETYTIME TYPE STRING,
SAFETYDURATION TYPE STRING,
PLANNEDORDERACTIONCONTROL TYPE STRING,
PRODNORDERISBATCHREQUIRED TYPE STRING,
PRODUCTUNITGROUP TYPE STRING,
MATERIALFREIGHTGROUP TYPE STRING,
COSTINGPRODUCTIONVERSION TYPE STRING,
ISFIXEDPRICECOPRODUCT TYPE STRING,
PRODUCTLOGISTICSHANDLINGGROUP TYPE STRING,
DISTRCNTRDISTRIBUTIONPROFILE TYPE STRING,
PRODUCTCFOPCATEGORY TYPE STRING,
PRODUCTCASNUMBER TYPE STRING,
PRODINTLTRADECLASSIFICATION TYPE STRING,
CONSUMPTIONTAXCTRLCODE TYPE STRING,
ITMISRLVTTOJITDELIVSCHEDULES TYPE STRING,
TRANSITIONMATRIXPRODUCTSGROUP TYPE STRING,
PROPOSEDPRODUCTSUPPLYAREA TYPE STRING,
PERDPRFLFORSFTYTME TYPE STRING,
ISMRPDEPENDENTRQMT TYPE STRING,
PRODUCTISFORCROSSPROJECT TYPE STRING,
ORDERCHANGEMANAGEMENTPROFILE TYPE STRING,
MINIMUMSAFETYSTOCKQUANTITY TYPE STRING,
PRODUCTISCOSTINGRELEVANT TYPE STRING,
WRHSMGMTPTWYANDSTKREMOVALSTRGY TYPE STRING,
ORIGLBATCHMANAGEMENTISREQUIRED TYPE STRING,
ORIGINALBATCHREFERENCEMATERIAL TYPE STRING,
PRODUCTISEXCISETAXRELEVANT TYPE STRING,
ISADVANCEDPLANNINGUSED TYPE STRING,
CONSIGNMENTCONTROL TYPE STRING,
GOODISSUEPROCESSINGDAYS TYPE STRING,
ISPURGACROSSPURGGROUP TYPE STRING,
LOCPRODGOODSRECEIPTPROCHOURS TYPE STRING,
LOCPRODGOODSISSUEPROCHOURS TYPE STRING,
LOCPRODSTORAGECOSTVALUE TYPE STRING,
REPLENISHMENTLEADTIMEDAYS TYPE STRING,
PPPLANNINGPROCEDURE TYPE STRING,
PRODNPLNGHEURISTIC TYPE STRING,
PRODUCTPLANNINGPACKAGE TYPE STRING,
SFTYSTKVIOLTNPNLTYCOSTVALUE TYPE STRING,
PRODUCTALERTRELEVANCECODE TYPE STRING,
RESOURCENETWORKNAME TYPE STRING,
GRHANDLINGCAPACITYQUANTITY TYPE STRING,
GRHANDLINGCAPACITYUNIT TYPE STRING,
GIHANDLINGCAPACITYQUANTITY TYPE STRING,
GIHANDLINGCAPACITYUNIT TYPE STRING,
ISLOCDEPENDENTSHELFLIFEUSED TYPE STRING,
SHELFLIFELOCDEPENDENT TYPE STRING,
MATURATIONDURNLOCDEPENDENT TYPE STRING,
RQDMINSHELFLIFELOCDEPDNT TYPE STRING,
RQDMAXSHELFLIFELOCDEPDNT TYPE STRING,
LOTSIZEUNIT TYPE STRING,
REORDERDAYSSUPPLYINWORKDAYS TYPE STRING,
TARGETDAYSSUPPLYINWORKDAYS TYPE STRING,
PLNGCALENDARPERDCLOTSIZING TYPE STRING,
REQUIREMENTSTRATEGY TYPE STRING,
ALERTTHLDFORDLYDRCPTDURN TYPE STRING,
ALERTTHLDFOREARLYRCPTDURN TYPE STRING,
PEGGINGSTRATEGY TYPE STRING,
ISALERTSINPEGGINGAVOIDED TYPE STRING,
ISFIXEDPEGGINGFORPRODRETAINED TYPE STRING,
BOMTYPEEXPLOSIONUSED TYPE STRING,
PRODUCTPLANNINGGROUP TYPE STRING,
INTERACTIVESOURCINGPROFILE TYPE STRING,
PRODUCTPRIORITY TYPE STRING,
MINPASSINGAMTCONTINUOUSPEGGING TYPE STRING,
CONVERSIONRULE TYPE STRING,
ISTOTALQTYRECEIPTELEMENT TYPE STRING,
ISTOTALQTYSTOCKELEMENT TYPE STRING,
ESPPISUSED TYPE STRING,
SRVCPARTSTHROUGHPUTTIMEDURN TYPE STRING,
THIRDPARTYORDERPROCESSING TYPE STRING,
VCLSAFETYSTOCKQUANTITY TYPE STRING,
PARLOCSAFETYSTOCKQUANTITY TYPE STRING,
VCLPARLOCSAFETYSTOCKQUANTITY TYPE STRING,
REPAIRSAFETYSTOCKQUANTITY TYPE STRING,
VCLREPAIRSAFETYSTOCKQUANTITY TYPE STRING,
VCLREORDERPOINTQUANTITY TYPE STRING,
VCLMAXIMUMSTOCKQUANTITY TYPE STRING,
COSTFACTORFORSTOCKHOLDINGVAL TYPE STRING,
PRODUCTPROCUREMENTCOSTSVAL TYPE STRING,
GOODSRECEIPTHANDLINGCOST TYPE STRING,
GOODSISSUEHANDLINGCOST TYPE STRING,
CONSUMPTIONOFSTORAGECAPACITY TYPE STRING,
GIPOSTINGISSYNCHRONOUS TYPE STRING,
CONSUMPTIONOFSTORAGECAPUNIT TYPE STRING,
MRPSAFETYSTOCKMETHOD TYPE STRING,END OF T_EKKO_STR. DATA: WA_PPRDPLANTBASIC_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_PPRDPLANTBASIC_STR-MANDT sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCT sy-vline
WA_PPRDPLANTBASIC_STR-PLANT sy-vline
WA_PPRDPLANTBASIC_STR-MAINTENANCESTATUS sy-vline
WA_PPRDPLANTBASIC_STR-ISMARKEDFORDELETION sy-vline
WA_PPRDPLANTBASIC_STR-VALUATIONCATEGORY sy-vline
WA_PPRDPLANTBASIC_STR-ISINTERNALBATCHMANAGED sy-vline
WA_PPRDPLANTBASIC_STR-PROFILECODE sy-vline
WA_PPRDPLANTBASIC_STR-PROFILEVALIDITYSTARTDATE sy-vline
WA_PPRDPLANTBASIC_STR-ABCINDICATOR sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTISCRITICALPRT sy-vline
WA_PPRDPLANTBASIC_STR-PURCHASINGGROUP sy-vline
WA_PPRDPLANTBASIC_STR-GOODSISSUEUNIT sy-vline
WA_PPRDPLANTBASIC_STR-MRPPROFILE sy-vline
WA_PPRDPLANTBASIC_STR-MRPTYPE sy-vline
WA_PPRDPLANTBASIC_STR-MRPRESPONSIBLE sy-vline
WA_PPRDPLANTBASIC_STR-PLANNEDDELIVERYDURATIONINDAYS sy-vline
WA_PPRDPLANTBASIC_STR-GOODSRECEIPTDURATION sy-vline
WA_PPRDPLANTBASIC_STR-PERIODTYPE sy-vline
WA_PPRDPLANTBASIC_STR-ASSEMBLYSCRAPPERCENT sy-vline
WA_PPRDPLANTBASIC_STR-LOTSIZINGPROCEDURE sy-vline
WA_PPRDPLANTBASIC_STR-PROCUREMENTTYPE sy-vline
WA_PPRDPLANTBASIC_STR-PROCUREMENTSUBTYPE sy-vline
WA_PPRDPLANTBASIC_STR-REORDERTHRESHOLDQUANTITY sy-vline
WA_PPRDPLANTBASIC_STR-SAFETYSTOCKQUANTITY sy-vline
WA_PPRDPLANTBASIC_STR-MINIMUMLOTSIZEQUANTITY sy-vline
WA_PPRDPLANTBASIC_STR-MAXIMUMLOTSIZEQUANTITY sy-vline
WA_PPRDPLANTBASIC_STR-FIXEDLOTSIZEQUANTITY sy-vline
WA_PPRDPLANTBASIC_STR-LOTSIZEROUNDINGQUANTITY sy-vline
WA_PPRDPLANTBASIC_STR-MAXIMUMSTOCKQUANTITY sy-vline
WA_PPRDPLANTBASIC_STR-LOTSIZEINDEPENDENTCOSTS sy-vline
WA_PPRDPLANTBASIC_STR-DEPENDENTREQUIREMENTSTYPE sy-vline
WA_PPRDPLANTBASIC_STR-STORAGECOSTSPERCENTAGECODE sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTISTOBEDISCONTINUED sy-vline
WA_PPRDPLANTBASIC_STR-EFFECTIVEOUTDATE sy-vline
WA_PPRDPLANTBASIC_STR-FOLLOWUPPRODUCT sy-vline
WA_PPRDPLANTBASIC_STR-PRODRQMTSARECONSOLIDATED sy-vline
WA_PPRDPLANTBASIC_STR-MRPAVAILABILITYTYPE sy-vline
WA_PPRDPLANTBASIC_STR-SCHEDULINGMARGINKEY sy-vline
WA_PPRDPLANTBASIC_STR-MATLCOMPISMARKEDFORBACKFLUSH sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTIONSUPERVISOR sy-vline
WA_PPRDPLANTBASIC_STR-PROCESSINGTIMEINDAYS sy-vline
WA_PPRDPLANTBASIC_STR-SETUPANDTEARDOWNTIME sy-vline
WA_PPRDPLANTBASIC_STR-TRANSITIONTIME sy-vline
WA_PPRDPLANTBASIC_STR-MATERIALBASEQUANTITY sy-vline
WA_PPRDPLANTBASIC_STR-INHOUSEPRODUCTIONTIME sy-vline
WA_PPRDPLANTBASIC_STR-MAXIMUMSTORAGEPERIOD sy-vline
WA_PPRDPLANTBASIC_STR-PRODMAXIMUMSTORAGEPERIODUNIT sy-vline
WA_PPRDPLANTBASIC_STR-PRODISWITHDRAWNFRMPRODNBIN sy-vline
WA_PPRDPLANTBASIC_STR-OVERDELIVTOLERANCELIMIT sy-vline
WA_PPRDPLANTBASIC_STR-UNLIMITEDOVERDELIVISALLOWED sy-vline
WA_PPRDPLANTBASIC_STR-UNDERDELIVTOLERANCELIMIT sy-vline
WA_PPRDPLANTBASIC_STR-TOTALREPLENISHMENTLEADTIME sy-vline
WA_PPRDPLANTBASIC_STR-REPLACEMENTPARTTYPE sy-vline
WA_PPRDPLANTBASIC_STR-HASPOSTTOINSPECTIONSTOCK sy-vline
WA_PPRDPLANTBASIC_STR-INSPLOTSAMPLEQUANTITYINPERCENT sy-vline
WA_PPRDPLANTBASIC_STR-QUALITYMGMTCTRLKEY sy-vline
WA_PPRDPLANTBASIC_STR-INSPLOTDURATIONINDAYS sy-vline
WA_PPRDPLANTBASIC_STR-INSPLOTDOCUMENTATIONISREQUIRED sy-vline
WA_PPRDPLANTBASIC_STR-RECRRGINSPINTERVALTIMEINDAYS sy-vline
WA_PPRDPLANTBASIC_STR-LOADINGGROUP sy-vline
WA_PPRDPLANTBASIC_STR-ISBATCHMANAGEMENTREQUIRED sy-vline
WA_PPRDPLANTBASIC_STR-QUOTAARRANGEMENTUSAGE sy-vline
WA_PPRDPLANTBASIC_STR-SRVCLVL sy-vline
WA_PPRDPLANTBASIC_STR-FORECASTREQUIREMENTSARESPLIT sy-vline
WA_PPRDPLANTBASIC_STR-AVAILABILITYCHECKTYPE sy-vline
WA_PPRDPLANTBASIC_STR-FISCALYEARVARIANT sy-vline
WA_PPRDPLANTBASIC_STR-CORRECTIONFACTORISREQUIRED sy-vline
WA_PPRDPLANTBASIC_STR-WRKCENTERSSHIPGSETUPTIMEINDAYS sy-vline
WA_PPRDPLANTBASIC_STR-CAPPLANNINGQUANTITYINBASEUOM sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTSHIPPINGPROCESSINGTIME sy-vline
WA_PPRDPLANTBASIC_STR-SOURCEOFSUPPLYCATEGORY sy-vline
WA_PPRDPLANTBASIC_STR-ISAUTOPURORDCREATIONALLOWED sy-vline
WA_PPRDPLANTBASIC_STR-ISSOURCELISTREQUIRED sy-vline
WA_PPRDPLANTBASIC_STR-COUNTRYOFORIGIN sy-vline
WA_PPRDPLANTBASIC_STR-REGIONOFORIGIN sy-vline
WA_PPRDPLANTBASIC_STR-COMMODITIYCODENUMBERUNIT sy-vline
WA_PPRDPLANTBASIC_STR-EXPORTANDIMPORTPRODUCTGROUP sy-vline
WA_PPRDPLANTBASIC_STR-PROFITCENTER sy-vline
WA_PPRDPLANTBASIC_STR-MRPPLANNINGCALENDAR sy-vline
WA_PPRDPLANTBASIC_STR-REPETITIVEMANUFACTURINGISALLWD sy-vline
WA_PPRDPLANTBASIC_STR-PLANNINGTIMEFENCE sy-vline
WA_PPRDPLANTBASIC_STR-PRODRQMTSCONSUMPTIONMODE sy-vline
WA_PPRDPLANTBASIC_STR-BACKWARDCNSMPNPERIODINWORKDAYS sy-vline
WA_PPRDPLANTBASIC_STR-FWDCONSUMPTIONPERIODINWORKDAYS sy-vline
WA_PPRDPLANTBASIC_STR-HASPRODUCTIONVERSION sy-vline
WA_PPRDPLANTBASIC_STR-SOURCEBOMALTERNATIVE sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTBOMUSAGE sy-vline
WA_PPRDPLANTBASIC_STR-TASKLISTGROUP sy-vline
WA_PPRDPLANTBASIC_STR-TASKLISTGROUPCOUNTER sy-vline
WA_PPRDPLANTBASIC_STR-COSTINGLOTSIZE sy-vline
WA_PPRDPLANTBASIC_STR-COSTINGSPECIALPROCUREMENTTYPE sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTPRODUCTIONQUANTITYUNIT sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTIONINVTRYMANAGEDLOC sy-vline
WA_PPRDPLANTBASIC_STR-MRPGROUP sy-vline
WA_PPRDPLANTBASIC_STR-COMPONENTSCRAPINPERCENT sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTQUALITYCERTIFICATETYPE sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTPLANTHASINSPECTIONSETUP sy-vline
WA_PPRDPLANTBASIC_STR-RQMTQTYRCPTTAKTTMEINWRKGDAYS sy-vline
WA_PPRDPLANTBASIC_STR-RANGEOFCVRGPRFLCODE sy-vline
WA_PPRDPLANTBASIC_STR-INVENTORYFORCYCLECOUNTIND sy-vline
WA_PPRDPLANTBASIC_STR-VARIANCEKEY sy-vline
WA_PPRDPLANTBASIC_STR-SERIALNUMBERPROFILE sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTCONFIGURATION sy-vline
WA_PPRDPLANTBASIC_STR-CONFIGURABLEPRODUCT sy-vline
WA_PPRDPLANTBASIC_STR-REPETITIVEMANUFACTURINGPROFILE sy-vline
WA_PPRDPLANTBASIC_STR-ISNEGATIVESTOCKALLOWED sy-vline
WA_PPRDPLANTBASIC_STR-SUPLRQUALITYMANAGEMENTSYSTEM sy-vline
WA_PPRDPLANTBASIC_STR-PLANANDORDERDAYDETERMINATION sy-vline
WA_PPRDPLANTBASIC_STR-ROUNDINGPROFILE sy-vline
WA_PPRDPLANTBASIC_STR-CONSUMPTIONREFERENCEPRODUCT sy-vline
WA_PPRDPLANTBASIC_STR-CONSUMPTIONREFERENCEPLANT sy-vline
WA_PPRDPLANTBASIC_STR-CONSUMPTIONREFUSAGEENDDATE sy-vline
WA_PPRDPLANTBASIC_STR-CONSUMPTIONQTYMULTIPLIER sy-vline
WA_PPRDPLANTBASIC_STR-FORECASTMODELISRESET sy-vline
WA_PPRDPLANTBASIC_STR-PROVISIONINGSERVICELEVEL sy-vline
WA_PPRDPLANTBASIC_STR-ISCOPRODUCT sy-vline
WA_PPRDPLANTBASIC_STR-PLANNINGSTRATEGYGROUP sy-vline
WA_PPRDPLANTBASIC_STR-DFLTSTORAGELOCATIONEXTPROCMT sy-vline
WA_PPRDPLANTBASIC_STR-ISBULKMATERIALCOMPONENT sy-vline
WA_PPRDPLANTBASIC_STR-CYCLECOUNTINGINDICATORISFIXED sy-vline
WA_PPRDPLANTBASIC_STR-STOCKDETERMINATIONGROUP sy-vline
WA_PPRDPLANTBASIC_STR-MATLQUALITYAUTHORIZATIONGROUP sy-vline
WA_PPRDPLANTBASIC_STR-TASKLISTTYPE sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTIONSCHEDULINGPROFILE sy-vline
WA_PPRDPLANTBASIC_STR-ISSAFETYTIME sy-vline
WA_PPRDPLANTBASIC_STR-SAFETYDURATION sy-vline
WA_PPRDPLANTBASIC_STR-PLANNEDORDERACTIONCONTROL sy-vline
WA_PPRDPLANTBASIC_STR-PRODNORDERISBATCHREQUIRED sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTUNITGROUP sy-vline
WA_PPRDPLANTBASIC_STR-MATERIALFREIGHTGROUP sy-vline
WA_PPRDPLANTBASIC_STR-COSTINGPRODUCTIONVERSION sy-vline
WA_PPRDPLANTBASIC_STR-ISFIXEDPRICECOPRODUCT sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTLOGISTICSHANDLINGGROUP sy-vline
WA_PPRDPLANTBASIC_STR-DISTRCNTRDISTRIBUTIONPROFILE sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTCFOPCATEGORY sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTCASNUMBER sy-vline
WA_PPRDPLANTBASIC_STR-PRODINTLTRADECLASSIFICATION sy-vline
WA_PPRDPLANTBASIC_STR-CONSUMPTIONTAXCTRLCODE sy-vline
WA_PPRDPLANTBASIC_STR-ITMISRLVTTOJITDELIVSCHEDULES sy-vline
WA_PPRDPLANTBASIC_STR-TRANSITIONMATRIXPRODUCTSGROUP sy-vline
WA_PPRDPLANTBASIC_STR-PROPOSEDPRODUCTSUPPLYAREA sy-vline
WA_PPRDPLANTBASIC_STR-PERDPRFLFORSFTYTME sy-vline
WA_PPRDPLANTBASIC_STR-ISMRPDEPENDENTRQMT sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTISFORCROSSPROJECT sy-vline
WA_PPRDPLANTBASIC_STR-ORDERCHANGEMANAGEMENTPROFILE sy-vline
WA_PPRDPLANTBASIC_STR-MINIMUMSAFETYSTOCKQUANTITY sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTISCOSTINGRELEVANT sy-vline
WA_PPRDPLANTBASIC_STR-WRHSMGMTPTWYANDSTKREMOVALSTRGY sy-vline
WA_PPRDPLANTBASIC_STR-ORIGLBATCHMANAGEMENTISREQUIRED sy-vline
WA_PPRDPLANTBASIC_STR-ORIGINALBATCHREFERENCEMATERIAL sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTISEXCISETAXRELEVANT sy-vline
WA_PPRDPLANTBASIC_STR-ISADVANCEDPLANNINGUSED sy-vline
WA_PPRDPLANTBASIC_STR-CONSIGNMENTCONTROL sy-vline
WA_PPRDPLANTBASIC_STR-GOODISSUEPROCESSINGDAYS sy-vline
WA_PPRDPLANTBASIC_STR-ISPURGACROSSPURGGROUP sy-vline
WA_PPRDPLANTBASIC_STR-LOCPRODGOODSRECEIPTPROCHOURS sy-vline
WA_PPRDPLANTBASIC_STR-LOCPRODGOODSISSUEPROCHOURS sy-vline
WA_PPRDPLANTBASIC_STR-LOCPRODSTORAGECOSTVALUE sy-vline
WA_PPRDPLANTBASIC_STR-REPLENISHMENTLEADTIMEDAYS sy-vline
WA_PPRDPLANTBASIC_STR-PPPLANNINGPROCEDURE sy-vline
WA_PPRDPLANTBASIC_STR-PRODNPLNGHEURISTIC sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTPLANNINGPACKAGE sy-vline
WA_PPRDPLANTBASIC_STR-SFTYSTKVIOLTNPNLTYCOSTVALUE sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTALERTRELEVANCECODE sy-vline
WA_PPRDPLANTBASIC_STR-RESOURCENETWORKNAME sy-vline
WA_PPRDPLANTBASIC_STR-GRHANDLINGCAPACITYQUANTITY sy-vline
WA_PPRDPLANTBASIC_STR-GRHANDLINGCAPACITYUNIT sy-vline
WA_PPRDPLANTBASIC_STR-GIHANDLINGCAPACITYQUANTITY sy-vline
WA_PPRDPLANTBASIC_STR-GIHANDLINGCAPACITYUNIT sy-vline
WA_PPRDPLANTBASIC_STR-ISLOCDEPENDENTSHELFLIFEUSED sy-vline
WA_PPRDPLANTBASIC_STR-SHELFLIFELOCDEPENDENT sy-vline
WA_PPRDPLANTBASIC_STR-MATURATIONDURNLOCDEPENDENT sy-vline
WA_PPRDPLANTBASIC_STR-RQDMINSHELFLIFELOCDEPDNT sy-vline
WA_PPRDPLANTBASIC_STR-RQDMAXSHELFLIFELOCDEPDNT sy-vline
WA_PPRDPLANTBASIC_STR-LOTSIZEUNIT sy-vline
WA_PPRDPLANTBASIC_STR-REORDERDAYSSUPPLYINWORKDAYS sy-vline
WA_PPRDPLANTBASIC_STR-TARGETDAYSSUPPLYINWORKDAYS sy-vline
WA_PPRDPLANTBASIC_STR-PLNGCALENDARPERDCLOTSIZING sy-vline
WA_PPRDPLANTBASIC_STR-REQUIREMENTSTRATEGY sy-vline
WA_PPRDPLANTBASIC_STR-ALERTTHLDFORDLYDRCPTDURN sy-vline
WA_PPRDPLANTBASIC_STR-ALERTTHLDFOREARLYRCPTDURN sy-vline
WA_PPRDPLANTBASIC_STR-PEGGINGSTRATEGY sy-vline
WA_PPRDPLANTBASIC_STR-ISALERTSINPEGGINGAVOIDED sy-vline
WA_PPRDPLANTBASIC_STR-ISFIXEDPEGGINGFORPRODRETAINED sy-vline
WA_PPRDPLANTBASIC_STR-BOMTYPEEXPLOSIONUSED sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTPLANNINGGROUP sy-vline
WA_PPRDPLANTBASIC_STR-INTERACTIVESOURCINGPROFILE sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTPRIORITY sy-vline
WA_PPRDPLANTBASIC_STR-MINPASSINGAMTCONTINUOUSPEGGING sy-vline
WA_PPRDPLANTBASIC_STR-CONVERSIONRULE sy-vline
WA_PPRDPLANTBASIC_STR-ISTOTALQTYRECEIPTELEMENT sy-vline
WA_PPRDPLANTBASIC_STR-ISTOTALQTYSTOCKELEMENT sy-vline
WA_PPRDPLANTBASIC_STR-ESPPISUSED sy-vline
WA_PPRDPLANTBASIC_STR-SRVCPARTSTHROUGHPUTTIMEDURN sy-vline
WA_PPRDPLANTBASIC_STR-THIRDPARTYORDERPROCESSING sy-vline
WA_PPRDPLANTBASIC_STR-VCLSAFETYSTOCKQUANTITY sy-vline
WA_PPRDPLANTBASIC_STR-PARLOCSAFETYSTOCKQUANTITY sy-vline
WA_PPRDPLANTBASIC_STR-VCLPARLOCSAFETYSTOCKQUANTITY sy-vline
WA_PPRDPLANTBASIC_STR-REPAIRSAFETYSTOCKQUANTITY sy-vline
WA_PPRDPLANTBASIC_STR-VCLREPAIRSAFETYSTOCKQUANTITY sy-vline
WA_PPRDPLANTBASIC_STR-VCLREORDERPOINTQUANTITY sy-vline
WA_PPRDPLANTBASIC_STR-VCLMAXIMUMSTOCKQUANTITY sy-vline
WA_PPRDPLANTBASIC_STR-COSTFACTORFORSTOCKHOLDINGVAL sy-vline
WA_PPRDPLANTBASIC_STR-PRODUCTPROCUREMENTCOSTSVAL sy-vline
WA_PPRDPLANTBASIC_STR-GOODSRECEIPTHANDLINGCOST sy-vline
WA_PPRDPLANTBASIC_STR-GOODSISSUEHANDLINGCOST sy-vline
WA_PPRDPLANTBASIC_STR-CONSUMPTIONOFSTORAGECAPACITY sy-vline
WA_PPRDPLANTBASIC_STR-GIPOSTINGISSYNCHRONOUS sy-vline
WA_PPRDPLANTBASIC_STR-CONSUMPTIONOFSTORAGECAPUNIT sy-vline
WA_PPRDPLANTBASIC_STR-MRPSAFETYSTOCKMETHOD sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.