2LIS_02_SCL

Purchasing Data (Schedule Line Level) | #TRAN | Extraction method: F1 | Delta: ABR | Component: Materials Management

Tables used: EKPO, EKKO, WBRP, LIPS, VBAP ... +188 more

🔑 Keys (10)
💰 Amounts (15)
∑ Quantities (2)
📅 Dates (9)
☰ Categorical (8)
Other (21)
🔗 Relations (26)

Column Name	Description
EBELN FK	Purchasing Document Number
EKGRP FK	Purchasing Group
EKORG FK	Purchasing organization
LIFNR FK	Vendor's account number
STATU	Status of Purchasing Document	Show values
EBELP FK	Item Number of Purchasing Document
MATNR FK	Material Number
WERKS FK	Plant
ETENR	Delivery Schedule Line Counter
UZEIT	Time

Column Name	Description
💲 Purchase order currency (WAERS):
NETPR	Net Price
BWBRTWR	Gross order value in order currency
BWEFFWR	Effective order value
BWGEOO	BW: Cost Value in Order Currency
BWKZWI1	Subtotal 1 from Pricing Procedure for Price Element
BWKZWI2	Subtotal 2 from Pricing Procedure for Price Element
BWKZWI3	Subtotal 3 from Pricing Procedure for Price Element
BWKZWI4	Subtotal 4 from Pricing Procedure for Price Element
BWKZWI5	Subtotal 5 from Pricing Procedure for Price Element
BWKZWI6	Subtotal 6 from Pricing Procedure for Price Element
DBWGEO	Delta purchase order/goods receipt at cost
💲 Local Currency (HWAER):
BWGEO	BW: Cost Value in Local Currency
BWGVO	BW: Retail Value in Local Currency
BWGVP	BW: Retail Value with Tax in Local Currency
BZGWR	Delivery costs for order from invoice in LC

Column Name	Description
📏 Purchase Order Unit of Measure (MEINS):
BWMNG	BW: Quantity in Order Unit
DBWMNG	Delta purchase order/goods receipt quantity in BUn

Column Name	Description
BEDAT	Purchasing Document Date
BUDAT	Posting date of goods received or invoice receipt for order
KDATB	Start of Validity Period
KDATE	End of Validity Period
SYDAT	Date on which the purchasing document was entered
EINDT	Item delivery date
SLFDT	Statistics-Relevant Delivery Date
UZEIT	Time
SCL_BEDAT	Schedule line date

Column Name	Description
ROCANCEL	Indicator: Cancel Data Record	Show values
BSTYP	Purchasing Document Category	Show values
STATU	Status of Purchasing Document	Show values
ELIKZ	"Delivery Completed" Indicator	Show values
EREKZ	Final Invoice Indicator	Show values
WEBRE	Indicator: GR-Based Invoice Verification	Show values
WEPOS	Goods Receipt Indicator	Show values
XERSY	Evaluated Receipt Settlement (ERS)	Show values

Column Name	Description	Domain name
LOGSY	Logical System	LOGSYS
ORGLOGSY	Logical System	LOGSYS
WKURS	Exchange Rate	KURSP
AFNAM	Name of requisitioner/requester	AFNAM
BWAPPLNM	Application Component	RSAPPLNM
BWVORG	SAP BW transaction key	NUM3
PEINH	Price unit	PACK3
TXZ01	Short Text	TEXT40
UMREN	Denominator for Conversion of Order Unit to Base Unit	UMBSN
UMREZ	Numerator for Conversion of Order Unit to Base Unit	UMBSZ
BANFN	Purchase Requisition Number	BANFN
CHARG	Batch Number	CHARG
MAHNZ	Number of Reminders/Expediters	PACK2
PERIV	Fiscal Year Variant	PERIV
NOSCL	Counter for Schedule Agreement Schedule Lines	PL2
PWLIF	Goods supplier	LIFNR
PREST	Invoicing party	LIFNR
PLIWK	Supplying plant to which partner roles have been assigned	LIFNR
PLIEF	Supplier to whom Partner Roles have been Assigned	LIFNR
PBEST	Ordering address	LIFNR
ITMUSE	Usage of Higher Level Item

