SAP Reports / Programs

Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

SAPPIPRL SAP ABAP Report - Create List of Inspection Lots

SAP T-Codes / Example ABAP code
ABAP OO / SAP Function Modules
ABAP reports / SAP Error Messages
SAP Tables / SAP Video Training

SAPPIPRL is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for The report RQGAAM31 reads information on inspection lots from the logical database PGQ and creates a printout of the inspection results for these inspection lots...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.

If you would like to execute this report or see the full code listing simply enter SAPPIPRL into the relevant SAP transactions such as SE38 or SE80

ABAP code to call this SAP report using the submit statement

This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.

SUBMIT SAPPIPRL. "Basic submit
SUBMIT SAPPIPRL AND RETURN. "Return to original report after report execution complete
SUBMIT SAPPIPRL VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement

Text pool values

Selection Text: P_CHTEXT = Inspection descriptions
Selection Text: P_EINZEL = Single values
Selection Text: P_FETEXT = Error text
Selection Text: P_PLVIEW = Part. lot view for prod. lots
Selection Text: P_TLTEXT = Long texts for lots/part. lots
Selection Text: P_VETEXT = Long texts for UD
Title: Create List of Inspection Lots
Text Symbol: 015 = Vendor name
Text Symbol: 014 = Spec. status
Text Symbol: 013 = Defects found
Text Symbol: 012 = No defects found
Text Symbol: 011 = Usage decision made
Text Symbol: 010 = No usage decision made
Text Symbol: 009 = Origin :
Text Symbol: 008 = Status :
Text Symbol: 007 = Inspection type :
Text Symbol: 003 = Inspection lot :
Text Symbol: 002 = Page
Text Symbol: 001 = Order Record: Simulate Inspection Lot from Production
Text Symbol: 017 = Customer name
Text Symbol: 030 = No characteristics found for this operation
Text Symbol: 029 = Part.lot
Text Symbol: 028 = Operation
Text Symbol: 027 = Insp. operation
Text Symbol: 026 = Task list :
Text Symbol: 025 = Long text:
Text Symbol: 024 = Sample size:
Text Symbol: 023 = Lot size :
Text Symbol: 022 = Inspection finish:
Text Symbol: 044 = Min. value of valid measured values
Text Symbol: 043 = Max. value of valid measured values
Text Symbol: 042 = Std deviation of valid measured values
Text Symbol: 041 = Mean value of valid measured values
Text Symbol: 040 = Results:
Text Symbol: 039 = Values
Text Symbol: 038 = Remarks
Text Symbol: 037 = Order record: simulate inspection lot report from goods receipt
Text Symbol: 036 = Attribute

Text Symbol: 035 = Status
Text Symbol: 034 = Characteristic
Text Symbol: 033 = No partial lots selected for this lot
Text Symbol: 032 = No operations selected for inspection lot
Text Symbol: 045 = Code
Text Symbol: 059 = No.of defects
Text Symbol: 058 = Code group
Text Symbol: 057 = Overview of defects found for lot
Text Symbol: 056 = No characteristics found for this insp. point
Text Symbol: 055 = Rework quantity
Text Symbol: 054 = Scrap quantity
Text Symbol: 053 = Quantity :
Text Symbol: 052 = Batch
Text Symbol: 051 = Partial lot qty
Text Symbol: 049 = Date:
Text Symbol: 048 = Quality score
Text Symbol: 047 = Usage decision
Text Symbol: 046 = Inspection point
Text Symbol: 031 = No inspection points found for this operation
Text Symbol: 016 = Vendor number
Text Symbol: 021 = Inspection start :
Text Symbol: 071 = Upper tol. limit
Text Symbol: 070 = Char. target value
Text Symbol: 069 = Inspect. version
Text Symbol: 068 = Insp.catalog type
Text Symbol: 067 = Inspector qual.
Text Symbol: 066 = Plant f. insp.meth
Text Symbol: 065 = Inspection method
Text Symbol: 063 = Usage decision for partial lot
Text Symbol: 062 = Overview of defects found for characteristic:
Text Symbol: 061 = Overview of defects found for operation
Text Symbol: 060 = Short text of usage decision code
Text Symbol: 074 = 1st lower limit
Text Symbol: 087 = Acceptance number
Text Symbol: 086 = No. of recorded sample units
Text Symbol: 085 = No. of incorrect sample units
Text Symbol: 084 = No. of valid partial samples
Text Symbol: 083 = Single unit no.
Text Symbol: 082 = Catalog type

