Entering content frame

Dummy text Purchasing Data (Schedule Line Level) Locate the document in its SAP Library structure

Technical name: 2LIS_02_SCL

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 2000.1

RemoteCube Compatibility

No

Prerequisites

Activation of the DataSource.

Use

The DataSource is used to extract the basic data for analyses of purchasing documents 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

BEDAT

Date of Purchasing Document

EKKO

BEDAT

BSART

Purchasing Document Type

EKKO

BSART

BSTYP

Purchasing Document Category

EKKO

BSTYP

BUDAT

Posting Date of Goods Receipt or Invoice Receipt for the Purchase Order

EKKO / EKBE

BUDAT

EBELN

Document Number of Purchasing Document

EKKO

EBELN

EKGRP

Purchasing Group

EKKO

EKGRP

EKORG

Purchasing Organization

EKKO

EKORG

HWAER

Local Currency

T001

WAERS

KDATB

Start of Validity Period

EKKO

KDATB

KDATE

End of Validity Period

EKKO

KDATE

LBLIF

Field is not used

EKKO

 

LIFNR

Vendor’s Account Number

EKKO / T001W

LIFNR

LIFRE

Different Invoicing Party

EKKO

LIFRE

LLIEF

Supplying Vendor

EKKO

LLIEF

LOGSY

Logical System

EKKO

LOGSY

ORGLOGSY

Logical System

 

 

RESWK

Issuing Plant for Stock Transport Order

EKKO

RESWK

STATU

Status of Purchasing Document

EKKO

STATU

SYDAT

Purchasing Document Entry Date

EKKO / EKBE

BEDAT

WAERS

PO Currency

EKKO

WAERS

WKURS

Exchange Rate

EKKO

WKURS

AFNAM

Name of Requester

EKPO

AFNAM

AKTNR

Action

EKPO

AKTNR

BSGRU

Reason for Order

EKPO

BSGRU

BWAPPLNM

Application Component

TMCLVBW

APPLNM

BWVORG

SAP BW - Transaction Key

hard-coded

 

EBELP

Item Number of Purchasing Document

EKPO

EBELP

ELIKZ

”Final Delivery Completed” Indicator

EKPO

ELIKZ

EMATN

Material Number

EKPO

EMATN

EREKZ

Final Invoice Indicator

EKPO

EREKZ

KONNR

Number of Principal Agreement

EKPO

KONNR

KTPNR

Item Number of Principal Agreement

EKPO

KTPNR

LGORT

Storage Location

EKPO

LGORT

LMEIN

Base Unit of Measure

EKPO

LMEIN

MATKL

Material Group

EKPO

MATKL

MATNR

Material Number

EKPO

MATNR

MEINS

Order Unit

EKPO

MEINS

NETPR

Net Price

calculated

 

PEINH

Price Unit

EKPO

PEINH

PSTYP

Item Category in Purchasing Document

EKPO

PSTYP

TXZ01

Short Text

EKPO

TXZ01

UMREN

Denominator for Converting PO UoM into Base UoM.

EKPO

UMREN

UMREZ

Counter for Converting PO UoM into Base UoM.

EKPO

UMREZ

WEBRE

GR-Based Invoice Verification Indicator

EKPO

WEBRE

WERKS

Plant

EKPO

WERKS

XERSY

Evaluated Receipt Settlement (ERS)

EKPO

XERSY

BANFN

Purchase Requisition Number

EKET

BANFN

BNFPO

Item Number of Purchase Requisition

EKET

BNFPO

BWBRTWR

Gross Purchase Order Value in Order Currency

calculated

 

BWEFFWR

Effective Order Value

calculated

 

BWGEO

BW: Purchase Value in Local Currency

calculated

 

BWGEOO

BW: Purchase Value in Order Currency

calculated

 

BWGVO

BW: Sales Value in Local Currency

calculated

 

BWGVP

BW: Retail Value with Tax in Local Currency.

calculated

 

BWKZWI1

Condition Subtotal 1 from Calculation Schema

calculated

 

BWKZWI2

Condition Subtotal 2 from Calculation Schema

calculated

 

BWKZWI3

Condition Subtotal 3 from Calculation Schema

calculated

 