Master Data Relations	Join Conditions
Promotion Client Promotion	`2LIS_02_SCL.MANDT == WAKH.MANDT` `2LIS_02_SCL.AKTNR == WAKH.AKTNR`
Purchasing Document Type ? Client Purchasing Document Type	`2LIS_02_SCL.[column in domain "BSTYP"] == T161.BSTYP` `2LIS_02_SCL.MANDT == T161.MANDT` `2LIS_02_SCL.BSART == T161.BSART`
Reason for Ordering Client Reason for Ordering	`2LIS_02_SCL.MANDT == TBSG.MANDT` `2LIS_02_SCL.BSGRU == TBSG.BSGRU`
Purchasing Group Client Purchasing Group	`2LIS_02_SCL.MANDT == T024.MANDT` `2LIS_02_SCL.EKGRP == T024.EKGRP`
Purchasing organization Client Purchasing organization	`2LIS_02_SCL.MANDT == T024E.MANDT` `2LIS_02_SCL.EKORG == T024E.EKORG`
Material number Client Material number	`2LIS_02_SCL.MANDT == MARA.MANDT` `2LIS_02_SCL.EMATN == MARA.MATNR`
Field not used Client Field not used	`2LIS_02_SCL.MANDT == LFA1.MANDT` `2LIS_02_SCL.LBLIF == LFA1.LIFNR`
Storage location Client Storage location Plant	`2LIS_02_SCL.MANDT == T001L.MANDT` `2LIS_02_SCL.LGORT == T001L.LGORT` `2LIS_02_SCL.WERKS == T001L.WERKS`
Vendor's account number Client Vendor's account number	`2LIS_02_SCL.MANDT == LFA1.MANDT` `2LIS_02_SCL.LIFNR == LFA1.LIFNR`
Different Invoicing Party Client Different Invoicing Party	`2LIS_02_SCL.MANDT == LFA1.MANDT` `2LIS_02_SCL.LIFRE == LFA1.LIFNR`
Goods Supplier Client Goods Supplier	`2LIS_02_SCL.MANDT == LFA1.MANDT` `2LIS_02_SCL.LLIEF == LFA1.LIFNR`
Base Unit of Measure Client Base Unit of Measure	`2LIS_02_SCL.MANDT == T006.MANDT` `2LIS_02_SCL.LMEIN == T006.MSEHI`
Material Group Client Material Group	`2LIS_02_SCL.MANDT == T023.MANDT` `2LIS_02_SCL.MATKL == T023.MATKL`
Material Number Client Material Number	`2LIS_02_SCL.MANDT == MARA.MANDT` `2LIS_02_SCL.MATNR == MARA.MATNR`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`2LIS_02_SCL.MANDT == T006.MANDT` `2LIS_02_SCL.MEINS == T006.MSEHI`
Item category in purchasing document Client Item category in purchasing document	`2LIS_02_SCL.MANDT == T163.MANDT` `2LIS_02_SCL.PSTYP == T163.PSTYP`
Issuing Storage Location for Stock Transport Order Client ? Issuing Storage Location for Stock Transport Order	`2LIS_02_SCL.MANDT == T001L.MANDT` `2LIS_02_SCL.[column in domain "WERKS_D"] == T001L.WERKS` `2LIS_02_SCL.RESLO == T001L.LGORT`
Supplying (issuing) plant in case of stock transport order Client Supplying (issuing) plant in case of stock transport order	`2LIS_02_SCL.MANDT == T001W.MANDT` `2LIS_02_SCL.RESWK == T001W.WERKS`
Customer Number Client Customer Number	`2LIS_02_SCL.MANDT == KNA1.MANDT` `2LIS_02_SCL.SHIPTO == KNA1.KUNNR`
Plant Client Plant	`2LIS_02_SCL.MANDT == T001W.MANDT` `2LIS_02_SCL.WERKS == T001W.WERKS`