Text Symbol: 081 = Additional info
Text Symbol: 080 = Insp. specificat.:
Text Symbol: 079 = Formula
Text Symbol: 078 = Lower plaus. limit
Text Symbol: 077 = Upper plaus. limit
Text Symbol: 076 = 2nd lower limit
Text Symbol: 075 = 2nd upper limit
Text Symbol: 072 = Low. tol. limit
Text Symbol: 020 = Check using material specification
Text Symbol: 019 = No task list assigned
Text Symbol: 018 = Customer number
Text Symbol: S02 = Operation:
Text Symbol: S01 = Digital signatures for results recording
Text Symbol: ARW = Order record: archive inspection lot from goods receipt
Text Symbol: ARA = Order record: archive inspection lot from production
Text Symbol: 098 = Valuation rule
Text Symbol: 097 = Phrase set
Text Symbol: 096 = Defect class
Text Symbol: 095 = Version
Text Symbol: 094 = Meas. reading
Text Symbol: 093 = Inspector
Text Symbol: 092 = Single results no.
Text Symbol: 091 = Sample no.
Text Symbol: 089 = Acc.const. VarInsp
Text Symbol: S03 = Date :
Text Symbol: S11 = Digital signatures for usage decision
Text Symbol: S10 = Comment:
Text Symbol: S09 = Comment language:
Text Symbol: S06 = Signatory:
Text Symbol: S05 = Signature no.:
Text Symbol: S04 = Time:
Text Symbol: 088 = Rejection no.
Text Symbol: 073 = 1st upper limit

INCLUDES used within this REPORT SAPPIPRL

INCLUDE LQPL1TS0.
INCLUDE LPPPITXT.

TABLES used within REPORT and the associated SELECT statement:

No SAP DATABASE tables are accessed within this REPORT code!

Function Modules used within report and the associated call statement:

QAST_STATUS_CHECK CALL FUNCTION 'QAST_STATUS_CHECK' EXPORTING i_objnr = qals-objnr i_status = c_status_stip EXCEPTIONS status_not_activ = 01.

TQ30_READ CALL FUNCTION 'TQ30_READ' EXPORTING i_art = qals-art i_sprache = sy-langu IMPORTING e_tq30t = tq30t EXCEPTIONS no_entry = 01.

GET_TEXT_DOMVALUE CALL FUNCTION 'GET_TEXT_DOMVALUE' EXPORTING domname = g_domname domvalue = g_domvalue langu = sy-langu IMPORTING txt = qgres-herkunft EXCEPTIONS not_found = 01.

QAST_STATUS_CHECK CALL FUNCTION 'QAST_STATUS_CHECK' EXPORTING i_objnr = qals-objnr i_status = c_status_ve EXCEPTIONS status_not_activ = 01.

T006_READ
  CALL FUNCTION 'T006_READ'
    EXPORTING
      msehi    = qals-mengeneinh
      spras    = qals-sprache
    IMPORTING
      struct   = t006
    EXCEPTIONS
      no_entry = 01
      no_text  = 02.

T006_READ
  CALL FUNCTION 'T006_READ'
    EXPORTING
      msehi    = qals-einhprobe
      spras    = qals-sprache
    IMPORTING
      struct   = t006
    EXCEPTIONS
      no_entry = 01
      no_text  = 02.