BWKZWI4

Condition Subtotal 4 from Calculation Schema

calculated

 

BWKZWI5

Condition Subtotal 5 from Calculation Schema

calculated

 

BWKZWI6

Condition Subtotal 6 from Calculation Schema

calculated

 

BWMNG

BW: Quantity in Order Unit

calculated

 

BZGWR

Planned Delivery Costs for Purchase Order from Invoice in Local Currency

calculated

 

CHARG

Batch Number

EKET

CHARG

DBWGEO

Delta PO/GR SP

calculated

 

DBWMNG

Delta PO/GR in Base UoM

calculated

 

EINDT

Item Delivery Date

EKET

EINDT

ETENR

Schedule Line Counter

EKET

ETENR

MAHNZ

Number of Reminders/Expediters

EKET

MAHNZ

SLFDT

Delivery Date Relevant for Statistics

EKET

SLFDT

UZEIT

Time of Day

EKET

UZEIT

PERIV

Fiscal Year Variant

T001

 

SCL_BEDAT

Schedule Line Date

EKET

BEDAT

NOSCL

Counter for Scheduling Agreement Schedule Lines

hard-coded

 

PWLIF

Goods Supplier

EKPA

LIFNZ

PREST

Invoicing Party

EKPA

LIFNZ

PLIWK

Supplying Plant to Which Partner Roles Have Been Assigned

EKPA

LIFNZ

PLIEF

Vendor to Whom Partner Roles Have Been Assigned

EKPA

LIFNZ

PBEST

Ordering Address

EKPA

LIFNZ

ROCANCEL

Cancellation of Data Record

hard-coded

 

Features of Extractor

This DataSource provides information about:

        the header data of a purchasing document, such as vendor, purchasing organization, order currency, and so on

        the item data such as material, purchase order quantity, order unit, net price, and so on

        the purchasing document delivery schedule lines, such as schedule line number, delivery date, schedule line quantity, value of schedule line quantity, and so on

The DataSource also provides information about the documents that are posted with regard to the purchase order, such as goods receipts and invoices. In addition, the DataSource provides information about how these documents are assigned to the schedule lines.

The assignment of purchase order history information and schedule lines is not stored in a database table. As a result, this information is only created during the posting of the documents or during initialization of the DataSource.

In the SAP R/3 system, this information is contained in the following tables:

        Header data in the table EKKO (Purchasing Document Header)

        Item data in the table EKPO (Purchasing Document Item)

        Schedule lines in the table EKET (Scheduling Agreement Delivery Schedule Lines)

        Purchase order history in the table EKBE (History of Purchasing Document)

For more information about purchasing documents, see the SAP Library under Materials Management Purchasing.

Important Key Figures

BWVORG - Transaction Key SAP BW

This field identifies the event that is based on the information in the DataSource. The contents of this field determines the importance and the behavior of other fields in the DataSource. The field ALIEF (Number of Deliveries) is, for example, only filled if the event is a goods receipt.

For more information, see SAP Note 684465: BWVORG for Purchasing Data Sources.

ROCANCEL – Cancellation of Data Record

This field can contain the following values:

        ‘blank‘ – New data record

        ‘X’ – Cancellation of data record

        ‘R’ – Deletion of data record

For more information, see SAP Note 578471: Deleted Items in BW and Statistics

BUDAT – Posting Date

If the information in this field relates to an event in the purchase order, the field is filled with the posting date of the purchase order. If the information relates to a goods receipt or an invoice, the field is filled with the posting date of the corresponding document.

NETPR – Net Price

The system always converts the net price to the local currency and to the base unit of measure.

For more information, see SAP Note 670313: BW: Field NETPR for DataSource 2LIS_02_ITM and 2LIS_02_SCL.

WKURS – Exchange Rate

For purchasing documents that were created in a currency other than the local currency, or to which documents such as invoices were posted in a different currency; The contents of this field specifies the conversion factor with which you can convert the foreign currency to the local currency.

BWEFFWR – Effective Purchase Order Value

The calculation is based on the item information and schedule line information.

For documents with purchase order quantity, the following applies:

bweffwr = ekpo-effwr / ekpo-menge * eket-menge

