Allocation - Schedule Line with Goods Receipt

Technical Data

Type of DataSource	Transaction Data (Movement Data)
Application Component	Materials Management (MM)
Available as of OLTP Release	SAP R/3 4.0B
Available as of Plug-In Release	PI 2002.1
RemoteCube Compatibility	No

Prerequisites

Activation of the DataSource.

Use

This DataSource is used to extract the schedule line quantities allocated with goods receipt quantities consistently to a BW system.

Delta Update

A delta update is supported. Delta process: ABR – Complete delta update with deletion indicator using delta queue (Cube-compatible).

Fields of Origin in the Extraction Structure

Field in Extraction Structure	Description of Field in Extraction Structure	Table of Origin	Field in Table of Origin
BWVORG	BW: Transaction Key SAP BW	hard-coded
EBELN	Document Number of Purchasing Document	EKET	EBELN
EBELP	Item Number of Purchasing Document	EKET	EBELP
SCLDT	Item Delivery Date	EKET	EINDT
SCLTM	Time of Delivery Date	EKET	UZEIT
SCLNR	Schedule Line Counter	EKET	ETENR
GMVPDT	Schedule Line Purchase Order Date	EKBE	BUDAT
BELNR	Number of Material Document	EKBE	BELNR
BUZEI	Item in Material Document	EKBE	BUZEI
SCLQTY	Schedule Line Quantity	EKET	MENGE
GMVQTY	Goods Movement Quantity	EKBE	MENGE
OPNQTY	Open Quantity	calculated
TTLQTY	Assigned Quantity	calculated
MEINS	Base Unit of Measure	EKPO	MEINS
ROCANCEL	Cancellation of Data Record	hard-coded

Features of Extractor

This DataSource provides information about the quantity of goods movements that were distributed to the schedule lines.

This means that the sequence of information in this DataSource is based on information in the schedule lines, but not on the information in the goods movement.

Because it is possible to post a goods receipt with a posting date (EKBE-BUDAT) that lies before or after the document creation date (EKBE-CPUDT), the creation date of the goods receipt document (GR document) plays an important role in the quantity distribution process.

The first GR document created is also the first document whose quantities are distributed, and this occurs irrespective of the posting date.

The information is only available in this DataSource if a goods movement was posted with respect to an order. Information about orders without goods receipt is not available.

In the Purchasing component in the SAP R/ 3 System, you will find data on goods movements in the table EKBE ( Purchasing Document History ), and data on schedule lines in the table EKET ( Scheduling Agreement Schedule Lines ).

To improve performance, this DataSource contains no information about scheduling agreements. This also applies to returns items, service items, and limit items.

For more information about purchasing documents, confirmations, and schedule lines, see the SAP Library under Start of the navigation path Materials Management Next navigation step Purchasing End of the navigation path .

Important Key Figures

SCLNR	Schedule line number in purchasing document
BELNR	Number of the material document used to post the goods movement
GMVPDT	Posting date of goods movement
SCLQTY	Schedule line quantity (quantity delivered by a vendor with regard to a schedule line)
GMVQTY	Quantity of a goods movement posted with respect to a schedule line
OPNQTY	Difference between the schedule line quantity (SCLQTY) and the total quantity (TTLQTY)
TTLQTY	Total quantity of goods movements posted for a schedule line

Example

Purchasing document 4500000001, Item 0010, has the following schedule lines:

Schedule line number (SCLNR) = 1

Delivery date (SCLDT)= 01.01.04

Delivery time (SCLTM) = 12:00:00

Quantity ordered(SCLQTY) = 20

A goods movement is posted with the following information:

Posting date (BUDAT) = 05.01.04

Document number of goods receipt (BELNR) = 5000000001

Item in document (BUZEI) = 1

Goods receipt quantity (MENGE) = 6

The DataSource results as follows:

ROCANCEL	'blank'
BWVORG	01
EBELN	4500000001
EBELP	0010
SCLDT	01.01.2004
SCLTM	12:00:00
SCLNR	1
GMVPDT	05.01.2004
BELNR	5000000001
BUZEI	0001
SCLQTY	15
GMVQTY	6
OPNQTY	9 => SCLQTY – TTLQTY => 15 -6
TTLQTY	6
MEINS	Base unit of measure of order

Data Review in SAP R/3

In the Purchasing component of SAP R/ 3 , you can use the General Reports transaction (transaction code ME80FN) to select, aggregate, and summarize information about purchasing activities. You can assemble the information that is to be reported according to selection criteria such as material, purchasing document, vendor, plant, and purchasing organization.

To assign the information in the list of issued purchasing documents clearly according to your wishes, you can use functions such as Sort, Filter, Aggregate Across Various Fields, Add Totals and Subtotals. You can also display the detail data for a purchasing document, a vendor, or a material.

Changing the View

If you select Change View , you can choose between the following views to display the output list:

Header/Item Data (data from the tables EKKO and EKPO)
Delivery Schedule Lines (data from the table EKET)
Purchase Order History (data from the table EKBE)

Setting the Layout

If you select Choose Layout , you have access to all the SAP List Viewers functions. In other words, you can change the existing layout (such as add or hide fields and columns, change the sort sequence, add subtotals, set filters), save the changed layout, and choose a different layout.

Comparing DataSource 2LIS_02_SGR to ME80FN

If you choose the Delivery Schedule Lines view in the transaction ME80FN, you can compare the data in the DataSource fields with the original document data in SAP R/3 , such as:

Purchasing Document Number (EBELN)
Item Number of Purchasing Document (EBELP)
Delivery Date (EINDT)
Schedule Line Quantity (SCLQTY)

You can check the information about the goods receipt in the Purchase Order History view.