GET_TEXT_DOMVALUE CALL FUNCTION 'GET_TEXT_DOMVALUE' EXPORTING domname = g_domname domvalue = g_domvalue langu = sy-langu IMPORTING txt = qgres-vbewertung EXCEPTIONS not_found = 01.

QPK1_CODE_TEXT CALL FUNCTION 'QPK1_CODE_TEXT' EXPORTING i_katalogart = qavp-vkatart i_codegruppe = qavp-vcodegrp i_code = qavp-vcode i_sprache = sy-langu IMPORTING e_text = qgres-codeve EXCEPTIONS no_match_in_range = 01.

GET_TEXT_DOMVALUE CALL FUNCTION 'GET_TEXT_DOMVALUE' EXPORTING domname = g_domname domvalue = g_domvalue langu = sy-langu IMPORTING txt = qgres-vbewertung EXCEPTIONS not_found = 01.

QPK1_CODE_TEXT CALL FUNCTION 'QPK1_CODE_TEXT' EXPORTING i_katalogart = qavt-vkatart i_codegruppe = qavt-vcodegrp i_code = qavt-vcode i_sprache = sy-langu IMPORTING e_text = qgres-codeve EXCEPTIONS no_match_in_range = 01.

DD_DOMVALUE_TEXT_GET CALL FUNCTION 'DD_DOMVALUE_TEXT_GET' EXPORTING domname = g_domname value = g_domvalue langu = qals-sprache bypass_buffer = ' ' IMPORTING dd07v_wa = idd07v.

GET_TEXT_DOMVALUE CALL FUNCTION 'GET_TEXT_DOMVALUE' EXPORTING domname = g_domname domvalue = g_domvalue langu = sy-langu IMPORTING txt = qgres-mbewertg EXCEPTIONS not_found = 01.

TQSS1_READ CALL FUNCTION 'TQSS1_READ' EXPORTING i_werks = qals-werk IMPORTING e_tqss1 = tqss1 EXCEPTIONS no_entry = 01.

QAFD_TQ79_READ CALL FUNCTION 'QAFD_TQ79_READ' EXPORTING i_slwbez = l_slwbez IMPORTING e_tq79 = tq79 EXCEPTIONS not_found = 01.

QAFD_TQ79T_READ CALL FUNCTION 'QAFD_TQ79T_READ' EXPORTING i_slwbez = l_slwbez i_sprache = sy-langu IMPORTING e_tq79t = tq79t EXCEPTIONS not_found = 01.

QAPP_IP_SELECT_KEY_LONG_FIELD CALL FUNCTION 'QAPP_IP_SELECT_KEY_LONG_FIELD' EXPORTING i_qapp = qapp i_slwbez = qals-slwbez IMPORTING e_pruefpkt = qappw-pruefpkt.

QAPP_IP_USER_FIELDS_FOR_LIST CALL FUNCTION 'QAPP_IP_USER_FIELDS_FOR_LIST' EXPORTING i_tq79 = tq79 i_tq79t = tq79t TABLES t_user_tab = x_qappusrtab.

GET_TEXT_DOMVALUE CALL FUNCTION 'GET_TEXT_DOMVALUE' EXPORTING domname = g_domname domvalue = g_domvalue langu = sy-langu IMPORTING txt = qgres-vbewertung EXCEPTIONS not_found = 01.

QPK1_CODE_TEXT CALL FUNCTION 'QPK1_CODE_TEXT' EXPORTING i_katalogart = qapp-vkatart i_codegruppe = qapp-vcodegrp i_code = qapp-vcode i_sprache = sy-langu IMPORTING e_text = qgres-codeve EXCEPTIONS no_match_in_range = 01.

GET_TEXT_DOMVALUE CALL FUNCTION 'GET_TEXT_DOMVALUE' EXPORTING domname = g_domname domvalue = g_domvalue langu = sy-langu IMPORTING txt = qgres-mbewertg EXCEPTIONS not_found = 01.

