Kontakt

Ansicht
Dokumentation

WRB_PO_GET_DETAILED_VENDOR - NOTRANSL: Liefert eine detaillierte Liste von offenen Bestellungen für 1 L

WRB_PO_GET_DETAILED_VENDOR - NOTRANSL: Liefert eine detaillierte Liste von offenen Bestellungen für 1 L

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   PERFORM Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

Functionality

This module determines open purchase orders (EKPO-ELIKZ ='') for a vendor (parameter VENDOR), which fulfill certain criteria. For each item in an open purchase order, a line is created in table DETAILED_LIST containing the following information:

  • Purchase order number
  • Item number
  • Delivery completed indicator
  • Gross order value of the item
  • Order quantity of the item
  • Summed order quantity of the selected schedule lines for this item
  • Summed goods receipt quantity of the selected schedule lines for this item
  • Currency key for the order currency
  • Promotion number

To limit the number of hits further, you also need to enter a list of plants (parameter SITE_LIST) to which the purchase orders are delivered (EKPO-WERKS) and the time period (beginning and end) for the delivery date (EKET-EINDT).

The information is determined using Join from the corresponding database tables to obtain the best possible performance. Parameter MAX_RESULT_SIZE can also be used to limit the number of hits.

Example

Notes

It is necessary to specify a valid time period for the delivery date (beginning and end must be valid dates and the beginning must be before the end or on the same date) otherwise the exception ILLEGAL_DATE_RANGE is generated. It is not necessary to specify the vendor list and the plant list, however, if you do not, purchase orders for all vendors and/or all plants in the system will be searched. This can cause serious problems with performance. SAP therefore strongly recommends that you limit the selection to a few vendors and plants and also that you make the time period for the delivery date as short as possible (a few days).

Further information





Parameters

DELIVERY_DATE_FROM
DELIVERY_DATE_TO
DETAILED_LIST
MAX_RESULT_SIZE
SITE_LIST
VENDOR

Exceptions

ILLEGAL_DATE_RANGE
MAX_RESULT_SIZE_EXCEEDED
NO_AUTHORITY_FOR_SITES
NO_AUTHORITY_FOR_VENDORS

Function Group

WRB_PO

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Length: 2621 Date: 20240605 Time: 182419     sap01-206 ( 63 ms )