Kontakt

Ansicht
Dokumentation

RM06HL10_EKET_WESBB_UPDATE - Correction Report: Update EKET-WESBB and RESB-ENMNG (Note 3011682)

RM06HL10_EKET_WESBB_UPDATE - Correction Report: Update EKET-WESBB and RESB-ENMNG (Note 3011682)

ROGBILLS - Synchronize billing plans   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.
SAP E-Book

Purpose

Program RM06HL10_EKET_WESBB_UPDATE is an analysis and correction program developed for SAP note 3011682.
As of SAP note 3011682 the valuated goods receipt blocked stock is updated for the scheduling lines (EKET-WESBB). This program detects and corrects purchasing document items with inconsistent quantity in field EKET-WESBB and RESB-ENMNG.

Execute the program to check/correct the valuated goods receipt blocked stock for the scheduling lines (EKET-WESBB) and the quantity withdrawn of the corresponding subcontractor dependent requirements for the components (RESB-ENMNG) of a purchase order or scheduling agreement.

The update is required for purchase order items with an open quantity in the valuated goods receipt blocked stock if the corresponding goods movement was posted before the implementation of SAP note 3011682 (The valuated goods receipt blocked stock quantity is increased e.g. via movement type 107 or 110. The valuated goods receipt blocked stock quantity is decreased e.g. via movement type 109 or 108).

The update of the subcontractor dependent requirements of the components (RESB-ENMNG) is relevant for subcontracting items (EKPO-PSTYP = “3 - Subcontracting”) without real-time consumption posting of subcontracting components (EKPO-ITCONS = " ") only.

Perform and check the correction in your test system first before you perform the correction in your production system!

Integration

Prerequisites

Features

You can execute the program in foreground or background. In foreground the program displays the result in an ALV table control. You can click on the hotspot in column EKBE, EKET_UPD and RESB_UPD to display the data records of the DB table EKBE, EKET and RESB. In background the program generates one spool per DB table.

Selection

The program selects the purchasing documents based on the following selection parameters:

  • Company Code(EKKO-BUKRS).
  • Purchasing Document Type(EKKO-BSART).
  • Vendor(EKKO-LIFNR).
  • Purchasing Document(EKKO-EBELN).
  • Purchasing Document Item(EKPO-EBELP).
  • Items with "Delivery Completed"(EKPO-ELIKZ). Per default the program does not select purchasing document items which are completely delivered. If you activate the parameter, the program selects items which are completely delivered too.
  • Deletion Indicator(EKPO-LOEKZ). Per default the program selects not blocked/deleted purchasing document items (EKPO-LOEKZ = " ") and blocked items (EKPO-LOEKZ = "S"). (The program does not select items which are marked for deletion (EKPO-LOEKZ = "L"). If you want to select items independent from the blocking/deletion indicator (EKPO-LOEKZ), delete the default values for the select option).
  • Item Change Date(EKPO-AEDAT).

The following selection parameters are implemented in the program logic and cannot be changed via the selection screen:

  • Purchasing Document Category(EKPO-BSTYP): The program selects purchase orders (EKPO-BSTYP = "F") and scheduling agreements (EKPO-BSTYP = "L").
  • Item Category(EKPO-PSTYP): The program selects the item categories “0 - Standard”, “3 - Subcontracting” "5 - Third Party" and "7 - Stock Transfer".

The program selects the purchasing document data as join from table EKKO and EKPO.

  • Package size: The package size controls the number of purchasing documents which are checked during one run. If you face a problem because of memory shortage (e.g. the runtime error TSV_TNEW_PAGE_ALLOC_FAILED) decrease the package size.
  • User: Enter the user "SAP_3011682" to display the radio button "Update".
  • Display items with error only: Per Default the checkbox is inactive. The program displays all selected purchasing document items. Activate the checkbox if you would like to display the purchasing document items with errors only.
  • Simulation: Activate the radio button to execute the program in simulation mode. The program selects the incorrect data records and calculates the valuated goods receipt blocked stock for the scheduling lines (EKET-WESBB). The expected value is displayed in column WESBB_NEW of table EKET_UPD.
    For subcontracting items (EKPO-PSTYP = “3 - Subcontracting”) without real-time consumption posting of subcontracting components (EKPO-ITCONS = " ") the subcontractor dependent requirements for the components (RESB-ENMNG) can be displayed via table RESB_UPD.
  • Update: Per default the radio button "Update" is hidden. Activate the radio button to execute the program in update mode. The program selects the incorrect data records and performs the update on DB level. The program corrects the valuated goods receipt blocked stock for the scheduling lines (EKET-WESBB) and the corresponding subcontractor dependent requirements for the components (RESB-ENMNG). The update of the quantity withdrawn (RESB-ENMNG) is performed via the function module MD_KOMPONENTEN_ANPASSEN_ENMNG.
    The program locks the purchasing document during the analysis (lock for object EMEKKOE). The program releases the lock if the purchasing document is not relevant for a DB update or after the program updated the DB record(s).