TQSS1_READ CALL FUNCTION 'TQSS1_READ' EXPORTING i_werks = qals-werk IMPORTING e_tqss1 = tqss1 EXCEPTIONS no_entry = 01.

QAFD_TQ79_READ CALL FUNCTION 'QAFD_TQ79_READ' EXPORTING i_slwbez = l_slwbez IMPORTING e_tq79 = tq79 EXCEPTIONS not_found = 01.

QAFD_TQ79T_READ CALL FUNCTION 'QAFD_TQ79T_READ' EXPORTING i_slwbez = l_slwbez i_sprache = sy-langu IMPORTING e_tq79t = tq79t EXCEPTIONS not_found = 01.

QAPP_IP_SELECT_KEY_LONG_FIELD CALL FUNCTION 'QAPP_IP_SELECT_KEY_LONG_FIELD' EXPORTING i_qapp = qapp "mit dem Inhalt von QALTPP i_slwbez = qals-slwbez IMPORTING e_pruefpkt = qappw-pruefpkt.

QAPP_IP_USER_FIELDS_FOR_LIST CALL FUNCTION 'QAPP_IP_USER_FIELDS_FOR_LIST' EXPORTING i_tq79 = tq79 i_tq79t = tq79t TABLES t_user_tab = x_qappusrtab.

GET_TEXT_DOMVALUE CALL FUNCTION 'GET_TEXT_DOMVALUE' EXPORTING domname = g_domname domvalue = g_domvalue langu = sy-langu IMPORTING txt = qgres-vbewertung EXCEPTIONS not_found = 01.

QPK1_CODE_TEXT CALL FUNCTION 'QPK1_CODE_TEXT' EXPORTING i_katalogart = qaltpp-vkatart i_codegruppe = qaltpp-vcodegrp i_code = qaltpp-vcode i_sprache = sy-langu IMPORTING e_text = qgres-codeve EXCEPTIONS no_match_in_range = 01.

GET_TEXT_DOMVALUE CALL FUNCTION 'GET_TEXT_DOMVALUE' EXPORTING domname = g_domname domvalue = g_domvalue langu = sy-langu IMPORTING txt = qgres-mbewertg EXCEPTIONS not_found = 01.

QEEA_STATUS_TEXT_READING CALL FUNCTION 'QEEA_STATUS_TEXT_READING' EXPORTING i_sprache = sy-langu i_status = l_spectab-satzstatus IMPORTING e_kurztext = qgres-statusv EXCEPTIONS no_entry_found = 01.

QEEA_STATUS_TEXT_READING CALL FUNCTION 'QEEA_STATUS_TEXT_READING' EXPORTING i_sprache = sy-langu i_status = l_resulttab-satzstatus IMPORTING e_kurztext = qgres-statusr EXCEPTIONS no_entry_found = 01.

GET_TEXT_DOMVALUE CALL FUNCTION 'GET_TEXT_DOMVALUE' EXPORTING domname = g_domname domvalue = g_domvalue langu = sy-langu IMPORTING txt = qgres-attribut EXCEPTIONS not_found = 01.

TQSS1_READ CALL FUNCTION 'TQSS1_READ' EXPORTING i_werks = qals-werk IMPORTING e_tqss1 = tqss1 EXCEPTIONS no_entry = 01.

QPK1_CODE_TEXT CALL FUNCTION 'QPK1_CODE_TEXT' EXPORTING i_katalogart = l_resulttab-katalgart1 i_codegruppe = l_resulttab-gruppe1 i_code = l_resulttab-code1 i_sprache = sy-langu IMPORTING e_text = qgres-code1 EXCEPTIONS no_match_in_range = 01.

FLTP_CHAR_CONVERSION CALL FUNCTION 'FLTP_CHAR_CONVERSION' EXPORTING decim = l_convert_digits expon = 0 input = l_convert_number ivalu = l_convert_not_initial IMPORTING flstr = l_convert_character.