bweffwr = Effective Price / Item Quantity * Schedule Line Quantity

For documents with target quantity, the following applies:

bweffwr = ekpo-effwr / ekpo-menge * eket-menge

bweffwr = Effective Price / Item Target Quantity * Schedule Line Quantity

BWGEO - Purchase Value in Local Currency

The value contained in this field depends on the information stored in the field BWVORG (BW Transaction Key).

The field determines if the value is derived from a purchase order, a goods receipt, or an invoice. This means, for example, that the values for the goods receipt are available when the contents of the BWVORG field are based on a goods receipt process and not on a purchase order or invoice.

For purchase orders, the following applies:

bwgeo = bwgeoo converted using WKURS

For goods receipts, the following applies:

bwgeo = Goods Receipt Value

For invoices, the following applies:

bwgeo = Assigned Invoice Quantity * Invoice Value / Total Invoice Value

bwgeo = eket-menge * ekbe-dmbtr / ekbe-menge

BWGEOO – Purchase Value in Order Currency

The value contained in this field depends on the information stored in the field BWVORG (BW Transaction Key).

The conversion of values in this field is always based on the exchange rate (WKURS) in the purchase order.

For purchase orders, the following applies:

bwgeoo = eket-menge * ekpo-effwr / ekpo-menge.

bwgeoo = Schedule Line Quantity * Effective Price / Item Quantity

For goods receipts, the following applies:

bwgeoo = bwgeo converted using WKURS

For invoices, the following applies:

bwgeoo = bwgeo converted using WKURS

BWMNG – Quantity in Order Unit

The information in this field also depends on BWVORG, since it determines whether the quantity specified is based on the purchase order, goods receipt, or invoice.

DBWGEO - Delta for Purchase Order/Goods Receipt at Cost Price (EP)

The information in this field indicates the difference between the purchase order value and the goods receipt value. The system only calculates this delta if a purchase order item is completed. This is the case, if:

        The item was completely delivered

        The Delivery completed indicator (ELIKZ) has been set

        The item has been deleted

The information is only available if one of these conditions is met for a purchase order item.

Since the DBWGEO field displays the difference between purchase order and goods receipt, this field is also dependent on the BWVORG field.The delta information is not available for invoices, but only for purchase order and goods receipt processes.

DBWMNG - Delta for Purchase Order Quantity/Goods Receipt Quantity in Base Unit of Measure

The information in this field indicates the difference between the purchase order quantity and the goods receipt quantity in the base unit of measure. The system only calculates this delta if a purchase order item is completed. This is the case, if:

        The item was completely delivered

        The Delivery completed indicator (ELIKZ) has been set

        The item has been deleted

The information is only available if one of these conditions is met for a purchase order item.

Since the DBWMNG field displays the difference between purchase order and goods receipt, this field is also dependent on the BWVORG field.The delta information is not available for invoices, but only for purchase order and goods receipt processes.

Data Review in SAP R/3

In the Purchasing component of SAP R/3, 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)

You can check the data from the DataSource 2LIS_02_SCL in last two views mentioned.

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_SCL to ME80FN

If you choose the Header/Item Data view in the transaction ME80FN, you can compare the data in the following DataSource fields with the original document data in SAP R/3:

        Document Date (BEDAT)

        Purchasing Document Type (BSART)

        Purchasing Document Number (EBELN)

        Purchasing Group (EKGRP)

        Purchasing Organization (EKORG)

        Vendor’s Account Number (LIFNR)

        Item Number of Purchasing Document (EBELP)

        Material Number (MATNR)

        Material Group (MATKL)

        Plant (WERKS)

        Storage Location (LGORT)

        Order Unit (MEINS)

If you choose the Scheduling Agreement Delivery Schedule Lineview in the transaction ME80FN, you can compare the data in the following DataSource fields with the original document data in SAP R/3:

        Item Delivery Date (EINDT)

        Quantity in Order Unit (BWMNG, if BWVORG=1)

        Schedule Line Date (SCL_BEDAT)

If you select the Purchase Order History view in the transaction ME80FN, you can check the information of documents that were posted with regard to a purchasing document, such as goods receipt documents, invoices, subsequent debits, and credit memos.

 

Leaving content frame