Allocation - Confirmation with Goods Receipt 

Technical name: 2LIS_02_CGR

Technical Data

Type of DataSource	Transaction Data (Movement Data)
Application Component	Materials Management (MM)
Available as of OLTP Release	SAP R/3 4.5B
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 confirmation 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	EKBE	EBELN
EBELP	Item Number of Purchasing Document	EKBE	EBELP
CNFDT	Purchase Order Confirmation Delivery Date	EKES	EINDT
CNFTM	Purchase Order Confirmation Delivery Date Time	EKES	UZEIT
CNFNR	Sequence Number Purchase Order Confirmation	EKES	ETENS
GMVPDT	Posting date in the document	EKBE	BUDAT
BELNR	Number of Material Document	EKBE	BELNR
BUZEI	Item in Material Document	EKBE	BUZEI
CNFTYP	Confirmation Category	EKES	EBTYP
CNFQTY	Confirmed quantity	EKES	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 distribution of goods receipt quantities to the confirmation quantities.

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.

This DataSource only considers confirmations which have the goods-receipt-relevant indicator set. In Customizing for purchasing, you can set a confirmation category as goods-receipt-relevant in the Confirmation Control.

The information is only available in this DataSource when a goods receipt has been posted with respect to an order and the purchasing document already has a GR-relevant confirmation.

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 confirmations in the table EKES (Order Confirmations).

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 order confirmations, see the SAP Library under Materials Management ® Purchasing ® Confirmations.

Important Key Figures

GMVPDT	Posting date in the document
BELNR	Number of the material document used to post the goods movement
CNFTYP	Confirmation category (shipping notification, inbound delivery, and so on)
CNFQTY	Confirmed quantity
GMVQTY	Quantity of goods movements assigned to a confirmation
OPNQTY	Difference between the confirmation quantity (CNFQTY) and the total goods movement quantity (TTLQTY)
TTLQTY	Total quantity of goods movements posted for a confirmation

Example

Purchasing document 4500000001, Item 0010, has the following confirmation:

Confirmation category (EBTYP) = SN – Shipping Notification

Confirmation date (EINDT)  = 01.01.04

Confirmation time (UZEIT) = 12:00:00

Confirmed quantity = 10

A goods receipt was then posted with the following data:

Posting date (BUDAT) = 05.01.04

Document number of goods receipt (BELNR) = 5000000001

Item in goods receipt document (BUZEI) = 1

Goods receipt quantity (MENGE) = 6

The DataSource results as follows:

ROCANCEL	'blank'
BWVORG	05
EBELN	4500000001
EBELP	0010
CNFDT	01.01.2004
CNFTM	12:00:00
CNFNR	001
GMVPDT	05.01.2004
BELNR	5000000001
BUZEI	0001
CNFTYP	SN
CNFQTY	10
GMVQTY	6
OPNQTY	4 => CNFQTY – GMVQTY => 10 - 6
TTLQTY	6
MEINS	Base unit of measure of order

Note:

For the system to take this confirmation into account, the goods-receipt-relevant indicator must be set in Customizing for Purchasing.

Data Review in SAP R/3

In the Purchasing component of the SAP R/3 system, you can use the General Reportstransaction (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 Viewersfunctions. 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_CGR to ME80FN

In the transaction ME80FN, you will find information about goods receipt in the Purchase Order History view. There, 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)

·        Goods Receipt Document Number (BELNR)

·        Goods Receipt Quantity (MENGE)

You can gather the confirmation information from the item data in the purchasing documents.