Standard Variants

Output

Per default the following columns are displayed with the technical field name as column heading:

  • EBELN(EKKO-EBELN - Purchasing Document Number).
  • EBELP(EKPO-EBELP - Item Number of Purchasing Document).
  • BSTYP(EKKO-BSTYP - Purchasing Document Category)
  • BSART(EKKO-BSART - Purchasing Document Type).
  • BSAKZ(EKKO-BSAKZ - Control indicator for purchasing document type)
  • BUKRS(EKKO-BUKRS - Company Code on item level).
  • EKORG(EKKO-EKORG - Purchasing Organization).
  • LIFNR(EKKO-LIFNR - Vendor Account Number).
  • BEDAT(EKKO-BEDAT - Purchasing Document Date).
  • RESWK(EKKO-RESWK - Supplying (issuing) plant in case of stock transport order).
  • LOEKZ(EKPO-LOEKZ - Deletion Indicator).
  • STATU(EKPO-STATU - RFQ status).
  • AEDAT(EKPO-AEDAT - Purchasing Document Item Change Date).
  • ELIKZ(EKPO-ELIKZ - "Delivery Completed" Indicator).
  • PSTYP(EKPO-PSTYP - Item Category in Purchasing Document).
  • KNTTP(EKPO-KNTTP - Account Assignment Category).
  • WEPOS(EKPO-WEPOS - Goods Receipt Indicator).
  • WEUNB(EKPO-WEUNB - Goods Receipt, Non-Valuated).
  • SOBKZ(EKPO-SOBKZ - Special Stock Indicator).
  • ITCONS(EKPO-ITCONS - Real-Time Consumption Posting of Subcontracting Components).
  • EKBE(History per Purchasing Document): The column displays the number of selected data from DB table EKBE. You can click on the hotspot in column EKBE to display the result.
  • EKET_UPD(Update: Scheduling Agreement Schedule Lines): The column displays the number of selected data from DB table EKET. You can click on the hotspot in column EKET_UPD to display the result. Per default the result is sorted after EBELN, EBELP, EINDT and ETENR in ascending order.
  • If WESBB is correct for all EKET-records, the cell is highlighted in green. If WESBB is incorrect for at least one EKET-record, the cell is highlighted in red.
  • WESBB: Valuated goods receipt blocked stock for the scheduling line (EKET-WESBB). If WESBB is correct the cell is highlighted in green else, it is highlighted in red.

  • WESBB_NEW: New valuated goods receipt blocked stock for the scheduling line. If the new quantity matches the current quantity the cell is highlighted in green and
    The program calculates the sum of the valuated goods receipt blocked stock based on the purchase order history (EKBE-WESBB). The sum of the valuated goods receipt blocked stock is distributed to the scheduling lines (EKET-WESBB_NEW) in ascending order (EBELN, EBELP, EINDT, ETENR).

  • UPDKZ(Technical field for Update): see details below.

  • STATUS(Processing Status): see details below.

  • MSG(Message Text): see details below.

  • RESB_UPD(Update: Reservation/dependent requirements): The column displays the number of selected data from DB table RESB. You can click on the hotspot in column RESB_UPD to display the result.
  • ENMNG: Quantity Withdrawn for the subcontractor dependent requirements of the components (RESB-ENMNG).
    If the valuated goods receipt blocked stock for the scheduling line (EKET-WESBB) is updated the
    related subcontractor dependent requirements of the components are updated too (The update is triggered via the standard function module MD_KOMPONENTEN_ANPASSEN_ENMNG).
    WESBB is correct the cell is highlighted in green else, it is highlighted in red.

  • UPDKZ(Technical field for Update): see details below.

  • STATUS(Processing Status): see details below.

  • MSG(Message Text): see details below.

  • UPDKZ(Technical field for Update): The column displays whether an update is required and possible ("U" = update is required and possible; " " = update is not required or not possible).
  • STATUS(Processing Status): The column displays the processing status of the record.
  • Icon Checked("@01@"): The record is correct, no update required.

  • Icon Activate("@3C@): The record is incorrect and can be updated.

  • Icon Message Warning("@1A@"): The program raised a warning during the check or the update, see details in column MSG (Message Text).

  • Icon Failure("@03@"): The program raised an error during the check or the update, see details in column MSG (Message Text).

  • Icon Locked("@06@"): The purchase order item is already locked by another process, no update possible.

  • MSG(Message Text). Additional information, e.g. the message text of warnings or errors is displayed in this column.

Activities

Example






CL_GUI_FRONTEND_SERVICES - Frontend Services   General Data in Customer Master  
This documentation is copyright by SAP AG.

Length: 12919 Date: 20240520 Time: 073518     sap01-206 ( 185 ms )