READ_TEXT
  CALL FUNCTION 'READ_TEXT'
    EXPORTING
      client    = mandant
      id        = id
      language  = sprache
      name      = hname
      object    = object
    TABLES
      lines     = textl
    EXCEPTIONS
      not_found = 01.

CONVERT_TEXT
    CALL FUNCTION 'CONVERT_TEXT'
      EXPORTING
        direction      = 'EXPORT'
        formatwidth    = 72
        format_type    = 'ASCII'
        header         = x_header
        ssheet         = ' '
        with_tab       = ' '
        word_langu     = sy-langu
        tabletype      = 'ASC'
        tab_substitute = 'X09  '
        lf_substitute  = ' '
      TABLES
        foreign        = textl_neu
        itf_lines      = textl
      EXCEPTIONS
        OTHERS         = 1.

QPK1_CODE_TEXT CALL FUNCTION 'QPK1_CODE_TEXT' EXPORTING i_katalogart = qmfel-fekat i_codegruppe = qmfel-fegrp i_code = qmfel-fecod i_sprache = sy-langu IMPORTING e_text = qgres-codeve EXCEPTIONS no_match_in_range = 01.

DD_DOMVALUE_TEXT_GET CALL FUNCTION 'DD_DOMVALUE_TEXT_GET' EXPORTING domname = g_domname value = g_domvalue langu = qals-sprache bypass_buffer = ' ' IMPORTING dd07v_wa = idd07v.

TQSS1_READ
*    call function 'TQSS1_READ'
*         exporting
*              i_werks  = qals-werk
*         importing
*              e_tqss1  = tqss1
*         exceptions
*              no_entry = 01.

QPK1_CODEGROUP_TEXT CALL FUNCTION 'QPK1_CODEGROUP_TEXT' EXPORTING i_katalogart = katalgart i_codegruppe = auswmenge i_sprache = sy-langu IMPORTING e_grouptext = grp_kurztxt EXCEPTIONS no_match_in_range = 1 OTHERS = 2.

QPL2_GET_VORNR_FROM_VORGLFNR CALL FUNCTION 'QPL2_GET_VORNR_FROM_VORGLFNR' EXPORTING i_aufpl = qals-aufpl i_aplzl = signs_tab-vorglfnr IMPORTING e_vornr = signs_tab-vornr EXCEPTIONS inconsistent_parameters = 1 internal_error = 2 no_data_found = 3 OTHERS = 4.

READ_TEXT CALL FUNCTION 'READ_TEXT' EXPORTING client = sy-mandt id = 'COMM' language = signs_tab-comm_lang name = l_textname object = 'SIGNATURE' TABLES lines = textl EXCEPTIONS not_found = 01.

CONVERT_TEXT CALL FUNCTION 'CONVERT_TEXT' EXPORTING direction = 'EXPORT' formatwidth = 72 format_type = 'ASCII' header = x_header ssheet = ' ' with_tab = ' ' word_langu = sy-langu tabletype = 'ASC' tab_substitute = 'X09 ' lf_substitute = ' ' TABLES foreign = textl_neu itf_lines = textl EXCEPTIONS OTHERS = 1.

SIGN_READ CALL FUNCTION 'SIGN_READ' EXPORTING object_imp = '20' key_lot_imp = l_rc73 TABLES signs_lot_tab = lt_signs_tab EXCEPTIONS key_for_object_incomplete = 1 no_signatures_found = 2 OTHERS = 3.

Contribute (Add Comments)

Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.

The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.

This will then be available for everyone to easily find by simply searching on the report name SAPPIPRL or its description.

SAPPIPRL - Create List of Inspection Lots
SAPPIPRL - Create List of Inspection Lots
SAPPI260 - Transfer of Production Commitments as Confirmations to R/2 PPC
SAPPI260 - Transfer of Production Commitments as Confirmations to R/2 PPC
SAPPI250 - Transfer of R/2 Production Orders as PI Production Requirements
SAPPI250 - Transfer of R/2 Production Orders as PI Production Requirements