Allocation - Schedule Line with Goods Receipt Technical name: 2LIS_02_SGR
Type of DataSource |
Transaction Data (Movement Data) |
|---|---|
Application Component |
|
Available as of OLTP Release |
|
Available as of Plug-In Release |
PI 2002.1 |
RemoteCube Compatibility |
No |
Activation of the DataSource.
This DataSource is used to extract the schedule line quantities allocated with goods receipt quantities consistently to a BW system.
A delta update is supported. Delta process: ABR – Complete delta update with deletion indicator using delta queue (Cube-compatible).
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 |
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
.
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 |
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 |
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.
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)
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.
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.